Qualifications Summary

• Over 7 years of total IT experience in the Business Requirements Analysis, Application Design, Dimensional Data Modeling, data migration, Implementations and Testing of Data Warehousing and Database business systems for various Financial, Insurance, Retail Manufacturing industries.
• 4 years of experience on ELT Tool ODI Oracle Data Integrator .
• Good experience on Oracle SQL and Pl/SQL.
• Worked on ODI Complex features like CDC Change Data Capture .
• Handsome experience on dealing with ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
• Good knowledge different version like ODI 10g 10.1.3.5,10.3.5.6 and ODI 11g
• Handsome experience of using Oracle Data Integrator ODI ELT Tool with Oracle Apps and Legacy data like XML, File, etc
• Knowledge in scripting languages like Jython, Perl and Web development technologies like JSP, XML, Web Services.
• Handsome Knowledge on Oracle Applications R12 and 12.1
• Experience in handling Version Control Systems
• Over 7 years of Data Warehousing experience using Informatica Power Center 8.1/7.1/6.2/5.1.2, Power Mart 5.1.1/5.0/4.7.2, Warehouse Designer, Power Connect, Power Analyzer, ETL, DataMart, OLAP, ROLAP, MOLAP, OLTP, Star Schema, Snowflake Schema, Siebel 7.8.x/OBIEE 10.1.3.x
• Three years of Dimensional Data Modeling experience using Data modeling, Star Schema/Snowflake modeling, Fact Dimensions tables, Physical logical data modeling, Oracle 10g/9i/8i, ERD , ERWIN 3.5/3.x and SQL Server Designer
• Strong Experience in implementing Ralph Kimball Methodology and Data modeling with Erwin
• Extensive Experience in Scheduling, Installing and Configuring Informatica.
• Expertise's in developing Slowly Changing Dimensions mappings using Change Data capture CDC Type1, Type2 and Type3 as a part of Performance Tuning.
• Executed Scheduling at Workflow level using Informatica Scheduler and DAC, also created PMCMD command line for scheduling workflow using UNIX scripts
• Trouble shooting and problem solving applications with Informatica Debugger
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads
• Data warehouse experience is varied from Data Analysis, Dimensional Data Modeling, Data Extraction Transformation Loading ETL , Creating Metadata layer, Data Mining, Data Transformation services DTS End User Reporting Web based Reporting Implementation, Creating Test scripts and user signoff documents.
• Created several scripts in UNIX for data transformations to load the base tables by applying the business rules based on the given data requirements.
• Strong experience in client interaction and understanding business application, business data flow and data elements.
• Ability to work in teams independent with minimal supervision to meet deadlines.
• Resourceful, creative problem-solver with proven aptitude to analyze and translate complex customer requirements.

Work Experience in chronological order

Confidential

ELT Specialist ODI Developer

Responsibilities:

• Extensively used Oracle data Integrator to extract data from legacy to Oracle database as per mapping rules.
• Extensively used ODI designer to create and manipulate source data stores, target data stores, packages, interfaces, procedures, variables.
• Developed the detailed design of application and technical architecture components
• Created ODI Interfaces using different transformation logics and migrated data from legacy to oracle data base.
• Involved in ODI architecture, documenting, code reviews and change migration
• Maintenance and Support of Oracle Data Integrator ODI interfaces between Hyperion systems Planning and Essbase and external systems.
• Created specification documentation for ODI mappings based on extraction rules.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the target database.
• Extensively created procedures and variables to execute pre and post interfaces in a package.
• Utilized different knowledge modules as per mapping rules to load data from legacy systems
• Created different types of join conditions, filter conditions and SQL quires to transform data to oracle.
• Create ODI interfaces and packages for initial load and incremental load
• Used ODI operator to debugger after execution of interface.
• Provide ODI Administration such as: versioning, repository creation and backups, ETL monitoring, troubleshooting failures, and scheduling.
• Prepare ODI objects Project, Models for deployment by using import export method
• Created agents to run the ODI jobs
• Monitor the ODI jobs using operator
• Assisted in the process of preparation of the document for ODI Development
• Extensively worked with Hyperion Reports, Developed reports for 2009 Annual plan and beyond, Forecasting monthly expenditures, Expense management and control, Reality of monetary resource availability, comparing actual vs. planned expenditures
• Worked on performance tuning of interface metadata, data loads and calculation times.
• Designed and developed ODI interfaces for integrating EBS data into Hyperion planning Essbase applications
• Resolved issues with the existing ODI interfaces in Hyperion Financial Forecasting HFF application

Environment: ODI 10.1.3.6, Oracle Hyperion Essbase and Planning 11.1.1.3, Hyperion FR, Smart View, Oracle 10g, SQL Developer, Windows 2003 R2 server.

Confidential

ETL Developer

Responsibilities:

• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers. Designed Different kinds of Transactions for the application.
• Was involved in development of the tables, stored procedures, triggers and views in Sql server.
• Involved in developing and supporting the SQL Server database for the timesheet application called Workbrain developed in ASP.net.
• Worked extensively on Query Analyzer and SQL Server Enterprise Manager to develop developed data dictionary, tables, views, indexes, functions.
• Developed VB scripts to connect to the sql server database to generate reports and flat files.
• Data from timeclock application use to generate a flat file which in turn was loaded into work brain application to calculate the labor rates.
• Used DTS and BCP to load the data from flat files to SQL server application and also to migrate data from SQL servers tables to flat files.
• Worked with T-sql for developing complex queries for reporting purposes.
• Developed SQL loader control files load the flat file data from work brain application and other shop floor applications and load into the Oracle tables which were source for many oracle discoverer reports.
• Dropped and recreated the indexes on tables for performance improvements.
• Developed Oracle tables which were base for the discoverer reports.
• Loaded the data into these tables using flat files as well as PL/SQL procedures creating db links to other application tables.
• Production support for data mart issues as well as SQl server data issues.

Environnent : SQL server 2005, Oracle 9i, Unix, SQL Server Enterprise Manager, Windows 2000/XP, SQL loader, VB scripting

Confidential

ETL-ETL Specialist ODI Developer

Responsibilities:

• Assisted in Logical Modeling. Forward engineered the Physical Data Model for development and production database
• Developed logical data models for the operations business area using ERwin
• Performed Source to Target Mapping. Used Trillium for Data Cleansing and Analysis
• Creating test plans and supporting executing test plans for the ETL Interfaces
• Worked with multiple data sources, creation and maintenance of ODI interfaces and packages
• Creating and maintaining the full lifecycle of ETL Interfaces/ processes/ flows
• Installed, Maintained and Documented the ODI setup on multiple environments
• Created, executed and managed ETL processes using ODI
• Used ODQ for Data Cleansing on Profiling
• Created numerous ODI Interfaces
• Used ODI Designer tool to design data integrity checks and to build ODI jobs
• Worked with ODI Graphical Designer, Topology Manager, Operator and Security Manager Knowledge Modules Reverse-engineering, Journalizing, Loading, check, Integration, Service
• Performed reverse engineering of databases using ODI Designer tool
• Graphical development and maintenance of Jobs using ODI designer
• Used ODI Security manager for managing users and permissions
• Used ODI Designer in order to generate documentation for the application
• Used ODI Topology manager module to manage the data information systems physical and logical architecture
• Modified IKM and LKM to populate a FLAG column in the target
• Used TOAD to develop Oracle PL/SQL, DDL's and Stored Procedures
• Responsible for converting the IMS Data to required structure using Informatica
• Used Cognos for reporting
• Developed PL/SQL procedures for processing business logic in the database

Environment: ODI 10.1.3.x, Oracle 10g/9i, PL/SQL. SQL Loader, Toad, Oracle SQL Developer, IMS Data, ETL, Erwin 4.2, Trillium, MS SQL Server 2005, Shell Programming, SQL Loader, IBM DB2 8.0, Sun Solaris, Windows NT

Confidential

Oracle Developer

Responsibilities:

• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges.
• Created Oracle Tables, Indexes, Views, Materialized views, Synonyms, database links.
• Wrote SQL queries Sub queries and Join conditions , PL/SQL programming and Query Level Performance tuning.
• Tuning of SQL statements using EXPLAIN PLAN, TKPROF, SQL Trace, and Oracle Hints to improve the performance.
• Worked on Collections, Bulk Binds Bulk Collects and Table Partitioning.
• Developed Oracle based SQL and PL/SQL programs for the creation of DW/ETL Process, ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
• Wrote Shell Scripts for database transactions and batch processing.
• Used Oracle tools such TOAD, SQL Developer, SQL PLUS and SQL Navigator.

Environment: Oracle 10g, ODI 10.1.3.5, Toad, Windows 2000/XP, Sql Loader.