OBIEE

Ambrose Turkson, Jr., MBA ****************@*****.*** 210-***-**** Cary, NC

SUMMARY

OBIEE Developer Skills:

Over six years of diverse professional experience and successful achievements in eBusiness Intelligence, analytics

•

and development

Strong experience as BI Developer in developing/modifying repositories and reports using OBIEE/Siebel

•

Analytics.

Strong experience in analyzing source systems and business requirements, identifying and documenting business

•

rules and design.

Strong experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using

•

the OBI Administration Tool in OBIEE 11g environment.

Good experience in setting up Object level and data level security.

•

Good experience in Configuring OBIEE Variables and security, Users and Groups in Enterprise Manager –

•

Fusion Middleware Control/Weblogic environment.

Business Analysis experience with excellent communication; interpersonal skills, broad understanding of business

•

operations and requirements.

Client Report Creation:

Strong experience in creating OBIEE Reports & Interactive Dashboards with prompts.

•

High Level knowledge of OBIEE architecture that converts client dashboard and ad hoc queries to Oracle BI

•

Presentation Server generated logical SQL before translation to Oracle BI Server generated physical SQL for data

sources to generate answers and reports.

End to End BI Solutions:

Experienced at working directly with multiple client functional organizations and technical staff to gather, analyze

•

information and data requirements, develop metadata, and provide user training/support through manuals and

workshops.

Proficient at interviewing stakeholders from CXO level executives to end users, and in translating users’ statements

•

of needed system behavior and functionality into Business and Functional Requirements

Business Model Development:

Strong experience in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules,

•

Time Series.

Ambrose Turkson, Jr., MBA ****************@*****.*** 210-***-****

• Good understanding of functional specs and converting them into technical specs.

MUDE:

Functional experience in Multi User Development Shared Repository Environments.

•

Enthusiastic team player, with excellent communication and interpersonal skills.

•

Ability to foster a sense of mission among teammates

•

OBIEE Development Life Cycle:

Strong grasp of requirement gathering procedures, determining data source systems, development phases

•

(repositories, reports and dashboards), performance enhancement strategies (e.g. caching and aggregate navigation),

implementing security, testing and quality assurance, and deploying the RPD to production.

Communication Skills:

Excellent Communication skills (written and oral).

•

Work well with people (Interpersonal skills) in team settings or with individuals.

•

Understand evolving stakeholder needs.

•

Strong organizational, analytical and facilitation skills.

•

Cultivate winning environment. Build relationships – internal and external organizations.

•

Strong presentation skills, a confident communicator, enthusiastic, and self starting.

•

Enabling Technologies:

Applications / Modules: OBIEE 10g/11g, BI Publisher 10g/11g, SM 7

•

Methodologies: Oracle AIM, SDLC, Agile

•

Operating Systems: MS Windows,

•

Software: Microsoft Office Suite, including MS Project, XML, WebServices

•

Databases / Tools: Oracle SQL Developer, Toad

•

PROFESSIONAL EXPERIENCE

[2]

Ambrose Turkson, Jr., MBA ****************@*****.*** 210-***-****

Tata Consultancy Services, Eagan, MN January 2014 Present

OBIEE Developer, Team Lead (with Admin Responsibilities):

Provide primary Incident Management support to business and client partners who need uninterrupted access to

•

OBIEE analytical and transactional data.

Analyze existing OBIEE 11g repository metadata structure (Physical, Business Model and Mapping, and

•

Presentation layers) to solve data and performance issues.

Examine dimension hierarchies, level based measures, and Time series metrics and derived columns of business

•

metrics in the BMM layer to minimize accuracy complaints.

Examine requests for access to dashboards and grant privileges to business users of OBIEE services.

•

Coordinate report development efforts between on site and off shore teams.

•

Work with business clients and Business Analysts to streamline requirements for analytical and performance

•

measuring reports.

Coordinated documentation efforts for over 100 Knowledge Transfer Sessions involving participants in UK, US and

•

India.

Haverty’s Project, Raleigh, NC August 2012 Oct 2013

OBIEE Developer:

Participated in requirement gathering meetings and performed requirement analysis.

•

Customized the OBIEE 11g repository (Physical, Business Model and Mapping, and Presentation layers).

•

Created dimension hierarchies, level based measures, and Time series metrics and derived columns of business

•

metrics in the BMM layer.

Built Report prototype based on initial business requirements.

•

Built Analyses and created Dashboards with Global prompts, column selectors, navigation and automatic

•

development.

Documentation drilldown.

•

[3]

Ambrose Turkson, Jr., MBA ****************@*****.*** 210-***-****

• Performed testing and Data Validation of data in reports against the databases using SQL Developer and Toad.

Performed post upgrade documentation.

•

Created and Customized the OBIEE Repository (Physical, Business Model and Mapping and Presentation layers)

•

Created Usage Tracking RPD and Dashboards

•

Designed and Customized OBIEE dashboards and reports / Dashboards with different analytic views (Drill

•

Down/Dynamic, Pivot Table, Chart, Column selector, Tabular with local and global filters) using OBIEE/Siebel

Analytic Web.

Created interactive maps using the new OBIEE 11g “Map Views” feature

•

SBDCNet.org – eBusiness Development Center (affiliated w/ Univ of San Antonio, TX) Feb 2010 – Jun 2012

Junior Oracle Business Intelligence Developer:

Created comprehensive and easy to understand Documentation of the complete implementation of the Customer

•

Sales Business modules (Reports, Dashboards, Security and Star schema).

Developed the Oracle BIEE Metadata repository (.rpd) model with for Sales, Marketing subject areas that involved

•

creating Physical, BMM layers with aggregates, dimensions, hierarchies ; Time Series Functions, Presentation layer

with catalogs; folders using Oracle BI Administration tool.

Participated in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and

•

Finance Subject Matter Experts (SMEs), Business Analysts and Users

Developed 4 dashboards and 37 reports. The reports were used by the business to identify most profitable customers

•

and analyze Revenue trends by Customer to identify opportunity / risk.

Implemented security by creating users; web groups, setting up External Table Authentication, creating Session

•

Variables and Initialization Blocks and associating catalog objects and Web modules with the created groups.

Utilized Oracle Delivers for sending real time, personalized alerts via intelligence agents (iBots) to subscribed

•

users.

Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, Oracle

•

material ized views and making changes to reports.

Communicated project status and escalated issues as needed.

•

Participated in complete life cycle of the project from project initiation, to development, to production support and

•

maintenance.

[4]

Ambrose Turkson, Jr., MBA ****************@*****.*** 210-***-****

• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the

values in the Reports / Dashboards, documented the test results.

Implemented Usage tracking reports which read statistics from the usage tracking database. These reports helped

•

identify performance bottlenecks for further tuning.

Re/Max International Elite, San Antonio, TX. March 2007 – Jan 2010

OBIEE Consultant:

Gathered Business requirements by interacting with the business users, defined subject areas for analytical data

•

requirements.

Performed gap analysis and feasibility study for the given requirement.

•

Created mockup reports and dashboards for review by the business users.

•

Customized the OBIEE Repository (physical, BMM, and presentation layers).

•

Created connection pools, imported physical tables and defined joins in the physical layer of the repository.

•

Created dimension hierarchies, aggregates, and keys in the BMM layer.

•

Modified Presentation Layer to add presentation tables and columns to meet the business user needs.

•

Worked on repository and session variables.

•

Used the security settings in Siebel Analytics Admin tool to setup users, Groups and Access privileges.

•

Created materialized views and aggregates to improve performance.

•

Customized Activity and Revenue star schemas.

•

Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and

•

perform database optimization by analyzing query performance.

Customized reporting with OBIEE Answers and integrated them into the Dashboards.

•

Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.

•

Created dashboards with global prompts, column selectors, navigation, and automatic drill down.

•

Created user level security for intelligence dashboards based on Business Requirement.

•

Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation,

•

Actual Vs. Forecast Response rates, Segment and Offer responses.

[5]

Ambrose Turkson, Jr., MBA ****************@*****.*** 210-***-****

• Created Dashboards with Dashboard prompts, Charts, Pivot tables.

Performed Data Validation of data in the reports and dashboards.

•

Extensively used SQL Tuning to improve performance.

•

Created iBots to send pre processed reports using OBIEE Delivers.

•

Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and

•

documented the results.

Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers,

•

Delivers and Publisher.

Documented the design for intuitive understanding and future reference.

•

Performed production support for the project.

•

GlaxoSmithKline Pharmaceuticals, May 1994 – Dec 2006

Executive Pharmaceutical Consultant:

Led the development, deployment, and overall project management of the West Coast Region marketing decision

•

support system that enabled market analysis, segmentation, and target market identification of distinct therapeutic

groups

EDUCATION

MBA, Global Business Integration, 2004

University of Phoenix, Walnut Creek, CA

BS, Business Administration with Marketing Emphasis, 1987

California State University, Los Angeles, CA

REFERENCES

Available upon request

[6]

Contact this candidate