Alexandru Catalin Nicolae verfügbar

Alexandru Catalin Nicolae

DWH/Data Vault Consultant and Team Developer - Freelancer

verfügbar
Profilbild von AlexandruCatalin Nicolae DWH/Data Vault Consultant and Team Developer - Freelancer aus Duesseldorf
  • 40237 Düsseldorf Freelancer in
  • Abschluss: nicht angegeben
  • Stunden-/Tagessatz: nicht angegeben
  • Sprachkenntnisse: deutsch (gut) | englisch (verhandlungssicher) | rumänisch (Muttersprache)
  • Letztes Update: 28.05.2019
SCHLAGWORTE
PROFILBILD
Profilbild von AlexandruCatalin Nicolae DWH/Data Vault Consultant and Team Developer - Freelancer aus Duesseldorf
DATEIANLAGEN
LebensLauf

Diese Anzeige ist nur für angemeldete Nutzer möglich.

Zertifikate

Diese Anzeige ist nur für angemeldete Nutzer möglich.

Gallup Certificate

Diese Anzeige ist nur für angemeldete Nutzer möglich.

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:
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:
Data Vault 2.0 Certification® (CDVP2®) 
- February 2018
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
Data Vault Modeling  February 2018, Genesee Academy
      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 (TeamWork NGO, University of Bucharest, Romania)
• Project coordinator for F.O.C.U.S. training team
• Deliver Time Management training
PROJEKTHISTORIE
(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)
ZEITLICHE UND RÄUMLICHE VERFÜGBARKEIT
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.
SONSTIGE ANGABEN
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
KONTAKTANFRAGE VERSENDEN

Nachricht:

Absenderdaten: