SUMMARY:

• 13+ years of experience in Mainframe Development and Support projects. Currently working in Confidential as Technical Lead managing a team of five members in onsite - offshore model. Current project involves Mainframe Development and production support in Mainframe, Windows environment. Formerly worked in Confidential as Application Developer in DB2, UNIX & Mainframe and as an Associate in Confidential Technology Solutions in Mainframe enhancement & support project.
• Provided production support for critical Mainframe daily/monthly/quarterly Job schedules. This includes job abends analysis, temporary and emergency fix. Provided permanent fixes for jobs by modifying the problem job steps/problem COBOL programs. FTP issues are resolved by adding GDG inputs and space abends in SMTP step is handled by restricting file attachment size. Worked in re-engineering project for Migration tool development and support in REXX & CLIST. New REXX programs/macros are developed along with new process to increase the performance of the tool. Developed SAS programs and Easytrieve programs to create reports/charts on business data. Fixed COBOL DB2 programs for performance issue by fixing the index scan and restructuring the data retrieval and update. Developed new processes in order to improve the efficiency of online module by providing key views made from critical tables. Modified flat file processing to VSAM file processing in existing COBOL programs in order to accommodate change request and improve application processing time.
• Worked and experienced in Agile methodologies and SDLC/ITIL processes. Agile methodologies helped continuous improvement and delivery by providing flexibility to implement anytime. High level of coding standards followed such commenting, modular programming, reusable sub-programs/stored procedures for new development of COBOL/SAS/REXX/Easytrieve programs. Worked as an Analyst for gathering business requirements and designing the technical solution for Mainframe applications. Lead the dev/support team to complete all assigned requests within expected timeline and great customer satisfaction. Domain experience includes Manufacturing, Insurance, Security, Banking and Finance. Resolved critical Credit card disputes/tickets for financial client in a DB2 UDB/Unix environment. Designed/written Mainframe COBOL DB2 Stored procedures for customer loyalty programs application. Developed a new automated process in SQL Server 2008 that processed Avenue CRM data and helped sync process between SQL Server and DB2 UDB databases. Worked with DBAs to analyze performance issues, deadlock issues and determine the best solution to improve the application availability and performance.
• Extensively worked as a Test Lead for all business requests by creating Test Cases, Test Plan, Test Result review, UAT Support and post implementation support. Worked with other application teams to test DB2 requests/services from Java based front-end/PEGA based front end. Performed Integration testing and Regression testing thoroughly in order deliver bug free Mainframe & DB2 components.

TECHNICAL SKILLS:

Mainframe Skills: COBOL, JCL, VSAM, REXX, Easytrieve, SAS, MQ, CICS

Database: DB2 for Z/OS, DB2 UDB, SQL Server 2008, IMS-DB

Mainframe Tools: ENDEVOR, CHANGEMAN, FILE AID, SPUFI, QMF, IBM-DB2 Tools, IBM Websphere Data Interchange, EXPEDITER, SAR

Job Scheduling Tools: Control-M, CA7, CA-JOBTRAC, TIDAL

Operating Systems: Z/OS, MVS, S390, UNIX, Linux, Windows 2008 Server

Other Tools: Axway Software, Putty, BMC Control-M

Project Skillsets: Microsoft Powerpoint, Word, Excel, Visio

Production Support Tools: BMC Remedy, Service now, Quality Center, PICCT

WORK EXPERIENCE:

Confidential, Erlanger, Kentucky

EDI Application Lead

Responsibilities:

• Requirement gathering for new EDI requirements such as - Adding new trading partners, adding new EDI transaction for existing Trading partners. This involves analyzing the EDI specifications in ANSI X12 format, complex COBOL-DB2 programs, MQ transactions, Interface between VAN and Mainframe, complex JCLs and job scheduling requirements. Developed new COBOL-DB2 programs, JCLs for new EDI requirements. Worked in MQ monitoring, analysis and production fixes. Resolved Job abends for space issue, invalid data, missing data, SMTP issues and FTP issues. Analyzed the complex JCLs that uses EDI translator to convert the ANSI X12 data to ADF and vice versa.
• SLA deviation is always kept < 2% throughout the year. Emergency fix and performance improvement provided for complex COBOL DB2 programs that processed Stocks, Commercial policies. Endevor/Changeman is used for moving the new/modified Mainframe components to QA/PROD/EMER region.
• Worked extensively in designing new COBOL-DB2 programs, modifying existing logic for JCLs and COBOL programs, EDI translator configuration, and test result review for test data. Implemented 30+ new request/change requests for EDI application till date.
• Provided review, validation and implementation of Endevor packages for all project delivery. This includes creating test cases as per EDI requirement such as Purchase order processing and validation, Acknowledgement generation, Advanced Ship Notice generation, Invoice creation. IBM WDI tool configuration review and implantation for all new setup of EDI documents. Added 27+ new EDI transactions with new and existing trading partners.
• Production support is provided round the clock in 24X7 format. This includes support for batch job abends, temporary fixes, root cause analysis and permanent fixes. More than 14 permanent fixes provided as a team and improvement of existing system process flow. Reduced severity 1 issues to < 5 in a year and severity 2 tickets by providing permanent code fixes. Also resolved the EDI transaction processing issues in Axway tool which interfaces between VAN and Mainframe.
• Currently working in EDI system architecture, EDI interfaces with other applications such SAP systems, Unix systems and Mainframe. Designed new JCL and new COBOL, SAS program for improved report monitoring. This report helped business user in effectively monitoring the VMI Order processing and acknowledgement generation. Modified existing COBOL programs and JCLs to send multiple acknowledgements.
• Project management is done for EDI application which involves resource utilization, workload managing, prioritization, co-ordination between production support and development team and also with other application teams.
• Primary support provided for critical Plant SAP migration project for EDI and VAN migration project. Identified the key Jobs, COBOL-DB2 programs and EDI transactions required to be changed and tested for SAP migration.
• For VAN migration, worked directly with third party VAN provider support team to test different EDI transactions such as 850/855/856/810/997/845 etc. This includes AS2 connection build in Axway tool, directory setup in Windows Server and modifying the windows scripts for processing logic.
• Working extensively in quality assurance for the deliverables and UAT and QA Testing with the EDI team, Q2C team, Business users, Esupport and external Trading Partners. Responsibilities include preparing test cases, planning testing strategies, validating and verifying test results. Worked in many testing projects that includes extensive testing such as Unit test, Integration test, System test, Regression test and User acceptance testing in Mainframe COBOL, JCL, DB2, VSAM and other components. Testing performed across various platforms: Mainframe & Unix, Mainframe & Windows, Mainframe & SAP. Worked in Mainframe and Java based front end to perform the end to end testing.
• Analyzed high complex COBOL programs and jobs for execution time improvement. This is achieved by fixing performance issues in DB2 cursors, processing logic, removing redundant DB2 calls, using index scans and normalizing the complex joins. Job execution time reduced from 2.5 hours to 1 hour for single job. Achieved the IBM DB2 certifications - Database Associate DB2 10.1 Fundamentals and Database Administrator DB2 10 for z/OS. DBA certification helped gaining in-depth knowledge for DB2 architecture and helped implementing high performance DB2 COBOL programs. Used the knowledge in designing the Database tables and relations. Achieved client appreciation from Confidential and Confidential for performance improvement of mission critical Jobs/programs.
• Providing support to approximately 60+ batch jobs, 2 systems (Mainframe & Windows), and different EDI processes. Also, working on team management such as Knowledge Sharing, Training, Workload management, Appraisal and resource allocation. Received customer appreciation for providing excellent support and implementing critical enhancement requests which increase the customer rating on vendor reports.

Confidential, Overland Park, Kansas

Technical Lead

Responsibilities:

• Performed requirement analysis, design and estimation for new business requirements. Worked on Impact analysis and design, code review and test result verification for complex requirements. Worked on the Release management for all monthly/exception releases for project delivery. All project deliverables were delivered with less than 5% SLA deviation.
• Developed new COBOL programs, JCLs, CA-Jobtrac Schedules, SQL Server data processing modules and performance improvement initiatives for existing jobs interacting with DB2 database. Worked as On-Call support person for Mainframe batch process and online transactions, iAvenue Batch & online. Worked on the Administration tasks for Avenue application which includes user support, server support and application support test support for business users in creating test plan and support for defects/issues/application knowledge.
• Designed and developed new Control-M schedules for new process flow for yearly sales-profit report calculation in insurance project. Developed automated update BI flow in SQL Server 2008 database in order to sync the data from CRM tool.
• Provided emergency fix, permanent fix for Production issues/job abends. Added new functionalities in COBOL-DB2-IMS programs. Created DB2 maintenance jobs for QA and PROD environment that performed mass data uploads, DB2 performance checks, DB2 backups and analysis for performance. Performed active DB2 monitoring using system commands to check the DB2 health and cleaning up unwanted and idle DB2 threads. Worked on the highly complex COBOL programs that uses multiple VSAM files with primary indexes and alternate indexes.
• Team management activities such as effort estimation, process documentation, knowledge transition, quality documents, visio diagrams were created at the project level. Worked as a Application Lead driving the offshore team.

Confidential

Associate Consultant

Responsibilities:

• Worked on the System Analysis, Coding, Testing, Implementation and post implementation support for all deliverables. All programs/utilities are built in REXX, CLIST, JCL and PROC. Worked on the migration tool NHM that is used for COBOL programs/JCL/PROC/COBOL-DB2 program implementation.
• Developed new process flow for cleaning up Migration tool components in UAT re-Engineering project. Process is developed in JCL, REXX and CLIST. Worked in Control-M to run Mainframe job schedules in UAT and PROD. Developed new job schedules, modified Job schedules, Schedule run monitoring and support for any job abends to the dev team. BMC Remedy and Service now is used for production support.
• Worked on re-engineering the migration tool and UAT environments up-to-date. Worked on the performance improvements and upgrading of all UAT cycles which included 10 UAT cycles for USA and UK region. Created several project documents - Process documents, Quality documents, Visio diagrams, Process manuals
• Support for migration issue in the UAT environment and resolution of the same - Resolved the migration issues within the time mentioned in the SLA. All the issues are acknowledged with 100% compliance.
• Process improvements done in order to keep UAT environments clean and error free. UAT batch execution support for QA testing: 5 Batch Cycles for New York and 5 batch cycles for London Resolved job abends and fixing, technical analysis for abend, coordination with the application team in case of business logic issue
• Developed of new process to provide advanced feature to the maintenance of UAT environments.
• Worked on Administering, managing and enhancement of Control-M scheduling environment for UAT & QA.
• Created new processes: Ad-hoc delete and Ad-hoc refresh to maintain UAT environment using advanced features.

Confidential

Application Developer

Responsibilities:

• Functional analysis done by analyzing the front-end application PEGA and DB2 data & procedures
• Provided 24X7 On-call support for the PEGA-DB2 and Mainframe batch application. Production implementation almost every week for production issues/bug fixes to ensure business profitability. Support provided for Mainframe batch abends/tickets and DB2 UDB database - system generated & user tickets. Worked on System analysis, impact analysis, coding, testing and implementation for production bugs in Mainframe. Database remediation & database implementation activity in DB2 UDB. Resolution of DB2 UDB issues by analyzing Unix code, DB2 Stored procedure and PEGA rules.
• Requirements gathering, Preparing estimates/specification document for the application development- Design specification, Coding, Testing, Implementation and post implementation support for the development project
• Project documentation - Process documents, Quality documents, Visio diagrams, Process manuals Tracking and logging of all test cases along with the defects as per client standard in the HP Quality Centre. Metrics data preparation in account level and participation in internal & external audit. Worked in coding, testing and implementation of new DB2 stored procedures.

Confidential, Charlotte, North Carolina

Associate

Responsibilities:

• Worked in an Application maintenance & production support project as onsite coordinator. Worked on requirement analysis, design, coding, testing, Implementation and post implementation support. Provided User Acceptance Testing support to the business users.
• Mainframe coding involved COBOL program, COBOL-DB2 program, JCL, Scheduling in CA-7.
• Provided code review for all offshore deliverables and On-Call support for mainframe batch. Performed successful testing of application for Disaster Recovery at the organization level.
• Performed successful merger testing for integration of application due to the acquisition of new financial organization.