Data Project

Vijaya Lakshmi

Email-Id : ****************@*****.***

Mobile : +91-929*******

Professional Profile

Having 4.5+years of experience in Data Warehousing and ETL concepts.

Extensive experience in Extraction,Transformation and Loading of data from

heterogeneous source systems like flat files, Oracle.

Hands on experience in mappings with varied transformation like Unconnected

and Connected lookups, Router, Aggregator, Joiner, Update Strategy and Re-

usable transformations.

Good knowledge on SQL.

Knowledge in UNIX.

Flexible and versatile to adopt any new environment and work on any

project.

Technical Skills

ETL Tools : Informatica Power Center 8.x/9.x

Databases : Oracle, SQL Server

Operating Systems : Windows 95,98,xp

DB Tools : TOAD,DB2

Organisation

Working at IBM Hyderabad From OCT 2013 to Till Date.

Worked at USINE TECHNOLOGIES Hyderabad From JAN 2010 To SEP 2013.

Educational Background

B-Tech(Information Technology) from JNTU University Hyderabad.

Professional Experience

ROYAL BANK OF SCOTLAND

Duration :Sep-2013 to Till Date

Environment : TOAD,TERDATA,ORACLE, Informatica Power Center 9.5.1

Role : ETL Developer

Description:

In 2011 RBS began a programme of work to implement a cross functional

Strategic Data Warehouse in the UK, using Informatica as the ETL tool,

Teradata as the underlying technology platform for the database, SAS as the

analytics toolset and an industry standard data model tailored for use in

RBS to structure the data (RBS-LDM).As part of the EDW initiative, the RBS

are looking to extend the initial work completed within the Foundation

Layer of the Strategic Data Warehouse and enhance the data model and data

utilizing a delivery partner to assist in accelerating delivery.The intent

of the programme is to provide an EDW using Foundation Layer which has data

elements from Core and Non Core systems,one of the projects in scope for

this work is Anti-Money Laundering. Anti-Money Laundering(AML) refers to a

number of internal processes and procedures to meet certain regulatory

obligations.AML includes transaction monitoring(TM),Transaction

screening(TS),Customer screening(CS) and Customer due diligence(CDD).The

AML activities are carried out by a number of systems and operational means

globally.Key performance indicators(KPIs) are required in order to manage

the AML activities and provide evidence internally and to regualtors that

the AML policies are providing an effective control environment.

Responsibilities:

Developed ETL mappings to extract and transform data from various sources

to meet requirements. Using Informatica PowerCenter created mappings and

mapplets to transform the data according to the business rules.

Understanding the Business requirements based on Functional specification

to design the ETL methodology in technical specifications.

Used Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer,

Sorter and Union to develop mappings in the Informatica Designer.

Created detailed Unit Test Document with all possible Test cases/Scripts.

Created Param Templates.

KFW SAP Fin,GERMANY

Duration : OCT-2013 to Aug-2014

Environment : DB2(DB Visulaizer), Informatica Power Center 9.5.1,

Role : ETL Developer

Description:

KFW is one of the Germany based reputed investment banks and the

main business is to offer loans to small/Medium/large scale companies.KFW

wants to analyze their business processes and performance via SAP Bank

Analyzer in the beginning. KFW initiated a program SAP Fin to get the data

to various data receiving systems like SAP Bank Analyzer/SAP BW and other

Data marts. Thus the main objective of this program is to extract data from

various source systems like Loans, Partners, Securities/Trade, Cash Flow

etc transform them to the format the end data receivers expect and provide

feed to them.

Responsibilities:

Responsible as team member in delivering solution to our customer in the

Banking sector.

Responsible for effective communication between the project team and the

Client, Provide day to day direction to the project team and regular

project status to the Client.

Translate customer requirements into formal requirements and design

documents, establish specific solutions and leading the efforts including

coding, testing and Peer reviews that culminate in client acceptance of the

results.

Improvement in productivity over the period of time for tasks.

Developed ETL mappings to extract and transform data from various sources

to meet requirements. Using Informatica PowerCenter created mappings and

mapplets to transform the data according to the business rules.

Understanding the Business requirements based on Functional specification

to design the ETL methodology in technical specifications.

Used Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer,

Sorter and Union to develop mappings in the Informatica Designer.

Created detailed Unit Test Document with all possible Test cases/Scripts.

.

GIANO REPORTING OPPORTUNITY, GE OIL & GAS

Duration : OCT-2011 to AUG-2013

Environment : SQL, PL/SQL, Informatica Power Center 8.6, Oracle11g

Role : ETL Developer

Project Details

The Main goal of this project is to have 2 Legal entities

inside GE Oil & Gas and it was located in Florence. Since the DWH queue was

refreshed according to the Italian time zone our users at different time

zones where not really happy to have their data not properly consolidated

or not up to date during their working hours. The DWH decided to create 3

different DWH areas: AMER, APAC and EMEA to schedule different data

refreshing times thank to different job queues.

AMER stands for Americas (north and south)

APAC stands for Australia, Pacific Area and China

EMEA stands for Europe, Middle East and Africa

Responsibilities:

Responsible for understanding Business Analysis and Requirements

Collection.

Preparation of mapping documents based on client requirement

specifications.

Preparation of ETL Design documents and Functional & Technical

specifications.

Design test cases to provide support to all systems and perform unit tests.

Invovled in preparing Metedata.

Used Debugger to test the mappings and fixed the bugs.

Used various transformations like Filter, Expression, Sequence Generator,

Update Strategy, Joiner, Stored Procedure, and Union to develop mappings

in the Informatica Designer.

Developed mapping parameters and variables to support SQL override.

Created mapplets to use them in different mappings.

Developed mappings to load into staging tables and then to Dimensions and

Facts.

worked with Source Analyzer,Transformation Designer, Mapping Designer and

Mapplet Designer.

Modified existing mappings for enhancements of new business requirements.

Created sessions, configured workflows to extract data from various

sources, transformed data, and loading into data warehouse.

Created mapping documents to outline data flow from sources to targets.

Extracted the data from the flat files and other RDBMS databases into

staging area and populated onto Data warehouse.

GE Money Bank, Sweden

Duration : March-2010 to April-2012

Team Size : 11

Environment : SQL, PL/SQL, Oracle11g, Informatica Power Center 8.6

Role : ETL Developer

Project Details:

The project includes development, maintenance and support of the Data Ware

House for GE Money Bank, Sweden.

Automating the reports generated on daily, weekly and monthly basis.

Developing and loading the datamarts required by business.

Controlling the access of the users to the various reports and modules.

Responsibilities:

Responsible for developing a data-mart for the early collection system of

the bank.

Responsible for upgrading the dialer system of the bank.

Upgrading the existing module for banking applications.

Developing various excel reports and maintaining the web based reports.

Implementing Change Requests as requested by the customer.

Resolving the Service Requests and Priority Requests as raised by the

business.

Providing production support for the jobs.

Preparing the weekly status report for reporting to the customer.

Process related activities for monitoring and minimizing the defects to be

followed by the team to match FourSoft standards of product and solution

delivery.Coordinate between different teams to ensure the completion of the

work.

Contact this candidate