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
STEWART A. BERMAN / PAGE 2 OF 2