PROFESSIONAL SUMMARY:

• 8 years of professional experience in the Industry with strong hands on Mainframe technologies - COBOL, JCL, CICS, VSAM, DB2, MQ’S, OS/390, SPUFI, QMF, Expeditor, Pan valet, Platinum, CA7, REXX, Platinum Detector, TMON, File aid,IMS-DB.
• Thorough understanding of the SDLC process entailing requirement analysis, design, development, testing, change request management and maintenance/ enhancement support to the client with strong skills in Mainframe technologies.
• Extensive experience in analysis, root cause identification and resolution of Mainframe Issues.
• Expertise in Architecture Flow analysis and preparation of technical design document.
• Good working experience in JCL, DB2, CICS, API (web services) for realizing SOA architecture.
• Expertise Knowledge of and experience using TSO/ISPF, File Aid, FTP, Pan Valet, Prose, SSIS and SSRS.
• Having key skill set in unit testing, system testing and debugging tools such as Xpediter, Intertest, Strobe / iStrobe.
• Extensive experience in developing high volume, high performance, high availability batch and real-time applications.
• Practical experience with performance tuning of mainframe applications including IBM DB2.
• Knowledge of relational databases, legacy systems integration, mainframes and design patterns.
• Experience with the utilization or creation of technical standards & documentation for Mainframe technologies.
• Involved in building the Mainframe Regions with all the software libraries, DB2 Tables, Jobs, Procs, Programs, OP04, and OP15.
• Expertise on LOAD TESTING in mainframes environment.
• Good knowledge and experience working in Health Care, Data ware House and Insurance industry.
• Experience in application development, debugging, implementation, testing of Oracle Database triggers files.
• Experience working with Offshore-Onshore model.
• Leading, coordinating and handling Offshore Team codes reviews and deliver to Client.
• Lead the Change Management request, Build & Release Implementation.
• Worked with End-User on the critical production support Issues. Also, Installed Patches in Production Region in order to overcome the Defects.
• Strong knowledge of big data concepts and tools like Map Reduce, HDFS, PIG, HIVE, HBASE & OOZIE.
• No SQL - Databases - CASSANDRA & MONGO DB.
• Highly motivated, detail oriented with excellent written and verbal communication skills, has ability to work independently and as a part of the team.
• Quick learner and up-to-date with industry trends. Excellent written and oral communications and team player. Excellent customer relations and people management skills. Ability to work independently and well-organized. Strong analytical and problem solving skills. Excellent presentation skills (strong verbal and written communications).

TECHNICALL SKILLS:

Platforms: Windows, Unix, Z/OS, S390

Languages: Java, C/C++, COBOL, JCL, CICS, VSAM, REXX, Unix Shell, SQL, Ezytrieve,

Packages: MSI Packages.

Reporting Tools: Document Direct, Info Pac Reporting, SSRS

Databases: SQL, DB2, SQL Server 2012, Oracle 12C and MS Access.

Tool: iStrobe, Load Runner, File-Aid, Detector, Abend-Aid, Beyond Compare, CA7, UniCenter, Xpediter, eTP, Clarity

Environments: Z/OS, S390, JDBC, Windows and Unix

Scripting: Unix Shell Scripting

Web Servers: Apache Tomcat

Design Documentation: Microsoft Visio Studio

Project Management: MS Project MPP, Microsoft Powerpoint

TECHNICAL EXPERIENCE:

Confidential, KY

Mainframe Developer and Lead

Responsibilities:

• Design and Development Application using mainframe tools COBOL, JCL, VSAM, DB2, Oracle
• Performed analysis and design of business requirements.
• Provided recommendations to the BOP team to update the existing system design based on the need after thoroughly observing the performance of systems to save Turnaround Time.
• Developed Visio diagrams to simulate business process helping business owners visualizing their processes.
• Analysis of the JCL used in the project flow.
• Identifying the jobs and activities to be performed in the job.
• Coding according to the specifications of given by Client.
• Ensuring that coding standards are followed.
• Preparing the test cases based on data and involve in testing
• Preparation of Unit Test Plans.
• Integrating all the modules for Unit testing
• Bug fixing
• Moving Corresponding Changes from Test Environment to Production after UAT.
• Interacting with Production Control and the Support Team for Scheduling the Job based on the requirement.
• Taking back up before going into live environment.
• On Call Support of the EDW Application till warranty period.
• Monitoring and support of the End Of Month jobs to move data from EDW to ODS Services.
• Handling the Incident tickets, Change Order & Problem tickets related to the application.
• Responsible for Defects Tracking and implementing the appropriate solution within the stipulated time.
• Worked with the Turn Center and Production Control for code changes migration to production and have the successfully run.
• Verification and Validation of the components.

Environment: COBOL, JCL, VSAM, DB2, REXX, Unix Shell, SQL, Oracle 10c, Windows XP.

Confidential, NY

Mainframe Lead

Responsibilities:

• Understanding the requirements of SDS production support.
• On-Call Support for SDS Batch & Online Application.
• Month End Support to monitor and resolve all the issues related batch and online application.
• Validation of production cycles and data at end of cycle.
• Matching the Finance Reports with the Mainframe Reports at the end of cycle.
• Backups of TEST regions on regular basis & other regions on request.
• Running the TEST Cycles as per customer request. Involved in developing backup and recovery procedures.
• Supporting the various application modules under SDS product
• Policy Administration
• Claims Administration
• Open Item Reconciliation
• Reporting System
• Accounts Payable
• Check/Draft Reconciliation
• General Ledger
• Adhere to acknowledgement and resolution SLA’s application to the project.

Environment: Windows Platform, ACU-COBOL, VSAM, SQL SERVER 2012, SSRS, SSIS, Beyond Compare

Confidential, KY

Mainframe Developer

Responsibilities:

• Expertise in Build, Release & Deployment of Metavance Application and Patches using Mainframe tools
• Development of CICS Transactions to call the Wrapper and API and invoke the web services to update the data in DB2 Tables.
• Prepared the MSI Package for the deployment of upgraded Metavance product on all the TEST, QA and Production servers.
• Understanding the requirements of METAVANCE product.
• On-Call Support for Meta Vance Batch & Online Application.
• Maintenance for Meta Vance application as per the quarterly enterprise release.
• Also, worked on Region Refresh, Region Build, Load Testing, and Stress Testing & Shake-Out.
• Build the release for the Metavance Application which including JCLs, Programs, Procs, Data cards, FTP Security Files, Software Libraries.
• Involved in Database Activities like creating DB2 Tables unload, load jobs, Scripts, Indexes for data storage.
• Executing the build in the regions phase wise - TEST and QA regions for new Meta Vance releases.
• Creating the replica of the Production Region with the new release to deploy on the Enterprise Release day.
• Participating in ERM Enterprise Release Management meetings and calls.
• Integrations of code designed by various systems to be prepared for the Release.
• Deployment of code in production during release day.
• Installation of Meta Vance patches in TEST, QA & Production regions in case of defects or upgrade to the existing product.
• Selective Data Copy for testers from one region to another using Platinum fast unload utility where SQL extended.
• Masking & Scrambling of production data when copied to TEST regions for testing.
• In order to move the data from Active DB2 tables to Historical/Audit tables involved in creating the design and process flow for the Purge and Archive project.
• Development of the jobs, programs, Procs and testing in the TEST, QA region.
• Successful in purging the data before 2005 from active table and moving it to Audit table.
• Meta Vance application performance report.
• Provides 24x7 on-call support for production / non production environment.
• Worked on monitoring tools like CA7, Dollar$ Universe
• Used UniCenter raising ticket and change management process.
• Involved in the Patch Management.
• Created and monitored SLA alerts.
• Involved in mainframe applications performance turning.
• As part of product upgrade, Deployment of clients on various servers using TCW Turn Control Wizard.

Environment: Z/OS, CICS, COBOL, JCL, DB2, Platinum, CA7, UniCenter, ERoom, TMON, TURN, One shot, EAPM, Pan valet and File-Aid

Confidential, KY

Mainframe Programmer

Responsibilities:

• Created the high level design and low level design to develop the new systems ZH, ZI to clone the Metavance application for the HMHS system in mainframe environment.
• Connect with the business teams on the regularly basis to create the flow as per business requirement.
• Development of new regions and libraries required for the new systems - ZH, ZI.
• Development of mainframe COBOL, CICS, DB2 programs based on similar business requirement of Metavance claim payable systems.
• Creating the corresponding JCLS, PROCs, Sysins and Datains.
• Preparing the job flow sequence using Microsoft Visio and implementing through the prose system OP04 job sequence and OP15 for restart instructions of the jobs.
• Understanding business requirement and technical requirement and implements the same on daily basis.
• Testing the code in the TEST, QA regions
• Handover the new systems ZH, ZI to the HMHS team to migrate to production.
• Preparation of complete documentation of HMHS system and handover to the support team.

Environment: Z/OS, CICS, COBOL, JCL, DB2, Platinum, CA7, UniCenter, ERoom, TMON, TURN, One shot, EAPM, Pan valet and File-Aid

Confidential, KY

Mainframe Programmer

Responsibilities:

• Understanding the requirements for MQ COBOL program and complete the analysis
• Understanding the requirement design documents provided by architect, business users.
• Set up the daily meeting with clients to understand the requirement and coding the same in the mainframe environment using Cobol, JCL, MQ’s
• Development of related programs component such as JCL’s, EZTRIEVE, SYSIN’s, DATAIN’S, PROCEDURES etc.
• Involved in unit testing, system testing and uat phase of the project.
• Migrating the code to QA and then production environment.
• Program HI837P reads data from table and write in queue depends on claim type. Several sets of the new program include.
• Read Claim id, Claim type, ECN, Create TS from THI837P table and put all this data into MQ queue depends on Claim type.
• Read Claim id, Claim type, ECN, Create TS from THI837H table and put all this data into MQ queue

Environment: Z/OS, COBOL, MQueue, JCL, DB2, Platinum, Pan Valet and File-Aid

Confidential, KY

Mainframe Developer

Responsibilities:

• Understanding the requirements
• Develop ER diagrams for the DB2 and application relationships
• Creating application relationships between tables as per the ER diagram using OPTIM tool
• Preparing the Visio’s Diagram showing the relationship between child and parent tables.
• Creating Access Definitions using OPTIM tool
• Testing of Access Definition includes extracting data from the source database as per the selection criteria and validating the extracted data by running the queries in SPUFI
• Loading the extracted data to the destination tables
• Verify whether the data in the tables loaded properly.

Environment: Z/OS, COBOL, JCL, DB2, Platinum, OPTIM, MS-Visio’s, EROOM and File-Aid