ETL Developer

Name: Bharat Kumar Thatipally

Phone: +1-380-***-****

Email: ****************@*****.***

LinkedIn: https://www.linkedin.com/in/bharat-thatipally/

Summary:

13+ years of IT experience in Analysis, Design, Development, testing, and implementation of Business application systems for the Healthcare, compliance industry.

Strong experience in Analysis, design, development, testing, and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, and Client/Server applications.

String Data Warehousing ETL experience of using Informatica 10.1/9.1 PowerCenter tools Designer, Repository Manager, Workflow Manager/ Monitor.

Expertise in Data warehouse/Datamart, OLTP, and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design Development, System testing, Implementation, and production support.

Extensive testing ETL experience using Informatica 10.1/9.1( Power Center, Designer. Workflow Manager, Workflow Monitor and server manager)

Expertise in working with relational databases such as Oracle 11g/10g, SQL server 2008/2005, and Teradata.

Strong experience in Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.

Extensive experience in developing Stored Procedures, Functions, Views and Triggers, and Complex SQL queries using Oracle PL/SQL, and T-SQL.

Experience in resolving ongoing maintenance issues and bug fixes: monitoring Informatica sessions as well as performance tuning of mappings and sessions.

Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to developing the code, Unit Testing, and Documenting.

Worked extensively in Slowly Changing dimensions.

Hands-on experience across all stages of SDLC including business requirement analysis, data mapping, build, unit testing, systems integration, and user acceptance testing.

Worked on POC’s on Azure for new clients. Which involved the creation of pipelines, connections, and procuring new data factory recourses.

Domain Experience:

●Health Care and Compliance.

Education Qualification:

●Bachelor of Technology

Technical Skills:

Programming

SQL, PL/SQL, Python, Unix Shell Scripting

Source control

GIT, Azure Repos, Code Commit

Tools

Azure, Informatica, SQL developer, Teradata, Toad.

Scripting

Unix Shell Scripting

Orchestration Tools

Control M

Database

Oracle, My SQL.

Operating Systems

Ubuntu, Windows

Professional Experience:

Deloitte Consulting: March, 2013- May, 2024.

Anthem HEDIS and PC2 (Health Care and Life Sciences) – Senior Informatica Developer Sep 2016- May 2024.

Client summary:

The Client is a trusted healthcare provider in the USA. It provides the performance results of the health plans and identifies the opportunities for improvement. Currently, the application is set with backend ETL jobs that are scheduled to run monthly and bi-monthly basis and will mostly load the data from Teradata, flat files acting as look-in most cases and land the data into Teradata Data warehouse through different layers till the final Oracle tables are loaded.

Key Responsibilities- Development:

●Involved in gathering business requirements, designing ETL architecture, coding, unit testing, review, and support till it goes live.

●Optimized the run time of the ETL by more than 30% pushdown transformations and SQL optimizations which helped businesses with their early data submissions.

●Implemented HEDIS 2 application with very low impact on several components by introducing a Swap process between parameters, based on different date ranges.

●Decision maker for all the scheduling-related changes using CTM.

●Lead the successful delivery of multiple complex modules.

●Involved in the ETL design and its documentation.

●Followed Star Schema to design dimensions and fact tables.

●Extensive experience with PL/SQL in designing, and developing functions, procedures, triggers, and packages.

●Developed reusable Mapplets and Transformations.

●Created high-level design documents, technical specifications, coding, and unit testing and resolved the defects.

Key Responsibilities: Production Support:

●Involved in gathering business requirements, designing ETL architecture, coding, unit testing, review, and support in the production cycle.

●Optimized the run time of the ETL by more than 30% which helped businesses with their early data submissions.

●Automated the replication of data to Teradata lower environments which is used in every release cycle.

●Automated Index creation on Oracle tables which should be dropped and created for any DDL changes using PL/SQL.

●Responsible for the development, implementation, and support of the databases.

●Appreciated by clients and leadership for quick turnaround on the production requests.

●Decision maker for all the scheduling-related changes using CTM.

●Led the successful delivery of over 13 complex modules.

●Offshore PoC for all the production support-related issues.

●Resolved over 100 production issues, consistently meeting SLA requirements.

Technical Environment: Informatica PowerCenter 10.1, Oracle SQL Developer 20.1, Teradata, Unix.

Providence Health Care.- Informatica Developer Mar 2016- Aug 2018

Client summary:

The project identified a need to redesign and reposition their costing systems to enable data-driven decision-making on previously unexamined data. The client aimed to transform and enhance costing methodologies for greater precision, leveraging patient data to determine costs per unit of activity and gain a clearer understanding of the total cost of care. This journey involved standardizing acute costing methodologies and expanding costing capabilities across the continuum of care, including ambulatory and post-acute services such as home health, long-term care, and hospice.

Key Responsibilities:

●Analysis and understanding of existing business models and customer requirements.

●Responsible for developing, supporting, and maintaining the ETL (Extract, Transform, and Load) process using Informatica Power Center 8.5.

●Experience in integration of heterogeneous data sources like Oracle, SQL server, and flat files into staging area.

●Used SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.

●Designed and developed mappings using source qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, update strategy, joiner, and Rank transformations.

●Implemented performance tuning of sources, targets, mappings, and sessions by identifying bottlenecks and using the debugger to debug the complex mappings and fix them.

●Implemented complex business rules in the Informatica power center by creating reusable transformations, and robust Mapplets.

●Used session parameters, Mapping variables/parameters, and created parameter files for flexible runs of workflow.

●Developed the ETL for the client costing process.

●Based on ETL Specification Developed Informatica mappings, sessions, and workflows.

●Involved in Requirement analysis, Effort estimation, Impact analysis, and Code designing.

●Coordinating with the onsite team to prepare unit test plans and unit test cases, raising issues and challenges, tracking defects, and reviewing the status of deliverables.

●Developing code based on Agile methodology and delivering the project within the given timeline.

Technical Environment: Informatica PowerCenter 10.1, Oracle Database 11g

Stericycle: Junior Informatica Developer Mar 2013-Feb 2016

Client summary:

Stericycle is a prominent player in the waste management sector, specializing in compliance services for regulated substances such as medical waste, sharps, pharmaceuticals, hazardous waste, and the disposal of expired goods. The project aims to assist Stericycle in consolidating its systems by extracting relevant data elements from digital documents, standardizing them into templates, and loading them into the database.

Key Responsibilities:

●Successfully created a database system containing all the component details and accurate pricing for the manual contracts from our clients.

●The client has his historical data present in the form of manual documents, which were digitalized and fed into the system.

●Gathered business requirements from the leads and functional team.

● Designed and implemented appropriate ETL mappings to extract data from files into the target database.

●Worked on other heterogenous data sources to integrate with the new data which involved transformation logics to be designed at mapping.

●Able to overcome the challenges during digitalization and creating pricing as pricing for the same wastage component varied from state to state where a key quality measure was required and was taken care.

●Successfully coordinated with a team of 15 across multiple locations to deliver 2000+ contracts.

●For every contract digitalized we ensured it is fed into the system so it can be validated by the client where we also provided SQL queries for easy validation.

●Once all the contracts are loaded we ensure the quality is delivered as expected by developing procedures/functions where the state and contract name/number are fed which will validate the differences and provide validation results.

●A very accurate level of analysis was performed with the latest data to standardize the pricing in each offering for waste processing. This will help clients define their taxonomy and re-evaluate their pricing, which could help generate revenue.

Technical Environment: Informatica, SSMS.

AstraZeneca and Novartis: Database support engineer. Sep 2011- Mar 2013

Client summary:

The clients use the Learning Management System (LMS) application Saba for training their employees.

Key Responsibilities:

●Managed production support processes, assisting clients with front-end application requests as well as back-end support.

●Successful in supporting back-end learning requests handled through SQL/PL SQL.

●Automated various processes such as notification generation, manual course completion marking, bulk member enrollment, etc., using backend Oracle stored procedures.

●Played a key role in handling database requests to update user data through the backend, as well as in developing reports for tracking user learning activities.

●Capable of communicating with clients to discuss product issues that have been resolved through back-end solutions.

●Ensured that documentation and support tickets were updated diligently to facilitate a smooth transition for the next shift's employees.

Technical Environment: Oracle.

Contact this candidate