SUMMARY

• Oracle Applications: Oracle Business Intelligence
• 4 years of Business Development Consulting experience
• 4 years of Oracle experience 10.1.1.6 - 11g
• E-Business Suite: BI Interactive Dashboards, BI Answers, BI Publisher, Delivers, BI Plug-in for Microsoft Office
• Tools: Microsoft Office Word, Excel, Access, Outlook, PowerPoint, Projects, and Visio, PeopleSoft
• Operating Systems: Windows XP, Vista, 7 and 8
• Web development: SharePoint 2010
• Other Skills: Business Development, Quality Assurance
• ERP: Hands on experience implementing the complete life cycle of ERP projects from design, gap analysis, development, unit testing, system testing, implementation, deployment and support in Oracle Applications 10g and 11g
• Oracle Tools: Business Intelligence, Web logic

EXPERIENCE

Confidential

OBIEE Developer

Confidential

• Lead OBIEE Developer implementing a three track phased OBIEE 11G project with an out of the box customized instance.
• Implemented a training schedule transferring knowledge to15 BI end users with novice experience in BI Analytics.
• Created and Implemented User Security roles and accounts.
• Trained IT end users in BI Analytics resourcing in Building new analytics, filters, Analytic prompts, Dashboard creation, Building Dashboard prompts and creation of system and session variables.
• Customized RPD in coherence with clients' needs.
• Customized Out of the box Dashboards to client's specifications, added new filters to existing analytics added Analysis and dashboard prompts.
• Documented customization procedures.
• Created new Analysis and reports deriving from Out of the box subject areas.
• Migrated development from the Development Environment to the Production Environment using Catalog manager and Archive and Unachieve functionality in Analytics Catalog folder.
• Created and executed Repository Variables.
• Implemented RPD customizations in the Development and Production Environment.
• Uploaded Repository changes with Enterprise Manager.
• Migrated Data warehouse tables into Repository Physical Layer.
• Created relationship between dimensions and facts in BMM layer
• Created multiple Subject areas In the presentation layer to carter client's needs.

Confidential

OBIEE Developer

• Experience on OBIEE 11.6.0 and PL/SQL
• Involved in business requirements gathering and translated the requirements into technical requirements.
• Developed BI reports in three environments Development, UAT and Production
• Close liaisons with project managers for the whole lifecycle of report development
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Ran extensive database quarries
• Wrote PL/SQL quarries to create new tables, update existing tables.
• Imported table columns into existing Repository tables.
• Implemented fragmentation for three geographies on new repository tables
• Created numerous repository variables.
• Assembled subject areas and created execution plan and accommodated the new mappings.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Built Unified Sub Ledger dashboards reports consisting of Summary, Transactional, Aging, Rollfoward and Variance reports.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Developed presentation variables.
• Developed an extensive Rollfoward report with PTD and LTD variations
• Carried out extensive review of Development environment.
• Oversaw UAT and Production migration of reports.
• Resolved CM tickets as per business end user requirements.
• Trained End Users and Pilot Users about OBIEE Tools.

Confidential

Developer

• Interacted closely with Functional Analysts and Business Users in the client side, and designed the system accordingly.
• Created customized metrics for client such as Accounts payable, Receivable and Variables
• Performed the gap analysis, Identified Facts and Dimensions with levels hierarchy and made required changes to the Data Model Physical, Business and Presentation layer .
• Experience on OBIEE 11.1.1.5
• Involved in setting Up MUDE in the organization.
• Configured Agents to send the Reports through Emails to the user group.
• Developed Parent Child Hierarchies in the repository.
• Identified granularity level of the financial data required to be available for analysis.
• Extensively used page prompts and dashboard prompts for filtering data values in financial reports.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc report according to the client needs.
• Used Table and pivot table to display hierarchical columns.
• Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE Answers.
• Used conditions to determine whether agents delivered their content and executed their actions.
• Created Time- Series calculations in the BMM layer.
• Created session variables for users to provide row- level data level security and used the session variable in OBIEE Answers to build the query.
• Used presentation variable in OBIEE Answers to save prompt values and use them for conditional formatting.
• Developed different Dashboards/Reports with different views Calculation, Detailed, Pivot, Charts, and Filters and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.
• Scheduled IBots and seeded server cache using Delivers to improve system performance. Scheduled reports to be e-mailed using BI Publisher Scheduler.
• Coordinated the RPD and Web Catalog objects migration from Development environment to QA environment and then to the Production environment using OBIEE Catalog Manager.

Confidential

Developer

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Prepared Design Specifications based on functional requirements of business and produced Technical Design Documents.
• Designed and built Repositories in accordance to business needs.
• Customized Dashboard pages as per business need e.g. Marketing, Field Sales, etc.
• Implemented dynamic dashboard prompts as per business requirement e.g. zooming into particular segments of the business in a performance-optimized manner.
• Transformed change management procedures.
• Implemented performance tuning measures including data caching.
• Adhoc query reporting to support the business requirements.

Confidential

Developer

• Collaborated with Business contacts Business Analysts in the analysis and preparation of OBI data requirements.
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
• Created dimensions, aggregations and keys using admin tool. Customized Physical Layer, BMM Layer and Presentation Layer using OBI Administration tool.
• Developed Global prompts, Filters, customized Reports and Dashboards using OBI presentation services.
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards Financials as per the detailed design requirements.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc reports according to the client needs.
• Managed the intelligent dashboards by using dashboard, page and report level security.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Worked on OBI presentation Answers to build Interactive Dashboards with drill-down capabilities.