Venkateswara Rao

Experience Summary

• Working for HP Global Soft from Sep 2010 as Technology Consultant

• Worked for Cognizant Technology Solutions from March 2007 to August 2010 as Programmer Analyst in Chennai.

• Worked for Redingtonton Tech Solutions Bangalore from June 2005 to February 2007.

• 6 years of IT experience in Data Warehousing.

• Good exposure in the Data warehousing concepts.

• Design, develop and deployment of ETL Mappings in Informatica.

Education and Certifications

Title of the Degree with Branch College/University Year of Passing

Bachelor of Technology in Electronics and Communication Engineering.

Jawaharlal Nehru Technological University, Hyderabad.

2005.

Technical Skills

Hardware / Platforms Windows 98/XP/2000, UNIX

Technology Informatica, Business Objects

Programming Languages C, Core Java

Databases Oracle, SQL Server, Netezza

Version Control Systems MS Visual Source Safe (VSS).

Certifications

Certified in Introduction to Oracle 9i SQL.

Informatica Certified Developer

Visa Details

Not Available

Contact Details

Mobile No. 971**-*****

Mai id : gwcmd5@r.postjobfree.com, gwcmd5@r.postjobfree.com

Relevant Project Experience

Organization: HP Global Soft

Project #1

Client CVK CareMark, RtrDur

Operating System Windows XP, UNIX

Tools Informatica, Oracle, Teradata.

Team Size 3

Role Team Lead

Period June 2011

Project Description

Medication Therapy Management (MTM) involves identifying Medicare D members at risk for adverse medical or drug events.

The integration of MTM client contract, member enrolment and Gaps in Care activities and outcome data from CSS into EDW2 will allow the following capabilities:

• Enhance reporting capabilities for MTM.

• Integrate the Gaps in Care data with other Clinical Program Data sets especially Drug Savings Review

• Support internal and client overall and member level reporting

• Enhance evaluation of interventions

Role and Responsibilities

• Altering the code for the business and data model changes.

• Development of the Unit test cases and performing Unit testing.

• Defining of the dependencies among the jobs

• Validating the Informatica objects.

• Migrating the code to the project folder

Project #2

Client DSI

Operating System Windows XP,

Tools Informatica, Netezza.

Team Size 18

Role Team Lead

Period Sep 2010 – Apr 2011

Project Description

DAIICHI SANKYO Pharma EDW will create a replica of the Dendrite sales data mart onto the Netezza Platform within the DSI environment and to migrate the Business Objects Universes and reports currently running within the Dendrite Environment over to the DSI based Business Objects Servers. The Data mart consists of 4 layers where the source data from the files of different source systems will be moved to staging layer, later CRF layer and then IDS layer and finally into DWH layer

The data from the DWH layer will be used by the Extracts and the Reporting teams

Role and Responsibilities

• Coordinate the team and complete the deliverables in time

• Extensively worked on Informatica pushdown optimization

• Developing Mappings & prepared UT documents as well as Business Documents

• Migrating the code to diff Environments

• Deployment of the Altered Objects

• Preparation of the migration check list

Organization: Cognizant Technology Solutions

Project #3

Title HR Data Mart.

Client Hanover

Operating System Windows XP

Tools Informatica, SQL Server, DB2.

Team Size 8

Role Team Lead

Period Mar 2010 – Till date

Project Description

This project intends to deliver the next step of a much broader HR vision. Easy access to trustworthy information will drive the company’s success in managing HR activities, understanding Employee trends and behaviors, monitoring staff performance and measuring the HR service delivery effectiveness

Currently most of the operational reporting is done from the HRO staging database, but that lacks the ability to report historical data in most cases and also this does not the serve the purpose of building the monthly dashboards for the executive management, which results in huge time and resources to create those dashboards every month and in heavy dependency on the manual processes. The HRDW eliminates these pains of the HRIS group by providing a single stop for all their reporting needs.

All the data loads will be within the Hanover systems and no external data integration is required for this project.

Role and Responsibilities

• Analyzing the Business Document.

• Performing the Unit Testing.

• Creating the Source and Target definitions in Informatica.

• Providing support to the QA team.

• Monitoring the progress of the plan and guiding the team members.

Calculating the profitability for the new proposals.

Involved in preparation of resource management plans.

Project #4

Title CL Auto Details, Home Details, MVR Reporting.

Client Hanover

Operating System Windows XP

Tools Informatica, Oracle, QC, DB2.

Team Size 4

Role Team Member

Period Jul 2009 – Feb 2010.

Project Description

MVR project is to reconcile the data on MVRs raised by agents versus policies generated by the equivalent agents. This reconciliation will help Hanover to charge back the agents who have ordered excess MVRs’ without placing appropriate business with Hanover.

The goal of the Project is to build a MVR report layer which will source data from POS, PMS and Choice point. The report layer will provide details of the agents who have crossed the MVR order Threshold limit on a monthly basis. Based on these details appropriate charge backs will be generated by Hanover

MVR project will have the following layers

• Stage Layer

• Reporting Layer

The CL Auto Details project would enhance the EDW with CL Auto data including driver, vehicle, coverage, other interest etc. The data is sourced partially from various PMS segments and from CAPE tables. The data from the source systems are captured on a daily basis in the Reporting Data Staging Area (RDSA) when changes occur in the source system. Intra-day changes are not captured. The staged data in RDSA is then transformed and loaded into the EDW. Reporting on the CL Auto data is then provided using the Hyperion reporting tool

Role and Responsibilities

• Analyzing the design Spec and the requirements.

• Analyzing the impact of the alterations to the objects in the existing environment due to the new enhancement.

• Development of the new mappings and changing the existing objects which are impacted due to the CR.

• Creation and Execution of the test cases in the SIT and DEV environments to check for data consistency

Project #5

Title Unique Legal Entity Identifier.

Client Northern Trust,

Operating System Windows XP, UNIX

Tools Informatica, Oracle

Team Size 8

Role Team Member

Period Dec 2008 – May 2009

Project Description

The scope of the project is to identify unique Legal Entities from among the credit risk exposure-related entities (“CRE-RE”) associated with the credit risk exposures that are sourced into nCAAP, and to assign each of them a Unique Legal Entity Identifier (“ULEI”). ULEI process will generate a unique ID, cross-referenced to the source system natural key.

At present, the Bank does not have an automated way to identify unique legal entities (obligors/guarantors) across its product source systems to aggregate exposures. This necessitates building a mechanized process to establish a unique ID for each NT legal entity with a credit exposure (both existing and future) and the cross-reference to the native source system natural key in order to perform exposure aggregation.

Role and Responsibilities

• Development of new mappings

• Fine tuning the mappings for better performance

• Fine tuning the data base objects

• Development of the Informatica Data Quality jobs and embedding them in the Informatica Power Center

• Unit testing of the developed mappings in informatica

• SIT support for the phase 1 deliverables.

• Creation of the sample data as per NT standards for unit testing

• Involve in peer review of the objects which are to be moved to the next stage.

• Involved in preparing the necessary documents like mappings spec, code review check list, Requirement traceability matrix, TSD, UTP, and UTC.

Project #6

Title CHAMP Enhancements.

Client WaMu,

Operating System Windows XP, UNIX

Tools Informatica 8x, Oracle, Teradata, UNIX

Team Size 1

Role Team Member

Period Aug 2008 – Oct 2008

Project Description

This CHAMP System contains House Hold Data and the system getting data monthly from various source system files and loads the data into staging area (STG) and from the staging area the data getting loaded into Presentation area (PS). Finally the data from the presentation is used to generate the reports. All the informatica workflows are called and executed from command prompt environment. The shell scripts and informatica workflows are called from the command prompt.

Role and Responsibilities

• Understanding the requirement specifications and design the code.

• Performed analysis, and preparation of the impact analysis documents

• Development of the mappings which involved CLOB data field from JMS Queue.

• Involved in creating Mapping documents

Project #7

Title Vocals Enhancements.

Client Wamu,

Operating System Windows XP, UNIX

Tools Informatica 8.x, SQL Server, Teradata, UNIX

Team Size 2

Role Team Member

Period Feb 2008 – June 2008

Project Description

The system VOCALS data store is to enable Service Excellence (SE) group with capability to perform in-house analysis, reporting, and modeling on customer satisfaction on WaMu products and services. The Vocals follows three tier architecture and operational process. The first stage data from various sources will be gathered and make it available at a single point i.e. at SESTG. The second stage data from the SESTG is moved to SEADS where all the historical information will be stored as it is received from the first stage. In the third stage the data from the SEADS will be moved to SESDM where the data is stored in structured to make it simpler for the SE team.

Role and Responsibilities

• Understanding the requirement specifications and design the code.

• Developed the mappings using Informatica’s data integration technology to extract, transform, and load data.

• Performed analysis, coding, bug fixing and testing for the new enhancements.

• Tested for the business rule and prepared the test cases.

• Involved in creating Mapping documents.

Project #8

Title Mapping Documentation.

Client WaMu,

Operating System Windows XP, UNIX

Tools Informatica, Oracle, Teradata

Team Size 10

Role Team Member

Period Sep 2007 – Feb 2008

Project Description

The objective of this Project is to analyze the existing EDM applications and Document the mappings in S1130 format. The current version of the EDM Application pulls data from different sources. This information is updated in the Data Warehouse as well as the Data Mart to address the downstream reporting needs. The Source data is loaded to the Staging tables and loaded to the warehouse tables. The data movement is currently handled from Informatica mappings.

Role and Responsibilities

• Analyzed the existing EDM system.

• Analyzed the mappings in the EDM system.

• Documented the transformation logic in S1130 format.

• Involved in Peer review of the documents

Project #9

Title ESM Re-write Analysis.

Client WaMu

Operating System Windows XP, UNIX

Tools Informatica, Oracle, Teradata

Team Size 4

Role Team Member

Period Jul 2007 – Sep 2007

Project Description

The objective of this project is to focus on generating the S1130s by understanding the transformation logic, data flow and documenting the same. It provides new and improved solution for the ESM application based on the client’s requirements. Re-engineer the application with the guiding principles of reusability, scalability, and robustness and improve the Ease of Maintenance factor of the ESM application. Production & Maintenance Support of the existing ESM application

Role and Responsibilities

• Understood the existing ESM system

• Analyzed the mappings in the ESM system.

• Documented the transformation logic in S1130 format

Project #10

Title Anomaly Reporting.

Client Arbitron Inc,

Operating System Windows XP

Tools Informatica, Oracle, Web Focus

Team Size 8

Role Team Member

Period Feb 2007 – Jul 2007

Project Description

Arbitron is an international media and marketing research firm primarily serving radio, cable, advertising agencies, advertisers, outdoor and out-of-home media, through its Scarborough joint venture, broadcast television and print media. The main objective of this project is to load the Data Warehouse about the details regarding the spending power of the population. The source data will be provided as flat files and Oracle files. This data will be loaded to the staging area. From the staging area the data will be loaded to a data warehouse. This data warehouse is used for business analysis. The aim is to develop an application for getting reports for day to day operations by the Arbitron Encoding team using the Enterprise Data Warehouse. The application generates a report on a daily basis giving details of anomalies by media entity for a particular media day. Encoding Operations team uses these reports to determine various anomalies associated to various media entities and follow up with media station to rectify the anomalies.

Role and Responsibilities

• Mapping Business requirements to technical architecture

• Created Dimension Mappings like Rule dim, Rule Parameter dim, Hour dim, Engg dim, Time Zone dim, Media dim.

• Created Transaction and the fact mappings like PPM Monitor Fact, APL Clock Drift Fact, Mention Day Fact and Mention HR Fact.

• Creating mappings, reusable transformations in Mapping Designer

• Involved in preparing the Detail Design Document

• Involved in Unit Testing

Contact this candidate