Project Developer

GIRIDHAR YERRAGUNTA

Phone: 732-***-**** ***************@*****.***

SUMMARY

Around 14 years of experience in Software industry as Senior Software Engineer/Project Coordinator/Software Engineer in analyzing, design, research, development, management, production support and maintenance of several mainframe applications.

Have a strong experience in software design, analysis, development, maintenance, testing and troubleshooting on IBM Mainframes.

Experienced in business application development with 10 years of Systems Analysis, Application Design, Development, and Maintenance with COBOL, Easytrieve, JCL, CICS, DB2, VSAM, IMS DB, Stored Procedures,CA7, ENDEVOR,JOBTRAC and SQL.

Expertise in the Mainframe tools like TSO, ISPF, Endeavor, ChangeMan, Xpediter, File-Aid, Abend-Aid, QMF, DB2I, SPUFI and EasyTrieve.

Experienced in creating batch COBOL programs using VSAM, DB2 and IMS DB databases.

Experienced in developing BMS maps for the CICS program.

Experienced in creating JCL and JCL PROCs using various JCL utilities like DFSORT, FILEAID, IEBCOPY, IEBGENER, IEBCOMPR and ICETOOL.

Excellent knowledge in DB2 with respect to Application development and performance tuning for different applications.

Experienced in creating SQL for retrieving and manipulating DB2 database servers using query management tools like QMF and SPUFI.

Experienced in creating DB2 stored procedures using languages like COBOL and Easytrieve.

Operating systems include z/OS, OS390, MVS and Windows.

Good understanding of SDLC life cycle and involved in all the activities related to it.

Experienced in providing estimates for application development or maintenance and System Testing.

Experienced in creating High Level Design, Detailed Design and Functional Requirement documents.

Expertise in creating System Test plans, Test Strategies, Test cases and Test Completion Reports.

Excellent knowledge with Unit Testing, System Testing, Regression Testing, Integration testing, User Acceptance testing, production implementation and maintenance.

Experienced in providing on-call support for different applications. Worked as a Primary on call support for GE Corporate accounts.

Possess excellent client co-ordination and involved in various related activities like attending Project Kickoff Meeting, Preparing and sending daily and weekly status reports to stake holders of project, conducting weekly project progress meeting with projects stake holders and by addressing queries related to the project.

Possess excellent Project management skills, led large projects and involved in project management activities like adhering to process, gathering metrics, attending process review meetings and .

Have worked in onsite-offshore model for around 14 yrs and in various client interfacing roles and exceeding client expectations.

Scheduling experience with CA7,CA11,TWS,ZEKE and JOBTRAC.

Excellent knowledge in file transfers between Midrange and MainFrame (NDM,FTP,MQ etc)

Educational Qualification and Certification

Bachelor of Engineering (Mechanical), Periyar University, India

FTC Certification Foundation certification in Banking

FTC Certification Certification in Core Banking solution

Six Sigma Green Belt

TECHNICAL SKILLS

Operating systems:

Z/OS, IBM 390 series, MVS, Windows-NT/2K/XP, MS DOS, UNIX.

Languages/Front End:

COBOL, JCL, EASYTRIEVE,CICS,JAVA

Version Control:

ENDEVOR and CHANGEMAN

Databases:

DB2 V9, VSAM,SQL Server, ORACLE,XPTR, VDR

Scheduler:

CA7 and JOBTRAC

Tools/Utilities:

TSO/ISPF, QMF, SPUFI, FILE-AID,RACF, DFSORT, ICETOOL, EXPEDITOR, ABEND-AID, IBM Utilities, MS-Office,REXX,CLIST and MS Visio.

PROFESSIONAL EXPERIENCE

TATA Consultancy Servises

Mainframe Tech Lead and Project Designer (Technical Architect)

Project: GCA – Global Content Archive

Duration: Oct 2011 – Mar 2016

Client: Bank of America

Role Played: Sr. Mainframe Developer, Team Lead,Project Designer

GCA is a technology unit within DC&PST (Document Cad & Payment Services Technology) that supports a collection of content archives those are the Systems of Record for compliance with records retention regulations (UCC, Reg E, etc). GCA receives content from various sources including over 250 mainframe and midrange sources, banking centers, and back-office operations (N & S America, Europe, and Asia). Currently stores 2 Peta bytes of data and captures around 13 Terabytes of new data monthly. It is the largest consumer of mainframe DASD enterprise-wide and currently migrating towards midrange platform. XPTR and VDR are the main applications that are supporting to store these statements and reports.

Responsibilities:

Attended project kick off meeting and business case walk through meetings.

Gathered business and functional requirements from business case documents and functional specification documents.

Created High Level and Low Level design documents.

Developed and maintained Cobol programs with extensive usage of DB2 and VSAM Databases.

Developed batch applications using COBOL, DB2, JCL,SAS and VSAM.

Generated various management and user reports using JCL and Easytrieve.

Responsible for development and maintenance of Batch COBOL programs using DB2 and VSAM

Developed JCLs and PROCs using utilities like IEBCOPY, IEBCOMPR, FILE-AID and Easytrieve.

Created tools for testing activities using REXX, CLIST and Panels.

Created SQL codes using QMF and SPUFI.

Worked on Scheduling the jobs using Jobtrac,CA7 and ZEKE.

Creating CR(Change reqests) in Maximo.

Report the progress of test activities to the client on a daily basis.

Preparation of MIS on weekly basis to report the progress of all the projects and WR.

Indentifying pain areas in testing for different projects and developing methodologies to improve test coverage.

Primary on call support for mainframe application.

Environment: COBOL,Easytrieve,SAS, CICS, JCL, VSAM, Jobtrac, CA7,ZEKE,DB2,XPTR,VDR, MVS,Z/OS, Expeditor,ISPF, TSO, SPUFI, QMF,REXX, File Aid,Changeman,ENDEVOR and JOBTRAC.

TATA Consultancy Servises

Mainframe Tech Lead and Sr. Mainframe Developer

Project: Info – Reporting Project

Duration: Oct 2011 – Mar 2016

Client: JP Morgan Chase

Role Played: Sr. Mainframe Developer, Team Lead

TSS - Information Reporting project Information Reporting Infrastructure System is JPMC TSS Information reporting database for warehousing current day and prior day information for creation of customer reporting.

IRIS – Information Reporting Infrastructure System. IRIS is a centralized repository and the reporting mechanism in Mainframe system, which will replaced Global Client Access repository systems of JPMC and BANK ONE. IRIS is primarily used for Cash Reporting products. It allows users to look at Data Feeds, Accounts, Individual transactions, and Sweep Reports and run Data Exports.

Responsibilities:

Gathering requirements from Client and coordinating with offshore/Onshore for deliverables.

Client interaction for resolution of queries.

Coordinating with Client & Offshore regarding project estimates updates and execution.

Managing team members

Responsible for development of Batch and CICS COBOL programs using DB2 and VSAM

Created and modified test and production JCLs/Procs/Parms as per the requirements

Actively used SPUFI, QMF, PLATINUM, STORED PROCS, & DB2 Utilities and involved into SQL Tuning work efforts.

Review, Walkthroughs and Inspections

Production Support

Updating system documentation

Performance monitoring of the system

Created automation Tools for Test and production JCL creation and Bind JCL creation for DB2 modules

Reengineering and performance tuning for some of the old DB2 Modules

Monitor and Modify Job schedule using CA7 and ZEKE.

Review of the deliverables of all the phases.

Training to New & Existing Team Members.

Environment: Easytrieve, COBOL, JCL, CICS, VSAM, DB2, Changeman,ENDEVOR,CA7,ZEKE,TSO, Expeditor, SPUFI, STORED PROCS, SQL Server, QMF, File Aid and CA7.

TATA Consultancy Servises

Mainframe Tech Lead and Sr. Mainframe Developer

Project: EMM (Enterprise Money movement)

Duration: Aug 2007 – Nov 2009

Client: American Express (USA)

Role Played: Sr. Mainframe Developer, Team Lead

Money movement is a business capability that is being developed to use across the enterprise

Amex goal is to implement a single universal U.S. $ MM platform to be used by all AMEX business processing U.S. $ MM transactions. Today, there are applications in at least 11 different AXP portfolios that perform some type of money movement functions. Generally, these applications service a single Line of business. Over 20 different software solutions are used for moving money. None of the applications is capable of moving money for multiple lines of business, and most are not technically and functionally able to support the POA vision for Money Movement.

Responsibilities:

Acquiring functional changes in the application and preparing technical specification document.

Preparing High Level Design document and reviewing Low Level Design document, requirements Extraction document, product code and Unit test case document.

Tracking various project metrics and updated the project daily and weekly status reports.

Created Test documents for both Integration and Unit testing and tested the same to make sure it is fulfilling all the business and functional requirements.

Developed batch applications using COBOL, JCL, DB2 and VSAM.

Developed JCLs and PROCs using utilities like IEBCOPY, IEBCOMPR, FILE-AID and Easytrieve.

Created tools for testing activities using REXX, CLIST and Panels.

Created SQL codes using QMF and SPUFI.

Comply with Quality procedures to be followed in this project

Enhancing the applications as per the requirements.

Efficiently used Changeman for Version control.

Provide fix to the mainframe batch jobs whenever there is an Abend.

Environment: Rexx,Easytrieve, COBOL, JCL, CICS, Changeman, VSAM, DB2, MVS, ISPF, TSO, SPUFI, QMF, File Aid, Z/OS and CA7.

TATA Consultancy Servises

Mainframe Developer

Project: SM10 Oil Cards

Duration: Feb2005 – Jul 2007

Client: Citi Bank

Role Played: Mainframe Developer

Citigroup is the world’s largest provider of credit card products. Citi Cards North America is the industry leader with some 2.5 percent of GDP spent using its credit cards and with an estimated 10% of Citi Card sales transacted online. Information Technology (IT) is part of the Operations and Technology department at Cit Cards. The functions of Citi cards IT include business relationship management, project management, solutions, development, testing, engineering, infrastructure, information security, finance and administration, architecture, and data systems management. IT is responsible for implementing business initiatives, maintaining existing technological components, and providing production support.

SM10 is Credit card core processing system for Private Label cards (Oil Cards). Citigroup acquired the system and supports more than 60% of the oil cards in US.

Responsibilities:

Production Support for the post Implementation changes.

Adhoc Reporting using DFSORT/ICETOOL and MS Office (Word, Excel, and Outlook).

Responsible for development of Batch and CICS COBOL programs using DB2 and VSAM

Created and modified test and production JCLs/Procs/Parms as per the requirements

Performed activity using SPUFI, QMF, PLATINUM, DB2 Utilities and involved into SQL Tuning work efforts.

Controlled versions of programs and JCL using Endevor and Changeman.

Created and modified test and production JCLs/Procs/Parms as per the requirements

Analyze business requirements and modify affected code modules and screens for the new enhancements.

Performed major role in system and acceptance testing which entailed developing test cases and scenarios, coordinating and executing tests, and analyzing test results Coordinating and Conducting Unit, System and System Integration testing

Production Support for the post Implementation changes.

Answering Queries raised by customer/user

Analyze business requirements and modify affected code modules for the new functionalities.

Environment: COBOL, CICS, JCL,Expeditor, DB2, VSAM, File Aid, Z/OS, Changeman, and Endevor.

InfoTech Enterprises Ltd

Mainframe Developer

Project: SAMS (Sales Assignment and Management System)

Duration: May 2004 – Feb 2005

Client: State Farm Insurance(USA)

Role Played: Mainframe Developer

SAMS is designed to facilitate the work of AIMS (Agency Information Management System).SAMS is designed to facilitate the work of ACT (Agency career tracking). ACT is one of the subsystems in SAMS, and is available in all zones and all zones are connected to a corporate database located in Bloomington. Information about an agent will be entered through the web screens and the data will be stored in the DB2 database. A centralized database, which is located in corporate, will interface with the other zonal systems for update or transfer of Agency Online Information System (AOIS).

Responsibilities:

Responsible for development of Batch (COBOL) programs using DB2 and VSAM

Created and modified test and production JCLs/Procs/Parms as per the requirements

Performed activity using SPUFI, QMF, PLATINUM, DB2 Utilities and involved into SQL Tuning work efforts.

Controlled versions of programs and JCL using Endevor and Changeman.

Created and modified test and production JCLs/Procs/Parms as per the requirements

Analyze business requirements and modify affected code modules for the new enhancements.

Environment: COBOL,JCL,Expeditor, DB2, VSAM, File Aid, Z/OS, Changeman, and Endevor.

InfoTech Enterprises Ltd

Mainframe Developer

Project: KP VSAM TO DB2 Project

Duration: Jan 2004 – May 2004

Client: KP Health Insurance Group, USA

Role Played: Mainframe Developer

SAMS is designed to facilitate the work of AIMS (Agency Information Management System).SAMS is designed to facilitate the work of ACT (Agency career tracking). ACT is one of the subsystems in SAMS, and is available in all zones and all zones are connected to a corporate database located in Bloomington. Information about an agent will be entered through the web screens and the data will be stored in the DB2 database. A centralized database, which is located in corporate, will interface with the other zonal systems for update or transfer of Agency Online Information System (AOIS).

This project is a Health insurance project. The client is Kaiser Permanente who owns a Health insurance company in USA. As the policies Implemented by him are good, the customers are increasing day by day. So, as the database was previously in VSAM with fewer customers has to be updated into DB2. This project has 4 major modules out of which one is death claim insurance.

As VSAM cannot handle huge database efficiently, it is converted into DB2. DB2 is the best-suited database for huge databases. Here while conversion from VSAM to DB2 one to one conversion is implemented.

Responsibilities:

Responsible for development of Batch (COBOL) programs using DB2 and VSAM

Converting all VSAM files, which already exist into DB2 tables, which are more flexible.

Engaging in building the COBOL programs to access DB2 tables that were accessing the corresponding VSAM files previously.

Created and modified test and production JCLs/Procs/Parms as per the requirements

Performed activity using SPUFI, QMF, PLATINUM, DB2 Utilities and involved into SQL Tuning work efforts.

Controlled versions of programs and JCL using Endevor and Changeman.

Created and modified test and production JCLs/Procs/Parms as per the requirements

Analyze business requirements and modify affected code modules for the new enhancements.

Environment: COBOL,JCL,Expeditor, DB2, VSAM, File Aid, Z/OS, Changeman, and Endevor.

Contact this candidate