SUMMARY:

• Over 5 years of experience in IBM Mainframe in Development, Test and Production environments in business domains like Healthcare, Insurance and banking.
• Expertise in COBOL, IMS, DB2, JCL, PL/I, CICS, IDMS, QMF, SPUFI, ETL, RACF, Changeman, VSAM, Rexx, Panvalet, Microsoft Visio, SAR, job scheduling tools CA - 7/CA-11.
• Extensive experience with object oriented analysis and design and developing use-case models.
• Tested applications and resolved complex problems throughout Software Development Life Cycle (SDLC), including preparing detailed program specifications. Worked in Agile and Scrum methodologies.
• Ability to meet deadlines and handle pressure coordinating multiple tasks.
• Demonstrated strong interpersonal skills with the ability to work effectively with upper management and excellent leadership skills in motivating others.
• Experience in working as Queue Manager such as Local Queue, Remote Queue, Alias Queue and Model Queue.
• Expertise in OS/390, Enterprise COBOL, ASSEMBLER, DB2 stored procedures, SYNCSORT, ISPF/PDF, SQL, Xpeditor, File-Aid, Endeavor.
• Generated Business Requirement documents (BRD), Functional Specification design documents (FSD) and Functional Requirement Documents (FRD).
• Expertise in data migration and data quality tools - Dataflux and Trillium.
• Experienced in Extracting, Transforming and Loading (ETL) by using Informatica software and data replication tools such as Informatica data replication, HVR (High Volume Real-time) data replication.
• Experience in interacting with business users and executives to identify their needs, gathering requirements, Use Case Diagrams, Activity Diagrams and Sequence Diagrams.
• Experienced Production support team lead, involved in productionsupportactivities during and after the implementation of jobs. Used CA-7 for job monitoring and scheduling.
• Experienced as Mainframe support Analyst wrote sql queries, altered IMS data and run the jobs as a part of bug fixes.
• Experienced in all phases of Software Development Life cycle (SDLC) - Requirements Gathering, Functional gap analysis, Construction, Unit Testing, and Support to various Testing techniques - Integration, Quality Assurance (QA) Test, User Acceptance (UAT) Test, Regression Test, and Production support.
• Experience in analyzing the entire system and the impact with the other backend and front-end systems.
• Experience in a variety of hardware and software platforms including Unix/Linux, AIX, MS-Windows.
• Worked on problems involving the evaluation of specifications for complex business requirements, processes (new, enhancements, maintenance) and developed the solutions.
• Have experience to work on User and Business requirements to provide high quality deliverables as per the schedule
• Having core competency in Incident management, Problem Management, Change Management, Team Management, Customer Service Orientation, Problem Solving & Decision Making, Innovation, Flexibility
• Experienced in developing product training material and conducted training sessions.
• Excellent exposure in interacting with clients and providing Co-ordination between onsite and offshore.
• Excellent analytical, communication and problem-solving skills.
• Good Team player, having interest towards exploring, learning and using new Tools & Software quickly as required.

TECHNICAL SKILLS:

Programming Languages: JCL, COBOL, CICS, PL/I, PL/SQL, REXX

Operating Systems: Z/OS (IBM Mainframe), TSO/ISPF, MVS/ESA, Windows

Databases: DB2, IMS, Oracle, Mysql.

Version Control Tools: Endeavor, Autoflow

File Management and DB Tools: Fileaid, SPUFI, QMF

Debugging Tools: Xpeditor

Data migration tools: HVR data replication tool, Informatica Data Replication, Informatica Fast clone

Other Tools and utilities: CICS Webservices, SAR, Dataflux, Trillium, ETL(Informatica), UNIX, CA-7/CA-11, Microsoft Visio, TSO/ISPF, QMF, SDSF, IBM utilities Database DB2, VSAM, Easytrieve.

PROFESSIONAL EXPERIENCE:

Confidential, Lake Mary, FL

Mainframe developer / System Analyst

Responsibilities:

• Analyzed complex programs and driver modules which are having multiple functionalities in the existing systems to find out the impact on new system.
• Analyzing and verifying development of projects according to the client requirements and modifying it with a perspective to align it with business need during project analysis phase in Agile and scrum software methodologies.
• Actively involved in Requirement Analysis, Business Analysis, Use-Case Analysis Involved and developed comprehensive Test Plans and Test Cases documented them in Quality Center (QC).
• Verified data flow of the system, functional activities and Impact Analysis of system.
• Development of new batch components using COBOL, DB2, PL/I, JCL, IMS.
• Worked in all kinds of Health care claims processing such as Intake, Adjudication, Enrolment and billing, Check-writing, Down-stream systems.
• Worked on designing target system on mainframe environment which can accommodate all the above mentioned systems.
• Understanding the functionality of complex code in legacy and target systems and writing technical specifications and code-drafts.
• Worked on CA7 scheduler, Changeman software, SAR, File-Aid, SPUFI, Endeavor, SYNCSORT.
• Worked in Inter-plan Teleprocessing System which is one of the key system in Healthcare domain that deals with claims coming from Host and Home plans under Blue-Cross-Blue-Shield.
• Worked on designing sub-system named Customer driven health plans(CDHP) which is one suite of Health plans based on geographic locations.
• Worked on Co-ordination of benefits sub-system which deals with claims coming from one member who is having more than one insurer.
• Developed re-usable common modules in COBOL and PL/I that replaced hundreds of lines of code.

Confidential, New York City, NY

Mainframe developer / System Analyst

Responsibilities:

• Involved in Development like Analysis, Design, Coding, Unit Testing, Integration Testing, and Release as per the business requirement.
• Detailed Impact analysis of the requirements on existing applications and interfaces.
• Prepared technical specifications and component specification once analysis is done.
• Involved in quick daily stand up meetings and story board tracking as per AGILE Methodology standards.
• Involved in designing and development of Data conversion process on the Target application using COBOL DB2 Programming.
• Development of new batch components using COBOL, PL/I,DB2, JCL, IMS, CICS, VSAM.
• Generated weekly Status Reports to the IT manager & participated in weekly status meeting with Team members, Business analysts & Development team.
• Developed new batch process using COBOL DB2 programming for new claims and existing claims
• Developed Internal and External DB2 Stored procedures to advocate User Interfaces.
• Adopted DB2 Performance Tuning techniques during the development process
• Involved in SORT techniques extensively to improve the batch performance
• Worked on CA Intertest for debugging and unit testing of CICS processes
• Involved in working with PLA, File-Aid, QMF and Spufi for SQL Queries
• Setup and managed new/secluded environment for UAT that allowed detailed performance/functional testing.
• Used Changeman software for Configuration Management
• Scheduled and Monitored batch process using CA-7 Scheduler.
• Using Trillium tool, we profile the data according to business requirements by writing business rules, date rules, character rules and based on threshold values, we validate the data. The data which passes above threshold value can be used for mapping using Informatica tool.
• Worked on HVR Data replication tool for change data capturing and data reporting and monitoring on target systems such as Oracle and SQL server.
• Conducted Joint Application Development (JAD) sessions to review the business document with a team of business end-users, application developers and technical analysts.
• Knowledge transfer to offshore team on business functionality and requirements.
• Involved in Unit Testing and Integration Testing
• Involved in daily monitoring of the Batch cycles
• Development and Testing of the optimization techniques and Used Changeman software for Configuration Management.
• Implementation the batch process in Production and Support in case of Abends/Issues

Confidential, Bloomington, IL

Mainframe developer /Production support /System Analyst

Responsibilities:

• Developed programs for data migration project in PL1 and Cobol using IBM-DB2 and IMS-DB as relational databases based on data in mainframe using JCL programs.
• Developed test plans, test cases, user stories and test environments and executed test procedures.
• Using Trillium tool, tested production data based on certain rules and allow only data which pass 100% and analyze data which fails to satisfy the rules and discuss with SMEs’ regarding rows which could not pass the threshold value.
• Used Nway joins and parser customization in Trillium software Dynamics CRM.
• Creating and managing Queue Managers, Channels, Listeners and Dead Letter Queue Handling.
• Worked on Informatica Data replication and Fast clone for real time data replication into target system where validation is easy and data reporting and monitoring.
• Involved in quick daily stand up meetings and story board tracking as per AGILE Methodology standards.
• Developed Internal and External DB2 Stored procedures to advocate User Interfaces.
• Adopted DB2 Performance Tuning techniques during the development process
• As a production support team lead, worked on IMS database bug fixes by altering data in IMS files after extracting them into our local host and FTP back to production environment by using CICS screen as a platform and verify whether the changes take place or not.
• Using Informatica tool, designed tables and databases according to data in mainframe environment, after getting design approval from clients, test with initial data which pass from trillium and moved to production environment.
• Worked on schema Reorganizations for better space management
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Conducted many sessions on defect prevention techniques, work flow and change management in my project.
• Root cause analysis and permanent fixes for recurring issues in production code.
• Participated in Performance improvement initiatives to reduce run-time of long running jobs in the batch.

Confidential, Dallas, TX

Mainframe developer / System Analyst

Responsibilities:

• Mainframe developer for worker compensation databases and deployed into production after creating packages.
• Ensured proper documentation of objectives, constraints, and scopes of the system.
• Took part in writing business requirements document (BRD) and functional requirements document (FRD)
• Entity Business Rule (EBR) techniques in Trillium Software including building complex expressions, setting advanced options such as Filter By, Group by and Aggregate By and reducing rework through Libraries
• Development of new batch components using COBOL, DB2, JCL, CICS, VSAM, Microfocus COBOL
• Created packages using DTS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool once the data passed above threshold value in Trillium.
• Participated in Performance improvement initiatives to reduce run-time of long running jobs in the batch.
• Analyzed existing code based on high-level integration requirements.
• Modified the existing programs and wrote the new programs to process corrected and recycled transactions as they are completed in the online system and allow further corrections within the same work cycle.
• Integrity tests and Quality Assurance for external and internal relations.
• Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.
• Created many datamodels (dataflow diagrams) and project status reports using Microsoft Visio and gannt charts respectively.
• Successfully lead the team in delivering a .NET based application for the Change Management, Configuration Management, and Daily Batch monitoring and reporting with back-end as Mainframe stored procedures.
• Created many Visual Basic scripts using MS-Access for Mainframe repetitive tasks.

Confidential

Mainframe developer, Data Analyst, Mainframe production support

Responsibilities:

• Developed programs in COBOL and PL1 for data validation in different tables in a Auto fetchables (database consists of Auto insurance clients) database after each production run.
• Job monitoring for JCL programs for its performance after each production run and raised tickets for respective development and testing teams.
• Unit Testing and evaluating the test results for test plans and test cases and prepare the test result summary report.
• Test case preparation and implementation of the test cases for testing
• Modifying the existing modules in the current system as part of the enhancement
• Maintaining the existing programs to suit client needs
• Evaluating the Unit Testing and prepares documentation
• Implemented several enhancements for existing applications as per the user requests.
• Gathered Customer Requirements and Created database using MS Access and Designed Data Model.
• Test case preparation and implementation of the test cases for testing
• Modifying the existing modules in the current system as part of the enhancement
• Maintaining the existing programs to suit client needs
• Evaluating the Unit Testing and prepares documentation
• Developed new batch programs using COBOL, DB2, JCL & VSAM, Microfocus COBOL.
• Experience in Service Management as Incident Analyst and Problem Coordinator using Service Manager.
• Provided 24x7 production support for a Mission Critical Application.
• Root cause analysis and permanent fixes for recurring issues in production code.
• Participated in Performance improvement initiatives to reduce run-time of long running jobs in the batch.
• Status reporting and weekly meetings with customer.
• Successfully provided 24x7 technical support to a group of 500 business users onshore for their immediate concerns related to production & test environments
• Setup & managed new/secluded environment for UAT that allowed detailed performance/functional testing.
• Implementation/Migration of Batch components to Production.