PROFESSIONAL SUMMARY:

• About more than 7 years of experience in IT industry, 6 years experience in Data Warehouse using Informatica Power Center v 8.6/7.1.3/6.2 ( Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Workflow Monitor, Source Analyzer, Transformation Designer, Warehouse Designer, Star & Snowflake Schemas, using ETL tool Informatica on Oracle, SQL Server Databases)
• Strong experience on Installation of Informatica and configuration of Informatica Power Center 8.6 on windows.
• Expertise in Informatica Performance tuning and Database Performance tuning.
• Experience in the integration of various data sources such as DB2, SQL Server, Oracle, Sybase, Siebel, COBOL, VSAM files, XML files, and various types of flat files.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Transaction Control, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Experiencing in Dimensional Data Modeling like star schema, snow flake schema Fact and Dimension tables.
• Experiencing in using Change Data Capture.
• Experiencing in implementing of Change Data Capture using Oracle stored procedures.
• Experience in using Versioning features in Informatica such as Deployment Groups, Labels and Object Queries.
• Experience in effectively using different migration methods in Informatica.
• Experience in writing UNIX shell scripts and automating the Informatica Processes.
• Working knowledge of PL/SQL, SQL, programming.
• Experiencing in using E/R studio 7.6 for designing the mapping documents.
• Involved in many presentations like confidentiality and HIPAA resources and have knowledge on PPO, PHCS networks
• Experienced in overall data warehouse, database, ETL and OLAP tuning for better performance.
• Involved in identification of facts, measures, dimensions and hierarchies for OLAP models
• Excellent work ethics, strong communication skills and interpersonal skills that help in communicating with the fellow team members, Managers, Developers and Users.

TECHNICAL SKILLS:

Tools: Informatica Power Center 8.6.2/8.5/8.1/7.1/6.1 , Power Exchange 8.1,TOAD 7.x/8.5.1, SQL*Loader, SQL*Plus, Import, Export, Control Center, Crontab, Autosys, Erwin, Tidal (Knowledge)

Reporting: Business Objects 5.1, Business Intelligence

Scripting: UNIX shell

Databases: DB2, Oracle 10g/9i/8i, Oracle 11i RAC, SQL Server 2005, Sybase, Siebel, Mainframe

Languages: PL/SQL, C#, C, SQL, T - SQL

Software s: Star team, Lawson, Quality Center

EXPERIENCE:

Confidential, New York, NY

Sr. ETL/Informatica Consultant

Responsibilities:

• Worked with architect and business managers to understand the requirement. Communicated with the Golden Gate DBA group to understand the source systems as well.
• Worked with Database people from Golden gate to understand the environment. How they are managing source systems.
• Worked with Data modeler to understand the source to target mapping documents, the structure of the tables, how the final target looks like.
• Worked with Golden Gate DBA team to formulate the incremental loads, change data capture process via Golden Gate to Informatica interface.
• Worked on E/R studio 7.6 and interacted with data architect to design source to target mapping document.
• Created mappings of initial load for all source systems, cleansed data and load it into staging area.
• Created mappings for initial load in PowerCenter Designer using the transformations Expression, Aggregator, Joiner, Normalizer, and Source Qualifier.
• Created complex mappings for full load into target in PowerCenter Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, Union, Rank, Stored Procedures, External Procedure, Sequence Generator and Transaction Control.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Implemented Type 1 and Type 2 Slowly Changing Dimensions for each data set.
• Created various tasks like session, email, command, event raise and event wait to give various conditions in the workflows.
• Created reusable sessions for different workflows.
• Worked on Cumulative Fact (Aggregate fact tables), Atomic Fact loading from all Dimensions in the Target. (Star Schema)
• Wrote SQL scripts to verify counts and validate the data.
• Used UNIX shell scripting for the flat file to move onto the server and importing to the source and merging the data as well.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, Worklets and Workflows.
• Used Informatica Scheduler to schedule the work flows as this organization is having Tidal Scheduler (Optional).
• Created parameters and variables for the reusable sessions. Created Email task, Decision task
• Worked on SQA environment to test the data before we move into Production Environment. Worked with DBA group to resolve performance.
• Responsible for creating the parameter files in order to connect to the right environment and data base.
• Worked with DBA on SQL scripts to automate the process of populating the various columns in the tables with surrogate keys
• Worked with data architect to create table and column definition to prepare the data dictionary for users.

Environment: Informatica Power Center 8.6.1, Oracle 9i, Oracle 11i RAC, PL/SQL, SQL, UNIX, Shell script, Toad 8.5.1, E/R Studio 7.6, SQA

Confidential, Milwaukee, WI

Sr. ETL Consultant

Responsibilities:

• Worked heavily with Business Analyst to understand the business and to design the architecture of the data flow.
• Worked with source system developers and business owners to identify data sources for defining data extraction methodologies.
• Designed the metadata tables and created mappings to populate the same. These tables were used to generate the parameter files.
• Analyzed the source data, made decisions on appropriate extraction, transformation, and loading strategies
• Analyzed complex ETL requirements/tasks and provided estimates etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs & Populating the Data Mart with only required information.
• Created reusable transformations to clean the data, which were used in several mappings.
• Worked on power exchange to create data maps, pull the data from mainframe, and transfer into staging area.
• Implemented Slowly Changing Dimensions as per the requirements.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Worked with Informatica Administrator to setup project folders in development, test and production environments.
• Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows)
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

Environment: Informatica Power Center 8.6, Power Exchange 8.1, Oracle 9i, PL/SQL, SQL, Mainframe, DB2, UNIX, Business Objects 5.1, Shell script.

Confidential, Armonk, NY

Sr. ETL Consultant

Responsibilities:

• Collaborated with business analysts in requirements gathering, designing, testing, and project coordination.
• Used Informatica tools, including Repository Manager, Designer and Workflow Manager and Workflow Monitor.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings.
• Designed and developed various mappings, sessions and workflows to extract data from flat files, Oracle sources and load to Oracle and flat files.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
• Developed several PL/SQL stored procedures for pre/post session commands.
• Handle slowly changing dimensions of Type II to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Provided production support by monitoring the jobs and fixing the issues in a timely manner.
• Worked on fine tuning the existing mappings for better performance.
• Performed unit and integration testing. Performed tuning of SQL queries.

Environment: Informatica Power Center 8.1, Oracle 9i, SQL Server 2000, UNIX, windows 2000

Confidential, Hilliard, OH

Informatica Developer

Responsibilities:

• Participated in requirement meetings with Business Analysts and End Users to understand analytical content needs, assisted in documenting these requirements, resolving ambiguities, conflicts, and ensuring requirements are complete.
• Worked with DBA/architect to provide input on various project related schema and architecture of the data marts.
• Analyzed the functional specifications provided by the data architect and created technical specs documents for all the tasks.
• Created new mappings, modified existing mappings, sessions, workflows to comply with the new architecture.
• Developed a new historical data mart for collections, tasks included gathering the information, defining the schema, creating scripts to drop and recreate the indexes, creating and scheduling the workflows to run along with the already existing nightly jobs.
• Analyzed and created various Fact and Dimensions tables.
• Implemented various Slowly Changing Dimensions (SCD - Type I & II) as per the requirements.
• Worked heavily on production support and fixing the issues to ensure data marts are online under SLA.
• Performed code reviews.
• Performed repository backups and managed folders, user access, connection variables for dev, sys, UAT and production.
• Used Informatica partitioning to increase the performance of the mappings.
• Created various tasks like session, email, command, event raise and event wait to give various conditions in the workflows.
• Worked on the deployment of new code from one environment to other during the release.
• Worked with Business Objects developers to assist them in the development of various reports.

Environment: Informatica power Center 7.1, SQL Server 2005, Oracle, Siebel, Star Team, Lawson, Tidal, Erwin, Business Objects, and PL/SQL.

Confidential

Oracle Developer

Responsibilities:

• Interacted with end users for gathering requirements.
• Perform database tuning, monitoring, loading and back up.
• Used sql loader to load data from csv files into Oracle tables.
• Creating prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.
• Developed procedures and functions using PL/SQL.
• Created number of database Triggers according to business rules using PL/SQL.
• Developed SQL for loading Meta data from Excel spread sheet to the database using SQL Loader.
• Extensively used PL/SQL to implement cursors, triggers and packages.
• Developed SQL script for loading data from existing MS Access tables to Oracle.
• Create record groups for manipulation of data, Perform unit and system integrated testing.
• Involved in database design, development of database, tables and views.
• Involved in application testing, deployment and production support.

Environment: Oracle 8i, PL/SQL, TOAD, SQL*Loader, MS Access, Excel spread sheet, Windows NT.

Confidential

Programmer

Responsibilities:

• Analysis and Design of the system
• Designed interface for the system.
• Created PL/SQL scripts for data transformation in line with program specifications.
• Designed, developed database using ERWIN
• Creating temporary tables and indexes for loading and updating data.
• Designed and Developed Stored Procedures, Packages & Functions using PL/SQL and SQL scripts.
• Used SQL*Loader to load data using direct and indirect path.
• Developed database Procedures to handle Partition Deletion and Truncation automatically based on data loading criteria using Dynamic SQL.
• Tested all the modules.

Environment: Oracle 7.X, SQL, PL/SQL, SQL*Loader, Developer 2000, HTML, Windows 95