Data Project

Madhavi

Phone: 804-***-****

m *****@*****.***

Professional Summary:

• Seven years of experience in System Analysis, Design and Development in the fields of databases,

data warehouse and client server technologies.

• Seven years of extensive experience in using ETL (Extraction, Transformation, Loading) utilizing

Informatica 5.1/6.2/7.1.3/8.5.1 (Power Mart/Power Center).

• More than three years of experience using ERWIN as leading data modeling tool.

• One year of experience in using OLAP Tools such as Business Objects 4.1.4/5.1.4 (Designer, BO)

and Web Intelligence 2.6/2.7.

• Extensive experience in performance tuning of sources, mappings, targets and sessions.

• Extensive experience in the creation of ETL Mappings and Transformations using Informatica

PowerMart/ PowerCenter to move data from multiple sources into target.

• Involved in gathering and analyzing the business requirements, planning and design of the

technical design document, implementing solutions, trouble shooting, applying patches & fixes and

maintain an effective documentation, adhering to high quality standards during various phases of the

project lifecycle.

• Well versed with SDLC processes like change management, issue management, configuration

& object tracking, QA methodologies etc.

• Extensive experience in writing stored procedures (PL/SQL), triggers and packages using

Oracle/Sybase.

• Excellent communication and interpersonal skills. Worked closely with the client on various

occasions and played a key role while interacting with Functional Personnel/Users for effective issue

resolution.

• Proven abilities in managing increased responsibilities and deliver time critical projects on schedule.

Skills:

ETL Tools: INFORMATICA Power Center/Power Mart 5.1/6.1/6.2/7.1.3/8.5.1

Databases: Oracle 7.x/8i/9.x/10.x, SQL Server 6.5/7.0, MS Access 7.0/2000, Sybase

12.5/15, DB2 8.0

DB Query Tools Advance Query Tool 6.1.4, WinSQL 4.1, Embarcadero DBArtisian 8.1.2,

TOAD 7.6/8.0/ 9.0.1.8

Database Modeling:

Erwin 3.5.2/4.0/7.1, TOAD 7.6/8.0/ 9.0.1.8

Database Skills: Stored Procedures, Views, Database Triggers and Packages.

Operating Systems: Microsoft Windows 95/98/00/NT/XP, MS-DOS, Linux, Solaris 8 and UNIX

Languages: C, C++, SQL, PL / SQL, UNIX Shell Scripting, Java, COBOL, PERL

Internet Tools: Applets, Servlets, HTML, DHTML, JavaScript, JSP, XML, JDBC

OLAP/DSS Tools: BusinessObjects 5i, Supervisor, Designer, InfoView 4.0, BusinessMiner 4.2,

Broadcast Agent 5.0, WebIntelligence 2.6

Professional Recognition:

• In IBM, won the prestigious ‘ BRAVO’ award for stellar contribution to Elisa project delivery and

consistently exceeding client expectations.

Professional Experience:

Comcast, Mount Laurel, NJ Feb’11– Apr’ 11

ETL Developer

This is a data migration project that involved migrating sales & servicing data from legacy billing systems

to salesforce.com

Responsibilities:

• Written/modified complex SQLs, triggers, stored procedures, views as part of

development/testing.

• Interacted with business users as a part of requirement and analysis process.

• Migrated data for different modules using Unix scripts.

• Performance tuned SQL queries.

• Performed root cause analysis for production issues and fixed them.

• Prepared unit test cases, performed unit testing and supported system testing.

• Prepared data migration validation scripts.

Environment: TOAD 9.0.1.8, Putty 0.59, TortoiseSVN 1.6.15, Mercury Quality Center 9.0,

Oracle 9.2.0.1.0, SunOS 5.8, Perl 5.8.5

Wipro Technologies, UK & India Apr ’07 – Dec ‘10

Module Lead

Client: United Bank of Switzerland

UBS is a leading global wealth manager, top tier investment banking and securities firm, and one

of the largest global asset managers. In Switzerland, UBS is the market leader in retail and

commercial banking.

SRM (Settlement Risk Management), Hyderabad, India Dec ’08 – Dec ‘10

Project overview:

The Settlement Risk Management system has been built to support the calculation and reporting

of settlement risk related exposures, limit availabilities and excesses arising out of trading and

clearing activities.

Responsibilities:

• Involved in end to end SDLC process

• Extensively worked on Informatica objects.

• Designed and developed complete ETL flow for multiple modules.

• Migrated the code for few modules from Perl/Unix scripts to Informatica.

• Written/modified complex SQLs, triggers, stored procedures, views as part of

development/testing.

• Interacted heavily with business users as a part of requirement and analysis process.

• Performance tuned Informatica mappings, sessions, SQL queries.

• Involved in the deployment of code into various environments.

• Performed root cause analysis for production issues and fixed them.

• Created Initial Analysis Documents in the analysis phase.

• Prepared unit test cases, performed unit testing and supported system testing.

• Mentored team members throughout the project.

• Involved in estimation and planning exercises.

Environment: Informatica PowerCenter 8.5.1, TOAD 9.0.1.8, Putty 0.59, Clear Case, Mercury

Quality Center 9.0, Oracle 9.2.0.1.0, Embarcadero DBArtisian - 8.1.2, Sybase 15, SunOS 5.8,

Perl 5.8.5

DMSI CASH EQUITIES, London, UK Dec ’07 – Dec 08

Project overview:

DMSI (Data Management of Static Instruments) maintains Instrument reference data. It takes

instrument information from vendors like Reuters, Bloomberg, FTS, Exshare, Telekurs, Nikkei and

either create or enrich the instrument information as per requirements and deliver the data to

down streams like Master files, CUBS,ICMF Database etc. Source files are flat files and target db

is Oracle. Informatica PowerCenter is used as ETL tool.

Responsibilities:

• Worked on Perl scripts for feed capture process.

• Worked on complex logic for match and merge process for different feeds as per

requirements.

• Scheduled Informatica workflows using Informatica scheduler as well as Autosys.

• Written/modified shell/Perl scripts for monitoring.

• Written/modified complex SQLs, triggers, stored procedures, views as part of

development/testing.

• Worked on reconciliations of feeds.

• Installed Informatica server/clients.

• Worked on exception module for different feeds.

• Worked in design, development, testing phases of the projects.

• Mentored teammates as and when needed.

• Involved in all phases right from feed capture process till monitoring process.

Environment: Informatica PowerCenter 8.1.1, TOAD 9.0.1.8, Putty 0.59, Tortoise SVN 1.4.8,

Mercury Quality Center 9.0, Oracle 10.2.0.3, Red Hat Enterprise Linux AS release 3 (Taroon

Update 8), Perl 5.8.5

ETD (Exchange Traded Derivatives), London, UK Apr ’07 – Dec ’07

Project overview:

ETD Reconciliation toolset is designed to replace and develop the functionality of the existing

reconciliation tools to provide a single, strategic reconciliation platform with in UBS. Smart

stream product Transaction Lifecycle Management (TLM) is used for ETD Reconciliations. This

reconciliation data remains available to key strategic downstream systems (e.g. Mercury). ETL

Informatica is used to develop mappings to extract and transform feeds from settlement

systems/external exchanges and load into TLM.

Responsibilities:

• Worked on the various feeds by developing simple/complex mappings using various

transformations.

• Extensively worked on Informatica objects.

• Developed documentation for all the feeds as per standard templates.

• Created and modified PERL scripts as per requirements.

• Created and modified UNIX scripts as per requirements.

• Mentored other developers as and when needed.

• Interacted with business on regular basis.

• Extensively analyzed data and resolved issues by interacting with business.

• Fine tuned sources, targets, mappings and sessions.

Environment: Informatica PowerCenter/ PowerMart 6.2.2, Oracle 9i/10g, SQL, PL/SQL, TOAD 9.0.1.8,

SunOS 5.8, Linux 2.0, Transaction Lifecycle Management 2.1, Windows XP, MS Excel.

May ’06 – Nov ‘06

IBM, Hyderabad, India

Senior Informatica Developer/Technical Lead

Client: Elisa, Finland

Project overview:

Elisa is a leading telecom service provider in Finland. It is a leader in applying new technologies and

provides various services like ADSL, Internet, Home phones, ISDN and Data security service like firewall

software.

Terra is an application that extracts data from TELLUS, which is a Billing and CRM system and loads the

data in warehouse which provides Mobile/Landline billing and tracking information. The main objective of

Terra is to build reports to facilitate the end user to extract detail customer information, service usages,

billing information and account details. Informatica 7.1.3 is used as an ETL tool to build Terra and

Cognos ReportNet is used to generate Decision support reports.

Responsibilities:

• Used Informatica PowerCenter/PowerMart 7.1.3 for extraction, transformation and loading (ETL) of

data in the data warehouse.

• Analyzed and developed Technical Design documents.

• Extensively used Informatica client tools – Designer (Source Analyzer, Warehouse designer,

Mapping designer, Mapplet Designer, Transformation Developer), Workflow Manager and Workflow

Monitor.

• Created simple and complex mappings in PowerCenter Designer using Lookup, Aggregate,

Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Normalizer and Stored

Procedure transformations.

• Involved in the performance tuning of mappings, transformations, queries for better performance.

• Involved in debugging of Mapping.

• Used SQL, PL/SQL queries extensively to query tables from database.

• Involved in writing stored procedures, functions, cursors and triggers.

• Involved in creation/maintenance of indexes for better performance.

• Created UNIX scripts to schedule the workflows.

• Involved in unit tests and initial development, test & production loads.

• Used Erwin for data model analysis.

• Led a team of four developers, ensuring effective coordination and guided them to achieve high

levels of turn around time in problem resolution.

• Exhibited excellent relationship management skills while interacting with client/functional team.

Environment: Informatica PowerCenter/ PowerMart 7.1.3, Oracle 10g, SQL, PL/SQL, TOAD 7.6, Erwin

7.1, HP-UX 11.x, Windows NT, Lotus Notes 6, MS Excel, UNIX Shell Scripting.

Oct ’03 – Apr ’06

Vision Systems Group Inc, NJ, USA

ETL/Informatica Developer

Halliburton, Houston, TX Jun ’05 – Apr ’06

Project overview:

Halliburton is one of the world’s largest providers of products and services to the oil and gas industries.

Halliburton also plays a role in submitting the orders placed by the USA troops. The main objective of

Compliance Tracking Tool (CTT) is to create a separate data warehouse for these orders. Business rules

are applied to the data and this data is finally loaded to the d ata mart for the business users. Extract,

Transform and Load process is done using PL/SQL stored procedures, functions, packages etc.

Responsibilities:

• Migrated tables and data from MS Access to Oracle.

• Created and modified PERL scripts in the process of migration.

• Wrote SQL, PL/SQL functions, stored procedures, packages, database triggers for the Extract,

Transform and Load Process.

• Involved in Exception handling and cursor management in PL/SQL.

• Implemented and tuned the indexes.

• Performed unit testing

• Checked and maintained Referential Integrity according to business rules.

• Involved in the preparation of design documents according to the requirements.

• Handled pre-defined and user-defined exceptions.

• Involved in SQL performance tuning.

• Provided 24/7 Production Support.

• Single handedly managed end to end ETL process.

Environment: Oracle 8i/9i, SQL, PL/SQL, SQL*Plus, Advanced Query Tool 6.1.4, TOAD 8.0, Erwin 4.0,

Microsoft PowerPoint, MS Access 2000, Sun Unix 8, Windows NT, MS Excel, PERL 5.8.8

U.S. Cellular, Chicago, IL April’ 05 – Jun’ 05

Project overview:

The main goal of DRDM (Data Roaming Data Mart) project is to develop two distinctly different sets of

reports. One set is designed for the Roamer Accounting Group that uses it to validate transactions with

the data services ICV while the other set provides home and roam splits on existing MARS reports for

the Product Marketing Group. The Roamer Accounting reports will be sourced from new DRDM. ETL

Informatica is used to extract data from various sources and load in to DRDM. Business Objects is used

to extract reports according to the requirement.

Responsibilities:

Analyzed and developed Technical Design documents.

• Designed dimension and fact tables for DRDM (Data Roaming Data Mart).

• Involved in preparing detailed ETL design, Audit report documents and unit test plans for the

mappings.

• Extraction, Transformation and Load was performed using Informatica Power Center to build the

data mart.

• Created shortcuts for source, targets and transformations according to business logic.

• Developed Complex Mappings and handled slowly changing dimensions type 1, 2 and 3.

Developed mapplets, mappings and configured sessions.

Maintained and improved integrity by identifying and creating relations-ships between tables.

Environment: Informatica PowerCenter/ PowerMart 6.2, Oracle 9i, SQL, PL/SQL, SQL Server, TOAD

8.0, ER/Studio 6.6, HP-UX 11.x, AIX 5.0, Windows NT, Lotus Notes 5.0, MS Excel, UNIX Shell Scripting.

Verizon Data Services, Tampa, FL May’ 04 – Apr’ 05

Project overview:

VPF (Verizon Product Factory) is a Data warehouse which contains all the Product Data required

for COFEE Ordering System, which is Verizon’s biggest Ordering System for East. Data we

support to COFEE is for all the East States and this is divided into four Modules. ETL Informatica is

used to Extract data from various sources from these four modules, transform according to the

business logic and load the data into COFEE.

Responsibilities:

• Used Informatica PowerCenter/PowerMart 5.1/6.2 for extraction, transformation and loading

(ETL) of data in the data warehouse.

Extensively used ETL to load data from COBOL files, Sybase, SQL Server databases and Flat

files to DB2, Oracle databases.

Analyzed and developed Technical Design documents.

• Worked on different data sources such as Cobol files, Excel sheets, Oracle, Flat files, MS

Access etc

• Wrote SQL, PL/SQL, stored procedures & triggers for implementing business rules and

transformations.

• Extensively used different transformations during development of mappings and created

reusable transformations and mapplets and used them in mappings.

• Used Informatica PowerCenter Workflow manager to create sessions, batches and workflows to

run the logic embedded in the mappings.

• Fine tuned transformations and mappings for better performance.

• Involved in writing UNIX shell scripts for Informatica ETL tool to run and schedule the sessions.

• Involved in testing Referential Integrity for tables and analyzing the fallouts.

• Interacted with users for effective issue resolution.

• Provided 24/7 Production Support.

Environment: Informatica PowerCenter/ PowerMart 5.1/6.1/6.2, Oracle 8i/9i, SQL, PL/SQL, SQL*Plus,

Advanced Query Tool 6.1.4, TOAD, IBM DB2 8.0, Erwin 4.0, Microsoft PowerPoint, MS Access, Sun Unix

8, Windows NT, MS Excel, PL/SQL Developer 5.1

Thomson West, Eagan, MN Oct’ 03 – Apr’ 04

Project overview:

Thomson West is the foremost provider of integrated information solutions to the U.S. legal market and is

the leading provider of productivity solutions to this market. It serves more than 20 million information

users in the fields of law, tax, accounting, higher education, reference information, corporate training and

assessment, financial services, scientific research and healthcare. The project’s main objective is to

develop incremental new sales via increased Inside Sales call rates driven by productivity increased in

outbound and inbound calls per day from automated workflows.

Responsibilities:

• Used Informatica PowerCenter/PowerMart 5.1/6.2 for extraction, transformation and loading (ETL) of

data in the data warehouse.

Extensively used ETL to load data from DB2, SQL Server databases and Flat files to Siebel EIM

application database.

Developed Technical Design documents.

• Informatica Designer tools were used to design the source definition, target definition and

transformations to build the mappings.

• Wrote SQL, PL/SQL, stored procedures & triggers for implementing business rules and

transformations.

• Worked on different data sources such as Oracle, Flat files, MS Access etc

• Used Informatica PowerCenter Workflow manager to create sessions and workflows to run the logic

embedded in the mappings.

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

• Fine tuned Transformations and mappings for better performance and involved in debugging of

mapping.

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

• Created reports using BusinessObjects.

Environment: Informatica PowerCenter/ PowerMart 5.1/6.2, Oracle 8i/9i, SQL, PL/SQL, SQL*Plus, DB2

8.0, Erwin 4.0, Microsoft PowerPoint, MS Access, UNIX, Windows NT, WinSQL 4.1

Education:

• Master of Science in Computer Science, Western Kentucky University, KY, USA

• Bachelor of Engineering, Osmania University, India.

Contact this candidate