SUMMARY

• Having 10+ Years of total Information Technology Industry experience in Oracle Applications R12, OBIEE 11g & 12c with excellent written and oral communication skills
• Having 5 years of experience in Design and Develop OBIEE Metadata (.rpd) and Dashboards/Reports using 10.x and 11.x
• Having Good knowledge on Architecture of Oracle Business Intelligence Enterprise edition 10g/11g
• Good understanding in Oracle Data Integrator (ODI 11g) - ETL Mapping Configuration and ETL Scheduling.
• Skilled in Security Setup, configuration of Analytics Metadata objects, Web Catalog Objects
• Having good exposure in data warehousing administrator Console (DAC)
• Expertise in developing reports with drill-down & drill-across capabilities using global & local Filters where and in which applicable
• Good Knowledge of Data Warehousing concepts and Dimensional modeling like Star and Snowflake schema
• Hands-on experience in implementing SCM Modules like P2P (Procure to pay) and OTC (Order to Cash)
• Well conversant with Application Implementation Methodology (AIM)
• Good experience in XML/BI Publisher, which includes working on report development objects like Data templates and RTFs
• Expertise in SQL, PL/SQL, Reports Design and Development, Form Personalization, Alerts, Shell Script, XML Reports and SQL Loader, Serena PVCS, BMS remedy tool.
• Having knowledge on Oracle INV, PO, OM, BOM, WIP, AP, AR and GL
• Good knowledge in Informatica

TECHNICAL SKILLS

Language: SQL, PL\SQL

Databases: Oracle 9i, 10g, 11g

OS: Windows, UNIX

GUI: Forms & Reports 6i, 10g

ERP: Inventory, PO & OM

ETL: ODI

BI: OBIA, OBIEE

PROFESSIONAL EXPERIENCE

Confidential, Winston Salem, NC

Senior Technical Consultant

Responsibilities:

• Involved in requirements gathering, analysis, design, used various data sources, development and implementation of the project.
• Implemented complex integration/use case of Oracle products.
• Worked on highly critical production related issue.
• Performed Cache Management.
• Developed Delivers iBots/Agents to automate report delivery and provide alerts on Interactive Dashboards.
• Implemented various Repository Variables and System Variables depending up on user requirements.
• Have performed several product related customization to alter out of the box product behavior.
• Took the ownership of upgrade activity in client environment from OBIEE 11g to OBIEE 12c version and fixed multiple migration issues in the process.
• Involved in diagnosing and fixing ODI 11g mappings failure during the load run.
• Responsible for building and maintaining client relationships-managing operational challenges and building efficiencies in the process.
• Implemented Aggregate tables for better Performance. Enhance performance by managing Cache management.

Environment: Oracle EBS, ODI, OBIEE 11g & 12c, PlSql, SQL

Confidential

Senior Technical Consultant

Responsibilities:

• Involved in requirements gathering, analysis, design, used various data sources, development and implementation of the project.
• Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer) - Import tables, Identifying Facts, Dimensions, created physical tables, join the tables, creating the logical tables and logical columns.
• Worked on Dimensional Hierarchies, Drill down, Level Based and Time series Functions based on Business Requirements.
• Worked on Repository Variables and Session Variables and Presentation variables.
• Worked on session variables and dynamic variables along with initialization blocks.
• Worked extensively on Oracle BI Answers, Delivers and Interactive Dashboards.
• Implemented Aggregate tables for better Performance. Enhance performance by managing Cache management.
• Configured many dashboards with different views like Pivot table, Chart, Tabular and View Selector and guided navigation links.
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Designed Dashboards Prompts, Pages, links, Images, Embedded content, Text, Folders and Guided navigation links as per Business requirements.
• Perform Unit Testing and validating the repository. Worked on BI Publisher reports.
• Utilized Aggregation to improve query performance
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Created business reports using BI Answers as per requirements.
• Generated various Analytics Reports using global and local filters.

Environment: OBIEE 11.1.1.9, ODI 11g, Oracle and SQL

Senior Software Engineer

Confidential, San Jose, CA

Responsibilities:

• Gathered Requirements and Effort estimation for Change Requests thus prepared ‘Report Specification’ logs
• Involved in Data Model Design and used best approaches to configure Physical, Logical and Presentation Layer
• Preparing MD70, MD120 and TE20 as per the functional design
• Identified Facts and Dimensions according to the design specification and done schema design
• Created Dimension Hierarchies for Drill down facility reports
• Defined Time Series functions for Level Based Measured reports
• Created Dashboards/Pages and used global & Local filters/prompts for several reports
• Responsible for developing different kinds of reports/Ad-hoc queries using OBIEE Answers and assigned them to application specification dashboard
• Implemented Object & Data level security
• Created reports with drill-down capabilities and used presentation variables
• Trouble shooting the issues related to repository models and report development
• Have used different report views and used Guided Navigation where ever appropriate

Environment: Oracle 11i Apps, OBIEE 11.1.1.7, Oracle, SQL

Confidential

Responsibilities:

• Customized standard reports to meet the client's requirement.
• Developed a package to validate and import purchase orders to interface tables from legacy system.
• Developed interface program to upload items and Items categories into interface tables from legacy system.
• Developed several reports and Customized as per the client requirement in Purchasing and Order Management.
• Created and customized reports using XML Publisher / BI Publisher.
• Achieved custom functionality in OM Sales Order Form through form personalization.
• Created and customized reports using XML Publisher / BI Publisher.
• Involving on up gradation of various Packages, Procedures and Functions by making the R12 necessity changes like replaced the 11i obsolete tables.
• Creation of FND objects like Value Sets, Flex fields, Responsibilities, Custom Menus, Request Groups, Profile Options Setups.
• Developed Custom shipping documents based on standard pick slip, Packing slip reports.
• Personalization on Standard Pricelist form.

Confidential

Software Engineer

Responsibilities:

• Supporting the Oracle 11i ERP Solutions
• Handling Several Technical Issues
• Creating Several CSR (Custom Change Request) and processing those till to PROD by several levels of user validations
• Modified several custom reports (RDF, Discoverer and XML) and Form Personalization and Custom.pll with Additional Functionality
• Modified custom components
• Creating Oracle SR’s for Oracle Standard Issues
• Support Related Development for All Modules(INV,PO,OM,AR,AP,WIM,BOM and GL) of Confidential Production Issues
• Supporting technical issues logged in Unisys peregrine and BMC Remedy for Confidential End Users
• Supporting the Month / Quarter / Year end closing activities by generating various reports needed by the users
• Defining Concurrent Programs, Executable, Value Sets and Display Profile values
• Prepared Technical Design Documents (MDO70) and Migration Documents (MD120)