SUMMARY:

• Over 8+ years of Extensive experience in Mainframe technology involving all phases of Software Development Life Cycle experience in Analysis, Design, Development, Maintenance, Testing and support activities.
• Experience primarily in Financial and Auto domains
• Efficient and extensive experience in designing, coding and testing of variety of software applications on IBM Mainframe Using COBOL,CICS,VSAM,IMS DB, Hogan,DB2,Easytrieve, JCL, RPC and Stored Procedures.
• Have good exposure to tools Viz. QMF, SPUFI, DFSORT, SYNCSORT, ICETOOL, ENDEAVOR, ChangeMan, NDM, ABEND - AID, MAXIMO, REMEDY, XPEDITOR, SAR, CA7, IDCAMS, IBM Fault Analyzer, IBM File Manager, FILE-AID, MQ-SERIES, and Quality Center.
• Developed reusable components using Rexx Language.
• Worked in different Performance Enhancement Projects, which helped to reduce Batch CPU time and Cost.
• Exposure to plan and execute all phases of System Development Life cycle (SDLC) across System Analysis, Estimation, Architectural Design, High Level Design, Low Level Design, Peer review, Development, Maintenance, Unit testing, Integration testing, Regression Testing, UAT, Implementation, Work flow design, Documentation and Production/Application.
• Involved in client meetings to study and analyze the requirements for the new requests, Effort estimation, coordinating with the offshore team members.
• Highly motivated Team Player with the ability to work independently, efficiently and effectively under stressful, high pressure and tight deadlines. Ability to work in an iterative development environment. Good team player with excellent inter-personal communication, leadership, mentoring and multi-tasking skills.
• Excellent team player with problem-solving and trouble-shooting capabilities and ability to adjust to people, circumstances, with a Drive for results through self-motivation.
• Had a good experience of Production Release methodology and compliance of strict Timelines.
• Over a period of time worked in different roles like Onsite Coordinator, Team Member, Team Leader, and Release Coordinator. Also, trained many associates in all the Mainframe Technologies.
• Excellent written, verbal, presentation and interpersonal communication skills, given an opportunity willing to work in a challenging and cross platform environments.
• Strong Analytical and problem solving skills. Ability to quickly master new concepts and applications.

TECHNICAL SKILLS:

Languages: COBOL, JCL, SQL,EASYTRIVE,REXX,CICS

Database: DB2,IMS DB, Stored Procedures and SQL

Access Methods: VSAM

Configuration Management Tools: ENDEVOR, SCLM

Hardware: IBM 3270,Z/OS

Tools: QMF, SPUFI, DFSORT, SYNCSORT, ICETOOL, ENDEAVOR, ChangeMan, NDM, ABEND-AID, MAXIMO, REMEDY, XPEDITOR, SAR, CA7IDCAMS, IBM Fault Analyzer, IBM File Manager, FILE-AID, MQ-SERIES, and Quality Center

Network/Protocols: TCP/IP,FTP,HTTP

PROFESSIONAL EXPERIENCE:

Confidential, Montvale, NJ

Mainframe Technology Lead

Responsibilities:

• Analysis of issues identified by dealers/Customers of Confidential and fixing them within SLA time based on Priority
• Providing 24/7 production support for Job abends
• Gathering the business requirements and created the Business Blueprint, Functional and Technical specifications for the business requirements
• High level design document for business requirements
• Configuration management using SCLM
• Expertise in creating various types of critical reports that are submitted by Confidential to Government regarding vehicle recalls/accidents
• Extensive experience in writing complex DB2 SQL queries with efficient performance
• Experience in effective code implementation in COBOL and CICS
• Extensively used various SORT techniques in JCL
• Knowledge of Cognos reporting on top of Data Warehouse system, for Management reporting of Daily Sales and different Key Performance Indicators
• Extensive experience in coding and implementation of Remote Procedure Calls (RPC) called from front end Java applications for backend processing.
• Worked in various housekeeping activities as part of code maintenance
• Effectively scheduling batch jobs considering all dependencies and business requirements.
• Performed various cut-over tasks as per the cut-over plan.
• Build and testing of components.
• Review code specifications for enhancements to improve quality of standards checking and reduce the cost of software development.
• Assistance to the project team members in Coding, Unit test planning and execution.
• Tracking the status of the project.
• Carry out Quality assurance activities (reviews, walkthroughs etc.) as defined in the Project Plan. IQMS aids in QA activities
• Carry out Production implementation, Researching and Resolving Production defects.
• Assist application team with the current testing process and in the development of a regression testing and quality control scripts.
• Participate in technical and project related training sessions for the team.
• Collect metrics and document maintenance activity identified tasks and solutions.
• Be responsible for the overall quality and timeliness of the deliverables, performing the Effort estimation for the work requests and doing detailed Schedule planning.
• Review database access code and recommend tuning opportunities. Conducting reviews and Walkthroughs for the Code and deliverables.
• Effective Onsite Offshore coordination and handling multiple projects

Environment: JCL, COBOL, Ezytrieve,CICS, IMS DB, VSAM, DB2, HOGAN, SAR, NDM, FILE-AID, IBM utilities, FILE-AID, CA7, Librarian, IPMS, IQMS, IRIS, RPC, Stored Procedures

Confidential, Montvale, NJ

Mainframe ETL Developer

Responsibilities:

• Played Mainframe SME role for delivering release.
• Effectively gathered systems requirement from client and taken signoff on approval of systems requirement.
• Led (involved) the team through SDLC life cycle (Requirement gathering, gap analysis, HLD, Detail Design, Development, Unit testing, Assembly testing, System test support, migration to Production environment and post go-live support).
• Actively involved in converting Functional specifications into High Level Design (HLD)
• Active participation in providing Detail Design for the HLDs
• Designed intermediate tables and target DB’s, view DB’s and tables.
• Created many test cases and Test scenarios for Unit testing, Integration testing of many Finance reports
• Involved in coding of transformations, extractions, program, function module and database loads
• Source systems data are thoroughly analyzed and documented in the standard format.
• Prepared the data mapping document
• Involved in creating Jobs, scripts and JILs as per the design documents
• Coordinate with up-stream and downstream application owner to process and make available the required source data for testing.
• Involved in unit testing of the changed/new code.
• Involved in SIT and UAT testing of the changed/new code.
• Logged the defects in QC and assigned to respective team and also involved in defect fixes raised by business users and Quality team.
• Involved in CAB activities and release planning to move the components.
• Deployed the components into production and monitored couple of production executions
• Actively participated in preparation of KT Questionnaire to get most of the system information in hand before KT Execution
• Coordinated and lead the Operations team in Knowledge Transition phase
• Actively participated in KT Execution from site and coordinated the offshore team up to the speed
• Involved in maintenance and support of production system under SLA.
• Coordinated closely with team in resolving various maintenance tickets
• Coordinating between onsite team & offshore team to resolve issues.

Environment: JCL, COBOL, Ezytrieve,CICS, IMS DB, VSAM, DB2, HOGAN, SAR, NDM, FILE-AID, IBM utilities, FILE-AID, CA7, Librarian, IPMS, IQMS, IRIS

Confidential

Mainframe Developer

Responsibilities:

• Involved in Analyzing the User requirements and provided necessary information from Mainframe Perspective to meet all the standard requirements.
• Involved in determining the data flow for the business requirements and translated these requirements into Data Models.
• Involved in preparing RDDs, Tech Specs for the bespoke reports.
• Requirement and Impact analysis.
• Preparation of High level and low level designs for the initiatives.
• Created stored procedures that are called from front end Java application
• Build and test of components.
• Review code specifications for enhancements to improve quality of standards checking and reduce the cost of software development.
• Assistance to the project team members in Coding, Unit test planning and execution.
• Carry out Quality assurance activities (reviews, walkthroughs etc.) as defined in the Project Plan. IQMS aids in QA activities
• Carry out Production implementation, Researching and Resolving Production defects.
• Assist application team with the current testing process and in the development of a regression testing and quality control scripts.
• Participate in technical and project related training sessions for the team.
• Collect metrics and document maintenance activity identified tasks and solutions.
• Be responsible for the overall quality and timeliness of the deliverables, performing the Effort estimation for the work requests and doing detailed Schedule planning.
• Review database access code and recommend tuning opportunities.
• Conducting reviews and Walkthroughs for the Code and deliverables.
• Scheduling of jobs and Post Production support
• Provided End User training on web application and generating reports.
• Implemented Data warehouse for Reporting
• Coordinating between onsite team & offshore team to resolve issues.

Environment: COBOL, JCL, DB2, Cognos, Stored Procedures,SAR, NDM, FILE-AID, IBM utilities, FILE-AID, CA7, Librarian, IPMS, IQMS, IRIS, Expeditor,DFSORT,QC

Confidential

Mainframe Developer

Responsibilities:

• Participated as a team member in discussion with business analysts and end users for requirements
• Understanding and analyzing the requirements
• Implemented requirements in COBOL CICS environments
• Preparing Unit Test Cases and validating Unit Test Results given by the team and make sure test is good.
• Enhanced the system for various business requirements, provided new and high quality solutions for the customer.
• Modeling, Business Content, Granularity, and Performance Tuning.
• Performed Data Extraction for master data and transactional data.
• Customized generic data source with the help of Function Module to load the Work Order details.
• Developed generic extractor based on a view in CRM to pick up latest status of Quotations / Sales Orders.
• Uploaded hierarchies for Cost Centers and Work Centers.
• Defined reports as per reporting requirements, the reports includes WO details, WO Creation, WO Scheduling, Emergency Response reports, Quotations acceptance to Work Orders, Deferral/Delay Communication, Jobs Technically Completed and Jobs Substantially Completed reports.
• Involved in Unit Testing, System Testing and Prepared System Maintenance Technical Document (SMTD).
• Scheduled and automated data loads from different source systems.
• Created various queries and extensively worked on Query Builder objects
• Involved in analyzing the Business requirements and Prepared IA’s for the same.
• Extensively worked on DB connect to extract the data from 3rd party systems.
• Handled UAT for rollouts

Environment: COBOL, JCL, DB2, Cognos, Stored Procedures,SAR, NDM, FILE-AID, IBM utilities, FILE-AID, CA7, Librarian, IPMS, IQMS, IRIS, Expeditor,DFSORT,QC