SUMMARY:

Designed, developed, and implemented various projects in Integrated Database Management System (IDMS) and CICS.Applications include Federal, Financial, Brokerage, Shipbuilding, Broadcasting, Entertainment Media, Medical Management, Insurance, Aerospace Management System, Education, Retail and Order Entry System. Developed Crystal Reports (v.10) using SQL.

TECHNICAL SKILLS:

Language: ADSO, CICS, DC - COBOL, COBOL II, SQL, VSAM, JCL, DB2EASYTRIEVE PLUS, LRF. Learning Python.

Utilities: PowerCenter, Power Exchange, SQL Developer, ADSC/ADSG, DME, DMLO, IDD, MAPC, OLP, OLQ, ADSA, ONLINE DEBUGGER, WORD, TOAD, MVS/TSO, FILEAID, PANVALET, BMS, SDF II, SYNCSORT, IEBGENER, IEFBR14, SPUFI, ENDEVOR, INTERTEST, XPEDITOR, CA7, CA11, VM/CMS, ICETOOL, INSYNC, FTP, ACCESS, EXCEL, NDMBATCH, CA FILE MASTER PLUS, Eclipse.

EMPLOYMENT EXPERIENCE:

Advanced Engineer

Confidential, Fairfax, Virginia

Responsibilities:

• Assigned to the Confidential Central Index System.
• Participated in release planning meetings, release retrospectives, sprint planning meetings, sprint retrospectives and daily stand up meetings.
• Conduct software and test script peer reviews of COBOL programs, JCLs and PROCS.
• Development of software including coding, testing and migrating software to FQT, SYST, Training and Acceptance environments.
• Was part of a support team for the system conversion from mainframe to Oracle database which included translation of mainframe code to functional test cases for the new system. Also took part in testing the new code written in JAVA using Postman.

Advanced Engineer

Confidential, Oakton, Virginia

Responsibilities:

• Assigned to the Confidential Central Index System.
• Participated in release planning meetings, release retrospectives, sprint planning meetings, sprint retrospectives and daily stand up meetings.
• Conduct software and test script peer reviews of COBOL programs, JCLs and PROCS.
• Development of software including coding, testing and migrating software to FQT, SYST, Training and Acceptance environments.

Mainframe Consultant

Confidential, Herndon, Virginia

Responsibilities:

• Assigned to the MBS POOL System to support the Security Pools for Single Family and Multifamily using IDMS COBOL under Agile Methodology.
• Duties included the upgrade and analysis of the extract and load using COBOL programs to refresh lower environments with production data and the modification of jobs with interface with MPS Pool System to downstream servers.

Principal Consultant

Confidential, Vienna, Virginia

Responsibilities:

• Assigned to the Confidential to transfer USCIS data to Oracle Database(11g) using Informatica tools.
• Duties included monitoring and maintaining jobs running in the mainframe and creation of datamaps in Power Exchange and ETL mappings in PowerCenter to load source data to target database and used SQL Developer to perform data verification.
• Wrote extract from IDMS database and compare COBOL programs to be used as an alternate to Change Data Capture process and wrote ETL mappings using flat files to Oracle.

Mainframe Consultant

Confidential, Raleigh, North Carolina

Responsibilities:

• Part of a mainframe production support team to resolve user issues using COBOL IDMS/CICS/DB2 and Easytrieve.
• Duties included modifying JCLS, PROCS, and CONTROL members to convert data transfer using NDMBATCH process

Programmer Analyst

Confidential, Newport News, VA

Responsibilities:

• Developed, maintained and supported mainframe applications using IDMS COBOL, DC-COBOL and ADSO.
• Provided production support that included on-call responsibilities using COBOL and JCL.

Programmer Analyst

Confidential, Newport News, VA

Responsibilities:

• Involved in developing applications for the mainframe using IDMS ADSO, DC-COBOL, MQ-Series, FTP and DB2.
• Duties included developing, enhancing, and testing production programs, conversion of the Workers Comp system using APS/DB2.
• Was part of a two- person development team until we were merged with the production support staff after the spin-off from Confidential in March 2011

Mainframe Consultant

Confidential, Jersey City, NJ

Responsibilities:

• Maintained the Cage Management System using IDMS ADSO and DC-COBOL.
• Duties included enhancing, testing, and debugging production programs.
• Researched, coded, and tested extended run-units of pre-existing applications to ensure data integrity written in ADSO/DC-COBOL and supported user’s requirements to updated Batch/DC COBOL programs, procedures, and JCLs.

Mainframe Consultant

Confidential, Burbank, CA

Responsibilities:

• Maintained the Theatrical Distribution System using IDMS ADSO and COBOL. Made modification to JCL procedures using TSO. Debugged and modified programs according to user requirement.
• Enhanced and developed ADSO and COBOL programs for the International Television Distribution System. Duties included making changes to JCL procedures.
• Developed Crystal Reports (v.10) for the Media Advertisement Tracking System which replaced the Theatrical Distribution System. Wrote SQL queries to retrieve information from an Oracle 10g database. Used drilldowns, sub-reports, cross tabs, formulas, parameters and views.

Mainframe Consultant

Confidential, New York, NY

Responsibilities:

• Performed enhancements to the Empire BlueCross BlueShield Manage Care System to meet user change requests using IDMS ADSO, COBOL II and JCL.
• Wrote specifications and modified existing CICS/IDMS COBOL applications to be HIPAA compliant and eliminate dependency of Global records. Updated all modules to provide MQ functionality and wrote CICS MQ-Series programs to facilitate testing of HIPAA project.
• Wrote specification and program to load HIPAA information to a IDMS/R database using COBOL III CICS/IDMS.
• Wrote specifications and programs to display HIPAA information using IDMS ADSO.
• Used ISPF/TSO for text editing.

Mainframe Consultant

Confidential, New York, NY

Responsibilities:

• Performed enhancements to Television Network Sales system to facilitate the selling of commercial units on owned cable Networks using IDMS ADSO and COBOL II.
• This required new programs and modifications to existing functions to handle the differences in scheduling, program inventory, pricing, calculations of ratings and impressions and management reports.
• Coded programs and JCL procedures to extract the commercial codes and positioning data from the IDMS database and VSAM using COBOL II.
• Coded online functions using VSAM/IDMS/CICS to allow New York Sales to transmit the commercial codes and commercial positioning files on request.
• These submittal online functions for the batch procedures that executes programs to extract data from the database.
• Coded online program using COBOL II CICS/IDMS to allow online submission of report programs written in IDMS COBOL/DB2.
• Modified DB2 programs using SQL.

Systems Analyst

Confidential, New York, NY

Responsibilities:

• Enhanced the Student Information System using IDMS COBOL II and ADSO.
• Used ROSCOE for text editing.