Technical

Proficiency

Platforms: Microsoft, AS/*00, IBM Mainframe, HP3000, Unix

Tools: SQL, Java Scripting, Java, .NET 3.5, XML, HTML, ASP, Sybase NEON, Visual Basic, C++, COBOL, COGNOS, TSO/MVS, FORTRAN, IBM WebSphere

Databases: SQL Server, Oracle, Sybase, DB2, Access, Allbase, Image

Industry

Knowledge

Industry Experience: Healthcare, Manufacturing, Engineering, Banking

Extensive experience in MRP/ERP software managing, installing and customizing manufacturing systems for both DOD and commercial product lines.

Extensive experience in health care system conversions over the last 10 years

in data mapping, specification writing, test planning, and programming.

Extensive experience with membership, claims, providers, premium billing,

capitation, Medicaid and Medicare modules on multiple health care systems.

SQL Developer

SQL Developer

SQL Developer

April 2017 – Nov2017 IntelliSource Solutions Chester Springs, PA 19425

Contract with DST Health Solutions did Oracle development work for conversion

Of Harbor Healthcare plan wrote scripts, Stored procedures and functions and

Mapped data from old system to the Exeter system. Did COBOL annalist for java programmers to fix issues with JCOBOL conversions. Used MS Access to convert data for history Claims .

June 2016 – Dec 2016 MasTech Moon Township, PA 15108

Contract with BCBSTX for 2017 new plans doing Stored Procedures, Querys

Inserting data and codes into tables as needed for the 2017 release !

Using Agile development environment

Feb. 2012 – May 2016 MicroVu Inc./ Multaply Inc. Boca Raton, FL 33427

SQL Developer - Microsoft SQL Server. Designed, developed, and supported stored procedures and SSIS packages. Converted data from other claims systems into the MicroVu claims auditing system - ARMS. Developed numerous stored procedures to implement auditing algorithms. Worked on very large databases with tables containing over 600 million rows. Developed over 500 stored procedures and SSIS packages in total. Clients included Humana, Wellpoint, and United Healthcare. Used MS Access for data conversions.

Software Engineer Independent Contractor

October 2010 – Feb. 2012 Muse Dragon Services Plano, TX

SQL Developer, Designed and wrote stored procedures, triggers, and queries as needed. Analyzed, developed, and executed stored procedures and SSIS packages to fix data issues and convert data from other systems to new SQL Databases for Clients.

Senior Support Technician

June 2005 – October 2010 TriZetto Inc. Phoenix, AZ

First line of contact supporting all of TriZetto’s Web base products including the J2E, .NET, VB and ASP bases products and the integration of the system to Facets backend. Set up SQL databases SQL Server,Oracle and Sybase. Developed custom query’s, stored procedures and triggers as needed for the customer base to repair and import data. Configured and debugged WebSphere servers for the supported clients for test and production environments . Developed java and VB script as need for client support. Worked with SSIS and DTS as needed.

Senior Software Engineer

Feb. 2004 - May 2005 Encore Systems Professionals Houston, TX

EnCore Systems provides a comprehensive Benefits Administration solution to the Third Party Administrator (TPA) market. Responsible for many projects on the EnCore Systems HP3000 and new Windows platforms. Participated in porting the HP3000 version to Windows. Worked extensively on member, provider and group administration modules as well as claim adjudication logic. Wrote COBOL and powerhouse programs (QTP, QUIZ and QUICK) as needed.

Senior Software Engineer

October 1995 – Sept. 2003 TriZetto Inc. Irving, TX

TriZetto focuses on providing professional systems solutions services to healthcare companies. Responsible for developing business and technical specifications, coding, testing, and working with clients for the following:

Web front-ends to healthcare systems using HMTL and ASP.

Custom web interfaces in Java and Java scripts for TriZettos’ Healthweb application in production for thirty companies.

SQL stored procedures and triggers for Sybase and SQL Server.

SQL stored procedures and COBOL in IBM DB2 mainframe environment.

Electronic funds transfer (EFT) for an HMO for individual products for Medicare and commercial products.

Year 2000 upgrade for Hewlett Packard’s Manufacturing Management System (MM3000) for Eli Lily.

Data Warehouse using ORACLE on Windows for a distribution company.

Senior Project Manager

April 1993 - July 1994 Beloit Fiber Systems Dalton, MA

Upgraded AMAP’s MRP-II system from Version-D to Version-F, re-wrote the inventory tracking programs, and implemented Master Production Scheduling module. Implemented a new shop tracking system with bar coding using Striped Lightning. Installed a Novell LAN and moved Engineering Department to AUTOCAD for Windows. Re-wrote the parts costing system for finance to track project cost on shop floor. Tools - COBOL II, FORTRAN 77, PROTOS, VPLUS, IMAGE SQL and ALLBASE on HP3000 Series 957, and HP NewWave Access, LOTUS, DBASE-IV Visual Basic and C++ on PC’s.

Manufacturing Software Manager

May 1985 - April 1993 Simmonds Precision Products Vergennes, VT

Developed and supported manufacturing system on IBM, Hewlett-Packard, Novell LAN platforms for this $120 million aerospace electronics DOD contractor. Implemented a new manufacturing system as part of a Class A MRP reengineering team, Installed an HP3000 series 58 and implemented Boeing Computer Services Production Management System for B-2 Bomber program. Installed an HP3000 series 955 and converted the rest of the company from IBM’s COPICS system to the Boeing system. Project was completed on schedule, under budget resulting in annual cost savings of $5 million. Team then implemented the CFS Financial Package replacing the financial system on the IBM 4381, which was then retired from service. The HP3000 was upgraded to series 967. Used COBOL, DL-I, VSAM and Easytrieve on IBM, FORTRAN-66, FORTRAN-77, COGNOS Powerhouse tool, RPG XL, IMAGE and ALLBASE on HP3000’s, LOTUS, CLIPPER and DBASE-IV on PC’s.

Education

Bachelor degree in Mathematics, Castleton State College, Castleton, Vermont

Associates in Electrical Instrumentation, Vermont Technical College, Randolph, Vermont

Affiliations

Honorable Discharge, United States Navy, January 1975

References

Don Baird VP of product development DST 972-***-****

Randy Quan manager of support Trizetto 972-***-****

Sue Severens senior project manager NTT DATA 214-***-****

Contact this candidate