Lead Application Developer, Structured Finance Resume
New York, NY
SUMMARY:
- Proven record of accomplishing more than set goals, learning new technology, assuming many roles, and supporting others.
- Well - versed in software development life cycle and agile processes, databases, object-oriented design, data structures, algorithms and design patterns.
- Particularly sensitive to user interface: easy-to-use GUI's, friendly user support and well-written documentation.
- Ivy-League Computer Science degree: SAT's 650V / 720M, dean's list. Learned C in 1979 at Yale (GPA 3.5), C++ in 1986 at Columbia (3.8).
- Authored and maintain vital Excel and Access modeling and forecasting applications used in reports presented to a top rating agency’s international committees.
- Upgraded InstallShield packages for the rating agency’s published software: Windows best practices, digital signatures, logos and colors, etc.
- Streamlined, standardized and updated many vital C++ applications and software development processes for major international bank.
- Devised entire company network administration system, including authoring C++ utilities, to determine workstation software update status (e.g., anti-virus), hardware and network configuration, document and Email storage capacity, Active Directory and Exchange configuration, etc.
- Authored C++ charting package with statistical calculations for drawing charts in PDF-format reports of published hospital-survey results.
TECHNICAL SKILLS:
Languages: VBA (Excel, Access, Word), SQL, PL / SQL, DDL / DML, C / C++ / VC++, HTML, xBase, DOS batch, UNIX shell, AWK, VAX DCL, Pascal, APL
Source control: CVS, PVCS, Visual SourceSafe
Databases: Oracle, Access, SQL Server, DB2, ODBC, FoxPro / Clipper / dBASE
Software: MS Office (Word, Excel, PowerPoint, Access, Scheduler / Outlook), MS Project, MS Visio, MS FrontPage, SQL Navigator, Toad
Graphics: MS Publisher, Adobe Creative Suite (Acrobat, InDesign, GoLive, Photoshop, Illustrator), PageMaker
Hardware/OS: IBM PC, Macintosh, HP / 3000, VAX, Windows, DOS, UNIX, Novell, VAX / VMS
Servers: Windows 2000-2003, Active Directory, Exchange / MailSweeper, Symantec AntiVirus, Barracuda Spam Firewall
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Lead application developer, Structured Finance
- Author, maintain, document and support both external and in-house financial ratings applications, e.g.:
- Surveillance Automation System / US and EMEA: Investor and ratings reporting system which extracts via ETL and PL / SQL Oracle financial data from monthly credit and cash-flow model runs of ABS, CDO, etc., deals and displays cash-flow and exception reports to the Ratings Committee.
- CDS Accelerator: Excel-based system which performs in-depth analysis of synthetic CDOs, incorporating Monte Carlo simulation, dynamic updates of analysis parameters, scenario analysis, substitution modeling, and SLR / SROC analysis to evaluate the credit quality of CDO assets.
- Hedge Fund Evaluator: Excel-based tool with Visual C++ DLLs to streamline the process of structuring CFO deals involving hedge-fund portfolios, evaluating transaction risk, and bringing S&P's securitization modeling criteria to the analysis.
- Author and maintain InstallShield packages for S&P products: Hedge Fund Evaluator, CDO Evaluator, S&P Interest Rate Evaluator, etc.
- Track purchase, licensing and installation of third-party software (Visual Studio, IntallShield, etc.) and company-wide VeriSign digital signatures.
Confidential, New York, NY
Lead database developer / programme
- Develop, enhance and maintain databases for tracking diagnoses, interventions, laboratory tests and treatment referrals for homeless and indigent people in all five boroughs of New York City, and reporting them to the Federal government.
Confidential, South Bend, IN
Lead programmer
- Led Visual C++ / STL / DB2 / SQL development team to publish on the Internet complex statistical analyses of hospital survey data producing Pulse Reports on the quality of American health care as evaluated by patients, employees, and physicians.
- Authored main C++ data-charting package to easily produce custom pie and bar charts on these reports.
Confidential, New York, NY
Programmer / analyst
- Converted to C++, maintained, documented and supported main financial applications for back office, lending, trading, accounting, treasury, commercial services, and other departments in the New York and Toronto branches, e.g.:
- Security Portfolio: Middle / Back office database application for $25 billion New York branch portfolio of CDO's, CMO's, ABS's and other fixed-income instruments. Included pricing formulas, import capability from multiple data sources (Midas / AS400, Excel etc.) via SQL and BDE / ODBC, interactive query builder, and sophisticated calculation and reporting functions.
- Operations Result: Profit / loss application to maintain calculation formulas and provide balance sheet and income reports to Head Office monthly; multiple data sources with diverse reporting and import / export capabilities.
- Credit Approvals: Real-time trading application requiring Risk Office approvals before booking trades. Involved data transfer, security and workflow control across multiple departments e.g. Risk Office, Asset Securitization (SPVs), Limit Control and Trading, and Commercial Services.
- Authored in VBA / Excel, VBA / Access, SQL / ODBC and Crystal Reports other financial applications, e.g.:
- Daily Rates: automatically retrieved data from Reuters / Bloomberg feeds every day, tabulated and charted them for different bank groups and the company intranet, allowed data entry and manual override by back-office personnel of T-bills, prime rate, etc.
- Portfolio matrix: Statistical analytics on securities portfolio with reporting capability.
- Streamlined all C++ development by adding significantly to global library of company-standard library routines:
- Financial and mathematical calculations - market prices, interest rates, hidden reserves, etc.
- Database access and manipulation utilities, e.g., streamlined indexed search, improved database synchronization, SQL / ODBC interfaces, batch data processing, transaction handling, etc.
- Implementations of FoxPro functions and commands - for ease of conversion into C++
- Paradigms for seamless portability of applications among branches with different databases and infrastructure
Confidential, New York, NY
Programmer / analyst
- Authored essential reports, e.g., weeks of supply, sales comparisons, buy sheets, etc., in VBA / Excel and VBA / Access.
- Maintained data warehouse and other large Access and SQL Server databases for Web, catalog and outlet sales.
Confidential, New York, NY
CTO / CIO
- Networked, configured and administered all computers on Novell 3 / Windows 3.1 and peer-to-peer Windows 95 networks.
- Created and maintained general member database in VBA / Access, including grievances, dues and other financial information. The database played a crucial role in determining members' eligibility to vote in the 1999 presidential election.
- Printed union cards and many ad-hoc reports using Word mail-merge and / or Excel analysis on the Access database.
- Designed, laid out and published their newsletter, Local 1S News, in Aldus PageMaker on a monthly basis.
Confidential
Project manager / Lead programmer
- Converted, co-wrote and maintained VBA / Word print engine for proposal-tracking and -printing system.
- Implemented virus tracking, detection and removal into the proposal system when Guardian was infected by a Word virus.