Forbes Chaimiti

Columbia Maryland

adlmqh@r.postjobfree.com

OBIEE 11g/12c /OAS/OAC

SUMMARY OF QUALIFICATIONS

EXPERIENCE

Forbes is a US Citizen with an expired Secret Security Clearance, an active DOE Security Clearance, and over 10 years of experience in OBIEE 10g 10.1.3.4.1,

11g 11.1.1.3/5/6/7/9 and OBIEE 12c, providing end-to-end business intelligence solutions by dimensional modeling design, building business models,

creating reports and interactive dashboards.

Utilized Tableau to produce appealing data visualizations to clients and to help them make business decisions with the help of Ad hoc reporting and Dashboards.

Developed Tableau data visualization with various views such as Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.

Prepared Dashboards with calculations, parameters in Tableau and created groups, sets and hierarchies.

Used Tableau Desktop for blending data sources and creating different interactive views and dashboards.

Excellent Team member with good business acumen, effective communicator, experience in working with Business Users.

Experience with Oracle BI Server, Oracle BI Answers/ Analysis, Oracle BI Scheduler, Oracle BI Interactive Dashboards.

Created data models with various data sets using Oracle BI Publisher.

Created pixel perfect reports with various views and scheduled them via email in different formats using both OBIEE and BI Publisher.

Used parameters in BI Publisher to establish data ranges for report data as per business requirements.

Extensive experience in creating and modifying OBIEE Repositories (Physical, Business Model and Mapping, and Presentation layers) using the OBIEE Administration tool.

Extensive experience in using Dimensional Hierarchy modeling (from Granular to Global levels) and Time series modeling in the Business Model and Mapping layer to

meet business requirements.

Expertise in building star and snowflake schemas in the repository as well as using the OBIEE 11g New Join link in the physical layer.

Expertise in using Alias and Dim tables so that the hierarchy and time series modeling would meet business requirements.

Experience in using and troubleshooting the main servers: Oracle BI Server, Oracle Presentation Server, and Oracle BI Scheduler.

Expertise in designing and developing custom reports using BI Answers and making them available in Dashboards.

Expertise in managing the NQSConfig.INI files to manage the RPD, and other parameters.

Extensive experience in managing Repositories files, by comparing, and merging them as part of development.

Extensive experience in using log files to diagnose errors, and issues in OBIEE's BI Components (BI Server, BI Scheduler, BI Presentation server, BI Java Host).

Good understanding of Data Warehousing concepts that define data sources and targets.

Expertise in managing the security by creating users and groups and assigning those users to their respective groups.

Expertise in managing performance through use of cache management and aggregated tables.

Technical Skills

OBIEE 10g 10.1.3.3, 10.1.3.4/Siebel Analytics 7.x

OBIEE 11g 11.1.1.3/5/6/7/9, OBIEE 12.2.1.0/1/2/3, Data Visualization Desktop, Visual Analyzer, BI Publisher, SQL, Toad/ SQL Developer, Oracle 10g,

Oracle 11g/12c, MS SQL server Database,

DB2 9.7, Windows XP, Windows 7/10, Linux/Unix, IBM AIX, WIN SCP,

IBM tools (Clear case, Clear Quest, Command Editor)

Empower Technology Services LLC-Columbia MD

Role: OBIEE 11g/12c Instructor

Jan 2019 – Present

Virtually teach students worldwide on:

oSQL uses in OBIEE

oConcepts associated with requirement gathering.

oData warehousing concepts.

oRPD development.

oReports and Interactive dashboards creation.

oSecurity management.

oPerformance management.

oTesting.

oMigration using catalog manager/client user interface.

TEK systems/SRS/DOE- Aiken SC

Role: OBIEE 12c RPD Engineer

March 2019 – March 2020

oMet with business analyst, team lead and stakeholders to gather business requirements.

oHeld team meetings to lay out design and development of OBIEE reports by following business requirements.

oCommunicated with DBAs and ETL developers on defining data sources for development.

oStudied client reports in Excel BI and converted them into OBIEE reports.

oCreated OBIEE 12c RPD, reports and dashboards using queries generated from PeopleSoft.

oUsed Toad to query database and did gap analysis to make sure all tables and columns are available before RPD development.

oDownloaded RPD from server to make changes, and then uploaded it back to server after modifications.

oImported tables from Data warehouse, created alias tables, star and snowflake schemas.

oCreated Business models, logical calculations, hierarchies, time series models, and level-based measures in the BMM layer.

oReordered Presentation subject areas, tables and columns in the Presentation layer before uploading RPD into analytics.

oCreated patches for RPD before it was uploaded into server.

oValidated RPD by querying database and by creating simple reports in analytics.

oWorked with Admins to view log files to get clues when debugging the environment.

oCreated reports and dashboards with various views like stacked line graphs, pivot tables, view and column selectors.

oAttended presentations with clients to get their feedback on our reports and made changes to suit client.

oManaged performance in this environment by using caching and materialized views with help from DBAs.

oTutored teammates and Clients on OBIEE 12c functionality, so that they could use OBIEE to view reports on the dashboard

oCreated documents on fixes we made to so that team can become more knowledgeable when same problems occur in future.

Environments:

Oracle 12c, OBIEE 12c version 12.2.1.2/3, OBIEE 12c VM, MS PowerBI, SQL, Toad, Linux, IBM Notes, Windows 10

Omnipoint/Accenture/DOJ – Washington DC

Role: OBIEE 12c RPD Developer

July 2018- Dec 2018

oMet with business analyst, team lead and stakeholders to gather business requirements.

oHeld team meetings to lay out design and development of OBIEE reports by following business requirements.

oCommunicated with DBAs and ETL developers on defining data sources for development.

oStudied client reports in Tableau application before converting them into OBIEE reports.

oUsed SQL Developer to query database and do gap analysis to make sure all tables and columns are available before RPD development.

oImported tables from Data warehouse, and created alias tables, and the created star schemas.

oCreated Business models, hierarchies, time series models, and level-based measures in the BMM layer.

oReordered Presentation subject areas, tables and columns in the Presentation layer before uploading RPD into analytics.

oCreated prompts and filters in reports to limit amount of data seen in reports.

oCreated repository and presentation variables which we used in report filters and prompts.

oUsed BI Analytics to create reports and interactive dashboards as per business requirements.

oCreated action links, so that users can see more detail in their reports.

oMigrated the RPD, and catalog to other environments, and eventually into production using catalog manager archive and unarchive.

oManaged performance by following all RPD development best practices and use of cache management.

Environments:

Oracle 12c, OBIEE 12c version 12.2.1.2, Tableau, SQL, SQL Developer, IBM AIX, Windows 7.

M9 Solutions/ Accenture/TSA- Calverton MD

Role: OBI Reports developer

May 2017 – March 2018

Met with users, business analysts and team members to gather business requirements

Worked on Production tickets and fixed issues involving users’ reports

Used BI Publisher in this environment to create reports directly from operational data sources

Defined data sources in BI Publisher and created connection strings to access data.

Created data models with various data sets to answer user questions

Used parameters to establish data ranges for reports as per business requirements.

Created pixel perfect reports with various views (Tables, charts, gauges)

Scheduled reports to run daily, weekly and monthly so that users can get their reports via email as soon as they enter office.

Diagnosed issues with reports and jobs, and made sure things flowed smoothly

Migrated catalog objects to various environments using the Download and Upload features, as well as Archive and Unarchive features.

Trained testers, and users on OBIEE and BI Publisher functionality, so they could continue to do their jobs.

Created documentation used by various teams that showed functionality of OBIEE and BI Publisher.

Environment: Oracle Seibel CRM, OBIEE 11g/OBI Publisher, SQL, SQL Developer, Windows 7

Cohesion/ Leidos/SSA- Baltimore MD

Role: BI Tools Analyst

August 2016 – February 2017

Met with users from different departments and gathered business requirements with the help of a business analyst.

Met with team members to get organized and create design documents before development

Imported tables from the data warehouse into the physical layer

Created alias tables to allow reuse of database tables multiple times.

Created star/ snowflake schemas in the physical layer, by joining fact tables to dimension tables.

Created business models, hierarchies, Time series models, and level-based measures in the BMM layer.

Created derived logical columns with calculations as per business requirements.

Manipulated data in the Business Model and Mapping layer, by creating case statements with conditions.

Created Subject areas, presentation tables/ columns just as how users wanted to see them.

Rearranged subject areas, Presentation tables/ columns in the Presentation layer, to meet user requirements.

Created implicit fact columns in the Presentation layer to allow users to create reports with only dimension columns without errors.

Checked global consistency to avoid errors, warnings, and best practice violations.

Deployed the RPD on command line, and created reports with different views like Pivot table, Graph, Gauge, Heat Matrix, Treemap, Funnel

Created dashboards for the client to allow them to answer business questions using OBIEE.

Used OBIEE 12c data visualizer to create reports with maps and charts with pixel perfect quality

Managed performance by use of cache management and aggregate tables, to reduce query response time.

Managed security by creating users and assigning them to their respective groups.

Diagnosed the environment’s issues by use of log files.

Changed different parameters in the environment’s config files to help clients with certain requirements they needed fulfilled.

Utilized Tableau to produce appealing data visualizations to clients and to help them make business decisions with the help of Ad hoc reporting and Dashboards

Developed Tableau data visualization with various views such as Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.

Prepared Dashboards with calculations, parameters in Tableau and created groups, sets and hierarchies.

Used Tableau Desktop for blending data sources and creating different interactive views and dashboards.

Environment: Oracle 12c, IBM DB2, OBIEE 12c, Tableau, SQL, SQL Developer, Windows 7

Deloitte Consulting LLP, Arlington, VA

Role: OBIEE Developer

May 2015- May 2016

oMet with managers and team members to gather business requirements.

oCommunicated with Business Analysts about requirements and client needs.

oHeld meetings daily with team members to iron out OBI and environment issues.

oDid gap analysis to make sure everything we needed for development was available.

oWorked in the three layers of RPD (Physical, BMM, and Presentation layer)

oModified Repositories according to user’s specifications.

oTrained and used OBIEE 12c and its data visualization tool.

oCreated multiple reports using 12c Data Visualizer

oModified OBIEE 11g RPD, so that it can work with OBIEE 12c

oDownloaded 12c RPD and modified it, before uploading it to make it available in analytics.

oRestructured Subject areas from out of the box, to what user required.

oRenamed tables/columns as per business requirements in the BMM layer.

oExtensively used log files to diagnose issues in our environment.

oUsed Config files in OBIEE to change parameters to allow our users to perform reporting tasks without any limitations.

oUsed Catalog manager (Archive and Unarchive) to move around catalog objects from one environment to another.

oHelped users answer business questions by creating reports (or ad-hoc reports) and interactive dashboards.

oUsed filters and prompts to limit amount of data showing up in reports.

oCreated reports with column selectors, view selectors in reports to help users see their reports in different ways.

oCreated reports with different views (best visualization, Recommended visualization, pivot, graphs, tree map, column selectors, and view selectors).

oUsed conditional formatting in reports to creating color backgrounds as performance indicators.

oCreated action links so that users could view more detailed reports.

oUsed Agents/iBots to deliver various reports to users, at specified schedules.

oManaged performance through use of caching/Aggregate tables, and by disabling user log levels.

Environment: Oracle 11g, EBS R12 Data source, OBIEE 11g/12c, SQL Developer, SQL, Windows-7/Linux.

Alta IT Services/ IBM/TSA, Annapolis Junction, MD

Role: OBIEE Reports Developer

June 2013- April 2015

Obtained a Public Trust security clearance to sufficiently work in this Federal contract position.

Successfully analyzed business requirements, in order to answer business questions

Interacted with team members (DBAs, OBIEE + ETL Developers, and Testers) and held meetings to iron out environment issues

Worked with users and developers to help them understand OBIEE functionality

Successfully solved the Business' problems using OBIEE, by creating reports used in decision making.

Modified RPD in the Admin tool to fix report problems

Worked in all three layers of RPD using the Admin tool (Physical, BMM, and Presentation layers.

Imported database tables into physical layer and created alias tables.

Created connection pools in the physical layer to define data connectivity.

Created star and snowflake schemas in the physical layer.

Created hierarchies, Time series functions, and logical columns in the BMM layer.

Created subject areas with Presentation tables and arranged them as per business requirements.

Successfully used consistency checker to check for errors, warnings, and best practice violations

Deployed the RPD multiple times to reflect changes to appear in reports.

Assisted in resolving upgrade problems from OBIEE 10g to OBIEE 11g.

Assisted in teaching users, and developers about OBIEE 11.1.1.7

Worked in BI Admin console, Enterprise manager, and Analytics to fulfill client requirements.

Created/modified reports using BI Analysis per business requirements.

Created/modified Dashboards using BI Interactive dashboards

Administered the BI catalog which housed all reports and dashboards.

Extensive experience in using Catalog Manager to Archive and Unarchive catalog files and folders across environments and maintaining their security.

Dealt with performance issues to make report query faster.

Used filters and prompts to limit the data being seen in reports.

Used variables, and created separate connection pools, and initialization blocks to streamline administrative tasks.

Used BI Publisher to create pixel perfect reports for the users.

Managed security in the BI Admin Console by creating users and assigning them to groups.

Used IBM and Oracle tools for performance diagnosis.

Used Clear Case as a versioning tool to check-out and check-in tickets.

Used Clear Quest in dealing with tickets from when they were opened to closed.

Environment: OBIEE 10g version 10.1.3.4.1, OBIEE 11g version 11.1.1.7.0, BI Publisher 10g/11g, Command Editor, SQL Developer, SQL, Oracle 10g/11g

Database, DB2 9.7 Database, IBM AIX Windows-7, Clear case/ Clear quest.

Meridian Health Plan, Detroit, MI

Role: OBIEE Developer

April- May 2013

oHeld meetings with users to understand business requirements in health care industry.

oSuccessfully analyzed business requirements, in order to answer business questions.

oWorked in the three layers of the RPD (Physical, BMM, and Presentation layers)

oUsed OBIEE best practices to create and maintain an RPD (Repository Project Definition).

oCreated hierarchies in the BMM layer.

oUsed business logic to create time series models, logical columns, filters in the BMM layer.

oDeployed the RPD to analytics via Enterprise Manager, to create reports.

oDeveloped and tested business intelligence reports using BI Analytics and Dashboards

oUsed BI Analytics and Dashboards to develop analytical reports against multiple data sources

oCreated filters and prompts to limit data in reports.

oCreated BI Publisher reports per business requirements.

oCreated users and assigned users to appropriate groups with appropriate permissions.

oCreated application roles and policies in the EM.

oUsed OBI's main config files to change parameters for better report functionality

oAbility to discuss and utilize the various architectural components of the tool (Security, aggregation, logical columns, …)

oUsed the consistency checker to validate repository by checking for errors, warnings, and best practice violations.

oExperience in troubleshooting issues on server and presentation side through the use of logs.

oGood communication skills to interact with team members, clients and end users.

Environment: OBIEE 11.1.1.7.0, SQL Developer, SQL, Oracle 11g Database, Windows-7/Unix.

TekSystems/ Lexis Nexis- Cincinnati, Ohio

Role: OBIEE Consultant

Jan- Feb 2013

Had meetings with users and managers to discuss the project flow

Set with users to try to understand the layout of reports and Dashboards in MS Excel and figure out ways to make them in OBIEE.

Created the Repository using the BI Admin tool.

Worked in all three layers of RPD (Physical, BMM, and Presentation layers)

Created Connection pool, star schema in the physical layer, and created Aliases out of database tables.

Created a business model per business requirements and moved the necessary tables into it.

Created hierarchies, logical columns, and other forms of dimension modeling in the BMM layer.

Created subject areas and necessary tables in the presentation layer, as per business requirements.

Used consistency checker to check for errors, warnings, and best practice violations.

Deployed the RPD into the EM, and then used it to create reports.

Created reports and Dashboards using analysis and BI Interactive Dashboards

Used prompts and filters to limit the amount of data that shows up in reports.

Used cache management to improve performance

Successfully installed and configured OBIEE 11g.

Environment:

OBIEE 11.1.1.6.0, MS SQL Server DB, SQL, Windows 7

Serco-NA Inc/ DoD- Reston, VA

Role: OBIEE Consultant

July 2012- Dec 2012

Received DoD Secret security clearance to sufficiently work in this government contract position.

Successfully analyzed business requirements to answer business questions.

Interacted with team members and did meetings to efficiently beat project deadlines.

Strong oral and written communication skills; ability to convey ideas, problems, and issues to both business and IT teams.

Worked in the three layers of the Admin tool (Physical, Business Model and Mapping, and Presentation layers)

Created Alias tables, star schemas within the physical layer.

Imported metadata into physical layer per business requirements.

Created derived tables, level-based hierarchies, and dimensional modeling in the Business Model and Mapping layer.

Used cache purging to get rid of stale cache once data in database was refreshed.

Created Reports with different views (Graph, gauge, funnel, view selector, and narrative views) using OBI analytics.

Extensive use of filtering to limit data display in reporting.

Used enterprise manager, and Instance config file to configure Presentation services.

Used BI Scheduler to deliver reports to various destinations in multiple formats.

Used java scripts within agents to deliver reports to required destinations.

Extensive use of conditional formatting to color columns according to business requirements.

Successfully used report cosmetics to produce great reports per business requirements.

Created users and groups and assigned appropriate permissions to see data within reports and dashboards.

Experience working with BI system components, and query logs, when there are problems in the environment.

Tested and Validated the Repository by using consistency checker to check for errors, warnings, and best practice violations.

Worked well with QA team to test RPD and WebCat before putting them into the production environment.

Environment: Oracle 11g, OBIEE 11g version 11.1.1.6.0, BI Publisher 11g, SQL Developer, Windows-7.

Infosys/ Wells Fargo Bank- Charlotte, NC

Role: OBIEE Reports Developer

Dec 2011-July 2012

oInteracted with Users, and team members to successfully examine the business' functional and technical requirements.

oSuccessfully analyzed business requirements to answer business questions.

oDeveloped ad-hoc reports and helped users answer business questions using OBIEE.

oDeveloped various Reports using Analysis, Interactive Dashboards with different Analytics views (Tables, Pivot Tables, Charts, Narrative Views).

oCreated Dashboard Prompts and Variables to make reports more dynamic.

oCreated filters in reports, to limit amount of data showing up in reports.

oUsed case statements to manipulate data as per business requirements

oUsed Conditional formatting in Tables and Charts, per business requirements.

oExtensive experience working in the Physical, BMM, and Presentation layers of the admin tool.

oCreated/modified Metadata repositories per business requirements, using the Admin tool.

oCreated Aliases, Dim Tables, and Dimensional hierarchy modeling.

oCreated star and snowflake schemas per business requirements.

oSuccessfully did Time series modeling, and created derived Tables, per Business requirements.

oCreated logical column calculations using expression builder in the BMM layer.

oCreated Level based measures (Monthly/Yearly sales, Regional sales), per business requirements.

oExtensive experience in working in the Presentation layer.

oCreated Subject areas and put presentation tables in them.

oRe-ordered tables and columns as per business requirements

oExpertise in troubleshooting when consistency checks show errors.

oTrained in creating reports/ iBots using BI Publisher 11g

oApplied Cache management techniques and Aggregated tables to maintain and enhance query performance.

Environment: OBIEE 11g version 11.1.1.5.0, BI Publisher 11g, SQL Developer, Windows-XP.

Student Outreach Solutions- Cincinnati, OH

Role: OBIEE Developer

Jan 2009- Nov 2011

• Interacted with Management, Users and Data analysts, and examined the business, functional and technical requirements.

• Created Repositories using BI Administration tool by importing tables into the Physical layer and created the Business and Mapping model to incorporate the business logic.

• Developed various Reports using BI Analytics, Interactive Dashboards with different views (Pivot Tables, Charts, and Narrative Views)

• Helped users create Ad-Hoc reports used in speedy decision making.

• Used BI Publisher to answer business questions, by creating reports against various data sources.

• Created customer facing documents (Letters, Invoices, Application forms, and business documents) per business requirements.

• Configured Data sources and created Data models per business requirements.

• Created sophisticated Graphs, Tables, and used filters, parameters, LOVs to make reports more dynamic.

• Used the BI Publisher iBots to deliver reports using different output formats (PDF, Excel, Word, HTML) to various destinations like: Printer, Fax, E-mail.

• Created Time series calculations so that users can use time comparisons in their reports.

• Created Alias and Dim Tables to enable Dimensional hierarchy modeling and repetitive use of tables.

• Created Level-based measures per business requirements.

• Configured Security by creating Users & Groups and setting up their permissions to see certain data.

• Expertise in troubleshooting when consistency checks show errors.

• Created Prompts to filter interactive Dashboard Data

• Successfully installed the OBIEE 11g versions 11.1.1.3.0 and 11.1.1.5.0.

• Applied Cache management techniques and Aggregated tables, to maintain and enhance query performance.

Environment: Oracle 10g/11g, OBIEE 10g/11g, BI Publisher 11g, SQL Developer in Windows-7.

Alexa Enterprises/ Papa Johns- Southgate, KY

Siebel Analyst/OBIEE developer

Jan 2005 – Sep 2010

• Set up meetings with the Users to quickly establish relevant business requirements for the business.

• Created/Modified Metadata repository (RPD) by using OBIEE Admin Tool’s Physical, Business Model and Mapping, and Presentation Layers.

• Designed, debugged and optimized the OBIEE/Siebel Analytics RPD / Dashboards / BI Publisher Reports.

• Successfully configured Data Sources before creating BI Publisher Reports.

• Successfully created Data models and XML Sample Data for purposes of making pixel perfect reports.

• Used SQL to join Fact tables to Dimension tables in BI Publisher.

• Used iBots in alerting production managers resulting in quick and proactive decision making.

• Worked closely with Business Analyst, discussed and gathered the Business requirements from different user groups.

• Created Star and Snowflake schemas in the repository as well as using the new foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer.

• Analyzed and validated the business model using the Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the BMM layer.

• Set up Security to authenticate users and assign appropriate permissions per business requirements.

• Used Filters and Prompts appropriately to avoid excessive data showing up on reports.

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

• Created reports and Dashboards and appropriately assigned permissions to users and groups to view these reports.

• Actively trained users so that they could efficiently navigate the dashboards.

• Extensively used Hierarchy modeling from Granular levels to Global levels for pizza sales to make periodic comparisons (Hour, Day, Week, Month, Quarter, and Year) among different Markets (States, Cities).

• Created Level-based measures per business requirements.

• Increased efficiency and profitability by extensively using Siebel Delivers and iBots to help decision making.

• Validated the Presentation layer to make sure users liked the appearance of Business models and tables.

• Tested RPD functionality by creating basic reports.

• Applied Cache management techniques and Aggregated tables, to maintain and enhance query performance.

Environment: Siebel Analytics 7.7, Oracle 10g, OBIEE 10g version, SQL developer, Windows XP

Education:

Associate degree in Accounting, Cincinnati State College Nov 2010

Bachelor’s in economics/ IT, Northern Kentucky University Dec 2005

Certifications

OBIEE Certificate, Oracle University October 5th, 2012

Contact this candidate