Manager Data
Resume:
Vinni Rao
*********@*****.***
EXPERIENCE SUMMARY
> Over Six years of IT experience in Analysis, Design, Development,
Testing and Implementation of Data Warehousing projects using Oracle,
DB2, SQL Server, XML's and Flat Files.
> Experience in designing and creating data marts using ETL tools such
as Informatica PowerCenter 6.2/7.1/8.0/8.6.0, and Configuration
knowledge of Repository Administrator Console.
> Extensive experience in Data integration of various data sources
(Oracle, DB2, SQL Server, and Flat Files) using ETL tool Informatica
PowerCenter.
> Extensively used Informatica Client Tools Power Center Designer
carrying Source Analyzer, Warehouse/ Target Designer, Transformation
Developer, Mapping Designer, Mapplet Designer, Power Center Repository
Manager, Workflow Manager and Workflow Monitor.
> Experience in OLTP/OLAP System Study and Analysis in performing Data
Modeling using Dimensional Data Modeling, Star/Snowflake Schema
Modeling using Fact and Dimension Tables, and Physical and Logical
Data Modeling using Microsoft Visio.
> Hands on experience in writing Stored procedures (PL/SQL), Triggers
and Packages using Oracle.
> Experience in reporting tools like Cognos and Actuate.
> Designed and implemented multi-dimensional Schemas and Data Marts.
> Experience in scheduling the Informatica sessions.
> Experience in writing System Design Specifications (SDS) and System
Requirements Specifications (SRS) technical documents following the
guidelines of Software Development Life Cycle (SDLC) and storing them
in MS SharePoint.
> Experience in testing the applications and creating Test cases, Test
plans and Test scripts.
> Excellent Analytical, Problem Solving, Communication and Interpersonal
skills, with ability to interact with individuals at all levels from
IT and Business areas.
> Experience in Production Support in resolving issues using Session
Logs, and Workflow Logs and worked closely with Offshore Support Team.
BUSINESS AREAS OF EXPERTISE
Financial Industry, Annuities, Insurance, Medical and Banking sectors.
TECHNICAL SKILLS
Data Warehousing: Informatica PowerCenter
6.2/7.1/8.0/8.6.0
OLAP Tools: Cognos Impromptu 7.1, Cognos 8.4, Actuate
Reports 9.0
Operating Systems: Windows NT/00/03/XP, Unix
Databases: Oracle 9i/10g, DB2, MS-SQL Server 2000, MS
Access
Database Tools: PL/SQL Developer, SQL Plus, TOAD
Database Modeling Tools: MS Visio 2003
Testing Tools: Test Director/ HP
Quality Center
Tracking/ Version Manager Tools: Serena TeamTrack 6.6
Programming Languages: C, C++, Java, SQL, PL/SQL
Web Technologies: HTML, DHTML
MS-Suite: MS-Word, MS Excel, MS-Project, Microsoft Out Look
and Microsoft Access
EDUCATION
BS, Computer Science Engineering
PROFFESIONAL EXPERIENCE
SunAmerica Annuities and Life Assurance Company, CA
Sep' 09 - Present
Data Warehouse Developer
SunAmerica is The Retirement Specialist, which Develops and Markets
Variable Annuities that can provide investment growth potential and options
for guaranteed lifetime income that's protected from economy downturns and
market volatility. Some of the retirement plans it sells are 401(k), IRA,
Roth IRA, TSA etc for various products. I have been working as an ETL
Data Warehouse Developer for both Internal as well as external Broker
Dealer requirements projects in support for core business end-to-end
processing. Some of the major projects I worked on are:
1. Appless End to End New Business Processing
2. Navisys New Products
3. Agent and Broker Dealer Commissions Maintenance
Responsibilities
> As part of SDLC process, created Software Requirements Specifications
(SRS) Document and System Design Specifications (SDS) Document before
Development phase.
> Developed Logical and Physical data models that capture current and
future state data elements and data flows.
> Designing and Customizing data models for Data Warehouse supporting
data from multiple sources (Oracle, DB2, SQL Server, Flat Files) on
real time.
> Designed and developed Informatica mappings to Extract, Transform and
Load data into target tables.
> Worked with Memory cache for Static and Dynamic cache to enhance
throughput of sessions containing Rank, Lookup, Joiner, Filter,
Sorter and Aggregator transformations.
> Extensively worked on Informatica Designer and Workflow Manager.
> Extensively used almost all transformations of Informatica including
Lookups, Stored Procedures, Update Strategy and others.
> Used Workflow Manager to initiate Sessions. Created and scheduled
Worklets. Setup Workflow and Tasks to schedule and load data at
required frequency using Workflow Manager.
> Extensively worked on Performance Tuning of ETL Procedures and
processes.
> Extensively used PL/SQL programming in backend and front-end
functions, procedures and packages to implement business rules.
> Tested the data and data integrity among various sources and targets.
Associated with Production support team in various performances
related issues.
> Developed mappings for Type 1, Type 2 and Type 3 Slowly Changing
Dimension (SCD).
> Worked with Session Logs, Workflow Logs and Debugger for Error
Handling and Troubleshooting in all environments.
> Generated different Business reports using Cognos and Actuate reports.
> Generated reports for GL accounts using SAP.
> Reviewed QA Test Plans and provided technical support during QA and
Stage testing (UAT) and queried Serena TeamTrack to monitor issues
reported during testing phase.
Environments
Informatica Power Center 8.6.0, Windows 2003, IBM Mainframes DB2 7.0,
Oracle10g, PL/SQL developer 5.1, SAP, TOAD, Cognos 8.4, ACTUATE reports
9.0, Serena TeamTrack 6.6, MS Access 2000, SharePoint 2.0, MS Suite.
Country Financial, IL
Mar'08- Aug'09
Informatica Developer
Country Financial is an Insurance and Financial services company. It offers
a full range of Insurance, Investments, and other financial products. As an
Informatica Developer I worked in Insurance and Investments areas of
businesses.
On the Insurance sector, I worked for the Auto Insurance project to
generate Customer and Sales related data for Business Reporting.
On the Investments sector, I worked for the Mutual Funds Business Analysis
project for Funds Assessment and Performance by its Fund Class.
Responsibilities
> Involved in Data Analysis to extract useful data, finding patterns and
regularities from the sources and develop conclusions.
> Actively involved in Data Warehouse system design discussions for
various projects.
> Extensively used various transformations like Look Up, Update
Strategy, Joiner, Aggregator, Union and few other transformations.
> Performed Normalization for De-Normalized data sources.
> Extensively used Mapping Variables, Mapping Parameters, and Parameter
Files for capturing Delta loads.
> Created Fact and Dimension table mappings to load Fact and Dimension
tables.
> Developed Slowly Changing Dimension (SCD) Type1, Type2, and Type3
mappings.
> Extensively used SQL Override in various transformations.
> Extensively worked with Reusable Mappings (Mapplets), Reusable
Workflows (Worklets) and Reusable Transformations.
> Worked with the Informatica Scheduler for scheduling the Delta loads
and Master loads at different frequencies.
> Performance tuning at the mapping level, session level, source level,
and the target level.
> Worked with Session Logs, Informatica Debugger, and Performance Logs
for error handling the workflows and session failures.
> Performed Unit and System Integration Testing for various projects as
part of the SDLC process.
Environments
Informatica Power Center 8.0(Repository Manager, Designer, Workflow
Manager, and Workflow Monitor), Windows XP, Oracle 10g, TOAD, PL/SQL
Developer, SQL Plus, Cognos Impromptu 7.1, MS Suite.
M.D. Anderson Cancer Center, TX
Jul'07-Feb'08
Data Warehouse Developer
M.D. Anderson Cancer Center is one of the world's most respected centers
devoted exclusively to cancer patient's care, research, education and
prevention. As a Data Warehouse Developer I worked in developing and
integrating the patient's information based on disease condition,
diagnosis, procedures and multitude of demographic information.
Responsibilities
> Responsible for Development, Support and Maintenance of ETL Process
using Informatica PowerCenter.
> Performed Data Profiling and Analysis to extract Source data based on
the Business requirements.
> Designed Data Models using Visio during Designing phase for System
Design Specifications (SDS) Documentation.
> Performed Relational and Dimensional Data Modeling using Snowflake and
Star Schema and populating the business rules using mappings into the
Repository.
> Created Temporary and Backup tables in Oracle during Development
phase.
> Worked with different source systems like SQL Server, Oracle, Flat
files, DB2 and COBOL files to extract data into data warehouse.
> Created complex mappings using Update Strategy and Normalization
transformations.
> Developed mapping using Slowly Changing Dimensions (SCD) Type 1, Type
2 and Type 3.
> Used mapping parameter and variables in mappings.
> Called Shell and Perl Scripts from Informatica using command task in
workflow manager.
> Created Tasks and scheduled Worklets for Data Mart loads for Batch
Processing in Workflow Manager.
> Developed SQL, PL/SQL programs, Stored Procedures and Triggers for
implementing business rules and transformations.
> Created SQL Scripts to build and drop table indexes to compute the
periodic statistics and analyzed several tables for Performance
Tuning.
> Used Debugger to test the data flow and fix the errors before running
the sessions.
> Developed several SQL Test scripts and performed
Unit/System/Integration Testing.
> Improved the mapping performance using SQL Overrides.
> Developed Shell Scripts and Stored Procedures to run from the
Informatica pre and post sessions.
> Performed Data Integration validation during regular database
refreshes from Production to downstream environments.
Environments:
Informatica Power Center 8.0, Windows XP, Oracle 9i, SQL Server 2000, DB2
7.0, MS Access 2000, Unix, XML, SQL, PL/SQL, SQL*Loader, TOAD, MS Suite.
HSBC Bank, India Dec'05 -
May'07
Data Warehouse Developer
Headquartered in London, HSBC is one of the largest banking and financial
services organizations in the world. HSBC provides a comprehensive range of
financial services to around 100 million customers through Personal
Financial Services, Commercial Banking, Global Banking and Markets, and
Private Banking. As a Data Warehouse Developer, I worked in Private Banking
sector on the following focus projects:
1. Business Analysis Report on customer Savings and Current Account
2. Money Inflow and Premature Withdrawals in Fixed Deposits
Responsibilities
> Developed a System Design Document containing Transformation logic,
Mapping information, Session run times, Version history of mappings
with modifications.
> Worked in team to design the Dimensional Models.
> Developed Fact and Dimensions tables using Snowflake and Star Schema.
> Worked with Legacy systems, Oracle and Flat files to extract and load
data into the data warehouse in oracle.
> Used various Transformations in mappings based on the business
requirements to create Data Marts.
> Managed Sessions, Database Connections and scheduled Batch Processes
using Workflow manager.
> Developed several complex mappings, Mapplets and Reusable
Transformations in Informatica to facilitate different data loads.
> Worked extensively with transformations like Lookup, Update Strategy,
Normalizer, Union, Stored Procedure etc.
> Worked extensively with Slowly Changing Dimension (SCD) Type1, Type2
and Type3 for maintaining historical data.
> Fixed invalid Mappings and run-time errors using Session Logs and
Workflow Logs.
> Performed Unit Testing and Integration Testing on Informatica
Sessions, Batches and the Target Data Loads.
> Coordinated in moving project related changes from Development to
Testing Environment.
> Tuned the mappings for improving performance and optimization.
> Generated reports from Data Marts using Cognos.
Environments
Informatica PowerCenter 7.1, Windows NT, Cognos Impromptu 7.1, DB2, Oracle
9i, TOAD, MS Suite.
VisionVista Ltd., India
Sep'04- Nov'05
Data Warehouse Developer
The Marketing Management System deals with marketing computer devices and
computer peripherals. This system maintains Customer Information, Order
Entry, Remittance Entry and Activity Inquiries. The customer information
sub module is used for creating a profile of new customer and updating the
profile of an existing customer. The order entry sub module is used for
orders they placed and remittance entry sub module is used for the
remittances they made. The activity inquiry module is used to know the past
activities of the customer.
The project in which I worked on is Marketing Management System (MMS).
Responsibilities
> Designing and customizing data models for Data warehouse supporting
data from multiple sources on real time.
> Designed and developed Informatica mappings, enabling to Extract,
Transform and Load the data into target tables.
> Worked with Memory cache for improving throughput of sessions
containing Rank, Lookup, Joiner, Sorter and Aggregator
transformations.
> Extensively worked on Informatica Designer and Workflow Manager.
> Extensively used almost all of the transformations of Informatica
including Lookups, Stored Procedures, Update Strategy and others.
> Developed Slowly Changing Dimension (SCD) mappings.
> Developed Sessions, Worklets using Informatica Workflow Manager.
> Extensively worked in the Performance tuning of the Programs,
Procedures and Processes.
Environments
Informatica PowerCenter 6.2, Windows 2000, Oracle 9i, SQL Server, MS Suite
Contact this candidate