Madhuri Ponnaluru

abhkpq@r.postjobfree.com

330-***-****

Summary

• Over Seven years of experience in Programming, Database design, development and administration including four

years of full lifecycle development experience in Data Warehousing using Informatica PowerCenter/PowerMart in

Unix, NT, Oracle, Teradata, UDB and SQL Server environments for medium to large enterprise data warehouses.

• Area of expertise encompasses Database designing, ETL phases of Data Warehousing. This is achieved with an

emphasis on relational data modeling and dimensional data modeling for OLTP and OLAP systems.

• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation

and Loading of data from multiple sources into Data Warehouse.

• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling,

Snowflakes Modeling, fact and dimension tables modeling of data at all the three levels: view, logical & physical

• Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data

warehouses.

• Hands on experience in tuning mappings, identify and resolve performance bottlenecks in various levels like

source, target, mappings, and session.

• Responsible for all activities related to the development, implementation, administration and support of ETL

processes for large-scale data warehouses using Informatica Power mart and Power Center.

• Export & Import, Performance & Tuning of Database, Backup and Recovery, SQL*Loader.

• Sound knowledge in UNIX Shell Scripting and Automation of ETL process.

• Expertise in SQL, PL/SQL and Dynamic PL/SQL for stored procedures and user defined functions.

• Excellent communication and interpersonal skills.

• Knowledge of GAP analysis and experience in requirement gathering.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter /6.2/7.1/8.x, Power Connect/Exchange

RDBMS: Oracle 10g /9i, MS SQL Server 2000/2005, Teradata, DB2 7.1, MS Access 2000

Data Modeling: ERwin 4.0, SQL Server 2000 database diagram creator.

Business Intelligence: Business Objects Designer, Business Objects Supervisor, Business Objects Reporter, Oracle

Reports

Languages: Visual Basic 6.0, JAVA 2, SQL, PL/SQL, C, C++, PASCAL, UNIX Shell scripting, XML, COSORT.

Operating Systems: AIX, HP-UX, WINDOWS 2000/2003/NT/XP, Solaris.

Others: TOAD, SQL * LOADER, EMACS, Ultra Edit, WinSQL, SQL developer.

EDUCATION

Bachelor of Engineering, JNT University, Hyderabad, A.P, India (3.90 GPA)

PROFESSIONAL EXPERIENCE:

Client: PASA, Peachtree city GA DEC 2009 –Till date

Role: Lead ETL Developer

Project: Panasonic is a Japanese multinational consumer electronics corporation. Its main business is in electronics

manufacturing and it produces products under a variety of names including Panasonic and Technics. Panasonic was ranked the

89th-largest company in the world in 2009 by the Forbes Global 2000 and is among the Worldwide Top 20 Semiconductor Sales

Leaders. I’m currently working as a Lead Data Warehouse Analyst for their automotive division PASA. The current project

involves development of pricing data warehouse to increase pocket margin across multiple units globally

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, and metrics and

project coordination.

• Design data load/ ETL processes to implement complex business transformation rules for strategic projects.

• Lead the coordination of Quality Assurance with Quality Analysts and Business Analysts.

• Involved in the creation of oracle Tables, Table Partitions, Indexes.

• Implemented Referential integrity using primary key and Foreign keys relationships.

• Lead the team in Dimensional modeling of the Data warehouse and used Erwin to design the business process, grain,

dimensions and measured facts.

• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the

hierarchies in dimensions.

• Created mappings and complex mapplets using Informatica power center designer 8.6

• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for

generalized dimension keys, and Lookup transformation to identify slowly changing dimensions.

• Used task developer in the Workflow manager to define sessions.

• Created reusable worklets and workflows.

• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.

• Responsible for monitoring all the sessions that are running, scheduled, completed and Failed. Debug failed sessions.

• Worked on database connections, SQL joins, cardinalities, aliases, views, aggregate conditions, parsing of objects and

hierarchies.

• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.

• Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters,

conditions, calculations, etc.

• Documented processing times for each module, developed test cases and used them to run through each process. Tuned

the matching parameters based on test results. Implemented and supported the Business Intelligence environment and User

Interface.

• Maintaining strategic projects involved in multiple regions globally. Managing customers and IT resources in different time

zones and cultures

• Weekly Status Report Review sessions with the resources and prioritize the tasks per business needs.

• Generate Periodic Project Progress Reports and send communications to the project stakeholders.

• Architect Decision Support Systems (DSS) which drive key business decision-making activities.

• Involved in writing test scripts, unit testing, system testing and documentation. ING Pershing

BONU S Sy ste m

P re Sta g in g Data ba s Envi ro nm ent

e Sale s,

Dat a W ar ehouse R evenue,

C om is sos,

m in

O ra c l C omm is sio n

Pr ducs Rep,s

o t, e St o re

Bonus App icens san dOf ic es d Pr o c D ata Mar t

L e

y)

B onus s (D a il y

Dat abase

( D ai l

)

1 Loadin g Schema

at i c a

( L)

y) Or

rm

a il ac

In fo

le

(D So

s t

c (D r ed

ro B NS : om iss os &Pr o dct

Cm in us

O r a cl

P ia ly P ro

d Vm

P : Com ision, Pr du cs

s o t,

re ) cs

to

Rep & / f f es, ice sesd aa

s O ic L n t

il y )

2a Hi sto r ical Dat a

e St o r e d

S ( Da

le ca R ep

ac ma ti

Or In f o r

2 Re gis tr at io ns

1 Except io n

a il y )

Pr o c s ( D

& L ic ensin g

Info Hub

S c e ma (E)

h

Prime v est Sy ste m

(D

D ata Ma rt

2b (O )

DS

Com ission s

m,

5

t ci a

a i ly )

Pr odc t, Res /

usp Ora c

rm a

le S o

y)

O f es Lice nes

f ic, s

t re d

il In

(D a

Pr o s

fo

I nf o

dat

a

c

ti c a En te r pri se R eport ing Syste m (ER S )

( We e

rm

r ma I nfo r mati c ( Dail y)

a 6

k ly )

Busi nessObj ects

I n fo at Busin ess Obj ects

ic U niv erses f or Ad H

oc

a

(D

4 Rep ort in g

a

Pre St age i ly

PV App In

)

Pr im evest Schema ( H) fo

rm

Dat abase

( Da a t ic

ily a R ep

)

Appo in tm ent s

)

( D a i ly

Dat a Mart

Re p/s

C onfo r m ed

Da ta lo ad fr om PV and B NS source syste m t oL O f es,

f ic

1 D men s ons

i i

at i c a

Lice ses

n

(L oad in g ) d at abase a rm

dt a f o

4 S ta ndar d

rm

BN S

I n fo

In f o

Repor ts

rm a

Load (L ) to Pre s age Data lo ad . Business Rule s ar e

t

ti

a ppli ed t onat iv e data ( from L ) a nd popula t ed t o

ca ( D

Pr est agedat abase. Busin es r ule s i nclu de the

s B NS : eps / f cs,

R O ie

3 Licen esda aan d

s t

ai l y

2 f oll owi ng. a di t nalSm ar t o r s

io wk

)

A ppro pr ia t e re fere nt ia l i nte grit y checks acro ss dat

a

t able s . Ot herDat a

N U / NO TN ULL checks in appro pr i ate

LL M ts . . .

ar

c olumns

A ppro pr ia t e fi lter s wil l be appl ie d at th e sour c .

e

F or exampl e - a l l ta bl es w il have th ef ilt er BD < >

6 i. e . a l dat a ex ept f or t he ones re l ati ng t o BD

c

' IN G Fin anci al Advis er s' wil l fl ow to Pre Satg e

S W App

d atabase .

Smar tw orks D abase

at

R d s th atdo not m eetth e above busin ess r ule s

ecor

2a wi l be popula t ed i n t he except io n ta bl es .

Sm artwork s Sys tem

Tabl es f ro m th e exc ptio n t ables wil l be popul ate d in

e

2b t heH old in g database on a w eekly bas s . i

3 R eps and Offi ce i nfo r matio n (f rom BON US) i s sent t o 5 Dat aw are house lo ad fr om I nfo Hub .

Smart wor ks database .

Or acle Dat abase

D ata fr om Presta ge an S mar tw ork s are t ra nsf orm ed

4 6 D ata Ma rtl oads f ro m D ata w are house .

a ppr ori ate l y t o popul ate In f o H ub . DB 2 U B Data ba s

D e

Ent er pri se R rt in g Syste m ( ER S)

epo

Business Obje c s

t

Environment: Informatica Power Center 8.6, Business XI, Oracle 10 g, UDB DB2, SQL Server (2005), SQL/PLSQL,

UNIX Shell Programming, Erwin7.2, Unix (IBM – AIX)

Client: RockwellCollins, Melbourne, FL Jan 2009 – Dec 2009

Role: Lead ETL Developer

Project:

Rockwell Collins is a pioneer in the design, production and support of innovative solutions for customers in aerospace and

defense. They are experts in flight-deck avionics, cabin electronics, mission communications, and information management

systems. They are global company with more than 20,000 employees world wide.

This project dealt with development of Spending Analytics data warehouse which generates Indirect spend report monthly and

sends email. It involved interaction with Rockwells PeopleSoft HRM, Oracle, SQL Server, UDB DB2, and Sybase as source

databases. Oracle was used as Target Database.

Responsibilities:

• Interacted with the various Business People and Analyzed the Specifications and identifying the source data needs to be

moved to Data staging area.

• Coordinated with customer in finding the sources and targets for data conversion.

• Involved in generating various Fact and Dimension tables to provide Business intelligence solutions for End users according

Business rules by using Star-schema.

• Responsible for design and developing ETL process for Data management, Data merging, Data transformation, Data

loading, Cleansing and structuring the data.

• Involved in data warehouse modeling and physical database creation.

• Worked on designing staging area to facilitate ETL strategy.

• Responsible for handling slowly changing dimensions in Fact tables and Data loading and adopted strategy to refresh Fact

table and Dimension tables.

• Designed ETL process to load data from MS SQL Server, MS Access and Excel spreadsheets into Warehouse and Created

and Monitored Batches and Sessions using Informatica Server Manager.

• Used IPC to connect PeopleSoft and legacy systems.

• Create data cleansing & data integrity rules and implemented in the staging area to improve data marts quality

• Worked extensively on Source Analyzer, Mapping designer, Warehouse Designer.

• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.

• Extensively used almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Update Strategy,

Sequence Generator, and Rank.

• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.

• Involved in Writing shell scripts to automate the ETL process and dynamic SQL programs to drop and modify tables in

different data staging areas.

• Created test scenarios for unit testing.

• Involved in Debug and resolve high priority.

• Provided consulting to Production support team on a regular basis.

Environment : Informatica Power Center 8.0, SQL server OLAP cubes, Peoplesoft 9, Oracle 10 g, UDB DB2, SQL Server

(2005), SQL/PLSQL, UNIX Shell Programming, Unix (IBM - AIX), and NT.

Client: Primevest, St Cloud, MN DEC 07 – DEC 2008

Role: Lead ETL Developer

Project:

Primevest is a self-clearing registered broker-dealer serving the clients of more than nearly 600 financial institutions

throughout the United States. With its focus exclusively on financial institutions, PrimeVest delivers innovative

investment and insurance solutions, comprehensive support and a flexible program structure built to strengthen client

relationships. I worked as a Lead ETL Developer for EasyInfo project to improve advisory and brokerage business.

Responsibilities:

• Performed Development, Lead role for a team of 4, which involves providing database architecture guidelines, ETL

standards to the team, and code reviews.

• Involved in Toll gate reviews, status meetings, progress reports with project stakeholders

• Daily Meetings with Business team, DBAs and DAs to review requirements and enhancements for ETL processes

• Lead the support activities related to Informatica projects.

• Architect the MV log solution to resolve a business critical issue (capture source system hard deletes).

• Maintained Production support issue tracker to track ongoing production support issues and facilitate with a resolution.

• Developed Informatica and PL/SQL best practices documents and Run books for various projects

• Informatica Administration activities like pmserver, pmrepserver command line repository operations, security, repository

queries, repository backups, standardizing database connections, migration of the objects using Versioning and Deployment

groups, using pmcmd command.

• End-to-end development of mappings on Informatica PowerCenter 7.1.2

• Maintaining versions of Informatica objects using Informatica version control

• Extensively developed PL/SQL Procedures for ETL process for Oracle to Oracle loads

• Creating and Scheduling Sessions and Batch Process based on demand, run on time, run only once.

• Test all the applications and transport the data to target Warehouse Oracle tables on the server, Schedule and Run

Extraction and Load process and monitor sessions by using Informatica.

• Identified ETL bottle necks and tuned ETLs to improve performance using pipeline partitioning, optimizing sessions, etc.

• Migration of the code from Development to QA and Production

• Writing UNIX Shell scripts as per the requirements for various needs.

• Generated mapping Environment validation documentation using the Business Objects 6.5

• Created the Visio diagrams of ETL constructions in Informatica Mappings and Workflows

• Data Analysis, requirements gathering, functional/technical specification, development and deploying.

• Involved in Design process and Data Modeling using ERwin.

• Created Auto Profile and Custom Profile using Profile Manager

• Created profile sessions, validated and executed temporary and persistent profile sessions using Workflow manager / profile

manager.

Environment: Informatica Power Center 8.0, SQL server OLAP cubes,, Oracle 10 g, Business Objects XI Release 2,

SQL/PLSQL., IBM Rational RequisitePro, Gemini, SUMMIT Ascendant

Client: Motorola, Libertyville IL Dec 2006– Dec 2007

Client: Motorola, INDIA Jul 2005– Dec 2006

Role: ETL Developer

Project:

Motorola is a Fortune 100 company known around the world as an innovator and leader in wireless and broadband

communications. Motorola is a global leader in providing integrated communications solutions and embedded electronic

solutions. Worked as an ETL developer for development of Motorola Enterprise Data warehouse . This data warehouse is

developed to help the top executives make decisions about the products and to also analyze various metrics and understand the

performance of the organization. Data in EDW is consumed by different systems like Business Intelligence reporting using

Business Object, Decision support Systems, Executive Information, Demand Planning, Automated Underwriting systems.

Responsibilities:

• Created and reviewed detailed designs and specifications, and participated in developing project estimates, schedule,

and commitments.

• Business Analysis and Requirements Gathering

• Developed mapping to load the data in slowly changing dimension. The unconnected stored procedure for Look Up on target

table. Used Aggregate, Expression, Lookup, Update Strategy, Router and Rank transformation.

• Understand and document various layers and structures of data that ultimately results in providing high visibility,

business critical information for decision making

• Conduct in-depth analysis of existing data systems and provide design suggestions to enhance the existing data

models

• Involved in source system analysis and created target tables in DB2 database.

• Creating and Scheduling Sessions and Batch Process based on demand, run on time, run only once

• Conduct unit, regression test in both development and testing repositories.

• Test all the applications Schedule, Run Extraction, Load process and monitor sessions by using Informatica to transport

the data to warehouse.

• Design and development of pre-code and post-code ETL documentation.

• Created staging tables in Oracle using TOAD, sqlplus, and Informatica Warehouse Designer.

• End-to-end development of ETL process in Informatica PowerCenter 6.2

• Developed SQL queries, executed PL/SQL procedures to create configuration files in Target database of DB2.

• Migrated informatica objects and other scripts into Testing Repository using Check-in and Check-out of Revision Control

System (RCS).

• Generated the mapping and workflow specifications documentation using the Crystal reports 8.5.

• Created the Visio diagrams of ETL constructions in Informatica Mappings and Workflows.

• Involved in developing detailed Test plan, Test cases and test scripts

• Created and maintained test documentation and test plans.

• Data validation and Database integrity testing done by executing SQL, PL/SQL statements.

• Performed Back end Testing, Black Box testing, Functional testing and Regression testing

Environment: Informatica Power Center 6.1,Oracle 8i, SQL/PLSQL, UNIX Shell Programming, Rational Clear case, MS EXCEL

for test cases

Dev Systems, India Dec 2004 to Jul 2005

Role: Software Developer

Project

Dev Systems is an auto insurance organization serving businesses and individuals with a broad range of insurance products and

insurance-related services. This application involves in designing and development of the Data Warehouse. The company’s data

come from different operational source and is then loaded into the Claims Data Warehouse. Various Business Rules and

Business Processes where applied to Extract, Transform and Load the data into the Data Warehouse.

Responsibilities

• Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications.

• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database

(capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using ERwin.

• Wrote stored procedures in PL/SQL and Unix Shell Scripts for automated execution of jobs.

• Configured Repository set-up for Development, Testing and Production.

• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse

• Wrote UNIX Shell Scripts

• Executed sessions, Sequential and Concurrent Batches.

• Writing of Database Triggers, Stored Procedures, Functions and Packages

• Involved in creation of the database and database tables

• SQL LOADER utilities for loading text files

• Writing of Shell scripting

• Performance monitoring and tuning of Application and SQL Queries

Environment: Oracle 7.3.4, PL/SQL, SQL Plus and UNIX. SQL LOADER

HONORS AND ACTIVITIES

Obtained Gold medal in Bachelors from JNTU University

STRENGTHS

• Excellent organizational skills.

• Time and detail oriented.

• Ability to manage and work well with others.

• Desire to constantly gain more knowledge and skill set.

REFERENCES

Available upon request

Contact this candidate