Project History

MetLife **/**** - **/****

Insurance & Financial services

Client Consolidated View (Life), PDW & CMR Development

ETL Technical Lead/Architect

MetLife is in the process of building an Enterprise Data Warehouse for

Individual Business. The purpose of this project was to get the

information loaded into the Individual Business Data Warehouse. The

Individual Business Data Warehouse will integrate the information from

various data sources into one central repository providing the

organization a cross-enterprise consolidated view of all information and

serve as the primary source for the data marts.

. Responsible for designing the ETL Strategy & Architecture of the

Project

. Responsible for managing tasks and deadlines for onsite and offshore

ETL teams

. Point person on the ETL team for other teams such as Reporting,

Testing, QA and Project Management for updates on Project Status and

issues

. Involved the Sign off meetings with project managers

. Gathered the Functional Requirement Specifications from business users

. Broke up the work into task lists and provided estimates based on

simple, medium and complex methodology

. Designed CDC logic to extract latest changes

. Created high level & low-level ETL flow design and was involved in

the detailed technical design

. Involved in conducting reviews of Informatica Code, Unit Test Cases &

Results.

. Organized daily technical discussions with the Onsite team and

including the individual offshore work stream leads and set

expectations for offshore delivery

As an Admin:

. Performed Informatica code migrations between Dev,QA &Prod

. Performed all Informatica administration functions such as user access

accounts, roles, setting standards, etc.

. Performed all Informatica software upgrades as needed.

. Interface with the Database Administration Group to ensure proper

configuration of database objects in support of ETL code.

. Documented steps for QA & Prod deployments.

. Worked with DBAs and Data Architects in planning and implementing

appropriate data partitioning strategy for Enterprise Data Warehouse.

. Created Database Objects Tables, Sequences and indexes

As a Developer:

. Created mappings employing various transformations, filters, joiners,

lookup, SQL overrides etc. to load data from multiple databases into

Warehouses

. Created Sessions and Workflows to schedule these mappings

. Created Unit Test cases and Integration test cases

. Performed unit testing of Workflows from source to staging and from

staging to warehouse

. Performed reconciliation and evidence creation.

. Performed analysis and fix of QA defects

. Involved in Unit testing and UAT defect fixing.

. Involved in Informatica Power exchange to import Mainframe DB2

sources.

. Involved in Informatica Power exchange to test the data at mainframe

. Involved in sessions partitioning and mappings performance tuning

. Involved in the QA and production deployment

Environment: Informatica 8.6, DB2 UDB version 7, UNIX shell scripts,

Maestro scheduler, PowerExchange 8.6, Mercury Quality Center

MOTOROLA 01/2009 - 02/2009

Manufacturing & Telecommunications

Business Management System (BMS)

ETL Technical Lead /Architect

Motorola Inc. is a multinational, Fortune 100 telecommunications company

based in Schaumburg IL.

The purpose of the Enterprise Data Warehouse project is to capture

transactional data from all the global ERPs so that reporting is

consistent for all regions. The project implementation required a

thorough understanding of ERP systems, Data Warehousing concepts and

tools (ETL/Backend) along with the functional and business knowledge.

. Was responsible for managing tasks and deadlines for the ETL teams

both Onsite and Offshore.

. Performed requirement gathering and requirement analysis

. Interacted with the client on various forums to discuss the status of

the project

. Gave the inputs & shared the knowledge with other team members.

Environment: Informatica 8.1.1, Cognos,OBIEE

Genworth Financial 08/2008 - 12/2008

Finance & Insurance

Necho Implementation (Data automation)

ETL Technical Lead /Architect

The Approval Chain application had been designed to Generate Approval

Chain for Supervisors and to identify the association of an employee to a

particular chain of approvers. The Necho Expense application had been

designed to support capturing, approval and submission of business

related expenses.

. Performed high level and low level ETL design.

. Trained the customer on some of the Informatica related technologies

such as IDE, IDQ and Informatica PowerExchange

. Used IDE - Informatica Data Explorer to profile Customer & Claim

information for faster data analysis.

. Was responsible for the Configuration Management and Code Migration

between various environments using Informatica with Release Management

and Versioning.

. Coordinated with the Networking & Business Firewall teams in resolving

connectivity issues with the Source Systems.

. Implemented Unique Person Identifier - UPI logic to uniquely identify

people and be able to obtain a 360 degree view of every person in the

organization.

. Conducted the reviews of Informatica Code, Unit Test Cases and Results

with the Developers.

. Shared data warehousing concepts among the team members.

. Loaded data to Teradata by using Informatica external load

. Utilize the Teradata utilities (Mload, Fload and Tpump) and BTEQ

. Created reports.

Environment: Informatica 8.1.1, ANSI SQL, IDE, IDQ, Informatica

PowerExchange, Informatica Visio Data Stencil, Teradata, Crystal Reports

Genworth Financial 01/2008 - 07/2008

Finance & Insurance

General Ledger Data Warehouse Implementation

ETL Technical Lead /Architect

The Unified Oracle GL Process had been designed to generate the General

Ledger Records for different countries. At the end of the Unified Oracle

GL Process different files were generated based on a set of book country

value on the GL line. Each file includes header, detail, summary and

footer records. The final files will be generated by the Unified Oracle

GL Process and FTP'd to the specified location. The process involves

generating GL Files, FTP of the final Files, archiving of the final data

files and sending e-mail notification.

. Played the role of an offshore ETL Technical Lead/Architect on this

Project and was responsible for creating Technical Specs & Low Level

Design for Offshore development.

. Completely responsible for offshore delivery and the creation of WBS -

Work Breakdown Structure for the offshore team.

. Played the role of a Project coordinator between various work streams

within the project and created Unit Test and Integration Test Plans.

. Organized daily technical discussions with the Onsite team also

including the individual offshore work stream leads and set

expectations for offshore delivery.

. Provided Daily and Weekly Status Updates to the Project Manager and

the Engagement Manager.

. Responsible for integrating migrated code and performing Integration

Tests from Offshore and publishing test results to the onsite team.

. Created SQL scripts for balancing financial data between Teradata and

Netezza systems

. Created BTEQ scripts

. Loaded data to Teradata by using Informatica external load.

. Utilized the Teradata utilities (Mload, Fload and Tpump) and BTEQ.

Environment: Informatica 8.1, SQL Server, UNIX, ANSI SQL, Teradata,

Crystal Reports, Winscp3

Genworth Financial 10/2007 - 12/2007

Finance & Insurance

Reimbursement process automation

ETL Technical Lead

Genworth uses an externally hosted travel Expense Management system

(hosted by Cybershift Inc) to manage the process of Travel Expense

submission and approval by Genworth employees provided by NECHO. After

an expense report is approved, it will be available in the Necho extract

the following day.

As a Lead:

. Interacted with the client on various forums to discuss the status of

the project, clarify any queries regarding the functionality etc.

. Gave the inputs & shared the knowledge with other team members

As a Configuration Manager:

. Maintained the updated version of all the software used for the

project

. Updated all the project related documents in VSS, the project-tracking

tool

. Maintained the traceability of the project workflow using Trace DB

tool

As a Defect Prevention Representative:

. Followed-up whether the defects for each task had been logged on to

the defect tracking system

. Took out the defect metrics using the Defect Pareto methodology.

. Conducted Defect Prevention meeting on a periodic basis

. Implemented the action items and followed up on them

Environment : Informatica 8.1, Oracle 9i, smart FTP, forms &

Reports 6i, VSS,Crontab

Genworth Financial 03/2007 - 09/2007

Finance & Insurance

Europe Payroll automation

ETL Technical Lead

Europe payroll automation project was designed to replace the current

manual process.

As a Lead:

. Interacted with the client on various forums to discuss the status of

the project, clarify any queries regarding the functionality etc.

. Gave the inputs and shared the knowledge with other team members.

. Created and assigned task entries in EPMS (Web based timesheet

management) for other team members

. Discussed the project status with the managers on a weekly basis.

Environment : Informatica 8.1, Oracle 9i, Unix,Crontab

Genworth Financial 09/2006 - 02/2007

Finance & Insurance

Headcount & CWT automation

ETL Technical Developer

Genworth uses CWT (Carlson Wagonlit Travel) portal for the travel

information. Currently this portal is maintained manually where in data

is entered through front-end screens.

Genworth uses an externally hosted travel Expense Management system

(hosted by Cybershift Inc) to manage the process of Travel Expense

submission and approval for Genworth employee.

The goal of this project is to automate the entire head count module.

Headcount reporting is used by to track and report GNW employees. The UO

data controller will process the headcount interface. The interface will

enter statistical data to the GL. The data is not financial data. It

does not require a balanced transaction. This document details the

interface between the Oracle Human Resource and Unified Oracle General

Ledger.

As an analyst:

. Designed the whole Informatica workflow that is derived from four

PL/SQL packages that are running currently.

. Prepared the detailed design document for the whole project execution

As a Developer:

. Performed requirements gathering and requirements analysis

. Created PowerCenter Code

. Performed the testing

. Coded the migration to the production

. Conducted reviews

. Created Oracle Forms & Reports for business users

. Created and managed triggers in database

. Created Crystal reports according to the requirements

. Created UNIX shell scripts for automating the complex tasks

. Provided level 1 support and resolved the failures as per SLA

Environment : Informatica 8.1, Oracle 9i, Unix, Crystal Reports,

form 6i, Reports 6i

Guardian Life Insurance Company 01/2006 - 08/2006

Insurance & Healthcare

Agency Database Reporting

ETL Programmer

Through this initiative Guardian aimed to consolidate agency expense,

production and management data in a centralized database for reporting

and analysis. The project exploited the power of the data warehousing

tool Business Objects (BO). A set of New ETL Processes were created to

load the data from mainframe flat files into data warehouse tables and

Business Objects Universe will use this data for generating reports.

As an Admin & Developer:

. Performed the requirement Analysis and gained an understanding of the

existing system

. Interacted with the client on various forums to clarify any queries

regarding the functionality and appropriate access required

. Designed the database model

. Created Logical and Technical Documentation

. Created ETL Folder structure at the UNIX server & Client repository

set up

. Installed software like Oracle 9x, Informatica Power Center 8.1.1,

TOAD, PUTTY

. Extracted COBOL source definitions

. Validated user ID's for both FTP & UNIX in all 3 environments and

created appropriate folders

. FTP of source files into appropriate folders

. Developed mappings for source to staging database and staging to

target database

. Created Informatica sessions and workflows

. Created Archive script for the source files and analyzed scheduling

methods

. Performed report design and development (Business Objects 6.5)

. Modified reports as per the client requirements

As a Tester:

. Prepared the required ETL unit test cases

. Reviewed Unit test cases and Integration test cases of all the

assigned modules

. Performed detailed unit and integration testing.

. Performed data validation at report level with the database.

Environment: Informatica 8.1.0, Business Objects 6.1(b), Oracle 9i, UNIX

Guardian Life Insurance Company 01/2005 - 12/2005

Insurance & Healthcare

EIM Data warehouse Maintenance

ETL Admin & Programmer

. Provided level 1 support and resolved trouble tickets as per the SLA

. Monitored daily, weekly, monthly Informatica workflows in production

. Resolved workflows in case of failures

. Escalated to on-call person in case of unresolved errors using trouble

ticketing system

. Made appropriate changes to schedules when jobs are delayed

. Proactively sent advanced notifications to users in case of known

delays

. Maintained jobs used in scheduling

. Attended MOM on a daily basis

. Performed end of day and monthly reporting to the customer manager

. Performed upgrade testing of workflows from version 6.2.2 to 8.1.0

. Documented the workflows and created flow diagrams for the same

. Performed Informatica User Administration

. Performed code migration under development, test and prod environments

. Install and configure PowerCenter on Windows and UNIX

Environment : Informatica 8.1.1/6.1.2/5.1.2, Oracle 9i, UNIX,

Oracle, Teradata, DB2, Flat files

Guardian Life Insurance Company 09/2004 - 12/2004

Insurance & Healthcare

Long Term Care UCV mart

ETL Programmer

. Involved in creation of mapping from Source to Staging

. Involved in writing SQL-scripts from Staging to Data mart

. Created sessions and workflows with the appropriate connection

variables

. Interacted with onsite team members on various forums to discuss the

status of the project

Environment: Informatica 6.1.2, Oracle 9i, SQL scripts,UNIX

Guardian Life Insurance Company 02/2004 - 08/2004

Insurance

Unity BO Reporting

Developer

This project was to automate the process of generating Accounting,

Disability, Billing, Compliance, Inforce Maintenance, Management, Quality

Assurance and Reconciliation reports with Navisys as the source system.

. Manually re-stared the UNIX script.

. Created and modified UNIX scripts.

. Tested data for summary and detailed queries.

. Fix database errors while running PL/SQL scripts.

. Prepared PL/SQL scripts for data loading into warehouse and mart

. Created and modified BO reports

. Prepared complex SQL queries to use in BO freehand SQL

. Used Oracle ChangeDataCapture logic to load the data.

Environment: Business Objects 6.1(b), PL-SQL, UNIX, Oracle

Guardian Life Insurance Company 05/2003 - 01/2004

Insurance

Equity BO Enhancements

Team Member

This project dealt with the enhancement for the existing Equity Universe

requiring modifications to 60 objects and creation of 320 new objects.

For extraction of data the existing PL-SQL scripts were modified and new

scripts were created. Once the data was in the Equity data mart the

objects were created in the Equity Universe.

. Analyzed, created and tested reports

. Performed Logical and Technical Documentation

. Created the Universe database for end user reports by using Business

Objects

. Created classes and objects according to the business requirements and

generated the reports

. Created procedures

. Ran PLSQL scripts and debugged errors

. Fixed SQL errors

Environment : Business Objects 6.1(b), PL-SQL, Oracle

Kmart 11/2002 - 04/2003

Retail

Choice Point Precision Marketing (CPPM)

Software Trainee

The Promotion History data was loaded into the CCDM as part of the

semimonthly database build. The purpose and objective of the project was

to address two issues related to Scheduled Direct Mail Campaigns and Re-

mail Campaigns

. Performed analysis and requirements gathering

. Performed logical and technical documentation

Environment : Business Objects 6.1, Oracle 8i

Kmart 04/2002 - 10/2002

Retail

Project Management Office Reporting

Software Trainee

The Project Management Office (PMO) was responsible for reviewing and

reporting the health of the IT projects. The client had an in-house

project management system that records the project status. Every night

data is extracted from the source database to a reporting data mart.

Business Objects is used for generating the reports.

. Performed analysis and requirements gathering

. Produced logical and technical documentation

Environment : Business Objects 6.1, Oracle 8i

Education

B. Tech Electrical and Electronics from Dr.SGIET affiliated to JNT

University.

Mr. Devireddy has 8 years of Information Technology experience. The core

of this experience has been in the Data Warehousing and Application

Development arenas performing Data Modeling and Analysis, ETL Design and

Execution, Design, Development, and Implementation for numerous

applications and systems.

Professional Highlights

> Over 6 Years of Data warehousing experience specializing in RDBMS, ETL

Concepts, Strategy, Design and Architecting, Informatica Administration,

Development and Testing.

> Over 2 Years of experience in OLAP concepts and Report development.

> Expert in Informatica which includes components like PowerCenter,

PowerMart, PowerConnect, Designer, Workflow Manager, Workflow Monitor,

Repository Manager, Repository Server Administration Console,

PowerExchange CDC, Teradata, IDE - Informatica Data Explorer, IDQ -

Informatica Data Quality, Informatica Visio Data Stencil. Have had

extensive experience in working with various PowerCenter Transformations

using Designer Tool. Handled various Data Sources like DB2, Oracle, SQL

Server, MS Access, and MS Excel including MF COBOL EBCDIC Files, Flat

Files and XML Files.

> Proficient in dimensional modeling & 3rd normal form techniques.

> Experience in Unix Shell Scripting and ETL Process Automation using Shell

Programming and Informatica. Performance Tuning at both Database Level

and Informatica.

> Strong Logical and Analytical Reasoning Skills, Excellent Communication

with good Listening, Presentation and Intrapersonal Skills.

> Strong Team building and mentoring skills and excellent Team leadership

capability.

> Proficient in Oracle PL/SQL. Expert in creation of stored procedures and

custom SQL to define ETL processes

> Played various roles like ETL Architect, Configuration Manager, Defect

Prevention Representative, Software Quality Analyst, Technical Lead,

Project Lead, Team Lead and managerial roles for teams up to 10 people.

Project Highlights

> Received Pat on Back award at Metlife (Q3, 2009), for excellent

performance & commendable contribution on CCV-Life.

> Received Valuable contribution award at Genworth (Q3,2008), for

dedication, commitment, commendable analytical skills and successful

execution of the project.

> Received excellent performance award at Guardian, for the longest

period of customer support in resolving technical issues.

Certification

> Certified Informatica Powercenter version 8 Mapping designer.

RDBMS :

. Oracle 10g/9.x/8i/7.x, SQL Server 2000/2005, MS Access 7.0, DB2 UDB 7.0

ETL Tools :

. Informatica PowerCenter/Power Mart/PowerConnect /Power Exchange

8.6/8.1/7.x/6.2/5.1

OLAP :

. Business Objects (Designer, Reporter, Supervisor), Cognos Report Studio,

Crystal Reports 8.0/6.0/4.6

Operating Systems :

. MS-DOS, UNIX, Windows XP/ NT/2000/ME,

Data Modeling :

. Erwin 3.5.2/4.0

Languages/Utilities :

. PL/SQL, C, C++, Java

GUI Tools :

. Developer 2000 (Oracle Forms & Reports 6i, 9i)

Other Software :

. TOAD

. AQT

. Microsoft Visio 2000

. VSS

Industries:

. Finance, Insurance, Retail, Manufacturing, Health Care,

Telecommunications

Contact this candidate