PROFESSIONAL SUMMARY:

• Project Lead (VSAM/IMS to DB2 conversion) for major health care insurer
• I have very strong leadership skills.
• One of my best attributes is working well with people and enjoy the opportunity to share my knowledge.
• Highly skilled and qualified data & programmer analyst, with over 30 years experience in the mainframe arena.
• Exceptional analytical and development skills
• Extensive COBOL, JCL, CICS and DB2 experience.
• Experience
• Offshore team of 8 developers and team lead
• Onshore team of 6 developers
• Team Lead
• MQ series processing team of 4 developers
• Create DB2 SQL’s to process data retrieved from MQ
• Translate COBOL DB2 programs from legacy system to be written by Ab Initio developers 5 developers
• Project Lead (Full life cycle project design/develop new system to process EDI acknowledgements)
• Design and develop Oracle database team of 3 DBA’s
• Designed and developed PL/SQL Procedures 2 PL SQL developers
• Project Lead / Mentor
• Team of approx 15 developers using new IBM tool VisualAge (Webshpere)
• Mentor team on use of tool and business requirements
• I have very strong leadership skills.
• One of my best attributes is working well with people and enjoy the opportunity to share my knowledge.
• Highly skilled and qualified data & programmer analyst, with over 30 years experience in the mainframe arena.
• Exceptional analytical and development skills
• Extensive COBOL, JCL, CICS and DB2 experience.
• Experience on many different platforms using SQL (mainframe,Unix,Oracle,Microsoft SQL server)

TECHNICAL SKILLS:

Programming Languages: COBOL, COBOL II, CICS, SQL, Oracle PL/SQL, Unix scripting(light), JCL,T - SQL, Stored Procedures

Databases / File systems: DB2, VSAM, Oracle, UNIX, Windows, Microsoft SQL Server 2005IBM30XX, IBM9XXX, Z/OS, OS390, MVS, OS/2, Windows7/8, UNIX, MS SQL Server 2005, Oracle SQL Developer

PC Software: EXECL, Word, Microsoft Project (light), VISIO

Utilities and Tools: Rapid SQL,TOAD, Xpediter, File-Aid, Intertest, MQ series, QMF, SPUFI, Sync Sort, TSO MVS Utilities

PROFESSIONAL EXPERIENCE:

Confidential - Chicago, Illinois

Responsibilities:

• Assigned to perform analysis on existing programs processing both Datacom and VSAM data
• Apply modifications programs by applying logic from the analysis stage
• Develop programs to access Datacom DB to populate files
• Create JCL jobs to create a segmented file that will be used in the NDM process
• NDM files to Unix environments
• Verify NDM of files

Confidential - Chicago, Illinois

Responsibilities:

• Assigned to perform analysis on existing programs processing both DB2 and VSAM data for multiple groups
• Apply modified program changes to upcoming releases. Usually due to mandates issued by the government
• NDM files to production, FTP files to server to be processed by McKesson software for editing
• A form of EDI process prior to FTPing the file it is run through translator. Translator converts incoming delimiter to one McKesson recognizes
• Developed programs to load MQ queues, Drain (MQGET) MQ queues
• Modified existing programs: access data transmitted via CICS channels and MQ and series all data was processed to comply with Federal and Medical mandates.
• Develop specs for programs
• Generate test cases with the assistance from the SME
• Modified applications to process new version of CXT 6.0 format
• Modified applications to process new version of NDC format
• Modified applications to process new version of Blue Chip Real Time Claim processing

Confidential - Chicago, Illinois

Responsibilities:

• Member of Vista group responsibilities: lead mainframe analyst for COBOL, SQL and JCL conversion to Ab Initio.
• Translate the function and process of the Cobol programs and DB2 SQL (cursors, Fetch) for them to be converted by programmers to Ab Initio process/modules.
• Create spreadsheets, word document defining the JCL jobs / procs that process that currently execute on the mainframe. These were used by the Ab Initio developers to create Ab Initio processes
• Breakdown the mainframe job scheduler to be used in Autosys.
• Analysis on programs, JCL and data as they executed in test environment to determine root cause of error (cobol/DB2) or Ab Initio.
• Liaison for mainframe and Ab Initio teams.

Confidential - Chicago, Illinois

Responsibilities:

• Member of OFS group responsibilities
• Assist in converting SQL from legacy to SQL procedures
• Analyze and correct data (DB2 tables)
• Determine cause of failure for ‘Open’ ticket/incidents
• Resolve and ‘Close’ ticket/incidents (repopulate/modify DB2 data)
• Analysis on programs, jcl on ad hoc requests to determine root cause of error
• Order to Cash (OTC) team has primary responsibility for CMS legacy.

Confidential - Chicago, Illinois

Responsibilities:

• Design specs for legacy system (COBOL,DB2) conversion to be processed by XML
• Created documentation to develop Dynamic SQL data for new version web tool
• Converted SQL from COBOL programs to called stored procedures via XML
• Debug and modify all SQL
• Generated SQL, in-house tool created SQL modules, which was converted to XML
• Use Rapid SQL execute xml for each module, verify data retrieved in the result set create SQL statements for as hoc data retrieval and correct data
• Created Detailed Tech Designs based on client specs to build and populate Data Warehousing tables. Documents provided the data definition of the tables (Staging tables) that were to be loaded to the production tables.
• Verify data conversions were correct and processed properly
• Generate and create test cases and test data
• Developed DB2 mainframe program to create files from DB2 tables. Files are written to a server, which is then ‘Pulled’ from the server to be processed in the Unix environment.

Confidential - Chicago, Illinois

Team Lead

Responsibilities:

• Develop new MQ message processing programs for the Real Time Adjudication / Medical Liability Estimator (RTA/MLE) system
• Developed programs to load MQ queues, Drain (MQGET) MQ queues
• RTIS (real time input system) utilizing MQseries DB2 analysis to process real time claim processing
• Modified existing programs: access data transmitted via MQ series translated data into data fields to access and populate DB2 tables all data was processed to comply with Federal and Medical mandates.
• Create ad hoc JCL to load and process the MQ queues
• Verify and validate data existence on DB2 tables
• Develop specs for programs
• Generate test cases with the assistance of the SME
• Modified applications to process new version of ANSI 5010 format

Confidential - Chicago, Illinois

Responsibilities:

• Data analyst for multiple metrics of the Dashboard process
• Determine data flow to load tables
• Create Staging tables and Dimensional table
• Create SQL to load tables, files to transfer data to staging/dimensional tables residing in different instances(environments)
• Generate specs and table layouts
• Create Stored Procedures

Confidential - Chicago, Illinois

Responsibilities:

• Assisted in the analysis of new DB2 SQL processes
• Replicate production process to test new data being loaded to DB2 tables (compare to VSAM data)
• Modify programs to process newly acquired plan(s)
• Modify JCL as plans are added to the processing system

Confidential - Chicago, Illinois

Project Team Lead and Technical Analyst / Developer

Responsibilities:

• Generate Design specs and table layouts
• Develop programs for new conversion systems from VSAM/IMS to DB2
• Perform DBA related functions
• In corporate DB2 Utilities to LOAD and UNLOAD DB2 tables
• Develop new DB2 & Non DB2 COBOL programs.
• Design and develop new Cobol applications for the Demand Planning and Supply team.
• Create jobs and procedures to process files and DB2 tables.
• Create files on mainframe and FTP them a Unix environment for Forecasting process

Confidential - Chicago, Illinois

Project Lead

Responsibilities:

• Full life cycle project design/develop new system to process EDI acknowledgements received via MQ from mainframe routed to UNIX. Created PL/SQL procedures, Oracle tables, Oracle jobs and triggers, file directories and e-mail functionality.
• Full life cycle for a new system. This effort was to create a new processing system in an Oracle/Unix environment. Developed core processing Oracle procedures (PL/SQL) ( aprox. 30 procedures, 12 jobs, 10 triggers and 50 tables, shell scripts and triggers for the UNIX environment. Team size 10
• Create ETL Designed and developed PL/SQL Procedures to perform ETL (extraction, transformation, and loading) function to Oracle databases for multiple projects.
• Responsible for developing and implementing CICS Cobol coding standards and BMS map edits. Develop new programs and maps for a new check processing system.
• Lead analyst review/modify existing DB2 and VSAM programs and JCL to ensure optimal performance
• Optimize newly installed Sterling GenTran DB2 programs and JCL jobs to ensure optimal performance. Created special JCL jobs that were incorporated into the Sterling EDI system.

Confidential - Phoenix, Arizona

Design Architect / Lead developer

Responsibilities:

• Design, analysis and development for new online processing for the Fee Assessment, Net Position, Participant-Setup and Transaction Cycle Maintenance teams using Visual Age.
• Data flow design using VISIO
• Liaison for user groups and development group.
• Mentor for the Fee Assessment, Net Position, Participant-Setup and Transaction Cycle Maintenance teams.

Confidential - Chicago, Illinois

Programmer Analyst

Responsibilities:

• Developed project plan to determine the scope of the project and resources necessary to renovate client’s in house programs. Established the policies and procedures to renovate programs. Created matrix used in renovating programs and testing (unit and string). Implementation three weeks ahead of schedule. Team size 3.
• Create/ modify COBOL programs or JCL per user requirements. Review programs and JCL performance enhancement.
• Performed analysis and wrote programs to convert newly acquired banks to the client’s chart of accounts.

Confidential - Riverwoods, Illinois

Programmer Analyst

Responsibilities:

• Designed/developed applications accessing DB2 tables creating files for the Account Balance Transfer, Register and Products Insurance groups.
• Assist integration team to establishing and implement the test environment.

Confidential - Chicago, Illinois

Team Lead

Responsibilities:

• Conducted Feasibility study to convert from a CICS VSAM mainframe system to a client/server based platform using IBM’s Visual-Age creating GUI based Customer Order and Inventory tracking system..
• Trained consultants and employees on coding using Visual-Gen

Confidential - New York, New York

Team Lead - Securities Books & Reporting

Responsibilities:

• Design and developed on-line CICS DB2 Securities applications.
• Designed and developed batch applications for Securities Books/Reporting group (USA and ASIA).
• Optimize JCL, procedures and VSAM files to process more efficiently

Confidential - Bloomingdale, Illinois

Consultant - Team Lead

Responsibilities:

• Designed/developed an on-line CICS and batch claims processing system. One of the main functions was to verify that charges submitted by visiting physicians, therapists etc fell within median average range. If not the charges would be considered invalid and payment would be suspended.
• Designed/developed a sub-system reporting claims

Confidential

Project Lead Development & Test team

Responsibilities:

• Lead team of 12 developers and 8 testers
• Designed/developed & implemented procedures and migration process
• Developed a test environment and test procedures.
• Established testing procedures (creating scripts and instructions on Debugging). All applications new and modified were reviewed and tested by my group.

Confidential

Team Lead

Responsibilities:

• Designed/developed an on-line CICS system for financial institution interfacing with the Voice Recognition Unit (VRU)
• Designed/developed a "mini" EDI translator for ANSI ‘820’ data.
• Developed data application to process and convert data transmitted by outside source to First Chicago’s format

Confidential - Chicago, Illinois

Team Lead

Responsibilities:

• Order Processing system (Arthur Anderson’s DOS)
• Designed new on-line CICS applications, maps and batch applications
• Initial investigation and development of user requirements
• Liaison for business partners and development groups

Confidential - Atlanta, Georgia

Senior Software Analyst Consultant

Responsibilities:

• Develop/design CICS applications for a new release of the Custom Order Process system
• Onsite Client consultant
• Lead data analyst to improve the efficiency of VSAM files processing.

Confidential - Atlanta, Georgia

Programmer Analyst

Responsibilities:

• Defined requirements for new promotion and commission system (full life cycle) for on-line CICS/VSAM system
• Initial investigation, development of new on-line CICS Distribution system
• Maintain existing applications for both on-line and batch systems
• Lead analyst for ABC audits (Special Audits for the Print Media).

Confidential - Scottsdale, Arizona

UFO Administrator, Programmer II

Responsibilities:

• Administrator of on-line system using UFO. System controlled all the levels of business Inventory, transport/delivery of shipments, donor confidentially and other various areas.
• Initial investigation, development of new UFO on-line applications