STEWART A. BERMAN
sab@saberman.com
www.saberman.com
Desktop / Client Software Developer
A developer and proven problem solver with extensive experience
in creating and fixing desktop systems and tools. Solid background in
understanding user needs, rapidly translating them into software solutions and
providing user training. Excellent communicator who is
effective in supporting both senior management and junior level staff.
Technologies
Ø
Expert:
MS Access/VBA, Visual Basic, Office Automation (Excel/VBA, Outlook/VBA)
Ø
Worked
with: VB.NET, SQL Server, Sybase and Oracle
Industry – Investment Banking
Ø
Risk
Management (Value at Risk, Data Mining) Software Development and Support
Ø
Front
Office Equity and Fixed Income Trading and Sales Software Development and
Support
Systems and Tools
- Developed an
interface to Outlook to automate setting up and classifying contacts in CareBinders – a retail personal record keeping system
in Access 2007. Implemented Sagekey’s registration system in the product and
developed an automated method for “hardening” the product as part of the
release process.
- Developed
testing tools to automate the validation of Oracle vs. MS Access to
support the migration of MS Access applications to Oracle. The tools include dynamic generation of
SQL to compare tables based on an analysis of their primary keys and field
types.
- Developed MS
Access based system to import and clean MarkIt Data spreads to
produce historical time series.
- Developed system
for calculating and reporting on value at risk for fixed income and equity
proprietary trading.
- Improved
productivity (2-3 FTE reduction)
- Improved
delivery (4 hours earlier)
- Improved
controls and increased transparency in risk analysis
- 40 users in NY,
London and Singapore.
- Extracted
data from Credit Derivatives spreadsheets and Sybase databases
- Calculated
and reported on risk factors using market shocks, correlated risk and
historical simulation
- Integrated
the use of Microsoft Outlook and Excel through VBA code.
- Developed a tool
to decompose Microsoft Access databases into text files representing all
of the internal objects including references and options and automated the
interface to a source control system (ClearCase). The tool also built Microsoft Access
databases from the text files.
- Developed an
interface between a proprietary custody system and Portia using MS
Access.
- Developed a market
neutral basket tracking system in MS Excel that priced and plotted the
market value of the baskets and indicated entry and exit points.
- Developed a
real-time P & L tracking system.
Developed an interface between VB and Reuters Pricing. Built and maintained SQL Servers used in
system.
- Developed a
system that monitors communications lines, analyzes messages, updates
information in a database and displays caller history for call center
operators.
Product Development
SAB Diskette Utility. Designed, developed, and marketed a product
to provide copying, comparing, formatting, verifying and bulk writing of
diskettes. The product had over 2,000 licensed users. Portions of the product
were licensed to Tool Technology for inclusion in WinTools. The entire product
was licensed to AST and to Epson America and installed on all of their
microcomputers shipped within the United States.
Professional History
- CareBinders – 2009 –
Present. Contractor.
- Credit Suisse
First Boston - 2005 – 2008. Employee.
- Credit Suisse First Boston - 1999
– 2005. Contractor.
- Deutsche Private Bank - 1998 –
1999. Contractor.
- Bankers Trust - 1995 – 1998.
Contractor.
- Executone
Information Systems – 1994. Consultant.
Early Career History
Prior to 1994, held various programming and managerial
positions with different levels of responsibilities as a Vice President at
CitiBank and as a Partner in Coopers & Lybrand.
Education
Master of Business
Administration
(Professional Accounting), Fordham University
Master
of Engineering
(Electrical), The City College of New York
Bachelor of
Engineering
(Electrical), The City College of New York