Manager Data

TejaVardhan

Professional Summary:

> Over * years of strong experience as an Informatica (ETL) Developer in

System Analysis, Design, Development and Testing fields of Data

Warehousing, Client server technologies.

> Strong experience in integration of various data sources like Oracle

9i/10g, Teradata, MS SQL Server 2005/2000, DB2, Mainframe and Flat

Files.

> Proficient in warehouse designs based on Ralph Kimball and Bill Inman

methodologies.

> Extensive knowledge in architecture design of Extract, Transform, Load

environment using Informatica Power Mart and Power Center.

> Extensively used Informatica tools, Designer, Server Manager/Workflow

Manager, Work flow Monitor, Repository Manager.

> Extensively worked on Informatica Power Center Transformations such as

Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update

Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence

Generator and Union Transformation.

> Highly experienced in developing mappings using Parameters and

Variables. Extensively used parameter file to pass mapping and session

variables.

> Proficient in developing Slowly Changing Dimension Mappings of type I,

II and type III.

> Extensively played with Performance Tuning at Informatica and Database

(Oracle) Level.

> Excellent hands on experience in writing, testing and implementation

of the PL/SQL programs, Stored procedures, Functions, Triggers, Views,

Materialized Views, Packages, DTS and performance tuning of SQL

queries.

> Strong experiences in UNIX shell scripting. Created scripts for

calling pmcmd command, file watcher, FTP and file archiving scripts

> Strong practical understanding of Star Schema and Snowflake Schema

Methodology, using Data Modeling tool Erwin 4.0/4.2.

> Extensive experience in unit testing, System testing and User

Acceptance Testing.

> Highly adaptive to a team environment and proven ability to work in a

fast paced teaming environment with excellent communication skills.

Education Qualifications:

Masters in Computer Science

Skillset:

Informatica PowerCenter 8.6/8.1/7.1/6.x (Source Analyzer, Data Warehouse

Designer, Mapping Designer, Mapplet, Transformations, Workflow Monitor,

Worklets), Power Exchange 8.x, Business Objects XI, Data Modeling Tools

Erwin 7.0/4.1/5.1, Visual Basic 5.0/6.0, Visual C++ 5.0, ASP 3.0, Oracle

PL/SQL, SQL Plus, T-SQL, SQL Server DTS, DB2, Korn Shell Scripts, Oracle

7.x/8i/9i/10g/11g, MS SQL Server 2000/2005/2008, Teradata V2R5/V2R6, DB2

8.1, MYSQL, OBIEE 10.1.3, OBIA 7.9.6,C, C++, SQL, JAVA, PL/SQL, HTML, XML,

OS Sun Solaris 8/9/10, Linux, IBM AIX 4.3/5.2. Packages SQL* PLUS, Toad

8.6.

Projects Summary:

BlueCross and Blue Shield of TX, Richardson, TX

1/2009 - Present

Informatica Developer

Blue Cross and Blue Shield of Texas is the leading provider of health

insurance in the state. They implemented an Enterprise data warehouse to

deal with different kinds of health claims which are categorized as

Facility, Professional, and FEP. Data is coming from various sources like

Oracle, SQL Server, Flat files etc which will be loaded in to EDW based on

different frequencies as per the requirement. The entire ETL process

consists of source systems, staging area, ODS layer, Datawarehouse and

datamart.

Hardware/Software:

Informatica PowerCenter 8.6.1, Oracle 10g/11g, PL/SQL, Microsoft SQL Server

2008, SQL, MS Visio, OBIEE, Windows NT.

Responsibilities:

> Involved in every step of the SDLC. Involved in customer requirements,

Data analysis, process flow design, data modeling for atomic and

Datamart.

> Helped Architect in design and development of Conceptual, Logical, and

Dimensional Data Models for the Data Warehouse.

> Analyzed source data and formulated the transformations to achieve the

customer requested reports.

> Developed the process flow for the project and created the data model

for Atomic and Data mart based on the customer requirements.

> Involved in assisting the team to develop the mappings and execute.

> Worked in standardizing the shared processes across the enterprise

data warehouse.

> As the requirement is to maintain the history of every change for all

columns, I have implemented the slowly changing dimension type 2 with

effective start and end date of the record.

> Designed and coded the Autosys job flow, which is for job scheduling.

> Involved in project planning and coordinating business, source and

development teams to meet the project deadlines.

> Data analysis is done to see the impacts of change in source system to

the existing Informatica maps, Oracle PL/SQL packages to feed data

into existing Datamart.

> Formulated the business rules for changes identified in the analysis

and modified Informatica maps, PL/SQL packages and Autosys flow to

handle the load time of each regular cycle run.

> Key person in working for system performance improvement for the

datamart loading and reporting.

Merrill Lynch, Pennington, NJ

3/2007 -12/2008

Informatica Developer

Merrill Lynch is one of the world's premier providers of wealth management,

securities trading and sales, corporate finance and investment banking

services. The main objective of the project is to build a Corporate

Investment Bank Sales Data Mart. ETL Informatica Power Center was used for

the extraction, transformation, and loading of data into the data

warehouse. The project had several loads like Daily Loads, Weekly Loads,

Monthly Loads, Quarterly Loads, and YTD Loads. These loads were implemented

using Incremental Loading (Change Data Capture), and Slowly Changing

Dimension Mappings.

Hardware/Software:

Informatica Power Center 8.1/7.1.4, Oracle 10g, SQL Server, Sybase, OBIEE,

UNIX, Windows XP, CA Autosys Scheduler, StarTeam.

Responsibilities:

> Requirement gathering from the end users and preparation of the BRDs.

> Implemented ETL Informatica designs and processes for the load of data

from the sources to the target warehouse

> Designed mappings from the scratch and also did performance tuning of

the mappings that were previously implemented.

> Responsible for performance tuning at various levels like mapping

level, session level, and database level.

> Worked on Power Center Tools like Designer, Workflow Manager, Workflow

Monitor, and Repository Manager.

> Worked on Designer Tools like Source Analyzer, Warehouse Designer,

Transformation Developer, Mapplet Designer, and Mapping Designer.

> Responsible for Production Support and Issue Resolutions using Session

Logs, and Workflow Logs.

> Extensively used various active and passive transformations like

Filter Transformation, Router Transformation, Expression

Transformation, Source Qualifier Transformation, Joiner

Transformation, and Look up Transformation, Update Strategy

Transformation, Sequence Generator Transformation, Rank

Transformation, and Aggregator Transformation.

> Developed Re usable Transformations, and Re Usable Mapplets

> Worked with Shortcuts across Shared and Non Shared Folders

> Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2

SCD

> Responsible for implementing Incremental Loading mappings using

Mapping Variables and Parameter Files.

> Responsible for determining the bottlenecks and fixing the bottlenecks

with performance tuning.

> Worked with Index Cache and Data Cache in cache using transformation

like Rank, Lookup, Joiner, and Aggregator Transformations.

> Extensive experience in debugging and troubleshooting Sessions using

the Debugger and Workflow Monitor

> Worked with Session Logs, and Workflow Logs for Error handling and

troubleshooting in DEV environment.

> Implemented various loads like Daily Loads, Weekly Loads, and

Quarterly Loads using Incremental Loading Strategy.

> Responsible for Unit Testing and Integration testing of mappings and

workflows.

> Worked for a short period of time on reports generating through OBIEE

application

> Worked with third party versioning tool StarTeam for versioning.

> Worked with third party CA Autosys scheduling Team for scheduling the

Informatica Power Center Workflows.

Great West Insurance, Denver, CO

1/2006 - 2/2007

Informatica Developer

Great West Insurance Company serves a full range of managed healthcare,

life and disability insurance, and retirement savings products and

services. This project includes developing Data warehouse from different

data feeds and other operational data sources. Built a central Database

where data comes from different sources like oracle, SQL server and flat

files. Reports were generated using Siebel Analytics.

Hardware/Software:

Informatica Powercenter 6.1/7.1, Oracle 9i, Teradata, SQL, PL/SQL, MS SQL

Server 2000, TOAD, Erwin 4.1, UNIX Shell Script, Windows 2003.

Responsibilities:

> Created new mappings and updating old mappings according to changes in

Business logic.

> Performed major role in understanding the business requirements and

designing and loading the data into data warehouse (ETL).

> Used ETL (Informatica) to load data from source to ODS.

> Used Informatica client tools - Source Analyzer, Warehouse designer,

Mapping Designer, Mapplet Designer, and Transformation Developer for

defining Source & Target definitions and coded the process of data

flow from source system to data warehouse.

> Logical and Physical design of databases using Erwin.

> Worked with other teams on Facets Data model design and Facets batch

processing.

> Implemented Slowly Changing Dimensions - Type I & II in different

mappings as per the requirements.

> Used Informatica Workflow Manager and Workflow Monitor to schedule and

monitor session status.

> Used Debugger to troubleshoot the mappings.

> Developed mappings in Informatica to load the data from various

sources into the Data Warehouse, using different transformations like

Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence

Generator, Filter, Sorter and Source Qualifier.

> Implemented performance tuning logic on Targets, Sources, mappings,

sessions to provide maximum efficiency and performance.

> Wrote the PL/SQL procedures for data extraction, transformation and

loading.

> Defined Target Load Order Plan for loading data into Target Tables.

> Prepared Unit Test Cases.

> Generated various reports using Siebel analytics functionalities like

Queries, Slice and Dice, Drill down, Functions, Cross Tab,

Master/Detail and Formulas as per client requirements.

> Used shell scripts for post session operations.

Franklin Templeton Investments, Dublin, CA

6/2004 - 12/2005

ETL Developer

Franklin Templeton Investments is a global investment management

organization offering investment solutions under the Franklin, Templeton,

Mutual Series, Bissett, Fiduciary Trust and Darby Overseas names. The

project team Corporate Financials is involved in building in DW for the

purpose of measuring Fund Profitability. Data from main frames is being

pulled from mainframes in the form of flat files and dumped into ODS using

Informatica 5.1.From ODS, which is maintained in Oracle the data will go to

ODE and then to the Data-Mart using DataStage Acential. Reporting done

using Cognos.

Hardware/Software:

Informatica PowerCenter 6.1, DataStage, Oracle 9i, PeopleSoft, UNIX, Cognos

7.0

Responsibilities:

> Worked extensively on Normalizer, Source Analyzer, Mapping Designer,

and Warehouse Designer.

> Developed several Maps and Mapplets using corresponding Source,

Targets and Reusable Transformations.

> Set up Batches and Sessions to schedule the loads at the required

frequency using Server Manager

> Analyzing the source data and deciding on appropriate extraction,

transformation and loading strategy.

> Extensively worked on all the transformations like Filter, Aggregator,

Expression, Router, Dynamic Lookup, Update Strategy, Sequence

generator, Rank.

> Involved in Performance Tuning of Complex Maps having multiple Lookups

and Target Tables.

> Used the command line program Pmcmd to communicate with the

Informatica Server.

> Uploading the Data files into the tables of the Oracle database in the

server running on UNIX with the help of a scheduled Cron job.

> Performed activities including design of exception handling strategy

and performance tuning of custom stored procedures in PL/SQL.

Airtel, Hyderabad, India

6/2002 - 5/2004

ETL / Informatica Developer

Airtel is a brand of telecommunication services in India. This Project is

basically developed for Airtel for building a data mart and OLAP reports

for order management, strategic testing and tactical call center/customer

relationship Management. This data mart stores historical information about

Local, Long Distance, Voice Mail, and Pager Services. This system extracts

data from order management system database (OLTP).

Hardware/Software:

Informatica PowerCenter 5.1.1, Oracle 9i, MS SQL SERVER 2000, SQL, PL/SQL,

SQL*Loader, UNIX Shell Script.

Responsibilities:

> Extracted Data from Different Sources by using Informatica.

> Extensively used Informatica client tools Source Analyzer, Warehouse

designer, Mapping designer and Mapplet Designer.

> Extracted data from different sources of databases. Created staging

area to cleanse the data and validated the data.

> Designed and developed complex Aggregate, expression, filter, join,

Router, Lookup and Update transformation rules.

> Developed schedules to automate the update processes and Informatica

sessions and batches.

> Analyze, design, construct and implement the ETL jobs using

Informatica.

> Developed mappings/Transformations/mapplets by using mapping designer,

transformation developer and mapplet designer in Informatica Power

Center 6.1.

> Developed Shell scripts to setup runtime environment, and to run

stored procedures, packages to populate the data in staging tables.

> Created Users, user groups, database connections and managed user

privileges using supervisor.

Contact this candidate