Data Life Insurance

VEERA VENKATA RAGHUNATH INDUGU

Email – *********@*******.***

Phone – 502-***-****

Mainframe Application Developer

SUMMARY:

13+ years of excellent hands-on experience in Application development, maintenance and production support in Mainframes.

High proficiency with relevance to the different phases of Analysis, Design, Programming, Debugging, Testing, Implementation & Production Support of various application systems.

Experience in passing SQL queries, Triggers and Packages using SQL in DB2 & POSTGRES

Have very good experience in Financial services, Health care insurance, Life insurance and Credit card (Vision+) domains

Have excellent experience in working with mainframe technologies like COBOL, JCL, DB2, CICS, VSAM, REXX, Sort, SAS, TSO/ISPF,CA7 (Scheduler), Xpeditor, ENDEVOR, CHANGEMAN, PANVALET, CICS MQ series, FILE-AID, SPUFI, Control M, BMC Tools, APPTUNE, Data Studio, CA-Platinum and IBM UTILITIES.

24X7 production support, providing root cause analysis (RCA) and suggesting and implementing performance optimization ideas.

Experience in System Integration Testing (SIT), User Acceptance Testing (UAT) and Production parallel testing

Experience in leading an offshore team.

EDUCATION:

●Bachelor of Engineering in Electrical and Electronics Engineering, JNTU, India 2006

Skill Set:

Tools: ENDEVOR, CHANGEMAN, FILEAID, FILEMASTER, Xpeditor, SPUFI, QMF, Easytrieve, TCP/IP, RACF, MQ series, CA-7, Control-M, INSYNC, FTP, Connect Direct, Rumba

Databases: DB2, Oracle.

Operating System: MVS ZOS, Microsoft Windows 7, Microsoft Windows X

Programming: COBOL, JCL, VSAM, CICS, REXX, SQL, Core JAVA

Other Tools: MS Office, JIRA, BMC Remedy, MS-Visio, Microsoft Office Suite, Teradata, Spring Tool.

●Working Knowledge with JAVA 7/8 to develop Micro-services in AWS Cloud using POSTGRESQL DB

PROFESSIONAL EXPERIENCE:

Client - Vanguard, Malvern, PA

Implementation Partner: Randstad Technologies

May 2018 – Till date

Senior Software Developer

Vanguard group handles the investments at different levels such as personal investors, institutional investors, retirement plan participants and financial advisors.

EIP is the application maintaining all of Vanguard’s Funds data such as Fund static data, Holdings data, Analytics, Brokerage, Returns, Pricing, Yields etc. Almost every application in Vanguard IT references this data and EIP is responsible for distributing this data as per the respective applications requirement.

Responsibilities:

●Work with various application team owners, Product owners to understand requirements

●Involved in Designing, Developing, Testing and Implementing various Mainframe

COBOL/CICS/DB2/JCL/Eazytrieve components

●Test batch cycle support and batch monitoring using Control-M for Mainframe jobs

●Stepped up to do production support and resolve defects when major SMEs retired/moved away from the

Team. 8 member team shrunk to 3 members and during this phase learnt and did the production

support on the go.

●Worked in production team and supported the team to resolve production issues.

●Created DB2 SQL Scripts and Stored procedures as a part of Mid-tier development using IBM Data Studio

and SPUFI

●Provided Production support for CICS screens and CICS MQ jobs

●Developed Mainframe applications running on MQ series to put/get the data

●Performance tuning Stored procedures and other applications using SPUFI and IBM Data Studio

●Worked on Production defects involving data related where a lot of analysis needed to be done using DB2

SQL operations

●Weekly Production support on-call for Mainframe Jobs

●Using Control-M to monitor the Production and Test batches

Environment: Mainframes Z/OS – CICS, MQ, COBOL, JCL, DB2, Native Stored Procedures, using Control-M for scheduling, Sprint Tool to invoke SPs, Data studio, INSYNC, JIRA, Agile, Sprint, DFSORT

First data, Louisville, KY

Implementation Partner: Cognizant Technology Solutions

Dec 2015 – April 2018

Senior Associate

FD Merchant services deals with the Merchant settlement process and generates various reports for Merchants.

Credit and Debit Transactions are received daily in offsite files through various sources. It can be Merchant, Third party Vendor, Distributed applications developed in JAVA, .NET etc. However all of them will be received in the same layout determined by the Card Associations. These include Sales, Credits, and chargebacks.

Settlement team creates the outgoing files for Interchange team where they perform the edit checks and qualifications based upon the Card association’s regulations and sent to them. Then they send back the incoming files with settled transactions to interchange team.

Payment details for each merchant are received from Merchant Accounting system(MAS) which are used to validate the totals in offsite files. Then daily/weekly/monthly/fiscal reports are generated and sent to the merchants as per their requirement.

Responsibilities:

●Work with Clients for new project requirements

●Participated in Analysis, Development, Testing and production implementation activities for Mainframe components such Jobs, COBOL, Sort cards and CICS modules

●Prepare Low level design documents

●Coordinate with offshore to get the work distributed and done as per the need

●Planning for Unit testing/SIT/UAT

●Post production support for the Mainframe COBOL,DB2,CICS, JCL & SORT components

●Used SPUFI extensively to analyze database related issues

●Monitor the Mainframe batch jobs and handle the abends in order to make sure that the merchant files are processed successfully on time

●Generate Weekly and Monthly status reports for the Mainframe Batch performance.

●Co-ordinate with offshore to make sure that the nightly batches are run smoothly

●Allocate work to offshore and get the tickets to a closure

●Working on Process Improvement ideas

Environment: Mainframes Z/OS – CICS MQ, COBOL, JCL, DB2, Native Stored Procedures, using CA-7 for scheduling, File-Aid, SYNCSORT

Humana, Louisville, KY

Implementation Partner: Syntel inc

Feb 2010 – Dec 2015

Project Lead

Humana is a Health Insurance Company that markets and administers health insurance products. Also a TPA for Medicare and Medicaid services. Humana has its own commercial Health insurance products such as the medicare supplement etc.

Humana has got different ways to enroll members into various products.

1)Enrollment Application PSM – Humana receives feeds from CICS MQ, Web services, Screens, Batch files and provides an integrated solution using the automated enrollment(AE) system to systematically receive, scrub and feed enrollment data to the Customer Interface and Metavance platforms. AE has the functionality to feed customer eligibility data with cross-platform lines of business, which includes the plan, benefits, division, coverage etc. Every member enrolled in Humana has to go through the AE application.

2)Customer interface (Dev & PSM) – Humana developed a separate system to handle the Individual and Group Members for various Lines of Business are given the choice of enrolling through Web, CICS screens and batch applications. Various benefits, coverages implemented for Medicare or Medicaid or Humana products are handled in this system.

Responsibilities:

●Working in Agile Methodology. Responsible for working in Analysis, Design stories and providing daily updates in standup meeting

●Involved in meetings with Client SMEs for requirements on various online(CICS) screens, CICS Web services & MQ series or batch components to be developed or enhanced

●Preparation of understanding document, high level design, low level design of the new assignments and enhancements in existing application for Mainframe COBOL,JCL,DB2 & CICS related components

●Preparation of job flow, program flow and screen flow diagrams for the existing system

Prepare unit test plan and test data

●Schedule meetings regularly with clients to review the design specs, code modified and test results and get the authorization in each stage

●Preparation of project status report

●Coordinating onsite and offshore team meeting

●Involved in Coding and unit testing phases where the Unit testing plans are prepared once the requirements are finalized

●Involved in reviewing the code and unit test results, SIT results, running the SIT and UAT cycles end to end

●Logging defects in the SQUIDS (Humana’s product for defects logging)

●Working in Maintenance and Support, Responsible for picking up Incident/Problem/Change order tickets from Servicedesk and getting them resolved

●Automated various manual processes run to generate reports for Business using REXX, JCL

●Working with application team on reducing MIPS

●Resolving trouble tickets and providing RCA for Data related issues

●Used IBM DB2 UDB and SPUFI to perform data related analysis for database issues

●Provided 24X7 supports, problem resolution and recovery process for Mainframe Applications

Environment: Mainframes Z/OS – CICS, COBOL, JCL, DB2, Native Stored Procedures, using Control-M for scheduling, Sprint Tool to invoke SPs, Data studio, File-Aid, JIRA, Agile, Sprint.

HSBC, Pune India

October 2007 – Jan 2010

Implementation Partner: Capgemini

Software Engineer2

HSBC credit card services came up with a plan to merge code across CS (Credit services) and RS (Retails services) and functionality with Global code thus to reduce the maintenance cost. So basically the project deals with the migration of CRS portfolio to One HSBC.

Different phases in One HSBC CRS:

1. Discovery phase:

Gap identification (GAP Analysis): This is relates to the functional analysis to identify the Gaps between WHIRL and One HSBC (Global).

Gap decisioning (Harvest, Adopt, Local, and Divest): The functionalities are grouped in to the four dispositions depending on the Gap identification

Gap prioritization (Business Case development)

2. Functional impact analysis.

3. Followed by normal SDLC.

Responsibilities:

●Gap Analysis with existing functionality

●Abridged SAD document creation

●FS creation by referring Final SAD (Solution architect document)

●TS creation by referring FS and Final SAD (Solution architect document)

●Attending daily Status meeting with Onsite co-ordinates

●Functional Documents walkthrough

●Participated in coding components using COBOL, CICS, MQ series, JCL, VSAM and reviewing

●Preparing Test cases and Test case scenarios

Contact this candidate