RICHARD AMON-KOTEY

SOFTWARE DEVELOPMENT ENGINEER

832-***-****

adkbnp@r.postjobfree.com

PROFESSIONAL SUMMARY

SAP Consultant with overall 10+ years of experience in SAP BW/BOBJ/HANA focused on design, development, and implementation of reporting in SAP applications for modules like FI-CO, SD, MM, IM and PM, and extensive experience in SAP BO reporting tools

Involved in 3 full life cycle implementations of SAP BW HANA, thus involved in project phases Business Blue Printing, Gathering Requirement, Gap analysis, Realization, Production Support, Testing, Documentation, end user training and Go-Live Support

Extensive experience in SAP BOBJ integration with SAP BW and SAP HANA

Extensive experience in data extraction from SAP ECC, Oracle and Flat files using BW Extractors, SAP BODS and SAP SLT

Expertise in front-end Business Warehouse components BEx Query Designer, Web Reports for Queries, workbooks, calculated key figures, restricted key figures, filters, applying conditions and exceptions, variables and processing types

Experience in SAP BOBJ 3.x and 4.x versions with UDT/IDT, CMC, BI Launch Pad, Web Intelligence, Crystal Reports, Analysis for Office, Xcelsius, Lumira and Design Studio

Excellent understanding of data modelling using BW extended star schema

Extensively worked on BW data objects such as Info-objects, Info-cubes, Multi-Providers, Composite-Providers, ADSO’s, SPO’s, APD’s, and OpenHub (Infospoke)

Extensive experience in performance tuning techniques such as evaluation of statistics, data load improvement and query performance tuning using compression, indices, aggregates and Info-cube partitioning

Extensive experience in systems upgrade and migration projects

Excellent understanding of SAFe, ASAP methodology and SCRUM SDLCs

Excellent team player with exceptional problem solving skills, enthusiastic, good communication skills, and customer service oriented

ENVIRONMENTS

SAP R/3, ECC 5.0, 6.0, BOBJ 3.0, 3.1, 4.0, 4.1, HANA

NetWeaver SAP BW 3.5, BI 7.0, 7.3, 7.4, 7.5

ETL SAP BODS 4.2, SLT

Programming Languages SQL, ABAP

Testing Tools HPQC

Databases Oracle10g/11i, DB2, SQLServer, MS Access and HANA

BI Tools BEx Tools; BEx Query Designer, BEx Analyzer,

Web Intelligence, Crystal reports, Xcelsius, Analysis for Office, Lumira, Design Studio

Employer: Intel October 2018 to Present

Location – Phoenix, AZ

Capacity: Software Development Engineer

Scope: SAP BI

•Data modelling in SAP BW and HANA Studio for meeting reporting requirements

•Provide technical solutions for all assigned projects that require development effort from data extraction from various source systems to modelling in BW

•Reporting in BOBJ front-end tools for covering FI, SD

•Leveraged ADSOs, Composite Providers for data modelling

•Data extraction into HANA via SLT and Data Services

•Leveraged HANA modelling thus Information Views thus Calculation Views

•Troubleshooting issues related HANA and BW

•Provided level 3 support for BW HANA Issues

•Documentation of reporting solution and knowledge transfer to L2 support

•Created Data Services jobs to extract data from HANA into SQL applications

Employer: COSTCO June 2017 to October 2018

Location – Seattle, WA

Capacity: Software Developer - SAP BI Developer

Scope: SAP BI

• Involved in creating migration plan, test plans for migration

• Data modelling in SAP BW and HANA Studio for meeting reporting requirements

• Created universes for customer reporting needs using IDT

• Trained business users to use Business Objects Web Intelligence to create reports based data sources

• Created and edited BW Queries and OLAP universes based on BW queries

• Responsible for migrating SAP BO Universes and Reports from DEV to QA and PROD environments

• Worked with SAP BI team to publish BOBJ reports

• Developed and deployed Design Studio dashboards and analysis application on the BI Platform

• Involved in administrative tasks such as setting up new BO environments in terms of maintenance, security and user access control

• Installed server side add on for Design Studio and Lumira on the BO Server

• Client-side installation of Design Studio and Lumira client tools

• Involved in performance tuning efforts for better report and data load times

• Educated client-side developers on best practices data warehousing and reporting

• Trained business users to use Lumira to create visualizations based data sources

Employer : WIPRO LTD

Client: Sealed Air Corp January 2017 to June 2017

Location –Charlotte, NC

Capacity: Senior SAP BW HANA Consultant

Scope: SAP BOBJ Migration with BW HANA Support

Involved in the requirement analysis, technical and functional specs documentation

Series of meetings with business users to understand new requirements

Leveraged new features of BW on HANA for performance optimization

Integration of BOBJ and SAP HANA for meeting reporting requirements

Optimizing HANA views and published HANA Information models in BW

Worked with Flat File Interface in loading master and transaction data

Developed Infocubes, Multi-providers and DSOs, Composite-Providers, SPOs, open ODS views and virtual providers

Created generic datasources using RSO2 to extract data from SAP ECC to BW such as Sales Orders, Deliveries

Used BEx Query Designer to create queries with drilldown functions, calculated key figures using formulas and variables

Included created Info-Packages and DTPs in the Process Chain for the automated scheduling of data loads

Integration of SAP BO and SAP HANA for meeting reporting requirements

Created several Web Intelligence reports by editing charts, tables, templates and worked with several pre-calculated web templates

Migrated Web Intelligence Reports from Universe connection to directed BEx query through BICS connectivity

Trained business users on how to use Business Objects Web Intelligence to create reports

Utilized Crystal Reports to create detailed financial reporting using sub-reports and parameter based reports

Interpret, configure and implement data mapping / transformation business rules into Data Services

Used Open Hub Services to push data out of SAP BW using BODS

Creating Dashboards using SAP BO Design Studio as well

Creating data visualizations using SAP Lumira on different datasources

SAP Design Studio deployment options on BOBIP such as filtering data using different options, using personalization and bookmarking

Developed Annual Company Reports application using Design Studio

Leveraging online composition Design Studio dashboards

Worked with SAP Portal team to publish reports

Employer : Ingenuity America

Client: Summit Technologies Nov 2012 to Dec 2017

Capacity: Senior SAP BW BO Consultant

Scope: Implementation and Support

Responsibilities:

Implementation using ASAP methodology thus involved in blue printing, functional and technical document and preparation of the requirements of the project

Worked closely with business users, business analysts and team members to understand the business requirements

Involved in design and recommended BI architecture integration with SAP and Non-SAP systems

Involved in installing Business Content objects and developing custom data objects

Performed standard, application specific and generic extractions on datasources such as LO Cockpit and FI/GL extractors

Enhanced Plant Maintenance 2LIS_17* data sources (maintenance order, notifications, order operation) as per requirements

Enhanced extract structures and populating them with the user/function exits in CMOD

Worked on various transaction data extractors in PM apart from 2LIS extractors with respective delta types

Installed Info-provider such as InfoObjects, DSOs and Infocubes, Multiproviders and Infosets

Performance tuning by creating indexing, compression, roll up and DB statistics of cubes

Done scheduling and monitoring of the process chains and addressing issues of process chain failures

Developed several queries based on new FI GL Datasources included Internal Earning Statements, External Earning Statements, Balanced Sheet, Profit and Loss

BOBJ reports for the project

Involved in validation of data in ECC and BW

Involved in rectification of failed data loads

Worked on different update modes for uploading the data from SAP ECC to BW

Created and edited OLAP universes based on BW queries

Prepared training manuals and trained business users on how to use BusinessObjects Web Intelligence and Analysis for Office

Utilized Crystal Reports to create detailed financial reporting using sub-reports and parameter based reports

Developed Design Studio analysis application and dashboard data visualizations to support various levels of decision making

Creating engaging data visualizations in SAP Lumira for end users

Employer: Ghana Telecom July 2009 - September 2012

Location – Accra, Ghana

Capacity: SAP BW Developer

Scope: Development & Support

BW implementation, activated datasources in RSA5 and checked extractors in RSA6 and RSA3

Documented short dumps and faulty extractors

Analysed and remedied production issues in the SAP BW system

Created custom data objects to satisfy requirements for connectivity with Legacy systems

Performed and documented unit testing for all objects in Sandbox and development system

Created Infopackages in Development system and tested new InfoObjects data loads

Checked PSA for errors involving invalid characters

Took screen shots and documented all unit testing required

Activated master data objects

Checked PSA for errors, documented short dumps and faulty extractors

Enhanced the different transactional datasources with new fields and added functionality to populate them

Modelling, building and customizing Infocubes, DSO, Info Objects, Infosets and Multiproviders as per the functional specifications

Involved in Installing Business Content for Standard InfoObjects, Info Sources, Infocubes related to Sales & Distribution, Material Management and Finance

Performance tuning of queries and data uploads through OLAP Caching, Aggregation and Compression and 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 with Free Characteristics, Calculated and Restricted Key Figures, Filters, Variables and Exceptions

Production support, which involves daily monitoring of data loads via process chains, trouble shooting and correcting the known errors Maintaining Reconciliations for Finance and Inventory data to verify the data in SAP R/3 and SAP BW are same.

Preparing status reports on Data Load monitoring of daily, weekly and monthly loads

Created queries based on calendar day, week, month, and year to obtain a variety of reports for AR overdue analysis

Data visualization using Webi and Xcelsius for building dashboards

Contact this candidate