Career Summary:

• A seasoned data processing professional with over 20 years of experience in both Mainframe and distributed
• application development. An innovative problem solver with solid analytical, and interpersonal skills. Experienced in
• all phases of the project life cycle, including user interface, business and systems analysis and design, development
• of programming specifications, coding, unit and system testing, documentation and user training. In addition to
• technical skills other strengths include leadership, self direction, reliability, productivity and teamwork skills.
• Hardware: All major IBM mainframe series, IBM PC's and Compatibles, Ultra Sparc, Power PC, HP3000/9000
• Operating Systems: MVS/SP XA ESA 390 z/OS UNIX/AIX, HP-UX, Solaris Windows NT/2000/XP/7
• Network/Server: Windows 2000, 2003, 2005, 2008
• Database: DB2 SQL IDMS VSAM IMS DB Sybase 10 MS Access Jet Oracle 7, 8i, 10g, 11i
• SQL Server 2003, 2005, 2008 UDB 9, Teradata
• Database Modeling: Advantage:Gen Cool:Gen IEF Composer Erwin MS Access
• Case Tools: Advantage:Gen Cool:Gen IEF Composer BAA, BSD and Construction
• Online/Networking: CICS Command Level , IMS DC
• Languages: z/OS COBOL VS COBOL II COBOL for OS/390 z/OS/JCL MF COBOL/Server Net Express
• Easytrieve Plus CLIST REXX ISPF Dialog, ANSI C, DOS Unix Scripting
• Client/Server: Micro Focus COBOL Server Express MS Access 97, 2000, 2003 VBA Visual Basic 6.0
• Visual C , ANSI C
• Oracle: SQL Plus Command Line PL SQL Forms 4.5 Reports 2.5 Discoverer Stored Procedures
• SQL Server: Transact SQL, T-SQL Stored Procedures, DTS
• IBM UDB: SQL
• Teradata: SQL
• Reporting Tools: Crystal Reports Cognos 7, 8 MS Access
• Desktop: Word Excel Powerpoint Project E-Mail Schedule Lotus Notes
• Productivity Tools: TSO/ISPF Endevor File-Aid Comparex Abend-Aid Panvalet Xpeditor
• QMF OLQ SPUFI Intertest Syncsort Iceman SDF NDM AMS BMC AQT,
• CA7 RMDS Softcopy SQL Programmer ClearCase RequisitePro VI DTS
• SQL Compare SQL Server Management Studio Redgate SQL Compare 6
• CRON MS Scheduled Tasks Serena Changeman
• Banking: Deposit Systems Financials Tax Reporting
• Insurance: Defined Benefits / Defined Contributions Tax Reporting Claims Billing
• Financials, Annuities Personal Lines Commercial Lines Healthcare,
• Regulatory Medicare Medicaid Prospective Payment Systems PPS

Experience:

Confidential

Software Engineer Analyst - Developer

• Provided technical solutions for new and existing interfaces on varying platforms seeking best possible client solutions utilizing their existing platform requirements.
• Analyzed, designed, coded and performed end to end systems testing for modified programs.
• Supported client ticket system issues related to implementations of EASYGroup suite and Amisys Advance suite of products.
• Maintained all Amisys Advance to EASYGroup interface modifications to dozens of external clients, providing technical
• solutions to Prospective Payment System PPS updates and configuration modifications.
• Skills Utilized: MF COBOL/Server Express, Unix O/S, Unix Scripts, SQL Plus, EASYGroup - PPS, Amisys Advance

Confidential

Systems Analyst - Developer

• Performed system level impact assessment for a systems conversion and sun setting.
• Analyzed, designed, coded and performed end to end systems testing for modified programs.
• Performed analysis, data modeled and provided development options with costs for a database conversion from IMS hierarchical
• database to a SQL Server relational database.
• Reconfigured ASG ViewDirect 4.2 document spooler and document server to accept text and postscript data sources.
• Skills Utilized: T-SQL, SQL Stored Procedures, DOS Batch Scripts, COBOL, IMS, Eztrieve , CA7, MS Access.

Confidential

Data Engineer Database Developer

• Provided development support in a Mainframe, SQL Server and IBM UDB environment. Manipulating data, modifying databases,
• scripted batch files in support of the development teams objectives. In addition, ran daily and weekly SQL and UDB applications
• in support of the organizations web applications and resolved data issues as they were identified.
• Provided technical support in the development of a metrics reporting system for management. This involved providing
• scenarios documentation and technical requirements for the development of this SQL Server stored procedure initiative.
• Skills Utilized: T-SQL, SQL Stored Procedures, DTS, UDB 9.0, COBOL, MVS DB2 8.0, VSAM, DOS Batch Unix Scripts

Confidential

Information Engineer

• Participated in the high level design for MI BI applications including selection of data sources and determination of whether the application will become part of the PLW publishing layer.
• On a project basis performed source to target data mapping and gap analysis along with logical data
• modeling and publishing layer modeling. Access analysis and input into physical database and ETL
• design providing opportunities for seamless integration within existing data marts.
• Interface with business customers, S/A's and MI design teams to gather and clarify data and usage requirements along with defining testing strategy, implementation approach and planning activities.
• Skills Utilized: Teradata, Erwin, Cognos 7.4, 8, MS Access, SQL Server

Confidential

Systems Analyst - Senior Developer

• Performed systems analysis, design and development of a data mart to support the MIS requirements. Cobol, DB2 SQL and utilities
• were used to accomplish the task.
• Lead an initiative to develop several new reporting requirements using the full SDLC to a successful timely project completion.
• Assisted in the development of Online and Batch procedures using Advantage Gen.
• Designed and developed a complex interest calculation program using Cobol/DB2 SQL, Several attempt
• were made to develop this process with several peers stating that it could not be done.
• Upgraded Filenet IDM and Capture desktop and server software to the newest versions, along with
• the daily maintenance and support of five 5 scanner workstations using Filenet with a custom VB UI.
• Skills Utilized: DB2, QMF, SQL, Cobol, VSAM, IMS DB, TSO/ISPF, JCL, CA7, VB 6.0, Advantage: Gen, FileNet Capture

Confidential

Confidential

Senior Consultant

• Systems performance and volume stress testing for all applications supporting the healthcare division. This entailed the extensive use of DB2 Utilities to perform data migration, data growth, backups, recoveries and binds. Extensive JCL modifications were made to support the new testing environment and data growth expectations of the project.
• Skills Utilized: DB2, DB2 Fileaid, VSAM, DB2 Workbench, QMF, SQL, SPUFI, TSO/ISPF, JCL, CA7

Confidential

Project Manager

Lead a team of five 5 offshore and two 2 on-shore developers in converting over 100 reporting programs to Eztrieve .

Completed the project ahead of schedule and under budget while delivering a quality product.

Skills Utilized: SDLC, Project Management, Eztrieve

Confidential

Senior Consultant

• Developed Cool:Gen 5.1 online procedures and action blocks using CBD Component Based Development
• Standards. Executed generated Com:Proxy code on personal test web servers and debugged using DTF Trace .
• Skills Utilized: DB2, Cool:Gen, QMF, SQL, SPUFI, TSO/ISPF, JCL, Com:Proxy, DTF

Confidential

Senior Consultant

• Systems performance and volume stress testing for all applications supporting the healthcare division. This entailed the extensive use
• of DB2 Utilities to perform data migration, data growth, backups, recoveries and binds. Extensive JCL modifications were made to
• support the new testing environment and data growth expectations of the project.
• Skills Utilized: DB2, DB2 Fileaid, DB2 Workbench, QMF, SQL, SPUFI, TSO/ISPF, JCL, CA7

Confidential

Team Leader Architect - Analyst - Developer

• Made and presented recommendations for strategic and tactical implementations to senior architects and management throughout the projects development lifecycle.
• Performed Systems Analysis between the existing legacy system and the front-end strategic VB Client Server application to Model and Develop an error processing methodology that seamlessly integrated both systems.
• Developed several C classes from technical specifications and assisted in defect resolution throughout the testing phases.
• Logical Physical Data Modeling, Systems Design Documents and Technical Specifications were created to support endeavor of integrating this new three-tier fat client server application with existing backend legacy systems.
• Acted as liaison between Legacy and Client Server teams to insure communication gaps were mitigated and technical/data requirements were delivered within project timelines. This included facilitating data design, extract, transformation rules sessions and design walkthroughs.
• Developed several Project Management tools using MS Access 97 - VBA, Over 40 users on 5 concurrent projects utilized these tools during business analysis, design and testing phases of their projects.
• Skills Utilized: DB2, QMF, SQL, COBOL, ACCESS 97, VBA, C , VB 6.0, ERWIN, TSO/ISPF, IMS DB, UNIX