SUMMARY:

• SEVEN(7+) years of total IT experience wif strong background in Analysis, Design, Development, Implementation of Data Warehousing in ETL process using ODI 12c/11g/ 10.1.3.4/10.1.3.5/10.1.3.2/ Sunopsis.
• Experienced in all phases of System Development Life Cycle (SDLC).
• Experienced in building/customizing ETLs from Source Systems such as EBS, WMIS, Share point and PeopleSoft to Data Warehouse.
• Hands on experience wif the new version ODI 12C.
• 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 noledge. Familiar wif 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 wif detail-oriented and problem solving skills in the technology arena.
• Established and maintained productive working relationship wif Management, Clients and Team Members. Self-starter, entrepreneurial, highly motivated team- player wif excellent communication /problem-solving skills. Quick learning ability vis-à-vis new technology. Easy adaptability to new environments.

TECHNICAL SKILLS:

Reporting Tools: OBIEE 11g/10g

ETL Tools: Oracle Data Integrator (ODI) c.12.1.1.2,v.11.1.1.7/v.10.1.3.4, Informatica V.9

Database: Oracle 12c/11g/10g/9i/8i, SQL Server, MS Access.

Database Tool: Oracle SQL Developer, TOAD, SQL Plus

Languages: SQL, PL-SQL, C, C++, JavaScript, Shell

Operating System: Windows 98/2000/XP/7, Windows NT, Windows server 2003/2008, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr ODI Developer

Responsibilities:

• Maintained all the Environments (DEV, SIT, and PROD).
• Collected requirements from the business and developed some tables accordingly.
• Worked on source systems like Oracle EBS, and Flat files.
• Developed mappings to load the data using flat files to oracle database.
• Retrieving files from UNIX server using variables and procedures to load into tables.
• Upgraded from ODI 10G to 12C on the client location.
• Developed documents which are used for QI developers for deploying and testing in PROD environment
• Make sure the data which loads in to the tables to be Unique data by analysing the complex requirements.
• Worked on Performance Tuning and make sure to complete the loads in very minimum time.

Environment: Oracle Data Integrator (ODI) v.12.1.1.2, Oracle Data Integrator (ODI) v.10.1.3.2, Oracle 12c, Oracle SQL developer, TOAD.

Confidential, Woburn, MA

Sr. ODI Developer

Responsibilities:

• Worked on converting SSIS mappings into ODI mappings.
• Worked on newest version of ODI 2C.
• Maintained all the Environments (DEV, QC, UAT).
• Worked on gathering requirements wif the business users.
• Created complex Mappings, Procedures and Packages according the requirement.
• Collected data from sources like Oracle, Microsoft SQL, Flat files, and Share point.
• Worked on validating the data after completing loading the tables.
• Worked on source systems like Oracle EBS, and Flat files.
• Developed mappings to load the data using flat files to oracle database.
• Retrieving files from UNIX server using variables and procedures to load into tables.
• Developed documents which are used for QI developers for deploying and testing in PROD environment
• Customized Knowledge Mappings according to the requirements.
• Scheduled the Scenarios in QC and UAT to run the loads every day.
• Worked wif reporting people to halp in building some dashboard.
• 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 wif 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: Oracle Data Integrator (ODI) v.12.1.1.2, Oracle 12c, Oracle SQL developer, TOAD, Windows 2008.

Confidential, Fort Myers, FL

Sr. ODI Developer

Responsibilities:

• Migrated the ODI scenarios across different environments (from Dev to UAT and tan to Prod).
• Worked on migrating Packages, Mappings, and Folders from old versions to ODI 12C.
• Maintained all the Environments (DEV,TST, and, PRD)
• Gatheird all the requirements from Business analyst and data modeller which are required for my development.
• Built numerous mappings in the development and tested it.
• Created and maintained all the logical and physical schemas in topology for the three environments.
• Worked on Data Validations for the tables using SQL Query’s and mappings developed to validate wif the source.
• Created several Variables, Procedures which are useful for the filtering and loading the data.
• Experience in customizing ODI Knowledge Modules, writing custom codes using Procedures to meet the complex business requirements.
• Created numerous Interfaces to load data from Flat files, CSV files, and Oracle tables into staging tables and tan into respective FACT/DIMENSION/Look-up Tables in Data Warehouse
• Worked on creating Slowly Changing Dimensions to identify the change of data.
• Worked on creating Packages for all the mappings, variables, and procedures.
• Data tuning had been made for the all the tables in Development.
• Scheduled the scenarios for the daily, weekly, and monthly based accordingly using built in scheduler.
• 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.12.1.1.2,Oracle 12c,v.11.1.1.7, Oracle 11g, OBIEE v.11.1.1.7, Oracle SQL developer, TOAD, Windows 2008.

Confidential, Marlborough, MA

Sr. ODI Developer

Responsibilities:

• Worked wif business analysts, developers, and management professionals from various locations to gather requirements.
• Built Data Warehouse in line wif 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..
• 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 wif 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.

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

Confidential, Waterbury, CT

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.

Confidential

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, autanticated wif 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 me-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.