SUMMARY

• Over 7 years of experience in Mainframe Technologies.
• Professional experience in all the phases of Software Development Life Cycle (SDLC) viz. requirement analysis, architecture, design, development, testing, documentation and post implementation revisions using Agile and Waterfall Methodologies.
• Excellent knowledge on core Mainframe technologies like COBOL, JCL, DB2 SQL, CICS, VSAM and IBM tools & utilities.
• Support Database Administration (DB2 DBA) tasks like DB2 backup and recovery, DB2 security issues and database performance tuning.
• Hands on experience on DB2 DBA utilities like Copy, Recover, Load, Unload, Quiesce, Reorg, Runstats, Check data, Check index, Repair etc
• Working experience on DDL, DML and DCL language on DB2.
• Good at creating design documents, UTP, UTR using MS Excel, MS Power Point, & MS Word.
• Good exposure in requirements gathering & analysis, preparing detailed design, development and testing.
• Used Flowcharts to prepare the Detail Design Document (DDL).
• Implemented business logic with advanced level programming using COBOL in development and major enhancement projects.
• Good hands on experience and knowledge on COBOL-DB2 batch programming using JCL and PROC.
• Experience in creating batch reports on Infoman tool.
• Strong working knowledge of Structured Query language (SQL), RDBMS concepts and objects like Database, Tablespace, Tables, Views and Indexes.
• As an application developer used structured coding in COBOL using DB2 to achieve business results.
• Good knowledge & hands on experience in working with most of the Mainframe tools & utilities like FileAid, ChangeMan, Endevor, Xpeditor, Smarttest, SPUFI, QMF, Jobtrac, Platinum, BMC Tools, Infoman, Syncsort, Abendaid, DFSORT, ICETOOL.
• Strong development experience and debugging skills.
• Monitoring production batch operations, which also include scheduling and monitoring jobs for SIT & UAT.
• Participated in performance improvement activities for both batch and online modules.
• Created unit test plans (UTP), performed unit testing and documented unit test results (UTR).
• Assists in integration, systems, acceptance, and regression testing with the testing team.
• Compliant with IT policies and procedures, especially those for quality and productivity standards that enable the team to meet established milestones.
• Good analytical & communication skills and ability to work independently.
• Good working experience in Coordinating and Supporting the Development, Testing and Deployment of Project in Off-Shore/On-Site model.

EDUCATION
BS in Computer Science

EXPERIENCE

Confidential,SD Jan 2012 – Sept 2012
Dispute Processing Systems
Sr. Mainframe Developer
This project settles disputes on credit card transactions like lost/stolen cards, fraud transactions, multiple charges for single transaction, damaged cards, billing errors, incorrect charge backs etc. DPS receives responses from PRPC and validates data from DB2 tables and the sends the data back to PRPC system. DPS also generates the settlement reports/letters for the customers.

Braille and large print for Horizon – COBOL-DB2 Developer and DB2 DBA
Citibank sends hard print letter communication to customers. For visually challenged persons these letters were printed in Braille and large which currently costs $54 as they were manually typed. The objective of this project was to create letters in automated way and send to Horizon for Blind, a third party vendor who would print. With this automation the cost of letter would be an average $4 bringing in annual save of $ 0.5 Million. As a part of this project, we extracted the records from DB2 tables and inserted them in a file to send to the Horizon.

Role:

• Coordinated with Business Analyst to define requirements, analyze business needs and validated solutions with client.
• Prepared the estimation document for the requirement.
• Prepared the Detail design document (DDL) for all the functional requirements.
• Creating the Flowchart and coding of application programs using Cobol and DB2.
• Developed JCL’s, procedures as per the client standards
• Execute the batch module using JCL.
• Used DB2 FileAid for preparing test data.
• Submitting the batch jobs (JCL) via Jobtrac.
• Modified the existing online programs using CICS.
• Preparing UTP and UTR.
• Creating package in ChangeMAN to install code in UAT and Prod environment.
• Altered the DB2 tables to accommodate new columns.
• Copied data from production region to UAT/Dev region as part of DB2 DBA activities.
• Done DB2 backup and recovery tasks.
• Performed Db2 Security tasks.
• Performed DB2 performance tuning.
• Used IBM utilities like IDCAMS, IEBGENER, IEFBR14, DFSORT etc.
• Experience with code review and peer review.
• Excellent problem solving skills and ability to work independently.
• Prepared code documentation for future reference and upgrades.
• Participated in weekly status calls and updating status of the project.
• Understanding the existing functions and designing the system for the enhancements.
• Provided post implementation support.

Confidential,FL May 2009 – Jan 2012
Sr. Mainframe Programmer Analyst

AML Datastore Phase II – Cobol and DB2 developer
AML datastore already exists for UK and now they want to make data store for Germany & Netherlands. We need to make 2 new data spaces for Germany & Netherlands and also we need to add 2 new fields to the existing data store of UK. We used the IMS DB database as well as DB2 tables to fetch data. We used to fetch data from the DB2 tables based on PCN number which is a unique number given to all the credit card holders of American Express. Following were the requirements.

• A one-time feed of all approved accounts is required from GNA, CARE and GLOBESTAR systems.
• Daily data feed of all new applications will be required from the GNA, CARE and GLOBESTAR systems to the AML database of Netherlands and Germany markets.
• Apart from the existing fields, the new field “Id confirmed level” and “Bank Verified” should also be provided by the GNA team henceforth in the daily feed as well as a one time feed for the already existing customers the data for which is already present in the current AML Datastore(for Uk market).

Role:

• Coordinated with Business Analyst to define requirements, analyzed business needs and validated solutions with client.
• Preparing the estimation document for the requirement.
• Analysis, Coding, Unit Testing, Regression Testing, Implementation of the new requirements.
• Prepared the High level design document for all the functional requirements.
• Creating the Flowchart and coding of application programs.
• Preparing UTP and UTR.
• Used Endevor for creating new modules as well as for altering the existing modules.
• Developed programs using COBOL, DB2, JCL.
• Used DB2 FileAid for preparing test data.
• Coding program in Endevor with client supplied coding standards.
• Submitting the batch jobs (JCL) via Jobtrac.
• Created new DB2 tables to accommodate fields for Germany and Netherlands.
• Altered the existing DB2 tables to add new columns for UK market.
• Developed JCL’s, procedures as per the client standards.
• Used Syncsort utilities for data manipulations and data formatting.
• Analysis, testing and debugging of new code before it promotes to production.
• Experience with code review and peer review.
• Participated in weekly status calls and updating the project status.
• Excellent problem solving skills and ability to work independently.
• Prepared code documentation for future reference and upgrades.
• Understanding the existing functions and designing the system for the enhancements.
• Provided post implementation support.

GNA has to replace the Pitney bowes with DQME for matching of the data. Earlier all the matching of the data used to be done by Pitney bowes system but now GNA has to send the applicant data to DQME and then DQME will send the matching information back to GNA. For this we need to establish a new MQ Request & Response message layout(s) between GNA and DQME for US Amex check. DQME will pass the required data for candidates with direct/possible matches. Then GNA will process the data.
Role:

• Involved in all phases of SDLC involving requirement gathering, estimation, design, implementation, testing, deployment and documentation.
• Discussed with business analyst and line of business to understand the exact requirements and wrote down the functional specification
• Impact analysis of the new requirement or change request on the existing programs.
• Identify and verify the impact based on the changes in downstream/upstream applications.
• Prepare and review the detailed design specification document
• Developed programs using COBOL, DB2, JCL.
• Coding program in Endevor with client supplied coding standards.
• Submitting the batch jobs (JCL) via Jobtrac.
• Performing functional testing and unit testing for batch and online programs using xpediter set up.
• Performing unit testing, system testing, integration testing and regression testing.
• Providing weekly project status to all the project stake holders.
• Experience with code review and peer review.
• Excellent problem solving skills and ability to work independently.
• Prepared code documentation for future reference and upgrades.
• Understanding the existing functions and designing the system for the enhancements.
• Provided post implementation support.

Confidential,TX Oct 2005 – April 2009
Sr. Software Developer

Worked on Major enhancements in Legacy application for Supply Chain Management division of Nissan North America (NNA). Enhancements leading to major overhaul in the Vehicle Management Systems (VMS) for NNA .Earlier, the plant floor system often had difficulty at End of shift to communicate with VMS which caused delays in start of batch window and inventory shortage or excess obsolesce. Enhancements bringing in better flexibility in issuance of inventory overbuys with in a time span of daily and weekly orders than the current systems which allowed only 1 overbuy for a period of 6 months.

VMS End of Shift
Plant floor systems often have difficulty with end of shift processing which transmits data to the Vehicle Management System (VMS) to indicate that production for a particular shift is complete and to initiate the batch window. When this occurs, application support is required to manually intervene to start the batch window. It may take as long as one hour when application support has to get involved to start the window which is critical time lost for window processing.
The VMS posting and end of shift process is at the facility / pay point level. This design assumes that all paths within a facility are working the same shift pattern. With the introduction of the three shift work pattern for Altima at the Canton facility, this has presented the need to add path level granularity to this process to support varying shift patterns by path within a facility. Historically, there has always been a static period between end of shift and the start of the batch window where no production results were posted. With the 24 hours of production for the Canton Altima, there is no static period for posting causing some inaccuracies in the system which could lead to part shortages or excess part obsolescence. This issue is referred as “Over posting”.

Role:

• Understanding the High Level design and preparing the Requirement understanding document.
• Preparing the Detail Design Document, test plan documents.
• Developed programs using COBOL, DB2, JCL.
• Coding program in Endevor with client supplied coding standards.
• Submitting the batch jobs (JCL) via Jobtrac.
• Documented Unit test plan (UTP), Unit test cases (UTR).
• Helped customers during System testing and Integration Testing and fixed defects identified during the test runs.
• Supported the QA team through the test cycles.
• Preparation of status reports and highlighting risks in the project.