Manager Data
Resume:
Venkat Sappi E -Mail:
*******.***@*****.***
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:
*******.***@*****.***
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:
*******.***@*****.***
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:
*******.***@*****.***
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:
*******.***@*****.***
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:
*******.***@*****.***
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:
*******.***@*****.***
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:
*******.***@*****.***
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:
*******.***@*****.***
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:
*******.***@*****.***
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:
*******.***@*****.***
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