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 teh 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 teh 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 teh 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, Basking Ridge, NJ

Senior ODI Developer

Responsibilities:

• Maintained all teh Environments (DEV, SIT, and PROD).
• Collected requirements from teh business and developed some tables accordingly.
• Worked on source systems like Oracle EBS, and Flat files.
• Developed mappings to load teh 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 teh client location.
• Developed documents which are used for QI developers for deploying and testing in PROD environment
• Make sure teh data which loads in to teh tables to be Unique data by analysing teh complex requirements.
• Worked on Performance Tuning and make sure to complete teh 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 teh Environments (DEV, QC, UAT).
• Worked on gathering requirements wif teh business users.
• Created complex Mappings, Procedures and Packages according teh requirement.
• Collected data from sources like Oracle, Microsoft SQL, Flat files, and Share point.
• Worked on validating teh data after completing loading teh tables.
• Worked on source systems like Oracle EBS, and Flat files.
• Developed mappings to load teh 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 teh requirements.
• Scheduled teh Scenarios in QC and UAT to run teh 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 teh Data Models.
• Responsible for creating Test plans and co-ordinate wif Testing Team in executing test plans for teh 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 teh ODI scenarios across different environments (from Dev to UAT and then to Prod).
• Worked on migrating Packages, Mappings, and Folders from old versions to ODI 12C.
• Maintained all teh Environments (DEV,TST, and, PRD)
• Gatheird all teh requirements from Business analyst and data modeller which are required for my development.
• Built numerous mappings in teh development and tested it.
• Created and maintained all teh logical and physical schemas in topology for teh three environments.
• Worked on Data Validations for teh tables using SQL Query’s and mappings developed to validate wif teh source.
• Created several Variables, Procedures which are useful for teh filtering and loading teh data.
• Experience in customizing ODI Knowledge Modules, writing custom codes using Procedures to meet teh complex business 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
• Worked on creating Slowly Changing Dimensions to identify teh change of data.
• Worked on creating Packages for all teh mappings, variables, and procedures.
• Data tuning had been made for teh all teh tables in Development.
• Scheduled teh scenarios for teh 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 teh 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 teh Team (post ODI data loads) to validate teh 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 teh 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 teh 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 teh requirement.
• Experience in developing complex Interfaces to call Maxl/Calc scripts or batch jobs in ODI to meet teh 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 teh Data which was loaded into Hyperion system using SQL and Excel add in Templates.
• Provide user support in resolving data/configuration/process issues in teh 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 teh FDD’s and documenting teh Design documents and other misc tasks related to teh ETL and Automation part of teh 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 teh Business Requirements and prepared teh detail Technical Specification document.
• Determined teh facts and dimensions, worked on identifying teh data granularity in facts and data consistency across dimensions.
• Worked on creating teh design document, facts and dimensions, hierarchies for logical columns, reports and dashboards.
• Prepared teh analytics report by importing teh required tables into teh physical layer using teh connection pool.
• Worked on creating teh Repository in teh Administration tool and applied hierarchies, created logical columns and also implemented teh time functions on teh logical columns depending on teh user’s requirement.
• Created as many as 40 reports on teh answers page and worked on building teh dashboards.
• Applied teh appropriate security model for different users, authenticated wif session variables and object level security for different web groups.
• Worked on setting up groups and providing privileges to teh users on teh Web Catalog Page.
• Viewed SQL query log and used SQL developer to run and debug teh 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 teh required changes by implementing teh views and by re-building teh indexes.

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