Access/VBA

STEWART A. BERMAN

ad6qnq@r.postjobfree.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 Six, Office Automation (Excel/VBA, Outlook/VBA)

Worked with: SQL Server, Sybase and Oracle

Industry – Investment Banking

Risk Management (Value at Risk, Data Mining) Software Development and Support

Equity and Fixed Income Trading and Sales Software Development and Support Industry – Personal Financial Planning (Consumer Software)

Microsoft Office (Interfaces, Security) Software Development and Support Systems and Tools

Provided production support for Strategic Risk Management systems

Developed tools to analyze Excel 2003 workbooks and Access 2003 databases for add- ins and references as part of an XP/Office 2003 to Windows 7/Office 2010 conversion.

Developed requirements for Risk Based P&L generation and analysis

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.

o Improved productivity (2-3 FTE reduction)

o Improved delivery (4 hours earlier)

o Improved controls and increased transparency in risk analysis o 40 users in NY, London and Singapore.

o Extracted data from Credit Derivatives spreadsheets and Sybase databases o Integrated the use of Microsoft Outlook and Excel through VBA code. o Calculated and reported on risk factors using market shocks, correlated risk and historical simulation

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 VB6 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. MS Access Based Utilities and Products. Designed, developed, marketed and supported a number of MS Access based utilities and products. See: www.saberman.com Professional History

Saberman, Inc. – 2001 – Present. Software Development, Sales and Support

CareBbinders – 2021-- 2021. Consultant

CareBinders - 2009 – 2017. Consultant

Credit Suisse First Boston - 2010 – 2013. Contractor.

Credit Suisse First Boston - 2005 – 2008. Director.

Credit Suisse First Boston - 1999 – 2005. Contractor.

Deutsche Private Bank - 1998 – 1999. Contractor.

Bankers Trust - 1995 – 1998. Contractor.

Executone Information Systems – 1994. Consultant. 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 Location: Remote Only

Contact this candidate