SAP BI/BO CONSULTANT FRED KWAME AMPONSAH
abm9q1@r.postjobfree.com
Professional Summary
* ***** ** **********. * years of result filled experience as SAP BI/BO Consultant.
* ****-life cycle projects (ASAP methodology) Implementations.
Hands-on SAP BW technical expertise in developing and enhancing DSOs, Infocubes,
MultiProviders, Extractors, Datasource and complex transformations.
Post Production Support - Technical, Functional and System Administration.
Hands on ETL Tools, data staging techniques and metadata tools.
Experienced in FIGL, Accounting, Accounts Receivables and Accounts Payables, Cost Center
Accounting, Internal Orders, Profitability Analysis, FI, HR/Payroll.
Good exposure to SAP functional areas: FICO, SD, HR, MM, Inventory, etc.
Solid knowledge in System Administration, Table storage maintenance, Security, Data
Extraction, Data Loading (Full /Delta Up-Load), ETL, Scheduling, Monitoring and Data
Modeling.
Maintenance, Installation and Enhancement of Business Content objects.
Experience in Process chains and Info packages to lay connectivity into various Data Targets.
Expert in performing routine program, modifications, Performance Tuning (Query and Data
Loading): Aggregates, Compression, Roll-Up, Indices, Statistics etc., and also the tools available
in BI/BW to measure them like RSRV, RSRT, ST03
Extensive knowledge of BEx Analyzer, and BEx Query Designer for developing reports, analysis
and Web reporting using BEx Web Publisher and BEx Web Application designer.
Experience integrating BW reports in SAP Portal.
Experience in distributing data to external data marts using the SAP Hub service.
Solid knowledge of SAP Enterprise Integration to Business Objects Enterprise.
Strong hands on experience in report development using Web Intelligence & Crystal Report
and Xcelsius, Desktop tools for Dashboards and BOBJ management console.
Experience in Universe designing, developing and generating Dashboards, Reports, Business
Good Experience in activities related to Technical Upgrade (BW 3.5 – BI 7.0 Upgrade) and
Testing, System Refresh, Production Releases, and Transportation of Objects from
Development box – QA – Production.
Experience with Non-SAP Source Systems data extraction using Universal Data Connect.
Strong analytical, conceptual and problem solving skills to evaluate complex BW technical and
functional problems and apply knowledge to identify appropriate solutions.
Experience with BW Security roles.
Experience with Information Broadcasting.
Good ABAP programming skills
Strong communication skills and a demonstrated ability to work as a team player.
Skills
Platforms: Windows 98/2000/XP/VISTA
SAP Tools : R/3, 4.6c, ECC 6.0, BW 3.0B, 3.0A, 3.1, 3.5, BI 7.0, ABAP
Reporting Tools : BEx Analyzer, WAD, Report Designer, Business Objects Enterprise XI R2:
Business View, OLAP Intelligence, Designer, Infoview, Web Intelligence,
Xcelsius 2008, Crystal Report 2008. MS Project, MS PowerPoint, MS Excel, MS
Word
Database : Oracle 9.2 Version 7, MS Access, MS- SQL Server
SAP BI/BO CONSULTANT FRED KWAME AMPONSAH
abm9q1@r.postjobfree.com
Professional Experience
Pentacle Consulting, Houston, TX
Client: Raytheon
Capacity: SAP BI/BO Consultant (Nov 2008 – Oct 2009)
Scope: Implementation and Support
Involved in system upgrade from BW 3.5 to 7.0.
Maintained and enhanced existing BW Data models, Extractors, Transformations and Reports to
meet new business requirements FI/CO, MM and Logistics.
Organized, created and maintained critical technical and functional documentation for BI
solutions, including technical specifications, test plans and training materials.
Defined and executed unit test, integration test and regression test scripts to validate key end-to-
end business scenarios.
Designed and developed new data models using SAP BW 7.0 objects- MultiProviders, Infocube,
InfoObject, Data Store Objects, Transformations, Start Routines, End Routines and DTP's
to meet new reporting requirements.
Enhanced standard business content objects
Performance tuned complex data loads and data conversion processes using advance BI 7.0
functionality to demonstrate improved response times.
Lead the Installation and Configuration of BO XI 3.1 on BO enterprise 64bit server.
Integrated SAP BI to BO XI enterprise
Set up security between BO Enterprise and SAP Enterprise.
Performed analysis, design, develop, and test universe using ‘Designer’ using Oracle data sources.
Responsible for creating and maintaining Universe classes, subclasses, objects, conditions, joins,
prompts reports and analytic solutions.
Performed Business Object Enterprise Administration using Business Objects CMC
Web Intelligence, Crystal Reporting and Dashboard development; extensively worked with
advanced Xcelsius concepts like What If Analysis, Dynamic Visibility, Narratives, Interactive
Charts, Hierarchies.
AEGISMTG, TX
Clients: TFP LTD, Kla-Tencor
Capacity: SAP BI Consultant (Jan 2007– Oct 2008)
Scope: Implementation, Enhancements & User Support
Analyzed the business requirements in daily meetings with the business users.
Created the high level documentation to present to the business users.
Developed new requirements for users based on FI/GL utilizing Hierarchies for Financial
Statements for Internal Earning Statements by Market, Profit Center, Cost Center etc.
Support with Unit testing, integration testing, and review of business training materials.
Develop processes and standards for BW production support.
Analyzed and installed the required business content Objects
Created the transformations, DTP’s and error DTP’s
Loaded Data on a Daily and Monthly basis, monitoring delta data loads, troubleshooting where
SAP BI/BO CONSULTANT FRED KWAME AMPONSAH
abm9q1@r.postjobfree.com
necessary.
Worked extensively on the transaction data and master data user exits on R/3.
Used the Business Content plan, budget and assigned values InfoCube 0IMFA_1, for over all
Investment management Analysis.
Created reports by using RRI (Report to Report Interface), exception, conditions, exception
aggregation, restricted and calculated key figures depending the requirements.
Worked extensively with BEx Analyzer and created queries using BW-Reporting Variables,
Navigational attributes and Filters. Developed workbooks, InfoSet Queries and used RRI jump
queries to drill down to other queries.
Developed front-end queries and reports using Web reporting tool and Web Application designer.
Participated as a team member in discussion with business analysts and end users in achieving the
most suitable reports for various business evaluations.
Installation, Configuration and Integration of Business Object XI R2 to SAP BW system.
Extensive use of Business Object Enterprise XI reporting tools: Reporter, Xcelcius, Designer,
Infoview, Web Intelligence and Crystal Reports to report off SAP BW system.
Pentacle Consulting, Houston TX
Client: Pacific Unit
Capacity: SAP BW Analyst (June 2006- Dec 2006)
Scope: Support, Defects & Enhancements
Involved in complete life cycle implementation of SAP BW using ASAP methodology as a team
member, converting Functional Specifications into Technical Specifications and then to
realization.
Analyzed the requirements and identified the suitable business content for SD, FI/CO and had the
standard infocubes, ODS’s, Multicubes and various other relevant objects installed and activated.
Used full features of BI 7.0 (DTP, Transformations, and DSO).
Developed BW Queries, Testing and transporting through landscape.
Extensive work on translation keys & Function modules for (ODS) to do Currency conversions.
Involved in testing extractors, data loads and reports before transporting into production.
Enhanced extract structures by adding new fields and populating them with the user/function exits
in CMOD.
Created the process chains to automate the data loads for transaction, master, text, hierarchies,
currency exchange rate tables.
Performed standard, application specific and generic extractions such as LO Cockpit, LIS, CO-PA,
and FI/GL extractions.
Extensively worked with PSA in Monitoring the Data Transfer from Source Systems into BW.
Extensive work on Design & Development of Custom Cubes, DSO/ODS Objects,
Multiproviders and Infosets; Enhancements on Accounts Receivables (AR) cube 0FIAR_CO2.
Delta Management.
Modeled Data targets according to the reporting requirements.
Performance Optimization by Tailoring Transfer Structures, Communication Structures, and
Update Rules using routines and Start Routines.
Developed various FI/CO and SD reports such as DSO Analysis Current Period, Days overdue
Analysis, Customer Sales Trend, Actual Contribution margin in Sales, Incoming Orders
Analysis and Product Profitability Analysis in SD.
Worked with SAP Open Hub service for sending the data from BW to External Systems.
SAP BI/BO CONSULTANT FRED KWAME AMPONSAH
abm9q1@r.postjobfree.com
Provided complete end user training and knowledge transfer to permanent staff.
DrewTech Consulting
Client: - Direct Alliance
Capacity: SAP Junior BW Developer (Oct 2005 – May 2006)
Involved in user requirement collection and doing GAP Analysis.
Involved in testing during implementation: Unit, Integration, Volume and Stress tests.
Enhanced the different Transactional DataSources with new fields and added functionality to
populate them.
Modeling, building and customizing InfoCubes, DSO/ODS, Info Objects, Infosets and
MultiProviders as per the functional specifications.
Involved in Installing Business Content for Standard InfoObjects, InfoSources, InfoCubes related
to Sales & Distribution, Material Management and Finance.
Used the Business Content Sales Overview InfoCube 0SD_CO3, for over all Sales Analysis.
Developed simple Routines in Update rules and Transfer Rules for the key figures of InfoCube
Purchase Data 0PUR_CO1. InfoCube was used for Analyses of Material groups, Vendors, and
Materials.
Monitored data extraction and created queries based on client’s requirement.
Performance Tuning of queries and data uploads: OLAP Caching, Aggregation and Compression
Implemented BW statistics to monitor BW system performance.
Liaised with SAP Basis Team regarding BW Transport requests.
Worked extensively in creating reports like Balance Sheet, P&L, Cash, Gross Margin, Monthly
Sales, Open Orders, Back Orders, Overdue, Daily Sales Reports, Payment History, etc. using
structures, formulas and Cell definitions.
Worked with BEx Analyzer to generate Queries and embedding them into Workbooks.
Configured BEx Queries for Free Characteristics, Calculated and Restricted Key Figures, Filters,
Variables and Exceptions
Education
Masters in Engineering
Wayne State University, Detroit, MI
Bachelors in Civil Engineering
KNUST, GH
Personal
Green card holder
References
Upon Request