Highly Motivated IT professional with * Years of experience in IT Industry

with more than 6 years in Business Requirement Analysis, Application

Design, Data Modeling, ETL Development, Implementations and Testing of Data

Warehousing and Database business systems for Financial, Insurance, Retail

Industries.

Summary:

. Data Warehousing: Over 6+ years of hands on experience in ETL and Data

Integration for developing ETL mappings and scripts using Informatica

Power Center 9.5/9.1/8.6.1/8.6/8.1/7.1 using Designer, Repository

Manager, Workflow Manager & Workflow Monitor. Exposure on Power

Exchange functionality

. Involved in understanding client Requirements, Analysis of Functional

specification, Technical specification preparation and Review of

Technical Specification

. Extensive experience in creating Transformations and Mappings using

Informatica Designer to implement business rules and processing tasks

using Workflow Manager to move data from Multiple Sources into

Targets.

. Expertise in working with various transformations using Aggregator,

Data Masking, Look Up, Update Strategy, Joiner, Filter, Sequence

Generator, Normalizer, Sorter, Router, XML, Stored procedure in

Informatica PowerCenter Designer.

. Experience in Performance Tuning and Optimization of the Sessions and

Mappings.

. Proficiency in data warehousing techniques for Data Cleansing, Slowly

Changing Dimension Phenomenon.

. Strong RDBMS concepts and experience in creating, maintaining and

tuning Views, Stored Procedures User Defined Functions and

System Functions using SQL Server, T-SQL.

. Experience in T/SQL Development on database processes.

. Wrote PL/SQL procedures, SQL scripts, and SQL*Loader control files for

creating a development database

. Expertise in creating Stored Procedure/Functions, Triggers and

Packages in Oracle 9i/10g.

. Databases: Experience in handling various Data sources like

DB2(9.x/8x),Informix,ORACLE (11/10/9g), Teradata,SQL Server

2008/2003/2000, MS Access, Ms Excel.

. Experience in using Erwin to design Logical/Physical Data Models.

. Data Modeling: Extensive experience in Analyzing the Dimensional Data

modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables,

Physical & logical data.

. Reporting: OBIEE 10g

. SDLC: Exposure in overall SDLC including requirement gathering,

development, testing, debugging, deployment, documentation, production

support.

. Coordinate ETL and database development work with developers and

conduct code reviews

. Exposure knowledge of Informatica Migration and Upgrade.

. Experience in Scheduling tools like AUTOSYS.

. Other: Knowledge of UNIX shell scripting job scheduling on multiple

platforms.

. Excellent individual and team performer maintains high levels of

communication with Business Analysts and end users to enable better

team performance.

Education:

. Bachelor's degree in Computer Science And Information

Technology,JNTU,HYDERABAD,INDIA

TECHNICAL SKILLS:

Data Warehousing Informatica Power Center 9.x/8.x/8.x/7.x, Power Exchange

8.6,Repository Server Administrator Console, Power Exchange,

Designer, Manager

Reporting Tools Oracle Business Intelligence Enterprise Edition 10g

Database & Related SQL*Plus,Teradata, Oracl Oracle 10g/9i/8i,Mainframe

DB2,Informix,IBM DB2, TeradataMS SQL Server 2000/2005,

Sybase, MS Access 7.0/2000.

Data Modeling Dimensional Data Modeling, Star Schema Modeling, Snow Flake

Modeling, FACT and

Dimensions Tables, Physical and Logical Data Modeling.

Operating Systems UNIX, Windows Server 2003, Windows XP/NT

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

Basic.

Applications TOAD, SQL Loader,PL/SQL developer, Autosys, Work Scheduler,

Microsoft Visio.

Professional Experience

SHOPBOP(AMAZON),Madison,WI

July'13- Till Date

Informatica Developer.

Project:: Shopbop, a retailer of designer clothing and accessories for

women. The Retail project is an Integration Project which sources the data

from Warehouse and Provide Clean and Consistent data to meet Operational

needs of the Front end Application. Further, Data is used by Business Users

to analyze and make decision on the Retail Prices, allocation amount

throughout all the business in shopbop.

Responsibilities:

. Prepared the mapping design document using the specifications gathered

from the Business Analysis teams

. Created the ETL logic document and dependency mapping sheet.

. Worked extensively on Informatica 9.1 client tools such as Designer,

Workflow manager, Workflow Monitor

. Extracted data from different sources like Oracle, flat files and

loaded into DWH.

. Created complex mappings in PowerCenter Designer using Aggregate,

Expression, Filter, and Sequence Generator, Update Strategy, Lookup,

Joiner, and Stored procedure transformations.

. Developed mappings/Reusable Objects/mapplets by using mapping

designer, transformation developer and mapplet designer in Informatica

PowerCenter 9.1

. Used Informatica PowerCenter 9.1 for extraction, loading and

transformation (ETL) of data in the data warehouse.

. Handle Slowly changing dimensions Type I and Type II based on the

business requirements.

. Used Informatica Power Center Workflow manager to create sessions,

batches to run with the logic embedded in the mappings.

. Involved in scheduling the informatica workflows using Informatica

Scheduler.

. Migrated mappings, sessions, and workflows from development to testing

and then to Production environments.

. Performing the production support for the daily routine jobs.

. Involved in Performance tuning for sources, targets, mappings and

sessions

. Implemented Slowly Changing Dimension (SCD) Type 2 for inserting and

updating Target tables for maintaining the history.

. Designed and created an Autosys job plan to schedule our processes.

. Used PL/SQL to write stored procedures to increase the performance.

. Developed post-session and pre-session shell scripts for tasks like

merging flat files after Creating, deleting temporary files, changing

the file name to reflect the file generated date etc.

. Developed various sessions, batches containing parameters files,

indicator files and multiple sources file.

. Designed and developed UNIX shell scripts as part of the ETL process

to compare control totals, automate the process of loading, pulling

and pushing data from and to different servers.

. Validated the data for accurate load into target databases.

. Worked on AUTOSYS Scheduling tool to automate the ETL jobs.

Environment: Informatica Powercenter 9.1,Oracle 11g, SQL Developer,

Autosys, PL/SQL, UNIX. SQL Query Analyzer, SQL Server, Flat Files.

Lincoln Financial Group, Philadelphia, PA

Jan' 11- July'13

Informatica Developer.

Project: Broker Dealer Systems: Lincoln National Corporation is a Fortune

200 American holiding company, which operates multiple insurance and

investment management businesses through subsidiary companies. The project

involves delivering files to its clients who will be used in respective

client's portfolio centers for reporting and reconciliation. The project

aims at delivering new files for new features, code enhancements for

additional features, round the clock production support and performing bug

fixes, change requests and maintenance requests.

Responsibilities:

. Prepared the mapping design document using the specifications gathered

from the Business Analysis teams

. Created the ETL logic document and dependency mapping sheet.

. Worked extensively on Informatica 9.1 client tools such as Designer,

Workflow manager, Workflow Monitor

. Worked on Informatica transformations such as Source Qualifier,Data

Masking, Filter, Update Strategy, Union, Sorter, Expression,

Aggregator, Joiner, Connected & Unconnected Lookup transformation,

Sequence Generator, Transaction Control etc

. Worked extensively using Datamasking Transformation to mask the

Values.

. Developed Informatica mappings/sessions/workflows - Extensively used

Dynamic/Persistent Lookup cache techniques for minimizing the load

window

. Creating, maintaining and tuning Views, Stored Procedures User

Defined Functions and System Functions using SQL Server, T-SQL..

. Load data to applications which used by the company supervisors.

. Identified all the conformed dimensions to be included in the target

warehouse design and confirmed the granularity of the facts in the

fact tables.

. Extensively created Reusable Transformations and Mapplets to implement

the business logic for loading to the target database.

. Designing the ETL process flows to load the data into Oracle Data Base

from Heterogeneous sources.

. Involved in performance tuning SQL and Informatica mappings/sessions

by session partitioning techniques.

. Load data from various source flatfile, xml, ORACLE, etc to stage

table.

. Implemented Slowly Changing Dimension (SCD) Type 2 for inserting and

updating Target tables for maintaining the history.

. Designed and created an Autosys job plan to schedule our processes.

. Used PL/SQL to write stored procedures to increase the performance.

. Developed post-session and pre-session shell scripts for tasks like

merging flat files after Creating, deleting temporary files, changing

the file name to reflect the file generated date etc.

. Developed various sessions, batches containing parameters files,

indicator files and multiple sources file.

. Designed and developed UNIX shell scripts as part of the ETL process

to compare control totals, automate the process of loading, pulling

and pushing data from and to different servers.

. Validated the data for accurate load into target databases.

. Worked on AUTOSYS Scheduling tool to automate the ETL jobs.

. Migrated Informatica objects (mappings/sessions/work lets/workflows)

from the Dev to QA, Perf and Production Environments

. Involved in ETL testing, Created Unit test plan and Integration test

plan to test the mappings, created test data.

Environment: Informatica Powercenter 9.1,Oracle 10g,SQL Developer, Autosys,

T-SQL,PL/SQL, UNIX. SQL Query Analyzer, SQL Server, Flat Files, Windows

2008.

Farmers Insurance Olathe, KS

Oct' 08 - Dec' 10

Informatica Developer

Farmers Insurance is one of the leading companies in the nation for the

auto insurance with more than 10 million policyholders. Its companies have

consistently received high ratings for financial strength and claims paying

ability from various independent rating agencies. The Insurance DW project

was developed in an effort to streamline the entire process of Insurance

and to keep track of various financials on a daily, weekly, monthly basis.

Claims, Premium, Loss and Contracts were some of the modules to deal with.

Responsibilities:

. Interacted with Business Analysts to gather the business requirements

. Performed data analysis based on the source systems and existing OLTP

database systems.

. Defined attributes on various dimensions like Organizations, Financial

Instruments, Plans, Accounts, Transactions.

. Analyzed the functional specs provided by the data architect and

created technical specs documents for all the mappings.

. Develop logical and physical data models that capture current

state/future state data elements and data flows using Erwin

. Converted the data mart from Logical design to Physical design,

defined data types, Constraints, Indexes, generated Schema in the

Database, created Automated scripts, defined storage parameters for

the objects in the Database

. Designed The Tables to load Historical data for ITD, YTD values and

Error Handling process.

. Extracted Sources with high volume datasets from various sources like

COBOL, Text Files, XML, and Relational Tables.

. Documentation of Technical specification, business requirements,

functional specifications for the development of Informatica

Extraction, Transformation and Loading (ETL) mappings to load data

into various tables.

. Designed and developed Informatica mapping and incremental

updating/aggregation strategies.

. Responsible for moving the mappings and sessions from development

repository to production repository box, creating shortcuts to share

the repository objects.

. Developed mappings, sessions, workflows and workflow tasks based on

the user requirement and scheduled the workflows in workflow manager

and monitor the load status in the workflow monitor.

. Performance tuning of sources, targets, mappings and SQL queries in

the transformations.

. Wrote PL/SQL procedures, SQL scripts, and SQL*Loader control files for

creating a development database.

. Unit testing of the mappings and Integration testing of the developed

workflows for analyzing the actual and expected results

. Created mappings in designer to implement the type 2 slowly changing

dimensions.

. Used Informatica debugging techniques to debug the mappings and used

session log files and bad files to trace errors occurred while

loading.

. Creating Test cases for Unit Test, System Integration Test and UAT to

check the data.

. Created Oracle Stored Procedure to implement complex business logic

for good performance and called from Informatica using Stored

Procedure transformation.

. Wrote UNIX scripts to maintain the workflows and to email customers

and session log files to the development team in case of failures.

. Document all ETL related work per company's methodology.

Environment: Informatica PowerCenter 8.6, ORACLE10g, SQL Server 2000,TOAD,

UNIX, Windows XP Professional

UCB Pharma,Atlanta,GA

May '08- Sep '08

Informatica Developer

UCB Pharma has instructed Advantage MS to design, implement and operate its

Customer Master, Operational DB and Data Mart as part of UCB Pharma

Business Information Architecture. To accomplish this we are maintaining 3

Databases namely Raw_DB, ODB (Operational DB) & DM_DB (Data Mart DB). The

Process of Data movement can be in done in 3 phases, in the first phase

data movement is between UCB to Raw DB, in the second phase Raw DB to

Operational DB and in the third phase Operational DB to Data Mart DB by

using, various business logic.

Responsibilities:

. Worked closely with client in understanding the Business requirements,

data analysis and deliver the client Expectation.

. Used Informatica PowerCenter 8.6.1 and its all features extensively in

migrating data from OLTP to Enterprise Data warehouse.

. Configured the OBIEE for Oracle database; understood and implemented

the clients reporting requirements.

. Extracted data from different sources like Oracle, flat files and

loaded into DWH.

. Created complex mappings in PowerCenter Designer using Aggregate,

Expression, Filter, and Sequence Generator, Update Strategy, Lookup,

Joiner, and Stored procedure transformations.

. Developed mappings/Reusable Objects/mapplets by using mapping

designer, transformation developer and mapplet designer in Informatica

PowerCenter 8.6.1

. Used Informatica PowerCenter 8.6.1 for extraction, loading and

transformation (ETL) of data in the data warehouse.

. Handle Slowly changing dimensions Type I and Type II based on the

business requirements.

. Used Informatica Power Center Workflow manager to create sessions,

batches to run with the logic embedded in the mappings.

. Involved in scheduling the informatica workflows using Informatica

Scheduler.

. Migrated mappings, sessions, and workflows from development to testing

and then to Production environments.

. Performing the production support for the daily routine jobs.

. Involved in Performance tuning for sources, targets, mappings and

sessions.

. Performed unit testing on the Informatica code by running it in the

Debugger and writing simple test scripts in the database thereby

tuning it by identifying and eliminating the bottlenecks for optimum

performance.

. Wrote PL/SQL stored procedures & triggers, cursors for implementing

business rules and transformations.

. Worked extensively with different caches such as Lookup cache (Static,

Dynamic, Persistence and Shared).

. Utilized C# in implementing back end databases.

. Created deployment groups, migrated the code into different

environments.

. Worked closely with reporting team to generate various reports.

Environment: Informatica PowerCenter 8.6.1 (Power Center Repository

Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 10g,

TOAD 6.0, SQL, PL/SQL, UNIX

GE Capitol Hyderabad,India

Jan'08 - May'08

ETL Developer

This system helps the customer service representatives to deal and transact

with customers loan, credit, debit, portfolios, investment etc. The

operational data of different financial departments loaded into central

Data Warehouse and transformed into different regional data marts. The

various corporate metrics/web reports like Credit Profile, Product Profile,

and Funds Transfer etc. were generated periodically.

Responsibilities:

. Installed and Configured Informatica Server, Repository, Shared

Folders, Client tools to connect database.

. Designed Transformations, Mappings using Informatica Designer, Source

Analyzer, Warehouse, Designer and Mapping Designer.

. Created folders to organize and store all Meta data in the repository,

mappings and sessions.

. Created Active, Passive, Connected, Unconnected and Reusable

Transformations.

. Created complex Expression, Aggregate, Rank, Filter, Stored

Procedure, Joiner and Dynamic & Static Lookup Transformations.

. Created Star and Snowflakes schemas using Fact and Dimension tables.

. Scheduled Sessions and Batches in Informatica Server at off peak time.

. Populated tables like ad campaigns by region, industry and indexed in

order to manage very large volume of data.

. Implemented proper Security of Repository by creating user groups,

users, privileges.

. Designed various Universes to generate required reports.

. Manipulated data in reports using Filters, Sorting, and Ranking etc.

Environment: Informatica PowerCenter 7.1, Power Mart, Business objects

Enterprise 6.0, Oracle 8i, Erwin

Llyods Bank,Hyderabad,India

Jun '07 - Dec' 07

Oracle Developer

Description: Lloyds is one of the leading banking sectors in UK. Bank has a

need for an analytical Data warehouse to improve the decision-making

system. They mainly wanted to get information about season wise financial

analysis, target custom groups, loss making schemes, profitable schemes,

Branch wise analysis etc. Worked as Database developer in client / server

environment, design and modifications of various applications using Oracle

and Developer 2000. Developed various forms and reports for departments

such as: quality control, warehouse and finance.

Responsibilities:-

. Involved in the entire system study, analysis and designs.

. Created Entity Relationship diagrams, Functions Relationship diagrams,

data flow diagrams and enforced all referential integrity constraints

using Oracle Designer.

. Involved in the creation of schema objects like indexes, views, stored

procedures and synonyms.

. Involved in the analysis of how the purchase order was organized.

. Created SQL tables with referential integrity and developed queries

using SQL and PL/SQL.

. Involved in writing triggers which internally called procedure and

functions.

. Involved in testing the database for queries that were generated and

handled the performance issues effectively.

. Involved in documenting the entire technical process.

. Supported technical teams involved with ORACLE issues and operations.

. Involved in the maintenance of the database.

. Environment: Oracle 8.0, Oracle Designer, UNIX

Contact this candidate