ETL developer

k

[pic]

Leela Madhavi Chanda

**** ***** **.

Dublin, OH 43016

Home: 614-***-****

Mobile: 614-***-****

E-mail: ********@*****.***

Certified Informatica Developer

EXPERIENCE

> 3+ years of experience in designing, developing and testing

application software developed in C/C++, Java, Visual Basic, and

Oracle.

> 10+ years of experience in development and design of ETL methodologies

for supporting data transformations and processing in a corporate wide

ETL solution using Informatica Power Center.

> Practical understanding of the Data Modeling (Dimensional &

Relational) concepts such as Star-Schema Modeling, Snowflake Modeling,

modeling of data at three levels: conceptual, logical and physical.

> Extensive experience in extraction, transformation, and loading of

data using Informatica from heterogeneous sources.

> Expertise in developing, testing, and implementing triggers, functions

and stored procedures using PL/SQL.

> Hands on experience in tuning mappings, identifying and resolving

performance bottlenecks in various levels like sources, targets,

mappings and sessions.

RELEVENT SKILLS

. ETL Tools: Informatica PowerCenter 6.2/7.1/8.1/8.6/9.0.1,

SAP BusinessObjects Data Services xi 3.2

. Languages: C, C++, Java, Visual Basic 6.0, PL/SQL

. Web Programming Tools: ASP, HTML, Apex 4.0

. Operating Systems: Windows XP/2000, AIX, Linux

. Testing Tools: Mercury 6.0, WinRunner 7.5, QuickTestPro 6.5, Test

Director 7.6

. Scripting Languages: VBScript, TSL, KSH Shell Scripting

. Data Modeling: Microsoft-Visio 2002, Erwin 4.0

. Databases: Oracle 10g, MS SQL Server 2008, MS Access 2000,

DB2, Teradata

. Version Control Management

Tools: Harvest, Serena

. Scheduling Tools BMC Control-M, Autosys

WORK EXPERIENCE

JPMorgan Chase & Co. Columbus, OH Aug 2014 - Dec 2014

JPMorgan Chase & Co. is a leading global financial services firm and one of

the largest banking institutions in the United States. Worked on loading

the Inventory Database for analysis and reporting. The project involved

consolidating the requests for inventory such as Domains, Clusters and VMs

(Virtual Machines) from different systems like myCompute, EURC and Prime.

Responsibilities:

. Building complex data flows with various Data Services Transformations

like Table Comparison, History preserve, Map Operation, and query.

. Implementing Change Data Capture for Slowly Changing Dimension Type 1 and

Type 2

. Tuning ETL Performance to improve the execution time.

Environment: SAP Business Objects Data Services xi 3.2, Oracle 11g, SQL

developer

Nationwide Children's Hospital Columbus, OH May 2012-May 2014

Nationwide Children's Hospital is one of the largest and most comprehensive

pediatric hospitals and research institutes in the United States. Worked

on several projects - Patient demographic history changes, Care

Coordination, Sports Med, Diagnostic Related Group, Hospital Account

Merges, Heart Center and also built user interfaces for users using Oracle

Apex.

Responsibilities:

. Created complex Jobs, Work Flows, Data Flows, and Scripts using various

Transforms (Integrator and Platform) using Data Services to successfully

load data from multiple sources into a desired target.

. Worked on Change Data Capture on both Source and Target level for Slowly

Changing Dimension Type 1, Type 2 and Type 3.

. Designed and developed ETL routines in BODS (Business Objects Data

Services), modified and created new Data Services jobs to meet project

requirements.

. Extensively worked on ETL Performance tuning and fixed several production

tickets.

. Built GUI interfaces using Apex for users to interact with the Data

warehouse data.

. Built Unix scripts to report on the Production jobs execution status

Environment: SAP Business Objects Data Services xi 3.2, Oracle 11g, SQL

Developer, AIX, and Oracle Apex 4.0

Wendy's International Corp. Dublin, OH Aug 2011- Feb 2012

Wendy's Company is a hamburger company. Worked on several projects -

Sales/Time Labor Database Move, Automation of Store Closures and Automation

of Menu Item Changes Sync.

Responsibilities:

. Developed Windows bat and vbs scripts to remote login to Window servers

and delete Merak Mail Accounts

. Implemented Slowly Changing Dimension (Type 1 and Type 2) to load tables.

. 24X7 ETL on-call support.

. Involved in Analysis, ETL design, testing, implementation and

documentation.

. Involved in ETL mappings enhancement, performance tuning and ETL objects

migrations.

Environment: Informatica Power Center 9.0, Oracle 10g, SQL Developer,

Microsoft SQL server 2008, Windows XP, Hyperion Essbase, Control-M, Magic,

Linux

National City Corporation (NCC)/PNC bank, Cleveland/Columbus, OH

Oct 2006- Jun 2011

Senior ETL Developer

NCC/PNC bank is a financial Institution. Worked on NCC projects - AML (Anti

Money Laundering) and RAM (Risk Assessment Matrix). After PNC bank acquired

NCC worked on various PNC projects - BIT (Broker and Insurance tracking),

Basel II application, NCC to PNC data conversion project, ORM (Operational

Risk Management) conversion project, Performance Reporting project, and ACH

IAT project.

Responsibilites:

. Performance tuned many ETL mappings and sessions which reduced production

cycle processing time.

. Implemented Slowly Changing Dimension (Type 1 and Type 2) to perform

database operations on ETL loads.

. Developed Disaster and Recovery (DR) plans and also performed DR testing.

. Participated in Informatica PowerCenter version upgrade from 7.1 to 8.6.

. Participated in NCC to PNC Conversion process, developed mappings and

scripts for merging NCC's data to PNC CIF system.

. Built automated SQL and spreadsheet reports for ETL loads run statistics.

. Involved in Analysis, ETL design, testing, implementation, documentation

and production support.

. Developed Stored Procedures and Functions in SQL and PL/SQL.

. Used Debugger for debugging the mappings.

. Extensively worked with team based environment with Informatica Version

Control enabled.

. Created Release notes and performed ETL code migrations using deployment

groups and also responsible for updating the documentation according to

the changes suggested by ETL lead.

. Extensively worked on scheduling and executing the test cycles during

System and UAT runs.

. Provided 24X7 on-call support for ETL applications.

Environment: Informatica Power Center 8.6, Oracle 10g, AIX, Harvest,

WinSQL, DB2, Microsoft SQL server 2005, Serena Changeman DS, KSH Shell

Scripting, Windows 2000, PL/SQL

Solucient LLC. Evanston, IL

May 2005 - Mar 2006

Informatica Developer

Solucient LLC is a healthcare business intelligence company. It provides

Healthcare providers an insight into their performance against their peers

and to identify opportunities to drive business growth and to help deliver

quality care. Worked in crmView project to develop a Data mart for

campaign management team.

Responsibilities:

. Developed and maintained Stored procedures, UNIX Korne scripts used in

the Pre & Post session commands, Stored procedure transformations and

Command tasks in development of Data Mart.

. Implemented Slowly Changing Dimension (type 2) to update dimension

tables.

. Created complex Informatica mappings to load the data mart and monitored

them. The mappings involved extensive use of transformations like

Aggregator, Filter, Router, Expression, Joiner, Update strategy and

Sequence generator.

Environment: Informatica Power Center 6.2, Oracle 9i, Sun OS, TOAD 7.0,

Erwin 4.1, Golden 32, PLEdit.

Atlanta Gas & Light Company, Atlanta, GA Dec 2003 -

Apr 2005

Informatica Developer

Atlanta Gas & Light Company is a natural gas distributor. Developed a Data

Warehouse to understand the consumption patterns and trends of its 2.2

million customers. This Data warehouse housed the entire customer, product,

billing, service, and sales information of its natural gas customers.

Information was in various locations and various environments.

Responsibilities:

. Created complex and robust mappings and mapplets using Mapping designer

and Mapplet designer to generate different mappings for different loads.

. Documented the entire process. Documentation included mapping document,

Unit testing document and System testing document among others.

. Designed complex mappings involving Target load order and Constraint

based loading

. Troubleshoot problems by checking Workflow, Sessions and Error Logs. Also

used Debugger for complex problem troubleshooting.

Environment: Informatica PowerCenter 6.2, Oracle 9i, DB2, Teradata, Erwin

3.5, Unix Korne Shell Scripts, Sun-Solaris 5.8, Ms SQL Server 2000, WinSQL,

and XML

Eli Lilly Tippecanoe Laboratories, Lafayette, IN Nov 2002- Oct

2003

Informatica Developer

Eli Lilly and Company is a global research-based pharmaceutical

corporation, which has Tippecanoe Laboratories in Lafayette, Indiana. Lilly

deployed an innovative data warehouse project, CSM to collect information

on many of the Sales and Marketing factors from disparate data sources.

Responsibilities:

. Analyzed specifications and identified source data need to be moved to

data warehouse. Participated in the Design team and user requirement

gathering meetings.

. Developed various Bulk load and Update procedures and processes using

SQL*Loader and PL/SQL in Oracle 9i Environment.

. Extensively worked in the Performance tuning of the programs, ETL

Procedures and processes.

Environment: Informatica Power Center 6.1, Oracle 9i(9.2.0.1), WinSQL Lite,

Erwin 3.5.2, and TOAD 7.1.

John Deere Health, Chicago, IL Feb 2002- Oct 2002

Informatica Developer

John Deere Health Care, INC. is a leading company in assisting independent

network providers by undertaking preventive care and care management

intervention programs to improve care and make it more cost effective. John

Deere Health, a division of John Deere and company provides various health

care plans. The data warehouse implemented primarily caters to the claims

analysis activities.

Responsibilities:

. Extensively involved in Creating, Enhancing and maintaining several

activities of data warehouse including Performance tuning, and modifying

Target tables as per requirement.

. Created and developed various critical mappings as per business

requirements to enhance business performance.

. Used Debugger to test the mapping performance and fixed the bugs.

. Involved in writing Procedures and Functions in SQL and PL/SQL.

Environment: Informatica Power Center 6.2, Oracle 9i, windows 2000, SQL*

Loader

REFERENCES

Provided upon request.

Contact this candidate