DEEPTHI PRIYANKA WATADA Email : ad2nhe@r.postjobfree.com

Phone : 919-***-****

Senior Data Engineering Analyst

Having 8+yrs. of experience in the U.S. health care domain, seeking assignments in the field of ETL, Informatica.

PROFESSIONAL SUMMARY:

8.6 years of experience in Information Technology with a strong background in Data Warehousing and ETL process using Informatica Power Center 9.1,9.6 and AB initio(1year) and BA in PCMS Project.

Extensive exposure on Informatica, Power Center 9.1 & 9.6.1, HP Service Manager, Service-Now, Advanced Query Tool (Db2), IBM i Series Navigator 12.0, Aginity Workbench for Pure Data System for Analytics 09 (Netezza), Ab Initio(2 year), Ab Initio(DXF Framework), Cognos report testing(1Yr), MYSQL, Oracle DB, TOAD, DataBricks, Data Meer, Power BI, Teradata, Python Programming,Jira, CA rally,Qtest, Azure Data factory, Snowflake

Substantial experience in all stages of Database and Data Warehouse life cycles starting from requirement gathering, analysis, design, development, testing, implementation, maintenance and support of Databases and Enterprise Data Warehouse systems for HealthCare sector.

Strong erudition about Star schema, Snow flake schema dimensional models, Fact tables, OLAP concepts and data warehousing components (Sourcing, ETL, and Reporting).

Skilled in writing SQL queries, database design and in creating indexes, functions, and sub queries.

Experience in working with healthcare administrative, medical, or pharmacy claims data to support downstream applications, data marts, and end users.

Extensive knowledge in troubleshooting of Informatica Mappings, Mapplets, Worklets and Reusable Transformations and Involved in load process of Direct, Incremental & Historical loading in Informatica.

Specialized in Functional and technical aspects of Pharmacy Benefit Management with substantial understanding of PBM domain.

Experience in Data Warehouse development working with (ETL) Extraction/Transformation/Loading using Informatica Power Center with DB2/Netezza.

Good understanding of Session logs and handling Reject loader to work with reject files.

Experience in creating and executing test plans for QA tests, User Acceptance Testing (UAT) and Post Implementation Tests in Data warehousing area.

Experience in coordinating Onsite-Offshore and mentoring junior resources.

EXPERIENCE SUMMERY

Caltek Solutions INC – Client Takeda : May 2023 to till date.

Legato Health Technologies – February 2021 to March 2023 date.

UnitedHealth Group Hyderabad March 2013 to November 2020.

Worked in different roles of OPTTUMRX projects like ETL Developer, Data Engineering Analyst and application support by providing consistent support for various applications and production environment.

PROJECT DETAILS

Project #1 : DSOC (Data Strategy and Governance)

Client : Takeda Pharmaceutical Company Limited

Role : Data Engineer

Duration : May 2023 – Till Date

Technologies : Datameer, AWS, Databricks, SQL, Power BI, Jira, Python, Qtest

Digital Strategy is a USBU-wide, cross-functional initiative to evolve how Takeda engages and serves its customers across marketing, sales, patient services and medical affairs. Objective is to use Veeva Suggestions to centralize data and information for field team so that time can be better spent on pre-call planning, leading to more effective HCP discussions

Job Responsibilities:

Gathering requirements and analyzing data model of the client (HCP information). Designing and developing the pipe line using Python programming for the client specific requirement.

supporting the issues encountered in production delivered products or use cases in applications within SLA.

Handling the performance improvements and automation to make the application robust.

Worked on building the metrics using power BI for PDT, Takhzyro use cases in DSOC.

END to END development & support accountability of application.

Project #2 : SPS Data Compatibility

Company : Legato Health Technologies

Duration : Feb 2021 – March 2023

Role : Senior Software Engineer

Technologies : MY SQL,ORACLE DB, Toad, HIVE, Informatica PowerCenter 9.6,Control+M, Power BI

Job Responsibilities:

Worked as a Developer in this project on Source to Target analysis of data. Prepared query counts for specific provider data entities provided by the business. Validated the counts in different layers of data and performed analysis on variance entities for different source systems.

Worked on HLBR reports using stored procedures and generated the reports to business.

Worked on automation of S2T queries for all layers to capture the counts just by running the procedure. Worked on Control M to schedule the jobs and manual triggering process.

Built appropriate and useful reporting deliverables. Also mentored junior resources to understand the requirements and guided in successful deployments of tasks.

Project #3 : PRE CHECK MY SCRIPY (PCMS)

Duration : March 2018 – November 2020

Client : OPTUMRX

Technologies : Abinitio GDE, Ab Initio DXF Frame work, Unix, Cognos for Reporting, MY SQL, Netezza, Teradata,Azyre Data Factory, Snowflake

This project, PreCheck MyScript is an application that lets doctors run a pharmacy trial claim before prescribing for our Members. Doctors can see how much Patients would have to pay at their preferred

pharmacies and offer lower-cost alternatives. Satisfaction with the Prior Authorization experience will improve.

Job Responsibilities:

●Worked as a BA in PCMS project, gathered all the business requirements and provided the logic to build the report for ETL and reporting team. Built and worked on sql queries foe the necessary business logic.

●Involved in Agile process for this project. Worked as a SA and QA Engineer and delivered defect free codes to production for each sprint iteration.

●Worked on enhancements related to the requirement, provided support to the delivered jobs in production. Handled the sprint reviews on the business requirements.

●Identified the source and target tables and created the Data (Source-Target) Mapping documents.

●Involved in writing transformation rules using express>it and load the data into the target tables by running the project’s specific abinitio framework.

●Test Case and Test plan documents in order to drive the User Acceptance Testing (UAT) and Post Implementation (PI) testing on the Integrated Data Warehouse.

●Performed BA check outs to ensure data quality, reviewing test results and provide sign off.

●Stream-lined end-to-end process to support large-scale data intake and integration across multiple sources and systems

●Refreshed the data by using fastexport and fastload utilities.

●Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.

●Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into IDW.

Project #4 : ORCHARD

Client : OPTUMRx.

Duration : Nov 2016 - Apr 2018

Technologies : Informatica PowerCenter 9.1, 9.6, DB2, Netezza

ORCHARD: A process to migrate the Enterprise datamart, the central repository of OptumRx and the Eligibility process to Informatica 9.6.1 and in Netezza database.

Job Responsibilities:

●Analyzed the source and target data systems to be able to map data from one to the other developing the Extract, Transform, and Load (ETL) layer using Informatica PowerCenter 9.6.1. Worked with Netezza database in creating the sources and targets and migrating the data.

●Developed ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on business requirements.

●Facilitated in troubleshooting issues post release deployment including support for Data Warehouse production projects along with solution proposals to solve complex production issues.

●Created Batch scripts to automate file transfers from Data Warehouse to customer file landing gateway\zone.

●Maintained several data marts which are part of the Enterprise Data Warehouse.

●Providing support to the ORCHARD related production jobs and working on any production related issues or user requests.

Project #5 : Informatica 9.1 to 9.6 Upgrade

Duration : July 2016 – March 2017

This project is a migration work which includes the code migration from Informatica 9.1 version to 9.6 version.

Job Responsibilities:

●Designed and developed ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on business requirements using Informatica 9.6 environment.

●Facilitated in troubleshooting issues post release deployment including support for Data Warehouse production projects along with solution proposals to solve complex production issues. Worked on all the compatibility issues while performing the upgrade

●Maintained several data marts which are part of the OptumRx Online Reporting.

●Providing support to all the migrated jobs in production and working on any production related issues or user requests

Project #6 : RDUR Project

Duration : April 2014 – February 2017(Support)

Technologies : Informatica PowerCenter 9.6, DB2, MY SQL

RDUR (Retrospective Drug Utilization Review):

The Retrospective Drug Utilization Review (RDUR) Program is a comprehensive provider- based medication safety program design to identify, educate, and address potential drug therapy related issues. The objective of these programs is: Detect clinically significant RDUR cases in the Medicaid, Medicare, and Commercial population. Promote appropriate use of medication through timely provider notification. Minimize the number of incidences of RDUR cases in the Medicaid, Medicare, and Commercial population.

Project #7 : REJECT CLAIMS REVIEW Project

Duration : July 2014 - February 2018

Technologies : Informatica PowerCenter 9.1, SQL

REJECT CLAIMS REVIEW (RCR):

Rejected Claims Review (RCR) is a process to audit claim rejects to ensure that the rejections are valid. It is independent process which systematically audits and processes claims rejects where appropriate and quickly identifies and routes rejects requiring human intervention to appropriate team for resolution.

Job Responsibilities:

Analyzed the Source and Target databases to understand the business logic.

Co-ordinated tasks with onsite and offsite team members and translated internal and external client requests into reportable data structures.

Analyzed the RxClaims source and target data systems to be able to map data from one to the other developing the Extract, Transform, and Load (ETL) layer using Informatica 9.1.

Maintained several data marts which are part of the Enterprise Data Warehouse.

Connection related issues were solved which includes server to database connectivity, database connectivity to import source and targets in Informatica designer and get access to source data.

Project #8 : Enterprise Data Mart (EDM)

Client : OptumRx.

Duration : April 2013 – December 2017

Technologies : Informatica PowerCenter 9.1,9.6, DB2, Netezza

Enterprise Data Mart (EDM): Enterprise Data Mart is the central repository for storing claims data, which deals with paid, reversed and rejected claims to add the metrics to online reporting and also contains information about health plan, drugs, pharmacy, prescriber and member. Budgeting and forecasting decisions are based on the reports produced using this data warehouse.

Job Responsibilities:

Involved in user requirement design study and analysis of the system. Interacting with the users on a daily basis in understanding the business requirements and came up with different innovative solutions and gathering new requirements if any.

Involved in Database analysis in order to fetch only required set of data from database.

Designed and developed ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on business requirements.

Developed mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Normalize, Filter, Rank and Router, Stored Procedure, XML.

Involved & prepared Unit Test Plan (UTP) and System Test Plan (STP) documents.

Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.

Achievements:

Got Spot Awards for quick resolution to Production Environment issues.

Awarded with BRAVO Aquamarine & Amethyst recognition at OPTUM for Outstanding Performance in OLR Report Automation, Developing and supporting New Data Marts and Performance tuning of long running jobs in ETL.

Submitted ‘6’ Bright Ideas in performance tuning of ETL jobs through Informatica.

Awarded with BRAVO Aquamarine, Sapphire and Jupiter for the EMR integration and ETL development in AB initio for PCMS project.

Received accolades and appreciations from various Project Teams for excellent quality of work and consistently demonstrating the ability to achieve tight deadlines

Got Impact award recognition at Legato Health Technologies for successful delivery of one of the source system (CPMF/FACETS/CPF) into production for source to Target.

Professional Certification

AHM-250 (Academy of Healthcare Management certificate) in Healthcare domain in 2017.

Certified AZ-900 ( Microsoft Azure Fundamentals ) in 2020.

EDUCATION:

B.Tech in Electrical and Electronics Engineering from LakiReddy BaliReddy College of Engineering (Affiliated under JNTU Kakinada)in 2008 – 2012 secured 80.27% marks

TECHNICAL SKILLS:

Operating System

Windows XP, Windows 7,UNIX

Languages

SQL

Tools

Informatica PowerCenter 9.1 & 9.6.1,MS Office Suite 2013,HP Service Manager, Advanced Query Tool, IBM i Series Navigator 12.0,Aginity Workbench for Pure Data System for Analytics 09, Ab Initio(1 year),Ab Initio(DXF Framework),Cognos reporting, DataBricks

Database

DB2,Netezza, SQL Server, Toad

Remote Access

FTP, Control M, Datameer

AFFIRMATION:

I hereby declare that the information furnished above is true to the best of my knowledge and belief.

Place: Cary, NC (Deepthi Priyanka Watada)

Contact this candidate