Data Manager

Nikitha

PROFESSIONAL SUMMARY

• An IT professional with more than 7 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 phases of Data warehouse life cycle involving Requirement Analysis,

Design, Coding, Testing, and Deployment.

• Strong experience with SDLC methodologies like Waterfall and Agile.

• 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.

• Expertise in configuration, performance tuning, installation of Informatica, & in integration

of various data sources like Oracle, DB2, flat files into the staging area and Design ETL

processes that span multiple projects.

• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various

levels like sources, targets, mappings and sessions.

• 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 Informatica PowerCenter 9.x/8.x/7.x, Informatica

Powermart

Designing Tools ERStudio 9.x, Erwin, Visio.

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

DB2

Languages C, C++, HTML, SQL, PL/SQL, Unix Shell Scripting

OS Windows 98/2000/NT/XP, UNIX

Database Tools SQL* PLUS, SQL Loader, Toad, IBM Data Studio

Scheduling Tools Autosys, Control M

Reporting Tools OBIEE, MicroStrategy

EDUCATION:

Bachelors in Computer Science Engineering, Jawaharlal Nehru Technological University, India

EXPERIENCE:

Federal Dept of Health and Human Services (HHS), Silver Spring, MD June’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 detail design

documents for all the mappings.

• Created Process flow for mappings and sessions.

• Responsible for Data Extraction and Transformation from disparate sources like Oracle, flat

files and Loading to Oracle using Informatica Power Center.

• Created Informatica maps using various transformations like Source Qualifier, Expression,

Look up, Stored Procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router.

• 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, 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.

• 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.1, Oracle 11g, SQL*Loader, PL/SQL, Windows 7, UNIX,

Putty, Control-M.

State Farm Insurance Companies, Bloomington, IL July’12 – Mar’14

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 conceptual, 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.

• Used Workflow Monitor to monitor the jobs, review error logs that were generated for each session,

and resolved them.

• 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 restorability 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.

Environment: Informatica Power Center 9.1, MS Access, Oracle 11g, DB2, Salesforce, Control M, ER

Studio 9.x, Visio, UNIX Scripting, Putty.

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.

• Implemented slowly changing dimensions methodology to keep track of historical data.

• 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, LINUX, UNIX Scripting,

Putty, 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, Teradata.

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.

• 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.

Environment: Informatica PowerCenter 8.6, Oracle 10g, Autosys, SQL, PL/SQL, Teradata, DB2, Toad,

ERwin 3.5, Unix Scripting, Putty.

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, Oracle 9i/8i, PL/SQL, SQL*Loader,

Windows 2000, UNIX Scripting.

Contact this candidate