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.