Debug legacy database programsWrite MQ-Series programsCreate VSAM files to support user requests for improved performance JCL modified to support generation data groups

Responsible for detailed conversion of clients billing history.Modified the ETL programs for clients unique billing requirements.Design, Build, Test VB(5) programs for NSF electronic remittance advice.Windows XP, VB(5), ADODB, MS-Access

Mainframe legacy EDI updates to COBOL-II programs.Compile, unit and regression test.WDI Mapping revisions for added segments.Modify client specific code in multiple in/out bound bridge programs.

- Provide support for clients converting from the Micro Systems PM system to Benchmark PM, and EMR.- Maintain, enhance and debug DataFlex 3.2 code, and support conversion to version 15.x.- Provide user support for legacy and ad hoc reporting.- Provide support for client issues as they arose.Dataflex 3.2, MS-Access, Windows XP

Maintain, enhance and debug DataFlex 3.2 code, and support conversion to version 15.x.Provide user support for routine and ad hoc reporting.Design and implement database changes for governmental medical insurance mandates.ETL client data for conversions using a variety of DBMS(MS-SQL,Pervasive,Oracle,MySQL,MS-ACCESS, csv)Developed several HL7 interfaces between laboratory and practice management systems.Provide support for client issues as they arose.Evaluated 3rd party products for additional productivity.Used all resources available to Micro Systems to recover and restore 100% of client A/R within 4 days of a major fire. This involved recreation of all servers/clients, programs and database files from new system images and new hardware..Windows XP, Dataflex 3.2

Contract to provide skill and services to migrate a user customized Lawson database from an old release. Primary activities were focused on the LAWSON changes to the index structure from ascending to descending segments.Other duties involved writing SAS procedures to identify data fields with unexpected values.OS/MVS, COBOL, SAS

Modify, compile, and test HP BASIC programs to enhance daily management reports.Design, build, test A/R (Accounts Receivable) programs BASIC, HPUX, Oracle

Developed an invoicing report application using Actuate with other team members.Debugged custom SQL for the PeopleSoft Informix database.Converted a legacy COBOL data collection system to SQLMicro Focus COBOL, Informix, SQL

Evaluate alternatives, Prepare and tender bids, evaluate proposals, issue PO for server/softwareWindows NT

Modify AS/400 RPG and COBOL programs to support enhanced operator inquiry and invoice generation.

Develop Policy Master Record extractions, using COBOL, DB2 and SAS, to create special one off reports for mid-management, senior executives, lawyers, and legislative representatives, in a large IBM-390 processor complex. Restricted disclosure due to company policy.MVS JES3 DB2 SAS

Modify AS/400 COBOL enhancing control reports.

Design, build, test a PM software system to support a startup billing service company.Design, build, and support multiple database systems to provide client financial reports in a timely manner. Mainframe for hospital based physicians/practices. 5360 processor for client stand alone systems.Mentor operations support personnel and programmers for continued success.Provide guidance and support to board of directors in regards to strategic initiatives.Developed electronic interfaces to medical center information systems to provide automatic loading of patient demographics.Designed, bid out, install two raised floor computer rooms for the processor complex.Designed and bid out, install a bus/tag AB switch for sequential tape backup.Mainframe purchase and install of IDMS/R with ADSO for development.Platforms used were the IBM 5360, DOS/VSE 4361, and AS/400.Using PC-SAS as a statistical tool analyzing ICDA diagnosis codes correlations.

Conversion of mine planning systems tables to SAS datasets.Designed an interface for mine planning where all SAS data values were stored "BY NAME" in the IDMS database which allowed the engineers to store their values in different formats for compliance reports.OS/MVS, PL/I, COBOL, FORTRAN, TSO, SAS, IDMS