PROFESSIONAL SUMMARY:

• 8+ Yrs. of experience in various modules of Oracle Applications 11i/R12 with strong experience in OBIEE 11g.
• Strong expertise in OBIEE 11g in designing and implementing complex OBIEE architectures with excellent knowledge of Oracle E - Business Suite.
• Excellent knowledge in Data warehousing and BI concepts. Strong experience in developing Ad-hoc as well as Analytical reports.
• Extensive experience with architecting OLTP/OLAP databases
• Strong experience in Designing OBIEE Business Models (star schema, dimensions, and calculations) and following industry best practices.
• Strong expertise in developing OBIEE Repository Document (RPD) from scratch, and implementing advanced features of OBIEE.
• Designed complex dashboards and answers, along with developing complex Hierarchies, KPI’s, Drill down, and Drill through reports according to customer requirements.
• Strong experience in developing reports by converting existing SQL reports to OBIEE reports/dashboards.
• Strong expertise in OBIEE Performance Tuning, and Aggregate designing.
• Strong expertise in Oracle Applications (11i and R12) with emphasis on Fixed Assets, Oracle Projects, Oracle Grants Accounting, HR and CRM Modules.
• Strong experience in Confidential and Noetix Analytics products. Extensive experience in developing, customizing and maintaining Confidential .
• Hands on experience in Oracle prepackaged BI Applications (BI Apps).
• Strong programming skills in SQL and PLSQL with extensive experience in Performance tuning, and Partitioning.
• Excellent knowledge in ETL tools such as Informatica Power Center.

SKILL:

Key Skills: OBIEE Architect | Oracle EBS | Data Warehousing | ETL & Dimensional Model Implementation| Informatica| PLSQL | SQL

Domains: Business Intelligence| ERP | Data warehousing| BI Reporting

Technologies: Oracle EBS R12/11i| OBIEE 11g | Informatica PowerCenter 9.x | PLSQL | SQL Oracle 11gR2, 10g | Confidential | Noetix Analytics | Cognos

KEY PROJECTS EXECUTED:

Confidential, San Jose, CA

Technologies: Data Warehousing, Noetix Analytics, OBIEE, Informatica

OBIEE Architect - Lead Consultant

Responsibilities:

• Designed Confidential OBIEE Star schema Model containing multiple dimensional hierarchies, aggregate navigation and complex calculations.
• Designed and developed complete OBIEE architecture for Confidential
• Create ETL to populate the star schema using fast data movement techniques.
• Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture.
• Identify, recommend and implement ETL process and architecture improvements.
• Coordinated with ETL developers on delivery of tables, columns, ETL loads, and performance enhancements
• Developed Metadata repository, configured metadata in the Business Model Layer & Physical Data Model and maintaining Web-Catalog Objects (Dashboard, Pages, Folders, Reports) as per the data requirements using OBIEE 11g/10g Server Admin and web tools.
• Designed and developed complex OBIEE dashboards. Developed complex report containing 80 sub reports with complex drill through and drill down logic.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Conduct impact assessment and determine size of effort based on requirements.
• Familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques and tools to support task performance.
• Worked on “Security Realms” in Oracle Weblogic Server-Administration Control to configure "Users and Groups" and "Roles and Policies", granting OBIEE access and query privileges using BI Presentation services.
• Tuned the performance of the dashboards to achieve sub second response time.
• Designed complex informatica mappings, sessions and workflows.

Confidential, Burbank, CA

Technologies: OBIEE 11g, Noetix Analytics

Development Lead

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design.
• Designed and developed complex dashboards covering various functional areas of Oracle Depot repair, Order Management, Projects and Fixed Assets modules.
• Created numerous executive level reports and Dashboards to provide insight into the HR reporting
• Designed and developed OBIEE Metadata repository (.rpd) that consisted of Physical layer, business model and Mapping layer (Aggregates, Dimensions and time Series functions) and presentation Layer.
• Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, Alias and Extension tables as well as Foreign and Complex joins.
• Developed many Reports using different Views (Pivot Table, Chart, and Column Selector), Interactive Dashboards with drill-down capabilities, charts, tabular using Dashboard and Page Prompts.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer created numerous executive level reports. Dashboards were generated to provide insight into the financial data.
• Worked extensively with existing data teams to understand the customer requirements and built reports according to those needs.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Designed and developed RPD document and implemented advanced drill down features, and Drill through features.
• Performed performance tuning of dashboards to make sure data returns in few seconds.
• Developed Test Plan including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs.

Confidential, Minneapolis

Technologies: Oracle Apps R12, Confidential, Oracle Discoverer

Sr. Applications Engineer

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design
• Thorough understanding of various functional areas in Oracle Apps R12 Tele service, Field Service, Depot Repair and Install Base module. Developed functional specifications document and technical specifications document for the Confidential .
• Designed and Developed Confidential for Oracle Apps R12 Tele service, Field Service, Depot Repair and Install Base module. Conducted various rounds of functional and technical discussions. Tested the functionality of Confidential against various versions of Oracle Apps R12.
• Designed, developed, coordinated and tested the new security feature of Confidential . This security feature enabled Noetix administrator to provide the same and even better security than Oracle Apps
• Thorough functional testing of Confidential product. Involved in Unit Testing and performance testing for reports.
• Expertise in Oracle Discoverer in Creating various business areas, user views, custom folders and joins for reporting.
• Developed various custom business areas by using the Discoverer for various modules.
• Created complex folders and created Item Classes.

Confidential, San Jose, CA

Technologies: Oracle EBS 11i - Core HR, IBM Cognos

Senior Applications Engineer

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design
• Thorough understanding of various functional areas in Oracle Apps 11i HR module. Developed functional specifications document for the Confidential .
• Designed and Developed Confidential for Oracle HR module. Conducted various rounds of functional and technical discussions. Tested the functionality of Confidential against various versions of Oracle EBS 11i.
• Designed, developed, coordinated and tested the new security feature of Confidential . This security feature enabled Noetix administrator to provide the same and even better security than Oracle Apps.
• Thorough functional testing of Confidential product. Involved in Unit Testing and Performance Testing for reports.

Confidential

Technologies: Oracle EBS 11i - GMS, PA, FA

Application Engineer

Responsibilities:

• Understand functionality of wide range of Oracle EBS suite modules including Oracle Grants Accounting module (GMS), Oracle Projects (PA), and Oracle Fixed Assets (FA).
• Created the requirements spec for the team and prepared the functional specifications documents and technical specifications documents.
• Designed and developed Confidential for 11i. Conducted various rounds of functional and technical discussions. Tested the functionality of Confidential against various versions of Oracle EBS 11i.
• Designed, developed, coordinated and tested the new security feature of Confidential . This security feature enabled Noetix administrator to provide the same and even better security than Oracle EBS
• Tuned lots of Confidential to return data in sub seconds. As the company grew so did data on which Confidential ran grew. This required us to enhance the performance of Confidential by changing the view code to return data in few seconds.
• Designed, developed and tested reports in Discoverer, Cognos and Business objects. Designed and developed sample reports to provide customers a framework to develop reports using Confidential .