Post Job Free

Resume

Sign in

ETL Developer

Location:
Irving, TX
Posted:
February 21, 2018

Contact this candidate

Resume:

SESHAGIRI VUMMANENI

Contact No.: +1-551-***-****

ac4kct@r.postjobfree.com

Professional Summary:

More than 7 yrs of experience as a Abinitio developer

Extensively worked on Abinitio Tool using various components like rollup, join reformat and techniques like parallel processing, component folding etc,.

Good knowledge on Conduct>IT (Plans), validation extension.

Exposure on Business Rule Environment (BRE).

Working with EB CIDIC,XML,flat files processing

Well versed with the Healthcare demine’

Worked on all the phases of SDLC from requirement gathering to product support.

Won client accolades numerous times

Worked on the Mainframe screens

Worked on Solaris, AIX, Redhat, Windows, Z O/s operating Systems

Worked on Databases like Oracle, SQL Server, DB2

Worked on the Quality Analysis of the products, responsible for the Defect tracking and Classification.

Sound knowledge on generating Human readable formats of reports (Excel) using Abinitio.

Job Experience:

Name of the Company

Designation

Address of the employer

From

To

Duration(Years)

Cognizant Technology Solutions

Projects- Associate

Client Location USA

2017/02/22

Till Date

1

Cognizant Technology Solutions

Projects-Associate

DLF Building, Block - 1, Plot # 129 to 132, APHB Colony, Gachibowli, Hyderabad 500019, India

2012/11/21

Till Date

4

Techsource Solutions

Software Engineer

#203, Old Madiwala, BTM 1st Stage, Bangalore 560068, Karnataka, India.

2010/05/04

2012/11/16

2

Technical Skills:

Hardware

IBM AIX Server, HP Linux,

Operating System

Linux, UNIX, OS-390, zOS, Windows XP/7

Programming Languages

AbInitio DML, AbInitio Meta-Programming, UNIX Scripting, Python, SQL, PL/SQL,

Databases & Tools

AbInitio ETL, DB2, Oracle, Teradata

Other Utilities

FileZilla FTP tool, SQL loader, Putty

Location

Hyderabad, India

OTHER SOFTWARE COURSES/CERTIFICATION COMPLETED THROUGH COGNIZANT ACADEMY

No

Name of Institution

Diploma or Certificate

Year of Completion

1

Pharmacy Benefit Manager(PBM)

Cognizant Internal Certification

2013

2

Working with Design Pattern, Tools and Principles

Cognizant Internal Certification

2015

3

Abinitio Vendor Training

Abinitio Basics, EME, PDL, Meta Programming.

2015

4

Advanced Abinitio Co>op

Cognizant Internal Certification

2016

Project #1:

Role – Business Relationship Manager (BRM).

Project Title

Anthem Benefit Load

Duration

01/15/2018 to till date

Location

Cognizant Technology Solutions, Hyderabad

PROJECT DESCRIPTION:

The customer is a second Largest Pharmacy Benefit Manager (PBM) who manages prescription drug programs on behalf of insurance carriers. This is done by setting plans up with different Copayment tiers.

One of the biggest insurance carrier moved from one PBM customer to another. Hence based on my previous experience in same domain, working as a BRM.

ROLES AND RESPONSIBILITIES:

Understand the Healthcare plans

Map the carrier health plans to Existing Customer’s clime adjudication system.

Plans will load into system using ETL tool (Informatica).

Project #2:

Project Title

Benefit Builder

Duration

06/01/2014 to 01/12/2018

Location

Cognizant Technology Solutions, Hyderabad

Hardware

IBM AIX Server

Operating Systems

AbInitio Co-Op System, Linux, Windows 7

Programming Languages

AbInitio ETL, DB2 and Unix Shell Scripting

PROJECT DESCRIPTION:

The customer is a Largest Pharmacy Benefit Manager (PBM) who manages prescription drug programs on behalf of insurance carriers. This is done by setting plans up with different Copayment tiers. The previous process of setting up the CoPay configurations is manual and was a Project oriented approach. It consumed few weeks to several months to complete a bulk CoPay project.

The Benefit Builder is a Copayment (CoPay) configuration system. The purpose of this project is to build a generic platform that allows the business users to run queries based on a list of criteria’s, modify the CoPay configurations, and complete a bulk load for Client Specific and Medicare Part-D Copays. AbInitio BI tool is used to provide the business solution to bulk CoPay loads.

Applications:

BWS – Benefit Work Station (Designed to load Medicate Plans)

ABL – Automatic Benefit Load (Designed to load Anthem specific Benefits)

CLIENT DESCRIPTION:

The client is a Fortune 100 company, and it is one of the largest Pharmacy Benefit Management organizations in the United States. The company processes pharmaceutical claims for members at network pharmacies and at their own mail order pharmacies. It provides integrated pharmacy benefit management services including network-pharmacy claims processing, home delivery services, specialty benefit management, benefit-design consultation, drug-utilization review, formulary management, and medical and drug data analysis services to manage drug plans for government agencies (both as administrator of employee benefits and public assistance programs), corporations, and unions.

ROLES AND RESPONSIBILITIES:

Responsible for all the deliverables from Benefit Builder development team.

Point of Contact for the CoPay and Medicare Part-D CoPay processing modules.

Involved in effort estimation and development plan.

Assigning work to the team on daily basis and ensure the deliverables are on time with high quality. Onsite/Offshore Co-ordination (Developers, Onsite co-coordinator)

Requirements Gathering (Participating in Requirement walkthrough sessions and Understanding Functionality) and Analysis.

Technical design and documentation. Responsible for designing, developing and unit testing the business logic in AbInitio.

Production support activities. Generating on-time on-demand reports and preparing project dashboards for Business team to enable quick decisions.

DURATION OF THE PROJECT:

1 Year 5 Months and On-going.

Project #3:

Project Title

Benefit Migration

Duration

12/01/2012 to 05/31/2014

Location

Cognizant Technology Solutions, Hyderabad

Hardware

IBM AIX Server

Operating Systems

AbInitio Co-Op System, Linux, Windows 7

Programming Languages

AbInitio ETL, DB2 and Unix Shell Scripting

PROJECT DESCRIPTION:

The customer is a Pharmacy Benefit Manager (PBM) who manages prescription drug programs on behalf of insurance carriers. After acquiring another PBM, a decision was made by the Client to use acquired PBMs code-base/processes for future because of its high flexibility and better functionality. A new project is designed to move/migrate the data into this new system in a tiered approach.

The project mainly aims at automating the manual migration of the client data from legacy to the new system. AbInitio BI was chosen to carry out the automation of this migration because of it highly sophisticated transformational abilities.

Each tier migrates the Benefits, Clinical rules, Coverage rules, CoPay configurations and Pricing rates to the new system using AbInitio processes. The development team is responsible for creating the intent/load ready datasets by transforming the data from legacy system to the proposed systems’ compatible format.

Since, the legacy systems are active till the time the new module is completely active, changes may happen to the rules/rates and new system should be updated with these updates as well. The team is also responsible to perform this Dual Maintenance activity. Even if a Tier is live, the team compares the Legacy data and existing data to identify and updates/inserts/deletes through dual maintenance processing and brings the new systems’ data to sync with these updates periodically. So the project actively works on the current Tier migration as wells as the dual maintenance activity related to the migrated tiers.

CLIENT DESCRIPTION:

The client is a Fortune 100 company, and it is one of the largest Pharmacy Benefit Management organizations in the United States. The company processes pharmaceutical claims for members at network pharmacies and at their own mail order pharmacies. It provides integrated pharmacy benefit management services including network-pharmacy claims processing, home delivery services, specialty benefit management, benefit-design consultation, drug-utilization review, formulary management, and medical and drug data analysis services to manage drug plans for government agencies (both as administrator of employee benefits and public assistance programs), corporations, and unions.

ROLES AND RESPONSIBILITIES:

Responsible for all the deliverables from the development team.

Point of Contact for the CoPay and Pricing modules.

Involved in effort estimation and development plan.

Assigning work to the team on daily basis and ensure the deliverables are on time with high quality. Onsite/Offshore Co-ordination (Developers, Onsite co-coordinator)

Requirements Gathering (Participating in Requirement walkthrough sessions and Understanding Functionality) and Analysis.

Involved in rigorous technical analysis using AbInitio features for providing migration solutions.

Technical design and documentation. Responsible for developing code to transform the Client rules/rates from legacy Anchor compatible format to the new format. Automation of process using Shell scripting and AbInitio Graphs.

Production support activities. Generating on-time on-demand reports and preparing project dashboards for Business team to enable quick decisions.

Preparation of effort estimation for various tasks taken up. Actively involved in data loading and data extract processing activities. Responsible for Production loads.

Responsible for executing Dual Maintenance activity to identify changed Rules/Rates and load them into Production systems upon approval.

DURATION OF THE PROJECT:

1 Year 5 Months (17 Months).

Project #4:

Project Title

BESTDW

Duration

08/01/2011 to 11/16/2012

Location

Wipro Technologies, Bangalore

Hardware

IBM AIX Server

Operating Systems

AbInitio Co-Op System, Linux, Windows 7

Programming Languages

AbInitio ETL, DB2 and Unix Shell Scripting

PROJECT DESCRIPTION:

The project US card development handles the development of business critical ETL application using Abinitio & Teradata as per the client standards which are in development namely BEST DW application, Proof of claim, Notification and reconciliation, Account Search, etc. which are very critical to Client Business.

CLIENT DESCRIPTION:

It is one of the lead bank in America that offers a broad array of financial products and services to consumers, small businesses and commercial clients. A fortune 500 hundred company. As one of the nation’s top 10 largest banks based on deposits, Client serves banking customers through branch locations primarily in New York, New Jersey, Texas, Louisiana, Maryland, Virginia.

ROLES AND RESPONSIBILITIES:

Getting the requirements from onsite coordinator on daily basis.

Involved in creation of Project setup.

Creating or modifying graphs according to req.

Validations are performed for the new fields that are to be loaded in the database and the transformations are performed for the same.

Implemented table inserts, updates and deletes accordingly

Unit testing of the developed Abinitio graphs.

DURATION OF THE PROJECT:

1 Year 3 Months (15 Months).

Project #4:

Project Title

The Eagle Warehouse Solutions

Duration

06/20/2009 to 07/16/2011

Location

Wipro Technologies, Bangalore

Hardware

HP -UX Server

Operating Systems

AbInitio Co-Op System, Linux, Windows 7

Programming Languages

AbInitio ETL, DB2 and Unix Shell Scripting

PROJECT DESCRIPTION:

I involved in developing data extract and Transform modules for Enterprise Data warehouse, which facilitates Client to have an integrated view of the amount and the type of business with its trade customers worldwide identifying its partners that do significant business and analyzing the profitability on the basis of customer, product, region, etc.

CLIENT DESCRIPTION:

The Client group is a diverse group of five privately held companies. Products and services offered by the Client range from trucking/intermodal to information technologies to emergency medical transport.

Responsibilities Managed:

Analyzing the requirement sent by the Leads and developing Abinitio graphs

Creation of Abinitio design and development work products (graphs) that conform to the stated business requirements and high level design documents.

Done appropriate unit-level testing of work products and the management of the review process for the Abinitio deliverables.

DURATION OF THE PROJECT:

2 Years 1 Months (25 Months).

EDUCATION

Title of the Degree with Branch

College/University

Year of Passing

Bachelor of Technology in Electrical &Electronics

Chaitanya Engineering College, JNTU

2009

XII

Vignana Bharathi Junior College, Board of Intermediate Education

2005

X

Z.P.H.School, Kothapatnam, Board of Secondary Education

2003



Contact this candidate