Programmer Analyst Office

Obj***

RESUME

OF

Mr. JOHN W. LEWIS

**********@***.***

404-***-**** - Cell

Summary

• Senior COBOL Programmer Analyst with over fifteen years of experience working

throughout the full SDLC in a 24x7 production environment.

• Extensive experience developing, maintaining and supporting multiple on-line Data Base

production systems with ten years of experience working with financial/revenue

applications.

• Over fifteen years of mainframe experience using COBOL, CICS, DB2, and JCL with

hands on experience creating and maintaining PROCS.

• Extensive experience working with developers to gather requirements and translating

those user requirements into system requirements and performing Quality

Assurance (QA) procedures.

• Over fifteen years of experience working with the source code management tool Endevor

and TSO.

• Team player and self-starter who has excellent verbal and communication skills.

Technical Summary

IBM MAINFRAME z/OS 900, COBOL, COBOL II, COBOL 74, CICS/BMS, DB2/, SQL,

SQL/DS SPUFI, QMF, VSAM, MVS JCL, TSO/ ISPF, IMS DB/DC, EASYTRIEVE, ORACLE

8i, SQL PLUS (UNIX), IDMS, ENDEVOR, XPEDITER, INTERTEST, PANVALET, MS

OFFICE (EXCEL, WORD, ACCESS), OS/VSE, SAS, SOX, MICRO FOCUS COBOL, VISUAL

BASIC 6.0, VIA SOFT, COPICS, MQ SERIES, VISIO, FILEAID, OWLLIB, ROSCOE ADW

1.6XX/2.7.01/2.7.02, FTP, NDM,UNIVAC, PL/1 1100/DMS, ECL, OMNICAID,

POWERPOINT, CLEAR QUEST, METAVANCE, HIPAA, CA-7, CHANGEMAN, SDLC

Methodology, Crystal Reports, STORED PROCEDURES, WEBSPHERE MQ,VISUAL

BASIC.NET, HTML, Mercury Quality Center (Test Director), XML, SOA, SYNCSORT, and

EDI X12N TRANSACTION SETS (276, 277, 834, 837I, 837P and 837D).

Professional Experience

Blue Cross Blue Shield, Washington DC – June 2014 - Present

Senior Programmer Analyst

• Responsible for analyzing and creating design documents and program specifications and

writing COBOL DB2/CICS programs for a centralized claims history data base to

facilitate the processing of all FEP for members that are received by all Plans throughout

the United States and Overseas Claims for payment that are processed by the Washington

D.C. Plan.

• Supervised releases that were monitored on a 24/7 processing schedule to include all

updates, enhancements and new modules for production.

• Acted as liaisons between the business and technical entities translating the business

needs in to technical specification using VISIO flow charts.

Environment: IBM MAINFRAME z/OS 900, COBOL, DB2/SQL IMS, SPUFI, TSO/ISPF,

CICS and VISIO, ICCF, MS WINDOWS 7/XP, MS OFFICE (EXCEL, WORD), XCEL, EDTR

Text Editor

PAGE 1

Obj100

Resume of John W Lewis, Page 2 of 6

Blue Cross Blue Shield, Richardson Texas, Illinois – March 2012 – June 2014

Lead Programmer Analyst

• Responsible for coordinating the implementation of the States of Illinois ( HCSC),

Alabama, Texas and New Mexico for Centennial Care and Maximus enhancements and

Related Groups (DRG) and apply HIPAA ICD-10 5010 modifications for

Medicaid/Medicare applications writing COBOL DB2/CICS programs while creating

JCL Jobs and Procedures (Procs) in TSO in Endevor.

• Created Provider Data Extract for Medicare Advantage and TANF to populate DB2 tables

and CICS screens.

• Supervised and mentored junior programmers while creating standards and procedures

for structured coding, testing, QA and documentation.

Environment: IBM MAINFRAME z/OS 900, COBOL, DB2/SQL IMS, SPUFI, TSO/ISPF,

CICS and VISIO, ICCF, MS WINDOWS 7/XP, COBOL, MS OFFICE (EXCEL, WORD),

XCEL, EDTR Text Editor,

Bank of America/Merrill Lynch, Atlanta, GA – October 2012 – March 2013

Programmer Analyst

• Responsible Maintaining and Modifying the Regulatory List Screening system for

International sanctions. Utilizing various DB2 tables and utilities and routines to control

and monitor the restrictions of financial accounts of organizations, nations and

individuals involve in money laundering activities.

• Coordination efforts between various off-shore facilities to control the processing of all

financial accounts of countries and individuals that are “Black-Listed” updating DB2

table and CICS report screens.

Environment: IBM MAINFRAME z/OS 900, COBOL, DB2/SQL SPUFI, TSO/ISPF, CICS and

VISIO, ICCF, MS WINDOWS 7/XP, COBOL, MS OFFICE (EXCEL, WORD), XCEL, EDTR

Text Editor

LabCorp, Burlington, NC – January 2012 – August 2012

Senior Programmer Analyst

• Responsible coordinating the implementation of the Diagnosis Related Groups(DRG) and

apply HIPAA ICD-10 5010 modifications to various State Blue Cross/ Blue Shield

facilities and hospital plans for Medicaid/Medicare applications.

• Creating and modifying COBOL DB2 programs to include new Diagnosis codes and

creating report programs and spread for the Business community using QMF and EXCEL

spread sheets.

Environment: IBM MAINFRAME z/OS 900, COBOL, DB2/SQL, IMS, SPUFI, TSO/ISPF,

CICS and VISIO ICCF, MS WINDOWS 7/XP, COBOL, MS OFFICE (EXCEL, WORD), XCEL,

EDTR Text Editor

Health Management Associates, Naples, Florida – June 2011 – January 2012

Programmer Analyst

• Responsible for the implementation of the Secondary Payer Calculations and apply

HIPAA ICD-10 5010 modifications to various State Blue Cross/ Blue Shield facilities and

hospital plans for Medicaid/Medicare applications.

Environment: IBM MAINFRAME AS400, ICCF/VMS and z/OS 900, MS WINDOWS 7/XP,

COBOL, CICS, MS OFFICE (EXCEL, WORD), XCEL, EDTR Text Editor, and VISIO.

PAGE 2

Obj100

Resume of John W Lewis, Page 3 of 6

State of North Carolina, Raleigh, NC – January 2011 – June 2011

Programmer Analyst

• Responsible for the analysis of the rewrite for the legacy Medicaid (MMIS) to process

transactions (276, 277 and 837) front end for COBOL DB2 CICS applications and apply

HIPAA ICD-10 5010 modifications and updates to the Diagnosis Related Groups(DRG).

Environment: IBM MAINFRAME z/OS 900, MVS, MS WINDOWS 2000/NT, COBOL,

DB2/SQL, IMS, HTML, SPECBUILDER, DOCBUILDER, EDI, CICS, Stored Procedures El

Segundo, XQMF, QMF, COBOL, SPUFI, TSO/ISPF, XPEDITER, MS OFFICE (EXCEL,

WORD), XCEL, CA-7, XML, ENDEVOR, EASYTREV, DB2 Stored Procedures and VISIO.

NASCO, Atlanta, Georgia – March 2010 – January 2011

Programmer Analyst/ Business Analyst

• Responsible for triaging medical claim processes from various carriers and providers to

coordinate the integration and implement system changes while Testing and tracking

defects in CLEAR QUEST to determine their causes and solutions in an effort to support

the METAVANCE online Electronic Health Record (EHR) . I also participated in the

HIPAA ICD-10 5010 conversion.

Environment: IBM MAINFRAME z/OS 900, MVS, MS WINDOWS 7/XP, COBOL,

DB2/SQL, EDI, CICS/BMS, SPUFI, TSO/ISPF, XPEDITER, MS OFFICE (EXCEL, WORD),

XCEL, CLEAR QUEST, METAVANCE, SYNCSORT, and VISIO.

Health Plan Services, Tampa, FL – July 2009 – November 2009

Programmer Analyst

• Created Cobol, CICS, DB2 programs to calculate Health Markets rates for the Batch

and Online rating processes for Quoting, Verify/Issue, Billing, Rate Changes and Auto

Adjustments. I created the High Level Design Documents (HLD) as well as the Detailed

Design Document (DLD). I also created the VISIO flow charts, XCEL spread sheets and

other supporting documentation while implementing HIPAA ICD-10 5010 modifications.

I also created and implemented test scripts prior to promoting/staging the component into

production.

Environment: IBM MAINFRAME z/OS 900, MVS, MS WINDOWS 2000/XP, COBOL,

DB2/SQL, EDI, CICS/BMS, SPUFI, TSO/ISPF, XPEDITER, MS OFFICE (EXCEL, WORD),

XCEL, CHANGEMAN, EASYTREV, SYNCSORT, CICS and VISIO.

Neiman Marcus, Dallas, TX – February 2009 – July 2009

Programmer Analyst

• Responsible for the conversion merging the Bergdorf Goodman IMS system to the

Neiman Marcus DB2 accounts receivable/accounts payable systems. My duties consist of

analyzing and mapping the financial data feeds, via transaction sets writing Design

documents, writing COBOL/CICS/DB2 programs, training junior programmers and

users on the systems functionalities, attending meetings and JAD sessions and supporting

the management staff on request.

Environment: IBM MAINFRAME z/OS 900, MVS, MS WINDOWS 2000/NT, COBOL/390

Enterprise, COBOL/ CICS/BMS /DB2 /SQL, VSAM, SPUFI, TSO/ISPF, XPEDITER, FTP,

MS OFFICE (EXCEL, WORD, XCEL), MQ Series, XML, SYNCSORT, FILE-AID FOR DB2

and VISIO.

PAGE 3

Obj100

Resume of John W Lewis, Page 4 of 6

Blue Cross Blue Shield of Texas, Richardson, TX – January 2008 – February 2009

Programmer Analyst

• Responsible for the development of the Medicaid (MMIS) IAM Mainframe VSAM

repository is used to medical claims from various vendors via Medical Warning Report.

The repository also house CET (Pharmacy) claims, Provider (PNF) file. Medical claims,

medical warning report, and Provider (PNF) files. BlueGateway produces CET

(Pharmacy) claim file. These files are processed via IAM Mainframe as they are made

available (daily, weekly, monthly, ad hoc). The IAM Mainframe creates a flat file

containing claims data for each of the input files. The flat files are transferred via FTP

(File Transfer Program) to the Encounter Repository Database using B usiness Process

Management (BPM) methodology.

Environment: IBM MAINFRAME z/OS 900, MVS, MS WINDOWS 2000/NT, COBOL/390

Enterprise, DB2/SQL, VSAM, SPUFI, TSO/ISPF, XPEDITER, MS OFFICE (EXCEL, WORD),

XCEL, FILE-AID FOR DB2, ENDEVOR, XML, ZEKE/ZEB SYNCSORT, CICS FTP and

VISIO.

State of Georgia, Atlanta, GA – May 2007 – January 2008

Programmer Analyst/Business Analyst

• Responsible for the State of Georgia Mental Health system. I am currently creating

Systems Requirement Specifications and Detailed Design Documents utilizing MS

OFFICE (EXCEL, WORD and VISIO). From these documents, I created COBOL/

CICS/BMS / DB2 programs. I performed the migration of programs, copybooks, Procs

and control cards to the CHANGEMAN staging areas.

Environment: IBM MAINFRAME z/OS 900, MVS, MS WINDOWS 2000/NT, COBOL III

Enterprise, DB2/SQL, SPUFI, TSO/ISPF, CHANGEMAN, MS OFFICE (EXCEL, WORD),

XCEL, FILE-AID FOR DB2, SYNCSORT, CICS and VISIO.

MBNA/ Bank of America, Dallas, TX & Charlotte, NC – March 2006 – May 2007

Programmer Analyst

• Responsible for the bank merger/conversion of the Online Credit Card system. I mapped

the MBNA IDMS data to DB2 tables and VSAM files to the Bank of America files to be

processed via COBOL CICS/BMS programs. I performed the migration of programs,

copybooks, Procs and control cards to the ENDEVOR staging areas and set up the skid

ids in CA7. I worked the 2 nd and 3rd shifts of a 24/7 testing and production support

effort. Mercury Quality Center (Test Director) is used to track defects that were

immediately resolved to facilitate the continuity of testing.

Environment: IBM MAINFRAME z/OS 900, MVS, MS WINDOWS 2000/NT, COBOL/390

Enterprise, DB2/SQL, Mercury Quality Center, Stored Procedures, SPUFI, TSO/ISPF,

XPEDITER, MS OFFICE (EXCEL, WORD), XCEL, FILE-AID FOR DB2, ENDEVOR, NDM,

MQ Series, EASYTREV, HTML, XML, IDMS, SYNCSORT, PL/1 DB2 Stored Procedures,

CICS and VISIO.

Resume of John W Lewis, Page 5 of 6

PAGE 4

Obj100

Blue Cross Blue Shield of Michigan, Detroit Michigan – November 2005 – March 2006

Programmer Analyst

• Responsible for the Medicaid (MMIS) Claims and Extended Web Features for the

Explanation of Benefits (EOB) and Federal Employee Program (FEP) systems. I created

COBOL CICS/BMS /DB2/IMS/MQ Series programs that captured screen input data

from the Web and GET (read) MQ Series input files then PUT (wrote) MQ Series output

files for the description of benefits by Line of Business. TSO via VISUAL BASIC.NET

connectivity. Created and maintained Crystal Reports. My responsibilities include

requirements gathering, design creation, development and testing and implementation.

EDI transaction (X12N) sets were created and processed.

Environment: IBM MAINFRAME z/OS 900, MVS, MS WINDOWS 2000/XP, COBOL/390

Enterprise, DB2/SQL, CICS, IMS/DB, SPUFI, TSO/ISPF, XPEDITER, MS OFFICE (EXCEL,

WORD), XCEL, VISUAL BASIC.NET ENDEVOR, EASYTREV, FTP, XPEDITER,

SYNCSORT, CICS and VISIO.

SunTrust Bank, Atlanta, GA – January 2005 – November 2005

Programmer Analyst/Business Analyst

• Responsible for the Deposits application Migration and conversion From CHANGEMAN

to ENDEVOR. I also created and modified various COBOL CICS/DB2 programs

while monitoring the APAR testing partition IN CA7 for various applications. Also,

updated XCEL spread sheets from the Main-Frame TSO ($SVRS) via VISUAL

BASIC.NET connectivity. Environment: IBM MAINFRAME 3090, MVS, MS

WINDOWS 2000/NT, COBOL, DB2/SQL, CICS, VAMMIS COBOL, SPUFI,

TSO/ISPF, XPEDITER, MS OFFICE (EXCEL, WORD), XCEL, VISUAL BASIC.NET,

Stored Procedures, CICS and VISIO.

AFLAC, Columbus, GA – July 2004 – January 2005

Programmer Analyst/Business Analyst

• Analyzed the Claims Appeal Process and Fraud Statements System to create detailed

program specifications, test scripts and the Technical Design Document. I also created

and modified DB2/SQL programs and maintained Windows Forms in Visual Basic.net. I

was responsible for system architecture, program design, technical team leadership,

development, documentation, and full life cycle development. My areas of expertise

included Provider, Claims, Forms management, and Eligibility. I used Cobol2, DB2,

QMF, CICS, Stored Procedures, ENDEVOR, File-aide, Expediter, TSO, and JCL in

online and Batch environments. I was responsible for code review, QA testing, Systems

integration testing, and Production Simulation testing.

Environment: IBM MAINFRAME z/OS 900, MVS, MS WINDOWS 2000/NT, COBOL,

DB2/SQL, CICS, Stored Procedures, COBOL, SPUFI, TSO/ISPF, XPEDITER, MS OFFICE

(EXCEL, WORD, PROJECT), XML, XCEL, ENDEVOR, EASYTREV, DB2 Stored Procedures.

CICS and VISIO.

Resume of John W Lewis, Page 6 of 6

PAGE 5

Obj100

State of New York, Albany, NY – May 2003 – June 2004

Programmer Analyst

• Completed the analysis for the rewrite of the legacy Medicaid (MMIS) to process front

end for COBOL DB2 CICS applications. Analysis consisted of frequent Joint

Application Design sessions (JADS) with the users (State of New York Personnel).

Environment: IBM MAINFRAME 3090, MVS, MS WINDOWS 2000/NT, COBOL,

DB2/SQL, HTML SPECBUILDER, EDI, CICS, Stored Procedures El Segundo, XQMF, QMF,

COBOL, SPUFI, TSO/ISPF, XPEDITER, MS OFFICE (EXCEL, WORD, PROJECT), XCEL,

CA-7, XML, ENDEVOR, EASYTREV, CICS and VISIO.

Affiliated Computer Services, Atlanta, GA – June 2002 – May 2003

Programmer Analyst/Business Analyst

• Re-writing and testing several programs that process hospital Claims and Medicare Part A

claims to accept the file formats for HIPAA for the 837 transaction set. I Analyzed the

current system and documented all modifications make the system HIPAA compliant. I

created and maintained programs for the Provider sub-system utilizing COBOL, DB2

and CICS in a legacy conversion effort. I documented and proposed all the requirements

to produce and test transactions (X12N) while maintaining Medicare/Medicaid Claims

systems and forms.

Environment: IBM MAINFRAME z/OS 900, MVS, MS WINDOWS 2000/NT, COBOL,

DB2/SQL, ZEKE/ZEB, EDI, CICS, OWLLIB, TSO/ISPF, XPEDITER, CICS and MS OFFICE

(EXCEL, WORD).

State Of Alabama, Montgomery Alabama – September 1997 – June 2002

Programmer Analyst

• Responsible for technical support of claims processing for Medicare/Medicaid (MMIS)

Year 2000 date conversions. I tested and analyzed the GUI front end that was created by

EDS for MMIS claims processing to make sure the system is HCFA compliant. I

designed, tested and implemented a series of COBOL programs for MMIS check

distributions to establish security and verification of payments. I supported State of

Alabama Child Support collections and Welfare using IDMS ADSO to DB2 CICS

utilizing conversion tool FORCROSS.

Environment: IBM MAINFRAME 3090, MVS V1 R4.0, VISUAL BASIC, COBOL, COBOL

II, IDMS, CICS, TSO, FORCROSS, ISPF, ZEKE/ZEB, SYNCSORT, CICS ENDEVOR and

ROSCOE.

Blue Cross Blue Shield, Birmingham Alabama – December 1996 – September 1997

Programmer Analyst

• Responsible for Prior Carrier Payments Medicaid (MMIS) Claims and Year 2000

conversions. I was Liaison between prior carriers and BCBS-AL for quality assurance to

populate DB2 claims tables with corresponding data from outside subscribers and

vendors. I created reports and XCEL spread sheets for management for claims status and

eligibility. I wrote COBOL programs to strip the information off of reports and files and

program them into BCBS-AL format.

Environment: IBM MAINFRAME 3090, MS WINDOWS 95, MICRO FOCUS COBOL,

COBOL II, SQL, DB2, IMS DB/DC, CICS, SAS, ZEKE/ZEB, SYNCSORT, EASYTREV, and

CHANGEMAN.

PAGE 6

Contact this candidate