Accomplished Global Software Programmer & Database Developer

J. ANDREW SMITH 862-***-**** - *********@*****.*** - https://www.linkedin.com/in/jandrewsmith - Bloomfield, NJ

Senior Database Developer / Analyst & Software Programmer

Ivy-League software engineering leader with substantive background in software and database analysis, development, and execution in competitive markets. Excel at creating tools/solutions and leading efforts to improve testing capacity, increase efficiency, significantly simplify processes, and contribute to enhancing product performance and features. Expert in software development life cycle, agile processes, databases, object-oriented design, data structures, algorithms, and design patterns. Leverage experience in a wide variety of programming languages and tools as well as user-friendly Graphical User Interfaces (GUIs). Proven track record of exceeding goals; communication skills across many platforms; working with cross-functional teams; and motivating co-workers to perform at highest levels.

Core strengths include: Accelerated Learning Curve with New Technologies - Training/Mentoring - API/GUI Test Automation - Spreadsheet and Database Analysis - Application Development - Visualization Tools - System Integration - Technical/User Support - Report Generation - Dashboard Tools - Documentation - Detecting and Resolving Bugs - Modeling & Forecasting - Authoring and Reuse of Code - Version Control

OVERVIEW OF SIGNIFICANT CONTRIBUTIONS

> Reported to Microsoft an Excel formula-tracing bug; resolved in Excel version 2016 (https://support.microsoft.com/en-us/kb/3115438).

> Awarded twice: authored and maintained vital Excel and Access modeling and forecasting applications used in reports presented to top rating agency's international Ratings Committees with which to determine and substantiate globally-published ratings.

> Created and maintained Office VBA add-ins with tools, custom ribbons, and reusable code for all levels of users and developers.

> Streamlined, standardized, and updated many important C++ applications and development processes for global investment bank.

> Devised company network administration system in its entirety including self-authored database and C++ utilities, security features, hardware and software configuration, document and Email storage capacities, and Active-Directory and Exchange configurations.

> Created and developed C++ / PDF charting package with statistical calculations for drawing charts in nationally published survey reports.

> Upgraded InstallShield packages for published software including Windows best practices, digital signatures, logos and colors.

PROFESSIONAL PROGRESSION

Lead Database Developer / Programmer (per diem) - Floral Park Ophthalmology, Floral Park, NY 9/2017 - Present

Enhance and maintain the practice's VBA / Access-based system to track patients, appointments, visits, insurance, billing, reminders and robo-calls.

> Implemented and first automated the practice's waiting list.

VBA / Database Developer - Crum & Forster, Inc., Eatontown, NJ 5/2018 - present

Develop in Excel VBA many highly specialized client-data conversion tools and internal reports with an Oracle PL/SQL back-end:

> Authored formula-based converter to accept any arbitrary data layout and remap it to company standards; customized it with minimal effort for each of many clients whose monthly data feeds the converter helped automate and streamline.

> Automated annual projection report such that it gathers an entire user-input year’s data and produces summaries both overall and per broker.

GUI Developer / Data Analyst - 1010data, New York, NY 2/2017 - 3/2018

Developed in K, enhanced and debugged the company's web interface (HTML, CSS, JavaScript) to database, analysis, and visualization tools operating on a column-based relational time-series database with in-memory capabilities. Tools included their flagship "Trillion-Row Spreadsheet" (TRS) and proprietary QuickQuery / QuickApp programming language, enabling clients to easily analyze and understand cloud-based big data.

> Developed and enhanced the TRS to allow users to expand and customize text-export options.

> Built paradigms into TRS so developers could add custom tabs and hide pre-defined tabs.

> Composed and automated testing scripts in Python and 1010data QuickQuery / QuickApp for system components.

Lead Application Developer - S&P Global, New York, NY 7/2006 - 1/2017

Authored, maintained, documented, and supported both external and internal financial ratings applications. Created and maintained VBA development tools for version control, formula auditing, database interface, security, and data conversion. Authored and maintained InstallShield Packages for company products, e.g., Hedge Fund Evaluator (HFE), CDO Evaluator (CDOE), Market Value Evaluator (MVE), and S&P Interest Rate Evaluator (SPIRE). Improved software integrity and security by leading efforts to propose and ultimately purchase company digital signatures.

> Awarded for converting HFE's calculation engine from VBA to C++ and maturing and securing HFE to manageable state for external sale. HFE is an Excel-based tool with Visual C++ DLLs and Access back-end (ODBC / DAO / ADO) to incorporate company's securitization criteria for modeling hedge fund performance, allowing analysts to develop relevant scenarios, and streamlining CFO-structured deals involving hedge-fund portfolios and evaluation of transaction risk, and bringing proprietary modeling criteria to the analysis process.

> Awarded for single-handedly creating, developing, maturing and securing MVE, a VBA / Excel-based tool with Access back-end (ODBC / DAO / ADO) to incorporate S&P's quantitative methodology and assumptions rating market value securities transactions.

> Created, developed, and supported a myriad of investor- and ratings-support systems along with dynamic analysis and modeling processes. Also created and utilized VBA / Excel Test Automation tool used both internally and externally by KPMG.

> Developed and enhanced VBA / Word template with automated population features to load RMBS performance data from Oracle / PL/SQL back-end and produce comprehensive ratings reports to present to international Ratings Committees.

Software Engineering Consultant - Greater New York City Area 4/2004 - 7/2006

Served as technical consultant and software/database/report developer for various companies including Merrill Lynch, The McGraw-Hill Companies, SunGard Consulting Services, Fortis Bank, Bellmarc Realty, and Press-Ganey Associates.

> Administered software and hardware systems (Active Directory, Exchange, Windows Server) for 300 real-estate sales agents, 10 property managers, and corporate staff of 20, including authoring software and version inventory system utilities in C++ and VBA / Access.

> Converted data and authored management utilities using various programming languages and applications.

> Created and supervised company-wide help desk to effectively track and respond to customer issues. Designed and developed custom sales materials in Adobe Illustrator, PhotoShop and VBA / Word.

> Acted as Financial Systems Analyst writing and maintaining various databases and software; integrated two disparate systems.

> Debugged and streamlined FoxPro application to unify multiple disparate G/L billing systems and international and domestic cost-centers.

> Acted as lead programmer authoring and developing in C++/PDF complex statistical analyses of hospital surveys producing nationally published reports; devised data-charting package to produce custom pie and bar charts for reports.

Lead Database Developer / Programmer (per diem) - Care for the Homeless, New York, NY 6/2004 - 6/2010

Developed, enhanced, and maintained databases for tracking diagnoses, interventions, lab tests, and treatment referrals for homeless and indigent individuals throughout all five boroughs of NYC for government reporting purposes.

Programmer Analyst - Bayerische Landesbank, New York, NY 7/2000 - 4/2004

Streamlined C++ development of company and third-party software packages. Created and developed financial applications in VBA, SQL, ODBC, and Crystal Reports. Facilitated development by adding significant library routines to global platform.

> Created C++ implementations of common FoxPro functions and commands for conversion purposes.

> Implemented in reusable code a host of financial calculations, e.g., hidden reserves, market prices, and interest rates.

> Ensured seamless portability of applications among branches with disparate databases and infrastructure.

> Authored many vital VBA / Excel and VBA / Access financial applications which provided the Head Office comprehensive dashboards, reports and charts (Crystal Reports) based on AS400 / DB2 data via SQL and ODBC.

EDUCATION & AWARDS

Columbia University Bachelor of Science, Computer Science 5/1993

New York, NY GPA: 3.8/4.0

Recommended for graduate-level work

Yale University Pursued Bachelor of Science, Computer Science 9/1978 - 5/1981

New Haven, CT GPA: 3.5/4.0

Dean's list

S&P Global Recipient of the Silver ACE Award 2012

New York, NY Recipient of the Golden SPARC Award 2006

TECHNICAL SKILLS

Programming Languages: VBA (Excel, Access, Word), SQL, PL/SQL, DDL/DML, HTML, Python, CSS, JavaScript, XML, C, C++, VC++, K, dBase, DOS batch, UNIX shell (KSH), AWK, APL

Relational Databases: Oracle, Access, SQL Server, DB2, ODBC, DAO, ADO, FoxPro / Clipper / dBase

Financial Feeds: Bloomberg, Intex, CORE

Source Control: JIRA, Confluence, SVN, CVS, PVCS, Visual SourceSafe

Publishing / Graphics: MS Publisher, Adobe Creative Suite (Acrobat, InDesign, GoLive, Photoshop, Illustrator), Aldus PageMaker

Operating Systems: Windows, Linux, UNIX, IBM PC, Mac, HP/3000, VAX, DOS, Novell, VAX/VMS

Servers: Windows, Active Directory, Exchange / MailSweeper, Symantec AntiVirus, Barracuda Spam Firewall

Contact this candidate