Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

P rofessional Summa ry

A senior Informatica Developer, professional with 6 years of diverse experience in analysis,

design, development and testing.

• Experience in Information Technology with a strong back ground in Analyzing,

Designing, Developing, Testing, and Implementing of Data Warehouse development

i n various domains such as Financial, Sales, Insurance, Telecom and Wireless

• Proficiency in utilizing ETL tool Informatica Power Center 9.1/8.x for developing the

Data warehouse loads with work experience focused in Data In tegration as per

client requirement

• Worked intensively with Informatica Power center Designer. Strong knowledge on

Source Analyzer, Warehouse designer, Transformation Developer, Mapplets

Designer and Mapping Designer

• Excellent knowledge and experience in data warehouse development life cycle,

requirement analysis, Repository management, implementation of Star, Snowflake

schemas, and slowly changing dimensions

• Extensively worked on Informatica Power Center Transformations such as Source

Q ualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update

Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator

a nd XML Source Qualifier

• Good experience on Informatica Power Centre/Power Mar t

• Extensively used Informatica Workflow manager and Workflow monitor for creating

and monitoring workflows, worklets and sessions

• Providing daily, weekly and monthly status reports to managers

• Experience in requirements gathering from Client and implement the same in

applications

• Expertise in all phases of the Software Development Life Cycle. Worked in 24*7

environment t o provide production support

• Identified the Facts and Dimensions using Erwin Data modeling tool to represent

t he Star Schema Data Marts

• Skills in creating Test Plan from Functional Specification, and Detailed Design

Documents

• Strong in database concepts with PL/SQL, Oracle and Teradata

Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

• Experience in writ ing Test plans, Test cases, Unit testing, System testing,

I n tegration testing and Functional testing

• Experience in UN IX Shell Scripting and Dollar Universe for scheduling the jobs

• Experience in the usage of Autosys scheduler in order to schedule workflows and

sessions

• Abili ty to work independently or within a team

• Worked on report analysis and development in OBIEE

• Hands on experience in performance tuning in Informatica and oracle

• Expertise in Developing Data stage jobs in Parallel Extender using different stages

l ike Transformer, aggregator, lookup, Source dataset, external fil ter, Row generator,

and column generator

• Good knowledge in interacting with Informatica Data Explorer (IDE), and

I nformatica Data Quality (IDQ)

• Experience in Onsite-Offshore model

• Exposure to full project life cycle development for implementation and integration

• Hands on experience in Production Support and Maintenance by resolving issues to

meet all Data Warehouse service Level agreements (SLAs)

• Excellent Team player and can work on both development and maintenance phases

of the project

Technical Skills:

Data Warehousing

Informatica Power Center 9.0/8.6.1/8.5/8.1.1/7.1.2/7.1.1/6.1/5.1.2, Power Connect for

M ainframe/SAP/PeopleSoft/MQSeries, Power Exchange,

I nformatica Power Mar t 6.2/5.1.2/5.1.1/5.0/4.7.2, SQL*Loader,

F lat Files (Fixed, CSV, Tilde Delimited, XML, COBOL, AS/400), IDQ

Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

Dimensional Data Modeling

Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and

Logical Data Modeling, Erwin 4.5/4.0/3.x

Database and related tools Oracle 10g/9i/8i/8/7.x, MS SQL Server 2000/7.0/6.5, Teradata,

Sybase ASE, PL/SQL, TOAD 8.5.1/7.5/6.2.

BI & Reporting Tools Business Objects and OBIEE

Languages SQL, PL/SQL, SQL*Plus, C, C++, VB 6.0/, Working knowledge of Unix Shell

Scripting

Web Technologies HTM L, XHTM L and XML

Operating Systems M icrosoft XP/NT/2000/98/95, UN IX, Sun Solaris 5

Education

Bachelor’s in Computer Science

Work Experience

P roject # 1

E TL/ Data Warehouse Developer

CP HA - Ottawa, ON

Aug 2011 to P resent

Description

Canadian Public Health Association is one of the largest nonprofit health plan in Canada,

serving 3.2 million members with in the count ry. I t is an integrated health delivery system

w hich provides entire scope of care including preventive care well-baby and prenatal care,

Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

immunizations, emergency care, screening diagnostics, hospital and medical services and

p harmacy services.

Responsibilities

• Extracted data from wide variety of data Sources like Legacy Systems, Flat files and

Relational Databases using Informatica Power Center 8.1/9.0

• Gathered user requirements and reporting requirements for a better understanding

of the business process and the current reporting system

• In teracted with Business Analysts and Data Modelers on Mapping documents and

Design processes for various Sources and Targets

• Worked on Facts and dimensions tables, slowly changing dimensions and

D imensional Modeling (Star Schema and Snow Flake Schema), Entity-Relationship

concept

• Designed/developed mappings using Source Qualifier, Lookup, Filter, Expression,

Router, Update Strategy, Rank, Sequence Generator etc

• Worked on Informatica Power Center tools-Designer (Source Analyzer, Data

warehousing designer, Mapping Designer, Mapplets & Transformations),Repository

M anager, Workflow Manager & Workflow Monitor

• Developing Workf lows, Worklets, sessions and tasks to effectively manage the Load

and also create and control workflows, tasks and sessions

• Worked on Query Optimization and ETL performance tuning for improving the

performance of the data warehouse

• Used Workf low Manager for creating, validating, testing and running the sequential

and concurrent sessions and scheduling them to run at specified t ime and as well to

read data from different sources and wri te it to target databases

• Involved in doing Unit Testing, In tegration Testing and System Testing

• Used IDQ to identify inconsistencies of data and fur ther cleansing

• Provided production support for multiple projects

Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

• Created Workf low and Tasks to schedule the loads at required frequency using

Workflow Manager

• Created Standardization, cleansing and Parsing routines in IDQ

• Used Join, Rule and column Profiling

• Extensively developed Oracle PL/SQL stored procedures using TOAD to implement

d ifferent business logics and perform backend testing (Oracle 9i) to verify the

t ransactions and business logic

• Created and tested UN IX shell scripts to automate SQL scripts and stored

p rocedures

Environment: I nformatica 9.1, IDQ Erwin 4.0, UN IX, MVS, SQL, PL/SQL, Oracle 9i/10g,

SQL Server 2000, Tivoli.

P roject # 2

Sr. I nformatica Developer

Best Buy, Vancouver, BC

Sep 2010 to July 2011

Description

Best Buy was the second largest North American Electronics Retailer. The company

operates 1100 department stores in all over North America. I t also operates catalog sales

merchant offices nationwide in many small markets. Certain stores are located in power

centers and can be considered big-box stores. I t has streamlined its catalog and distribution

w hile undergoing renovation improvements at store level. Project was executed in phases

building up from extraction, computation logic, dimension models and populating data

using Informatica.

Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

Responsibilities

• Extensively worked with the data modelers to implement logical and physical data

modeling to create an enterprise level data warehousing

• Extensively worked on creating Facts and Dimensions tables

• Designed and Developed Oracle PL/SQL Procedures and UN IX Shell Scripts for

Data Import/Export and Data Conversions

• Created and Modified T-SQL stored procedures for data retrieval from MS SQL

SERVER database

• Worked with pre and post sessions, and extracted data from Transaction System into

S taging Area

• Extensively used Informatica Power Center 9.1 to extract data from various sources

and load in to staging database

• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer,

T ransformation developer, Mapplet Designer, Mapping Designer, Repository

manager, Workflow Manager, Workflow Monitor, Repository server and Informatica

server to load data from f lat files, legacy data

• Extensively used t ransformations such as Source Qualifier, Aggregator, Expression,

Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored

P rocedure

• Designed the mappings between sources (external files and databases) to operational

s taging targets

• Experience in the usage of Autosys scheduler in order to schedule workflows

and to run packages

• Involved in data cleansing, mapping t ransformations and loading activities

• Developed Informatica mappings and Mapplets and also tuned them for Optimum

performance, Dependencies and Batch Design

• Implemented Slowly Changing Dimension methodology for H istorical data

• Extensively worked on unit testing and implemented on t ransformations, mappings

Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

• Involved in production support and stabilizations

• Worked on M igration of Data warehouse in between different versions

• Coordinated between Development, QA and production migration teams

• Extensively involved in documentation of the project

• Generated reports using Business Objects for analysis

Environment : Informatica Power Center 9.1, Teradata V2R5/V2R6, Oracle 11g, PL/SQL,

H yperion, SQL SERVER 2005, UN IX Shell scripting, Business Objects XI R3, ESP

Schedule, TOAD, SQL Assistant, Windows 7.

P roject # 3

E TL/ Data Warehouse Developer

Fai r mount, Toronto, ON

Oct 2008 to August 2010

Description

Fairmount is one of the world's largest hotel and leisure companies, with a system that

p rocesses over $8 billion in bookings per year including more than $1 billion in online

t ransactions. To support such a vast system they embarked onto this prestigious project.

T he main aim of the project was to replace its old and conventional Star link system with

Valhalla, which in i tself comprises of several engines called Booking, Promo, Rates, SPG,

E DG, Inventory and Prop

Responsibilities

• Worked closely with Business Analysis team, discussed and gathered the

requirements

Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

• Worked on designing and coding the complete ETL process using Informatica for

various t ransactions and loading data from different sources like Flat Files and

Relational Database

• Involved in End-to-End development from OLTP systems to creation of Data Marts

• Handled 20 Terabytes of data warehouse database

• Understood the business point of view to implement coding using Informatica power

center components

• Created and used reusable Mapplets and t ransformations using Informatica Power

Center

• Executed several sessions and created batches to automate the loading process

• Extensively used Informatica scheduler to schedule Informatica workflows

• Exclusively worked on the t ransformations like Aggregator- to get monthly,

quarterly, Yearly claim aggregations, Connected & unconnected lookups - get the

claim_ids from other tables and also used SQL override to fil ter the data

• Involved in Performance tuning of different tables like FIRST_RESERVATIONS

t able which has data around 1 TB by creating parti tions and using stored procedures

• Worked on f lat files as sources, targets and lookups

• Used PMCMD to start and abort sessions and tasks. Also used I NFACMD to t rack

t he status of the applications and also automate the service notification emails

• Implemented various optimization techniques in Aggregator, Lookup, and Joiner

t ransformation

• Developed mappings/sessions using Informatica Power Center 8.6 / 7.1 for data

loading

• Developed mapping to load the data in slowly changing dimension (SCD)

• Used Informatica parameter files to fil ter the daily data from the source system

• Involved in Data Quality Analysis to determine the cleansing requirements

• Used various debugging techniques and Informatica debugger tool to debug the

mappings

• Creating Test cases for Unit Test, System Integration Test and UAT to check the

data quality

Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

• Created Oracle Stored Procedure to implement complex business logic for better

performance

• Involved in all phases of SDLC from requirement, design, development, testing,

P roduction and support for production environment

• Created indexes on the tables for faster retrieval of the data to enhance database

performance

• Involved in the End user t raining and worked in testing and production support

environments

• Created Materialized view for summary data to improve the query performance

• Worked along with the DBA to resolve performance and tuning issues

• Designed Sequential Workflow using Workf low Manager, Workf low Monitor for the

w hole process

• Experience in the usage of Autosys scheduler in order to schedule workflows

and sessions

• Responsible for loading data into warehouse from different sources using Oracle

loader to load millions of records and used Import/Export utili ty to load small tables

• Responsible for scheduling the workflow based on the nightly load

• Supported Oracle 10g databases running mission critical 24*7 systems

Environment: I nformatica Power Center 8.1/7.1.1, Oracle 9i & 10g, PL/SQL, Golden gate,

M icro strategy 7i, Mainframe DB2, MS Visio, ERWIN Data Modeling tool, TOAD, Windows

2000, UN IX.

P roject#4

Senior ET L Developer

I GATE Solutions, H yderabad

Feb 2007 to Sep 2008

Description

Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

The client 3i is a world-leading financial services company, advising clients in all aspects of

f inance, around the world, around the clock. Credit Suisse operates in three global divisions

- P rivate Banking, Investment Banking and Asset Management. Post Trade technology

deals with the securities market. The project is to report on the fee accrued in the t rading

t ransactions of Credit-Suisse across the markets worldwide.

Responsibilities

• Involved in various phases of SDLC from requirement gathering, analysis,

design, development and testing to production

• Gathered requirements from Business Users

• Extracted Erwin physical models into repository manager using Informatica

• Prepared technical specifications for the development of Informatica (ETL) mappings

to load data into various target tables and defining ETL standards

• Developed complex mappings using Lookups connected and unconnected, Rank,

Sorter, Joiner, Aggregator, Filter, Router t ransformations to t ransform the data as

per the target requirements

• Analyzed business requirements and worked closely with various application teams

and business teams to develop ETL procedures that are consistent across all

application and systems

• Documentation of technical specification, business requirements, functional

specifications for the development of Informatica mappings to load data into various

t ables and defining ETL standards

• Worked on Informatica Power Center 7.1.3 tool - Source Analyzer, warehouse

designer, Mapping Designer & Mapplets, and Transformations

• Created and configured Workflows, Worklets, and Sessions to t ransport the data to

t arget using Informatica Workflow Manager

• Extensively performed unit testing and system or integration testing

• Generated PL/SQL scripts and UN IX Shell scripts for automated daily load

p rocesses

• Extensively worked in Oracle performance tuning and created DDLs, database

objects like Tables, Indexes. Worked with DBA’s for performance Tuning issues

Venkat Sappi E -Mail:

acgvei@r.postjobfree.com

Contact: 437-***-****

• Developed several forms and reports in the process. Also converted several

s tandalone procedures/functions in PL/SQL to packaged procedure for code

reusability, modularity and control

• Designed tables, indexes and constraints using TOAD and loaded data into the

database using SQL*Loader

• Worked on OBIEE reports to do Enhancements

• Tuning of Informatica jobs with oracle as backend database

Environment: I nformatica 8x, Business Objects XI, Oracle, SQL*Plus, PL/SQL, TOAD 7.1,

U N IX, Windows XP, OBIEE

Contact this candidate