Oracle Support Consultant Resume
4.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 wif clients various stakeholders.
- Experienced in usingOracle EBS Financial Modules.
- Experienced in usingOBIEE 11g.
- Expertise in designing and developing custom reports.
- Skilled in building Interactive Dashboards wif drill - down capabilities.
- Extensive experience in OBIEE/ Presentation Services.
- Practical understanding of Data modeling.
- Have experience integrating Essbase wif OBIEE 11g .
- Experienced in interacting wif users conducting interviews, gathering analyzing and documenting user needs tan rolling out deliverables.
TECHNICAL SKILLS
Oracle EBS Financials: AP, AR, FA, CE and GL
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 wif 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 wif data mapping issues, identifying functional requirements for custom programs tan communicated required updates to developers.
- Executed change management using end user training and consultation to align business wif teh new designed process.
OBIEE LEAD
Confidential
Responsibilities:
- Performed installations, upgrades and enhancements to theOBIEEenvironment and supported testing plus training of application related functions.
- Worked onOBIEE11g security issues.
- Successfully installedOBIEE11g environment for CFO’s Risk team.
- IntegratedEssbaseASO, BSO cubes wifOBIEE.
- Expertise in debugging, optimizing teh performance tuning ofOBIEErepository & dashboards/reports administration and Configuration ofOBIEE.
- Used Essbaseas data source forOBIEERepository (RPD).
- Served as teh SME onOBIEEin 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 teh BMM layerand 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 teh entire phase of teh P2P part of teh 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 wif recommending best practices for design and implementation of BI solutions and for testing and usage of OBIEE.
- Served as advisor for client wif 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 teh OBIEE RPD.
- Worked in a Multi-User Development Environment (MUDE) wif 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 wif staff as well as third party vendors.