For employer details contact accvjn@r.postjobfree.com OR Call on: 410-344-

**** ***:1005.

Padmapriya

530-***-****

accvjn@r.postjobfree.com

SUMMARY:

. An IT Professional with 7+ Years of experience in Analysis, Design,

Development, Testing, Implementation, maintenance, and support of

Enterprise level Data Integration, Data Warehouse (EDW) Business

Intelligence (BI) solutions using Operational Data Store(ODS), Data

Warehouse (DW)/Data Mart (DM), ETL, OLAP, Client/Server, and Cloud

applications on Windows and Unix platforms

. Working experience with clients from Financial, Life Sciences (Pharma),

Insurance, Retail Industries.

. Worked extensively on Data Analysis, Data Validation, Data Cleansing, and

Data migration.

. Extensive ability to perform root cause analysis, performance monitoring

and application related issues.

. Proficent in using Informatica PowerCenter 6.2/7.1/8.1.1/8.6.1/9.1.0,

Informatica Power Exchange 7.1/8.1/9.1, Informatica Cloud, Oracle

11g/10g, MS SQL Server 2005/2008, SalesForce CRM Solution.

. Good knowledge in interacting with Informatica Data Explorer (IDE), and

Data Quality (IDQ).

. Proficient in using SQL, PL/SQL, Dynamic SQL, Stored

procedures/functions, Triggers and Packages, Complex Joins, Correlated

Sub-Queries, Aggregate functions, Analytic functions, Views, Materialized

Views, Indexing, Partitioning and Performance tuning the same using

explain plan.

. Hands on experience in identifying and resolving performance bottlenecks

at sources, targets, and performance tuning of SQL queries, ETL Code.

. Strong understanding of Ralph Kimball and Bill Inmon Data Warehousing

Methodologies.

. Strong understanding of the principles of DW using Fact Tables, Dimension

Tables, Star Schema, and Snowflake Schema Dimensional modeling.

. Experience with software development life cycle (SDLC) and project

management methodologies.

. Ability to handle projects in Visual C#, VB.NET, ASP.NET with MS SQL

Server back end.

. Able to work independently and in a team with good communication,

presentation and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools Informatica Power Center 6.2/7.1/8.1.1/8.6.1/9.1.0,

Informatica Data Quality (IDQ) 8.6.1/9.10, Informatica

Power Exchange 8.6.1, Informatica Power Connect,

Informatica Cloud, Informatica B2B, SQL Server Integration

Service (SSIS), Oracle Warehouse Builder

BI Tools OBIEE 10.1.3.4.1

Tools SQL-TOAD, SQL-Navigator, MS SQL Server Management Studio,

WinSQL, SQL*PLUS, SQL* Loader, Aginity Netezza Workbench,

IBM Rational Doors

Scheduling Tools Autosys

Database Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008, Netezza

5.0x, Teradata V2R6

Operating System Windows XP, UNIX

Languages SQL, PL/SQL, HTML, XML

PROFESSIONAL EXPERIENCE

Coach Inc., New York, NY Aug 2013 - Present

Sr. ETL Informatica Consultant

Coach is a leading American design house of modern luxury accessories.

Coach has established the signature style and distinctive identity for

their brand. The objective of this project is to support SalesForce CRM

Clienteling application related Operational Support processes. The

processes include bi-directional data flow from/to SalesForce.

Responsibilities:

. Designed and developed Informatica Power Center ETL to extract and/or

load data from heterogeneous systems (Salesforce, Oracle, SQL Server, and

Flatfiles).

. Created ETL high level and low level technical design documentation.

. Supported Informatica Cloud Data Synchronization, Data Replication tasks

of Customer Refresh, Employee, and Transactions processes.

. Created extracts of Customer / Employee data from Salesforce as per

business requirement.

. Developed a process for ETL load statistics which captures ETL processes

details, load success, reject counts and process statuses for audit

needs.

. Created processes that uses Informatica built-in and user defined

parameters and variables.

. Worked on Informatica PowerCenter - Source Analyzer, Target Designer,

Mapping Designer, Workflow Manager, Mapplets, and Reusable

Transformations

. Created mappings using transformations like Lookup, Salesforce Lookup,

Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure

and Sequence Generator.

. Worked on re-creating Informatica cloud tasks in Informatica PowerCenter

to support SalesForce CRM business needs and achieve cost benefits.

Environment: Informatica Power Center 9.1.0, Informatica Cloud, Flat

files, Oracle 11g, SQL server 2012, SQL, PL/SQL, Salesforce.com (SFDC),

Tidal, Rational

Symantec, Cupertino, CA Jul 2012 - Jul 2013

Sr. ETL Informatica Consultant

The company has evolved to become one of the world's largest software

companies. They provide security; storage and system management solutions

to help our customers - from consumers and small businesses to the largest

global organizations - secure and manage their information-driven world

against more risks. The main aim of this project is to build Dealer

Reporting (DR) Data Mart and deliver required dealer reports to the client.

Responsibilities:

. Designed and developed Informatica Power Center and Power Exchange to

extract, transform and load data from heterogeneous systems (Oracle,

Teradata, SQL Server) to staging and Data warehouse

. Involved in the ETL technical design discussions and ETL high level

technical design documentation

. Developed Mappings to load data from flat files through various data

cleansing and data validation process.

. Worked on Informatica PowerCenter - Source Analyzer, Target Designer,

Mapping Designer, Workflow Manager, Mapplets, and Reusable

Transformations

. Responsible to manage the Transformations like Lookup, Aggregator,

Expression, Router, Filter, Update Strategy, Stored procedure and

Sequence Generator.

. Created standard and reusable Informatica mappings/mapplets using Lookup,

Joiner, Rank, Source Qualifier, Sorter, Aggregator, and Router

transformations to extract, transform and load data mart.

. Strong experience in implementing CDC using Informatica Power Exchange

8.x/7.x

. Worked with QA team to coordinate the testing efforts of Datamart before

moving to UAT and Prod.

. Created the Repository manager, users, user groups and their access

profiles.

. Involved in the performance tuning of Informatica code, SQL, PL/SQL

scripts, Database using standard performance tunings steps for better

performance and thereby improving the load time.

. Created SQL, PL/SQL, stored procedures for implementing business rules

and transformations.

. Created and executed test cases/scripts and completed unit, integration

and system tests successfully.

. Deployment of Informatica Objects from Dev to QA,UAT, and Production

environments

. Supported daily nightly productions jobs on rotation basis

. Created JIL files and scheduled the tasks using Autosys.

Environment: Informatica Power Center 8.6.1/9.1.0, Informatica Power

Exchange 8.6.1, Informatica Cloud, Teradata V2R6, Flat files, Oracle

11g/10g, SQL server 2005, SQL, PL/SQL, Salesforce.com (SFDC), Autosys

UMB Financial Corporation, MO Dec 2011 - Jun 2012

Sr. Informatica Consultant

The company owns commercial banks, a brokerage company, a community

development corporation, a consulting company, a mutual fund servicing

company, and 16 other subsidiaries. This data warehouse is developed for

reporting solution that provides timely, accurate, consistent,

comprehensive, and relevant information at all times.

Responsibilities:

. Involved in gathering the Functional Requirements.

. Created dimensional model star schema using Kimball methodology.

. Involving in extracting the data from Oracle, and Flat files.

. Creating and Run Sessions using Workflow Manager and Monitoring using

Workflow Monitor.

. Defined Target Load Order Plan for loading data correctly into different

Target Tables.

. Defined mapping variables and parameters to capture load history, row

counts and to log errors of a session run.

. Developed wrapper workflow with command tasks to control execution of

workflows in loop.

. Implemented performance tuning techniques by identifying and resolving

the bottlenecks in source, target, transformations, mappings and sessions

to improve performance.

. Developed complex Informatica load maps and informatica error maps for

Extraction, Loading and Transformation (ETL) of data as per the business

requirements.

. Developed Reusable Mapplets and Reusable Transformations for standard

business units to be used in multiple mappings.

. Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data

cleansing, data matching, data conversion, exception handling, and

reporting and monitoring capabilities of IDQ 8.6.1.

. Experienced with Installation and maintenance of Power Center, Power

Exchange on Unix Platform

. Analyzed and created indexes and hints in database to improve query

performance.

. Prepared UNIX Shell Scripts and these shell scripts will be scheduled in

Autosys for automatic execution at the specific timings.

. Involved in System Testing, Regression Testing, Security Testing.

. Created Test Function matrix and preparation of Test Execution Report.

. Involved in preparation of reports Using OBIEE 10.1.3.4.1.

Environment: Informatica Power Center 8.6.1, Informatica Power Exchange

8.6.1, Informatica Data Quality 8.6.1 (IDQ), OBIEE 10.1.3.4.1, Oracle

11g/ 10g, TOAD, UNIX Shell Scripting, XML, MS Excel, Flat Files, Legacy

Systems, PL/SQL, Autosys, IBM Rational Doors, Windows XP

Liberty Mutual Insurance, NH Dec 2010 - Oct 2011

ETL Developer

Liberty Mutual Group which ranks 129th on the Fortune 500 list of U.S.

corporations is one of the largest multi-line insurers in the North

American property/casualty industry. The primary objective of this project

is to get data from different sources (DB2, Oracle, Flat files) and perform

the necessary operations on the data as per the user requirement and load

it on to the Oracle which will eventually be used by other applications

like PAL claims, Exprs, BoComp, Mira and others.

Responsibilities:

. Involved in Data modeling and design of data warehouse in star schema

methodology with confirmed and granular dimensions and FACT tables.

. Extracted data from sources like DB2, Oracle and Fixed width and

Delimited Flat files Transformed the data according the business

requirement and then Loaded into the Oracle Database

. Modified several of the existing mappings and created several new

mappings based on the user requirement.

. Maintained existing mappings by resolving performance issues.

. Imported and Created Source Definitions using Source Analyzer,

. Imported and Created Target Definitions using Warehouse Designer.

. Created Mappings using Mapping Designer to load the data from various

sources using different transformations like Aggregator, Expression,

Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router,

Sequence Generator, Source Qualifier, and Update Strategy

transformations.

. Created Mapping Parameters and Variables.

. Handled operating system tasks by generating Pre and Post-Session UNIX

Shell Scripts.

. Created and Scheduled Sessions and Batch Processes based on demand using

Informatica Server Manager.

. Involved in Optimizing the Performance by eliminating Target, Source,

Mapping, and Session bottlenecks.

. Used pmcmd command to schedule sessions and batches.

Environment: Informatica Power Center 8.6.1/8.1, Informatica Power

Exchange 8.1, Business Objects XIR2, HP UNIX, Windows NT, DB2, Oracle

10g, Erwin 4.0, SQL, PL/SQL, SQL * Loader.

Wyeth Pharmaceuticals, PA Feb 2010 - Nov 2010

Informatica Developer

This data warehouse captures and stored information regarding

salesforce activities like Calls/Samples/Presentations from the SFE system,

Factory Sales data, third party data related to Prescriptions (IMS Xponent

Plantrak Rx), NDC and DDD (Drug Distribution Data) for Competitor products.

This system consolidates and aggregates all this information to facilitate

deciling customers, generating target lists and variable pay for the sales

force. It also facilitates to view the fact data by different dimensions

like Time, Aligned, Unaligned, Product grouping, Market, Customer views.

Responsibilities:

. Involved in design, development of Pharma Sales and Marketing Data

Warehouse.

. Involved in technical requirement gathering with different source teams

and third party data provider teams.

. Involved in territory alignment enhancement project to align the sales

data to the new territory alignment hierarchy.

. Worked on the reporting ODS enhancement project to report historical data

from ODS.

. Responsible for migrating Informatica processes from 7.x to 8.x.

. Informatica ETL mapping processes to load Monthly and Weekly IMS and NDC

data.

. Designed and Developed Informatica mappings, creating sessions and

workflows for Data Loads.

. Tuned SQL queries and mappings for better performance. Used different

techniques table partitions and parallelism in Informatica. Used explain

plan, gather statistics, different types of indexing.

. Designed and Developed ETL logic for implementing CDC by tracking the

changes in critical fields required by the user using Informatica Power

Exchange 7.1

. Responsible for automating IMS and NDC sales data load processes. Used

extensive shells script techniques to automate the load and QA the sales

data.

. Developed PL/SQL procedures, Functions using Dynamic SQL, PL/SQL tables,

BULK Load features.

. Used Maestro Tivoli, Unix Cron schedulers to automate the load processes.

. Created Materialized views for aggregate tables from IMS and NDC fact

tables. The aggregate tables are created for different time measures to

ease the calculations at the time of reporting.

. Generated various ad-hoc reports as per the requirements.

. Developed Shell scripts for ETL automation and scheduled them in Tivoli

Maestro Scheduler including the capability to dynamically create

parameter files through scripts

. Responsible for creating and maintaining user documents, functional

documents, technical documents and mapping design documents

Environment: Informatica Power Center 7.1/8.1.1, Informatica Power

Exchange 7.1, HP UX 11i, Oracle 10g/9i, MS SQL Server 2000, Business

Object, Erwin 4.0, SQL, PL/SQL, TOAD 8.x/9.x

Eli Lilly and Company, IN Dec 2009 - Feb 2010

DW Developer

Project involved in Data Warehouse development for sales division,

which contains the sales data for pharmaceuticals and medical products of

the company. This Data Warehouse project will enable management to better

leverage information collected within current operational systems to help

in their decision making process. Project involved in development of

Informatica change requests in the Sales Force Tier System and Commercial

Rebate System to accommodate new business rules.

Responsibilities:

. Developed complex mappings and mapplets using transformations like

Connected and Unconnected Lookup, Router, Filter, Expression, Aggregator,

sorter, Joiner, sequence generator, Update Strategy.

. Created mappings to migrate data from Flat files, Oracle, to data

warehouse.

. Implemented slowly changing dimensions methodology to keep track of

historical data using Connected, Unconnected lookup transformations with

Update Strategy transformation.

. Created sessions, configured workflows to extract data from various

sources, transformed data, and loading into data warehouse.

. Involved in Performance tuning at source, target, mappings, sessions, and

system levels.

. Schedule and Monitor Workflows using Workflow Manager/monitor.

. Created partitions for parallel processing of data and used Debugger to

troubleshoot the mappings.

. Tested the data and data integrity among various sources and targets.

Associated with Production support team in various performances related

issues.

. Involved in Unit, Integration, system, and performance testing levels.

. Provide solutions for Test Problem Reports.

Environment: Informatica 6.x/7.1, Business Objects XIR2, Oracle 9i, SQL

Server 2005, Windows XP

UCO Bank, INDIA Feb 2008 - Aug 2009

Programmer Analyst

Loan Management: The project involves loan processing for housing

schemes. It maintains the relation between builder and Loan organization.

It makes easy for loan organization to process loan and makes payment

schedule and tracking of repayment of loan.

Responsibilities:

. Developed and reviewed the Test Plan and Test strategy documents

. Performed all aspects of verification, validation including functional,

structural, regression, load and system testing

. Executed Test cases manually and logged defects using Quality Center

. Involved in development of data validation, load process and error

control routines.

. Involved in DATA validation using SQL queries and back-end testing

. Tested a number of complex ETL mappings, mapplets and reusable

transformations for daily data loads

. Created UAT test cases and scenarios based on Use Cases, and made sure

those UAT test cases meets the business requirements

. Tested all the new and modified program units

. Performed in User Acceptance Testing (UAT), once product was ready to

release

Environment: Oracle 9i, Manual testing, QTP, UAT, SQL, PL/SQL, Windows

XP, NT

I Q Software Solutions, INDIA Apr 2006 - Jan 2008

Software Engineer

IQ Software Solutions is Development based company, providing web

services to different customers all over the world. IQ provides customized

web based applications to the end users.

Responsibilities:

. Involved in testing the quality of different web pages

. Defects were identified, provided documentation to the development team

for debugging

. Tested applications Performed Regression and Integration Testing

. Developed test scripts for manual/automatic tests

. Involved in document preparation and future releases

Environment: Manual Testing, HTML, XML, Windows XP, NT

Contact this candidate