Recommended expert

Tim Safarowsky

Freelance Business Intelligence Consultant

Tim Safarowsky
Nuremberg, Germany

Experience

Oct 2018 - Present
7 years 4 months

Freelance Business Intelligence Consultant

Self-employed

  • Ongoing support on a Lucanet project in Hamburg (logistics/financial market)
  • Advising on budgeting issues
  • Advising on questions related to asset accounting
  • Support in reporting
  • Lucanet implementation for a client near Munich (retail/building materials)
  • Support with initial setup
  • Preparation of data imports from Excel
  • Development of (SQL) interface to Navision data
  • Ongoing support on a Lucanet project in Munich (pharma/medical)
  • Data output in SQL Server
  • Support and advice on setting up consolidation (legal)
  • Ongoing support on a Lucanet project in Cologne (publishing)
  • Preparation of Excel imports
  • Support during initial setup (project restart)
  • Ongoing support on a Lucanet project in Ludwigsburg (chemicals, printing inks, hobby paints)
  • Connecting Lucanet to existing data warehouse solution (SQL)
  • Ongoing support on a Lucanet project in Bad Staffelstein (solar industry)
  • Connecting Lucanet to existing data warehouse solution (SQL)
  • Integration of Lucanet reporting package
  • Support and advice on setting up consolidation (legal & management)
  • Ongoing support on a Lucanet project in Zeven (transport and logistics)
  • Administration of existing Lucanet solution
  • Integration of Lucanet reporting package
  • Support and advice on setting up consolidation (legal & management)
  • Support for planning, forecasting
  • Lucanet implementation for a client in Luxembourg (retail)
  • Installation and setup
  • Support with initial setup
  • Preparation of data imports Excel/DWH interface
  • Lucanet implementation for a client in Nuremberg (manufacturing)
  • Support with project restart
  • Design for reporting and planning
  • Setup of import packages
  • Lucanet in-house consultant for an international software group focusing on M&A
  • Consulting and support for the corporate holding and business units regarding implementation, rollout and operation of the Lucanet disclosure management solution
  • Lucanet implementation for a client in Wassertrüdingen
  • Database setup and configuration
  • Connection of source systems with Lucanet interfaces
  • Consolidated financial statements setup
  • Support in the consolidation process
  • Support in the reporting process
  • Support of Lucanet for a client in Stuttgart
  • Support in the consolidation process
  • Support in the reporting process
  • Support in the planning process
  • Sparring partner for the specialist department
  • Support of Lucanet for a client in Landau
  • Implementation of cost center allocation in Lucanet
  • Support in the consolidation process
  • Lucanet carve-out support for a client in Waldstetten
  • Database setup and configuration
  • Design and implementation of BI software for a personnel service provider in Nuremberg
  • Integration of various source systems
  • Development of data warehouse and ETL processes
  • Creation of several cubes and data marts
  • Ongoing support and further development
  • Based on: Cubeware Importer, SQL Server, TM1
  • Design and implementation of BI software for an elevator company in Nuremberg
  • Integration of Navision BC
  • Development of data warehouse and ETL processes
  • Creation of several cubes and data marts
  • Based on: Cubeware Importer, SQL Server
  • Design and implementation of BI software for a logistics company in Leipzig
  • Integration of various source data
  • Development of data warehouse and ETL processes
  • Creation of several cubes and data marts
  • Based on: Cubeware Importer, SQL Server, TM1
  • Design and implementation of BI software for a corporate group in Freilassing
  • Integration of various source data
  • Development of data warehouse and ETL processes
  • Based on: Cubeware Importer, SQL Server, TM1
  • Design and implementation of a new reporting environment based on SQL Server and Power BI
  • Best practice advice for creating a data warehouse
  • Support in report creation in Power BI
  • Support in transforming an existing DWH solution to SAP BW
  • Analysis and documentation
  • Ongoing consulting on processes
  • Support in designing BW/SAC models
  • Reporting in SAC
  • Rebuilding a BI environment for an international company from Berlin (manufacturing/trade)
  • Connecting SAP BO to new DWH (SSIS)
  • Creation of tabular model cubes (SSAS)
  • Creation of reports and KPIs
  • User training
Mar 2012 - Sep 2018
6 years 7 months

(Senior) Consultant Business Intelligence and Lucanet

…syscon Unternehmensberatungsgesellschaft mbH

  • Planning and execution of customer projects
  • Connection and development of interfaces to Lucanet
  • Adjustments and enhancements of existing consolidation circles
  • Point of contact for content and technical questions on consolidation
  • Financial and liquidity planning with Lucanet
  • Reporting with the Lucanet Excel Add-In
  • Conceptual consulting
  • User training / on-the-job training
  • Planning and execution of numerous customer projects in business intelligence
  • Project coordination and management
  • Project documentation
  • Conceptual support in planning processes (financial planning)
  • Implementation of BI tools
  • Further development of existing BI landscapes
  • Data modeling and ETL processes
  • Support in pre-sales
  • User training / on the job training
  • Creation of reports and analyses
  • Mapping of planning processes
  • Introduction of planning solutions for corporate planning
  • Specifications
Jan 2009 - Jan 2012
3 years 1 month

International Sales Controller

ad pepper media International N.V.

  • Campaign controlling and reporting at international level
  • Sales controlling for all subsidiaries
  • Close cooperation with management and board
  • Ad-hoc analysis for management and board
  • Purchase/delivery controlling in close contact with sales and delivery teams
  • CRM controlling
  • Adserving calculation
  • Key user Cubeware and MS Dynamics AX 4.0
Feb 2006 - Dec 2008
2 years 11 months

Junior-Controller Finance and Sales

ad pepper media International N.V.

  • Participation in monthly, quarterly, and annual financial statements
  • Assistance in budget creation and monitoring
  • Help in developing and implementing new controlling instruments
  • Financial controlling for subsidiaries (provision of financial reports and actual vs. target comparison of financial data)
  • Ad-hoc analyses for management and board
  • Special business tasks

Skills

  • Very Good Knowledge Of Microsoft Sql Server
  • Very Good Knowledge Of Data Modeling
  • Very Good Knowledge Of Ssis / Ssas
  • Very Good Knowledge Of Power Bi
  • Good Knowledge Of T-sql
  • Good Knowledge Of Mdx And Dax
  • Very Good Knowledge Of Microsoft Excel
  • Good Knowledge Of Sap/bw Sac

Languages

German
Native
English
Advanced
French
Elementary

Education

Sep 2003 - Feb 2006

ad pepper media International N.V.

Office communication, accounting and controlling clerk

VWA Nürnberg

Business economist (VWA) · Business economist · Nuremberg, Germany

Certifications & licenses

Lucanet Certified Professional – Planning and Consolidation

Cubeware Certified Professional based on Microsoft Analysis Services

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Marco Skulschus
Marco Skulschus

Business Analyst, Data Warehouse Developer

View Profile
Stefan Corsten
Stefan Corsten

SSIS Development

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Guino Ndjenndja
Guino Ndjenndja

Senior Data Engineer

View Profile
Germo Görtz
Germo Görtz

BI Developer

View Profile
Henok Abraham
Henok Abraham

Founder and Managing Director

View Profile
Vitali Haberkorn
Vitali Haberkorn

Power BI Expert

View Profile
Ronny Herold
Ronny Herold

Senior Business, IT and Data Analyst, Portfolio Analyst

View Profile
Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Bernd Steckenbauer
Bernd Steckenbauer

Business Data Analyst | PowerBI & Microsoft SQL Server

View Profile
Eric Bouendeu
Eric Bouendeu

Quality Assurance Manager (QSV)

View Profile
German Popken
German Popken

Microsoft BI Specialist

View Profile
Guido Klein
Guido Klein

Power BI Report Developer

View Profile
Christian Dröge
Christian Dröge

Requirements Engineer

View Profile
William Nguyen
William Nguyen

Product Owner Frontend

View Profile
Kai Pankatz
Kai Pankatz

Oracle Project Management and DBA

View Profile
Peter Brungs
Peter Brungs

Data Warehouse Consultant (Development and Analysis)

View Profile
Stephan Martin
Stephan Martin

Sabbatical, professional development

View Profile
Markus Groh
Markus Groh

Data Solution Architect, Founder

View Profile
Philipp Grunert
Philipp Grunert

Data Scientist & Data Engineer

View Profile
Joachim Bleichert
Joachim Bleichert

Further development and maintenance of a company-wide monitoring database

View Profile
Frank Schneiderlöchner
Frank Schneiderlöchner

Principal Consultant

View Profile
Carsten Leschik
Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

View Profile
Gurpreet Dhami
Gurpreet Dhami

Digital Finance Consulting – Advanced Data Analysis

View Profile
Yannick Reinke
Yannick Reinke

Power Platform Developer

View Profile
Felix Reimann
Felix Reimann

SAP Analytics & Planning Expert

View Profile
Andre Wroblewski
Andre Wroblewski

PRINCE2® Foundation Examination

View Profile
Stefan Dangubic
Stefan Dangubic

BI Consultant in Controlling

View Profile
Evrim İlden
Evrim İlden

T-SQL Database Expert

View Profile
Jonathan Staude
Jonathan Staude

AI Consultant

View Profile