Synopsis

• Over 5+ Years of total IT experience in all the phases of the Data warehouse life cycle involving Requirement Gathering, design, development, analysis, Documentation & testing of Data warehouses using ETL, Data Modeling, Online Analytical Processing.
• Solid experience in implementing complex business rules by creating re-usable transformations and robust mappings/mapplets using various transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Expertise in Data Warehousing, ETL design and development process using Informatica Power mart and Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations).
• Strong Data modeling experience using Star/Snowflake schemas, Reengineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling.
• Experience with Data Extraction, Transformation and Loading (ETL) from different data sources like DB2,Oracle, MS SQL Server etc. into a common analytical data model using InformaticaPower Center 7.1.4/8.6.
• Experience in performance tuning of Informatica Sources, Targets, Mappings, and Transformations & Sessions, developed batch processes and ETL tools to update the accounts.
• Experienced in using parameter files, mapping parameters, mapping variables and session variables.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence and Synonyms.
• Creating Data Structures i.e. Tables & Views and applying the referential Integrity.
• Implemented Data Cleansing, Data Analysis, Data Profiling, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
• Thorough experience in integration of various data sources like Siebel CRM and relational databases like Oracle, SQL Server, and MS Access and worked on integrating data from flat files and XML files.
• Strong experience in Oracle database Performance Tuning and extensive experience in SQL * Loader Imports/Exports.
• Extensively worked on UNIX shell scripts that is used in scheduling Informatica pre/post session operations, increasing cache size, database administrations and database connections.
• Expertise in error handling, debugging and problem fixing in Informatica.
• Strong understanding of Performance tuning in Informatica and Databases.Worked with Oracle and SQL Server Stored Procedures, Triggers, Index, and experienced in loading data into Data Warehouse/Data Marts using Informatica.
• Business Intelligence experience using Oracle Business Intelligence Enterprise Edition 10.1.3.4.2 (OBIEE). Created rpd and implemented Security using Groups in the repository document and also created Dashboards in the Answers.
• Exposure to on-shore and off-shore support activities.
• Won awards and client appreciation on many occasions for prompt and quality delivery.
• Played key role in problem solving, interacting with Business Analysts and minimizing manual intervention.
• Focuses on delivering business solutions. Has strong technical skills and picks up new technologies fastly.
• Demonstrates leadership skills and motivates the team for increased productivity. Has good communication, interpersonal and presentation skills.
• Looking for a challenging role in the field of Software Development in a reputed organization.

Education

B.Tech in Electronics and Communication Engineering.

ETL Tools: Informatica Power Center 8.6/7.1.4
Reporting Tools : OBIEE 10.1.3.4.2
Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, DB2, flat files
DB Tools: TOAD, SQL Developer
Languages: Java, SQL, PL/SQL, UNIX Shell Scripting
Operating Systems : Windows 7/Vista/Server 2003/XP/2000/9x/NT/DOS, UNIX

Confidential Dec 10 to May 12

ETL Informatica Analyst/Developer

Confidential has different systems such as Franchise Information System which holds information about the Franchises, Property Management System which holds the consumer profile information and Central Reservation System which holds things like reservation information, Consumer profile information and other transactions.

Roles and Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter 8.6.1.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping
• Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle.
• Developed data Mappings between source systems and target system using Mapping Designer.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed reusable Mapplets and Transformations.
• Developed and tested all the Informatica mappings and update processes.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy, Java Transformations and Re-usable transformations.
• Created events and tasks in the work flows using workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Taken part of Informaticaadministration. Migrated development mappings as well as hot fixes them in production environment.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Developed Unit test cases and Unit test plans to verify the data loading process.

Environment:Informatica – PowerCenter 8.6.1 (PC 8.6.1), Power Exchange, Oracle 10G, Oracle 11G, UNIX Shell Script, Windows NT/2000/XP, SQL Server 2008.

Confidential March 09 to Dec 10

ETL Informatica Analyst/Developer

OFS Reporter is a Business Intelligence tool used by Confidential. It is used to extract data from several different sources, gather it in a single database which is easily accessible by a reporting tool called ORACLE BUSINESS INTELLIGENCE. With this reporting tool, Schlumberger end users will have the ablility to build their own queries in several functional domains.

Roles and Responsibilities in INFORMATICA:

• Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like Oracle, and Flat Files.
• Extensively used Informatica Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Use Source Analyzer and Warehouse Designer to import the source and target database schemas, and use mapping designer to map source to the target.
• Use Transformation Developer to create joiners, filter, lookup, Router and Aggregation transformations that are used in mappings.
• Created Shell Scripts to generate the parameter files, automatic backup old log files, and to automate the loading process.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed reusable Mapplets and Transformations. 
• Used PL/SQL procedures and functions in mappings to do complex database level operations with Oracle 10g.
• Developed and tested all the Informatica mappings and update processes.
• Provided Production support by monitoring the processes running daily.
• Worked closely with business Analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited).
• Developed Unit test cases and Unit test plans to verify the data loading process.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment. Used Autosys for defining, scheduling, monitoring the jobs.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.

Roles and Responsibilities in OBIEE:

• Create user and security roles.
• Work on tickets that we receive on a regular basis which may involve development changes, enhancements etc.
• Develop iBots to send reports to the clients by mail.
• Monitor daily loads using AUTOSYS tool (JOB Scheduling Tool).
• Develop custom dashboards and reports using Answers.
• Work closely with Business Analysts and understan the Analytics requirements
• Configure OBIEE Repository which includes implementation of physical data model as per requirements.
• Import tables from database and create physical joins.
• Create dimension hierarchies and assign priorities to each level.
• Create new dashboards in Answers and assign security to users.
• Responsible for Unit Testing, System Integration Testing and validation of data for all the reports that are generated using OBIEE.

Environment:Informatica – PowerCenter 8.6.1/7.4.1 (PC 8.6.1/7.4.1), Power Exchange, OBIEE 10.1.3.4.2, Oracle 10G, Oracle 11G, UNIX Shell Script, Windows NT/2000/XP, SQL Server 2008.

Confidential Jan 07 to Dec 08

In product life cycle management, the product produced will be managed starting from the manufacturing to a completely finished product. It manages different materials required for the product to be manufactured. Common core operations (CCOPS) are used in the product manufacturing stage and Business continuity process (BCP) is used in the product sales stage.
e-Matrix tools are used for the product life cycle management.

Roles & Responsibilities:

• Incident Management, Problem Management & Query Management for Common Core Operations (CCOPs).
• Write Matrix queries using MQL (Matrix Query Language) for extracting information and send it to the users if needed.
• Write Tcl (Tool command language) scripts for various data extracts.
• Responsible for Unit testing of developed modules.
• Production Support and work on Change Management tickets.