PROGRAMMER/ANALYST thinking out of the box that brings success to projects and companies with development and technical solutions. Able to learn business concepts as well as relevant technology quickly.

Core Competencies

Database Development (Oracle, PL/SQL, SQL Server, TSQL, DTS, SQL Server Integrated Services, and SQL Server Reporting

Services)

Documentation (Reverse Engineered Business Requirements, Technical Designs, Training Presentations, Process Documents, Disaster Recovery Plan)

Data Warehousing and Reporting (Tableau, Essbase, Cognos, Actuate, SSRS, Crystal Reports, Cognos ReportNet, Hyperion Analyzer)

Business Skills (Customer Service, Team Skills, Process and Project Ownership, Mentor and Train New Team members)

Scripting/Programming (Unix Shell, VB.Net, VBScript, JavaScript, C#)

Data and Technical Analytical Skills (Analytical Problem Solving)

Career Progression

Energy Federation Inc, Southborough MA

SQL Programmer 12/2018 to Present

Working on extracts from mysql and SQL Server and Tableau reports pulling from SQL Server to send to energy suppliers and product suppliers.

Supporting data warehouse jobs and administrating Tableau.

Designed, developed, and supported process to quality control data for main client.

Fallon Health, Worcester MA

ETL Developer 04/02/2018 to 12/2018

SQL Developer Contractor, 07/2017 to 03/31/2018

Worked on a project to design, develop, and support processing for extracts to send enrollment and claim data to the federal government for comparing Fallon quality of claims to other carriers.

Format of files is in XML, and response files were also in XML. Processing was done in SQL Server using SSIS and stored procedures.

Mosaic Insurance Exchange, A Carroll Enterprises Company, Worcester MA

Senior ETL Developer, 04/2016 to 01/2017

Worked on a Team that enhanced, developed, and supported EDI files to multiple health insurance carriers.

Reverse engineered requirements based on existing code logic.

Created deployment document for ETL logic.

Due to budget cuts, the team size was cut after conversion from VAX to CRM was put into production.

Fallon Health, Worcester MA

ETL Developer, 02/2012 to 04/2016

Collaborated on a Team design, develop, and support processing for the following:

oExtracts from SQL Server using SSIS to third party vision vendor, EyeMed.

oProcess EDI 834 eligibility files in SSIS that were sent into Fallon Health from various parties.

oNew EDI feeds from SQL Server to the vendor that took care of payments to providers and members. Data was written to xml files, which became EDI 835 files, provider files, and other files.

oProject that calculated, validated, and stored copays and coinsurance values in SQL Server to be used globally throughout interfaces and extracts.

Worked with QA and business for testing and remediation.

Monster Worldwide Inc., Maynard, MA

Database Engineer, 11/2011 to 01/2012

Performed performance tuning, designed and developed audit reports, and enforced coding standards.

Downsized from Monster Worldwide Inc. as part of 7% workforce reduction.

Health Plans Inc., Westborough, MA

Programmer, 09/2006 to 11/2011

Designed, developed, and supported the following processes:

oEligibility Variance Process that automated enrollment from clients using VB.Net, SSIS, and SSRS. Included reports to various departments, and automatically adding enrollment to system through 834 files. Solution saved the company from hiring 2-3 people to manually processing enrollments resulting in costing savings.

oFlexible Spending Process that automated flex claims through the company's website.

oUniversity Health Coverage System that added enrollment from universities, allowing the company to focus on more business critical items as everyday needs were automated. Converted Actuate Reports to SSRS to be accessible through the web for clients.

Accenture, (Boston Scientific was the client), Natick and Watertown, MA

Enterprise Reporting Systems Analyst, 10/2005 to 09/2006

Developed and supported various elements of a data warehouse and revenue system, using SQL Server and Cognos.

Fidelity Investments, Boston, MA

Lead Software Engineer/Developer, 01/2004 to 10/2005

Financial Instrument Reporting System (FIRS)

Supported application that collected, stored, and distributed financial data on mutual funds.

Lead for Mil rate Expansion Project – Updated and tested Actuate reports, Oracle stored procedures, and C++ code. Led project communication with over 30 teams to verify over 800 files.

Senior Software Engineer, 01/2001 to 01/2004

Online Repository Charge-back Activity (ORCA), Fidelity Investments, Boston MA

Senior developer on a project which aggregated cross-departmental billing information into a centralized multi-dimensional data warehouse in Essbase for financial reporting and analysis.

Developed ASP pages for forecast and budget import process, and adjustment processing.

Migrated and consolidated data for feeds to and from ORCA.

Senior developer involved in the re-designing of the ORCA system. System was re-engineered from a Sybase transactional relational database to an Oracle star schema. Automation of process resulted in reduction of time required to aggregate data from a day to less than an hour.

Lead for production support, documentation, and development enhancements for a data warehouse and Essbase cube based on data in Sybase. As a result the process time was reduced from 2 weeks to a day, due to automation of manual processes and data clean up.

National Charitable Services (NCS), Fidelity Investments, Boston MA

Lead developer on a multitude of transaction processing projects with responsibilities that included:

Participation in the systems and business analysis.

Development the technical specifications.

Development and unit tested code in PL/SQL, UNIX Scripts, and AWK scripts.

Problem solving with third parties to cross test.

Resolution with QA and UAT testers to resolve issues.

Education

Arcadia University, Glenside, Pennsylvania

Bachelor of Science in Computer Science

Contact this candidate