Srilakshmi Karnati Mobile: 732-***-**** Email:

aco0eb@r.postjobfree.com

ETL Consultant

Professional Synopsis

> Informatica and oracle certified professional with over 9 Years of IT

experience in the Analysis, Design, Development, Testing and

Implementing the ETL/Data warehouse system for Banking, Telecom and

Insurance Domains.

> Having in-depth work experience in Informatica Powercenter,

Informatica Power Exchange,PL/SQL,IBM Cognos

> Expertise in creating Real time Change Data Capture(CDC), MQ and Web

Service workflows using Informatica Power Exchange

> Having experience in Informatica Data Quality for data validation

rules

> Having experience of working with cloud based tool Salesforce

> Expertise in working with relational databases such as Oracle Exadata, Mainframe DB2,Microsoft SQL Server, Teradata

> Exposure to Hadoop Ecosystem including HDFS, MapReduce, HBase, Hive

and Pig,Oozie and Zookeeper

> Developed Models and Packages using Framework Manager and published to

Cognos Server.

> Developed reports and performance tuning (aggregation at the database,

indices, Query Optimization and Framework Manager Model improvement)

were done to improve the report output.

> Experience in developing Unix Shell Scripts for automation of ETL

process

> Knowledge in Planning, Designing, developing and deploying Data

warehouses / Data Marts with experience of both relational &

multidimensional database design using Data Modelling tool ERwin

(Physical and Logical data models).

> Experience in resolving on-going maintenance issues, bug fixes,

monitoring Informatica sessions as well as performance tuning of

mappings and sessions.

> Good in Performing the Migrations across all the environments (Dev,

QA, Prod)

> Proficient in understanding Functional Requirements and Design

documents.

> Working with business stake holders about impact of implementing the

changes in production environment

> Extensive expertise in designing, developing and executing test

scenarios and test cases.

> Conducted training sessions for the users and also prepared user

manuals for better understanding of the designed system for the users

> Having good experience as team lead and led the team with team size of

12-15.

> Excellent interpersonal and communication skills and having experience

in working with senior level managers, business people and developers

across multiple streams.

Education: Bachelor's in Computer Science Technology

Technical Skills

ETL Tools: Informatica Powercenter (9.x, 8.x), Power Exchange (9.x, 8.x),

Informatica Data

Quality, Pentaho, IBM WebSphere DataStage 8.1

BI Tools : Cognos 10 BI Series, Business Objects

Databases: Oracle Exadata, Mainframe IBM DB2, Microsoft SQL Server, Sybase,

Teradata

Oracle Tools: SQL Developer, SQL Plus, TOAD

Data Modeling Tool : Erwin

Version Controlling Tools: Clear Case, Harvest, Tortoise SubVersion

Scheduling Tools: ESP Scheduler, Control M, Autosys

Operating Systems: Windows, AIX-UNIX, Mainframe Z/os

Languages: SQL, PL/SQL, Core Java, C, UNIX Shell Scripting

Certifications

. Informatica S - Power Center 8 Mapping Design

. Informatica U-Power Center 8 Advanced Mapping design

. Oracle Database 11g Data Warehousing Essentials

. Sun Certified Java Programmer 1.6

Projects Handled:

LFGD Reporting &Analytics

Role : ETL Consultant

Client : Lincoln Financial Group

Duration : October 2014 to Present

Technology : Informatica Power centre 9.5,

Autosys, Microsoft SQL Server 2008/2012, Unix Shell Scripting,

HP Quality Centre, Tortoise Sub Version

Lincoln Financial Group is offering a diverse range of financial services

and solutions.With a strong focus on four core business areas - life

insurance, annuities, retirement plan services, and group protection. This

project is to create a LFGD Data Warehouse to support Data Management,

Sales Reporting, Compensation and Management reporting for LFD Sales.

Responsibilities:

. Developed reusable Informatica mapplets and worklets for audit balance

framework.

. Created ETL design and mapping flow for highly complex requirements.

. Done in depth data Analysis to see what kind of data present in source

and how they should to be loaded into the target.

. Involved in the Design, Development, Testing phases of the Data

warehouse.

. Prioritized Business requirements and translated those requirements

into functional technical requirements

. Involved in Design and Data Model development

. Created Informatica mappings for initial load and daily updates.

. Modified mappings as per the changed business requirements.

. Designed reusable transformations and shortcuts to share different

mappings.

. Developed, tested Store procedures, Functions and packages in PL/SQL

for Data ETL.

. Designed and developed Mapplets and worklets for reusability.

Extensively used ETL to load data from heterogeneous sources like flat

files, Oracle tables, XML and Teradata.

. Involved in fixing, testing of store procedures and functions, unit

and integration testing of Stored Procedures and the target data.

. Designed Audit Strategy to audit the data between Source System,

Target System and Other Parallel Reporting Systems.

. Involved in troubleshooting the load failure cases, including database

problems.

. Analysed the query performance and designed the load process

schedules.

. Involved in Production Deployment and Support.

. Creating UNIX scripts to run workflows and to check files availability

and sending generated files to different systems for processing

further.

. Converted the data mart from Logical design to Physical design,

defined data types, Constraints, Indexes, generated Schema in the

Database.

. Troubleshooting the problems by checking various logs.

. Involved in unit testing and Integration Testing.

. Created and performed testing strategy and test plans for any

changes/upgrade to Informatica mappings

BNYM - COD-CRS- CIW Warehouse

Role : ETL Lead

Client : Bank of New York Mellon

Duration : Jan 2013 to Sep 2014

Technology : Informatica power exchange, Informatica Power centre 9.0 &

9.5,

ESP scheduler, Oracle Exadata, Teradata,DB2, Unix

Scripting

Tools : Informatica Power Centre 9.0 & 9.5, Informatica power

exchange 9.5,

ESP Scheduler, Harvest

BNY Mellon is a leading investment management and investment services

company, uniquely focused to help clients manage and move their financial

assets and succeed in the rapidly changing global marketplace. In CIW we

process data for cash activity transactions related to assets, Foreign

exchange,Advisory fees, Asset management fees, Custody/administration

fees, Stock transfers

Research/analysis fees etc.The objective of this project is to create a new

data warehouse (CRS) for The Bank of New York Mellon Customers. The new

data warehouse CRS (Customer Reporting System) is developed by sourcing

data from two systems.

. Legacy Bank of New York data warehouse COD (Custody Operational Data

warehouse)

. Heritage Mellon custody and accounting systems CMS (Custody Management

System) and IAS (Institutional Accounting System)

CRS is built to store data necessary for generating drill-down reports

which provide cash & custody data. CRS is now renamed to CIW (Client

Information Warehouse). CIW will initially be populated by only legacy COD

system and will eventually be integrated by Mellon's custody & accounting

source systems.

Responsibilities:

. Creating High Level Design documents and Low Level Design documents

based on requirements

. Done in depth data Analysis to see what kind of data present in source

and how they should to be loaded into the target.

. Involved in Data modelling.

. Created mapping with various type of sources and targets (XML, Flat

file, MQ, CDC, VSAM, DB, Web service ).

. Creating CDC Registrations for Real time data.

. Creating PWX data maps to fetch data from the Mainframe Files.

. Monitor the Client Information Warehouse jobs to make sure SLAs are

met. Ensure that environment related issues are reported immediately,

and follow up to closure.

. Worked with Teradata 12 utilities like BTEQ, Fast Load, and Multi

Load.

. Creating UNIX scripts to run workflows and to maintain Real time

workflows Dependency.

. Developed mappings in Informatica to load the Real time data using PWX

source along with normal sources. Also developed mappings which

involve Mainframe file data extraction using PWX Data maps.

. Created ETL design and mapping flow for highly complex requirements.

. Developed List, cross tab, drill through, master-detail, chart and

complex reports which involved Multiple Prompts in Report Studio.

. Developed Models and Packages using Framework Manager and published to

Cognos Server.

. Developed reports and performance tuning (aggregation at the database,

indices, Query Optimization and Framework Manager Model improvement)

were done to improve the report output.

. Converted the data mart from Logical design to Physical design,

defined data types, Constraints, Indexes, generated Schema in the

Database.

. Troubleshooting the problems by checking various logs.

. Involved in unit testing and Integration Testing.

. Created and performed testing strategy and test plans for any

changes/upgrade to informatica mappings

. Involved in UAT Support.

. Involved in Peer reviews of LLDs, mappings, Sessions and PWX data

maps.

. Monitoring currently running jobs.

. Worked on performance tuning of queries in project.

. Worked in MQ's and channels setup for project.

. Effective Co-ordination with the team to deliver the task with in

schedule with Quality

. Co-Ordinating status meetings between offshore and onshore.

Mutual Funds Data Warehouse (Bank of New York Mellon)

Role : ETL Technical Lead

Client : Bank of New York Mellon

Duration : Oct 2011 to Dec 2012

Technology : Informatica power exchange, Informatica Power centre 8.6 &

9.0,

ESP scheduler, Oracle Exadata,Unix Scripting

Tools : Informatica Power Centre 8.6 & 9.0, Informatica power

exchange 9.0,

ESP Scheduler, Harvest

MFW (Mutual Funds Data Warehouse) is a Client File Interface application is

providing services for BNYM platinum clients. The application creates file

extracts that are delivered automatically to BNY Mellon internal and

external clients. Currently all data is extracted from the INFORM Custody

database (Sybase). The current information flows to INFORM thru OBR from

the core heritage BNY Custody systems: TAS, ASP, GSP and IMMS. The TAS/ASP

to GSP migration will affect the MFW clients because after migration MFW

client accounts will move from Inform database. To mitigate the client

impact the current information flow will be changed from INFORM to CIW.The

data will flow from GSP, IMMS, CDW, PSS, SMDB to CIW and CIW will load the

data into MFW database.

Responsibilities:

. Developing new mappings or making changes in existing mappings

according to new business requirements.

. Real time processing of data using Informatica Power exchange which

is essential for banking.

. Monitoring the daily warehouse load process and troubleshoot time

sensitive job failure issues

. Tuning the Code after verifying the real-time data test results

. Incidents fixing

. Handling adhoc loads

. Implemented Star Schema Grouping and Dimension Hierarchy in

Framework Manager Model.

. Developed List, cross tab, drill through, master-detail, chart and

complex reports which involved Multiple Prompts in Report Studio.

. Working Closely with IGS (Informatica Global Support) after hot

fixes are provided by informatica

. Carry out Impact Analysis for any new changes being pushed to

Production.

. Testing and reviewing the deliverables.

. Co-ordinating meetings between offshore and onshore.

. Effective Co-ordination with the team to deliver the task with in

schedule with Quality

BNYM Fund Accounting

Role : ETL Technical Leader

Client : Bank of New York Mellon

Duration : Mar 2011-Sep 2011

Technology/Tools : Informatica power exchange, Informatica Power centre

9.0,

ESP scheduler, Oracle Exadata, Unix Scripting, Harvest, BMC

Remedy User, Sales Force

BNY Mellon is a leading investment management and investment services

company, uniquely focused to help clients manage and move their financial

assets and succeed in the rapidly changing global marketplace. The

objectives of this project are,

. Create a new Subsystem named Fund Accounting System (FA) under Client

Information Warehouse(CIW) to load the data for Invest one reporting

system.

. Get the Source data from the SunGard Accounting system and load into CIW-

Fund Accounting systems with business logic for generating Invest one-

workbench reports.

Responsibilities:

. Developing new mappings or making changes in existing mappings

according to new business requirements.

. Real time processing of data using Informatica Power exchange which

is essential for banking.

. Monitoring the daily warehouse load process and troubleshoot time

sensitive job failure issues

. Designed OLAP Reports using most of the Report studio features

(Conditional Formatting/Page layout, Sections, page Breaks, sorting,

summaries, grouping, Drill Down, Drill Up).

. Tuning the Code after verifying the real-time data test results

. Incidents fixing

. Handling adhoc loads

. Working Closely with IGS (Informatica Global Support) after hot

fixes are provided by informatica

. Carry out Impact Analysis for any new changes being pushed to

Production.

. Testing and reviewing the deliverables.

. Co-ordinating meetings between offshore and onshore.

. Effective Co-ordination with the team to deliver the task with in

schedule with Quality

AXA Life Insurance BI

Role : ETL Developer

Client : AXA Life Insurance

Duration : Oct 2008-Feb 2011

Technology: Informatica 8.5,Oracle 9i

Tools : Informatica Power Centre 8.5.1, TOAD, Peregrine service

centre, Clear Case

AXA is a world leader in financial protection and wealth management. AXA

services over 50 million customers throughout the world. AXA occupies

leading positions in its main markets: life insurance, health insurance and

general insurance. Over here data is processed and Individual sales system

(ISS) was implemented for business with the objective to keep accurate

customer profiles,to enable better targeted and more flexible database for

performing marketing campaigns, To produce and manage renewal and mid term

changes and to introduce the sale of a new lower premium product to a

targeted customer base

Responsibilities:

. Doing production support activities

. Doing root cause analysis for Incidents raised

. Handling adhoc loads

. Developing new mappings or making changes in existing mappings

according to new business requirements.

. Carry out Impact Analysis for any new changes being pushed to

Production.

. Co-Ordinating UAT testing with stakeholders.

. Co-ordinating meetings between offshore and onshore.

British Telecom Global Services

Role : Developer

Client : British Telecom, UK

Duration : July 2006-Sep 2008

Technology: Informatica 8.5, Oracle 9i

Tools : Informatica Power Centre 8.5.1, TOAD, Visual Source Safe

BT Global Services helps multi-site organisations to master the

complexity of business communication. It serves corporate and government

customers worldwide, and wholesale customers outside the UK. Over here

all the data related to customer orders for different types of access

types and billing amounts are processed and loaded into target for

business users for analysis.

Responsibilities:

. Understanding existing business model and customer requirements.

. Developed mappings using informatica for data flows from Source to

Target.

. Used various transformations like the Joiner, filter, lookup,

expression, aggregator etc... In mappings to perform the ETL

process.

. Worked on mapping review, if design flaws found as a part of peer

testing.

. Created Effective Test Data and Unit Test cases to ensure

successful execution of data loading processes.

. Performed Informatica code migrations, testing, debugging and

documentation.

Contact this candidate