SUMMARY

• Over 19 years of IT experience in the United State spanning multiple platforms, projects, objectives, and companies.
• Expertise in all phases of the systems development life cycle in the mainframe environment. I have technical strengths and the ability to work in a legacy application environment. With significant experiences in multiple industries, including but not limited to: manufacturing, insurance, government and financial institutions. I have been involved in projects that produced superior results even in systems that require the strongest analysis, design, programming, and user contact skills in third and fourth generation languages, database, and production control arenas.
• Worked with Confidential, Set up new interface between Accounting payment system, PeopleSoft HR application, & Supply Chain system in SAP
• Involved in decommissioning project for Confidential Motors, Which includes Reverse Engineering of Time and Attendance, and Payroll applications
• Industries: Insurance, Finance, Education, Steel manufacturing, heavy Appliances Manufacturing, Retail, Warehousing, & Government.
• Functional Areas: Warehousing, Material handling, Transportation Steel product manufacturing, Home Appliances manufacturing, Accounting, Insurance Claim, Banking, Managing life Insurance policies, Electronic Data Interchange (EDI).Human Resources
• Methodologies: Water fall, Agile, Application Management Methodology (AMM), Productivity Management

TECHNICAL SKILLS

Application Development Tools: TSO, ISPF, ICCFApplication Package CAS, Sterling Integrator, GENTRAN FOR EDI

Databases / DB Tools: IDMS for application development with Database Design & some IDMS DBMS Administration, DB2, IMS, WDI, QMF, ENDEVOR, CHANGEMAN, CA - PLATINUM

Desktop Tools: Microsoft Office, VisioHardware IBM PC, IBM 3090, IBM ES 9000 OS-390

Methodologies / Techniques: Water fall, Agile, Application Management Methodology (AMM), Productivity Management

Network Software / Communications: MQ SERIES, FTP, VAN, GXS, TCP/IP

Operating Systems: Windows 7, MVS, TSO/ISPF, DOS/VM, / VSE, Z/OS

Programming Languages: COBOL, COBOL-II, MICRO FOCUS COBOL, JCL, CICS, CICS TS WEB 5.2 FOCUS

Testing Tools: LOAD RUNNER

Utilities / Command Languages: MF UTILITIES, IDCAMS Use access method services for catalogs, IEBCOPY utility Copy libraries, IEFBR14

Other: Websphere Data Interchange, EDI Mapping

PROFESSIONAL EXPERIENCE

Confidential | Mossville, IL

Mainframe Developer / Support Analyst

Responsibilities:

• Worked EDI Gentran transition from Mainframe system to new EDI system Sterling Integrator It includes
• Data Validation Data Mapping
• Run data extracts from current system
• Created scripts, jobsto automate the extraction
• Loaded extracts into the new system using ETL tools or DB2 SQL loader with bulk loading with JCL .
• Conducted internal data validation checks including business rules and referential integrity checks
• Handled EDI transactions such as 850, 210, 810,832, 843, 824, 840, 830, 860, & 997 and onward
• Processing in the Mainframe System.
• Set up new interface between Accounting payment system, PeopleSoft HR application, & Supply Chain system in SAP
• Load Invoice to remittance Database / Remove from the due Database
• Load wage Garnishment & workers compensation payment records.
• Print remittance advises for both SCF & Non SCF Suppliers.
• Sending EFT payments to JPM Chase
• Sending SCF invoices to JPM Chase
• Managing check numbers on all payments
• General Ledger Payment Load
• Determining Pre paid invoice due to Match Grief or Price Grief
• Determining Debit Balance Suppliers
• Determine Assignment for EDI Interface with SAP, other Mainframe legacy System, and Suppliers
• Define requirements& design Document changes
• Determine Test Changes using proper Data, include all conditions
• Test Results Check out
• Make sure, new Changes installed, working properly in the Production System
• User review Test Output
• Install changes
• Put all pieces of changes to Production
• Run Test again using change Modules
• Verify Results
• Check Production runs until comfortable with the results.

Environment: Application is written on DB2, IMS DB/DC, COBOL, VSAM, JCL, MVS, CICS, SQL Other than that following tools are being used to support application - ABENDAID, FILEAID, RLOAD, SPUFI, QMF, JES3, AJS, CA-VISION, ChangeMan, MQSERIES, REMEDY, CA-PLATINUM, DB2 STORED PROCEDURE, FTP, Connect Direct, NDM,, Used Agile methodology for Developing Project

Confidential | Marysville, OH

Sr. Mainframe Developer

Responsibilities:

• Confidential has initiated North America Time and Labor (NA T&L) project to upgrade their existing Time & Attendance and Payroll systems. The time and attendance system is used to record associate’s work hours at manufacturing plants HAM (MAP, ELP and AEP), EGA, HMA, HPPG and HMIN in the United States. The payroll system is used to calculate Payroll for all Confidential associates and Japanese employees.
• Involved in decommissioning project for Confidential Motors, Which includes Reverse Engineering of Time and Attendance, and Payroll applications. The current applications are built on COBOL, DB2 Plate form, have a several interfaces with other application, inside and Outside Confidential .
• Worked very closely with the Business, & collected useful information for the Current Application, & Execution for human Resources Application in Specific, Time & Labor
• Performed Data Mapping for the current and the New Cloud based Koronos System using UML Diagrams (Use Case Diagrams, Activity Diagrams, Sequence Diagrams) using MS Visio ..

Environment: Application is written on DB2, CICS, COBOL, VSAM, JCL, MVS, SQL SAS, Other than that following tools are being used to support application - FILE MANAGER, ABENDAID, FILEAID, RLOAD, SPUFI, QMF, CA-7, CA-VIEW, CA-ENDEVOR, MQSERIES, FTP, Z/OS, & TCP/IP.

Confidential | MI

Senior Mainframe Analyst

Responsibilities:

• In the six years at Confidential I worked on several applications, Mainly EDI Mainframe system, Confidential Manufacturing Application, and Credit Memo system.
• Worked for 3 years on the EDI project, description is mentioned below
• EDI migration Mainframe Project, which took whole EDI application migrated and outsourced IBM, it involves extensive analysis, testing, and facilitating implementation of new application. It includes
• Used UML Diagrams (Use Case Diagrams, Activity Diagrams, Sequence Diagrams) using MS Visio for EDI process.
• Run final extracts from the current system
• Executed specific customizations on target database
• Run pilot migrations
• Loaded extracts into the new system using SQL loader with bulkloading functions
• Reported exceptions to client team
• Reviewed migration validation reports and metrics
• Record count verifications on the new system
• Reconciled or resolved any exceptions or unexpected variations
• Before Migration project started, being an application owner, supported
• 24X7 EDI application for Confidential .
• Designed, tested, and implemented EDI maps in order to migrate data processing from mainframe.
• Controlled all file transfer with all clients, including all Inbound/outbound data exchanges, management of layouts and data dictionaries, and all financial files.
• Lead all integration initiatives, and provide guidance during all stages of the life cycle of a project. Tailored methodologies and handle issues to customer’s needs
• Maintain and developed / GENTRAN / WDI for Mainframe Trading Partners and transaction maps.
• Communicated with the VAN (Value Added Network) to ensure constant communications.
• Worked closely with the SAP team to develop EDI to SAP maps (Inbound outbound)
• Automation of new client file exchanges, including data washes, file exports, and reporting.
• Increased productivity through implementation of custom Programming solutions aimed at reducing time spent running manual processes, troubleshooting, and error resolution.
• Successful automation of file uploads/downloads across various Network types using multiple file exchange methods.
• Lead documentation initiatives to ensure all electronic exchanges and processes were documented in full
• Offer suggestions on the streamlining of processes through automation, custom programmatic solutions, and training in necessary areas to more successfully fulfill EDI role.
• Created and maintain a wide variety of documentation to use by the EDI and associated departments.
• Using IDOC, I used to confirm the data elements that are needed to be mapped between the EDI transactions and the associated IDocs. Using Idocs I Used to verify that the transactions are working properly, performed testing, and documented the test results.
• Worked upon the configuration of SAP IDOC to X12 mappings specifically for: 850, 855, and 810, 210, 214 type transactions.
• Worked on SAP module of Sales and Distribution, Worked very closely with the Business
• Application is written on DB2, IDMS DB/DC, CICS, COBOL, VSAM, JCL, MVS, SQL, EDI, WDI (IBM WebSphere) / GENTRAN, TSO/ISPF
• Following tools are being used to support application.
• ABENDAID, FILEAID, RLOAD, SPUFI, QMF, CA-7, CA-VIEW, CA-ENDEVOR, MQSERIES, FTP, FAULT ANALYZER, TWS, & TCP/IP.
• Before start working upon EDI project, I worked on the Confidential Manufacturing System, which is based on the IDMS, and DB2 Data based system,
• Performed Enhancement, coding, testing, and implementation of changes in the Production System, the period lasted for three and half years. Confidential manufacturing system is a very large and complex application,& requires extensive MF experience, and skills.
• Worked upon Credit memo system, which is also a Mainframe application, written in CICS, COBOL, VSAM and DB2.
• During this period, performed following
• Develop high level design document from the client request.
• Perform design walk through with the client.
• Identified and removed the functionality and its corresponding programs that interact with an old VSAM database which has already been replaced by the DB2 in the listed derivatives application. Fixed Change requests and ad-hoc requests from clients. Performed implementation and fixed post implementation bugs.

Environment: Application is written on DB2, IDMS DB/DC, CICS, COBOL, VSAM, JCL, CA-7, MVS Operating system Z/OS, SQL, EDI, WDI (IBM Websphere, Other than that following tools are being used to support, ABENDAID, FILEAID, RLOAD, SPUFI, FAULT ANALYZER, QMF, CA-7, CA-VIEW, CA-ENDEVOR, MQSERIES, FTP, & TCP/IP.

Confidential | Eden Prairie, MN

Sr. Mainframe Developer

Responsibilities:

• Responsible for application support 24X7 for Third party accounting application for Confidential Pharmacy Stores;
• TPA is a Pharmacy accounting application for Confidential deals in Account receivable and Accounts payable for Confidential .
• All accounting activities recorded into Pharmacy Stores are sent over to Mainframe Host, and data later is being transferred over to TPA application. The application is used to manage accounts receivables from third party prescription payment plans. The application is critical to Confidential ’s cash flow situation. The application handles high volume, both in terms of the number of transactions which go through the system and the number of dollars cleared after reconciliation process. Each month, 6-10 million transactions go through the system and $ million in receivables are cleared
• Performed development, maintenance and enhancement for the Data Ware Housing Accounting and, Transportation application.
• Provided analysis, Problem resolution, Programming and testing.
• Worked closely with user departments, troubleshooting problems and new or improved applications.
• Learned Data Ware housing, and its connection with Finance connection

Environment: Z/OS, ABENDAID, ALCHEMIST, FILEAID, Lotus Notes Data Base, FILEAID FOR DB2, DB2 STORED PROCEDURE, RLOAD, SPUFI, QMF, ESP, CICS, CA-EASYTRIEVE, SAR, INFOPAC, CA-ALCHEMIST, Control-M, XCOM, MQSERIES, FTP, & TCP/IP.

Confidential | Benton Harbor, MI

Sr. Mainframe Analyst / Programmer

Responsibilities:

• Maintain and enhance the current IDMS/CICS/COBOL/VSAM/DB2 Mainframe (OS/390) production environment.
• Performing data extracts, from IDMS databases, from VSAM sources, from multiple sources, some based on effective-dated source records.
• Pulled data from VSAM files for Clear data evaluation.
• Data Cleansing of Marketing application, write several Batch programs for it
• In addition, aiding in the analysis and design to facilitate the transition of Service Contract Mainframe Systems and interfaces to a new package in a Sun/UNIX/Oracle based environment. As a sole responsible for the Service Contract application, I have a proven track.
• Record in delivering quality, efficient systems within project deadlines and within the Allocated budget.
• Responsible for the production support 24/7 on call for the Service. Contract application and weekend support for the following applications.
• Marketing Batch Application
• Marketing Client Application
• Quality of Service Application
• Warranty Service Application.
• Earlier on the same assignment, engaged in the maintenance and support for the Products application. These applications are legacy applications written using IDMS, DB2, COBOL-II VSAM, and CICS software.
• Learned and gain in depth knowledge for Marketing, and Warranty Applications

Environment: COBOL II, CA-7, VSAM, JCL, MVS, IDMS DB/DC, TSO/ISPF, IDMS 14.2, CHANGEMAN, DB2, SQL, SPUFI, QMF, CA-PLATINUM, CICS, ABENDAID, FILEAID, Windows NT, VISIO, TEST DIRECTOR, Z/OS, & TCP/IP.

Confidential | Hennepin, IL

Senior Developer and Support Analyst

Responsibilities:

• Performed maintenance for a manufacturing steel product processing system with legacy applications on the Mainframe.
• Prepared Functional and Technical specifications for IMS Modules for the legacy systems such as inventories, Scheduling, coil Tracking, shipping, mill order entry, Scheduling, and order status, quality & metallurgical.
• Modified the IMS database records
• Created Technical specifications, coded new programs,
• Modified JCL, Led the testing effort and coordinated loading procedures.
• Evaluated all JCL extracting programs that were being executed.
• Created & made enhancement in number of online programs to meet the new requirement set up by the user, also coded new batch program from scratch with the help of COBOL-II, & IMS data base.
• Conducted extensive program analysis to before making any enhancement in the programs, created test plans for unit, system, and integration testing.
• Learned Manufacturing Functionality for Steel Industry

Environment: COBOL II, VSAM, JCL, MVS, IMS DB/DC, TSO/ISPF, LIBRARIAN, VSAM, CICS, ABENDAID, FILEAID, XPEDITOR, WINDOWS NT, VISIO, CA7, & TCP/IP.

Confidential | Trenton, NJ

Senior Mainframe Consultant

Responsibilities:

• Worked on a Family Automated Case Tracking System,
• Responsibilities were to managing and doing program analysis, program modifications, writing batch and online programs from scratch. Prepared JCL, & set up procedures for the job Stream.
• Worked on a project, which helped state in getting rid of duplicate cases of juvenile from the data base. It involved more than 20 COBOL & Focus programs to accomplish the task.
• Used FOCUS application for creating reports from DB2 and IMS legacy data base applications.
• The project work was greatly appreciated by the Project Manager.
• The application FACTS provides the user with automated docketing, & indexing.
• Case history information, notice, subpoena generation, case Tracking, court Calendaring Scheduling statistical reports, Court Fee processing, & management reports.

Environment: COBOL II, VSAM, JCL, MVS, IMS DB/DC, TSO/ISPF, FOCUS, ABENDAID, LIBRABRIAN, CA7, XPEDITOR, FILE-AID & TCP/IP.

Confidential | Mountain View, NJ

Sr. Analyst /Programmer

Responsibilities:

• Hired by Confidential for an out source project for Confidential Mortgage with aim to make it a Public Company, the project was name as Confidential Horizon project.
• Received training for Focus data base with report generating facility, & fundamental of SAS programming.
• Wrote several new programs online and batch programs in CICS COBOL with IMS Database.
• Modified several batch and online programs in IMS, using Cobol and CICS,
• Learned Mortgage Industry

Environment: COBOL II, IMS-DB/DC, VSAM, JCL, CA-7, MVS, CICS, TSO/ISPF, EASYTRIEVE, and CLIST.

Confidential, Washington, PA

Sr. Programmer / Analyst

Responsibilities:

• Analyzed, designed, and coded enhancements to an existing Periodic Payment System, the systems support the periodic Payment Center in processing checks, & electronic Fund Transfers. The products supported are Life Insurance Settlement Options, Group Disability payments, Confidential Income Annuities (PIA), Structured Settlements, & Board of Directors Payments.
• Involved extensively in the production support, weekly status meetings, problem & change management & system maintenance throughout this period.
• Other involvement was in the Y2K project for the PPS System, it includes external / internal document design, online & batch programs modification, data base conversion, unit & system integrated testing plan.
• Completed year-end Tax related projects throughout my stay in the Confidential .
• Defined & completed changes in many Logical Record Facility Sub schemas.
• Exercised extensive usage of OLQ & DMLO in the testing phase of the projects.
• Worked for the conversion project for PPS application, the conversion was from IDMS database system to DB2 data base system.
• Tested the system at unit, system and integration levels.
• Defined escalation procedures and coordinated loading procedures for the move to production.
• Learned several MFsoftware, Also Learned Insurance Process in Specific Annuity

Environment: COBOL II,, JCL, MVS, IDMS DB/DC, TSO/ISPF, IDMS, CHANGEMAN, VSAM, ABENDAID, FILEAID, CA7, XPEDITOR, WINDOWS NT, CLIST, REXX,VISIO, IDMS LRF data base, & TCP/IP.