EXECUTIVE SUMMARY:

• Embedded with 7 years of effective, highly - motivated exposure to IT Industry, focusing on Business Analysis, Requirements, Development, Testing, Administration and Implementation of Database and Data warehousing business systems.
• Expert level skills in developing Strategies for Extraction, Transformation and Loading (ETL) using Informatica Power Center 7x, 8x and 9x (Repository Manager, Designer, Work flow Manager, Work flow monitor).
• Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart on Client/Server environment.
• Worked extensively on Informatica Suite like Source Analyzer, Warehouse designer, Mapping & Mapplet Designer and Transformations.
• Experience in developing strategies for Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Mart/Power Center (Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Developer, and Designer).
• Strong understanding and Experience of Performance tuning in Informatica and Databases. Worked with Oracle and SQL Server Stored Procedures, Triggers, Index, Table Partitions and experienced in loading data into Data Warehouse/Data Marts using Informatica, SQL*Loader, Well Versed with different tools for accessing Databases and development in databases like TOAD, PL/SQL Developer.
• Thoroughly worked on ETL process consisting of data transformation, data sourcing, mapping, conversion, migration and loading into OLAP systems.
• Developed Unix Shell Scripts and Stored Procedures to run from the Informatica pre and post sessions to create and drop the indexes to improve the speed of session execution.
• Designed complex mappings using Lookup, Aggregator, Joiner, Router and Stored Procedure Transformations and did partitioning to improve performance.
• Implemented performance tuning techniques like: Tuned source qualifier queries to make use of indexes, Used reusable lookups with persistent caches to reduce multiple hits on database, used bulk load whenever feasible, Dropped and recreated indexes when loading data into indexed table.
• Experience in creating Metadata Objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboards, Pages, and Reports) using OBIEE Admin Tool and Presentation Services.
• Strong understanding of data warehousing concepts, dimensional modeling, designing Star and Snowflake schemas.
• Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL.
• Experience in Data Warehouse Administration Console (DAC) to Configure, Monitor and Schedule ETL routines.
• Knowledge in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer).
• Excellent problem solving skills with strong technical background and good inter-personal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS:

OBIEE Tools: OBIEE 10.1.3.x, Siebel Analytics 7.8/7.7,Oracle BI Apps 7.9.x.

Relational Databases: Oracle 8i: 11g |Teradata|DB2|SQL Server 2000/2005

Database Applications: SQL| SQL*Plus | PL/SQL | UNIX | Toad | DAC 10.1.3.X

ETL Technologies: Informatica Power Center 9.X/8.X/7.1.X, Power Exchange 8.x

Programming: C | C++ |Java|XML|WebServices

Operating Systems: Windows Vista/XP/2000/NT | UNIX | LINUX|Sun Solaris

Dimensional Data Modeling: Star Schema Modeling, Snow: flake Schema Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Informatica Developer

Responsibilities:

• Involved in requirements gathering, analysis, function/technical specifications, development, deploying and testing.
• Coded, tested, implemented and maintained medium to highly complex ETL mappings and Shell scripts to build and maintain automated ETL processes.
• Coded the Informatica jobs for long term reliability, and accuracy.
• Worked with the existing application support team to help identify root cause of issues during the workflow runs, after identifying the issues took corrective actions and implemented long-term prevention plans.
• Prepare/maintain documentation on all aspects of ETL processes to support knowledge transfer to other team members.
• Very good knowledge and Hands on experience on Flat file processing and ability to develop data validation mappings during the flat file loads and automating the ETL Load processes.
• Ability to identify and implement the parallel processing capabilities in the workflow sessions and use those capabilities to reduce the Workflow load times.
• Hands on experience on Performance Tuning using Session Partion, Lookup Properties, and Session Properties.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle 10g, Flat files, SQL Server 2005, DB2 Cobol files and to load data into staging tables first and then into Oracle Data Warehouse.
• Responsible for creating the Migration requests from Development to Stage and then after cross checking the migrated code in Stage for successful migration of all objects, the code is moved from Stage to Production.
• Designed and developed PL/SQL Procedures, Triggers and Packages for implementing business logic.
• Ability to write the Shell Scripts based on the project requirements.
• Integrated Informatica with Web Services applications through oracle PL/SQL.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations based on the design specifications.
• Troubleshooted and Performance tuned complex ETL mappings to reduce the session run time.

Environment: Informatica Power Center 9.1.0/8.6.1 , Oracle 11g/10g, SQL SERVER 2005/2008, PL/SQL, Flat Files,VSAM Files, T-SQL, Shell Scripts, Business Objects XI R2,FTP Servers, Linux.

Confidential, Philadelphia, PA

Informatica Developer

Responsibilities:

• Interacted with the Business Analysts in understanding the business requirements for the project.
• Created the stage mappings to extract the tables from the DB2 and then load the data into the oracle 10g staging area tables.
• Efficiently implemented Change Data Capture (CDC) to extract information from numerous DB2 tables.
• Created the User Defined Functions to handle the null values from the DB2 tables.
• Created various mappings, mapplets to implement the business logic using different transformations like Sorter, Joiner, Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter.
• Involved in Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple DB2 systems.
• Designed and Developed the Informatica mappings workflows/sessions to extract, transform and load the data into Oracle OPM Data Mart.
• Loaded Dimension, Fact and Exception tables and automated email generation when exceptions occurred.
• Created and used the reusable email tasks for the purpose of getting the status report on session failure, on session success and on workflow suspension.
• Used Workflow Monitor to monitor the progress of workflow and session and also used the workflow log and session log for trouble shooting purposes.
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• Worked with the DBA to improve Informatica session performance and query performance by collecting statistics and defining relevant indexes on target tables
• Performed unit testing to test load time and documented the Unit Test Results and Unit Test Cases.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Involved in writing the shell scripts in order to get the mainframe file to Informatica server Source directory.

Environment: Informatica Power Center 8.6.1, Informatica Power Exchange 8.6.1 DB2, Oracle 10g, SQL Developer, UNIX, Windows XP, OBIEE 10.1.3.4.1.

Confidential, Logan, UT

Sr. Informatica Consultant

Responsibilities:

• Expert level skills in Implementation of Enterprise Data warehouses using Informatica Power Center 8.1.1.
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Used Informatica Designer to create reusable transformations to be used in Informatica mappings and mapplets.
• Developed complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques.
• Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data warehouse.
• Created and scheduled Worklets. Setup workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Scheduled an execution plan run by using DAC.
• Worked on Performance tuning of mappings, transformations and sessions to optimize session performance by indexing and caching.
• Improved the performance by reducing the amount of time required for a load by balancing the batches in such a way that increases parallel processing.
• Involved in writing UNIX shell scripts to run batch jobs and automating their schedules.
• Involved in Designing and developing the OBIEE/Siebel Metadata Repository (.rpd) using OBIEE/Siebel Analytics Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down, Hierarchies) & Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.

Environment: Informatica Power Center 8.5, OBIEE 10.1.3.4, Oracle EBS, DAC, Oracle 10g, UNIX, Windows XP.

Confidential, Pasadena CA

ETL Developer

Responsibilities:

• Analysis, Requirements gathering from Business Requirement Document (BRD), function/technical specification, development, deploying and testing by Business Analysts.
• Developed simple & complex mappings using Informatica to load Dimension & Fact tables as per STAR Schema techniques.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Developed pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Session Performance is improved by creating multiple connections to sources and targets and loading data in parallel lines.

Environment: Informatica 7.x, Oracle 9i, UNIX, Win 2000 Server.

Confidential

Siebel Analytics Developer

Responsibilities:

• Involved in Software Development Life cycle starting from requirements gathering and performed object oriented analysis and design to implementation & maintenance.
• Involved in the design and development of Accounting Main heads and Sub Heads for various accounts.
• Designed the database schema and ER diagram depicting relationships between various tables in the database.
• Created the database trigger for the complex data validations and for security.
• Developed Oracle database triggers, stored procedures and PL/SQL scripts as per system requirements.
• Created Materialized views for high-end Application usage.
• Worked with Sub-queries/Correlated Sub-Queries in Different areas of the database

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, SQL*Loader, UNIX.

Confidential

Oracle Applications Developer

Responsibilities:

• Worked on Journal Import to bring legacy journals from AP, AR and Posting in Oracle General Ledger.
• Involved in Vendor Conversion from legacy system to Oracle System.
• Designed and developed Aging Buckets report in Accounts Receivables using Discoverer 4i.
• Designed and Developed PO Exception Report, Requisition without PO Reportin Purchasing using Reports 4i.
• Designed and Developed Checks Invoice Details report in Accounts Payables using Discoverer.
• Customized Open Payable invoices by Vendor using Reports 4i in Account Payables.
• Developed the PL/SQL validation program for the Vendor Interface process.

Environment: Oracle Applications 11i/11.5.9 Account Receivables, Account Payables, Purchasing, Reports 4i, Discoverer 4i, Oracle 8i, SQL* Loader, UNIX & Windows XP