Ankita Chatterjee

Ph: 469-***-****

Email:ab8u98@r.postjobfree.com

Professional Summary:

. About 6 years of IT experience in DWBI technology under Different

Sector

. Worked as Onsite coordinator at different client locations

. Managed different teams of 10 Members

. Experience in Informatica ETL Tool for almost 6 years

. Experience in SAP Business Objects Data Services Tool (SAP BODS) for

around 3 years

. Clear knowledge on OLTP and OLAP Systems, developing Database schema

- Star and Snow flake schema (Dimensions and Facts), ER Modeling and

expertise in integrating various source's- Oracle, SQL Server, XML

files and Flat files

. Experience in working with Tools- TOAD, SQL Developer, SQL Plus,

Filezila and Core FTP

. Used various sources like SAP ERP, Oracle, SQL Server, DB2, Flat

files, and XML in creating reports

. Implemented PRE and POST Session shell scripting to run workflows

using pmcmd command

. Extraction of data from Sources to Targets- Staging Area, Data Marts

or Data Warehouses

. Extensive Testing experience like testing under Functional,

Regression, Integration, Stress and Load testing areas

. Implemented Performance Tuning Techniques on Mappings, Session and

Targets.

. Expertise in administration tasks includes Importing/Exporting

mappings, copying folders over the DEV/QA/PRD environments.

. Good depth of Knowledge of data warehouse architecture and data

modeling

. Experienced working while GO-LIVE of a project

. Experienced in writing test plans, test cases and test scripts

. Involved in preparation of Technical Specification and Scope Documents

. Worked with colleagues to resolve issues or concerns

. Maintained NO SLA BREACH or DELIVERY BREACH

. Excellent team player and self-starter with good ability to work

independently and possess good analytical, problem solving and logical

skills and manage business expectations with a delivery-focused

approach

. Ability to quickly understand and master new software technologies

Technical Skills:

ETL Tools : Informatica (8.5, 8.1, 7.1.3 and 6.2), SAP BODS (4.0,

3.2 versions)

Databases : SQL Server(2008,2005,2000 versions),

Oracle(11g,10g,9i versions),

IBM DB2 V9, SAP ERP and R/3 systems

Languages : SQL, T-SQL, PL/SQL, C, UNIX Shell Scripting

Operating Systems : Windows (Vista/XP/2000), UNIX

DB Tools : TOAD, SQL *Plus, PL/SQL Developer

Reporting tools : SAP Business Objects XI 4.0, Qlikview

(Trainings)

Other Tools/Applications: NesTool, Quality center, Service Center, HP

Service manager, Outlook,

Lotus notes

Professional Experience:

CPSG Partners

Sr.Informatica Developer

Dallas, TX

Period: June 2013 - Current

Data Quality Reports: Reports are extracted by calculating the Key

Performance Indicators (KPIs) using Informatica. These reports are further

useful for tracking the overall budget on the CAPEX done by the employer.

Responsibilities:

. Involved in designing the documents based on the requirement

specifications

. Developed SQL queries to ensure loading of data, performed unit

testing at various levels of ETL, developed and implemented the

coding of informatica mapping

. Debug the sessions by utilizing logs of sessions and monitored

workflows and collected the performance data

. Maintaining jobs in the Informatica scheduler to schedule the jobs

. Preparation of Technical Specification and Scope Document

. Technical Unit Testing

. Regression volume testing

. Created ad-hoc reports, drill down, and drill through reports

Environment: Informatica Power Center 8.5, SQL Server 2008

Nestle USA, Globe

Sr. Informatica Developer

SAP BODS Developer

Vevey,Switzerland

Period: June 2010 - December 2012

GLOBE stands for "Global Business Excellence" and is the largest program

Nestl has ever undertaken.

GLOBE was created in July 2000 in order to improve the performance and

operational efficiency of Nestl 's businesses worldwide. GLOBE will achieve

this ambition through the creation of common business process architecture,

and through standardization of internal and external master data, and

information systems and infrastructure.

Nestle is in the process of implementing SAP R/3 ERP system in more than 80

countries, across the globe.

Data from various disparate legacy systems needs to be extracted, cleansed,

transformed and loaded into these SAP databases. Another aspect of the job

is to design ETL process for the markets in various countries falling under

three zones AMS, AOA and EUR.

Responsibilities:

. Worked with the business analysts in requirement analysis to

implement the ETL process.

. Worked extensively on Informatica tools -Repository Manager,

Designer and Server Manager.

. Worked on all the Transformations like Lookup, Aggregator,

Expression, Router, Filter, Update Strategy, Stored procedure,

Sequence Generator and involved in both designing and developing

the Data Mart.

. Developed PL/SQL Stored procedures according to business scenarios.

. Data from source systems was extracted and transformed according to

business requirements using Informatica PowerCenter and loaded into

Oracle Data Mart and

. Involved in unit and system testing, creating tasks, worklets,

workflows to load the data.

. Scheduled, Run and Monitored sessions using workflow manager and

workflow monitor.

. Defined Target Load order plan for loading data into Target Tables

and troubleshoot problems by checking Sessions and Error Logs.

. Involved in performance tuning issues at various levels such as

target, sessions, mappings and sources.

. Used pmcmd commands for stopping and starting workflows and tasks

and involved in postproduction support and enhancements.

. Created parameterized reports, Drill down and Drill through reports

using Excel files

. Designed and developed different Extraction-Transformation

components using SAP Business Objects Data Services and loaded into

different target DBs like SQL Server and Oracle

. Quality Review

. Preparation of Technical Specification and Scope Document

. Technical Unit Testing

. No SLA or DELIVERY BREACH

. Regression volume testing

. Support functional team while Functional unit testing

. Support the sustain team while Go-Live of the project

. Worked with tools like NesTool, Quality center, Service Center, HP

Service manager

Environment: Informatica Power Center (8.5/8.1/7.1.3), SAP BODS (4.0/3.2),

Oracle (11g/10g), SQL Server (2008/2005)

IBM

Informatica Developer

Kolkata, India

Period: July 2007 - May 2010

The in house project of IBM consisted of data to be migrated from different

legacy systems to SAP R/3 ware house using some validation rules in order

to be maintained. The developments were designed in order to have the

master data maintained in SAP R/3 system. Not all users have access to SAP

hence the data is created and maintained in different legacy systems and in

different forms. Global Data Conversion developments get the data from

these legacy systems and process/validate the data to maintain uniformly.

LSMW programs are then triggered in SAP in order to pull the data from the

staging db to SAP.

Responsibilities:

. Extensively used Informatica Tools to develop, Schedule, Execute

and Monitor all ETL jobs

. Developed Informatica ETL mappings per the Mapping Specifications

. Developed mappings to extract data from Flat files, DB2 sources

. Extensively used many transformations (Source Qualifier,

Normalizer, Joiner, Router, Update Strategy, Look Up, Union

transformation, Filter transformations etc) and assisted in

creating fact and dimension table implementation in Star Schema

model

. Designing and creation of complex mappings using the SCD types

extensively

. Created post-session and pre-session shell scripts and mail-

notifications and developed SQL Scripts to validate all mappings

business functionality for unit testing, extensively used Mapping

Variables & Parameters, Workflow Variables and Session Parameters

. Involved in Migrating the code from development to production

environments

. Build and maintain code to support data movement from production

databases to downstream databases/Files

. Unit testing the code with a sub-set data base and making sure the

test results match with the client requirement

. Extensively used performance tuning techniques to tune ETL jobs and

attended Daily production support

. Handling Ticketing system

Environment: Informatica Power Center (6.2), DB2 V9, Oracle (9i), Flat

Files, XML files

Major Achievements:

0. She has been associated with Continuous Improvement Process of various

existing projects.

1. She was single-handedly responsible for the design and implementation

of the 'Automated process of Production Monitoring' which resulted in

a huge manual effort reduction by about 50%. This has been accepted as

an Intellectual Capital by IBM (ICM) and a Continuous Improvement

Process (CIP) by Nestle

Educational Background:

Ankita has completed her Bachelors in Engineering in ELECTRICAL and

ELECTRONICS under Jawaharlal Nehru Technological University (JNTU) in

Andhra Pradesh, India for the year 2007

She has received Merit Certificate for Best Performer in the year 2006-07.

Contact this candidate