SAP BW/ BO Consultant, Expert SAP BI Consultant/ Analyst, SAP BW/ BO Consultant

RESPONSIBILITIES:
Working in the area of Assortment reports, creating and modifying BW 7.5 transformations and
start/end/field routines, creating and modifying BEx Queries. Working with and modifying BO reports,
working with merged dimensions and sections. Working with aDSOs and BW data sources, Composite
Providers and Calculation Views. Participating in Retrofit activities. In Assortment reports I added
new Bex queries to BO reports. I also added new calculated and restricted key figures to the
Assortment reports.

RESPONSIBILITIES:
Designing architectural solutions as per requirements.
SAP BO and BW reporting layer development for financial analysis. Working with BW 7.5 and BW/4HANA
ETL (DSO, ADSO, InfoCubes, MultiProviders, Composite Providers, InfoObjects, DataSources,
Calculation Views, Open ODS Views) /Query Designer on HANA studio, SAP Lumira Designer/ Design
Studio/ Web Intelligence/ FIORI Launchpad/SAP Analytics Cloud. ABAP OO /user and customer exits and
BAdI. Working with authorizations.

RESPONSIBILITIES:
Designing architectural solutions as per requirements.
Writing ABAP BW routines, using ABAP OO programming, writing User, Customer Exits, BAdI, using
dynamic programming within financial area of BW. Working with Bex Query Designer, Web Application
Designer, DSO, ADSO, InfoCubes, MultiProviders, Composite Providers, APD, InfoObjects, DataSources,
SAP Financial reporting within BW and R/3 source systems. Gathering, analysing and implementing
requirements for Accounting Payable (Procured to Pay), Accounting Receivable (Credit and
Collection), General Ledgers (Record to Report) and Financial Supply Chain (FSCM). Using BODS as
data entry layer for data upload into BW and native HANA. Working with native HANA (HANA studio) /
HANA Modeller, Design Studio and BPC 10.1 EPM reporting. Creating connection between BSAR MJV Run
book and central BW reporting. Using Solution manager for transportation purpose together with
Service Now ticketing system. Building and maintaining QlikView reports.

RESPONSIBILITIES:
Leading a small development team.
SAP Financial Reporting in automotive area. Technologies including BPS0, BPS_WB, Bex Query Designer,
Web Application Designer, DSO, ADSO, InfoCubes, MultiProviders, APD, Composite Providers,
InfoObjects, DataSources, Planning Sequences, Planning Functions, Plannnig Layouts, FOX Formulas,
ABAP Functional and OO Programming, BADI, RSA1, RSPC, RSPCM, RSPLAN, Aggregation Levels, RSINPUT,
Analysis for Office, VBasic and BO WEBI Reports. Managing maintenance and change requests tasks in
the area of Actual and Forecast data.
Creating and migrating InfoCubes into HANA Optimized, managing HANA Advanced DSOs and flows (HANA
Modeller), using solution manager for transportation.
Working with HANA studio (Analytical Views, Calculation Views) and Design Studio.
Creating and managing SAP APO Planning Books (transactions /SAPAPO/MC77, /SAPAPO/SDP94,
/SAPAPO/SDP8B), EPM BPC.
Delivering SAP trainings to Volvo.
Designing Framework for automatic migration from BPS to IP (excluding BPS Layouts).

Knowledge transfer and system analysis for a leading German automotive industry. Technologies
involved: SAP BW (DSO, ADSO, InfoCubes, MultiProviders, Composite Providers, InfoObjects,
DataSources, APD), Integrated Planning, BPS, SAP Functional ABAP and ABAP OO, SAP BW Reporting and
Planning.

RESPONSIBILITIES:
Adjusting and creating of Planning Layouts using transaction RSINPUT. These tasks involved also
writing classes for Data Slices and usage of planning sequences. Usage of BPS0 and RSINPUT to handle
manual planning for planning cubes APO requests (I used BPS0 also for retraction purposes and used
ABAP in Characteristic Relationships).
Loading of/ handling of Forecast and Actual data for planning as well as for reporting purposes of
various financial versions using both old 3.x dataflow (Update/Transfer rules) as well as the new
dataflow (with DTPs). Furthermore, creation of various process chains for daily/monthly/initial
loads (for example to load T3/T0 versions). Moreover, I created BO 4 reports using BEX connection to
BW Queries (which I also created) in Information Design Tool. These reports used Merged Dimensions
and hierarchical variables for data input (neither data foundation nor Universes were used).
Apart from that, my responsibility was to do adjustments to an MVC and ABAP OO based BSP financial
planning application as well as doing ABAP enhancements to the BW routines.

RESPONSIBILITIES:
Project in the area of SAP BW 7.1 (DSO, InfoCubes, InfoSources, MultiProviders, InfoObjects,
DataSources, APD)/BO 3.1, Crystal Reports 2008 and Cognos 8 for a leading European car company. My
main responsibilities involved creation of Cubes, DSOs, process chains (TRAN RSA1 and RSPC and
RSPCM), ABAP programming of Start-, End- and Expert routines (mainly TRAN RSA1 directly - function
modules - or SE80 through OO). I also constructed WEBI Reports and Crystal Reports using Cognos as a
pattern for layout and calculations. Also, my responsibilities have included transports (TRAN STMS)
and design of BEX Queries as well as managing CMC and working with InfoView. Source system was
Informatica. I also worked with Business Objects Data Integrator (BODI) as data consolidation tool
for reporting.

RESPONSIBILITIES:
The project involved working in SAP BW 7.1 and SAP BW 7.3 environment. My main responsibilities
included changes/implementation of BW ETL with various R3 sources. Also, I enhanced extractors and
wrote User Exits using ABAP, BEX Queries, and finally I prepared the Workbooks, which also included
macros in BEX Analyzer.

Also parallel I prepared a migration of BO reports from 3.1 to 4.0 using the BIAR file and CMC.

RESPONSIBILITIES:
Project for a German television. Included:
* Developing PL SQL packages and functions (Bulk collect, exceptions, DDL, DML, DCL and TCL)
* Extending and maintaining Oracle database (Tables, Views, Materialized Views, Indexes, Blocks,
Segments, Execution Plans, Tablespaces, database links, Sequences and Partitions)
* Using Primary, Foreign keys, Index organized Tables and Triggers for updating measure tables
in Datawarehouse
* Creating Oracle statistics in order to keep up the Datawarehouse performance
* Using Oracle hints for performance tuning in Oracle 10.2
* Working with Oracle 10.2 and 11.2 databases
* Working with SQL Developer and Toad as development environment
* Writing Korn Shell scripts for automatic Datawarehouse creation together with Logs (this was
necessary, because Toad does not create logs while compiling included scripts)
* Using Cygwin in order to simulate UNIX Environment on Windows systems
* Using Cognos 8 Report Studio for report creation
* Using Business Objects Data Integrator (BODI) for creating ETL
* Gathering business and writing system documentation and requirements for Datawarehouse
development purposes

A Project for a leading European energy supplier based in Germany, Würzburg (BW 7.1 and BO 3.1). As
source system we used R3 HCM System. My main responsibilities included:
* Writing and participating in enhancing of a BSP Application using ABAP OO as an event handling
method
* BW ETL (writing and adapting routines, creating Cubes and DSOs)
* Enhancement of generic extractors (TRAN SBIW) as the data was drawn from InfoTypes.
* Usage of Integrated Planning as input mask for the User's correction data entered through
Input ready Variables in BEX Query Designer (IP Data Slices).
* Creation and changing of Universes and WEBI reports.
* Using TRAN RSBBS as a transaction for creation of "Jumps" in BEX Analyzer.
* Preparation of transports in TRAN SE10 and using of TRAN ZRT4 (transport manager as
alternative to STMS)

A project for a leading European Telecommunication Company based in Bonn, Germany. Included:
* Gathering business requirements
* Modelling business processes in Power Designer, MS Visio (UML)
* Cubes modelling in Power Designer and Cognos
* Writing business documentation for a leading European Telecommunication company
* Data warehouse business processes managing
* Training in the customers company in Bonn, Germany
* Working with clearcase as the versioning system
* Delivering Ab Initio and Data Warehouse training in Polish and German languages
* ETL processes modelling in Power Designer (UML)
* Implementing ETL processes in Ab initio
* Implementing ETL processes in PL/SQL
* Experience with UNIX as the data warehouse server
* Writing technical documentation concerning technical concepts, user guides
* Cubes implementation using Cognos
* ETL performance improvement analysis
* UC4 experience
* Working with clearcase as the versioning system

RESPONSIBILITIES:
* Designing and Implementing financial and train map modules (three tier architecture)
* Using Java J2EE and EJB for the frontend application parts
* Using PL/SQL procedures for designing the database parts
* Using Eclipse as the development platform
* Creating Reports using the Jasper tool
* Using SVN as the versioning system

RESPONSIBILITIES:
* Designing and implementing system components
* Using MS Access 2007 as the programming environment
* Designing and implementing the financial (invoices, bills) module
* Designing and implementing the car rental module

RESPONSIBILITIES:
* Taking part in software development for a leading European telecommunication company
* Working with Carbide as the programming platform
* Using SVN for the versioning purposes

RESPONSIBILITIES:
* Collecting application requirements
* Designing HR managing system (MVC architecture)
* Writing business and system documentation (use cases, application guide)
* Creating reports using the Crystal Report tool
* Using ASP.NET and ADO.NET for application developing purposes
* Using MS T-SQL for designing and implementing of the database