Srikanth

614-***-****

abhmdo@r.postjobfree.com

Professional Summary:

o 7+ years of career reflecting experience and high performance in System

Analysis, Design, Development and Implementation in Relational Database

and Data Warehousing Systems using Informatica.

o Experienced in design, development, and documentation and testing of ETL

jobs using Informatica Power Center 8.x/7.x/6.x, Informatica Power

Exchange.

o Experience in Requirement Gathering, Analysis, System Design, and

Developments phases of Software Development Life Cycle (SDLC).

o Expertise in working with Repository Manager, Designer, Work Flow

Manager, Work Flow Monitor, Transformation Developer, Re-usable

Transformations, Shortcuts, Import and Export utilities.

o Experienced in coding using SQL, SQL*plus, PL/SQL stored

procedures/functions, triggers and packages.

o Excellent understanding of the DBA functions including creating tables,

table spaces, databases, indexes and clusters.

o Experienced in Installation, Configuration and Administration of

Informatica Power Center on Client/Server environment.

o Strong understanding onthe principles of Data Warehousing using Fact

Tables, Dimension Tables with Star Schema and Snowflake Schema modeling.

o Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing

Dimension phenomenon (SCD).

o Experienced in Data analysis, Data modeling concepts, Database design and

Data migration.

o Extensive experience in Financial, Insurance and Health Care Sectors.

o Excellent knowledge of different RDBMS like Oracle 8i/9i/10g/11g, MS SQL

Server, DB2 and Teradata.

o Effective in cross-functional and global environments to manage multiple

tasks and assignments concurrently.

o Worked on UNIX Shell scriptingeffectively.

Skillset:

Informatica Power Center 8.x/7.x/6.x, Power Connect 7.x, Erwin 4.0, Oracle

11g/10g/9i/8.i/7.x, DB2 UDB,Teradata V2R6/V2R5, Toad, SQL*Plus, SQL*Loader,

MS SQL Server 2000/2005, MS Access 7.0, Cognos 8.0, SQL, PL/SQL, UNIX Shell

Scripting, Perl scripting, Xml, Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM

AIX 4.2/4.3, Win 98/2000/XP/NT, Autosys, Crontab andCA Schedulers.

Education Qualifications:

V Bachelors of Science in Information Technology, India.

Professional Summary:

American Express, Greensboro, NC.

Mar 10- Till

Date

Role: Senior ETL Informatica Developer

American Express is a global services company, providing access to

products, insights and experiences that enrich lives and build business

success .American Express is a leading provider of core financial

institution processing, card issuer and transaction processing services,

mortgage loan processing and related information products and outsourcing

services to financial institutions, retailers, mortgage lenders and real

estate professionals.

Hardware/Software:Informatica Power Center 8.6.1, Informatica Power

Connect, Oracle 10g/9.i, DB2, Erwin, Toad Teradata 8.1, SQL server 8.0,

UNIX and Unicenter scheduler.

Responsibilities:

> Extensively involved in the Analysis, Design and Modeling. Worked on Data

Elements, Issue/Question Resolution Logs, and Source to Target Mappings,

Interface Matrix and Design elements.

> Worked closely with business analysts to understand the business needs

for decision support data.

> Created mappings and Mapplets to load data from source systems in to data

warehouse.

> Involved in the extensive development of numerous mappings using

transformations like Lookup, Expression, Aggregate, Filter/Router,

Joiner, Rank and Sequence Generator.

> Performed incremental aggregation to load incremental data into Aggregate

tables.

> Developed an end-to-end ETL processes for Data Marts.

> Designed the ETL processes to load data from Flat files and SQL Server

database into the target Oracle database.

> Optimized Query Performance, Session Performance and Reliability.

> Developed PL/SQL stored procedures for source pre load and target pre

load to verify the existence of tables.

> Written SQL overrides in source Qualifier according to business

requirements.

> Mentored the DB developers on Informatica to gain knowledge.

> Took the backup of Repository on regular intervals depending on the

amount of work done.

> Used parameter file to define database connection session parameters to

reuse sessions for different relational sources or targets.

> Performed Unit testing, Integration testing and generated various Test

Cases.

Assurant Employee Benefits, Kansas City, MO

Aug 08 - Feb 10

Role: Senior ETL Informatica Developer

Assurant Employee Benefits is one of the largest marketers of employee

benefits in the United States; it offers the product diversity and

security. Itscore business is focused on small to mid-size employer groups.

The company has enormous amount of inconsistent and redundant data

generated among various functional groups of an organization. The

application was developed to integrate these isolated islands of data to

provide users with better information and even faster access so that they

identify opportunities more quickly and respond more appropriately. This

information was extracted from different OLTP applications using

Informatica and was transformed into independent Data marts and then to

EDW.

Environment: Informatica Power Center 7.x/8.x, Informatica Power Connect,

Oracle 10g/9i, DB2, MS SQL Server 2005, Flat files, SQL*Loader, Erwin,

Toad, Windows XP/2000, Unix.

Responsibilities:

> Involved in full project life cycle - from analysis to production

implementation and support with emphasis on identifying the source and

source data validation, developing particular logic and transformation as

per the requirement and creating mappings and loading the data into ECF

databases.

> Based on the requirements created Functional design documents

andTechnical design specification documents for ETL Process.

> Designed, implemented and documented ETL processes and projects

completely based on best data warehousing practices and standards.

> Extensively involved in Informatica Power Center upgrade from version

7.1.1 to version 8.1 and upgrading hotfixes.

> Designed, developed Informatica mappings, enabling the extract, transform

and loading of the data into target ECF tables on version 7.1.3 and 8.1.

> Involved in performance tuning and fixed bottle necks for the processes

which are already running in production. Also gained 3-4 hours load time

for each process.

> Designed and developed process to handle high volumes of data and high

volumes of data loading in a given load window or load intervals.

> Created Workflow, Worklets and Tasks to schedule the loads at required

frequency using Workflow Manager.

> Created complex mappings using Aggregator, Expression, Joiner

transformations including complex lookups, Stored Procedures, Update

Strategy and others

> Designed and developed table structures, stored procedures, and functions

to implement business rules.

> Extensively developed shell scripts for Informatica Pre-Session, Post-

Session Scripts.

> Extensively involved in migration of Informatica Objects, Database

objects from one environment to another.

> Tested data integrity among various sources, targets and various

performance related issues.

Emblem Health Services Company LLC, New York

Jun 07- Aug 08

Role: Senior ETL Informatica Developer

Emblem Health provides access to quality, affordable health care by

providing a choice of products and networks so members have access to the

medical care they need at prices they can afford.

Environment: Informatica Power Center 8.1/7.1, Informatica Power Connect,

Oracle 10g/9i, DB2 UDB, SQL Server 2000, Flat files, Sequential files,

SQL*Loader, Toad, Windows XP/2000 and UNIX.

Responsibilities:

> Extensively involved in interacting with Project coordinators, Business

Analysts and End-users to gather requirements.

> Created transformations according to business logic.

> Designed ER-diagrams, Dataflow diagrams, module logic & data using Erwin.

> Prepared the ETL spread sheet and designed Star Schema after identifying

the Facts and Dimensions.

> Used the Informatica Power center designer to develop the required

mapping based on the ETL spread sheet.

> Used the Informatica Power Center Workflow Manager to develop the

required sessions for the mappings developed based on the ETL spread

sheet.

> Used different transformations Source Qualifier, Expression, Filter,

Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner,

Router, Aggregator transformation and SQL override extensively.

> Used the Workflow Manager to create tasks, sessions, worklets and

batches.

> Scheduling the session's tasks comprising of different mappings for data

conversion, extractions in order to load data into oracle database.

> Extensively involved in performance tuning of the Informatica

Mappings/Sessions by increasing the caching size, overriding the existing

SQL.

> Used debugger to handle errors in the mappings.

> Written pre session and post session scripts in mappings.

> Wrote stored PL/SQL procedures for certain Business Requirements.

> Implemented the best practices for creating the mappings, sessions and

workflows.

> Designing and customizing data models for data warehouse to support data

transfer from multiple sources at real time.

> Performed Unit testing for the mappings before including the developed

sessions into the already existing batch.

> Integration tested the entire batch after including the individual

sessions into the existing batch.

> Performance statistics were considered during the integration testing.

Johnson & Johnson Pharmaceutical, L.L.C, Morris Plains, NJ

Apr 06 - May 07

Role: Informatica Developer

Johnson and Johnson is a leading global manufacturer of major drugs and

health products. It is world's eighth largest pharmaceutical company and a

premier consumer health company. The project objective was to validate the

data and make it available for end user reporting, analysis and decision

support and to improve the client services by preventing errors, providing

real-time data and updating records as the transactions are completed.

Environment: Informatica Power Center 7.1, Informatica Power Connect,Oracle

8i, DB2, MS SQL Server 2000, SQL*Loader, Business Objects 6.0, XML, Toad,

Flat files and UNIX.

Responsibilities:

> Involved in all phases of SDLC from requirement, design, development,

testing, training and rollout to the field user and support for

production environment.

> Worked with Informatica PowerMart client tools like Source Analyzer,

Warehouse Designer, and Mapping.

> Involved in data design and modeling by specifying the physical

infrastructure, system study, design, and development by applying Ralph

Kimball methodology of dimensional modeling.

> Imported various Sources, created Targets and Transformations using

Informatica Power Center Designer (Source analyzer, Warehouse developer,

Transformation developer, Mapplet designer, and Mapping designer).

> Identified proper partitioning methods for performance enhancements.

> Developed and scheduled Workflows using task developer, Worklet designer,

and workflow designer in Workflow manager and monitored the results in

Workflow monitor.

> Involved in analyzing source systems and designing the processes for

Extracting Transforming and Loading the data to Data Warehousing system.

> Wrote the shell scripts to process the PL/SQL procedures and wrote the

PL/SQL program units for data extracting, transforming and loading.

> Scheduled sessions for pulling the data from transactional databases in

order to maintain the freshness and availability.

> Handled data exceptions in Informatica using Reject Loader utility.

Manipal Hospitals, Bangalore, India.

Oct 04 - Mar 06

Role: Informatica Developer

This Project involved creating a Data Warehouse for sales reporting

system.Data from ODS was extracted, transformed and loaded into data

warehouse using Informatica.

Environment: Informatica Power Center 7.1/6.2, Business Objects 4.1, Erwin

3.5, PL/SQL, Oracle 8i, DB2, SQL Server 2000, Windows 2000, AIX 4.3.3 and

UNIX.

Responsibilities:

> Requirements gathering, Source data analysis and design.

> Develop Logical and Physical data models that capture current

state/future state data elements and data flows using Erwin.

> Extensively used Informatica Power Centeras an ETL tool to extract,

transform and load data from remote sources to EDW.

> Building of the WMS, RMS & HRS module of the EDW.

> Wrote shell scripts and stored procedures to automate the aggregate

building process.

> Worked extensively on transformations like Filter, Router, Aggregator,

Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner

transformations.

> Created, launched & scheduled sessions and batches using Power Center

Server Manager.

> Developed a prototype for designed interface and estimated the

performance criteria.

> Extensively worked on the Database Triggers, Stored Procedures, Functions

and Database Constraints.

> Used Connected and unconnected lookups in various complex mappings.

> Reviewed and documented existing SQL*Loader ETL scripts.

> Worked on Debugging, Troubleshooting and documentation of the Data

Warehouse.

> Identified the underlying tables and business rules by forward and

reverse engineering using ERWIN.

> Responsible for development, test and productions mapping migration using

repository manager. Also used Repository Manager to maintain the

metadata, Security and Reporting. Tuning the Informatica Repository and

Mappings for optimum performance.

> Customized data by adding calculations, summaries and functions.

> Created standard and Ad hoc reports using Business Objects.

> Developed and published reports on the web through Web Intelligence.

Satyam Computer Services Ltd, India

Jul 03- Sep 04

Role: Oracle Developer

Satyam is a leading global business and information technology company,

delivering consulting, systems integration, and outsourcing solutions to

clients in over 20 industries. We leverage deep industry and functional

expertise, leading technology practices, and an advanced, global delivery

model to help clients transform their highest-value business processes and

improve their business performance.

Responsibilities:

> Created procedure, functions, cursors, packages according to the business

logic.

> Created forms, and queries.

> Created reports for different criteria.

> Used Unix Shell scripts using K-shell to automate the process of running

jobs/batches.

> Tuned SQL queries for better performance.

Environment: Oracle 8.i, SQL, PL/SQL, UDB DB2, PL/SQL, UNIX AIX 4.2 and

Windows XP/2000/98.

Contact this candidate