Manager Data

Nikitha Reddy

SUMMARY

. An IT professional with around 8 years of experience in mission

critical software applications with a strong background in Data

Warehousing and Oracle technology areas.

. Well versed with Data warehousing Architecture on the Design,

Development, Extraction, Transformation and Loading of data using

Informatica Power Center as an ETL tool.

. Experience in all the phases of Data warehouse life cycle involving

Requirement Analysis, Design, Coding, Testing, and Deployment.

. Strong experience with SDLC methodologies like Waterfall and

Agile/Scrum.

. Strong knowledge of Entity-Relationship, Facts and Dimensions tables,

slowly changing dimensions and Dimensional Modeling (Star Schema and

Snow Flake Schema).

. Experience in building the Data warehouse using Ralph-Kimball

methodology.

. Extensive experience in developing mappings for Extraction,

Transformation, Loading (ETL) data from various sources into Data

Warehouse/Data Marts.

. Experience in creating Reusable Transformations (Joiner, Lookup,

Sorter, Aggregator, Expression, Update Strategy, Router, Filter,

Sequence Generator, Normalizer and Rank) and Mappings using

Informatica Designer and processing tasks using Workflow Manager to

move data from multiple sources into targets.

. Extensively worked on developing and debugging Informatica mappings,

mapplets, sessions and workflows.

. Worked on Performance Tuning, identifying and resolving performance

bottlenecks in various levels like sources, targets, mappings and

sessions.

. Efficient in tuning complex SQL statements.

. Extensively used SQL and PL/SQL in creation of Triggers, Functions,

Indexes, Views, Cursors and Stored Procedures.

. Strong experience with UNIX and Shell Scripting.

. Proficient in writing documents, preparing presentations and

presenting them.

. Well organized, goal oriented, with excellent trouble shooting and

problem solving skills.

. Strong ability to quickly adapt to new applications, platforms and

languages.

. Excellent team player with good organizational, communication,

interpersonal & analytical skills.

SKILLS

ETL InformaticaPowerCenter9.x/8.x/7.x

Designing and Scheduling tools ERStudio 9.x, Erwin, Visio, Autosys,

Control M

Databases Oracle 11g/10g/9i, MS Access, SQL Server,

Teradata, DB2

Languages C, C++, HTML, SQL, PL/SQL, Visual Basic,

Unix Shell Scripting

OS Windows 98/2000/NT/XP, UNIX

Packages SQL* PLUS, SQL Loader, Enterprise Manager

Console, Toad 7.5, IBM Data Studio

EDUCATION:

Bachelors in Computer Science Engineering, Jawaharlal Nehru Technological

University, India

EXPERIENCE:

Federal Dept of Health and Human Services (HHS), Silver Spring, MD

Mar'14 - Till date

Sr.Informatica Developer

Description: HHS will be moving to new HR systems that will replace Capital

HR, myPay, and the Integrated Time and Attendance System (ITAS) with

interconnected systems. This effort, mandated by HHS, is referred to as the

Hire to Retire (H2R) Modernization Program.

Responsibilities:

. Prepared User Requirements Documentation for mapping and additional

Functionality.

. Analyzed the functional specifications provided by the data architect and

created Technical specification documents and Detail design documents for

all the mappings.

. Created Process flow for mappings and sessions.

. Expertise in configuration, performance tuning, installation of

Informatica, & in integration of various data sources like Oracle, MS SQL

Server, XML, Flat files into the staging area and Design ETL processes

that span multiple projects.

. Responsible for Data Extraction and Transformation from disparate sources

like Oracle, DB2, SQL Server, flat files, XML files and Loading to Oracle

using Informatica Power Center.

. Created Informatica maps using various transformations like Web services

consumer, XML, HTTP transformation, Source Qualifier, Expression, Look

up, Stored Procedure, Aggregate, Update Strategy, Joiner, Union, Filter

and Router.

. Extracted XML data from messaging system (MQ Series) and other sources

and loaded data to targets using XML Parser and XML Generator

Transformations.

. Implemented complex business rules by creating reusable transformations,

and robust Mappings/Mapplets.

. Used Dynamic Lookup transformation for implementing Slowly Changing

Dimensions.

. Created Workflows using Workflow manager for different tasks like sending

email notifications, timer that triggers when an event occurs and

sessions to run a mapping.

. Created Pipeline partitioning to improve Session performance and

synchronizing the target load rows throughout the session run.

. Developed Pre SQL and Post SQL scripts for Informatica jobs, PL/SQL

stored procedures and functions.

. Used the Debugger to validate the transformations by creating break-

points and analyzing the debug monitor.

. Involved in Performance Tuning and optimization of Informatica mappings

and session.

. Used Informatica scheduler to schedule the tasks.

. Scripts were run through UNIX shell programs in Batch scheduling.

. Created Test data and Unit test cases to ensure successful data loading

process.

Environment: Informatica Power Center 9.5, Oracle 11g, PL/SQL, Windows 7,

SQL Server 2008, UNIX, Informatica Job Scheduler.

State Farm Insurance Companies, Bloomington, IL

July'12 - Jan'14

Sr.Informatica Developer

Description: State Farm Insurance is a group of insurance and financial

services companies. State Farm is currently aiming for a complete online

platform for the customers. The project was Customer Driven Evolution, as a

part of this project, we are developing a Report A Claim application in

which customers can log in and file their claims online.

Responsibilities:

. Worked closely with the Business Analysts to understand the Data

requirements, definitions, and business rules to be implemented.

. Gathered business rules and requirements of different Lines of Business

for the ETL process from various Development Centers in the Enterprise.

. Involved in developing the logical and physical models using ER

Studio.

. Prepared the required application design documents based on

functionality required.

. Used Informatica as an ETL Data movement tool to create source/target

definitions, mappings and sessions to extract, transform and load data

into staging tables from various platforms.

. Developed mappings using flat files and relational databases as sources.

. Developed reusable transformations and mapplets, and used them in

mappings.

. Used SQL override queries in source analyzer to customize mappings.

. Used Informatica debugger to find troubleshooting information about

data and error conditions in the mappings.

. Responsible for creating mappings and transforming existing feeds into

the new data structures maintaining client standards utilizing

Normalizer, Router, Lookups (Connected, Unconnected), Expression,

Aggregator, Update strategy transformation.

. Responsible for designing and creating restartability and failover

mechanisms and implemented them using informatica mappings which can

support real-time synchronization of mapping to run continuously 24/7.

. Involved in design discussions when creating a separate exception

handling framework to deal with the real time and non real time exception

records which helps in storing/reprocessing/audit purposes.

. Actively involved in various proof of concept discussions by exploring

various solutions to meet and satisfy business requirements and needs.

. Handled UNIX operating system tasks to run informatica jobs using Control

M and also generating Pre and Post-Session UNIX Shell Scripts.

. Worked on Unix Shell scripting and FTP process.

Environment: Informatica Power Center 9.1, Oracle, Flat files, Control M,

ER Studio 9.x,Visio, UNIX Shell Scripting.

Lincoln Financial Group, Omaha, NE

Aug'11 - June'12

Informatica Developer

Description: Lincoln Financial Group is an insurance service company, which

provides group insurances. It focuses mainly on health and dental services.

The project was to build an Operational Data store and also Data warehouse

to build a reporting environment for all the future acquisitions.

Responsibilities:

. Involved in full life cycle development including Design, ETL

strategy, troubleshooting Reporting, and Identifying facts and

dimensions.

. Prepared the required application design documents based on

functionality required.

. Designed the ETL processes using Informatica to load data from Oracle,

Flat Files (Fixed Width), and Excel files to staging database and from

staging to the target Oracle Data Warehouse database.

. Implemented the best practices for the creation of mappings, sessions

and workflows and performance optimization.

. Created mappings using transformations like Source Qualifier, Joiner,

Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and

Sequence Generator.

. Designed and developed the logic for handling slowly changing

dimension tables load by flagging the record using update strategy for

populating the desired.

. Involved in cleansing and extraction of data and defined quality

process for the warehouse.

. Involved in performance tuning and optimization of Informatica

mappings and sessions using features like partitions and data/index

cache to manage very large volume of data.

. Documented ETL test plans, test cases, test scripts, test procedures,

assumptions, and validations based on design specifications for unit

testing, system testing, expected results, preparing test data and

loading for testing, error handling and analysis.

. Involved in migration of mappings and sessions from development

repository to production repository

. Involved in Unit testing, User Acceptance Testing to check whether the

data is loading into target, which was extracted from different source

systems according to the user requirements.

. Involved in production support working with various mitigation tickets

created while the users working to retrieve the database.

. Created Stored Procedures to transform the Data and worked extensively

in PL/SQL for various needs of the transformations while loading the

data.

Environment: Informatica Power Center 9.1, Oracle 11g, TOAD 9x, PL/SQL

Developer 7.1.0, LINUX, UNIX Shell Scripting, SQL*Loader

Roche Pharmaceuticals, Nutley, NJ

Oct'09 - June'11 Informatica Developer

Description: Roche is a leading healthcare company with a uniquely broad

spectrum of innovative solutions. Their products and services address

prevention, diagnosis and treatment of diseases, thus enhancing wellbeing

and quality of life. The Data Warehouse developed will enable marketing

managers to better leverage information collected within current OLTP

systems to help in their decision making process. First Phase involved

gathering the reporting needs of marketing managers to facilitate the

decision support, identifying key analytical subject areas within the scope

of the project. In the second phase, developed ETL system and generated

facts, dimensions, cubes. The environment included multiple database

systems like Oracle, DB2 and SQL Server 2000.

Responsibilities:

. Instrumental in Analysis, Requirements Gathering and documentation of

Functional & Technical specifications.

. Involved in Dimensional modeling to Design and develop STAR Schemas

using ERWIN to identify Fact and Dimension Tables.

. Worked extensively on Informatica client tools such as Designer,

Workflow manager, Workflow Monitor.

. Extensively used ETL to load data from sources such as Flat Files,

Oracle to Oracle, Teradata Target Data base.

. Based on the business requirements Reusable transformations are

created in transformation developer and Mapplets in the Mapplet

designer.

. Developed complex mappings to transform the data using Rank, Sorter,

Stored Procedure, Joiner, Aggregator, Filter, Connected lookup,

unconnected lookup and Router transformations.

. Implemented slowly changing dimensions type 2 to keep track of

historical data.

. Extensively used dynamic lookup cache for slowly changing dimensions.

. Used workflow manager for creating, validating, testing and running

the Sequential and Concurrent batches and sessions and scheduling them

to run at specified time with required frequency.

. Implemented performance tuning techniques by identifying and resolving

the bottlenecks in source, target, transformations, mappings and

sessions.

. Used Workflow Monitor to monitor the jobs, review error logs that were

generated for each session, and resolved them.

. Extensively performed unit testing and system testing.

. Performed Database end tuning using EXPLAIN PLAN and analyze table

queries.

Environment: Informatica PowerCenter 8.6, Oracle 10g, DB2, Autosys, SQL

Server 2008, PL/SQL, Teradata, Toad, ERwin 3.5, Unix.

Pioneer HealthCare Systems, Bangalore, India

Jun'07 - May'09

ETL Developer

Description: Pioneer healthcare Systems is into manufacturing and sales of

ENT products, general surgery products, endo urology products. Pioneer

developed an in-house inventory and sales Management system.

Responsibilities:

. Requirement Analysis and Design

. Coding (involves coding of shell scripts, Informatica mapping, sessions

and workflows)

. Unit Testing

. Responsible for developing, support and maintenance for the ETL (Extract,

Transform and Load) processes using Informatica Power Center.

. Developed Shell Scripts, PL/SQL stored procedures, table and Index

creation scripts.

. Created complex transformations using Source Qualifier, Joiner,

Aggregator, Lookup, Router, Expression, Update Strategy and Sequence

Generator.

. Used Informatica Power Center Server manager to create sessions, batches

to run with the logic embedded in the mappings.

. Involved in developing the SQL scripts for Extract and load the data

warehouse.

. Involved in Unit and Integration testing of Informatica Sessions and

Target Data.

Environment: Informatica PowerCenter 7.1, MS Access, SQL Server 2005,

Oracle 8i/7i, PL/SQL, SQL *Loader, Windows 2000, UNIX.

Contact this candidate