Srikanth

203-***-****

EXPERIENCE SUMMARY

. Over 8+ years of experience in the Information Technology industry

with strong knowledge in Informatica and data warehousing

functionalities.

. Experience in Upgrading, Installating and Administartion of

Informatcia Powercenter and Data Quality tools.

. Excellent in Informatica Power Center and SQL/PLSQL for ETL cycle

development.

. Experience in Project management, effort estimation, resource

allocation and delivery management and Involved in Business Analysis,

collecting User and System Requirements, identification of technical

risks, and dependencies.

. Experience in creating Business Requirements, Design, Technical, Pre

& Post production, Pre & Post Installation and Upgradiong documents

for ETL, BI and DQ Applications.

. Experience in Unit, System and Integrate Testing of different process

in Data warehouse.

. Hands-on experience in designing, developing, and programming

solutions built around these technologies. Proficient in data

warehousing/ Business Intelligence concepts and also in Dimensional

Modeling.

. Good experience using Informatica Power Exchange, Power Exchange

Oracle CDC, Metadata Manager, Data Analyzer, Reference Table Manager,

B2B Dataexchange, Grid & High Availability option.

. Experience on Business Requirements Analysis, Application Design,

Development, testing, implementation and maintenance of client/server

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

Pharmaceutical and Telecom industries.

. Good knowledge of ETL methodology for supporting data transformations

and processing, in a corporate wide ETL Solution using Informatica

PowerCenter 8.6/8.5/8.1.1/8.0/7.1/7.0/6.2/6.1/5.1.2/5.1.1/4.7

(Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing

Designer, Mapping Designer, Mapplet Designer, Transformation

developer), Informatica PowerMart 6.2/6.1/5.1.2/5.1.1/4.7, Power

Connect, PowerPlug, PowerAnalyzer, Power Exchange, Datamart, Autosys.

. 3 years of Business Intelligence Experience in generating various

complex reports using BUSINESS OBJECTS 6.0, BOXIR2. Worked with

Designer and WEBI for creating ad-hoc and complex reports.

. 4 years of Dimensional and Data Modeling using Star & snow Flake

schemas. Experience with Fact and Dimension Tables.

. 7 Years of database experience using Oracle 11g/10g/9i/8i/7.x, MS

Access7.0/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000.

Hands on Working knowledge in Oracle and PL/SQL Writing Stored

Procedures, Packages, Functions and Triggers. Adept at working with

Distributed Data Bases, SQL * Loader. Created SQL Server Integration

Services (SSIS) SQL Server Analysis Services (SSAS).

. 6 years of UNIX shell scripting experience using shell scripts like

sed, awk, grep, WC, more, etc. Worked with crontab command to schedule

the jobs and ftp command to get access to a remote server.

. Participated in business and technical design sessions with DBAs,

developers and Extensive experience in business analysis, gap

analysis, cost/benefit analysis, testing, development of functional

specifications and project planning

. Lead the warehouse design and integration effort, including data

sourcing and transformation

EDUCATIONAL QUALIFICATION

. Master's in Computer Applications, Osmania University.

TECHNICAL SKILLS

Operating Systems MS-DOS, Window XP/2000/NT, HP-UNIX, LINUX

Schedulers Control-M, Auto Sys, ESP.

Modeling Tools ER win 4.5/4.0/3.5.5/3.5.2

BI Tools Business Objects 6.5/XI R2

Utilities Informatica PowerExchange 8.6.1, Metadata Manager,

Data Analyzer, Reference Table Manager, Informatica

B2B Data Exchange

ETL Tools Informatica, Power Center

6.2/7.1.2/7.1.3/7.1.4/8.1.1/8.6.1, DataStage 6.0,

SQL Server - DTS

Data Quality Tools SAS Data Flux 7.1.2, Informatica Data Quality

3.1/8.6.2, Informatica Data Explorer 5.0/8.6.2

Languages SQL, PL/SQL

Database Tools TOAD 8.0, PL/SQL Server 2005, 2000 SQL Developer

1.2, SQL * Loader

Databases Oracle 8i/9i/10g/11g, SQL Server 7.0/2000/2005

PROJECT EXPERIENCE

AVIVA INSURANCE, Des Moines, IA

Mar 2010 - Till Date

Role: Senior Informatica Consultant

Project: Reporting & Analysis Development

Responsibilities:

. Extracted data from different sources like SQL Server 2000, Oracle

and Flat files to load into ODS

. Involved in Requirement Gathering for functional and Non functional

and provided solutions to the Design of the Project.

. Created pre and post session Stored procedures to drop, recreate the

indexes and keys of source and target tables.

. Developed complex mappings to implement type 2 slowly changing

dimensions using transformations such as the Source qualifier,

Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router,

Rank, Union, Normaliser, Sequence Generator, Update Strategy, and

Joiner

. Performed data validation, reconciliation Balance and Control and

error handling in the load process to ensure the Solvency II rule.

. Implemented the Data governance rules provide by the business.

. Designed the tables and loaded the data according to the design of

ACORD data model.

. Performed tuning of Informatica sessions by implementing database

partitioning, increasing block size, data cache size, sequence buffer

length, target based commit interval .

. Created Mapplet and used them in different Mappings.

. Created tables and inserted data into the tables using SQL Server

2005.

. Developed Informatica workflows and sessions associated with the

mappings

. Developed, executed, documented test cases, test plans for

integration and system testing

. Documented standards for Informatica code development and prepared a

handbook of standards

. Scheduled walkthroughs of design documents, specifications, code, test

plans etc. as appropriate throughout project lifecycle.

. Worked on the datawarehouse which is implemented in the IBM IIW data

model structure.

. Tuning Informatica Mappings and Sessions for optimum performance.

. Executed prototypes for ETL and Data Quality demonstrating their

capabilities while training AVIVA personnel to use of the new

platform.

. Involved in trouble shooting and implementing the new features of

PowerCenter.

Environment: Informatica 8.6.1, Informatica Power Exchange 8.6.1, Metadata

Manager, UNIX, Linux, Oracle 10g, SQL Server 2005, Flat Files.

AMERICAN EXPRESS, Phoenix, AZ

Dec 2008 - Feb 2010

Role: Senior Informatica Consultant

Project: AMEX GNS Development

Responsibilities:

. Extracted data from different sources like SQL Server 2000, Oracle

and Flat files to load into ODS

. Created pre and post session Stored procedures to drop, recreate the

indexes and keys of source and target tables

. Designed and developed complex mappings using various transformations

in Designer to load data from flat files, legacy systems and Oracle

database into the target Oracle datamart.

. Created complex slowly changing dimensions type II processes using

dynamic lookup, Joiner, Router, Union, Expression and Update

Transformations

. Design and develop ETL processes using Informatica

. Designed, developed, maintained and tested Business Objects reports.

. Resposible for creating pre and post intsallation checking and testing

. Responsible for testing the existing ETL process after upgradion by

trial runs.

. Responsible for testing all the new features and functionalities of

Powercenter 8.6.

. Responsible for Unit and Integrate testing.

. Developed complex mappings to implement type 2 slowly changing

dimensions using transformations such as the Source qualifier,

Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router,

Rank, Union, Normaliser, Sequence Generator, Update Strategy, and

Joiner

. Performed data validation, reconciliation and error handling in the

load process

. Performed tuning of Informatica sessions by implementing database

partitioning, increasing block size, data cache size, sequence buffer

length, target based commit interval and SQL overrides

. Created Mapplet and used them in different Mappings.

. Implemented the Basel II to create an international standard that

banking regulators can use when creating regulations about how much

capital banks need to put aside to guard against the types of

financial and operational risks banks face.

. Created tables and inserted data into the tables using SQL Server

2005.

. Developed Informatica workflows and sessions associated with the

mappings using Workflow Manager

. Developed, executed, documented test cases, test plans for

integration and system testing

. Documented standards for Informatica code development and prepared a

handbook of standards

. Scheduled walkthroughs of design documents, specifications, code, test

plans etc. as appropriate throughout project lifecycle.

. Loaded and extracted data from SAP Sources and Targets.

. Tuning Informatica Mappings and Sessions for optimum performance.

. Involved in trouble shooting and implementing the new features of

PowerCenter.

Environment: Informatica 8.6.1, Informatica Power Exchange 8.6.1, Metadata

Manager, UNIX, Linux, Oracle 10g, SQL Server 2005

Allstate Insure, North Brook, IL

Apr 2008-Nov 2008

Role: Senior Informatica Consultant

Project: ALGO Development

Responsibilities

. Actively involved in gathering report requirements, analyzing the

requirements and formulating them into ETL process and Reporting

Designs.

. Involved in Creating high level and low level design documents.

. Involved in transforming the business requirements into the

technical requirements.

. Created technical specs and also mapping documents.

. Responsible for creating Powercenter services and also planning

the powercenter outages.

. Responsible for creating complex mappings, workflows and session

tasks as per the business requirements.

. Involved in creation insertion updation and deletion data into

tables using SQL Server 2000.

. Processed flat files as well as relational data from source to

targets.

. Analyze the Source and Target systems and database designs to

define Data capturing strategy

. Designed ETL architecture to extract transactional data from

multiple operational sources and load to a single target oracle

database serving as an independent data mart.

. Defined various facts and Dimensions in the data mart including

Aggregate and Summary facts.

. Designed and developed complex mappings using various

transformations in Designer to load data from flat files, legacy

systems and Oracle database into the target Oracle datamart.

. Created complex slowly changing dimensions type II processes using

dynamic lookup, Joiner, Router, Union, Expression and Update

Transformations

. Design and develop ETL processes using Informatica

. Designed, developed, maintained and tested Business Objects

reports.

. Resposible for creating pre and post intsallation checking and

testing

. Responsible for testing the existing ETL process after upgradion

by trial runs.

. Responsible for testing all the new features and functionalities

of Powercenter 8.6.

. Responsible for Unit and Integrate testing.

. Worked in Teradata FSLDM databse model as a warehouse.

. Created Indexes/Stored Procedures/functions/views/Materialized

Views/ Partitioned Tables/ Triggers etc to improve the report

performances.

. Involved in designing the Universe as per the report requirements

using Business Objects.

. Responsible to create different sets of reports using Web

Intelligence.

. Responsible to create interactive Dash board reports as per the

Business requirements.

. Involved in some administration tasks on BOXI like User

Management, Scheduling reports, Security management etc.

Environment: Informatica 8.1.1/8.6, Business Objects XI, Oracle 10g,SQL

Server 2000, Windows XP, HP-UNIX, Teradata

CNA, Chicago, IL

Jan 2007-Mar

2008

Role: Senior Informatica Consultant

Project: Merlin Data Warehouse

Responsibilities:

. Gathered requirements from the management for functionality,

display and effectiveness of the reports.

. Developed Source to Target mapping documents for the data

transfer.

. Developed mapping to load the data in slowly changing dimension

. Prepared ETL Design Specification, Initial data load scripts, test

scripts, test cases, and metadata scripts and scheduled the ETL

workflow through Unix CRON Jobs.

. Worked extensively with SQL*Plus, TOAD for writing user defined

queries, stored procedures, views, tables, Indexes and

constraints.

. Created Unit testing, move to QA, move to Production

documentation.

. Worked on extracting data from Oracle, Sql server database

transform and loading into data warehouse.

. Implemented the standards provided in the Acord Data model.

. Excellent communication analytical skills and ability to perform

as part of a team.

. Involved in evaluating the Data Quality product suite for CNA,

organize.

. Identify Exceptional data in our existing Warehouse and OLTP

systems.

. Requirement gathering, analyzing and implementing ETL and DQ

process

. Responsible for Developing ETL process flow.

. Understanding and documenting Procedure and function of Oracle

finance for development of ETL logic using Informatica

. Interact with client for project review and take feedback from

Business users.

. Responsible for Unit and Integrate testing.

. Responsible for creating complex mappings, workflows and session

tasks as per the business requirements.

. Developed various Mappings in efficient way using various

transformations.

. Designing of Informatica objects with aim of optimizing

performance and reducing development

and testing time.

. Involved in writing PL/SQL programs to accomplish some business

requirements and also to improve some loading process.

. Responsible for analyzing any data quality issues reported by the

business by debugging the source and Target data.

. Craeted BO Universe for DQ Reports.

. Created Dashboard and BO DQ reports for the business users.

. Responsible for schedule and maitenanceof the reports and users.

. Responsible for problem assessment and/or resolution and

documenting those resolutions

Environment: Informatica7.1.4/8.1.1, Oracle9i, SQL Server 2000, Windows

2003/XP, Oracle Applications 11.5.8,Erwin 3.5.2, Business Objects XI

CNA, Chicago, IL

Oct 2005-Dec 2006

Role: Senior Informatica Consultant

Project: Commercial Lines

Responsibilities:

. Gathered requirements from the management for functionality,

display and effectiveness of the reports.

. Design of Dimension Data Modelling, Star Schema Design.

. Developed Source to Target mapping documents for the data

transfer.

. Developed mapping to load the data in slowly changing dimension

. Prepared ETL Design Specification, Initial data load scripts, test

scripts, test cases, and metadata scripts and scheduled the ETL

workflow through Unix CRON Jobs.

. Worked extensively with SQL*Plus, TOAD for writing user defined

queries, stored procedures, views, tables, Indexes and

constraints.

. Created Unit testing, move to QA, move to Production

documentation.

. Worked on extracting data from Oracle, Sql server database

transform and loading into data warehouse.

. Excellent communication analytical skills and ability to perform

as part of a team.

. Moving the application to production with change control process &

assist the post production support

. Works with the Development Manager/Director to define project

deliverables, milestones, and manage risk/dependencies

. Maintaining and supporting data marts and data warehouse

applications.

. Coordinating with Onsite & Offshore Team meetings and also

application status documents.

. Management work across teams, prioritization of tasks, tracking

the work status, and planning the tasks

. Trouble shooting and performance of applications if any issues for

the user access.

. Created Day-to-Day tasks monitoring report of the issues and work

status.

. Created documents for the users for installing and accessing the

BI applications.

. Responsible for addressing Critical Technical and Data Quality

Issues by interacting with frontline users.

. Responsible for creating Unit, system Integration and UAT Test

Deployment configuration plans and execution.

. Migrating planning of applications across the environments.

. Performance tuning of the application processes and upgrading

them.

. Execute daily, weekly and monthly jobs, processes and procedures.

. Execute reports and ad-hoc queries to provide required business

partner data.

. Monitor job execution and maintain the process schedule.

. Execute code migrations and support user acceptance testing

activity for changes and enhancements.

. File management, Reviewing, creating and modifying UNIX shell

scripts and executing command-level instructions.

. Maintenance and scheduling of BO & WEBI Reports.

Environment: Windows XP, HP-UNIX 11i v1, Informatica 6.2/7.1.2, DataStage

6.0, Business Objects 6.5/XI, Oracle9i, SQL Server 2000, SQL Server

Analysis Manager, TIDAL, ERwin 3.5,

CNASURETY, Souix Falls, Chennai India

Oct 2004-Sep 2005

Role: Sr. ETL Consultant

Project: P& C Insurance Development

Responsibilities:

. Using informatica ODBC driver this data map, which represents the

data, is imported into Informatica repository.

. Interacted with various departments in the mainframe environment

to know about the format of data coming from mainframe

environment.

. Used Informatica Designer to create complex mappings using

different transformations to move data to Oracle database.

. Developed mappings in Informatica to load the data from various

sources into the Data Warehouse using different transformations

like Source Qualifier, Expression, Filter, Router, Lookup,

Aggregate, Rank, Update Strategy and Joiner.

. Worked extensively with Normalizer transformation to normalize the

data from the Mainframe environment.

. Developed expressions to convert the dates in Gregorian and Julian

formats to standard date format that suites the database.

. Developed logic to denormalize the data from database to upload it

back to mainframe.

. Extracted (Oracle), Transformed and Loaded data into Flat files

using Informatica mappings and complex transformations

(Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier,

Filter, Router and Expression).

. Wrote SQL, PL/SQL codes, stored procedures and packages for

dropping and re- creating indexes, to generate oracle sequences,

procedures that cleans up the base automatically in case the

mapping already ran, the procedure that will logically expire

existing records and update specific Code, packages to incorporate

business rules to some times eliminates transformation dependency.

. Involved in Logical & Physical Database Design of the staging and

the Data Warehouse databases using Erwin and Oracle.

. Analyzing the high level design documents and understanding the

functionality of both source and target systems and created low

level design document.

. Analyze information requirements and business rules based on

current documentation, source system understanding.

. Worked closely with the Team Lead to perform maintenance and

written new ETL processes.

. Executed and implemented data load from identified source system.

. Validate the data with the client SME's (Subject Matter Experts).

. Responsible for developing ETL maps, SQL and shell scripts to

clean and load data into Operational Data Store (ODS).

. Involved in extracting the data from the flat files and load the

data into ODS and Data Mart.

. Responsible for Performance Tuning of Informatica Mapping.

. Analyzed Session Log files in case the session failed to resolve

errors in mapping or session configurations

. Involved in preparation of Unix Scripts to kick off Informatica

jobs.

. Checking the file formats for the source flat files using UNIX

shell scripts thereby ensuring input file formats are same as

specified.

. Scheduling Informatica jobs using Cron tab which helps to run UNIX

shell scripts thereby running Informatica jobs using pmcmd

command.

. Developed UNIX shell programs for invoking SQL and PL/SQL

extraction scripts.

. Analyze source system data structures and map target schema to

source data structures.

. Prepared Micsoft Visio Diagrams which helps to understand Business

process.

Environment: Informatica 6.1/6.2, Oracle 9i, UNIX (Sun Solaris), Fixed

Width Files, TOAD 7.6.0.11, Windows XP

State Street, Chennai, India

Mar 2004-Sep 2004

Role: ETL Developer

Project: Sales Pattern Analysis

Responsibilities:

. Used Informatica Designer to create complex mappings using

different transformations to move data to a Data Warehouse.

. Developed mappings in Informatica to load the data from various

sources into the Data Warehouse using different transformations

like Source Qualifier, Expression, Lookup, aggregate, Update

Strategy and Joiner.

. Optimized the performance of the mappings by various tests on

sources, targets and transformations.

. Scheduling the sessions to extract, transform and load data in to

warehouse database on Business requirements.

. Involved in creation and usage of stored procedures and

Informatica power mart for data Loads in to data mart on a weekly

basis.

. Generating shell scripts on UNIX side to move invoices to Accounts

Payable in regular intervals.

. Involved in design and creation of Fact tables.

. Interacted with various departments, gathering their needs and

developing reports based on user requirements.

. Performing data cleansing, scrubbing and validating the data

before loading into data warehouse as per business user advice.

. Development and testing of Mappings, Sessions & workflows.

. Creating and running sequential & concurrent sessions and worklets

to load data to target database.

. Responsible for file management on the UNIX servers.

. Developed Design Document for better understanding of existing ETL

processes.

. Migrated mappings, sessions, worklets & workflows from Development

to Testing and from testing to production.

. Creating users groups and assigning access to the users depending

on the subject area.

Environment: HP-UX 11.0, Informatica 5.1/6.1, Windows NT, Oracle 8i.

ANZ, Bang, India

June 2002- Feb 2004

Role: ETL Developer

Project: Risk Technologies

Responsibilities:

. Loaded data from flat files to source tables using SQL*loader and

informatica.

. Implemented performance tuning logic on targets, sources,

mappings, sessions to provide maximum efficiency and performance.

. Worked in the Basel II Acord Model

. Responsible for Testing and Validating the Informatica mappings.

. Testing Mappings using Debugger.

. Involved in creation and usage of stored procedures and

Informatica power mart for data Loads in to data mart on a weekly

basis.

. Generating shell scripts on UNIX side to move invoices to Accounts

Payable in regular intervals.

. Involved in design and creation of Fact tables.

. Interacted with various departments, gathering their needs and

developing reports based on user requirements.

. Performing data cleansing, scrubbing and validating the data

before loading into data warehouse as per business user advice.

. Development and testing of Mappings, Sessions & workflows.

. Creating and running sequential & concurrent sessions and worklets

to load data to target database.

. Preparing Unit test Cases and Release notes.

. Created and used UNIX shell scripts which are used to copy input

files from DEV environment to PROD environment, sending a mail

once the process has successfully completed.Also notifying users

if there is any failure in process specifying them cause of

failure, appropriate action needs to be taken for rectifying.

. Developed Interfaces using UNIX Shell Scripts to automate the bulk

load, update Processes and Scheduled Sessions using pmcmd commands

Environment: Oracle 8i, Informatica Power Mart 4.7, Windows NT.

Contact this candidate