Sai Bagirath

(H): 214-***-**** / (C): 469-***-****

Dallas,TX

acpfik@r.postjobfree.com

SUMMARY

. 7+ years of IT professional experience in designing, analysis,

programming and testing using Informatica Power Center 9.x/8.x/7.x/6.x.

. Extensive experience in design, development and implementation of Data

marts, Enterprise Data Warehouses and Business Intelligence Solutions.

. Extensive experience in Developing Informatica complex mappings/ Mapplets

using various Transformations for Extraction, Transformation and Loading

of data from multiple sources of data warehouses and creating workflows

with work lets & tasks and scheduling using workflow manager.

. Extensive experience in Insurance, Financial and Healthcare domains.

. Extensive experience of gathering requirement, Proof of concept, gap

analysis, design, development, and Implementation of the ETL/Data

warehouse projects.

. Intelligent Gathering of Business requirements to map legacy and other

sources to integrate into the Warehouse.

. Expertise with ETL processes utilizing Informatica PowerCenter

9.1/8.6/8.1to design data conversions from a variety of relational, XML

and flat file source systems to data marts/EDW.

. Experience with data analysis and Dimensional Data Modeling (specific to

a data warehouse / Business Intelligence environment), Star

schema/Snowflake schema, fact and dimension tables.

. Responsible for all activities related to the development, implementation

and support of ETL processes for large-scale data warehouses using Power

Center and Power Mart.

. Expertise in tuning mappings, identifying and resolving performance

bottlenecks at various levels like sources, targets, mappings, and

sessions.

. Experience in designing and developing efficient Error handling methods

for ETL mappings and workflows.

. Strong hands on experience using Teradata utilities (SQL, BTEQ Fast Load,

MultiLoad, FastExport, TPump, Visual Explain)

. Extensive experience in UNIX programming and shell scripting for

Informatica pre & post session operations.

. Ability to communicate design solutions to both technical and non-

technical audience.

. Experience in full life cycle development and implementation.

. Good understanding of overall data warehouse design principles and best

practices.

. Good Team Player with excellent communication, analytical, and

documentation skills.

. Experience in preparing documentation for data requirements and on

performing data modeling.

. Hands on experience in tuning mappings, identify and resolve performance

bottlenecks in various levels like source, target, mappings and session.

. Hands on experience in scheduling jobs through Control-M / WLM (Workload

Manager) Jobs.

. Very good exposure to Oracle 10g, 9i, 8.x, Teradata databases

. Hands on experience working in UNIX and Windows environments.

. Experience on Business Requirements Analysis, Application Design,

Development, testing, implementation and maintenance of client/server

Data Warehouse and Data Mart systems in the Industrial, Insurance,

Pharmaceutical industries

. Excellent Verbal and Written Communication Skills. Have proven to be

highly effective in interfacing across business and technical groups.

EDUCATION QUALIFICATION:

. Bachelor's Degree from Osmania University, Hyderabad, India.

TECHNICAL SKILLS

ETL Tools Teradata, Informatica Power Center 9.x/8.x

Databases Oracle 11x/10g/9i and Teradata.

Programming Skills SQL,TOAD, SQL*Plus

Scripting Languages UNIX Shell Scripting

Operating Systems UNIX (Sun Solaris 2.x, HP/UX) and Windows

NT/8/7/2003/2000/98.

Utilities BTEQ, Fast load and Multi Load.

PROFESSIONAL EXPERIENCE

Anthem Inc, Richmond, VA Sept

14 -Till date

Informatica Consultant

Anthem is the healthcare company in the United States and it is part of

BCBS. The Business Intelligence Applications are designed to deliver a set

of standard extracts to BCBS internal and external constituents, including

PMIS, BLUE2, EVA and EGD and others that reside within the Enterprise Data

Warehouse and Repository Depot (Edward). The Project was primarily aimed at

building a health information data warehouse for the users.

Responsibilities:

. Analyzed, designed, developed, implemented and maintained moderate to

complex initial load and incremental Informatica mappings and workflows

to provide data for Data Warehouse.

. Created several mappings using various active and passive transformations

like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner and

Expression.

. Developed Conceptual Business Model, Logical Data Model, Physical Data

Model and Star-Schema design.

. Researched operational data store (ODS) and Legacy systems to find

qualified source data.

. Coordinated with source system owners, day-to-day ETL progress

monitoring, Data warehouse target schema design (Star Schema) and

maintenance.

. Developing BTEQ's for loading the data from staging area to the Teradata

final target tables.

. Defined, designed, configured, and implemented a suitable architecture

for data integration from multiple, disparate data sources (including

legacy systems, relational databases, flat files, message queues,

spreadsheets) to Oracle 10g environment.

. Extensively worked in data Extraction, Transformation and Loading from

source to target system using BTEQ, FastLoad and MultiLoad.

. Involved in writing scripts for loading data to target data warehouse for

Teradata BTEQ, FastLoad and MultiLoad.

. Worked on Informatica Power Center 9.5 tools - Source Analyzer, Target

designer, Mapping Designer, Mappings & Transformations.

. Designed and developed transformation rules (business rules) to generate

consolidated (fact/summary) data using Informatica ETL (Power center)

tool.

. Checked Sessions and error logs to troubleshoot problems and also used

debugger for complex Problem troubleshooting.

. Identified and fixed bottlenecks and tuned the complex Informatica

mappings for better Performance.

. Performed extensive debugging and performance tuning of mappings,

sessions and workflows including

. Developed, tested and implemented break/fix change tickets for

maintenance and enhancement of Operational Data Store.

Environment: Informatica 9.5.0/9.0.1, Teradata 14.10, SQL, TOAD,

SQL*Plus, PL/SQL, TSRM, WLM, UNIX, Windows XP.

BCBSA, Richmond, VA Sept 13 -

Aug 14

Informatica Developer

The Blue Cross Blue Shield Association (BCBSA) is a federation of 37

separate health insurance organizations and companies in the United States.

Combined, they directly or indirectly provide health insurance to over 100

million Americans. Blue Cross plans providing coverage for hospital

services, while Blue Shield covered physician's services. EDWARD Cost of

Care project was executed to develop enterprise data warehouse which is

intended to ultimately delivering the right information to the right people

in the underwriting organization. This project involved integrating data

from EDL COC and loaded into Enterprise data warehouse the subject areas

which includes claims, payments and Membership information.

Responsibilities:

. Used different tasks (Session, Command, Email, Event-Wait and Control) in

the workflow

. Involved in writing scripts for loading data to target data warehouse for

Teradata BTEQ, FastLoad and MultiLoad.

. Involved writing the scripts using Teradata SQL as per requirements.

. Involved in preliminary analysis for the failure and approach to fix the

issues/specifications after finding the Root cause.

. Worked on Informatica Power Center 9.5 tools - Source Analyzer, Target

designer, Mapping Designer, Mappings & Transformations

. Created slowly changing dimension tables - SCD type 1 & type 2 mappings

using lookup, Expression, Update Strategy and Router Transformations

. Preparing and tracking of the overall status of applications and

communicating it with client on regular basis.

. Involved in analysis of primary cause of Incident Tickets, creating

change requests, Work Order (Service requests) in TSRM tool to implement

new production jobs, scheduling changes and fixes.

. Effective coordination with team members for Client deliverables & also

with development team to resolve the possible production issues.

. Understanding and documenting the existing applications for extended and

smooth support of applications.

Environment: Informatica 9.1, Teradata 13, SQL, PL/SQL, Oracle 10g, TOAD,

SQL*Plus,TSRM, Windows XP UNIX, WLM, TSRM

Black hawk Network Financial Services Pleasanton, CA

June 13 -Sept 13

ETL / Informatica Developer

A market leader in card-based financial solutions and the largest provider

of third-party prepaid cards, Blackhawk Network is a prepaid and payments

network, a market leader in card-based financial solutions and the largest

provider of third-party prepaid cards. Black hawk Network develops unique

products in easy-to-use formats and delivers them to consumers through an

exclusive retail network of leading grocery, mass, drug, convenience, and

specialty retailers in the United States, Canada, France, Mexico, and the

United Kingdom. This proprietary network includes over 80,000 store and

reaches more than 165 million consumers each week. Headquartered in

Pleasanton, California, Blackhawk Network has offices in New Jersey,

Chicago, Toronto, Mexico City, London, Paris, and Sydney.

Responsibilities:

. Based on the business requirements created High level and low level

Design Documents.

. Coordinated with team and Performed code review.

. Interacted with Data modular and DBA and Source systems and resolved the

Issues.

. Created Source definitions from SQL Server, Flat Files, Oracle, Teradata,

and Mainframe COBOL Sources.

. Created mappings involving various transformations like joiner,

aggregator, lookup, sequence generator, stored procedure, update

strategy, filter and router transformations to implement business logic.

. Imported/Created Target definitions and created Reusable Transformations,

mapplets in Shared folder.

. Involved in creating Informatica mapping to populate staging tables and

data warehouse tables from Mainframe sources.

. Extensively involved in writing ETL Specs for Development and conversion

projects.

. Created shortcuts for source and target and also created Reusable

Transformations, mapplets in Shared folder.

. Creating sessions, work lets and workflows for carrying out test loads.

. Extensively created Teradata BTEQ scripts to implement post load

processes.

. Extensively created MLOAD and FLOAD control files to load data in to EDW

tables.

. Designed and developed transformation rules (business rules) to generate

consolidated (fact/summary) data using Informatica ETL (Power center)

tool.

. Checked Sessions and error logs to troubleshoot problems and also used

debugger for complex Problem troubleshooting.

. Extensively used sequence generator for key generation in the data

warehouse.

. Identified and fixed bottlenecks and tuned the complex Informatica

mappings for better Performance.

. Worked on Parameterize of all variables, connections at all levels in

UNIX.

. Automation of job processing, establish automatic email notification to

the concerned persons.

. Coordinated with testing team in all three phases of testing including

end-to-end testing.

Environment: InformaticaPower Center 8.1, Teradata 13, windows 2000,

Teradata SQL, UNIX, Microsoft Excel.

Catholic Healthcare West, SFO, CA

Nov' 11 - May'13

ETL Informatica Developer

Description: One of the nation's largest not-for-profit healthcare systems

and the largest Catholic healthcare system based in the SFO, CA, United

States. Committed to delivering compassionate, high quality, affordable

healthcare services with special attention to the poor and underserved.

Network of more than 7,500 physicians and approximately 40,000 employees

provides healthcare services to more than four million people annually.

Responsibilities:

. Extensively used Informatica power center for extraction, transformation

and loading process.

. Designed and developed Star Schema, Snowflake Schema and created Fact

Tables and Dimension Tables for the Warehouse and Data Marts and Business

Intelligence Applications.

. Used Informatica Repository Manager to create Repositories and Users and

to give permissions to users.

. Used Informatica Designer to create mappings using different

transformations to move data from source to a Data Warehouse.

. Designed and Developed mappings in Informatica using different

transformations like Source Qualifier, Expression, Lookup, Aggregator,

and Router, Rank, Filter and Sequence Generator transformations.

. Created Update Strategy and Stored Procedure transformations to populate

targets based on business requirements.

. Tuned Teradata SQL queries and resolved performance issues due to Data

Skew and Spool space issues.

. Created and Configured Workflows, Worklets and Sessions to transport the

data to target warehouse tables using Informatica Workflow Manager.

. Created SCD type 2 mappings using lookup, Expression, Update Strategy and

Router Transformations.

. Scheduled the sessions to extract, transform and load data into warehouse

database as per Business requirements. Improved the session performance

by pipeline partitioning.

. Optimized the performance of the mappings by various tests on sources,

targets and transformations. Developed Procedures and Functions in PL/SQL

for Data ETL.

. Implemented performance tuning logic on targets, sources, mappings,

sessions to provide maximum efficiency and performance.

. Environment: Informatica Power Center 7.x, windows 2000, Teradata SQL,

UNIX, Microsoft Excel.

Client: DST Global, India

Jan 08- Sep11

Role: Informatica ETL Developer

Responsibilities:

. Interacted with business analysts, data architects, application

developers to develop a data model.

. Designed and developed complex aggregate, join, look up transformation

rules (business rules) to generate consolidated (fact/summary) data

identified by dimensions using Informatica Power Center 6.x/7.0 tool.

. Created sessions, database connections and batches using Informatica

Server Manager/Work flow Manager.

. Optimized mappings, sessions/tasks, source, and target databases as part

of the performance tuning.

. Design of ETL Mappings and Workflows using powercenter designer and

workflow manager.

. Involved in the extraction, transformation and loading of data from

source flat files and RDBMS tables to target tables.

. Involved in analysis of primary cause of Incident Tickets, creating

change requests, Work Order (Service requests) in TSRM tool to implement

new production jobs, scheduling changes and fixes.

. Developed various Mappings, Mapplets, and Transformations for data marts

and Data warehouse.

. Used Shell Scripting to automate the loading process.

. Used Pipeline Partitioning feature in the sessions to reduce the load

time.

. Analyzed and Created Facts and Dimension Tables.

. Used Informatica features to implement Type I and II changes in slowly

changing dimension tables.

. Used command line program pmcmd to communicate with the server to start

and stop sessions and batches, to stop the Informatica server and recover

the sessions.

. Designed processes to extract, transform, and load data to the Data Mart.

. Performed impact analysis, remedial actions and documented on process,

application failures related with Informatica ETL and Power Analyzer.

. Performed regular backup of data warehouse, backup of various production,

development repositories including automating and scheduling processes.

As part of optimization process, performed design changes in Informatica

mappings, transformations, sessions.

Environment: Informatica Power Center 7.x, ETL, Teradata, Oracle 8i, MS

Access, SQL, PL/SQL, Windows NT.

Contact this candidate