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, Confidential, Confidential and DB2 experience.
• Experience
• Offshore team of 8 developers and team lead
• Onshore team of 6 developers
• 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
• Design and develop Oracle database team of 3 DBA’s
• Designed and developed PL/SQL Procedures 2 PL SQL developers
• Team of approx 15 developers using new Confidential 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, Confidential, Confidential and DB2 experience.
• Experience on many different platforms using SQL (mainframe,Unix,Oracle,Microsoft SQL server)

TECHNICAL SKILLS:

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

Databases / File systems: DB2, VSAM, Oracle, UNIX, Windows, Microsoft SQL Server 2005, IBM30XX, 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

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 Confidential jobs to create a segmented file that will be used in the Confidential process
• Confidential files to Unix environments
• Verify Confidential (file transfer) 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
• Confidential 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 ( Confidential ) MQ queues
• 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 Confidential format
• Modified applications to process new version of Confidential Real Time Claim processing
• Development under Agile Project Management tool

Confidential, Chicago, Illinois

Responsibilities:

• Member of Vista group responsibilities: lead mainframe analyst for COBOL, SQL and Confidential 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 Confidential 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, Confidential 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.
• Development under Agile Project Management tool

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, Confidential on ad hoc requests to determine root cause of error
• Order to Cash ( Confidential ) 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
• 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 ( Confidential ) MQ queues 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 Confidential 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 Confidential 5010 format

Confidential, Chicago, Illinois

Responsibilities:

• Data analyst for multiple metrics of the Education 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 Confidential 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
• Fill in as DBA (until DBA was hired
• Perform DBA related functions
• In corporate DB2 Utilities to LOAD and UNLOAD DB2 tables
• Data access conversion
• Develop new DB2 & Non DB2 COBOL programs.
• Liaison for the New York office and Chicago installation of conversion program
• Liaison for the New York office and Chicago installation of DB2.

Confidential, Northfield, Illinois

Responsibilities:

• Design and develop new Cobol applications for the Demand Planning and Supply team (customer Walmart).
• 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

Multi Platform Project Lead Analyst / Developer

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.
• 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 Confidential 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 Confidential to ensure optimal performance
• Optimize newly installed Sterling GenTran DB2 programs and Confidential jobs to ensure optimal performance. Created special Confidential jobs that were incorporated into the Sterling EDI system.
• Designed and developed web pages using Microsoft FrontPage

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.
• Create/ modify COBOL programs or Confidential per user requirements. Review programs and Confidential 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

Senior Consultant/Analyst

Responsibilities:

• Conducted Feasibility study to convert from a Confidential 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

Responsibilities:

• Design and developed on-line Confidential DB2 Securities applications.
• Designed and developed batch applications for Securities Books/Reporting group
• Optimize Confidential, procedures and VSAM files to process more efficiently

Confidential, Bloomingdale, Illinois

Consultant - Team Lead

Responsibilities:

• Designed/developed an on-line Confidential 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

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.
• Worked with Confidential server team

Confidential

Team Lead

Responsibilities:

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

Confidential, Chicago, Illinois

Senior Team Lead / Programmer Analyst

Responsibilities:

• Order Processing system
• Designed new on-line Confidential applications, maps and batch applications
• Initial investigation and development of user requirements
• Liaison for business partners and development groups