Recommended expert
Tim Safarowsky
Freelance Business Intelligence Consultant
Experience
Oct 2018 - Present
7 years 4 monthsFreelance 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 monthInternational 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 monthsJunior-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
NativeEnglish
AdvancedFrench
ElementaryEducation
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