(I) Work experience

Data Warehouse Consultant (Freelancer): November 2015 – October 2017 (top itservices AG, Düsseldorf, Germany)

End-to-end DWH solution delivery:
• Requirements gathering and source system analysis
• Solution Design
• ETL / ELT process development
• Testing and Post Go-Live support
• Performance Tuning
• Regulatory Reporting (REMIT, EMIR III)
Team Management:
• Operational team alignment
• Knowledge and best practice sharing
• Fun@Work initiatives and motivation activities (Monday cookies, Inspirational Kinder eggs)

Tools: SAP BODS 4.0 (BusinessObjects Data Services), Oracle 11g, JIRA, Confluence, Sybase PowerDesigner, HP ALM

System and Process Integration Senior Analyst: April 2014 – November 2015 (Accenture, Düsseldorf, Germany)

DWH design and development:
• Source system analysis
• Solution Design
• ETL / ELT process development
• Testing and Post Go-Live support
Tools: SAP BODS 4.0 (BusinessObjects Data Services), Oracle 11g, JIRA, Confluence, Sybase PowerDesigner, HP ALM

SAP BusinessObjects BI and EPM Manager: February 2013 – March 2014 (Fairvalue Com SRL, Bucharest, Romania)

Project Management:
• P&L Planning Forecast vs Actual
• Resource allocation
Sales:
• Presales and demos
• Proposals and contracts
Team Management:
• Performance Evaluations
• People Growth
• Learning path design and follow-up
Team: 5 BI and EPM consultants.
Customers across numerous industries: Parcel Delivery, Financial Services, Construction, Public Sector, Beverage distribution and Aviation

SAP BusinessObjects BI and EPM Consultant: July 2010 – March 2014 (Fairvalue Com SRL, Bucharest, Romania)

Customer Interaction:
• Requirements gathering
• End User training and support
Consulting:
• Solution Design
• Development and Testing (smoke - UAT)
Tools: SAP BusinessObjects BI (WebIntelligence, Xcelsius, Crystal Reports), SAP BPC (Business Planning and Consolidation), BusinessObjects Data Services (BODS), Microsoft SQL Server

Intern BusinessObjects BI Presales & Sales SAP Romania: July 2009 – July 2010 (SAP Romania, Bucharest, Romania)

Pre-Sales:
• Xcelsius Dashboards, Crystal Reports, Web Intelligence Documents for the sales team
• Customer demos
• Solution configurator setup for Romania
• Participation in SAP World Tour Romania (Xcelsius PoC)
Sales:
• Telemarketing
• Telesales and Cold calling

(II) Project history

1. Project role: SAP BusinessObjects Data Services Consultant: May 2014 – October 2017
Project goal: Centralise different source systems data into a unique Enterprise DWH. Create Enterprise Reporting System (Industry: Energy Trading)
Environment: Oracle 11g, HPALM, HPQC, JIRA, Confluence
Tools: SAP Business Objects Data Services 4.0; SAP Business Objects BI Platform 4.0/ 4.1
Data Sources: Endur (ETRM System), Oracle; MS SQL Server, Web Services and Files

2. Project role: Project manager: November 2013 – March 2014
Project goal: Standardize Financial Reporting System - Excels to Database (Industry: Financial Services - Debt collection)
Environment: Microsoft SQL Server 2008 R2
Tools: SAP Business Objects Edge BI 4.0 SP08 / 4.1; Microsoft SQL Server 2008 R2 (SQL Stored Procedures + SSIS ETL Packages)
Data Sources: Excel and CSV Files

3. Project role: SAP BusinessObjects Consultant: October 2013 - November 2013
Project goal: BusinessObjects BI System Recovery (Industry: Food Production)
Environment: SAP Business Objects Edge BI 4.0; SP08; SAP BW 7.0; Windows Server 2003 SP02
Tools: Notepad++ / Compare; Manually uploaded recovered universes
Data Sources: DB Backup; IFRS / OFRS

4. Project role: SAP BusinessObjects Team Leader: September 2013 - December 2013
Project goal: Construction projects’ profitability / GPS Reports and Dashboards for construction machinery (Industry: Construction)
Environment: SUSE Linux; Microsoft SQL Server 2008 R2
Tools: SAP Business Objects Edge BI 4.0
Data Sources: SP08SAP ERP ECC 6.0 (FI, PS, Z Tables); Custom GPS Software

5. Project role: SAP BusinessObjects Team Leader July 2013 - August 2013
Project goal: Upgrade from Business Objects EdgeBI 3.1 to Business Objects EdgeBI 4.0 (Industry: Beverage distribution)
Environment: SAP Business Objects Edge BI 3.1; SAP Business Objects Edge BI 4.0 SP07
Data Sources: SAP BW 7.3

6. Project role: SAP BusinessObjects Team Leader: May 2013 – November 2013
Project goal: Integrate Custom application data into the DWH (Industry: Logistics Parcel Delivery)
Environment: Custom “CARGO” Logistic Application; SAP BW 7.3
Tools: SAP Business Objects Edge BI 4.0; Microsoft SQL Server Integration Services
Data Sources: Custom application; Microsoft SQL Server 2008 R2

7. Project role: SAP BusinessObjects Team Leader: May 2013 - November 2013
Project goal: Profitability model 2.0 / Decommissioning of source systems / Change of targets (Industry: Logistics Parcel Delivery)
Environment: SAP BW 7.3
Tools: SAP Business Objects Edge BI 4.0 SP06
Data Sources: Microsoft SQL Server 2008 R2 MSAS; SAP ERP ECC 6.0; Wizcount

8. Project role: SAP BusinessObjects Consultant and Trainer March 2013 - April 2013
Project goal: Speed up reporting on the new solution (Industry: Lotteries)
Environment: Microsoft SQL Server 2008 R2; Microsoft Analysis Services 2008 R2
Tools: SAP BusinessObjects Edge BI 4.0 SP06
Data Sources: Microsoft SQL Server 2008 R2; Text Files

9. Project role: SAP BusinessObjects Team Leader March 2013 - April 2013
Project goal: Upgrade from Business Objects EdgeBI 3.1 to Business Objects EdgeBI 4.0 (Industry: Logistics Parcel Delivery)
Environment: Windows Server 2008 to 2008 R2; SQL Server 2008 to 2008 R2
Tools: Business Objects EdgeBI 3.1 to Business Objects EdgeBI 4.0

10. Project role: SAP Business Objects Consultant: January 2013 - April 2013
Project goal: Demo System integrating BOBJ with BPC (Industry: IT Business Consulting)
Environment: Sandbox system
Tools: SAP BPC 10.0 MS; SAP Business Objects Edge BI 4.0
Data Sources: Excel and CSV Files; Microsoft SQL Server 2008 R2

11. Project role: Technical leader and Consultant: November 2012 - April 2013
Project goals: POC Implementation of the public budgeting process (Industry: Public Sector)
POC Roll-out of the public budgeting process (Industry: Public Sector)
Environment: HP Datacenter
Tools: SAP BPC 10.0 MS; SAP Business Objects Edge BI 4.0
Data Sources: Excel files; Manual input

12. Project role: SAP BusinessObjects Consultant: September 2012 - December 2012
Project goal: Simplified reporting of Balance Sheet, P&L by route, Route Profitability (Industry: Budget Airline)
Environment: MS SQL Server 2008
Tools: SAP BPC 7.5 MS, SAP Business Objects Edge BI 3.1, SAP Business Objects Data Services 3.1
Data Sources: Excel; Manual Input; Navitaire; Microsoft Navision

13. Project role: SAP BusinessObjects Consultant: January 2012 - June 2012
Project goal: Integrating business view (Industry: Holding - Construction/ Airline/ Agriculture/ HORECA)
Environment: MS SQL Server 2008; Oracle
Tools: SAP BPC 7.5 MS; SAP Business Objects Edge BI 3.1
Data Sources: Excel, Manual Input

14. Project role: SAP BusinessObjects Consultant/ Project Manager: September 2011 - February 2012
Project goal: Implementation of the Public-Sector Budgeting process (Industry: Telecommunication/Public-Sector)
Environment: Microsoft SQL Server 2008
Tools: SAP BPC 7.5 MS
Data Sources: Excel 2003 & 2007, Manual input

15. Project role: SAP BusinessObjects Team Leader: November 2010 - August 2011
Project goal: Analyze net profitability by customer, service, product and branch (Industry: Parcel Delivery)
Environment: Custom “CARGO” application; SQL Server 2008 (SSIS, SSAS)
Tools: SAP Business Objects Edge BI 3.1; Xcelsius 2008
Data Sources: SQL Server 2008, Excel and CSV files; Accounting solution

16. Project role: SAP Business Objects Consultant: July 2010 - October 2010
Project goal: Near Real-time P&L (Industry: Telecom Site Construction)
Environment: SAP ERP
Tools: SAP Business Objects Edge BI 3.1; Xcelsius 2008, Crystal Reports 2008
Data Sources: SAP ERP (CJI3/GLPCA)