OBJECTIVE

• To work as a BI Programmer/Designer/Consultant; Learn newer BI Technologies and keep adapting to changing customer requirements.

SUMMARY

• 9+ years of experience in using Oracle Data Integrator (ODIEE11g and 12C) and Knowledge on Oracle Business Intelligence Enterprise Edition (OBIEE11G/OBIA) development.
• Expertise in configuring OBIA Financial Analytics, pointing to source systems like Oracle EBS.
• Hands on experience in Configuring Hyperion Essbase Data Servers in ODI to load the data from Heterogeneous sources to Hyperion Essbase.
• Experienced in Analytical master data management on creation of analytical dimensions, reporting structures performance measures and related attributes based on validations and business rules that enforce enterprise governance policies.
• Hands on experience in designing and implementing the E - L-T architecture required to build data warehouse, including source-to-staging area, staging-to-target area, data transformations, and E-L-T process flows.
• Implemented extraction, loading, and transformation (E-LT) of data using Oracle Data Integrator; configuring the ODI master and work repositories, ODI models, defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions, and knowledge modules.
• Created numerous ODI Interfaces to implement Business Logic with ODI Graphical (Designer, Topology Manager, Operator, and Security Manager) & Knowledge Modules (Reverse-engineering, Journalizing, Loading, Check, Integration).
• Creating Variables, Sequences, Scenarios, Procedures, Interfaces and Packages in ODI.
• Worked on Exposing and invoking of SOAP web services and Restful web services through ODI using ODI Invoke web service tool.
• Worked on Migrating Oracle Data Integrator (ODI) from older versions OWB/ 11g to 12c by using fusion middleware 12c upgrade assistant.
• Worked on Installation of Oracle Data Integrator 11g/12c and configured master and work repositories.
• Configured golden gate in Oracle Data Integrator to capture real time data changes in the heterogeneous sources.
• Worked with multiple sources such as Relational database, Flat files, Json files for Extraction, Transforming and loading data into target tables.
• Experience in Metadata Modelling at three layers (Physical, Business and Presentation) using the Oracle BI Administration in OBIEE
• Extensive experience inOBIEE Administration Tool, OBI Answers, OBI Intelligent Dashboards, OBI Publisher, Delivers and iBots with OBIEE Applications.
• Involved in Implementing Slowly Changing Dimensions, Star Join Schema modelling, Snowflake Modelling, FACT tables, Dimension tables, de-Normalization.
• Identify and Created Facts, Dimensions and Hierarchies of the business model and customize the OBIEE repository (Physical, BMM and the Presentation layer).
• Extensive experience in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Star and Snow Flake schemas
• Performed requirements gathering, Analysis, and documenting business requirements, functional requirements and data specifications.
• Well versed with all stages of software development life cycle (SDLC) including Requirement Analysis, Designing, Coding, Testing and Deployment.
• Monitor Production Jobs to ensure successful execution in Control-M.
• Able to work independently or as part of Team, Fast learning and adapting to Newer Technologies.

TECHNICAL SKILLS

Database: Oracle 10g/11g

Languages: SQL, PL-SQL, SQL Server

Data Warehousing Tools: Oracle Business Intelligence 10g/11g Oracle Data Integrator 11g,12 C OBIA 11g, Hyperion Essbase, Golden gate Informatica

Scheduling Tools: Control-M, AutoSys

Middleware: Service oriented Architecture (SOA)

Data Modelling: Dimensional Data Modeling (Star Schema Modeling, Snow Flake Schema Modeling, FACT and Dimensions Tables)

Ticketing tools: BMC Remedy

Programming: Unix Shell Scripting, Jython

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

ODI Consultant

Environment: ODI 12c, OBIEE 11g, Oracle11g, WebLogic 10.3.6., Linux

Responsibilities:

• Used Oracle Data Integrator for Extraction, Loading and Transformation.
• Created data servers related to specific technologies and mapped with and physical and logical architectures.
• Created various mappings from source to target using Topology and Designer Navigator.
• Extensively used various knowledge modules such as Loading Knowledge Module, Integration Knowledge Module and Journalizing Knowledge Module for loading data into staging and target areas as well as to main data consistency.
• Created ODI Packages to improve inter-application dialog by having interfaces executed asynchronously.
• Designed logical Data model based on source system tables.
• Involved in migration from development phase to system integration testing.
• Experience in Failure analysis for ODI loads using Operator logs.
• Involved in full life cycle implementation of Financial and Supply Chain Analytics including installation, configuration, extension and customization.
• Implementing the Change Data Capture (CDC) by using Journalizing Knowledge Modules (JKM) to load Real time data.
• Experience in writing a PL/SQL programme such as writing triggers, Oracle stored procedures.
• Developed Different Reports with differentAnalytic Views(Tables, Pivot Tables, Charts, Column and View Selectors, Narrative, Tabular with Global and Local Filters) using presentation services.
• ConfiguredSchedulerby creating Scheduler tables in database.
• Perform daily Production Support recurring tasks and monitoring of the tickets queue, assign tickets, resolve tickets, update root cause and remediation.
• Developed Logical Columns in Business Model Layer based on Business Requirements by usingTime Series Objectsand business logic’s, and creating the Presentation Catalogs in Presentation Layer.
• Responsible for problem identification and resolution of failed processes or jobs and assisted customers in troubleshooting issues with their applications in AutoSys.
• Designed and executed unit test cases and debugged mappings successfully.

Confidential, TX

ODI/OBIEE Consultant

Environment: ODI 11g,OBIEE 11g, Oracle 11g, jython

Responsibilities:

• Processed data from various source systems like flat files and Oracle databases.
• Analyzed business requirements Specification documents and Converted High level design documents in to Low level design documents.
• Interacted with the Business users to identify the various process metrics in the business.
• Used ODI to effectively integrate heterogeneous data sources and converting raw data into useful information.
• Used ODI Designer as a data mapping/business rules implementation and developed mappings and workflows to transfer data from source system data to target systems.
• Developed various Data Marts using extracted information in the Data Warehousing System.
• Extensively worked on loading data from Source system to Target system by applying necessary transformations in Staging area.
• Created Data servers, Physical Schema, Logical Schema, Contexts using Topology Manager and Monitored Execution of mappings using operator.
• Used ODI for Reverse Engineering to retrieve metadata from data storage and load in to the repository.
• Used Knowledge Modules (KM) like LKM, IKM, RKM, JKM and CKM to accomplish Change data capture, slowly changing Dimension and Data Quality.
• Performed Data validation, Testing, Debugged the mapping for failed session.
• Implemented a variety of ODI interfaces, packages, procedures, scenarios for extracting and loading data in to Enterprise Data Warehouse.
• Developed Slowly Changing Dimensions (SCD's) using knowledge modules.
• Performed Unit Testing and prepared test cases.
• Conducted Performance tuning of ODI Mappings.

Confidential

ODI Developer

Environment: ODI 11g, Oracle 11g, SQL Developer

Responsibilities:

• Extensively worked on loading data from Source system to Target system by applying necessary transformations in Staging area.
• Involved in the flat file automation through SFTP configuration.
• Understanding existing business model and customer requirements.
• Created Data servers, Physical Schema, Logical Schema, Contexts using Topology Manager and Monitored Execution of mappings using operator.
• Much Involved in understanding the Source System and Target System.
• Resolving job failure, investigating long running jobs, restarting and forcing completed jobs, ensuring production batch completed successfully.
• Involved in creating the Mapping between source and target using ODI.
• Created and Tested ODI packages and scenarios for unit and integration testing process.
• Worked on different unit test cases and prepared test case documents for data verification.

ODI developer

Confidential

Environment: ODI 11g, Oracle 11g, SQL Developer

Responsibilities:

• Analysing and understanding Functional specification documents
• Involved in preparing low level specifications from high level specifications.
• Migrating the Data from Different Source systems to target systems
• Involved in Creation of different Objects in ODI like Interfaces, Variables, Sequences, Packages.
• Created Data servers, Physical Schema, Logical Schema, Contexts using Topology Manager and Monitored Execution of mappings using operator
• Involved in customization of existing knowledge modules to meet customer expectations.
• Created various mappings from source to target using Topology and Designer Navigator.
• Resolving job failure, investigating long running jobs, restarting and forcing completed jobs, ensuring production batch completed successfully.
• Resolving the bugs raised by QA team at the time of System testing.