EXPERIENCE SUMMARY:

• Eight (8) years of total IT experience with 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, XML files, Flat Files and PeopleSoft to Data Warehouse.
• Hands on experience with 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 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:

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

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

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

EXPERIENCE:

Confidential, Tampa, FL

Sr. ODI/OBIEE Developer

Responsibilities:

• Primary responsibilities include but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings by applying slowly changing dimensions (SCD), organizing current and historical data chronologically in all brand dimensions, storage capacity planning, developing ETL.
• Designed and built Oracle BIEE 11.1.1.7x Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Involved in gathering requirements from the business and providing technical solutions accordingly
• Work on source systems like Oracle EBS, and Flat files. Develop mappings to load the data using flat files to oracle database.
• Developed a process to retrieve files from UNIX server using variables and procedures to load into tables.
• Scheduled daily, weekly, and monthly jobs according to the design using built in job scheduler.
• Use Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Analysed Session log files in operator navigator to troubleshoot and resolve errors in mapping and managed session configuration.
• Created project documents like deployment guide, production support guides, run-books etc. that are used by QI developers for deploying and testing in PROD environment
• Work on Performance Tuning and make sure the loads complete as per the time requirements.
• Developed and debugged several intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View).

Environment: Oracle Data Integrator (ODI) v.12.1.1.2, OBIEE 11g, 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 with 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 with reporting people to help 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 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: 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 then to Prod).
• Worked on migrating Packages, Mappings, and Folders from old versions to ODI 12C.
• Maintained all the Environments (DEV,TST, and, PRD)
• Gathered 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 with 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 then 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.
• 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

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..
• 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.

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

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, 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.