Data Sql Server

GAYITHRI ABBU

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

Ph: 732-***-****

PROFESSIONAL SUMMARY:

. 6 years of extensive hands-on experience in the field of Data

Warehousing, ETL Integration, Database development and Business

Intelligence with industry exposure in

Finance, Advertising, Retail Merchandising and Insurance

. 5+ years of experience in designing and developing ETL applications

using Informatica Power Center 8.6/7.1/6.2

. 5+ years of professional experience with complete SDLC involving

Business Analysis, Design, Development, QA, Documentation, Knowledge

Transfer and Production Support.

. Strong knowledge in ER Data Modeling,Dimensional Data Modeling (Star

Schema, Snowflake Schema) and Data Warehousing methodologies (Kimball

and Inmon methodologies)

. Experience in integration of various data sources like SalesForce.com,

SQL Server, Oracle, Teradata, Sybase, DB2, MS Access, Flat files, XML

and COBOL files.

. Successfully completed training on SAS and Talend Open Studio 3.x,

conducted by Talend Corporation.

. Expertise in PL/SQL in creating database Stored Procedures, Functions,

Packages, Triggers, Cursors and Indexes

. Expertise in Shell Scripting, and XML.

. Expertise in migrating and integrating legacy system data to

relational database systems.

. An efficient Team Leader and a Team Player. Efficient in Task

assignment and mentoring the team members.

TECHNICAL SKILLS:

Operating Systems: UNIX, IBM-AIX, LINUX, IBM Mainframe, Windows

Vista/XP/NT

ETL/BI/CRM Tools: Informatica PowerCenter 8.6/7.1.3/6x/5x (Power Center

Designer, Warehouse Designer, Repository Manager,

Workflow Manager, Workflow Monitor), SalesForce.com,

CPWerx 6.0

Databases: Oracle 11g/10g/9i/8x, Teradata, SQL Server 2008/2005,

Sybase, DB2 8.5/7.2/7.1, MYSQL, MS Access

Modeling tools: Erwin r7.2

Query Tools: SQL*Plus, SQL Loader, TOAD, WinSQL, RapidSQL, Advanced

Query Tool, APEX,SQL Server Management Studio 2008

Scheduling Tools: AUTOSYS, TIDAL

XML: XML,DTD,XML Schema

Problem Mercury Test Director

Management:

Messaging tools: MQ Series, TIBCO

1

PROFESSIONAL EXPERIENCE:

Moodys Analytics, New York, NY

Nov '10 - Current

Title: ETL/Informatica Lead

Description: The Customer Reporting Project is part of a broader effort at

Moody's Analytics to improve the quality and accessibility of customer data

to support better business decision-making and drive increased revenue.

Responsibilities:

. Coordinated with business users and business analysts, on a regular

basis to discuss the

business requirement documents and transformed them into technical

specification documents.

. Coordinated with source system and data owners over resolution of

source data issues and better understanding of source data systems.

. Performed data profiling and analysis of various objects in

SalesForce.com (SFDC) and MS Access database tables for an in-depth

understanding of the source entities, attributes, relationships,

domains, source data quality, hidden and potential data issues, etc.

. Developed Source-Target Map documents to describe the relationship

between source and target data.

. Developed ETL Specification Design document containing detailed

information on ETL processing, mapping/workflow specifications,

exception handling process, staging and data warehouse schemas, etc.

. Designed and developed Informatica ETL Interfaces to load data

incrementally from SFDC, MS Access databases and Flat files into

Staging schema.

. Designed and developed Informatica ETL/SCD Interfaces to load data

from Staging schema into the Customer Reporting DW dimension tables.

. Designed and developed Informatica ETL Interfaces to load data from

Staging schema into the Customer Reporting DW Fact tables.

. Scheduled ETL jobs for the entire DW load process using Informatica

scheduler

. Coordinated with Testing Team to develop unit, system and integration

test cases to detect and resolve development defects.

Environment: Informatica Power Center 8.6, Salesforce.com, SQL Server 2008,

Power Exchange 8.1, ER Studio 8.0, RapidSQL7.6.1, PL/SQL, Ataccama Data

Profiler, Apex Loader

SuperMedia, Dallas, TX

Mar '10 - Oct '10

Title: Sr. Informatica Consultant

Description: SuperMedia (formerly known as Idearc Media) is a large

advertising and marketing firm whose advertising products and services

include Verizon SuperYellowPages, FairPoint, SuperYellowPages,

Superpages.com, EveryCarListed.com, SuperpagesDirect direct mail products,

etc. As a Sr.Informatica Developer for the large marketing institution, I

was involved in the design and development of Data warehouse

Responsibilities:

. Member of core ETL team involved in gathering requirements, performing

source system analysis and development of ETL jobs load the target DW.

. Analyzed the business requirement document and created functional

requirement document mapping all the business requirements.

. Designed and Developed ETL mappings using transformation logic for

extracting the data from various sources systems.

. Experience in using Oracle Application Express via APEX rapid

development tool for data centric (web applications).

. Designed and developed complex ETL mappings making use of

transformations like Source Qualifier, Application Source Qualifier,

Joiner, Update Strategy, Connected Lookup and unconnected Lookup,

Rank, Expression, Router, Filter, Aggregator and Sequence Generator

transformations.

. Automated the load process using UNIX shell scripts.

. Extracted various data from SalesForce.com using Informatica 8.6 with

Sales Force Adapter.

. Worked on updating Sales Force using external ID.

. Modified SOQL (Sales force object Query Language) for Sales Force

target at session level.

. Implemented Change Data Capture (CDC) on Source data from

Salesforce.com

. Created various objects in SalesForce.

. Used APEX explorer to query the SalesForce.

. Worked on SQL optimization and identified bottlenecks and performance

tuned the Informatica mappings/sessions.

. Performed the data validations and control checks to ensure the data

integrity and consistency.

. Involved in developing test plans and test scripts to test the data

based on the business requirements.

. Responsible for regression testing ETL jobs before test to production

migration.

. Supported migration of ETL code from development to QA and then from

QA to production.

Environment: Informatica Power Center 8.6, DB2, Power Exchange 8.1, Erwin,

TOAD, PL/SQL, Flat files, XML, Oracle 11i/10g/9i, Unix Maestro, Apex,

Salesforce.com

R J Reynolds Tobacco Co., Winston Salem, NC

Jun '08 - Feb '10

Title: ETL Informatica Consultant

Description: R.J. Reynolds is the second-largest tobacco company in USA,

primarily engaged in the manufacturing of smoking and smoke-less tobacco

products. Voyager CONNECT (VC) is a CRM application implemented at RJ

Reynolds that automated the Consumer and Trade Marketing Process.

Responsibilities:

. Discussed business requirements with business user group and business

analysts and transformed them into technical requirements.

. Developed Detailed Technical Specification and Logical Data mapping

documents for all the Informatica Interfaces developed.

. Developed ETL interfaces to integrate master data from Oracle, SQL

Server, and Flat file source systems into Oracle database.

. Developed change detection interfaces to implement Change Data Capture

(CDC) on master data.

. Designed and implemented ETL interfaces to generate Order transaction

reports for all RJRT product-selling outlets in USA.

. Developed UNIX scripts to create file lists, transfer and archive

source data files for backup and audit purposes.

. Used TIDAL to schedule the execution of ETL workflows, Data validation

scripts and File transfer and archival scripts.

. Developed and Documented Unit Test cases as part of the testing

deliverables.

. Used TIDAL to schedule Informatica workflow and UNIX scripts.

. Assisted the Production Support Team to ensure smooth execution of the

interfaces.

. Developed Knowledge Management contracts to help knowledge transition

of the development activity and documentation to the client.

Environment: Power Center 8.6/7.1.2,Oracle 10g,Teradata,SQL Server,

PL/SQL, AIX, DB2, TIDAL,TIBCO, Rapid SQL, AQT, SERENA, CPWerx6.0, Mercury

Test Director, Reflection X

Lowes Companies Inc., Wilkesboro, NC

Jan '07 - May '08

Title: Informatica Developer

Description: Lowes is a leading home improvement retailer with a total of

approximately 1600 stores in U.S and Canada, ranking #48 on the FORTUNE

500.

LDW is an Enterprise Data warehouse used to maintain a centralized

repository of store related data across the nation to support strategic

reporting and analytics to drive business decisions.

Responsibilities:

. Interacted with Business Analysts and Data Modelers to understand the

data model and clarify transformation rules to propagate data

movement.

. Developed Informatica Mappings to translate the Business Requirement

to ETL Logic to facilitate extraction of data from disparate sources

and propagate into the staging area.

. Developed Interfaces to extract, clean, conform and stage Sales

promotion master data from Trade Marketing System.

. Modified the existing Surrogate Key pipeline mappings to accommodate

for the Promotion related data.

. Developed and Unit Tested mappings involving complex transformations

to migrate valid and consistent data using Informatica as ETL tool.

. Developed Logical Data Map documents to describe the relationship

between source and target data.

. Developed and Documented Unit Test cases as part of the interface

development deliverable.

. Involved in System and Integration Testing in order to detect and

resolve development defects.

. Provided Production Support to ensure smooth execution of the

interfaces.

. Executed Cron jobs to initiate Informatica work flows.

. Enhanced existing Shell Scripts to enable audit checks and control

movement of data at various steps of data propagation.

. Improved the performance of long running batch jobs with the help of

SQL tuning, indexes and partitioning.

. Participated in mentoring and knowledge transition of the development

activity with the client.

Environment: Power Center 7.1, SYBASE, Oracle 9i, PL/SQL, UNIX/AIX, DB2,

TeraData, Cron, PuTTY, Test Director, Talisma

Nationwide Insurance, Columbus, OH

Oct '05 - Dec '06

Title: ETL Developer

Description: Nationwide is one of the largest insurance and financial

services companies in the world.

The FOCUS Project was a key Nationwide initiative that integrated disparate

financial systems into a single suite of applications that provide company-

wide visibility to financial information. Project involved creating process

for loading data into a data warehouse giving the users to access, analyze

and share information in the data warehouse.

Responsibilities:

. Interacted with Business users in development and documentation of

complex business concepts into technical specifications applicable to

various data movement and transformation processes.

. Played a significant role in the CONVERSIONS project - Historical data

conversion from the current systems and Nationwide enterprise

companies to the FOCUS financial platform.

. Implemented Joiner, Expression, Aggregate, Rank, Lookup, Update

Strategy, Filter, Sequence generator and Router Transformations, and

Mapplets in Mappings.

. Designed, Developed and maintained SQL Loader scripts, PL/SQL

procedures, functions, triggers to populate Oracle Tables.

. Used TOAD, SQL Tools to work with databases.

. Extensively worked on tuning the mappings and workflows.

. Used Maestro Job Scheduler to schedule Informatica and other jobs.

. Prepared Unit test documentation and cases/scenarios for the entire

team.

. Responsible for migrating mappings/workflows from Development to Test

and Test to Integration environments.

. Collaborating with development and QA teams to resolve defects.

Environment: Informatica Power Center 6.2, Oracle 9i, Teradata, PL/SQL,

UNIX

EDUCATION:

Master of Science, Osmania University, India.

Bachelor of Science, Nizam College, India.

Contact this candidate