TECHNICAL SKILLS:Hardware: IBM Z/900, 9000, 9121, 3090, 3081, 4361, AS/400

Operating System: MVS/ESA, MVS/XA, DOS/VSE, OS/VS, OS/400, Z/OS 390

Language: COBOL 370, COBOL II, COBOL, EASYTRIEVE, DL/1, SAS, RPG/400, MANTIS

Database: DB2, VSAM, TOTAL, IDMS, IMS DB

System Software: EDI, BMC, SQL, SPUFI, QMF, CICS/BMS, GTB, FTP, STORED PROC, PLATINUM, JCL, IBM UTILITIES, SORT, INTERTEST, FILEAID, TSO/ISPF, EXPEDITER, ICETOOL, COMPAREX, ABEND - AID, CHANGEMAN, LIBRARIAN, ENDEVOR, MAINFRAME EXPRESS, MQ SERIES, DCTS, FILE MANAGER, CONTROL-M, ORACLE 11g, PL/SQL DEVELOPER, IBM DEBUGGING TOOL

PROFESSIONAL EXPERIENCE:

Confidential, Merrill Lynch

Software Developer/Analyst

Responsibilities:

• Currently working on the Genesis Loan IQ Project to allow security-based loan transactions (obligor, commitment, obligation, collateral, pool) currently sourced from Automated Financial System ( Confidential ) be processed in the Loan IQ (LIQ) commerical loan system of the bank; Confidential pre-process jobs were created to reformat Confidential loan transactions into LIQ format; modified Genesis and Liquid Management Account (LMA) current process to handle new data feed from LIQ; prepared test plan and expected test results to ensure that all system requirements are tested and documented.
• Responsibilities included analysis, coding and testing batch programs, creating test plans, turning over programs to QA/production.

Environment: Z/OS, COBOL II, DB2, SPUFI, QMF, NDM, SQL, ENDEVOR, CA DB2 Tools, Debugging Tool

Confidential

Software Developer/Analyst

Responsibilities:

• Currently working on the EGS on Connect Project for Confidential ’s EDI system to allow processing of new EDI transaction 814M (Seamless Move); prepared test plan and expected test results to ensure that all system requirements are tested and documented.
• Currently working on the PROC3 Project for Confidential ’S EDI system to allow new Procurement Rate Codes Class 3 to be processed; prepared test plan and expected test results to ensure that all system requirements are tested and documented.
• Currently working on the Net Metering Project for Confidential ’s EDI system to automate the billing process for net metering customers; prepared test plan and expected test results to ensure that all system requirements are tested and documented.
• Currently working on the Gas Account Number Lookup Project for Confidential ’s EDI system to include customer postal information on the Eligible Customer List file; prepared test plan and expected test results to ensure that all system requirements are tested and documented.
• Responsibilities included analysis, coding and testing batch programs, creating test plans, turning over programs to production, and post-production support.

Environment: Z/OS, COBOL II, DB2, SPUFI, QMF, FTP, EDI, SQL, ATMS, CA DB2 Tools

Confidential

Software Developer/Analyst

Responsibilities:

• Involved in the Non-QBS (Quest Billing System) Ordered Code Project to improve Franchise and Commercial reporting capability and accuracy of test profiles and panels. The project involves creation of a process to establish Order Code to Service Code relationship and create a reference file for the revenue interface, this will ensure a more accurate Order Count metric. Utilized PL/SQL Developer and Microsoft Access to inquire on Oracle tables after mainframe files are FTPed to the ETL environment. These mainframe files will be loaded to the Oracle tables in the revenue load process.
• Responsibilities included analysis, coding and testing batch and online programs, creating test plans, turning over programs to production, and post-production support.

Environment: Z/OS, COBOL II, DB2, SPUFI, QMF, BMC, SQL, CICS, PL/SQL, Oracle

Confidential

Software Developer/Analyst

Responsibilities:

• Involved in the creation of detailed design for the ORBIT Single Biller Vision 5 Project for FIOS customers under Confidential ’s Confidential (Customer Accounts Receivable System) billing application. Detailed design documents were created for the development team in the payments, allocations, live balances and write-off processes.
• Involved in creation of post-conversion programs for data requirements not addressed by the ConversonTeam. These post-conversion programs will be implemented to ensure that converted production data are loaded into various DB2 tables as expected by the programs for processing.
• Involved in reviewing test results provided by the development team, this will ensure that all business requirements were addressed during testing before the programs are migrated for ITO/BST testing.

Environment: Z/OS, COBOL II, DB2, SPUFI, QMF, BMC, SQL, CICS, MQ Series

Confidential

Software Developer/Analyst

Responsibilities:

• Involved in the Choice Bundle Project for Confidential ’s EDI system to streamline the validation process of enrollments and history usage requests from suppliers for electric and gas customers; prepared test plan and expected test results to ensure that all system requirements are tested and documented.
• Involved in the enhancement of the EDI process to handle DB2 resource contention issues to eliminate partial rollback of updates made during processing.
• Involved in enhancement of the ECL/ROI process for Gas customers to exclude finaled, pending final, inactive, and written-off accounts from the ECL/ROI file.
• Involved in the Annual Refresh of Strata and ICAP DB2 tables where future PLC and Confidential values will be loaded for all premises numbers.
• Involved in implementing Data Repairs (DRs) to correct enrollment, billing, payments, and usage information as a result of production defects and data transmission issues.
• Involved in resolving DCTS (Document Cycle Tracking Service) issues that may come up from GXS transmission of EDI data between Confidential and the trading partners.
• Involved in providing development support to resolve production issues at the earliest possible time.
• Involved in the Annual Refresh of DCQ DB2 tables where Daily Contract Quantity will be loaded for all premises numbers.
• nvolved in the Eligible Customer List (ECL) Project for Confidential ’s EDI system to include additional customer information in the ECL file as mandated by Pennsylvania Public Utility Commission; prepared test plan to ensure that all system requirements are tested and documented.
• Responsibilities included analysis, coding and testing batch programs, creating test plans, turning over programs to production, and post-production support.

Environment: Z/OS, COBOL II, DB2, SPUFI, QMF, BMC, FTP, EDI, SQL, DCTS

Confidential

Software Engineer/Developer

Responsibilities:

• Involved in the analysis and design phase of the Prescription Drug Plan (PDP) Reassignment Project for 2011 where Medicare Part D beneficiaries currently enrolled in PDP plans that are terminating or increasing in premium are reassigned to a different PDP plan where premium is below or equal to the Confidential benchmark.
• Involved in the analysis and design of Medicare Advantage (MA) Reassignment Project for 2011 where Medicare Part D beneficiaries currently enrolled in MA plans that are completely non-renewing or terminating only in certain counties are reassigned to a stand-alone PDP plan where premium is below or equal to the Confidential benchmark.
• Involved in the Redesign and Modernization of MARX system where the auto-assign system will be enhanced to access new table structures designed for this project. JCLs to load/unload DB2 tables were setup using BMC load/unload utility. BMC was used to seed DB2 tables to create test data for unit/integration testing. BMC was also used to browse/update DB2 tables and inquire on DB2 tables affected by the project requirements. MQ programs were modified to address new DB2 table structures required by the project.
• Involved in the analysis of Part D Gap Coverage project where full dual beneficiaries will be given drug coverage on periods that he is eligible for Part D coverage although a gap exists in his eligibility.
• Involved in the creation of Regression Test Bed for Confidential ’s Automated Testing System (ATS) where a baseline database was setup where results of system and regression testing were compared against to reveal data differences as a result of the application enhancements.
• Involved in the Low Income NET Bene Project where Medicare Part D beneficiaries can apply prescription drug coverage via Point of Sale Contractor serving as another source of beneficiary enrollments.
• Involved in the Reassignment Project where Medicare Part D beneficiaries currently enrolled in Prescription Drug Plans that are terminating or increasing in premium are reassigned to a different plan where premium is below or equal to the Confidential benchmark.
• Involved in the Dual Eligibles Redesign Project where Confidential will run daily basis allowing Medicare Part D beneficiaries to received prescripVtion drug coverage at the earliest possible time. Major enhancements made to the Confidential system is allowing daily feeds from the Deeming application and running Confidential via the Workflow Manager where jobs are triggered by mask files. Programs accessing MQ (message queues) were modified to reflect the daily feed requirement.
• Involved in the Common Tables Project for MBDSS (Medicare Beneficiary Database Suite of Systems) where a common set of DB2 tables will be used across all MBD applications. BMC was used to seed DB2 tables to create test data to support test plans for unit/integration testing. BMC was also used to refresh and load initial data to the affected DB2 tables.
• Involved in the maintenance of the Low-Income Subsidy ( Confidential ) system for Confidential (CMS).
• Involved in the maintenance of the Auto Assign ( Confidential ) system for CMS where low-income subsidy eligibles are auto-assigned to a Part D plan.
• Involved in the maintenance of the Deeming system for CMS where qualified beneficiaries are deemed for assignment to a Part D plan.
• Provided technical support in resolving production problems for Confidential, Confidential, and Deeming systems.
• Responsibilities included analysis, design, coding and testing batch programs, turning over programs to production and providing production support.
• Provided technical support in resolving production problems.
• Responsibilities included analysis, design, coding and testing batch programs, turning over programs to production and providing production support.

Environment: Z/OS 390, COBOL II, DB2, SPUFI, QMF, BMC, SAS, SQL

Confidential

Senior Programmer/Analyst

Responsibilities:

• Involved in the Low-Income Subsidy ( Confidential ) Resynchronization Project for Confidential (CMS). Coded and tested COBOL/DB2 batch programs to evaluate the current status of the Confidential ( Confidential ) and CMS databases and determine the extent of resynchronization needed.
• Responsibilities included analysis, coding and testing batch programs, turning over programs to production and providing production support.

Environment: Z/OS 390, COBOL II, DB2, SPUFI, QMF, BMC, SQL

Confidential

Senior Programmer/Analyst

Responsibilities:

• Involved in the Client Experience Project for Confidential ’s Retail System. Coded and tested COBOL/DB2 batch programs for sales and problem cases.
• Involved in the maintenance of the Enterprise Database via Service Request Update Architecture for Confidential ’s Retail System. Coded and tested stored procedures that retrieve data from the Enterprise Database and passed data to the Mid-Tier platform for the Interactive Statements Project.
• Responsibilities included analysis, coding stored procedures, testing batch programs, system testing, and turning over programs to production.

Environment: Z/OS 390, COBOL II, DB2, SPUFI, STORED PROC, SQL

Confidential

Senior Programmer/Analyst

Responsibilities:

• Involved in the IMS to DB2 Conversion project for Confidential . This project will convert all batch IMS programs to DB2 for the Child Support Enforcement System applications including eligibility, entitlement, awarding, billing, accounting, reporting, and re-evaluation.
• Involved in the maintenance and production support of the Child Support Enforcement System to ensure that the system is up and running at the earliest possible time.
• Utilized MS Word and Excel to document testing i.e. test data, test plan, and expected results.
• Responsibilities included analysis, coding, testing batch programs, system testing, conversion, and turning over programs to production.

Environment: MVS/ESA, COBOL II, DB2, IMS, SPUFI, SQL

Confidential

Senior Programmer/Analyst

Responsibilities:

• Involved in the SUMS CDR ODS project for Confidential ( Confidential ). This project will provide comprehensive management information on Title II and Title XVI disability post-entitlement workloads and work-related continuing disability reviews.
• Involved in the SUMS Appeals project for Confidential . This project will provide consolidated and comprehensive management information for all levels of the appeals workload.
• Involved in the maintenance and production support for the Modernized Supplemental Security Income Claims System (MSSICS) of Confidential . MSSICS is an online system used to collect and process supplemental security income initial claims applications as well as post-eligibility actions.
• Involved in the maintenance and testing of online modules for the Associated Remarks project which allows the claim representative to update the claimant’s remarks after the claim has been printed.
• Involved in the maintenance and testing of online modules for the Expansion of Computational History project which allows the system to handle more than 10 years of computational history data differences.
• Involved in the maintenance and testing of online modules for the Claim Type Update project which allows processing of a temporary storage queue (TSQ) in lieu of the Person Data Element Cluster (DEC) to hold claim type information.
• Analyzed and investigated production problems involving CICS storage violations and recommended solutions to fix the problem and prevent these from happening.
• Utilized MS Word and Excel to document testing i.e. test data, test plan, and expected results.
• Responsibilities included analysis, coding, testing batch/online programs, user interface, system testing, production support, and turning over programs to production.

Environment: MVS/ESA, COBOL II, COBOL III, CICS, DB2, GTB, SPUFI, SQL

Confidential

Senior Programmer/Analyst

Responsibilities:

• Involved in the maintenance and testing of batch/online modules for the Loans Offer Processing (LOP) system of Confidential (Freddie Mac).
• Involved in production support for the LOP system to resolve production problems that may occur from time to time.
• Utilized MS Word and Excel to document testing i.e. test data, test plan, and expected results.
• Responsibilities included analysis, coding, testing online programs, user interface, system testing, production support, and turning over programs to production.

Environment: MVS/ESA, COBOL II, CICS, IMS, DB2, VSAM, SAS, DL/I, SQL, EASYTRIEVE

Confidential

Senior Programmer/Analyst

Responsibilities:

• Involved in the development and testing of data migration/interface modules for the Sales Forecasting, Purchase Order, and Accounts Payable System for the LINK Project to address data loads and updates to/from the MVS and SAP platforms. DB2 tables and VSAM files were used as input to these migration/interface modules.
• Involved in the development and testing of modules for the Bill For Commitment Project which allows non-delinquent accounts to be charged a fee and billed when they fail to meet their agreed commitment requirement within a given time.
• Involved in the Confidential / Confidential Inc. ( Confidential ) System Integration Project which covers maintenance of existing Confidential ’s online system to accommodate Confidential ’s online processing requirements as a result of a buy-out. Major enhancements were made in the Customer Information, New Enrollment, Inventory Control, and Order Entry online systems.
• Utilized MS Word and Excel to document testing i.e. test data, test conditions, test cycles, test plans, expected results, and problems encountered.
• Prepared program specs for migration/interface modules.
• Responsibilities included analysis, creation of online maps, coding and testing batch/online programs, user interface, acceptance testing, and turning over programs to production.

Environment: MVS/ESA, COBOL 370, COBOL II, CICS, DB2, SQL

Confidential

Senior Programmer/Analyst

Responsibilities:

• Involved in the major enhancements to the government trading system for Confidential . (PSI) which allows companies other than PSI to trade and clear through the system.
• Involved in the development and testing of batch/online programs for the online trade-entry system.
• Involved in the Y2K enhancements for the government trading system.
• Prepared program specs for batch programs and reports.
• Utilized MS Word, Excel and Access to document and setup test data, test conditions, test plans, and test cycles and problems encountered.
• Performed system analysis, creation of online screens, coding and testing of batch/online programs, user interface, user acceptance, acceptance testing, and production/post-production support.

Environment: MVS/ESA, COBOL II, CICS, VSAM, DB2, SQL