Experience Summary:

• SIX PLUS 6 years of total IT experience with strong background in Analysis, Design, Development, Implementation of Data Warehousing in ETL process using ODI 11g/10.1.3.4/10.1.3.5/Sunopsis.
• Experienced in all phases of System Development Life Cycle SDLC .
• Experienced in building/customizing ETLs from Source Systems such as PeopleSoft, EBS to DataWarehouse
• Experience in performance tuning DataWarehouse to meet Business Intelligence needs for applications such as Hyperion EPM applications and OBIEE.
• Experience in creating ad-hoc analysis and Dashboards using OBIEE Answers.
• Strong understanding on Data Warehousing concepts such as Star and Snowflake schemas.
• Used Oracle Data Integrator Designer ODI to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Experienced in Installing and Configuring Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning and developing ETL.
• Experienced in setting up ODI standalone Agents and J2EE Agents on WebLogic server based on requirements.
• Experienced in provisioning users Security Manager and setting up/manage source and target system connections Topology Manager in ODI.
• Experienced in developing stored procedures, functions, packages and database triggers using Oracle SQL Developer and PL/SQL to improve query performance.
• Strong SQL knowledge. Familiar with creating queries, tables, views and other relational objects, and maintaining the referential and data integrity.
• Experienced in gathering business requirements developing business requirement document, data mapping documents.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.
• Established and maintained productive working relationship with Management, Clients and Team Members. Self-starter, entrepreneurial, highly motivated team- player with excellent communication /problem-solving skills. Quick learning ability vis- -vis new technology. Easy adaptability to new environments.

Technical Skills:

Experience:

Confidneital

Sr. ODI Developer

Responsibilities:

• Worked with business analysts, developers, and management professionals from various locations to gather requirements.
• Built Data Warehouse in line with Ralph Kimball's Star Schema methodology for analytic purpose.
• Architected and Implemented ETL routines using ODI.
• Installed and configured Master and Work Repositories, ODI agents .
• Maintained DEV, TST, PRD environments.
• Maintained Topology connections in all 3 environments.
• Maintained User's security in all 3 environments
• Customized ODI inbuilt KM Knowledge Modules to build Interfaces for complex data requirements.
• Created numerous Interfaces to load data from Flat files, CSV files, and Oracle tables into staging tables and then into respective FACT/DIMENSION/Look-up Tables in Data Warehouse.
• Implemented serial vs parallel data loading in ODI.
• Used ODI in-built scheduler to schedule Scenarios/Load Plan's in production.
• Implemented slowly changing dimensions SCD in various Mappings.
• Utilized ODI in-built Journalizing J tables methodology to manage and maintain Change Data Capture CDC from source data.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Created numerous data validation scripts using SQL, which were used by the Team post ODI data loads to validate the data brought into DW.
• Conducted UAT session with Business Users.
• Created numerous Views, Materialized Views, Stored Procedures and Functions which were used in ODI during data load and OBIEE post ODI data loads and while building BI Reports .
• Conducted training session for both Administrators as well as End Users.
• Other tasks included were documenting ODI Installation and Configuration process, Design and Technical documentation for the developed ETL processes.

Environment: Oracle Data Integrator ODI v.11.1.1.7, Oracle 11g, OBIEE v.11.1.1.7, SQL Plus, TOAD, Windows 2008.

Confidneital

Sr. ODI Developer

Responsibilities:

• Developed, Supported and Maintained ETL Extract, Transform and Load processes using Oracle Data Integrator ODI .
• Translated business requirements into technical specifications to build the Data Warehouse.
• Created and Maintained data base objects Tables, Views, PK keys, Indexes, Partitions, Triggers, and Sequences, etc. .
• Developed numerous ODI Interfaces, packages, scenarios to extract data from different source systems such as Oracle EBS AR, AP, GL, OM Modules , Legacy Systems such as Mainframe, Flat files and Load into ODS/EDW.
• Validate the Data which was brought into ODS/DW using SQL/PL-SQL scripts.
• Responsible for setting up ODI in all the environments DEV, UAT and PROD which includes all the tasks from Installing and configuring ODI to releasing the environment to users assigning security, client installations and other related tasks .
• Installed the J2EE ODI Agents on WebLogic server as part of ODI set up.
• Responsible for setting up/administering source and target connections in ODI.
• Responsible for scheduling the Scenarios to execute in serial/parallel modes to meet the data load requirement.
• Monitor the scheduled ODI jobs in PROD and apply fixes for failed ones.
• Huge experience in fine-tuning complex ODI processes for better performance.
• Migrate the ODI scenarios across different environments from Dev to UAT and then to Prod using PPM packages.
• Experience in customizing ODI Knowledge Modules, writing custom codes using Jython to meet the complex business requirements.
• Experience in designing Mini Schemas/Data Models/Data Marts for Legacy Systems in Oracle and develop Reports out of OBIEE answers, dashboards as per business requirement.
• Experience in building ad-hoc reports in OBIEE answers and design some mid level dashboards as per user requirements.
• Experience in building and maintaining database objects Tables, Views, Procedures and Functions etc used in the Data Models.
• Responsible for creating Test plans and co-ordinate with Testing Team in executing test plans for the ETL Interfaces.
• Responsible for project documentation documenting functional, technical documents, preparing test cases/test plans and KT plans .

Environment: ODI v.11.1.1.3/v.10.1.3.5, OBIEE v.10.1.3.4, Oracle 10g/9i, SQL, PL/SQL, SQL Loader, Toad, Oracle SQL Developer, Shell Programming, Sun Solaris, Windows 2008.

Confidneital

Hyperion/ODI Support Analyst

Responsibilities:

• Created ODI Scenarios to extract Metadata and Data from OLTP system and Load cum Transform data in a suitable format to feed the Applications developed in Hyperion Planning and Hyperion Essbase respectively.
• Created separate packages for loading Metadata into Hyperion planning apps and loading data into respective Essbase cubes.
• ODI was used to load Incremental Metadata into Hyperion planning apps through Flat files provided by system analysts.
• Created data load Interfaces using Sql queries as source and load the transformed data into respective Essbase cubes.
• Responsible for performance tuning data load Interfaces.
• Experience in developing write back Interfaces to write back aggregated data designing interfaces using report script as source from Hyperion system into Oracle Tables or .csv files based on the requirement.
• Experience in developing complex Interfaces to call Maxl/Calc scripts or batch jobs in ODI to meet the data load requirements.
• Responsible for migrating ODI code Scenarios, Projects, Models, Topology connections across different environments.
• Responsible for ODI executions in PROD and apply quick fixes in case of failed ones.
• Validate the Data which was loaded into Hyperion system using SQL and Excel add in Templates.
• Provide user support in resolving data/configuration/process issues in the system.
• Responsible for Maintenance and Support of Oracle Data Integrator ODI interfaces between Hyperion systems Planning and Essbase and external systems.
• Involved in ODI architecture, documenting, code reviews and change migration.
• Train End-Users on process control, Hyperion Automation and using Oracle Data Integrator.
• Other responsibilities included were Business Requirements gathering, reviewing the FDD's and documenting the Design documents and other misc tasks related to the ETL and Automation part of the Application Development.

Environment: Oracle Data Integrator ODI v.10.1.3.4, Hyperion Planning v.9, Hyperion Essbase v.9, OBIEE v.10.1.3.4, Oracle 10g, SQL developer, Windows Server 2003.

Confidneital

Oracle Developer

Responsibilities:

• Responsible for analyzing the Business Requirements and prepared the detail Technical Specification document.
• Determined the facts and dimensions, worked on identifying the data granularity in facts and data consistency across dimensions.
• Worked on creating the design document, facts and dimensions, hierarchies for logical columns, reports and dashboards.
• Prepared the analytics report by importing the required tables into the physical layer using the connection pool.
• Worked on creating the Repository in the Administration tool and applied hierarchies, created logical columns and also implemented the time functions on the logical columns depending on the user's requirement.
• Created as many as 40 reports on the answers page and worked on building the dashboards.
• Applied the appropriate security model for different users, authenticated with session variables and object level security for different web groups.
• Worked on setting up groups and providing privileges to the users on the Web Catalog Page.
• Viewed SQL query log and used SQL developer to run and debug the SQL query issued during report execution.
• Used different unions and case statements in developing reports.
• Scheduled i-bots to deliver report contents to all users through different devices on various locations.
• Performance tuning of Dashboards and made the required changes by implementing the views and by re-building the indexes.

Environment: Siebel analytics 7.X, OBIEE 10.1.x, Oracle 10g, SQL Developer.