Alexandru Catalin Nicolae not available until 12/31/2018

Alexandru Catalin Nicolae

DWH Consultant and Team Developer - Freelancer

not available until 12/31/2018
Profileimage by AlexandruCatalin Nicolae DWH Consultant and Team Developer - Freelancer from Duesseldorf
  • 40237 Düsseldorf Freelancer in Germany
  • Graduation: Computer Science
  • Hourly-/Daily rates: not provided
  • Languages: German (good) | English (business fluent) | Romanian (first language)
  • Last update: 19.02.2018
KEYWORDS
PROFILE PICTURE
Profileimage by AlexandruCatalin Nicolae DWH Consultant and Team Developer - Freelancer from Duesseldorf
SKILLS

I am a certified Business Intelligence and Data Warehouse Consultant with more than 8 years of experience and implementation of more than 15 full-lifecycle projects across a wide range of industries, including Energy Trading, Financial Services, Parcel Delivery, Construction, Public Sector and Aviation.

(I) Areas of expertise:

Database:
- Microsoft SQL Server 2005-2012 – Installation/Maintenance/ Configuration/ Development/ Performance Tuning/ TSQL
- Oracle 10g/11g/12c – Development/ Performance Tuning/ PL/SQL
 Reporting / ETL:
- SAP BusinessObjects XI 3.1 / 4.0 / 4.1 Enterprise and Edge (BI Platform installation and administration, Universe Designer, IDT- Information Design Tool, Web Intelligence, Crystal Reports, Xcelsius / Dashboard Design)
- SAP BusinessObjects Data Services 3.1/4.0 (installation, ETL Design / Development / Full Push-Down /Performance Tuning)
- SAP BusinessObjects BPC 7.5/10.0 MS (Business Planning and Consolidation version for Microsoft Platform)
- Management Reporting, Budgeting, Management Consolidation, Regulatory Reporting (REMIT, EMIR), Business Dashboards, Profitability Models, Global Trade Model (GTM), Agile Implemented Reporting(AIR)
Modelling:
- Star-Schema, Snowflake, 3NF, bi-temporal historization, full / delta load, CDC
People management:
- 4 years of experience in managing 4 small IT teams both onshore and offshore
- Informal leadership and team building in NGOs and a Public Speaking organisation
Training:                
- Recently certified as a soft-skills trainer
 

(II) Certifications and training

      Project Management skills:
PMI Agile Certified Practitioner (PMI-ACP)® August 19th, 2016, Project Management Institute PMI
PROFESSIONAL SCRUM MASTER PSM I May 5th, 2016, scrum.org
PROFESSIONAL SCRUM PRODUCT OWNER PSPO I May 10th, 2016, scrum.org
PROFESSIONAL SCRUM DEVELOPER  PSD I April 8th, 2017, scrum.org
      SAP Solution skills:
Data Vault 2.0 Certification® (CDVP2®)  - February 2018
SAP Certified Application Associate - Data Integration with SAP Data Services 4.x August 29th, 2014, SAP
SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.0 November 26th, 2013, SAP
SAP Certified Support Associate - Incident Management with SAP BusinessObjects February 24th, 2011, SAP
SAP HANA Introduction boot-camp June 2015, Accenture (Prof. Dr Alexander Zeier)
      Technical skills:
ITIL 2011 Foundation October 15th, 2013, EXIN Cabinet Office, United Kingdom
Data Vault 2.0 Boot Camp And Certification September 2017, Scalefree.com
Informatica PowerCenter 10 Training  October-December 2017, Udemy
      Training and Leadership skills:
Certified Trainer and Speaker John C. Maxwell – John Maxwell Team
LAB Profile Certified Practitioner Shelle Rose Charvet

(III) Continuous improvement


I am in a continuous learning process in both personal and professional areas of my life. I am currently part of The John Maxwell Team and Toastmasters, and pursuing the following technical certifications:

Scaled Professional Scrum Certification - target date 2018
Certified Business Intelligence Professional (CBIP) - target date 2018
Certified Data Management Professional® (CDMP®) - target date 2018

(IV) Volunteering experience
Vice President Education
: February 2017 – Present (ToastMasters - The Bridge Speakers Düsseldorf)
• Orientation of new members including guide through Toastmasters curricula
• Learning path and mentorship program design and follow-up
Trainer and Project Manager of F.O.C.U.S. Training and Presentation Skills Projects: October 2008 – June 2012 (Team Work NGO, University of Bucharest, Romania)
• Project coordinator for F.O.C.U.S. training team
• Deliver Time Management training

REFERENCES

(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)

TIME AND SPATIAL FLEXIBILITY

It's being said: "New year, new challenges, new opportunities". I will be available starting January 2018.Anywhere in Europe, preferably with a good connection to my hometown, Düsseldorf.
Anywhere remote.

OTHER

Mission and vision:

I would like to become the preferred Partner for information-focused companies which implement a world-class Data Warehouse.
I support my clients in making informed decisions to improve their businesses and achieve higher performance, by helping them to transform data into information and then into knowledge.
My vision as a consultant is to share my knowledge and grow together with my team, and I do this by applying the training and leadership skills I have learned in the past years.

Social skills:
Team-spirit, agility, empathy, flexibility, inter-cultural awareness, attention to details

GET IN TOUCH

I accept the Conditions

I accept the terms of the privacy policy

Note: sending your contact request is free of charge

OTHER ONLINE PROFILES