Obiee Developer Resume
5.00/5 (Submit Your Rating)
SUMMARY:
- BI Answers, BI Publisher, BI Interactive Dashboards
- OBIEE complete life cycle; business requirement gathering, analysis, design, data modeling.
- OBIEE Metadata Repository (RPD)
- Design of customized interactive dashboards using drill down, guided navigation, prompts, filters, and variable.
- Oracle BI integration / Microsoft tools for ad - hoc reporting
- Oracle BI Server, BI Administration Tool, Oracle Enterprise Manager
- SQL, T-SQL and basic knowledge of PL/SQL
- Multi User Development (MUD) Environment check out repository, make changes and complete the merge process.
- System Integration Testing (SIT) and User Acceptance Testing (UAT)
- Microsoft office: Excel, Word, Project, PowerPoint
- Reporting tools: SSRS, Cognos, Crystal
PROFESSIONAL EXPERIENCE:
OBIEE Developer
Confidential
Responsibilities:
- Collaborate with business users to capture & define business requirements and contribute to designing and defining the appropriate data warehouse BI solution, which includes prototyping/demonstrating BI solutions.
- Design, develop and implement BI metadata/logical data models.
- Design, develop and implement complex BI user interface objects (e.g. reports, analytics, ad-hoc queries, dashboards, etc.)
- Determine whether measure calculations and processing should be done in ETL or metadata.
- Determine requirements for aggregate tables, design and support BI security model.
- Develop technical design documents and BI specifications that in corporate BI development standards & best practices.
- Load ETL mappings, Database objects and other data movement objects to Metadata Manager
- Troubleshoot performance issues of a BI environment and evaluate existing logic for tuning possibilities
- Enhance, maintain, and support existing OBIEE reports and dashboards using BI Publisher, Answers and Dashboards.
- Develop Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
- Provide production support for existing BI applications, which includes communicating with business users on their technical and non-technical questions/problems and work on new BI development initiatives simultaneously.
- Analyzes functional requirements, procedures, and problems to automate processing or to improve systems.
- Identify reporting/analytics improvement opportunities and provide proactive, consultative strategic solutions.
Business Intelligence Analyst
Confidential
Responsibilities:
- Gathered reported and analyzed requirements, and document reporting specifications.
- Designed, developed and implemented RPD (all layers: Physical, Business, and Presentation).
- Developed reports and dashboards using pivot tables, charts, and view selector and developing Oracle OBIEE Metadata repository for the .rpd model using aggregates, dimensions, hierarchies, and time series functions.
- Responsible for dimension hierarchies and level based measures, built time and calculated measures of a fact table.
- Created and scheduled iBots in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
- Designed and developed activities across the components of OBIEE including Oracle BI Answers, Oracle BI Interactive Dashboards, Oracle BI Publisher and Oracle BI Delivers.
- Responsible for application execution performance tuning utilizing SQL developer including creating aggregate tables, caching an event polling tables.
- Responsible for Variable Manager to define sessions and repository variables.
- Responsible for design, development, testing, maintenance, support, and documentation of OBIEE platform.
- Created groups in the repository and add users to the groups and granted privileges explicitly through group inheritance.
- Tested and modified OBIEE security for the internal controls environment.
- Assisted in developing identification processes for improving validation within the data collection process.
Accounting Analyst
Confidential
Responsibilities:
- Compiled and analyzed financial information to record transactions, prepare reports, review and verify accuracy.
- Prepared monthly fiscal reports for management, identifying budgetary status and concerns and providing an analysis and recommendations to management.
- Prepared balance sheet, profit and loss statements, consolidated financial statements, and other accounting schedules and reports.
- Verified, and reconciled all cash transactions against internal accounting and bank records.
- Established and updated KPI’s and dashboards to facilitate the decision-making and performance management processes.
- Supported budget and forecasted activities to achieve the overall organizational goals and objectives.
- Assisted in development and implementation of new processes and procedures to enhance the workflow of the department and supporting the operating elements of the organization.
