EMILDAH SIBANDA

CINCINNATTI OH *****

acw18v@r.postjobfree.com / 317-***-****

SUMMARY

6+ years in the IT industry and 3+ years’ experience in OBIEE

Experience in managing Enterprise Manager, Web Console in OBIEE 11.1.1.3/5/7/9

Experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the oracle Analytics Administration Tool

Implemented security by creating roles and web groups, checks with External tables and LDP, and Object Level Security

Experienced in creating Intelligence Dashboards and reports based on the business requirements

Extensively worked with Answers (Tables, Charts, Pivots), Dashboards (Embedded Contents, Images, Reports, etc.), BI Publisher (RTF Templates), Delivers and Agents

Experience in Installation, Configuration, and Administration of OBIEE

Experience with repository development, configured metadata objects (Subject area, Table, and Column) and web catalog objects (Dashboards, Folders, Reports)

Experience in creating dimension hierarchies and level based measures

Extensive expertise in providing end-to-end business intelligence solution by configuring metadata and building analytics metadata repository, star schemas, snow flake schemas, dimensional modeling design, building business models, generating reports, and creating interactive BI dashboards

Extensive experience in building and customization of interactive dashboards with drill down capabilities using global and local filters, contextual navigation, guided analytics, Business Rules with User Identity and roles, profiles, and personalization and creating and scheduling iBots

Excellent written and verbal skills, results oriented and Self-Starter looking for challenges, Anility to rapidly learn and apply new technologies and improve processes: Self-motivated and results oriented with solid work ethic

OBIEE DEVELOPER

Ohio Shared Information Systems August 2016 – Present

Responsibilities

Worked with Administration, Users and Analysts to gather reporting requirements.

Created a star schema in the Physical Layer using Alias Tables to avoid extraneous joints.

Created connection pools, imported physical tables and defined joins in the physical and business modeling and Mapping layers of the repository.

Created hierarchy to enable drilldowns.

Used the time series model to enable the business to analyze data across Time Series.

Used the calculation wizard to create measurements in percentages.

Used the best practice of business intelligence to meet projects and company objectives.

Developed various analysis with different analytics views (Pivot Table, Chart, Pie Chart, Graph, etc.) using OBIEE and made them available on dashboards for viewing.

Created users and groups and assigned application roles to groups.

Developed standard and ad hoc reports also developed dashboards in different subject areas with different analytical views (chart view, graphs, and pivot table with drill down capability).

Used filters and provided customized prompts appropriately to avoid excessive data showing up on reports.

Created pivot table allowing managers to analyze the business from different perspectives and in an orderly summarized manner.

Created agents for job-critical levels and auditable differences delivered to dashboards, email and cell phones to assist process owners with timely decision-making.

Interacted with Management to identify key Dimensions and Measures for business performance. This allowed management to quickly focus on relevant aspects of the business and make effective and profitable decisions.

Exposure on Multi-User Development Environments (MUDE)

Environment: OBIEE 11g, OBIEE Analytics, OBIEE Dashboards, OBIEE Delivers & Agents.

OBIEE DEVELOPER

Roche Diagnostics - Indianapolis IN March 2016 – August 2016

RESPONSIBILTIES

Gathered the Business Requirements from various analytics like planners, supply and quality

Identifying the gaps and customizations required in order to achieve the EMR reports

Created/modified Metadata repository (.rpd), customized BI repository, defined/developed Physical data layer, Business model and Presentation layer using BI Administration tool

Involved in repository Configuration, Troubleshooting and Migration

OBIEE admin work: New ID creation, account modification of existing users

Implemented OBIEE security (Object level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks

Knowledge of working in MUD environment

Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics

Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables as well as Dashboard / Report-level security

Worked extensively on OBIEE 11g for RPD and Webcatalog upgrade and also created new reports

Environment: OBIEE 11g, OBIEE Analytics, OBIEE Dashboards, OBIEE Delivers & Agents.

OBIEE DEVELOPER

National Government Services September 2015 – February 2016

Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.

Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.

Used the OBIEE Admin Tool to develop the three layers in the Repository.

Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.

Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.

Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.

Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.

Defined additional views (compound, table, chart views) of the data returned by the request to visualize data in many different ways.

Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.

Created Proactive agents (iBots) and configured Interactive dashboards to alert the employees as per the requirements.

Built parameter page using image prompts that enables users to visually select the input parameters.

Created groups in the repository and added user to the groups and granted privileges explicitly through group inheritance.

Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables.

Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.

Worked on improving the dashboard performance, readability, and security.

Environment: OBIEE 11g, OBIEE Analytics, OBIEE Dashboards, OBIEE Delivers & Agents.

OBIEE DEVELOPER

Bell Techlogix Indianapolis, IN April 2015- September 2016

Provide support in the development of OBIEE components and solutions

Understand project requirements and work towards design and development of the plan layout

Develop and deploy dashboards, analytics and reports properly

Design and develop data modeling concepts using various data modeling tools like star schema and dimension modeling

Design and place data in layers varying to physical, business and presentation

Work with administrators, users and analysts to maintain exchange of reporting requirements

Use the best practices of business intelligence to meet project an d company objectives

Identify production faults and critical issues followed and troubleshoot them

Prepare monthly reports and present them to the management

OBIEE DEVELOPER

Griffin IT Services May 2013 – March 2015

Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.

Analyzed the Reporting Requirements and participated in the documentation of Business Requirements.

Developed Oracle BI Metadata repository using BI Administration tool.

Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.

Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.

Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.

Developed measure for time comparison using time functions, ToDate and Ago.

Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.

Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.

Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.

Implemented security based on LDAP Authentication.

Configured Measures in the Business Model Layer and mapped to multiple logical table sources.

Created schedulers and developed iBots to deliver reports and dashboards to the subscribers as per the schedules and alerts.

Created report prototypes and presented them to users to get approval.

Attended weekly meetings with BA and Stakeholders for project status updates.

Performed unit and integration testing of reports and dashboards.

OPERATIONS SPECIALIST / DATA CENTER ADMINISTRATOR

JW Marriott Indianapolis IN February 2011 – May 2013

Responsibilities

Installed software, patching and assisted in upgrading and maintenance of operating systems

Provided extensive technical support, troubleshooting and diagnosing software, hardware and enterprise level applications

Configured remote systems and software to allow integration into network

Installed appropriate hardware and software in an effort to integrate legacy equipment

Supported end users with system administration, including analyzing, installing, maintaining and repairing hardware, software, peripherals and networks

Established a help desk remedy using a backup/ recovery procedure

Assisted in implementation of a desktop video teleconferencing environment

Assisted in creating new accounts, moving existing mailboxes and distribution lists

Configured and managed servers in the network

EDUCATIONAL BACKGROUND

AS Degree in Computer Science – Gweru Polytechnic College

Certifications

Certified Oracle Business Intelligence Enterprise Edition (OBIEE)

Information Technology Systems Administration Program Certificate - MyComputerCareer

Microsoft Technology Associate – Networking Fundamentals

Microsoft Technology Associate – Windows Operating Systems

Microsoft Technology Associate – Server Administration

Microsoft Technology Associate – Security Fundamentals

References

Available upon request

Contact this candidate