Obiee Consultant Resume
Albany, NY
SUMMARY
- Over 15 years of experience in various reporting tools like OBIEE, Oracle Reports 2.5, 6i, 8i, 10g, 11g, BI Publisher, XML Publisher, Tableau, Qlikview, Crystal reports and Discoverer.
- Over 8 years of experience in Business Intelligence Applications using Oracle Business Intelligence (OBIEE) / OBIA and BI Publisher.
- Over 15 years of experience in Oracle Financials (EBS) as a techno - functional mainly in Finance modules.
- Expertise in Oracle BI Apps EBS Financial Analytics- AR, AP, GL and CRM Analytics - Service and Contact Center Analytics.
- Expertise in Informatica for the Extraction, Transformation and Loading from various sources to the enterprise data warehouse.
TECHNICAL SKILLS
BI: OBIA, OBIEE 11g, 10.1.3.2/ 10.1.3.3/ 10.1.3.4/11 g, BI Publisher 11.1.1.6, 11.1.1.7
ORACLE Applications: Oracle Financials Rel. 12, 11.5.10, 11.5.8, 11.0.3, 10.7 and 10.6
ORACLE Financials: Accounts Receivables, Accounts Payables, PO, General Ledger, Fixed Assets, Inventory, Order Management, CM, Application Object Library, Oracle Project s.
Database: Oracle 11g, 10g, 9i, 8i, 7.x/6.0, MS Access. MS SQL Server 2000/2005/2008
Tools: OBIEE, BI publisher, QlikView 11.x, Tableau, Informatica, Teradata, Oracle Forms 6i, Reports 6i, Developer/2000 (Forms 4.5, Reports 2.5), Designer 2000, Visual Basic 4.0/3.0, Oracle Reports 2.0/1.1, SQL, SQL*Loader, TOAD, Workflow Builder, XML Publisher, Discoverer 4.1,10g, Data Loader, ADI
Languages: PL/SQL, SQL*Plus, Pro*C, C, Basic, Pascal, FORTRAN
Implementing projects, end to end testing and user acceptance testing:
Operating Systems: HP UNIX 2000, Sco-Unix 5.0, Windows 3.1, Windows 95, Windows,98/NT/2000/XP, 7
Hardware: IBM PC Compatibles, Compaq Pentium
Testing: HPQC
Version Control Tools: PVCS, ClearCase, SVN
PROFESSIONAL EXPERIENCE
OBIEE Consultant
Confidential, Albany, NY
Responsibilities:
- Currently working on BI Apps Service Analytics, Contact Center Analytics.
- Designing and testing reports and creating ad-hoc reports as per the business requirements.
- Customizations on the OOTB RPD file for Oracle Siebel CRM Service Analytics. creation of hierarchies, level based measures, fragmentation etc. as per best design principles and business requirements
- Assisting with design and development of repository (creating/Modifying objects in Physical, Business and Presentation layer) and the process of repository migration
- Implement Object level security for the users who would be using the OBIEE system
- Assist in the migration of the catalog objects/ repository from lower environments to the higher environments.
- Design, build and test new OBIEE reports including BI Publisher, Dashboards and Answers.
- Mentor report analysts in OBIEE report application use and development
- Research and resolve technical problems associated with the reporting applications
- Provide senior guidance on OBIEE Presentation Services and report optimization techniques.
OBIEE Developer
Confidential, Vancouver, BC
Responsibilities:
- Worked on OBIEE Analyses and BI Publisher pixel perfect reports in 11.1.1.7.0
- Worked on OBIEE Answers.
- Worked on Drill down reports, getting dynamic images into the reports.
- Worked on developing ad-hoc reports based on the business requirement.
- Worked on Graphs, Pivot tables in the Dashboards and BI reports for the presentations.
ERP Support Analyst
Confidential
Responsibilities:
- Worked on customizing OOTB RPD for Oracle Financials for AR, AP, GL Subject Areas
- Worked on Graphs, Pivot tables in the Dashboards and BI reports for the presentations.
- Worked for production support for various projects mainly in finance modules like AP, AP, GL, INV, FA and PO.
- Created business reports using BI Answers as per requirements.
- Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
- Created Technical Design Documents (TDDs) for OBIEE Semantic Layer, BI publisher Reports.
- Managed security privileges for each subject area and dashboards according to user requirements
- Worked on various reports in Finance Modules using Discoverer Plus
Lead Consultant
Confidential
Responsibilities:
- Worked on Oracle Financial Analytics on Receivables, Payables and general ledger modules.
- Customized various Reports in Oracle Applications Modules GL, AP, AR, FA and Projects.
- Designed and tested reports in Dashboards for the Oracle Financial Analytics modules like AR, AP, GL and created ad-hoc reports as per the business needs.
- Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
- Customized the OBIEE Repository (physical, BMM, and presentation layers).
Lead Consultant
Confidential
Responsibilities:
- Successfully Developed and customized Oracle Applications Modules GL, AP, AR, OM, PO.
- Developed OBIEE Financial Reports using BI Publisher 10g and XML Publisher.
- Used the OBIEE 10.1.3.3.x Administration tool to develop and enhance meta-data.
- Worked extensively with Physical Layer, Business Layer and Presentation Layer.
- Worked and Involved in Semantic Layer of OBIEE.