SUMMARY:

Senior software application developer/data analyst. Over 25 years of experience supporting investment firms (asset management, trade rebalancing, compliance, risk analysis systems), healthcare companies (claims analysis, rate forecasting, and clinical trials), as well as other industries. Background in statistics/econometrics and experience with data conversions of every type.

TECHNICAL SKILLS:

Software Skills: SQL Server (T - SQL, SSIS/DTS, stored procs), ETL, SSRS, VB.NET, VBA (Access, Excel, Powerpoint, Word)Visio Pro, Tableau, ASP, HTML, XML, VB6, SAS, SPSS, Crystal Reports, Visual Foxpro, Oracle, DB2, Sybase, Fortran, Agile, TFS, Visual Source Safe, Jira, Tortoise, Windows 7/10, XP, UNIX, IBM MVS/TSO, VM/CMS

EXPERIENCE:

Confidential, Rockland, MA

Responsibilities:

• Database development for consolidation of Project Controls Gas data for Confidential .
• Developed SQL Server/MS Access database to replace multiple excel spreadsheets.
• Access, Excel VBA, Powerpoint, SQL Server, Visio Pro, TableauEnhancements and maintenance of Auto Pricing models for Confidential .
• Developed at dislocation merge graph tool allowing interactive comparison of factors between states.
• Automated the creation of Powerpoint slides.
• Excel VBA, Powerpoint, SQL, SAS.
• Responsible for conversion and development of macros used for financial analysis and reporting accessing mainframe databases at Confidential .
• Worked with a network of internal clients in the US and worldwide, Coordinated efforts with offshore developers. Excel VBA, Access VBA, Visual Studio 2008, VB.NET, IBM/VM.
• Enhancements and maintenance to AMICA’s claims analysis processing system.
• The claims parser received over 10,000 claims per day from claims account representatives as well as customer submittals in XML and using VB.NET and SQL queries for delivery into their star schema DB2 analysis data warehouse.
• VB.NET, SQL 2008, DB2, XML.
• Development of MS Access 2010/SQL Server reporting system to replace legacy system for Confidential .
• Conversion of FoxPro databases to SQL server. ASP.NET, VB.NET, SQL 2008, LDAP.
• Provided data analysis and software support for financial systems.
• Knowledge transfer to offshore developers. Access VBA, Excel, SQL Server.2008
• Responsible for data conversion of a hospital inventory, maintenance, and tracking system with over 300 clients.
• Large datasets with 150 tables, 3000 fields and over 100 GB of data for Confidential .
• Visual Basic 6, SQL 2008 Server, SSIS, Oracle, Visual FoxPro, VBA/MS Access, Informatica/Salesforce.
• Performed customized data conversions.

Confidential, Waltham, MA

Technical Lead/Senior Software Engineer

Responsibilities:

• Responsible for maintenance, enhancements, and revisions of PCI’s Fair Lending Wiz (Mortgage and Auto loan compliance), Includes modules for Decisioning and Pricing Regression, Targeting Analysis, and Risk Analysis.
• Liaison between management, professional services, tech support, QA, and offshore developers.
• Visual FoxPro, VB.NET, ASP.NET, SQL Server 2005, SSIS, SSRS, Web Services. VB script, ASP, XML, COM+, VB6, SAS 9.1, Crystal Reports.

Confidential, Medfield, MA

Data Analyst

Responsibilities:

• Designed and created a portfolio snapshot system as an add-on product for users of dbCams+ portfolio management software.
• Product was purchased by Confidential and is now part of their product known as Confidential .
• Constructed numerous interfaces between corporate databases and portfolio accounting software.

Confidential, Waltham, MA

Data Analyst

Responsibilities:

• Programming and analytical support of federal and state studies of health care data for Confidential .
• Data analysis and statistical modelling for the SCRIPT project, a case study of Coronary Artery Disease sponsored by HCQIP.
• Software development for Medicare HEDIS data. SAS, Visual Basic, SQL Server, Oracle.
• Redesigned a credit risk and exposure analysis system for Confidential ’s retail brokerage division.
• New system as a multi-tier architecture.
• Developed customized DTS (SSIS packages to transfer data from Sybase back end to SQL Server middle tier and database replication to distribute transactions across 3 middle tier servers. Visual Basic 6, VBScript.

Confidential, Boston, MA

Senior Software Engineer

Responsibilities:

• Designed and constructed a system to correlate relationships between bond yields and economic indicators Includes user interface to test various scenarios including creating custom defined indexes of economic indicators (GDP, employment, housing starts, auto sales, etc.) and combining countries with weighted parameters.

Confidential, Medfield, MA

Senior Software Engineer

Responsibilities:

• Constructed numerous interfaces between corporate databases and portfolio accounting software.
• Re-engineered a portfolio rebalancing system designed to keep account holdings in balance with indexes when investments are bought and sold between countries for a global asset management firm.
• This system is used on a monthly basis to produced trades dictated by macroeconomic models.
• Automated daily pricing feeds from FACTSET and REUTERS using visual basic open function calls Sybase/SQL, Paradox, VB6, Excel 7, and Windows NT.

Confidential, Marlboro, MA

Senior Software Engineer

Responsibilities:

• Lead developer on Defined Benefits data conversion and reporting team.
• Responsible for delegation and coordination of consultants supporting user needs.
• Sybase/SQL, Visual Basic 4, Crystal Reports 4.5, MS Access 7, Windows NT.