SUMMARY

• Around 7 Years of IT experience, working in all phases of Life Cycle of Data Warehouse like Analyzing Data from Various Sources, Data Modeling, ETL Process of data, and Data Presentation to Business Intelligence for Analysis
• 6 years of experience in development and designing of ETL methodology for supporting data transformations using Informatica Power Center 9.X/8.x/7.x/6.xand PowerMart 6.x/5.x.
• Experience with different Databases Oracle, SQL Server, DB2, Sybase, and Teradata having databases of over 3 Terabyte size.
• Expertise in Oracle 10g/9i/8i, MS SQL Server 2000/7.0, Erwin 4.0, SQL, PL/SQL, SQL* PLUS, SQL* Loader, TOAD, Stored procedures.
• Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Strong work experience in Data Mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Experience in Installation and configuration of Informatica PowerCenter & in integration of various data sources like Oracle, SQL Server, Flat files into the staging area and design ETL processes that span multiple projects.
• Thorough and detailed understanding of Informatica software architecture, administration and mapping development.
• Worked with Type I & II Slowly Changing Dimension and created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and Unconnected Lookups, Filters, Sequence Generator, Router and Update Strategy.
• Expertise in implementing complex business rules by creating re - usable transformations, Mapplets, Mappings, Mapping, Session and Workflow Variables.
• Developed Informatica sessions and batchesand Automation and scheduling of UNIX shell scripts using Autosys.
• Implemented Performance Tuning techniques on Targets, Sources, Mappings and Sessions.
• Involved in Postproduction support, and enhancements.
• Experienced at creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Good experience in creating reports using OLAP tools like Business Objects and Cognos (Impromptu, PowerPlay).
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.X/8.x/7.x/6.x, PowerMart 6.x, 5.x

OLAP/Reporting Tools: Business Objects, Cognos (Impromptu, PowerPlay)

Databases: Oracle 10g, 9i, MS SQL Server 2000, DB2, Sybase, Teradata V2R5

Data Modeling: Erwin Designer. 4.0

Database Skills: Stored Procedures, Functions, Triggers and Packages

Methodologies: E-R Modelling, Star Schema and Snowflake Schema

Languages: SQL, PL/SQL, UNIX Shell Scripting

Web Technologies: HTML, XML, Java, JavaScript, PHP, C, C++

Tools: /Packages: Toad, MS Word, MS Access, MS Excel, MS PowerPoint

Operating Systems: UNIX, Linux, Windows 2000/ XP/NT

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior Informatica Developer

Responsibilities:

• Studied the design of the data warehouse model using Star Schema.
• Project life cycle - from analysis to production implementation, 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 different targets
• Involved in the designing of ETL process using Informatica in order to populate the Banking Data Mart using the Flat Files, SQL server to Oracle database.
• Extracted data from sources like DB2, SQL server, and Fixed width and Delimited Flat files. Transformed the data according the business requirement and then Loaded into Oracle database.
• Designed and developed complex mappings to load the Historical and Weekly data from the Legacy Systems to Oracle database.
• Created Reusable Transformations and Mapplets, used them in Mappings to develop the business logic for transforming source data into target.
• Implemented Type II Slowly Changing Dimension methodology for accessing the full history of customers.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, dynamic Lookup, Filter, Update Strategy, and Router transformations.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created and Monitored Workflows to run Session tasks using Informatica Server.
• Created and scheduled Worklets. Setup Workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
• Wrote shell scripting for informatica Pre-session, Post-session Scripts using PMCMD command line.
• Performed Performance tuning and optimization of mappings and session.
• Unit Testing is done at various times to check the validity of the data at each stage.
• Analyzed data with discrepancies through Error files and Log files for further data processing and cleansing.
• Designed SQL Queries and excel sheets for each mapping of their test scenarios.
• Also involved in production supportalong with designing and development of jobs.
• Created reports using Business Objects functionalities like queries, slice and dice, drill-down, cross-tab, master detail and formulas. Emphasis was on a design to support current and historic reporting.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings

Environment: Informatica PowerCenter 9.0/8.6, Oracle 9i, SQL Server, DB2, Flat files, ErwinBusiness Objects 6.1, Windows 2000.

Confidential, Louisville, KY

Sr DW ETL Informatica Developer

Responsibilities:

• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load.
• Worked with source teams to resolve data quality issues raised by end users.
• Mappings were developed in informatica employing transformations like Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router.
• Applied Slowly Changing Dimension and Dynamic lookup techniques.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Developed post and pre session shell scripts and scheduled Event based sessions at the Informatica workflow manager.
• Informatica Metadata repository was created using the Repository Manager as a hub for interaction between the various tools.
• Used Informatica Power center workflow manager to create sessions, batches to run with the logic embedded in the mappings
• Implemented performance-tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue.
• Extensively used PL/SQL Procedures/Functions to build business rule.
• Used pmcmd commands for stopping and starting workflows and tasks.
• Used parameters and variables (sessions/mappings) extensively for incremental loads.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Configured email notification. Setting up tasks to schedule the loads at required frequency using Power Center workflow manager.
• Created Analytical Reports using Business Objects.
• Designed and developed a strategy for a specific and vital reporting need.

Environment: Informatica PowerCenter 8.1, Oracle 9i, SQL Server, Teradata V2R5, ToadWindows 2000, UNIX.

Confidential, Maryland

DW ETL Informatica Developer

Responsibilities:

• Worked on dimensional modeling to Design and develop Star Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Involved in Data Modeling Using Erwin.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files.
• Involved in the Extraction, Transformation and Load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively used Transformations like, Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Used Informatica Repository Manager to create Repositories and users and to give permissions to users.
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Wrote Shell Scripts for Informatica Pre-session, Post session Scripts.
• Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.
• Performed Unit testing and verified the data.
• Supported Business Objects end-user in areas including software (Designer, Reporting, Web Intelligence, and Publisher) and creating reports.

Environment: Informatica PowerCenter 7.2, Informatica PowerMart 5.1.2, Oracle 8i, SQLPL/SQL, Toad, Business Objects, Windows 2000, UNIX.

Confidential, CA

DW ETL Informatica Developer

Responsibilities:

• Involved in the installation and configuration of Informatica Power Center.
• Designed and developed complex Mappings using Informatica.
• Used Informatica as ETL tool to pull data from source systems, transform and load data into databases.
• Implemented Join, Expression, Aggregate, Lookup, Update Strategy, Filter and Router Transformations as per Business Requirements.
• Created sessions and workflows for designed mappings.
• Created and scheduled Session, jobs based on demand, run on time using Workflow Manager.
• Written SQL overrides in Source Qualifier according to the Business Requirements.
• Identified performance bottlenecks and involved in Performance Tuning of mappings and sessions.
• Involved in writing Shell Scripts.
• Extensively involved in writing PL/SQL stored procedures and database triggers.
• Designed and developed Reporting system using Cognos and maintained Impromptu Catalogs.

Environment: Informatica PowerCenter 7.2, Oracle8i, DB2, Cognos, Erwin 4.0, TOAD Windows 2000, PL/SQL.

Confidential, CA

DW ETL Informatica Developer

Responsibilities:

• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using informatica power center.
• Extensively used Informtica Client tools-Source Analyzer, Warehouse Designer, and Workflow Manager.
• Imported data from various source (Oracle, Flat file, XML) and transformed and loaded into targets using Informatica.
• Developed Informatica mappings for data extraction and loading, worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
• Developed initial and incremental data loads in Informatica using Update strategy transformation.
• Monitored Workflows and Sessions using Workflow Monitor.
• Developed Unit test cases for the jobs .
• Involved in developing Adhoc reports using Business Objects.

Environment: Informatica Power Center 7.1,Oracle 9i, SQL Server (7.0), Erwin 4.0, TOADSQL, PL/SQL, Windows NT.

Confidential

Database/ETL Developer

Responsibilities:

• Involved in the coding of Stored Procedures and Triggers using PL/SQL for various Business Requirements.
• Designed and developed all the tables, views for the system in Oracle.
• Involved in Data Loading and Extracting functions using SQL*Loader.
• Implemented various validation rules on the data by applying various integrity constraints as well as data validation rules.
• Reducing the bottlenecks helping the query to execute by dropping or creating the indexes as per required.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets, and Transformations.
• Implemented Aggregate, Filter, Join, Expression, Lookup, Update Strategy, and Stored Procedure Transformations.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Creating and running sessions and batches using Workflow Manager to load the data into the Target Database.

Environment: Informatica Power Center 7.1,Oracle 8.0, SQL*Plus, SQL*Loader, PL/SQL, Windows NT.