Manager Data

Usha Madhavi Gorli Email :*******.*****@*****.***

ETL Developer Mobile :+91-998*******

Professional Experience

4+ Years of IT experience in ETL Development and SSRS

0.8 years of experience in development and maintenance of SQL Server Reporting Services

3 years of experience as ETL developer in Data Warehousing, Informatica 9.x, 10.2 Oracle and DB2

Experience in implementation of Data warehouse applications mainly Extraction, Transformation and Loading process using ETL tool Informatica Power Center 9.x

Knowledge in integration of various data sources like Oracle, MS Access, Flat files into Staging Area

Good Knowledge on Data Warehousing concepts

Created mappings using various transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Update Strategy and Lookupetc.

Created and Executed Workflows using Workflow Manager and Workflow Monitor

ETL code migrations from DEV, QA & PROD environments

Educational Qualification

B.Tech in Information Technology from Vignan’s Institute of Engineering for women, May 2012 with 74%

Intermediate in MPC from Narayana Junior College, APRIL 2008 with 88%

SSC from MNR High School, APRIL 2006 with 90%

Technical Skills

ETL Tools

Informatica Power Center 9.x, 10.2

Database

MS SQL Server2008/2012,Oracle9/10g, DB2

Shell Scripting

UNIX shell scripting

Tools

InformaticaDVO, Autosys

Reporting

SSRS SQL Reporting Services, Power BI

Professional Experience

Working with Infosys Limited as a Senior Systems Engineer from Oct-2014 to Till date

Project 4

Project Name : Informatica 10.2 Upgrade

Client : Bank Of America

Environment : Informatica, Autosys, Oracle DB, Netezza, Unix, Toad Data Point 4

Roles & Responsibilities

Upgrade the application components from 9.6 to 10.2

ETL COE to migrate the informatica 9.6 PROD code to informatica 10.2 DEV and create the relational connections.

Updating the system variables from 9.6 to 10.2

Fetching workflow details for Active jobs in Autosys and identify connection details

Creating relational connections in 10.2 DEV

Updating each workflow and sequence generator values

Testing to run the job from informatica and unix in DEV

Comparing the load time between DEV 9.6 and DEV 10.2

Checking randomly with some sample data in DEV

UAT Migration

UAT Testing and Validation

Project 3

Client : Advanced Micro Devices(AMD)

Environment : Windows 2008 server, SQL Server 2008 Reporting Services and SQL Server 2008

Roles & Responsibilities

Work directly with functional analysts and business users in understanding the information needs of the business and developing new BI functionalities or tools to meet these requirements

Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.

Development of reports using different SSRS Functionalities like sort prompts and cascading parameters, Multi Value Parameters.

Project 2

Name : Data Hub Migration from DB2 to Oracle

Client : Wells Fargo(Worked in Client Location)

Environment : Informatica 9.x, DB2, Oracle, Unix

Roles & Responsibilities

Analysing the design documents of the Autosys and Brokerage Datawarehouse Jobs

Creating the wrapper scripts using shell scripting in UNIX for the jobs to be migrated from DB2 to Oracle

Creating mappings for the jobs through informatica power center designer and creating workflows and sessions through workflow manager

Running the workflows using created wrapper scripts in unix

Checking the data migration, implementing debugging and performance tuning

Checking the data sync in DB2 and Oracle target tables using informaticaDVO(Data Validation Option) tool

Project 1

Name : NMAC Enhancements

Client : Nissan, USA

Environment : Informatica 9.x, DB2, Oracle

Roles and Responsibilities

Creating High Level Design, Unit Test Cases and Unit Test Results for each of the enhancement

Extracted data from flat files, OLTP tables and loaded into staging tables

Designed, developed and tested mapping as per ETL Specifications

Used Informatica designer to create mappings using different transformations like Lookup, Joiner, Aggregator, Expression, Filter, Router and Update Strategy etc.

Involved in ETL migrations from QA &PRODenvironments

Tested mappings to assure that data is loaded as per ETL Specifications

Personal Details

Full Name : Usha Madhavi Gorli

Father’s Name : G. VenkataRamana

Marital Status : Married

Nationality : Indian

Passport : H9475876

Languages Known : English, Telugu and Hindi

Permanent Address : D/O. VenkataRamana,D/No.12-68,

Gorlivanipalem village, Sabbavaram Mandal,

Visakhapatnam-531035, Andhra Pradesh,India

Phone No : +91-998*******

Declaration:

I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.

Place: Hyderabad (Usha Madhavi)

Contact this candidate