-
Software development company
- Consulting data migration Salesforce
2019 - 2019
Consulting data migration Salesforce
Software: Salesforce, MS Excel
Creation migration-templates, coordination ext. service provider
Optimization of data quality, data analysis
Check migrated data (plausibility, formulas)
-
Special constructions for vehicles
- Consulting revision calculation file
2018 - 2018
Consulting revision calculation file, automotive
Software: MS Excel 2016
Creation of a management overview
Revision calculation file car construction, improvement usability, time saving
-
consumer goods
- Consulting development controlling-tool
2018 - 2018
Consulting development controlling-tool, consumer goods
Software: VBA, MS Excel 2010
Special knowledge: reporting
Development controlling-tool, simplification of order- and invoicing procedures
Development control cockpit
With macros – automatization data-import, time saving
-
automotive industry
- Consultant Reporting Tool (freelance)
2017 - 2018
Developpment reporting tool, MS Excel basis
-
Automotive industry
- Interim FP&A Specialist (freelance)
2017 - 2017
Revision and developpment of various reports and tools with MS Excel and VBA (liquidity planning, bank reporting etc.)
-
Deutsche Bank
- Data management and MS Excel Specialist – development tools VBA and MS Excel (freelance)
Paris
2016 - 2016
Data management and MS Excel Specialist – development tools VBA and MS Excel
- Programming various tools (MS Excel and VBA macros) for efficient project-work
- Daily (logical) error control with MS Excel
- Revision project reporting with MS Excel
- Data management; creation, adaption and allocation of new ID’s to employees
-
Freelancer - Consultant
- MS Excel Specialist (freelance)
2016 - 2016
Development tool to simplify office-work with MS Excel & VBA
- Timesheets, invoicing and overview of revenue
- Developing a tool for user-friendly data entry of working time, automatic creation of
invoices and overview of revenue with MS Excel and VBA
- Developing VBA-form for simplified and clear data entry
- With VBA-macro, automatic creation of invoice possible for various clients
- Transferring data from invoice in overview revenues with macro
-
Dutch-German company, energy sector
- MS Excel Specialist – Reporting (freelance)
2015 - 2015
MS Excel Specialist – revision of personnel planning & development reporting
Revision of company-wide personnel planning with Excel 2010 and VBA
Personnel planning table and evaluation, complete in English
Characteristics planning table and reporting (start of the project):
- High complexity and significant processing time for professional and managerial staff
- High error susceptibility and problems evaluating data
- Manual evaluation of the captured data and reporting
Results of my work (end of the project):
Revision planning file:
- User-friendly, clear structure for a unified data entry
- Time-saving and simplified entry of data
- Development of a tool for data entry and transfer of data in planning file with a macro
- Analysis, pivot-tables with possibility of automatic update
-
The Linde Group
- PMO (Contract Management)
Saint-Priest
2012 - 2013
Software: MS Excel 2007 and 2010, SAP SD, VBA, Lotus Notes
Specialized knowledge: Project management, large-scale plant construction,
reporting, English, French
Projects: large-scale plant construction (pharmaceutical, chemical, gas and biotech plants).
Multi-project management, time-parallel administration of 10-15 long-term projects
Administration of projects with SAP SD and Lotus Notes
International Project teams (team members from China, Columbia, USA, India, Russia and
South Korea etc.)
- Support and reduction workload technical project manager
- Contact person for commercial and contractual questions for the project contract
(contracts in English and French)
- Planning time of invoicing on the basis of project contract and coordination
with department of project controlling, invoicing and monitoring payments, credit control
- Management of communication flow, interface between departments
(for example logistic, controlling, expatriate, tax and accounting)
- Organisation of Kick-Off/Milestone-Meetings
- Development Project reporting for a better project documentation
- Data query, analysis big data with MS Excel
- MS Excel training
- Support with MS Excel/VBA knowledge, special project
-
Pioneer Investment
- Sub project manager reporting & Business analyst reporting
2011 - 2012
Sub project manager introduction of new reporting software in the company
Introduction of Actuate Birt instead of SAP BO
- Support project manager project execution
- Stakeholder management
- Time planning (milestone-planning) in coordination with project manager and team members
- Error documentation and clarification of possible solutions
- Development project reporting for project manager
- Planning and organisation of multiplicator training
- Contact person for external service provider and employees
Business analyst reporting
- Ad-hoc-finance reporting with Business Objects and MS Excel, for example reports
for BAFIN and client-reports
- Further development and automatization of existing finance-reporting with MS Excel
and VBA
-
Siemens IT Soultions & Services (SIS)
- Project assistant human resources
2011 - 2011
Takeover SIS ATOS
Internal staffing action
Project members from HR and other departments
- Support project manager execution of project
- Administration of internal staffing action, support HR
- Development tool for a better administration of project with MS Excel
- Development project reporting
-
Goethe-Institut
- Revision reporting department controlling and accounting – MS Excel specialist
2010 - 2010
- Support department manager, reduction workload
- Revision reporting (especially budget planning) with MS Excel and VBA
- Organisation MS Excel training
-
LWP
- Project work & controlling and MS Excel (freelance)
2008 - 2010
development and programming tool KPI of company MS Excel and VBA
Analysis of all business activities law company
KPI for certification DIN EN ISO 9001:2008
More than 40 KPI
Project team of lawyers, controllers and other departments
My tasks
- Support and reduction workload project manager
- Development and technical implementation tool with MS Excel/VBA
- Interface & management of communication flow project manager & data entry team in
3 locations
- Development of an uniform database in MS Excel as basis for the evaluation
- Unification data of 3 different sources
- Close collaboration with IT, connecting to database (MS Query)
- Data management, data cleaning
- Calculation KPIs & development management reporting
- Work with pivot, matrix-functions, lookups etc.
- Control of validity
- Graphical presentation data
Close collaboration with marketing-department; publication KPI and design documents,
marketing for external presentation law company (for example for courts, internet etc.)
-
Leonhardt Westhelle & Partner
- Consulting business studies, controlling, MS Excel, accounting, law
2004 - 2010
Business and MS Excel services
Various lawyers, insolvency administrators – Kassel, Germany
Services:
- Development of various tools for simplification office work with MS Excel/VBA
- Analysis of accounting documentation
- Maintenance of homepage with content management system
- Development and design documents for presentation of company
- Finance planning
- Active involvement in restructuring plan
- Managing inventories
- Further services with commercial and legal reference (for example managing insolvency
appeals, processing insolvency proceedings with large administrative burden, and others)
