SUMMARY:

• Over 15 years of IT experience in automotive, healthcare, manufacturing, transportation, state government, human resources, finance, accounting and insurance industries.
• Worked in the capacity of Sr. Mainframe Programmer/Analyst and SCM tool administrator on various projects.
• Strong experience in the areas of Systems Development Life Cycle from project initiation to implementation, production support, data modeling and testing.
• Conversant and have strong concepts of development methodologies like waterfall and Agile.
• Extensive experience of evaluating systems requirements and translating them into test cases for quality assurance.
• 10 years plus technical background in mainframe technologies such as COBOL, CICS, DB2, JCL, VSAM, IMS DB/DC, Stored Procedures, etc.
• Addressed Customer tickets very promptly and always performed Root Cause Analysis to eliminate repetitive issues.
• Solid Back - end testing experience in writing and executing SQL Queries
• Have good understanding of interaction with distributed platforms.
• Have good Knowledge in ETL tool Informatica.
• Good team player and have ability to work independently
• Good written and verbal communication skills
• Good Understanding of Data modeling.

TECHNICAL SKILLS:

Expert: IBM OS-390, Z/OS, MVS

Highly Skilled: VM, VSE

Proficient: Windows

Working Knowledge: UNIX

Software: COBOL LE, COBOL/370, COBOL-II, JCL, Stored Procedures, CICS, VSAM, SPUFI,CSP, File Manager, IBM Debug Tools, FileAid, AbendAid, Strobe, TSO/ISPF, Xpediter, ChangeMan, Endevor, BMP Shell, ALM, SDF,MQ,Ellipse, SCLM, PUPS, Dyle280, Word, Excel, Power Point, Visio, Easytrieve,QMF, FastLoad, BTQMAIN, MLOAD, BTEQ, Informatica(v8.6),JIRA,PL/SQL

Databases: DB2,IMS DB/DC

PROFESSIONAL EXPERIENCE:

Confidential

Consultant

Responsibilities:

• Working as a Programmer/Analyst for MBFS collection application, for requirement gathering. Enhancement and bug fixing.
• Worked and involved in analysis and development of successful migration project of mainframe retail and lease application to a vendor ALFA application with the use of COBOL, DB2, VSAM and Easytrieve.
• Worked to enhance and fix the Online collection applications with the extensive use of COBOL, CICS, DB2, MQ and VSAM.
• Tuned and fixed background CICS transactions to send and retrieve data.
• Worked to automate the Bankruptcy Optimization System to send and receive the encrypted bankruptcy information to third part vendor through SFTP.
• Work on reported incidents and fixing bugs for Collection application.
• Supporting Mainframe Collection application 24/7.

Technical Environment: IBM Mainframe, Z/OS, COBOL-LE, CICS, DB2, MQ, Stored Procedures, JCL, VSAM, TSO/ISPF, SPUFI, Endevor, JIRA, ALM, CISM, Expediter, File Aid, Easytrieve etc.

Confidential

Consultant

• Worked as a Sr. Programmer/Analyst to support and enhance billing system of America’s premier regulated energy company, which provides customer-focused energy solutions and investment-driven growth opportunities.
• Performed analysis, created specifications documents, developed batch and online programs, and participated in testing till UAT.
• Developed and maintained new applications and scripts to pull survey data from vendor sites and loaded into central database for analysis purpose.
• Performed day to day maintenance and enhancement of billing and other applications assigned to me through TPRs(Tickets).
• Analyzed and Developed Informatica maps, workflows using DB2, Flat Files as both Sources and Targets.
• Used Informatica components such as Mapping Designer, different types of Transformations such as (Source Qualifier, Filter, Aggregation, Router, Update Strategy, Lookup, Union, etc.)

Technical Environment: IBM Mainframe, Z/OS, UNIX, COBOL-LE, CICS, DB2, VSAM, Stored Procedures, JCL, Easytrieve, Shell Scripts, Informatica etc.

Confidential

Consultant

• Worked as Software Configuration Manager tools (Endevor, Changeman and PUPS) administrator to provide technical support to application developers for migrating the application codes from Changeman to Endevor.
• Worked with vendor to install and fix bugs with Endevor processors.

Technical Environment: IBM Mainframe, Z/OS, Endevor, Changeman, PUPS, COBOL, JCL, etc.

Confidential

Consultant

• Worked as Sr. Programmer/Analyst in IS Finance Production Services to support the financial systems of the company, which includes pharmacy payments (Checks and 835/Remittance Advice), Members EOB, Client Billing, Client Claims Files (PAL, NCPDP & Custom).
• Performed various functions such as business requirement analysis, system analysis & design, code development, code review, test plan development and testing for both batch and online application systems.
• Also performed the duties of ticket management, production support and application maintenance.
• Participated in enterprise level projects like Network Processing Fee and HIPAA 2012.
• Followed CRM requirements for change management and documentation.

Technical Environment: IBM Mainframe, Z/OS, COBOL-LE, CICS, DB2, Stored Procedures, JCL, VSAM, IMS DB, TSO/ISPF, SPUFI, ChangeMan, IBM DEBUG Tools, IBM File Manager, Dimensions.

Confidential

Consultant

• Worked as Sr. Analyst and Programmer/Analyst on multiple projects during the tenure with Confidential .
• Collected information from the customers and created functional and detailed program specifications for developers.
• Analyzed, developed, tested and implemented the system changes for Contest and Incentives (C&I) project.
• Developed data model and designed the database structures for the project.
• Analyzed stored procedures and tables to identify and rectify the performance bottlenecks during systems testing phase. Implemented solutions to resolve performance issues with C&I application’s database and external databases which resulted in significant improvement.
• Received a certificate of appreciation from business application manager for valuable contribution to this project.
• Provided 24/7 to the application after project launch. Resolved post production issues within the allocated time.
• Developed mainframe stored procedures and batch programs to support a web-based Real Time Order Management System which is used for Commodity Allocation and Field and Reserve.
• Participated in discussions with the business to collect business requirements.
• Collaborated with DBA to analyze and develop efficient and powerful database solution utilizing the advanced features of DB2.
• Provided a backup support to ChangeMan Administrator for promoting program components to different environments.
• Resolved defects and issues with the coordination of web developers.
• Received a certificate of appreciation from business application manager for valuable contributions to the project.

Technical Environment: IBM Mainframe, OS/390, Stored Procedures, DB2, COBOL, JCL, VSAM, IMS DB/DC, TSO/ISPF, SPUFI, ChangeMan, BMPShell, CA7, STROBE, Xpediter, File-Aid, and Abend-Aid, etc.

Confidential

Consultant

• Analyze, design, develop and tested various components of the Billing System.
• Implemented batch solution to extract data from mainframe database to load into an Oracle database for reporting.
• Also provided 24X7 on call support.

Technical Environment: IBM Mainframe, OS/390, DB2, COBOL, JCL, TSO/ISPF, SPUFI, Teradata with