OBJECTIVE:

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

SUMMARY:

• 8+ 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, Procurement & Spend Analytics pointing to source systems like Oracle EBS.
• 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 Migrating Oracle Data Integrator (ODI) from version 11g to 12c by using fusion middleware 12c upgrade assistant.
• Worked with multiple sources such as Relational database, Flat 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 in OBIEE 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

Data Warehousing Tools: Oracle Business Intelligence 10g/11g, Oracle Data Integrator 11g,12 C, OBIA 11g

Informatica Scheduling Tools: Control-M, AutoSys

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

Environment: : ODI 12c, OBIEE 11g, Oracle 11g, WebLogic 10.3.6, Unix shell Scripting.

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.
• Developed Different Reports with different Analytic Views (Tables, Pivot Tables, Charts, Column and View Selectors, Narrative, Tabular with Global and Local Filters) using presentation services.
• Configured Scheduler by 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 using Time Series Objects and 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

Environment: ODI 11g,OBIEE 11g, Orcale 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

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.

Confidential

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.