PROFESSIONAL SUMMARY

• 5 years of total IT experience in the Designing, Coding, Development, Testing and Implementation of Data Warehouse/Data marts.

2 years of strong experience in Informatica Power Center 7.1.1, Informatica Power Mart 6.2 (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server) Three years of experience in Oracle Warehouse Builder 10g Release2 (Designer, Control Center Manager, OmbPlus, Process Flow Editor)

• Strong understanding of Data warehouse concepts, ETL, Star Schema, FACT & Dimensions tables, source to target data mapping, ability to define and capture Business rules associated with the ETL process.
• Experienced in the design of Extract Transformation and Load (ETL) processes, coding and testing the ETL processes, maintain, troubleshoot and fine tune existing ETL process.
• Good experience with Oracle8i/9i/10g database as backend for ETL process.
• Enthusiastic and adaptive to new technologies.

EDUCATION

Bachelors in Commerce

TECHNICAL & SOFWARE SKILLS

Data Warehousing:

Informatica Power Center 7.1 (Workflow Manager, Workflow Monitor, Work lets, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations Developer,), Informatica Power Mart 6.2,Oracle WarehouseBuilder10gR2(Designer, Control Center Manager, Omb Plus, Process Flow Editor, Database Objector

Programming:

SQL, PL/SQL, C.Dos,

Environment:

Microsoft Windows 95/98, 2000/NT/XP, Vista, Windows 7.0

WORK EXPERIENCE

Confidential,Oakland, CA
(Consumer Product)

Aug 2010 – Present

Confidential, is the first customer to go live with Oracle’s DSR. Clorox is collecting near real time point-of-sale (POS) data from retailers that provide it, along with syndicated market data from IRI, shipment data, trade funds data, and other data elements. By correctly modeling this data in a DSR, Clorox can examine the effectiveness of a much greater proportion of its promotions, as well as measure the effectiveness of promotions much more quickly. Speed of analysis is important because it leads to better behavior shaping.

• Data Extraction from Flat Files and Loading into interface tables using OWB.
• Data Cleansing.
• Created the maps for consumption data.
• Implemented the Increment load for the fact.
• Involved in the performance testing of the maps.
• Involved in Unit testing.
• Promoting Dev code to QA and Production environments.
• Designing the New Mappings.
• Designing and implementing the Process Flows for Data Load.

Environment: Oracle Warehouse Builder 1og Release2 (Repository Assistant, Designer, Control Center Manager, Data object Editor, Process Flow Editor), OBIEE, PL/SQL, Oracle 10g, Windows XP.

Confidential,Canonsburg, PA.
(Pharmaceutical)

Jul 2007 - July 2010

Confidential, is the third largest generic pharmaceuticals company in the U.S. to the third largest generics and specialty pharmaceutical company in the world.
Confidential,maintains operations in the North America, Europe, Middle East and Africa & Asia Pacific.

• Data Extraction from Different source systems like Flat Files, EBS and NDW.
• Customization of DSR mappings to Activsion.
• Designing the ETL mappings.
• Design and Implement control process for incremental loading.
• Designing and implementing the Process Flows for Data Load.
• Developing Reports in OBIEE
• Involved in Performance tuning of reports and OWB mappings

Confidential,Orangeburg, NY
(Consumer Product)

April 2006 - Jun 2007

Manufacturing of Pre-moistened wipes and other product likes personal hygiene, cleansing, disinfection.
Oracle E-Business suite is being used world-wide by its large client base. New release of E-Business Suite will provide facility to the Manufacturers of any product, to sync-up there manufacturing cycle with the retailer’s annual sale cycle to earn the most profit by utilizing there manufacturing and distribution channels effectively

• Participate in all phases including Client Interaction, Requirement Gathering, Data Analysis, Design, Coding, Testing and Documentation.
• Responsible for Coding Maps and Process flows
• Developed Complex mappings in OWB to load the data from various sources using different transformations like Set Operator, Joiner, Key Lookup, Expression, Aggregator, Sequence Operator, Filter, Splitter and Deduplicator transformations.
• Created Functions and Procedure to be used in Process flow for complex condition flow.
• Performance tuning of maps.
• Responsible for creation of Technical Design Documents and Unit Test Plan
• Performed Unit Testing, Performance Testing, Integration testing
• Responsible for Peer code reviews
• Worked with the Data base administrator for the creation of repository using Repository Assistant.
• Explaining the mapping functionality to the QA team.
• Fixing the bugs.

Environment: Oracle Warehouse Builder 1og Release2 (Repository Assistant, Designer, Control Center Manager, Data object Editor, Process Flow Editor), OBIEE, PL/SQL, Oracle 10g, Windows XP.

Confidential,WH
(Energy & Health Care Product)

Feb 2004 - March 2006

Confidential, Corporation is one of the world largest electrical engineering and electronics Companies. Siemens provides innovative technology and comprehensive knowledge on how to benefit customers. The primary objective of this project is to provide enterprise wide data warehousing solutions for top-level executives and to a large extent for operational users also, which will allow Siemens Management to continue to analyze the organized data. This Data warehouse would enable both tactical and strategic decision-making. Siemens Data Warehouse is built upon integrated legacy system data feeds received from many Siemens based business data sources.
HR Data Mart is a Data Warehouse reporting, analysis, and decision-support environment that allows users to view and analyze Human Resource information specific to Siemens. The initial source systems for this HR data are the Siemens Corporate Oracle HRMS instances. The other focus of the project is to develop an environment, which provides the business with critical business metrics reporting and analysis functionality in the form of standard reports and ad hoc query capability.

• Involved in analyzing the systems and gathering of requirements
• Worked on Informatica tools -Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used Source Analyzer to Load data from Flat Files and OLTP Systems into Data Warehouse.
• Created Informatica mappings to build business rules to load data.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Used Mapping parameters and variables to making mappings more flexible.
• Most of the transformations were used like the Source qualifier, Aggregators, lookups, Filters & Sequence Generator.
• Developed mappings/ sessions using Informatica power center for data loading.

Environment: Informatica Power Center 7.1, Erwin 3.0, Business Object Oracle 9i/8i, PL/SQL, Windows 2000, Win NT 4.0