Profile of Chogugudza
Chogugudza Oracle Certification
As a highly skilled and experienced OBIEE Business Developer, Analyst, and Reporting Specialist with over seven years in the industry, I possess expertise in:
* Requirements elicitation, data analysis, and functional/non-functional documentation
* Oracle OBIEE report/analysis creation and administration
* Data warehousing, aggregation rules, data analytics, and data insights
* Complete Software Development Life Cycle (SDLC) with Agile/Scrum and Waterfall methodologies
* Dimensional modeling, complex join creation, and design of Star and Snowflake Schemas
* Product quality assurance, including unit testing, peer testing, and User Acceptance Testing (UAT)
* OBIEE troubleshooting, performance tuning, and cache mechanisms
* Data modeling and database querying
* Creation of user-friendly, intuitive Answers reports, interactive dashboards, and deliverables
* Providing Business Intelligence solutions that drive competitive advantage
Skills:
**Core Competencies:**
* Proficient communication skills (verbal, written, virtual)
* Strategic thinking, problem-solving, and solution-driven mindset
* Team orientation, motivation, and leadership abilities
* Self-starter, quick learner, and impeccable time management
* Excellent decision-making, analytical, and multi-tasking skills
* Attention to detail, minimal direction required
* Exceptional interpersonal and organizational skills
* Ability to collaborate effectively across teams and levels
**Specialized Skills:**
* Eliciting business and system requirements and documenting functional and technical specifications
* Design of Use Case, Activity, Sequence, Class, and Data Flow Charts and Diagrams
* Knowledge of Data Warehousing, Dimensional Modeling, ETL, OLAP, and Oracle BI Applications
* Experience with ETL Tools, problem-solving, and analytical skills
* Definition of Key Performance Metrics (KPIs), facts, dimensions, and hierarchies
* Proficient in designing star and snowflake schemas for business physical and logical models
* Strong modeling of Physical/Business Model Mapping/Presentation layers of OBIEE Metadata (.rpd) using Oracle BI Administration Tools
* Proficiency in configuring OBIEE objects (variables, analysis, interactive dashboards, reports)
* Providing guided navigation, prompts, filters, and agents to advance business deliverables
* Creation of queries, formatted views, and graph charts for interactivity and dynamic content
* Use of Variable Manager to define session and repository variables
* Application of initialization blocks to streamline administrative tasks and modify metadata content
* Design of Dimensional Hierarchies, Level Based Measures, and Multiple Table Sources
* Scheduling of agents and deliverables in Oracle BI for real-time and actionable intelligence
* Performance tuning, cache management, aggregate tables, and index optimization
* OBIEE Security configuration using LDAP and External Database Tables for object and database level security
* Performance Tuning and troubleshooting using aggregation cache and variables
* Creation of views, maps, trellis, pivot tables, graphs, and maps for data visualization
* All phases of the System Life Cycle
* Use of OBIA HR Analytics and Financial Analytics for Human Resources and Enterprise Resource Planning
**Software Applications and Programming:**
* Business Intelligence Tool: OBIEE 10/11g
* Database Tools: TOAD, Oracle SQL Developer, Oracle Data Integration (ODI) (OBIA), (OLTP, ETL, OLAP)
* Languages: SQL, PL SQL, JavaScript, HTML, XML Windows
* Business modeling Tools: MS Visio, MS Project, Unified Modeling Language (UML)
* Methodologies: Software Development Life Cycle (SDLC), Agile methodologies (Scrum, Waterfall)