Project Service

Daniel Mensah

Senior SAP BO Consultant

**** ********* ***, ******, ***** 75249

214-***-**** - ***********@*****.***

SUMMARY PROFILE

Results focused and diligent Senior SAP BO Consultant and accounting

professional with demonstrated expertise in Universe design and

development, Web intelligence reporting, Crystal reports development,

Dashboard (Xcelsius), creation of sematic layers with Information Design

Tool (IDT), BI Launch Pad, enhancement and development of work of complex

modules, and deployment of SAP solutions to achieve defined business

objectives for over 8 years.

. Strong analytical skills in identifying business issues and implementing

process and procedures, proficient in full cycle accounting, financial

analysis, cost accounting, and management of general accounting functions

for 4 years.

. Perform high level/detail design, develop and unit test of BO (Universe,

Webi, Crystal Reports and Dashboards).

. Experience in creating blue print, functional and technical documents for

3 projects life cycles.

. Experience in migration projects from BO XIR3.1 to 4.0, writing SQL,

PL/SQL, Views and Stored Procedures.

. Excellent experience in SAP BO Suite (6.5, XI R2/R3, 4.0) with good

understanding of Data warehousing concepts

. Efficient in administrative activities like creating users, user groups,

security, and working with privileges to users.

. Highly knowledgeable in Crystal reporting that requires running totals,

sub-totals, summary report, hierarchies, Cross-tab, and multiple groups.

. Migration of Universes and reports using Promotion Management (or LCM)

and Import Wizards.

. Experience in Sub-report and on-demand sub-report in crystal reporting.

. Skillful in system analysis, testing, trouble shooting of transaction

data, documentation and performance tuning of reports in various

environments.

. Strong in using Central Management Console (CMC) to maintain servers,

create connections, manage groups, users, set security levels, publish

and schedule reports.

. Dashboard (Xcelsius): Creating chart with visualizing data range, Series,

interactive model, maps with graphics, and Query as a Web Service;

perform multidimensional ad-hoc analysis with Analysis Office, Dashboard

for Mobile.

. Maintain the Data Warehouse, while integrating vital corporate data

through best practices.

. Experience in relational databases, proficient with the use of aggregate

prompt, where clauses, select statements etc.

. Excellent skills in using BI Launch Pad to creating BI Workspace; launch

Applications, sets Advance and Interactive analysis preferences, Run and

Schedule reports, set Crystal report viewing preferences and edit

parameters etc.

. In Information Design Tool (IDT), skillful in the creation of semantic

layers - create relational data or OLAP connection, data foundation

layer, business layer, publish universe in the repository, and publish

connection to a repository.

. Resolving loops, Fan Traps and Chasm traps using context and alias and

check integrity of universes.

. Efficient in the use of aggregate aware function to optimize report

performance, and speeds up the execution of queries

. Experience in migrated reports and objects from development to production

environment using import wizard.

. Collaborate and work with other BW/BO developers, designers, and

architects to ensure all the BO objects meet business requirements and

performance goals, and provide training to end users as needed.

AREAS OF EXPERTISE

Software: SAP BO 4.0, BI 7.3; Oracle Financials, JD Edwards, Yardi,

PeopleSoft, ADP, and MRI.

Reporting tools: Universe, WEBI, Crystal Report, Bex Query

designer/analyzer, Dashboard, Info-view

Databases: SQL Server 2008/7.0/6.5, Oracle 10g, 9i/ 8i, Access, DB2

Other: Financial Forecasting, Variance Analysis, Creation of Templates &

Procedures.

Operating System: Windows 7, NT 6.0, Windows 2003 & 2008 Server, Windows

XP, Linux

ACHIEVEMENTS

. Received recognition award for dependability, accuracy, efficiency and

timely meeting of reports deadlines.

. Have contributed tremendously in performance tuning processes in

universe level, database level, report level, and server level. These

have reduced delay in report generation and speed up report output of

our team to meeting report deadlines.

. As part of a highly dedicated team we successfully completed SAP

implementation project within 8months in planning, managing and

delivering SAP Solutions. Wrote documentation to support the

implementation of best practices and ensure documentation was up-to-

date. Assisted in the facilitation of end user testing as well as

customer support in providing post-implementation support and

maintenance.

. In WEBI, importing excel sheet as a source to creating butterfly chart

showing different categories of ages of males and females employees in

the organization. Such Reports helped management to make cost analysis

and cost reduction in employee related cost and helped to balance the

demographic population of employees within the company.

. Also, in WEBI, effective use of combined queries to perform union,

intercession and minus operation to determine varying sales revenue,

profit margins for different products lines, given specific regions

and for five consecutive years, have helped to redirect management

focus to channel resources to specific products portfolios thereby

yielding incredible returns to the company in both short and long

term.

. Produced Timely Executive Dashboards using dynamic visibility and High

level Crystal reports for the Financial Controller. In addition, my

involvement in building financial and budget reports have improved the

quality of periodic reports generation.

PROFESSIONAL EXPERIENCE

Golden Support Systems - Dallas, Texas (2006 - Present)

Senior SAP BO Consultant

. Actively involved in project planning sessions with project managers,

business analysts and team members to analyze business requirements

and outline the proposed solutions.

. Improving the quality of Universe design and development with unique

creation of classes, objects, schema, aggregate prompt, derived table,

aggregate aware, Store procedure and modifying existing universe etc.

. Assists in resolving production support problems. Develops and

suggests alternative approaches to resolving problems.

. In Web Intelligence (WEBI), developing meaningful report layout for

senior management for high level revenue & cost analysis - example

able to produce report showing sales revenue bars alongside unit sold

of various products lines on a vertical tabular report layout.

. Broad experience in building Dashboard by using excel sheet with Live

Office connection with Universe, WEBI, Crystal report, and creating

Interactive flash files with Crystal reports using Crystal consumer

data.

. Using crystal report to create vendor due date analysis report,

customer due date analysis report, GL accounts balances etc.

. Project sharing knowledge in IDT especially when multiple developers

work on various semantic layers - Able to perform check-in and check-

out operation, consolidate changes done by the developers into one

file in the shared project, update the local project and publish to

the BO server.

. Performing multidimensional ad-hoc analysis with Analysis Office tool

to help management reporting.

. In Information Design Tool (IDT), creating semantic layers - create

relational data or OLAP connection, data foundation layer, business

layer, publish universe in the repository, and publish connection to a

repository.

. Building dashboard on Query as a web service real-time data into excel

using WSDL on top of universe query.

. Building Query and report development using Bex Analyzer, Bex Query

Designer, Bex Web application designer.

. Experience in 3 full life cycle implementation in SAP BI 7.0/ BW

projects for FI areas like Gap analysis, Blue-printing, Design

specification, and Testing etc.

. Using report functionalities such as Variables, Breaks, Sorting,

Alerts, Prompts, Slice and Dice and Drill down/up, Filters, Ranking,

Sections, Graphs, Functions, Formulae and Master-Detailed using

various sources like SQL Server, Oracle and MS Access.

. Optimizing report by applying the sum function at the select statement

or database level.

. Currently achieving impressive results in generating daily and monthly

reports for the following: Monthly sales report, Sales by rep report,

Daily margin report, AR Aging report, Bad debt report, Comparative

income report, Cost analysis, Actual vs. forecast report etc.

. Efficiently performing administrative activities like creating users,

user groups, set up security levels, and working with privileges to

users.

. Web Intelligence: Creating advance multiple reports, ad hoc query,

tables and charts, complex filters, customized formulas and highly

formatted page layouts.

. Crystal Reports: Planning, creating formatted reports, multiple

groups, Integration with SAP Data Source, manipulation formulas,

applied conditions and export reports to Excel and Word.

. Created BEx Queries using functionalities like conditions,

exceptions, user entry variables and formula variables, restricted Key

figures etc.

. Using crystal report to generate open document in URL - this directly

opens specific financial document or report from the BO server base on

the document ID, and export output in different format like pdf, word,

excel etc.

. Consistently using aliases, and context operators to resolve loop

problems in universe design.

. Imported UNX file from the repository resources to the local project

for further modification per client's request, and republished to the

repository with latest changes.

. Excellent interpersonal & communication skills to work with team

members and ensure all applications & reporting solutions are clearly

integrated and synchronized.

A-1 Affordable Motors - Kennedale, Texas (2003 - 2006)

Accountant

. Successfully performed full-cycle accounting for 4-service lines in a

dynamic growing automotive company. Strategically planned,

coordinated, and reviewed accounting functions and financial

statements to consolidate results with other service lines.

. Effectively developed solid financial reports detailing forecasting,

trending, and financial analysis which enabled the owners to make

expansion within Dallas/Fort Worth metroplex. Cleaned up past due

deficient of over $500,000 within 6 months and kept them current at

92%. Also, managed accounts payable operating and approval process.

Key contributor to month-end closing.

. Provided primary oversight to the various service lines in resolving

and managing control issues, such as budget comparison statement,

balance sheet, profit & loss reviews to facilitate efficient

operational performance within budgetary constraints.

. Conducted comprehensive review and analysis of operating statistics,

budget comparison cash flow and variance report, 12 month

actual/budget statement, marketing sources analysis, and prepared and

presented detailed owner report to the owners monthly. In addition,

the Executive summary was reviewed and tied to the financial report.

. Efficiently managed the cash flow of the service line and provided

monthly distributions to the owners timely. Some distributions were re-

invested for the purpose of expansion. Performed corporate bank

reconciliation monthly, and worked in collaboration with the

Controller to ensure timely delivery of owner reports to the

investors.

EDUCATION

. Master of Business Administration, Finance, Colorado Technical

University (2012)

. Bachelor of Science in Accounting, Colorado Technical university

(2011)

. ACCA Level 1 & 2, Assoc. of Certified Chartered Accountants, London,

UK (2001)

Contact this candidate