*** ******** ********* ****, ********** MO ***** Web: www.prijbs.com

Tel 510-***-**** Fax 636-***-**** Mob#:- 636-***-**** Email: abn1vp@r.postjobfree.com

Sandeep Reddy Gangula

Current Location: St. Louis, MO

Availability: Now

Visa Status: H1B Visa from PRI Inc

Relocation: Willing to Relocate anywhere in US

Summary

• Currently associated with Accenture Services Ltd., a leading Consultant and Service Provider Fortune 500

company operational in more than 150 countries

• Around Seven years of professional experience in IT industry in Analysis, Design, Development,

Implementation and Testing Software Applications

• Six Plus year of experience in developing, debugging, maintaining and enhancing Health Insurance

Application using Mainframe technology. My technology Forte is COBOL, JCL, REXX, VSAM, CICS, DB2,

EZtrieve, ISPF, IBM Utilities, SQL SERVER etc

• My domain expertise is on Health Insurance having a rich understanding of fundamentals of Health

Insurance, Claim Processing, Claim Payment, Claim Functionality, HIPPA, etc

• Expertise in REXX language for building tools on Mainframe

• Exceeded client expectations in development of scalable Mainframe Applications

• Expertise in writing and implementation of the Packages, Triggers, Stored Procedures, Functions, views,

DTS indexes at Database level and Form level on Oracle 10g, and SQL Server

• Clear understanding of business procedures and ability to work as an individual and as a part of a team

• Excellent analytical, functional, design and development skills with excellent communication skills, both

written and verbal

• Ability to work in both individual and team environments

• Excellent skills to express complex concepts and work collaboratively with people from diverse disciplines

and varying degrees of technical experience

Technical Skills

• Operating Systems: Z/OS, Windows NT/2000 95/98/ME/7

• Relational Databases: DB2, MS Access, Teradata

• Languages: COBOL, JCL, CICS, REXX, VSAM

Tools:

• General: File-Aid, QMF, RMDS, SPUFI, File Manager

• Debugging: Xpeditor, Abend Aid, RACF, ISPF, SDF, File Manager, CA7

• Testing: Playback, QA Hiperstation

• Software Products: GDG, Mercury Test Director, Iservice

Configuration Management: Endevor

Achievements and Certifications:

• Tech check in COBOL, VSAM and JCL

• Mainframe Certification from Accenture Mainframe Capability Team

• Healthcare 101 Fundamentals of healthcare Certification

• Healthcare 201 Claim Processing Certification

• Basic Claim Certification of one of the Largest Insurance company

• IBM CICS Internal Certification

• IBM DB2-700 Certification

Professional Experience

Career Profile

Organization : Accenture Services Pvt Ltd

Designation : Senior Software Engineer

Duration : October 2005 till date

Company Location : Chicago, USA

Company Website : www.accenture.com

Company Description:

Accenture is a global management consulting, technology services and outsourcing company, committed to

delivering innovation. Accenture is well known for providing Innovative solutions, giving good management

planning and delivering high performance to the client. We has extensive relationships with the world’s leading

companies and governments and work with organizations of all sizes including 84 of the Fortune Global 100 and

two-thirds of the Fortune Global 500. Our commitment to client satisfaction strengthens and extends our

relationships. For example, 93 of our top 100 clients in fiscal year 2004, based on revenue, have been clients for at

least five years, and 73 have been clients for at least 10 years . Accenture can mobilize the right people, skills and

technologies to help clients improve their performance .

Techno – Functional Exposure and Responsibilities:

• 7 year of experience in developing, debugging, maintaining and enhancing Health Insurance Application

using Mainframe technology. My technology Forte is COBOL, JCL, REXX, VSAM, CICS, DB2,

ISPF, IBM Utilities, etc

• Experience in writing the CICS, DB2 and Batch COBOL programs

• Has developed various BMS Map Screens in CICS

• Involved in the Deployment process of various Releases

• Good working knowledge of Endevor, ISPF, File-Aid etc

• Good knowledge of writing SQL queries using QMF or SPUFI in File-Aid

• Proficient in all phases of Software Development Life Cycle

• Extensive experience on writing Unit Testing cases

• I have got good communication skill (both written and verbal), am a fast learner and can learn new

technologies very soon

• I am extremely performance driven, and can analyze problems and can come up with solutions very

fast

• Always ready to take new approach and initiatives in the work assigned to me, and always finish my

work before deadline

• I am an excellent team player, and at the same time I can do a work individually very well

Project Details

Project : Billing & Remittance

Client : Express Scripts

Duration : November 2010 to December 2012

Location : St. Louis, MO

Role : Team leader

Express Scripts is a PBM, makes the use of prescription drugs safer and more affordable for tens of millions of

consumers through thousands of employers, government, union and health plans.

Responsibilities:

• Lead Developer

• Production Support

• Design, coding, Unit Testing, Defect Fixing and Post production support during warranty period

• Developing controls for the Application

• Offshore Coordinator

• Worked as a Quality Coordinator within the team, where I was responsible for maintaining the quality of

the documents prepared by the whole team

• Participated in internal and external SOX and SAS16 audits

• Conducted Technical trainings at the project level as well as Accenture level

• Took Application level trainings for new joiners within the project

• Created tools within the project to increase productivity by automating the repetitive tasks

• Built Automated the Controls for the Current system

Detailed description of the work done by me during my tenure in the project:

I am designated as On call support person for the system, I support the system 24*7 . I am also handling

the Integration Projects.

My First Assignment was to add Business functionality, which involved almost 20 Batch Program

changes, 10 JCL Changes and creating one Stand alone screen (CICS).

Next Assignment was to enhance the code in First fill first Generic project, changed 2 CICS screens and

changed the 3 Online programs to include the functionalities

My Next Assignment was EOP language translation project where I changed 5 Batch modules and 2

EXtrieve modules for changing the reports.

My Nex t Assignment was to Build controls sytem, I was able to build Key Controls around the

system and automated few of them

I am responsible for the SOX and SAS16 Audits from our team that is conducted every quarter. I co-

ordinate with Auditors to test some of our Key Business Functionalites.

Environment:

Technology : Mainframe

Languages : COBOL, JCL, VSAM, CICS, etc

Database : DB2,

Tools : Endevor, File Manager, File-AID, Xpeditor, IService

Project : Claims Recovery

Client : WellPoint

Duration : September 2008 to October 2010

Location : Indianapolis, IN

Role : Lead Developer

WellPoint is one of the nation’s largest health benefits companies, with 34 million members in its affiliated health

plans and more than 65 million individuals served through its subsidiaries. One in nine Americans receives

coverage for their medical care through WellPoint's affiliated plans.

Responsibilities:

• Lead Developer

• Project Execution

• Design, coding, Unit Testing, Defect Fixing and Post production support during warranty period

• Worked as a Quality Coordinator within the team, where I was responsible for maintaining the quality of

the documents prepared by the whole team.

• Conducted Technical trainings at the project level as well as Accenture level.

• Created tools within the project to increase productivity by automating the repetitive tasks.

Detailed description of the work done by me during my tenure in the project:

My assignment was to develop queries on Teradata to retrieve the Claims that are wrongly Paid.

I have developed the Scenarios to retrieve the Wrongly Paid claims. I took responsibility on one of the

systems (FACETS) to recover the Claims.

Also automated these queries to run on Informatica on every Month for newer Claims.

Used Mainframes for FAST Unloading the Data for some required information and also wrote programs to

retrieve Data on Monthly basis .

Environment:

Technology : Mainframe, Datawarehousing, Green Plum

Languages : COBOL, JCL, VSAM, REXX, CICS etc

Database : DB2, Teradata etc, SQL Server, Green Plum

Tools : Talend, Informatica

Project : SPRF

Client : United Health Group

Duration : October 2005 to August 2008

Location : NewJersey, NJ

Role : Lead Developer

Roles and Responsibilities:

• Analysis

• Design

• Coding

• Unit Testing

• Defect Fixing

• Post Production Support for Modules delivered

Detailed description of the work done by me during my tenure in the project:

My first assignment in the team was to expand a file layout and also add new fields in the screen.

This module used both Batch changes as well as online changes. The quality of work was of high

standard and with no defects and was appreciated by the client.

My next assignment involved a complex change which was affecting the functionality of the whole

business. New screens, programs and tales were introduced as part of this change .The changes were

delivered on time and with defined quality standards. No issues were reported even in production for

these changes.

Next assignment was a project where there were lot of unclear requirements as a reason of which

the changes were complex. The BRDs were changed many times during the coding phase but still then

I was able to deliver the final product on time.

My next assignment was to make some enhancements to the existing screens used by the business.

This was delivered with zero defects .Got appreciated by client as this reduced a lot of response time .I

was acting as a developer lead for this assignment and was managing some other modules along with

mine.

Additional Responsibilities:

• Worked as a Quality Coordinator within the team, where I was responsible for maintaining the quality of

the documents prepared by the whole team

• Participated in internal audits also for the same

• Conducted Technical trainings at the project level as well as Accenture level

• Took Business level trainings for new joiners within the project

• Created tools within the project to increase productivity by automating the repetitive tasks

Environment:

Technology : Mainframe

Languages : COBOL, JCL, VSAM, REXX, CICS

Database : DB2

Tools : Endevor, Xpeditor (Batch & Online), File AID, CA7 Scheduler, SDF,

Playback, QA Hiperstation, Mercury Test Director

Degree and Date Institute/ Board Marks Major and

Scored Specialization

BE College Of Engineering,

72 June, 2004

Osmania University, A. P.

Gautami Junior College, 90 June, 1999

INTERMEDIATE

Hyderabad,A.p.

Sri Aurobindo School, Jangaon, 82 March, 1997

SSC

DIST: Warangal Andhra

Pradesh

Education Qualifications: -

Contact this candidate