Professional Summary:

** ***** ** ** ********** in the field of Data warehousing as a Senior ETL Developer which includes 6 years of On-Site work experience.

Worked on informatica Power Center, Informatica TDM, Informatica BDM, Oracle PL/SQL and UNIX Shell scripting & Python tools.

Worked on multiple domains like Manufacturing, Supply Chain, Health Care & Telecommunication systems.

Experience of working on complete project development life cycle which includes Requirement analysis, Design, Development, Testing, Deployment and Maintenance through different project development methodologies like Waterfall and Agile.

Experience with Data Extraction, Transformation and Loading (ETL) from different data sources like DB2, Oracle, MS SQL Server, Teradata, Salesforce, Azure Could & Flat files.

experience in implementing complex business rules by creating re - usable transformations and robust mappings/mapplets using various transformations.

Good amount of knowledge on Power Center Performance tuning techniques and SQL query optimization & tuning techniques.

Experience of working on Informatica TDM in providing the de-identified test data to non-production environments for testing data needs.

Worked on Informatica Big Data Management (BDM) tool with Cloudera Hadoop Platform.

Possess good Communication, Interpersonal & Analytical skills.

Ability to work under strict deadlines and diverse conditions.

Ability to perform independently as well as leading a team of 2-3 resources technically.

Technical Skills:

Data Warehousing (ETL Tools)

Informatica Power Center, Informatica TDM and BDM

Databases

Oracle (SQL & PL/SQL)

Programming Languages

Unix Shell Scripting and Python Basics

Cloud Technologies

Azure Fundamentals.

Employment History:

Name of the Company

Designation

From

To

Duration

Lumen Technologies

Senior Software Engineer

Feb’ 2022

Till Date

1.10 Years

Cognizant Technology Solutions

Associate- Projects

Mar’ 2014

Jan’ 2022

7.10 Years

iGATE Global Solutions Limited

Senior Software Engineer

Oct’ 2010

Sep’ 2013

3 Years

Datacore Technologies Pvt. Ltd.

Software Engineer

April 2010

Sep’ 2010

0.6 Years

Project Profile:

#7 Project Name

Hawkeyes Service Assurance & Service Delivery

Client

Lumen Technologies

Location

Oregon, United States of America

Technologies Used

Informatica 10.1.0, Oracle, UNIX & Azure Basics

Duration

February 2022 – Till date

Project Description:

Lumen Technologies Data Enablement provides data solutions related to special initiatives like Gainsight, integration and consolidation efforts into centralized data stores related to Sales Orders, Trouble Ticketing, and Revenue, new product development initiatives, and executive data needs for Sales, Service Delivery, Service Assurance, and Operations to meet our business stakeholder data needs. We deliver data warehouse and big data/data lake implementations and make sure that quick turnarounds happen when new requirements continue to come in. The team works in a truly agile and PI planning approach. We collaborate and coordinate with our stakeholders and coworkers continuously to deliver software implementations.

Roles & Responsibilities:

Worked with architects, system engineers and product owners to understand/detail business and system requirements and logical/physical data models.

Worked with scrum team members and other team's system analysts to create/update/enhance source to target mapping documents.

Worked on quality assurance to generate test plans and test cases.

Analyzes programming requests for the purpose of assisting integration with current applications Develops ETL code, test scenarios and assists with UAT Build and data loading for User Acceptance Testing.

Estimates levels of effort (LOEs) for work requests: analysis, design, development, and testing.

Participates in and/or consults on Integrated Application and Regression Testing Tasks that include project implementation, researching and evaluating problems, and recommending and implementing decisions.

Conducts training for the purpose of providing technical expertise to end users.

#6 Project Name

Kaiser - Regulatory Finance

Client

Kaiser Permanente

Location

Oregon, United States of America.

Technologies Used

Informatica 10.1.0 with BDM, TDM, Oracle, UNIX, & Python

Duration

May 2015 – January 2022

Project Description:

As part of Section 1343 of Affordable Care Act (ACA), created the Risk Adjustment program to better spread the financial risk borne by health insurance issuers to stabilize the premiums and provide issuers the ability to offer a variety of plans to meet the needs of the diverse population. Under the risk adjustment program payments will be transferred from issuers with relatively lower risk populations to issuers with relatively higher risk populations. on-grand fathered individuals and small group market plans irrespective of whether they are the part of exchange will submit the risk adjustment data (Claims & Enrollments) that will be used to determine individual level risk scores, plan average actual risk and associated payments and charges.

Roles & Responsibilities:

Sr. ETL Informatica Developer & Lead:

Analyzing the requirements and Preparing the High level & Low-level design documents with the proposed solution to handle the business requirements.

Developing the code as per the approved design documents and conducting the internal peer reviews. Preparing the UTC documents and capturing the Unit Test Results.

Migrate the code to higher environments SIT & UAT. Provide support for System Integration and User Acceptance testing.

Providing the hand over to Production Support Team after successful completion of SIT & UAT and before Deploying to the Production.

Preparing the deployment documents to migrate the code to Production Environment with necessary business approvals.

Post-Production support like production deployment validations and post-production issue fixes if any.

Participating in daily/weekly status calls to provide the status on the project related activities.

TDM Informatica Developer:

Preparing De-identified data for all ACA applications for V2016 and v2019 SMP rules as per CMS regulations.

Data Masking – Data Creation, Masking of sensitive fields and loading the masked data to non-Production environments.

Create the masking policies and apply on the data sources and generate workflows into informatica power center using informatica TDM web portal tool.

Collecting the Intake requests for data preparation from different applications (3R, Edge Server, CSR, KPMETA, RSAC, RACS and RADA) and preparing data and perform validations and run post load updates.

Coordination and Collaboration with various application teams and stake holders.

Worked with Python developers to build scripts to automate the TDM processes and validate the data between actual source systems and TDM databases.

POC Using Informatica BDM with Cloudera Hadoop Platform:

DSSHCR - 2Rs project has been implemented using Informatica power center, UNIX and Oracle tools for the Enrollment, Pharmacy and Utilization tracks. The new project which comes under Kaiser Permanente will leverage the Cloudera Hadoop platform and the Extract, Transform and Load part need to be implemented by Informatica Big Data Management tool. The purpose of the POC is to detail the business use case which needs to be implemented using the Informatica BDM tool with Cloudera Hadoop platform. This use case focuses on the processing capabilities of Big Data Hadoop platform by pushing down the Informatica BDM transformations into Hadoop cluster.

Tools Used: Informatica BDM with Cloudera Hadoop Platform, Oracle SQL Developer and UNIX.

Roles & Responsibilities:

Develop the ETL mappings, workflows using BDM tool to replicate the existing system’s scenarios for both Enrollment and Utilization tracks.

Created and Executed the ETL jobs using Blaze, Spark and HIVE engines and compared the performance statistics between all three engines.

Created the ETL objects to use all the possible transformations to verify the capabilities and limitations in using all the three engines.

#5 Project Name

DSSHCR - 3R’s Purging

Client

Kaiser Permanente

Location

Oregon, United States of America.

Duration

April 2014 – April 2015

Technologies Used

Informatica, UNIX and Oracle

Project Description:

As part of Kaiser Permanente data management policies archiving and purging of data is recommended for every application depending on the business needs. Claims Management System (CMS) mandates data submitted by all vendors must be retained for a certain period (5 Years) for audit purposes.

Data Archiving/Purging is the process of identifying and moving inactive data out of the current production systems and into long term archival storage systems. Moving inactive data out of production systems optimizes the performance of the resources needed there while specialized archival systems store information more cost–effectively and provide for retrieval whenever needed.

Roles & Responsibilities:

Analysis on the Retention periods required on SST / HST / VAD tables for purging / Archival by setting up the meetings with respective teams.

Involved in the creation of PL/SQL stored procedures to purge the data for individual schemas.

Involved in the creation of ETL jobs to automate the purge process.

Provided Support for SIT and UAT testing Phases.

Deployed the code to SIT, UAT & Production environments.

#4 Project Name

OMAR Enhancement and OMAR Ponytail

Client

Motorola Solutions

Location

Chicago, United States of America.

Technologies Used

Informatica, UNIX, Oracle

Duration

January 2013 – September 2013

Project Description:

OMAR enhancement and OMAR Ponytail Projects are extensions of Order Management Project which involves the requirements in NA and EMEA DWH.

Roles & Responsibilities:

Detail level of analysis on Requirements given on EMEA and NA Regions and prepare design and mapping specification documents for different user requirements.

Develop the code and perform unit testing.

Provided the support for System Integration and User Acceptance testing.

Deploying the implemented changes to production.

Also worked on Production support activities to schedule & monitor the EMEA of NA data Loads.

#3 Project Name

Motorola EIM Solution Architect

Client

Motorola Solutions

Location

Chicago, United States of America.

Technologies Used

Informatica, UNIX, Oracle & Teradata

Duration

October 2012 – December 2012

Project Description:

Problematic Issues in data at DWH level were raised as individual tickets assigned to Level 3 Support team. Key responsibility of the Assignee is to have a detailed analysis over the ticket assigned by having series of discussions with the user, support team etc. and conclude to solve the issue by finding its root cause. This project helped us to have direct one to one interaction with clients on a periodic basis in the form of calls and email communication.

Roles & Responsibilities:

Perform detailed analysis over the Issue Reported by the user in order to find the root cause.

Have periodic calls with user to understand the issue reported and to give status of the ticket.

Prepare a design document which indicates necessary solution for the bug reported.

Implement the necessary fix required and perform unit testing.

Deploy the change to Production instance upon necessary business approvals.

#2 Project Name

EIM – Order Management

Client

Motorola Solutions

Location

Chicago, United States of America.

Technologies Used

Oracle, Informatica and Unix

Duration

August 2011 – September 2012

Project Description:

The Customer, Motorola is one of the leading Mobile handsets and other electronic equipment Manufacturers. Motorola has an Order Management ERP application which maintains details of all the orders placed till its end delivery. The key objective of Order Management Data warehouse Project was to extract data from these various data sources (ERP and COF) and load them into a unified database for reporting and other purposes.

Roles & Responsibilities:

Detail level of analysis on Requirements given on EMEA and NA Regions and prepare design and mapping specification documents for different user requirements.

Develop the code and perform unit testing.

Provided the support for System Integration and User Acceptance testing.

Deploying the implemented changes to production.

Also worked on Production support activities to schedule & monitor the EMEA of NA data Loads.

#1 Project Name

HNM Spend/Savings by BU/Technology

Client

Motorola Solutions

Location

Chicago, United States of America.

Technologies Used

Informatica, UNIX and Oracle

Duration

October 2010 – July 2011

Project Description:

Business is doing ad-hoc reporting/data analysis using OBIEE answers. This OBIEE answers is built on SMS system which get orders and shipments data from GEMS NA (Liberty) data warehouse. There are three different source systems (SMS, XACTLY, SFDC) from where we need to bring the data in our Data warehouse (EDW).

Roles & Responsibilities:

Involved in requirement gathering and requirement analysis for assigned module.

Involved in preparing the technical design document for the SMS module.

Developed the Code for SFDC, XACTLY and SMS modules.

Created Unit Test Case documents and captured the unit test results

Involved in the peer Reviews.

Education:

Title of the Degree with Branch

University

Year of Passing

Master of Computer Applications.

Sri Venkateswara University

2009

Bachelor of Science in Computer Applications

Sri Venkateswara University

2006

XII

Board of Intermediate Education

2000

X

Board of Secondary Education

1998

Contact this candidate