Manager Data

ANAND SHARMA

**** ******* ******** ( Riverside, California 92503

951-***-**** ( *******.*****@*****.***

Professional Summary

. Highly skilled professional around with 3 years of experience in IT as

consultant working for major corporate clients, and having 3 years of

in-depth knowledge in Data Warehousing, Data Modeling, Business

Intelligence System Study, Design, Development and Implementation of

applications and Client/Server technologies.

. 3 + years of experience in designing and implementing data warehouse

and data mart applications, mainly in designing and developing ETL

processes using Informatica Power Mart /PowerCenter.

. Extensively used Informatica Workflow Manager and Workflow Monitor for

creating and monitoring workflows, worklets and sessions.

. Experience in creating Sessions and Batches using Informatica Server

Manager and monitored and scheduled the sessions and batches.

. Extensive experience in design, development of Data warehouses/Data

Marts, Data Extraction, Transformation and Loading (ETL), Dimensional

Modeling, designing the STAR and SNOWFLAKE schemas.

. Extensive experience in various Mappings, Mapplets, Transformations,

scheduling the Sessions and Batches for ETL process using Cognos

Decision Stream

. Strong SQL, PL/SQL and Business Analysis skills with proficiency in

creating triggers, stored procedures, functions and packages using

PL/SQL

. Excellent technical and communication skills and ability to work

effectively and efficiently in teams

. Worked with different data sources like Flat files, XML files,

Databases

. Expertise in data analysis, data warehousing, data modeling, and data

migration.

. Developed reusable mappings, using Mapplet Designer

. Used Transformation Developer to create the filters, stored procedure,

Joiner, update strategy, expressions, Lookup, Aggregate and other

Transformations.

. Worked extensively with ETL Processes for data warehouses.

. Used Source Analyzer and Warehouse designer to import the source and

target database schemas, and the Mapping Designer to map the sources

to the target

. 3 years of experience in RDBMS like Oracle, SQL Server, Teradata and

DB2.

. Strong knowledge of Data Warehousing concepts and Dimensional modeling

like Star Schema and Snowflake Schema

. Expertise in UNIX, Oracle, ETL tools, and analysis tools. Data Access

methods & data modeling tools-ERWIN, Informatica, AB INITIO, SQL PLSQL

. Expert in UNIX shell scripting (Korn shell/Bourne shell)

. Expert in Perl scripting

. Excellent communication, presentation, project management skills, and

a very good team player

Technical Skills

Data Warehousing Informatica 7.3, 8.6, Ab-Initio

Reporting Tools Cognos 8.0 Series

Data Modeling Star-Schema Modeling, Snowflake-Schema Modeling, FACT and

Dimension Tables, Pivot Tables, Erwin

Testing Tools Win Runner, Load Runner, Test Director, Mercury Quality

Center

RDBMS Oracle 10g/9i/8i/7.x, MS SQL Server 6.5/7.0/2000/2005/2008, UDB DB2,

Sybase, Teradata, MS Access 2003

Programming UNIX Shell Scripting, Perl, Korn Shell, C Shell, Bourne Shell,

Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++, Java

Web Technologies JavaScript, HTML 4.0, and DHTML, Java, J2EE

Education:

. Master of Science in Computer Application . K.I.I.T. University .

Bhubaneswar, Orissa, INDIA

. Bachelor of Science in Computer Application . Bangalore University .

Bangalore, Karnataka, INDIA

Patni Computer System Ltd, Mumbai, India

Jan '07 to Jan '09

Informatica Developer - Corporate Credit Card

Responsibilities:

. Working with the DBA group, Business Analysts to extract the

historical data from one oracle database into data marts built in

another oracle database. Attended several business sessions with

the business users and analysts.

. Involved in creating a comprehensive Technical Specification

Document for the project.

. Designed and developed the Informatica mappings for the ETL process

to load the data into the Oracle database tables.

. Designing, building, testing Informatica Power Center mappings,

sessions, workflows, and defining Data Warehouse Staging

Layer.

. Experience with Informatica Power Center version 7.x and later

migrated to 8.6.

. Successfully implemented the Informatica Best Practices on ETL

design / development experience for both 3NF and Star Schema

. Deployed advanced ETL techniques such as staging, reusability, data

validation, and change data capture (CDC) and error processing.

. Independently Monitored performance issues at the source, target,

mapping and session level.

. Applied Strong Oracle skills (SQL, performance tuning, DDL, etc.)

. Implemented Informatica versioning (team based development)

. Performed the Level I support Level II production support.

. Managed Database Objects (Tables, Views, Stored Procedures, and

Database Triggers), Oracle Accounts, privileges and roles.

. Used MS SQL, Flat files, XML files, Oracle files as data sources

and transformed into Oracle and MS SQL databases.

. Achieved good understanding on Informatica Repository Server and

Workflow Manager.

. Created Tasks, Workflows and Worklets using Informatica and

Monitored the Data loads in Workflow Monitor Module.

. Major Involvement in improving the tuning of mappings, both

existing and newly developed. Thorough understanding of session

properties in server manager for performance enhancement.

. Developed mappings for reuse using mapping designer.

. Modified existing mappings for improved performance.

. Complete involvement in ETL lifecycle.

. Maintaining versions of repositories, managing users and upgrading

repositories.

. Created source and target definitions, Mappings, Transformations

and worked with Sessions.

. Created and scheduled many Sequential & Concurrent batches to group

the sessions to run at the same time.

. Created Tasks and Workflows using Informatica Workflow Manager for

all mappings created.

. Worked on several complex transformations to create data warehouse.

. Interact with end users to identify information needs and business

requirements for final reports.

Environment: Informatica Power Center 8.6, ERwin 3.5, Oracle 9i, MS SQL

Server, PL/SQL, XML, Unix and Windows NT 4.0

Escorts Limited, India, Mumbai, India Feb '06

to Jan '07

Informatica Developer - Global Consumer Data Mart

Responsibilities:

. Participated in Requirement Gathering, Business Analysis, User

meetings, discussing the issues to be resolved and translating user

inputs into ETL design documents.

. Analysis, Design and Development, testing and implementation of

Informatica transformations and workflows for extracting the data

from the multiple sources.

. Developed extraction mappings to load data from Source systems to

ODS to Data Warehouse

. Developed complex mappings in Informatica to load the data from

various sources using different transformations like Source

Qualifier, Look up (connected and unconnected), Expression,

Aggregate, Update Strategy, Sequence Generator, Joiner, Filter,

Update Strategy Rank and Router transformations.

. Used debugger to test the mapping and fixed the bugs.

. Executed sessions, both sequential and concurrent for efficient

execution of mappings and used other tasks like event wait, event

raise, email, command and pre/post SQL.

. Used session partitions, dynamic cache memory, and index cache to

improve the performance.

. Documented the mappings used in ETL processes.

. Designed and Developed the Informatica workflows/sessions to

extract, transform and load the data into Target.

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

. Developed procedures to populate the customer data warehouse with

transaction data, cycle and monthly summary data, and historical

data.

. Optimize SQL queries for better performance.

. Worked with different Informatica tuning issues and fine-tuned the

transformations to make them more efficient in terms of

performance.

Environment:

Informatica Power Center 7.3, Oracle 8i, SQL, PL/SQL, TOAD, SQL*Plus,

Windows 2000, Unix.

Contact this candidate