We provide IT Staff Augmentation Services!

Oracle Support Consultant Resume

5.00/5 (Submit Your Rating)

Houston, TX

SUMMARY:

  • Experienced and attentive to detail, possessing a high aptitude of leveraging technology.
  • Skilled communicator able to build strong working relationships with clients various stakeholders.
  • Experienced in using Oracle EBS Financial Modules.
  • Experienced in using OBIEE 11g.
  • Expertise in designing and developing custom reports.
  • Skilled in building Interactive Dashboards with drill - down capabilities.
  • Extensive experience in OBIEE/ Presentation Services.
  • Practical understanding of Data modeling.
  • Have experience integrating Essbase with OBIEE 11g .
  • Experienced in interacting with users conducting interviews, gathering analyzing and documenting user needs then rolling out deliverables.

FUNCTIONAL SKILLS:

  • Requirements gathering, creating functional design, data analysis, customizations
  • Oracle EBS Financials: AP, AR, FA, CE and GL

TECHNICAL SKILLS:

  • BI Publisher, OBIEE 11g,
  • Databases: Oracle 11g
  • DB Analysis Tools: SQL* Plus, SQL Developer, TOAD
  • Languages: PL/SQL, SQL,MDX
  • Operating System: Windows and Linux

PROFESSIONAL EXPERIENCE:

Oracle Support Consultant

Confidential

Responsibilities:

  • Supported daily production and interacted with business users.
  • Developed, configured dashboards, answers, requests, prompts and BIPublisher reports.
  • Designed Oracle BIPublisher data models, data sets and templates.
  • Updated systems to meet new requirements for various EBS Modules.
  • Developed Unit Testing Scripts and Systems integration Testing of Interfaces and other custom solutions
  • Executed ad-hoc SQL queries to review data upload and assist with data mapping issues, identifying functional requirements for custom programs then communicated required updates to developers.
  • Executed change management using end user training and consultation to align business with the new designed process.

OBIEE LEAD

Confidential

Responsibilities:

  • Performed installations, upgrades and enhancements to the OBIEE environment and supported testing plus training of application related functions.
  • Worked on OBIEE 11g security issues.
  • Successfully installed OBIEE 11g environment for CFO’s Risk team.
  • Integrated Essbase ASO, BSO cubes with OBIEE.
  • Expertise in debugging, optimizing the performance tuning of OBIEE repository & dashboards/reports administration and Configuration of OBIEE.
  • Used Essbase as data source for OBIEE Repository (RPD).
  • Served as the SME on OBIEE in cross team meetings and initiatives

OBIEE DEVELOPER

Confidential, Houston, TX

Responsibilities:

  • Designed developed and deployed RPD in all three layers.
  • Designed and developed Data modeling and Analysis using Dimensional Data Modeling, Star Schema modeling.
  • Created dimensions, hierarchies, aggregates and keys in the BMM layer and created new logical columns.
  • Designed, developed and implemented complex BI interface (objects, reports, analytics, ad-hoc queries, dashboards etc.)
  • Created and scheduled Agents to provide real-time, personalized and actionable intelligence for relevant users.
  • Designed and supported BI Security model. And created variables.

ORACLE FUNCTIONAL CONSULTANT

Confidential, San Jose, CA

Responsibilities:

  • Requirements gathering, fit/gap analysis and process flows.
  • Worked on Oracle modules covering: Procure to Pay (P2P), Oracle General Ledger (GL), and Accounts Receivables (AR).
  • Responsible for coordinating and assisting the entire phase of the P2P part of the project which included initial operations analysis, business process re-evaluation, preparation of configuration and set up document and testing for AP.
  • Was responsible for addressing Operational issues, concerns and questions by users and providing training for them on GL, AR and AP

BUSINESS ANALYST

Confidential

Responsibilities:

  • Tasked with recommending best practices for design and implementation of BI solutions and for testing and usage of OBIEE.
  • Served as advisor for client with regards to OBIEE technical issues.
  • Created custom reports and dashboards.
  • Was active in solving complex and program wide OBIEE initiatives, including upgrades, new functionality, security, performance, etc.
  • Responsible for creation and modification of the OBIEE RPD.
  • Worked in a Multi-User Development Environment (MUDE) with OBIEE Developers

INBOUND SUPERVISOR

Confidential, Indianapolis, IN

Responsibilities:

  • Maintenance of reports and execution of daily/weekly/monthly reporting processes.
  • Ran Ad-hoc SQL queries in an Oracle 10g Database, as needed for reporting.
  • Establishing a working and support relationship with staff as well as third party vendors.

We'd love your feedback!