Data Manager

Madhuri Geddam

*********@*****.*** 203-***-****

* ***** ** **** ********** in IT Industry in Analysis, Design,

Development and maintenance of various software applications mainly in

Data Warehousing(Informatica Power Exchange, Informatica Power Center,

Data Stage, Business Objects),Oracle(SQL,PL/SQL) and Windows

environments in industry verticals like Banking, Marketing, Retail,

Hospitality and Healthcare.

8 years of Dimensional Data Modeling experience using Data modeling,

Relational Data Modeling, Star Join Schema/Snowflake modeling, Fact and

Dimensions tables and also worked on Physical and Logical data modeling

OLTP, OLAP, Data Dictionary.

8 years of ETL and data integration experience in designing and

developing ETL mappings and scripts using Informatica Power Center

8.6.1/8.0/7.1 using Designer, Repository Manager, Repository Server,

Workflow Manager, Workflow Monitor, Operational Data Store(ODS)

8 years of experience in designing Reports, Dashboards using the

reporting tools like Business Objects 5.1/6.X and Crystal reports

Worked extensively with complex mappings using different

transformations like Source Qualifiers, Expressions, Filters, Joiners,

Routers, Union, Unconnected/Connected Lookups, and Aggregators.

Extensive experience in implementing Type 1 and Type 2 Slowly Changing

Dimensions as per the requirements.

Experience in developing Sessions/tasks, Worklets, Workflows using

Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.

Experience in using the Informatica command line utilities like pmcmd

to execute workflows in non-windows environments.

6 years of experience in tuning SQL statements, Procedures, ETL

processes and their respective applications to enhance the data load as

well as to improve the application response time

8 years of experience in writing PL/SQL using Oracle Parallel Queries,

Materialized Views, Bulk collects to validate and justify business

requirements

Solid team player with leadership, interpersonal and communication

skills

TECHNICAL HIGHLIGHTS

Business Objects Crystal Reports Onsite Coordinator

5.1/6.x

Business Requirements Performance Tuning Problem Solving

Erwin ER Studio PL/SQL Programming

Skills Profile

Tools:

InformaticaPowerExchange8.1,InformaticaPowercenter8.1/8.0/7.1

.2/7.1.1/7.0,TOAD 8.0, 9.1, SQL loader, Tomcat3.x/4.x,

JWS2.0,Secure Shell, Kintana, SQL Navigator, Business

Objects XI R2/XI/6.5/6.0,Erwin 3.5.2,Visio.

Databases: Oracle 11g/10g/9i/8i, Tera data V2 R6.1, IBM DB2 UDB

8.0/7.0, Ms-Access, UNIX

Web: JDBC, JMS, Servlets, JSP, Swing, RMI, JNDI, EJB

Professional EXPERIENCE

Aug 2010 - present All State Insurance

Informatica Developer

ERRM uses a third party Data Modeling application called Igloo. The

data comes from the multiple sources i.e. from Allstate Data sources

and external sources. The goal of the project is to automate the data

input process. ALIR to help identify, track and reduce the number of

uninsured motorists.

Contribution:

> Involved in several projects like ERRM, ALIR, Property Inspection,

Sales Marketing Master address table in the ADW Data warehouse

> Architecture designed for the Master Address table with Business users

in requirements gathering by attending sessions with subject matter

experts for the understanding of the business.

> Successfully completed the Master Address table in the ADW Data

warehouse design.

> Build ETL mappings to pull data from Oracle, flat files to target

database

> Extensively used various active and passive transformations like

Filter Transformation, Router Transformation, Expression

Transformation, Source Qualifier Transformation, Joiner

Transformation, Lookup Transformation, Update Strategy Transformation,

Sequence Generator Transformation, Rank Transformation, and Aggregator

Transformation.

> Extensively used various Data Cleansing and Data Conversion functions

like LTRIM, RTRIM, ISNULL, ISDATE, TO_DATE, Decode, Substr, Instr and

IIF functions in Expression Transformation.

> Used Informatica Power center tool as ETL tool for constantly moving

the data from sources into staging area.

> Used Constraint Based loading & target load ordering to efficiently

load tables with PK-FK relation in the same mapping.

> Development of Informatica mappings, lookups, reusable components,

sessions, workflows etc.

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

loading.

> Monitored the jobs daily and involved in production support.

Technology Used: Oracle 11g, Informatica Power Center 8.6.1, ER Studio,

Crystal Reports, Data Modeling, Erwin, SQL, PL/SQL, TOAD, UNIX Shell

script, PUTTY.

Nov 2007 - Dec 2009 Citi Group Inc, Jacksonville, FL

Informatica Developer

Project Equinox will set Citi apart from all other banking competitors.

This is a Citigroup initiative, focused on bringing multiple lines of

business together, demonstrating our collective strength to consumers

and delivering value in a way which is unmatched in the industry today.

This program is not just about selling more products, its main

objective is to help customers save and plan for their future. This is

about Citi partnering with its customers to make their lives easier.

Customer Choice: With the program, certain U.S. customers (U.S. person

defined for tax purposes) can choose to receive either up to $500 now

or choose to receive up to $5,000 in 10 years - 10 years from the date

each eligible product is opened. Customers will be credited a certain

amount after enrolling in the Equinox program and opening eligible

accounts:

- Checking

- Mortgage

- Home Equity Line or Loan

- Credit Card

- Savings

Contribution:

> Involved in the SDLC of the application development. Working with the

Business users in requirements gathering by attending sessions with

subject matter experts for the understanding of the business.

> Analyze the source systems data and the current reports at the client

side to gather the requirements for the data warehouse data model.

> Performed dimensional modeling for OLAP data warehouse. Identified

transaction fact grains by studying ERDs of OLTP RDBMS. Designed multi

star schema to resolve issue of multiple grains in same schema.

Designed slowly changing dimensions. Prepared lineage design specs for

ETL.

> Worked as part of architect team to develop the complete star schema

and also snow flake schema for the phase 1 of data warehouse.

> Created the staging and star schema model for oracle 10g and Teradata.

Extensively worked on writing stored procedures and using of

Materialized views and used BTEQ querying language on TERADATA

database.

> As part of ETL process, loaded data from Flat files, Heterogeneous

Database tables and Excel spreadsheet into target Oracle database and

applied Business Logic on Transformation Mapping for inserting and

updating records when loaded.

> Created Stored Procedures and used them in the mappings by using them

as Connected and Unconnected Stored Procedure Transformations in the

mappings.

> Worked on developing all the mappings needed to load the staging area

of the DW.

> Designed ETL jobs to perform incremental load (with error handling)

using IBM Datastage 8.0 parallel jobs. Created workaround for

Datastage's defective handling of Type1 SCD. Monitored jobs, added

indexes to improve performance.

> Sole point-of-contact of an offshore team and a Client team. Clarified

daily issues between the two teams (proposal/budget/schedule

discussions, status/review meets, defect/requirement analysis).

> Helped in developing Informatica mappings, PL/SQL code to fix issues

in production Database.

> Performed Code reviews and provided tips for the ETL /DW team to

improve the performance issues.

Technology Used: Oracle 10g,Teradata,Informatica 7/8, ER Studio,

Crystal Reports, Erwin, Rational Clear Case, SQL Server 2005,DB2,Toad,

Tomcat 4.1.27, Websphere, Visio 2002, SQL, PL/SQL, Eclipse IDE.

Mar 2007 - Nov 2007 Agilent Technologies, Santa Clara, CA

Onsite Coordinator

Agilent HRIT is responsible to maintain all the HR and IT related

applications for the World wide client Agilent. Amongst those

applications two of the reporting applications are maintained by

Reporting Stream. The two applications are WEDB (Workforce Employee

Database) and Bluebook (Reporting application for Agilent).

WEDB: This is a workforce database which maintains all the HR and

Finance related data of all the Agilent and Non Agilent Employees'

data. The database is of Oracle 9.1.2. Loading of employee data is done

through a blend of JCL and UNIX Shell scripts and SQL / PL SQL and

through Informatica Jobs. It is a huge database which takes data from

different Vendors / Applications and provides data to different Vendors

/ Applications.

BLUEBOOK: This is one of the efficient and flexible reporting

applications in the modern era and which is implemented using Data

Warehousing concepts. This is a proprietary product of Agilent

Technologies Ltd. The data is pulled in to this application through the

DB which is maintained for this application into which the data is

loaded through a set of UNIX Shell scripts and PL / SQL procedures.

Role based security is provided to this application which is used by

all the top level employees of Agilent

Contribution:

> Analyzed the source data and business related to it so that the new

data sources can be seamlessly integrated to the existing data

warehouse.

> Finalized business requirements with business stakeholders / users.

> Primary responsible for deploying the changes from logical data model

to physical modeling.

> Analyzed and quantified the impact of projects on upstream /

downstream systems.

> Trained and mentored peers on standards, processes, methodologies,

ERWin.

> Performed extensive analysis of existing / new data to satisfy

business requirements.

> Performed reverse-engineering from Informatica codes, UNIX shell

scripts, Teradata BTEQ scripts, stored procedures, metadata to

understand the existing process, data and relationships.

> Planned and designed the Oracle schemas, designing database objects

like partitions, tables, views, indexes, sequences, constraints,

packages, procedures, functions and database triggers.

Technology Used: Oracle 9i/10g(rel1,rel2),Informatica 8.1,Teradata

V2R6.1,Teradata SQL Assistance 7.1,ER Studio, Erwin, Data Modeling,

SQL, PL/SQL, Eclipse IDE, Putty, SQL Navigator.

Oct 2005 - Mar 2007 Cisco Inc, San Jose, CA

Onsite Coordinator

eCustomer is a cross-functional enterprise-wide program. The purpose of

eCustomer is to provide a 360-degree view of the customer, linked

across functional silos, which enables business intelligence to be used

for strategic decision support. The 360-degree view is accomplished

through the creation and management of simplified processes and

policies that ensure a foundation of quality customer data. eCustomer

is also building a Customer Registry, which serves as a directory of

accurate customer data, allowing consistent customer information to be

shared across source systems.

The My New Clips tool is used in order to have Newsletter distributed

to the sales force. The IT modified version will deliver a customized e-

mail newsletter to all Cisco employees and contractors generated from

their self-managed user profiles. Using a personalized daily or weekly

e-mail, the tool will deliver important announcements from IT

executives, product releases, training notification, program updates

and more.

Contribution:

> Business user's interaction to gather all the functional requirements.

> Requirements gathering, analysis and design.

> Documentation of requirement and design.

> Data Modeling using ERWin.

> Deploying the changes from logical data model to physical modeling.

> Data Warehouse design.

> Design associated ETL Design and ETL changes.

> Troubleshooting high severity tickets which need architectural

changes.

> Planned and designed the Oracle schemas, designing database objects

like partitions, tables, views, indexes, sequences, constraints,

packages, procedures, functions and database triggers.

> Implemented and designed using UI1 standards migrate to UI2 standards.

> Supporting both CARAT, AM and HMT and Handling Cases.

> Ensure the quality of the deliverable to the client.

Technology Used: Informatica 7, Oracle 9i, Toad, Erwin, Data Modeling,

SQL, PL/SQL, Teradata V2R6.1, Teradata SQL Assistance 7.1, ER Studio,

Dollar U, Wincvs, secure shell, Kintana tool.

Feb 2005 - Sept 2005 Contract Management, San Jose, CA

Sr Software Programmer

The B2B Rosetta Net Service Contract Management is a project to broaden

the scope of the existing B2B range of applications used by Sonus

Software Inc. The project was developed with functional inputs from QA-

Offshore, primarily to handle the information about Service contracts

of products when they are moved from one customer location to another

location. Additionally, the application is also capable of handling the

label changes and retrieving the information about the contracts and

installed products.

Contribution:

> Understanding the entire functionality of the Contract mgmt.

> Analysis of the specifications provided by the clients. Development,

Implementation and enhancements of Entitlements and participated in

the design and development data access Layer.

> Prepared Solution Specification document, High Level Design document,

Process Flow document and Test Plan documents.

> Involved in coding and Coordinated with Up-stream / Down-stream

systems for completeness / correctness of data flow into and from Data

Hub system.

> Prepared Solution Specification document, High Level Design document,

Process Flow document and Test Plan documents.

> Data is stored in appropriate tables in organized way and provided

with data constraints and validation checks.

Technology Used: Informatica 7, Oracle 9i, Erwin, Data Modeling, SQL,

PL/SQL, Toad, Dollar U, Wincvs, secure shell, Kintana tool.

Dec 2003 - Feb 2005 Saw Pipes Delhi, INDIA

Sr Programmer

The HRMS module looks into the staffing needs of an organization,

employee recruitment and training, employee performance related issues,

personnel and management practices, and employee benefits and

compensation. The main objective of this module is to look after the

Human Resource activities of an organization. The activities comprise

Recruitment, Induction, Training, Appraisal, and Employee Separation.

Sub-modules in HRMS.

The Payroll processing is one of the main tasks of the HR-department.

It involves tracing the salary Structure of each employee, computing

pay, calculating leave encashment, computing overtime payments,

deduction of appropriate amounts for loans and advances generating new

accumulated totals, producing paychecks and automatically produces key

reports to document the payroll process.

Contribution:

> Primary responsible for Base development, Reports, Scheduled Reports

and Transaction-Authorization of Wings Enterprise.

> Primary responsible for analysis of specified transactions provided by

different clients.

> Troubleshooting high severity tickets which need architectural

changes.

> Bug-Fixing and incorporate the new changes for the modules.

> Development of the database scripts.

> Responsible to attend the weekly change meetings to schedule the

changes and to get proper approvals.

Technology Used: Core Java, Swings, C++, Mysql, Visio Studio, Eclipse

IDE, SQL Server.

Mar 2001 - Mar 2003 Shilpa Info Technologies, Hyderabad

Programmer

The Intellect Market team is now developing a smarter way to source and

manage software components. Intellect Market plans to launch a business-

to-business e-commerce web site (Component Planet) that acts as a

broker in sourcing, distributing and warehousing software components.

Users will locate and purchase software components from the

comprehensive library of thousands of available components.

Contribution:

> Primary responsible for credit card processing and validation

> Development, Implementation and enhancements of Entitlements and

participated in the design and development data access Layer

> Database management and JDBC connectivity

> Troubleshooting high severity tickets which need architectural changes

> Responsible to attend the weekly change meetings to schedule the

changes and to get proper approvals

Technology Used:: Oracle 9i, ER Studio, Erwin, Data Modeling, JSP,

Structs Framework, Java Script, Tomcat 4.1.27, Websphere, Visio 2002,

SQL, Servlets, PL/SQL, Eclipse IDE.

Academic Background

Masters Degree in Computer Applications 1996-2000 India

Contact this candidate