SUMMARY

• 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, configuring metadata, creating reports and using interactive dashboards and Answers/ Analysis.
• 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 INSTANCE Config file and EM to manage Presentation services.
• 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 12c, Data Visualization Desktop, Visual Analyzer, BI Publisher, SQL, Toad/ SQL Developer, Oracle 10g, Oracle 11g, MS SQL server Database, DB2 9.7, Windows XP, Windows 7/10, Unix, IBM AIX, WIN SCPIBM tools: (Clear case, Clear Quest, Command Editor)

PROFESSIONAL EXPERIENCE

Confidential

OBIEE 12c RPD Engineer

Responsibilities:

• Met with business analyst, team lead and stakeholders to gather business requirements.
• Held team meetings to lay out design and development of OBIEE reports by following business requirements.
• Communicated with DBAs and ETL developers on defining data sources for development.
• Studied client reports in Excel BI and converted them into OBIEE reports.
• Created OBIEE 12c RPD, reports and dashboards using queries generated from PeopleSoft.
• Used Toad to query database and did gap analysis to make sure all tables and columns are available before RPD development.
• Downloaded RPD from server to make changes, and then uploaded it back to server after modifications.
• Imported tables from Data warehouse, and created alias tables, and the created star schemas.
• Created Business models, logical calculations, hierarchies, time series models, and level-based measures in the BMM layer.
• Reordered Presentation subject areas, tables and columns in the Presentation layer before uploading RPD into analytics.
• Created patches for RPD before it was uploaded into server.
• Validated RPD by querying database and by creating simple reports in analytics.
• Worked with Admins to view log files to get clues when debugging the environment.
• Created reports and dashboards with various views like stacked line graphs, pivot tables, view and column selectors.
• Attended presentations with clients to get their feedback on our reports and made changes to suit client.
• Managed performance in this environment by using caching and materialized views with help from DBAs.
• Tutored teammates and Clients on OBIEE 12c functionality, so that they could use OBIEE to view reports on the dashboard
• Created documents on fixes we made to so that team can become more knowledgeable when same problems occur in future.

Environment: s: Oracle 12c, OBIEE 12c version 12.2.1.3, OBIEE 12c VM, MS PowerBI, SQL, Toad, Linux, IBM Notes, Windows 10 .

Confidential

OBIEE 12c RPD Developer

Responsibilities:

• Met with business analyst, team lead and stakeholders to gather business requirements.
• Held team meetings to lay out design and development of OBIEE reports by following business requirements.
• Communicated with DBAs and ETL developers on defining data sources for development.
• Studied client reports in Tableau application before converting them into OBIEE reports.
• Used SQL Developer to query database and do gap analysis to make sure all tables and columns are available before RPD development.
• Imported tables from Data warehouse, and created alias tables, and the created star schemas.
• Created Business models, hierarchies, time series models, and level-based measures in the BMM layer.
• Reordered Presentation subject areas, tables and columns in the Presentation layer before uploading RPD into analytics.
• Created prompts and filters in reports to limit amount of data seen in reports.
• Created repository and presentation variables which we used in report filters and prompts.
• Used BI Analytics to create reports and interactive dashboards as per business requirements.
• Created action links, so that users can see more detail in their reports.
• Migrated the RPD, and catalog to other environments, and eventually into production using catalog manager archive and unarchive.
• Managed performance by following all RPD development best practices and use of cache management.

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

Confidential

OBI Reports developer

Responsibilities:

• 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

Confidential

BI Tools Analyst

Responsibilities:

• 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

Confidential

OBIEE Developer

Responsibilities:

• Met with managers and team members to gather business requirements.
• Communicated with Business Analysts about requirements and client needs.
• Held meetings daily with team members to iron out OBI and environment issues.
• Did gap analysis to make sure everything we needed for development was available.
• Worked in the three layers of RPD (Physical, BMM, and Presentation layer)
• Modified Repositories according to user’s specifications.
• Trained and used OBIEE 12c and its data visualization tool.
• Created multiple reports using 12c Data Visualizer
• Modified OBIEE 11g RPD, so that it can work with OBIEE 12c
• Downloaded 12c RPD and modified it, before uploading it to make it available in analytics.
• Restructured Subject areas from out of the box, to what user required.
• Renamed tables/columns as per business requirements in the BMM layer.
• Extensively used log files to diagnose issues in our environment.
• Used Config files in OBIEE to change parameters to allow our users to perform reporting tasks without any limitations.
• Used Catalog manager (Archive and Unarchive) to move around catalog objects from one environment to another.
• Helped users answer business questions by creating reports (or ad-hoc reports) and interactive dashboards.
• Used filters and prompts to limit amount of data showing up in reports.
• Created reports with column selectors, view selectors in reports to help users see their reports in different ways.
• Created reports with different views (best visualization, Recommended visualization, pivot, graphs, tree map, column selectors, and view selectors).
• Used conditional formatting in reports to creating color backgrounds as performance indicators.
• Created action links so that users could view more detailed reports.
• Used Agents/iBots to deliver various reports to users, at specified schedules.
• Managed 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.