Bhumika Patel Informatica Senior Developer

More than 12+ years of total experience and Over 5+ years of IT experience with expertise in analysis, design,
development and implementation of Data warehouses and Decision Support Systems (DSS) using ETL tools
Informatica 10.2/9.x with RDBMS like Oracle, MS SQL server, Teradata and MySQL databases on Windows and UNIX
platforms. Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging,
production deployment and production warranty support. Extensive experience of providing IT services in
engineering, construction and HealthCare domain.

 Good understanding of Data Warehousing Concepts like Dimensions Type I and II, Facts, Surrogate keys,
ODS, staging area.
 Good understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling,
Snowflake Schema Modeling.
 Good experience of writing SQL Queries for Data analysis, Data mapping specification, Data Profiling, Data
Migration and creating Data Dictionaries.
 Expert in writing complex SQL queries and optimizing the queries in Oracle, SQL Server and Teradata.
 Experience in developing very complex mappings, reusable transformations, sessions and workflows using
Informatica ETL tool to extract data from various sources and load into targets.
 Experience in tuning and scaling the procedures for better performance by running explain plan.
 Experience in Performance tuning of ETL process using pushdown optimization and other techniques.
 Used mapplets, user defined functions, reusable transformations, look-ups in Informatica mapping.
 Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners
with day-to-day ETL progress monitoring.
 Skilled in creating Source to target mapping, ETL Specification Documents and capturing requirement.
 Experience with Informatica tools using real-time CDC (change data capture) and MD5.
 Good communication and presentation skills, works well as an integral part of a team, as well as
independently, intellectually flexible and adaptive to change.

EDUCATION:
 Master of Engineering from Lamar University, TX, USA 2008
 Bachelors in Civil Engineering from Gujarat Univ. 2001

TECHNICAL SKILLS:

ETL tools Informatica PowerCenter 10.2/9.6/9.2

RDBMS Database Oracle 12c/11g, MS SQL Server 2018, MySQL, Teradata 16
Tools Microsoft Visio, Erwin 9.5/8.1, TOAD, Oracle SQL developer, WINSCP, MS Office,
Control-M, Rally, JIRA
Mythologies SDLC, Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Client: Bechtel Corporation, Houston, TX

Duration: Jul 2019 to Till Date
Role: Informatica Developer
Project Name: Bechtel Data Mart
Bechtel is a trusted engineering, construction and project management partner to industry and government. Bechtel
serves the Infrastructure; Nuclear, Security & Environmental; Oil, Gas & Chemicals; and Mining & Metals markets.
their services span from initial planning and investment, through start-up and operations.

NTT DATA, Inc.

nttdata.com/americas
This project aims to create a data mart for ETA (Electronic Test Automation) tools to access all their needed data
from a single environment and to enhance efficiency, analysis, and the tools' ability to communicate in sync with one
another. This enables ETA (Electronic Test Automation) to achieve their goals:
Improving customer return cycle time through consistent and quicker analysis
Automatically optimizing test limits
Implementing strategic Final Test outlier screening to meet automotive customer expectations.
Responsibilities:
 Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user
training and support for production environment.
 Actively involved in interacting with business users to record user requirements and Business Analysis.
 Outlined the complete process flow and documented the data conversion, integration and load mechanisms
to verify specifications for this project.
 Parsing high-level design spec to simple ETL coding and mapping standards.
 Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data
from flat files and SQL server database.
 Maintained warehouse metadata, naming standards and warehouse standards for future application
development.
 Created the design and technical specifications for the ETL process of the project.
 Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract,
transform and load data into staging tables from various sources.
 Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing
Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored
procedure transformation.
 Worked with various complex mapping, designed slowly changing dimension Type1 and Type2.
 Performance tuning of the process at the mapping level, session level, source level, and the target level.
 Created Workflows containing command, email, session, decision and a wide variety of tasks.
 Tuning the mappings based on criteria, creating partitions in case of performance issues.
 Performed data validation after the successful End to End tests and appropriate error handling in ETL
processes.
 Resolving the tickets based on the priority levels raised by QA team.
 Developed Parameter files for passing values to the mappings as per requirement.
 Scheduled batch and sessions within Informatica using Informatica scheduler and also customized pre
written shell scripts for job scheduling.
Environment: Informatica PowerCenter 10.2, Tableau 2020.3, Unix, TOAD, Microsoft SQL Server 2018, Teradata
16, Control M, Shell Scripting, SharePoint, Confluence

Client: Amegy Bank, Houston, TX

Duration: Jun 2017 to Jul 2019
Role: Sr. Informatica Developer
Project Name: IDW
Description: Amegy Bank specialize in banking privately owned business of all sizes and public companies in all
industries with additional expertise in real estate, energy and correspondent banking. Amegy Bank operates in
nearly 500 local financial centers across 11 Western states, it is known as Zions Bancorporation in S&P 500. The
objective of this project is to enrich data from new sources into existing IDW i.e., integrated data warehouse to
enable improved decision-making, strategic plans, support and solutions that favorably impact costs, quality of care,
outcomes, and customer satisfaction through an information-driven environment that leverages their integrated
data assets for competitive advantage.
Responsibilities:

NTT DATA, Inc.

nttdata.com/americas
  Worked with the business team to gather requirements for projects and created strategies to handle the
requirements.
 Documented Data Mappings/ Transformations as per the business requirement.
 Worked on project documentation which included the Technical and ETL Specification documents.
 Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous
source systems into target database.
 Created mappings using Designer and extracted data from various sources, transformed data according to
the requirement.
 Involved in extracting the data from the Flat Files and Relational databases into staging area.
 Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
 Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star
schema.
 Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter
usage in Source qualifiers, and data flow management into multiple targets using Router.
 Created Sessions and extracted data from various sources, transformed data according to the requirement
and loading into data warehouse.
 Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router
and Aggregator to create robust mappings in the Informatica Power Center Designer.
 Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
 Developed several reusable transformations and mapplets that were used in other mappings.
 Prepared Technical Design documents and Test cases.
 Extensively worked on Unit testing for the Informatica code using SQL Queries.
 Implemented various Performance Tuning techniques.
 Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner,
Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator
transformations.
 Wrote SQL queries to view and validate the data loaded into the warehouse.
 Developed transformation logic as per the requirement, created mappings and loaded data into respective
targets.
 Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
 Used PMCMD command to run workflows from command line interface.
 Improved performance testing in Mapping and the session level.
Environment: Informatica PowerCenter 9.6, SQL Server 2016, MySQL, Shell Scripts, SQL, UNIX, Toad, SQL
Developer, tableau, Control M

Client: Humana Inc, Irving, TX

Duration: Jan 2016 to Jun 2017
Role: ETL Developer
Project Name: Consolidated Customer Warehouse
Description: Humana Inc. offers medical and supplemental benefit plans; it operates through Retail, Group and
Specialty, and Healthcare Services segments. The company provides commercial fully-insured medical and specialty
health insurance benefits comprising dental, vision, and other supplemental health benefits; financial protection
products; and administrative services to individuals and employer groups, as well as military services.
The project is aimed at developing Visuals dashboard and reports for their huge customer base that will be helpful
for long-term decision-making, strategic plans, support and solutions giving stakeholders ability to access, analyze
and help stakeholder to automate extract process for down-line application. This data mart sourced data from
multiple source system like QNXT, QCARE, LEON etc. into data mart.
Responsibilities:

NTT DATA, Inc.

nttdata.com/americas
  Experienced in using Informatica for data profiling and data cleansing, applying rules and develop mappings
to move data from source to target systems
 Designed and implemented ETL mappings and processes as per the company standards, using Informatica
PowerCenter.
 Extensively worked on complex mappings which involved slowly changing dimensions.
 Developed several complex mappings in Informatica a variety of transformations, Mapping
 Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router,
Aggregator, Lookup, Update strategy, Sequence generator and Joiners.
 Deployed reusable transformation objects such as Mapplets to avoid duplication of metadata, reducing the
development time.
 Worked on developing Change Data Capture (CDC) mechanism using Informatica
 Power Exchange for some of the interfaces based on the requirements and limitations of the Project.
 Implemented performance and query tuning on all the objects of Informatica using SQL Developer.
 Worked in the ETL Code Migration Process from DEV to QA and to PRODUCTION.
 Created the design and technical specifications for the ETL process of the project.
 Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing
 Environment: Informatica PowerCenter 8.6, Oracle 11g, SQL Server 2012, SQL, Erwin 8.1, UNIX, Control-M

Past experience in non IT area Nov 2008 to Oct 2015

AMEC Foster Wheeler: worked as Piping Engineer IV from Dec 2013 to Oct 2015
Worley Parsons Limited worked as Offshore Structural Engineer from Nov 2012 to Nov 2013
Bechtel Corporation worked as Pipe Stress Engineer/ Civil Engineer from Nov 2008 to July 2012

NTT DATA, Inc.

nttdata.com/americas