Skip to main content
Top expert badge
Recommended expert
Profile header background

Peter L.-Excel and Access Applications

Peter L. - Excel and Access Applications - profile avatar
Profile header overlay
Available
Holzkirchen, Germany

Check rate

Experience

Mar 2026 - Apr 2026
Munich, Germany

Calculator Redesign

TD Synnex GmbH & Co. oHG

Position summary
Calculator Redesign at TD Synnex GmbH & Co. oHG
Industries
Information Technology
Business areas
Business Intelligence
Finance
Information Technology
  • Two suppliers made extensive changes to the calculation and data provision. The calculation tool therefore needs to be adapted.
Oct 2025 - Jul 2026
Baunatal, Germany

Database Optimization

HVU Bildungsakademie gGmbH

Position summary
Database Optimization at HVU Bildungsakademie gGmbH
Industries
Education
Business areas
Information Technology
  • An existing Access database is to be optimized. This includes its structure, usability, and above all the expected significant time savings in its use.
  • The optimization is to be carried out step by step because all data must be retained and the changes must be made during ongoing operations.
  • The existing budget should be kept rather low.
  • Used: Access, VBA
Aug 2025 - Sep 2025
Holzkirchen, Germany

Inventory

MV E-Systems UG

Position summary
Inventory at MV E-Systems UG
Industries
Manufacturing
Business areas
Information Technology
Supply Chain Management
  • The company's product is made from a large number of individual components and parts, some of which have to be pre-assembled.
  • A simple, cost-effective Access database is needed to provide an overview of inventory, orders, and purchase orders.
  • Used: Access, VBA
Jul 2025 - Sep 2025
Munich, Germany

New Calculator

TD Synnex GmbH & Co. oHG

Position summary
New Calculator at TD Synnex GmbH & Co. oHG
Industries
Information Technology
Business areas
Information Technology
  • TD Synnex needs a new calculator for another supplier. The existing (original) calculator is therefore redesigned to display the modified price list structure.
  • Core areas such as simple item selection and creating customer calculators remain in place.
  • Used: Excel, Access, VBA
Jul 2025 - Jul 2025
Hamburg, Germany

Data Consolidation

COLIFT GmbH

Position summary
Data Consolidation at COLIFT GmbH
Industries
Professional Services
Business areas
Human Resources
  • Personnel data from various sources is to be loaded into a single Excel "database". Formatting corrections are made to ensure a consistent presentation.
  • Used: Excel, VBA
Jul 2025 - Jul 2025
Moosburg, Austria

Income and Expenses

Fit4Business GmbH

Position summary
Income and Expenses at Fit4Business GmbH
Industries
Professional Services
Business areas
Accounting
Finance
  • Clearly present income and expenses from account transactions, including comparisons, expense categorization, and an overview of changes over time.
  • Used: Excel
May 2025 - May 2025
Munich, Germany

Three Excel Applications

BLM Büroservice GmbH

Position summary
Three Excel Applications at BLM Büroservice GmbH
Industries
Professional Services
Business areas
Business Intelligence
  • Added to and improved three small Excel applications.
  • Used: Excel, VBA
Jan 2025 - May 2025
Munich, Germany

Calculator / Report Redesign

TD Synnex GmbH & Co. oHG

Position summary
Calculator / Report Redesign at TD Synnex GmbH & Co. oHG
Industries
Information Technology
Business areas
Business Intelligence
Information Technology
  • Made major adjustments due to several changes on the suppliers' side (changes to source data, products, and calculations).
  • Increased requirements from the country organizations also made adjustments and extensions necessary.
  • A report tool had to be adapted due to new data sources.
  • Used: Excel, VBA
Jan 2025 - May 2025
Allersberg, Germany

Hotel Database

bikeAlpin GmbH

Position summary
Hotel Database at bikeAlpin GmbH
Industries
Tourism
Business areas
Information Technology
  • Ongoing support, enhancement, and change requests.
  • Used: Access, VBA, Excel
Dec 2024 - Dec 2024
Allersberg, Germany

Hotel Database

bikeAlpin GmbH

Position summary
Hotel Database at bikeAlpin GmbH
Industries
Tourism
Business areas
Information Technology
  • Created an Excel calendar application so that the Access front end controls the Excel application, and the Excel application manipulates the Access front end.
  • The data is stored cleanly in the Access back end, changes can be made easily in the Access front end, and the overview is provided through an Excel calendar.
  • Maximum ease of use, because when switching between Excel and Access, the target application is already positioned on the correct records or cells.
  • Used: Access, Excel, VBA
Nov 2024 - Dec 2024
Munich, Germany

Calculator Redesign

TD Synnex GmbH & Co. oHG

Position summary
Calculator Redesign at TD Synnex GmbH & Co. oHG
Industries
Information Technology
Business areas
Finance
Information Technology
  • Change the calculation basis for a supplier from Listprice to Cost+.
  • Completely rebuild the exchange rate calculation to also allow any sales currency to be offered independently of the purchase currency.
  • Used: Excel, Access, VBA
Sep 2024 - Oct 2024
Munich, Germany

Calculator Redesign

TD Synnex GmbH & Co. oHG

Position summary
Calculator Redesign at TD Synnex GmbH & Co. oHG
Industries
Information Technology
Business areas
Information Technology
Product Development
  • Reactivate country-specific settings so that the subsidiaries in Austria and Switzerland can use the changes to the tool.
  • Used: Excel, Access, VBA
Jul 2024 - Sep 2024
Großkarolinenfeld, Germany

Heat Loss

ACE - Andrea Costa Engineering

Position summary
Heat Loss at ACE - Andrea Costa Engineering
Industries
Energy
Business areas
Business Intelligence
  • Add correct energy loss data to an existing Excel calculation tool. The calculations come from Andrea Costa, while I implemented them in Excel.
  • Used: Excel
May 2024 - Aug 2024
Munich, Germany

Calculator Redesign

TD Synnex GmbH & Co. oHG

Position summary
Calculator Redesign at TD Synnex GmbH & Co. oHG
Industries
Information Technology
Business areas
Information Technology
  • The proven and repeatedly modified calculation tool had to be extensively changed to represent the completely new item structure of one of the suppliers. The change was also used to implement performance improvements.
  • Used: Excel, Access, VBA
Jan 2024 - Mar 2024
Bietigheim-Bissingen, Germany

Project Controlling

Nidec GmbH

Position summary
Project Controlling at Nidec GmbH
Industries
Manufacturing
Business areas
Business Intelligence
Finance
  • The presentation that must be prepared every year needs to be updated. For this, many analyses and charts have to be checked and improved if necessary. The goal is both to complete the presentation and to identify and implement possible improvements.
  • Used: Excel
Dec 2023 - Jul 2024
Allersberg, Germany

Hotel Database

bikeAlpin GmbH

Position summary
Hotel Database at bikeAlpin GmbH
Industries
Tourism
Business areas
Information Technology
  • The database started in Jan. 2013 and continuously improved and expanded over the years must be completely redesigned due to changed requirements. This includes a modified data structure and, as a result, different workflows and output options.
  • The newly developed structure enables advanced functionalities that were not possible with the old approach. It also allows other time-saving workflows to be implemented. Many limitations that previously required extensive manual intervention are eliminated.
  • Used: Access, VBA
Nov 2023 - Nov 2023
Neuenbürg, Germany

Bills of Materials

Höckh GmbH

Position summary
Bills of Materials at Höckh GmbH
Industries
Manufacturing
Business areas
Operations
Product Development
  • Bills of materials from CAD and the enterprise resource planning system must be compared. The Excel tool displays the differences in color and as a list.
  • Used: Excel, VBA
Sep 2023 - Sep 2023
Munich, Germany

Reconciliacion Files

TD Synnex GmbH & Co. oHG

Position summary
Reconciliacion Files at TD Synnex GmbH & Co. oHG
Industries
Information Technology
Business areas
Information Technology
  • The Excel tool created from 11/2018 to 03/2019 had to be quickly converted to Access because there were more records than Excel allows in rows.
  • Used: Excel, Access, VBA
Mar 2023 - Aug 2023

Diverse

Diverse

Position summary
Diverse at Diverse
Industries
Automotive
Information Technology
Business areas
Business Intelligence
Information Technology
  • Various minor adaptations and changes to different projects for several companies (e.g. TD Synnex, Audi).
  • Used: Access, Excel, VBA
Jan 2023 - Feb 2023
Würzburg, Germany

Patient Data

Julius-Maximilians-Universität

Position summary
Patient Data at Julius-Maximilians-Universität
Industries
Education
Business areas
Information Technology
Research and Development
  • Patient data from various research and observation systems must be appropriately consolidated in an Access database and jointly output via export.
  • An analysis of patient histories was previously not meaningfully possible due to the different systems. The database provides the first cross-system evaluation option.
  • Used: Access, VBA, Excel
Dec 2022 - Feb 2023
Mönchengladbach, Germany

Invitation Database

Marketing Gesellschaft Mönchengladbach mbH

Position summary
Invitation Database at Marketing Gesellschaft Mönchengladbach mbH
Industries
Advertising
Business areas
Information Technology
Marketing
  • Creating an Access database to manage invitations to larger cultural events.
  • Creating invitations.
  • Tracking responses (attending / not attending, including the number of accompanying guests).
  • Taking specific groups of invitees into account.
  • Providing the option to manage seating assignments.
  • Used: Access, VBA, Excel
Aug 2022 - Jan 2023
Essen, Germany

Contact Database

RuhrFutur gGmbH

Position summary
Contact Database at RuhrFutur gGmbH
Industries
Education
Business areas
Information Technology
  • Creating an Access database to manage all people with whom RuhrFutur has been or is in contact.
  • Linking people with business partners (universities, ministries, companies, …).
  • Linking projects with people or business partners.
  • Creating and managing lists (e.g. Christmas mailings) for people at their business partners.
  • Enabling export and selection options across all areas (people, business partners, projects, lists).
  • The many separate Excel tables previously required are now combined in one database. This eliminates problems with duplicates, outdated data, inconsistencies, etc.
  • Used: Access, VBA, Excel
Jan 2022 - Jul 2022
Munich, Germany

Excel Pricing Tool Enhancement

Tech Data GmbH & Co. oHG

Position summary
Excel Pricing Tool Enhancement at Tech Data GmbH & Co. oHG
Industries
Information Technology
Business areas
Information Technology
  • Improving the tool created from 03/2018 - 10/2019 and incorporating supplier changes.
  • Adding further functionalities.
  • Improving performance.
  • Taking changes caused by suppliers into account.
  • Used: Excel, VBA, Access
Jan 2022 - Mar 2022
Lüneburg, Germany

Green Tourism

Leuphana Universität

Position summary
Green Tourism at Leuphana Universität
Industries
Tourism
Business areas
Business Intelligence
Research and Development
  • Supporting an Excel-based analysis: Data on the social and environmental criteria of package holidays was to be combined in an Excel tool and presented in a clear and useful way. The analysis logic was created by Leuphana, while I created the Excel-based analysis.
  • Used: Excel, VBA
Dec 2021 - Dec 2022
Ingolstadt, Germany

IT Continuity

Audi AG

Position summary
IT Continuity at Audi AG
Industries
Automotive
Business areas
Business Intelligence
Information Technology
  • Continuation of the project from 08/2017-11/2021.
  • Changing the calculation basis.
  • Expanding the graphical presentation.
  • Expanding the analyses.
  • Support and advice on current topics.
  • Improving data analysis.
  • Incorporating changes resulting from external requirements.
  • Used: Access, VBA, Excel, Powerpoint
Dec 2021 - Mar 2022
Munich, Germany

GMC Revision

MGS GmbH

Position summary
GMC Revision at MGS GmbH
Industries
Information Technology
Business areas
Business Intelligence
  • Revising and supplementing the "GMC" project from 12/2015 to 4/2016, and from 12/2016 and 5/2018 to 6/2018.
  • Used: Excel, VBA
Dec 2021 - Feb 2022
Frankfurt, Germany

Consulting on BCM Controls

KfW IPEX-Bank GmbH

Position summary
Consulting on BCM Controls at KfW IPEX-Bank GmbH
Industries
Banking and Finance
Business areas
Information Technology
Quality Assurance
  • The Excel-based workflow is to be transferred to an Access database. Existing weaknesses are to be eliminated and the possibilities of a database utilized. Purely consulting work by me; another company was to handle the implementation.
  • The customer knows and appreciates my solution approaches (from another project at another company) and the very fast implementation. The company carrying out the work can benefit from my knowledge of BCM, my ability to identify opportunities for improvement, and exotic Access application scenarios.
Oct 2021 - Oct 2021
Munich, Germany

Price Lists 1

Tech Data GmbH & Co. oHG

Position summary
Price Lists 1 at Tech Data GmbH & Co. oHG
Industries
Information Technology
Business areas
Business Intelligence
Information Technology
  • The supplier's monthly price list is automatically restructured so that an individual price list can be created for selected customers.
  • Used: Excel, VBA
Mar 2021 - Jun 2021
Germering, Germany

Automating TNW

Schober Beratung für Logistik

Position summary
Automating TNW at Schober Beratung für Logistik
Industries
Transportation
Professional Services
Business areas
Information Technology
Logistics
  • The consultants' monthly activity reports are automatically transferred to summary tables; plausibility checks are also performed.
  • Used: Excel, VBA
Jan 2021 - Feb 2021
Pullach, Germany

Expanding Project Overview

Hermes Arzneimittel GmbH

Position summary
Expanding Project Overview at Hermes Arzneimittel GmbH
Industries
Pharmaceutical
Business areas
Business Intelligence
  • Modifying an existing Excel document to significantly improve its processing and clarity.
  • Designing the modifications so that other documents with the same structure can easily be adapted. Transferring them into a template.
  • Selected topics for training in the use of Excel.
  • Used: Excel, VBA
Nov 2020 - May 2021
Munich, Germany

Excel Pricing Tool 2 / 3

Tech Data GmbH & Co. oHG

Position summary
Excel Pricing Tool 2 / 3 at Tech Data GmbH & Co. oHG
Industries
Information Technology
Business areas
Business Intelligence
Supply Chain Management
  • Based on the Excel Pricing Tools developed so far, create another one to represent an additional supplier.
  • Used: Excel, VBA, Access
Sep 2020 - Oct 2020
Munich, Germany

Excel Pricing Tool Extension

Tech Data GmbH & Co. oHG

Position summary
Excel Pricing Tool Extension at Tech Data GmbH & Co. oHG
Industries
Information Technology
Business areas
Finance
Information Technology
  • Extend the tool created from 03/2018 - 10/2019. Additional calculation methods (bonus models) are offered.
  • Extend the tool so that it can also be fully provided to customers, including its visual appearance.
  • Support for displaying the tool in other languages (currently DE, in the future at least EN).
  • Used: Excel, VBA, Access
Sep 2020 - Sep 2020
Murnau am Staffelsee, Germany

Scan-Print

Wiesendanger medien GmbH

Position summary
Scan-Print at Wiesendanger medien GmbH
Industries
Media and Entertainment
Business areas
Information Technology
  • Create a small Excel-based tool. An RFID scanner reads a code, and the corresponding value from a CSV file is then output as a barcode on a label printer.
  • Used: Excel, VBA
Apr 2020 - Nov 2021
Ingolstadt, Germany

IT Continuity

Audi AG

Position summary
IT Continuity at Audi AG
Industries
Automotive
Business areas
Business Intelligence
Information Technology
  • Continuation of the project from 08/2017-03/2020.
  • Transfer to a production environment.
  • Create an extended calculation ("Impact Matrix") that enables significantly more accurate results.
  • Add several analyses.
  • Additions to the graphical display of the current state, including information on possible measures and prioritization.
  • Used: Access, VBA
Mar 2020 - Mar 2020
Munich, Germany

Excel Pricing Tool Extension

Tech Data GmbH & Co. oHG

Position summary
Excel Pricing Tool Extension at Tech Data GmbH & Co. oHG
Industries
Information Technology
Business areas
Business Intelligence
Information Technology
  • Extend the tool created from 03/2018 - 10/2019 so that it can be used in several country offices.
  • Used: Excel, VBA, Access
Jan 2020 - Jan 2020
Germering, Germany

Distances

Schober Beratung für Logistik

Position summary
Distances at Schober Beratung für Logistik
Industries
Transportation
Professional Services
Business areas
Logistics
  • Calculate and enter road distances using the Google Maps API in an Excel list with starting points and destinations.
  • Used: Excel, VBA
Apr 2019 - Mar 2020
Böblingen, Germany

Excel Macro Programming PMO

Hewlett-Packard GmbH

Position summary
Excel Macro Programming PMO at Hewlett-Packard GmbH
Industries
Information Technology
Business areas
Information Technology
Project Management
  • Created and modified several small tools to process monthly internal time records.
  • Used: Excel, VBA
May 2018 - Jun 2018
Munich, Germany

GMC Revision

MGS GmbH

Position summary
GMC Revision at MGS GmbH
Industries
Information Technology
Business areas
Information Technology
  • Revised and expanded the "GMC" project from 12/2015 to 4/2016.
  • Used: Excel, VBA
Mar 2018 - Oct 2019
Munich, Germany

Excel Pricing Tool / Reconciliacion Files

Tech Data GmbH & Co. oHG

Position summary
Excel Pricing Tool / Reconciliacion Files at Tech Data GmbH & Co. oHG
Industries
Information Technology
Business areas
Business Intelligence
Information Technology
  • An existing Excel-based pricing tool had to be completely rebuilt. It creates a calculation interface from supplier price lists that takes the very frequent dependencies and restrictions into account and includes the customers' individual conditions.
  • For the first time, a tool was created that takes all the specifics of both suppliers into account, with simple and intuitive operation through filters and dropdown fields.
  • The basis for years of improvements and adjustments due to changes made by the suppliers.
  • Extremely efficient tool for preparing quotes, giving the inside sales team a unique selling point in the market.
  • Selected customers receive their own tool, which they can use to create quotes or orders themselves. None of the competitors offers even a remotely comparable tool, providing a major competitive advantage.
  • Created a tool to present monthly billing data for customers in both summary and detailed form.
  • Unmatched presentation of business transactions for customers, with the option of using them to create calculations for end customers as well. The volume of data no longer allows for manual processing.
  • Used: Excel, VBA, Access
Feb 2018 - Feb 2018

Tours

Privat

Position summary
Tours at Privat
Industries
Information Technology
Business areas
Information Technology
  • Created a private Access tour database to record and analyze sports activities (mountaineering, road cycling, MTB, ski touring, …).
  • Created to meet personal needs that were not covered by standard solutions.
  • No dependence on standard software that could eventually be discontinued and shut down by the manufacturer.
  • Used: Access, VBA
Aug 2017 - Mar 2020
Ingolstadt, Germany

IT Continuity

Audi AG

Position summary
IT Continuity at Audi AG
Industries
Automotive
Business areas
Information Technology
  • Revising an Access database design and creating the finished Access database for managing, tracking, and calculating continuity processes.
  • Contributing to the redesign of the underlying processes. In practice, recreating the Access database.
  • Data previously compiled manually is calculated within seconds and converted into standardized reports.
  • Changes can be implemented extremely efficiently thanks to a clean database structure. Significant reduction in staffing requirements while greatly expanding functionality and calculation accuracy.
  • Basis for further streamlining measures and functional enhancements.
  • Used: Access, VBA, Excel, Powerpoint
Feb 2017 - Jul 2017
Munich, Germany

Database Dictionary

Allianz AG

Position summary
Database Dictionary at Allianz AG
Industries
Insurance
Business areas
Information Technology
  • Revising an Access database design and creating the finished Access database for documenting database fields.
  • Used: Access, VBA
Jan 2017 - Jun 2017
Ottobrunn, Germany

Development Support

EKM GmbH

Position summary
Development Support at EKM GmbH
Industries
Information Technology
Business areas
Information Technology
Product Development
  • Implementing change requests or creating new functionalities for various EKM customers.
  • Software environment: GDI.
  • Used: GDI
Dec 2016 - Dec 2016
Nuremberg, Germany

Cost Savings 2

GfK SE

Position summary
Cost Savings 2 at GfK SE
Industries
Professional Services
Business areas
Business Intelligence
Information Technology
  • Completely rebuilding and functionally expanding the Access database worked on in May 2016.
  • Used: Access, VBA
Dec 2016 - Dec 2016
Munich, Germany

GMC Revision

MGS GmbH

Position summary
GMC Revision at MGS GmbH
Industries
Information Technology
Business areas
Business Intelligence
Information Technology
  • Revising and supplementing the "GMC" project from 12/2015 to 4/2016.
  • Used: Excel, VBA
Dec 2016 - Dec 2016
Allersberg, Germany

Hotel DB Lists

bikeAlpin GmbH

Position summary
Hotel DB Lists at bikeAlpin GmbH
Industries
Tourism
Business areas
Information Technology
Marketing
  • Improving the appearance of some lists and letters.
  • Creating another list and customer letter.
  • Used: Access, VBA
Nov 2016 - Nov 2016
Allersberg, Germany

Hotel DB Calendar

bikeAlpin GmbH

Position summary
Hotel DB Calendar at bikeAlpin GmbH
Industries
Sport
Tourism
Business areas
Information Technology
  • Integrating a calendar in Access to display all trips and guides over an entire season.
  • Links from the calendar directly to edit the trips.
  • Changes to the trips are displayed immediately in the calendar.
  • Used: Access, VBA
Sep 2016 - Sep 2016
Munich, Germany

Equal Opportunities

Fraunhofer Gesellschaft

Position summary
Equal Opportunities at Fraunhofer Gesellschaft
Industries
Professional Services
Business areas
Business Intelligence
Information Technology
  • Automating an Excel application previously operated manually to visualize key figures using VBA.
  • Used: Excel, VBA
Jul 2016 - Jul 2016
Allersberg, Germany

Hotel DB Post-Calculation

bikeAlpin GmbH

Position summary
Hotel DB Post-Calculation at bikeAlpin GmbH
Industries
Tourism
Business areas
Accounting
Business Intelligence
  • Continuing the work from Dec. 2015.
  • Used: Access, VBA
May 2016 - May 2016
Nuremberg, Germany

Cost Savings

GfK SE

Position summary
Cost Savings at GfK SE
Industries
Information Technology
Business areas
Information Technology
  • Getting an existing, faulty Access application up and running.
  • Used: Access, VBA
Apr 2016 - May 2016
Hamburg, Germany

Evaluation Tool

benchex GmbH

Position summary
Evaluation Tool at benchex GmbH
Industries
Information Technology
Business areas
Business Intelligence
  • Based on an existing Excel solution, create a new Excel tool that makes it possible to filter and consolidate the individual survey results and display the results.
  • Used: Excel, VBA
Dec 2015 - Apr 2016
Kaufering, Germany

GMC

ais Werbeagentur GmbH

Position summary
GMC at ais Werbeagentur GmbH
Industries
Advertising
Energy
Real Estate
Business areas
Business Intelligence
Information Technology
  • MGS Münchner Gesellschaft für Stadterneuerung mbH needed an Excel-based way to create an individual energy check for existing buildings for its customers.
  • First solution "from a single source" (Excel only).
  • Free data entry with no quantity restrictions.
  • The result is an approximately 30-page booklet that does not reveal that it was generated with Excel.
  • Used: Excel, VBA
Dec 2015 - Dec 2015
Allersberg, Germany

Hotel DB Post-Calculation

bikeAlpin GmbH

Position summary
Hotel DB Post-Calculation at bikeAlpin GmbH
Industries
Tourism
Business areas
Business Intelligence
Information Technology
  • Expanded the hotel database to record and evaluate all invoices.
  • Used: Access, VBA
Mar 2015 - Dec 2016
Euskirchen, Germany

Training Management / Weclapp

Laufcampus GmbH

Position summary
Training Management / Weclapp at Laufcampus GmbH
Industries
Sport
Business areas
Information Technology
  • Repeatedly expanded and improved the application upgraded in Feb. 2015.
  • Consolidated and cleaned up approximately 10,000 addresses from various sources in Excel.
  • Set up a database for the CMS Weclapp together with the customer.
  • Imported the addresses into Weclapp.
  • Used: Excel, VBA
Mar 2015 - Mar 2015
Munich, Germany

CREDIT

Munich Re AG

Position summary
CREDIT at Munich Re AG
Industries
Insurance
Business areas
Information Technology
  • Modified the Access database created from July to Aug. 2011.
  • Switched to Office 2013 and Win7.
  • Made minor adjustments.
  • Used: Access, VBA, Excel
Feb 2015 - Feb 2015
Euskirchen, Germany

Training Management

Laufcampus GmbH

Position summary
Training Management at Laufcampus GmbH
Industries
Retail
Sport
Business areas
Information Technology
  • Improved an existing Excel file in terms of functionality and appearance.
  • Used: Excel, VBA
Dec 2014 - Dec 2014
Allersberg, Germany

Cycling Jerseys

bikeAlpin GmbH

Position summary
Cycling Jerseys at bikeAlpin GmbH
Industries
Tourism
Business areas
Information Technology
  • Created a small Access database to provide an overview of sold cycling jerseys by size.
  • Used: Access, VBA, Excel
Jan 2014 - Feb 2014
Allersberg, Germany

Hotel Database

bikeAlpin GmbH

Position summary
Hotel Database at bikeAlpin GmbH
Industries
Tourism
Business areas
Information Technology
  • Improved the database created the previous year.
  • Used: Access, VBA
Nov 2013 - Dec 2013
Munich, Germany

ENP Database / Renewal 2014 / MGA Monitoring Tool

Munich Re AG

Position summary
ENP Database / Renewal 2014 / MGA Monitoring Tool at Munich Re AG
Industries
Insurance
Business areas
Business Intelligence
Information Technology
  • Created an Access database for managing risks, with quarterly data delivery from Excel and a 4-step update process.
  • Mainly reformatted customer claims data in Excel tables into machine-processable formats, partly with the help of self-created VBA tools.
  • Also created smaller tools, analyses, etc.
  • Converted the Excel solution created from Apr. to May 2011 to Access.
  • Used: Access, VBA, Excel
Jan 2013 - Jun 2013
Allersberg, Germany

Hotel Database

bikeAlpin GmbH

Position summary
Hotel Database at bikeAlpin GmbH
Industries
Tourism
Business areas
Information Technology
  • Created an Access database for booking all trips, hotel stays, luggage transport, return trips, and shuttles.
  • Created various lists and documents for customers and guides.
  • Created a calendar to provide an overview of the status of all trips.
  • The new Access database made things much easier and created the basis for several extensions.
  • Used: Access, VBA
Dec 2012 - Mar 2013
Munich, Germany

Occupations Database

Munich Re AG

Position summary
Occupations Database at Munich Re AG
Industries
Insurance
Business areas
Information Technology
  • Creating an Access database to manage occupational figures.
  • Connecting to an existing database via Excel interfaces.
  • Used: Access, VBA, Excel
Oct 2012 - Dec 2012
Munich, Germany

Renewal 2013 / CREDIT 2

Munich Re AG

Position summary
Renewal 2013 / CREDIT 2 at Munich Re AG
Industries
Insurance
Business areas
Business Intelligence
Information Technology
  • Primarily reformatting Excel spreadsheets containing customers' claims data into machine-readable formats, partly with the help of self-created VBA tools.
  • Expanding the database created in July and Aug. 2011 with additional functionality and linking it to another Access database.
  • Used: Access, VBA, Excel
Jun 2012 - Jul 2012
Eschborn, Germany

Sampling

Techem GmbH

Position summary
Sampling at Techem GmbH
Industries
Utilities
Business areas
Information Technology
  • Completing an Excel-based database for managing water sampling points (Legionella testing).
  • Interface for data communication with the testing laboratory.
  • Printing forms and sample labels.
  • Used: Excel, VBA
Jun 2012 - Jun 2012
Munich, Germany

Fahr & Spar Summer/Autumn 2012

BMW AG

Position summary
Fahr & Spar Summer/Autumn 2012 at BMW AG
Industries
Automotive
Business areas
Information Technology
  • Adapting the existing database to the requirements of an additional campaign.
  • Used: Access, VBA
Feb 2012 - Feb 2012
Munich, Germany

Fahr & Spar 2012

BMW AG

Position summary
Fahr & Spar 2012 at BMW AG
Industries
Automotive
Business areas
Information Technology
  • Adapting an existing Access database to the requirements of this year's campaign.
  • Migration from Access 2003 / Win XP to Access 2007 / Windows 7.
  • Used: Access, VBA
Oct 2011 - Dec 2011
Munich, Germany

Renewal 2012

Munich Re AG

Position summary
Renewal 2012 at Munich Re AG
Industries
Insurance
Business areas
Business Intelligence
Information Technology
  • Primarily reformatting Excel spreadsheets containing customers' claims data into machine-processable formats, partly with the help of self-created VBA tools.
  • Also creating smaller tools, analyses, etc.
  • Used: Excel, VBA
Sep 2011 - Oct 2011
Allersberg, Germany

Maps

bikeAlpin GmbH

Position summary
Maps at bikeAlpin GmbH
Industries
Tourism
Business areas
Information Technology
Production
  • Arranging for maps to be scanned.
  • Calibrating, cropping, and assembling scans.
  • Converting into various formats.
  • Used: QuoVadis, GlobalMapper
Jul 2011 - Aug 2011
Munich, Germany

CREDIT 2

Munich Re AG

Position summary
CREDIT 2 at Munich Re AG
Industries
Insurance
Business areas
Accounting
Information Technology
  • Creating a new Access database that enables monitoring of business transactions.
  • Revising the existing Excel transfer frontend.
  • Converting the existing Excel database.
  • Automating daily booking processes, including importing data from Outlook, posting entries, checking limits, and generating emails.
  • Generating several analyses to monitor business transactions.
  • Automation made it possible to obtain exact data for the first time.
  • Used: Access, VBA, Excel, Outlook
Apr 2011 - May 2011
Munich, Germany

MGA Monitoring Tool

Munich Re AG

Position summary
MGA Monitoring Tool at Munich Re AG
Industries
Insurance
Business areas
Business Intelligence
  • Creating an Excel-based monitoring program that compares insurance data with claims data.
  • Quarterly cumulative import of data deliveries from the customer.
  • Displaying approximately 30 KPIs, both in tables and graphs.
  • Integrating an extensive filter.
  • Used: Excel, VBA
Apr 2011 - Apr 2011
Allersberg, Germany

Maps

bikeAlpin GmbH

Position summary
Maps at bikeAlpin GmbH
Industries
Tourism
Business areas
Product Development
  • Creating digital maps.
  • Calibrating, cropping, and assembling scans.
  • Converting into various formats.
  • Used: QuoVadis, GlobalMapper
Oct 2010 - Dec 2010
Munich, Germany

Renewal 2011

Munich Re AG

Position summary
Renewal 2011 at Munich Re AG
Industries
Insurance
Business areas
Business Intelligence
Information Technology
  • Primarily reformatting Excel spreadsheets containing customers' claims data into machine-processable formats.
  • Also creating smaller tools, analyses, etc.
  • Used: Excel, VBA
Oct 2009 - Dec 2009
Munich, Germany

Renewal 2010

Munich Re AG

Position summary
Renewal 2010 at Munich Re AG
Industries
Insurance
Business areas
Business Intelligence
  • Primarily reformatting Excel spreadsheets containing customers' claims data into machine-processable formats.
  • Massive time savings and elimination of manual errors through automation.
  • Used: Excel, VBA
Sep 2009 - Sep 2009
Allersberg, Germany

Elevation Profile Generator

bikeAlpin GmbH

Position summary
Elevation Profile Generator at bikeAlpin GmbH
Industries
Tourism
Business areas
Information Technology
  • Creating an Excel program to generate elevation profiles for the tours offered.
  • Importing GPX files and providing layout options for the elevation profiles.
  • Output as scaled elevation profiles including point labels.
  • Used: Excel, VBA
Jun 2000 - Oct 2008
Sauerlach, Germany

Order Processing

Fa. Schiedel / BTG Schornsteintechnik

Position summary
Order Processing at Fa. Schiedel / BTG Schornsteintechnik
Industries
Construction
Manufacturing
Business areas
Logistics
Operations
Production
  • Production and distribution of chimney systems.
  • Order processing.
  • Creation and maintenance of an Excel-based order form.
  • Creation and maintenance of an Access database for order tracking, production planning and coordination across multiple locations, as well as assigning freight forwarders.
Mar 1997 - May 2000
Munich, Germany

Wealth Management Clerk

Bankhaus Merck Finck & Co

Position summary
Wealth Management Clerk at Bankhaus Merck Finck & Co
Industries
Banking and Finance
Business areas
Accounting
Finance
  • Reviewing daily automatically imported account transactions and corporate actions.
  • Manually updating corporate actions that cannot be automated.
  • Preparing daily reconciliations of internal clearing accounts using Excel: extracting data from print files, creating account balances, and reconciling them with externally supplied total balances.
Aug 1995 - Feb 1997
Taufkirchen, Germany

Export Order Processing

Ortovox Sportartikel GmbH

Position summary
Export Order Processing at Ortovox Sportartikel GmbH
Industries
Sport
Business areas
Logistics
Operations
Production
  • Production of sporting goods for ski touring equipment, backpacks, and clothing.
  • Creation of production and requirements plans with Excel.
Sep 1992 - May 1995
Munich, Germany

Trainee Commercial Specialist

F.W. Schubert GmbH

Position summary
Trainee Commercial Specialist at F.W. Schubert GmbH
Industries
Retail
Business areas
Procurement
Sales
Supply Chain Management
  • Training to become a commercial specialist through a work-integrated education program.
  • Examination for commercial specialist in May 1995.
  • AdA examination in Dec 1994.
  • Examination to become a wholesale and foreign trade merchant in Jan 1994.
Oct 1991 - Dec 1991

Surveying Student

FH-Studium

Position summary
Surveying Student at FH-Studium
Industries
Education
Business areas
Research and Development
Jul 1990 - Jun 1991
Munich, Germany

Military Service / Administrative Work

Bundeswehruniversität Neubiberg

Position summary
Military Service / Administrative Work at Bundeswehruniversität Neubiberg
Industries
Education
Government and Administration
Business areas
Operations
  • Basic training in Amberg.
  • Administrative work in the student housing department of the Bundeswehruniversität.
Jan 1982 - Dec 1990
Munich, Germany

Student

Asam-Gymnasium

Position summary
Student at Asam-Gymnasium
Industries
Education
  • Graduation: Abitur with advanced courses in mathematics and physics.
Jan 1976 - Dec 1982
Sauerlach, Germany

Student

Volksschule Sauerlach

Position summary
Student at Volksschule Sauerlach
Industries
Education

Industry experience

See where this freelancer has spent most of their professional time.

Experienced in Education, Manufacturing, Construction, Automotive, Information Technology, and Banking and Finance.

Education
Manufacturing
Construction
Automotive
Information Technology
Banking and Finance
Profile match chart

Business area experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Operations, Logistics, Production, Business Intelligence, and Finance.

Information Technology
Operations
Logistics
Production
Business Intelligence
Finance
Profile match chart

Summary

Creation and optimization of Excel and Access applications

  • Comprehensive knowledge across various industries
  • Flexible and timely implementation of your programming requirements
  • Attentive, committed, and structured working style
  • All the advantages of an external employee

Skills

  • Windows Environment (Xp, Vista, Windows 7, Windows 10, Windows 11)
  • Microsoft Office (2003, 2007, 2010, 2013, 2016, 2024)
  • Excel Including Vba Programming
  • Access Including Vba Programming

Languages

German
Native
English
Advanced
French
Elementary
Italian
Elementary

Education

Sep 1992 - May 1995

F.W. Schubert GmbH

Business Specialist through an integrated vocational education program · Munich, Germany

Oct 1991 - Dec 1991

Surveying

Oct 1982 - Jun 1990

Asam-Gymnasium

Abitur · Munich, Germany

...and 1 more

Statistics

Experience

Total positions 81
Experience in Education 17 y
Avg length 8 m
Longest experience 8 y 11 m

Global experience

Countries worked in 2 (Germany, Austria)
Primary country Germany

Expertise

Recent roles Calculator Redesign, Database Optimization, Inventory
Main industries Education, Manufacturing, Construction
Main business areas Information Technology, Operations, Logistics

Qualifications

Member since
Last update
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Have questions? Find more information here.

Peter is based in Holzkirchen, Germany.

Peter speaks the following languages: German (Native), English (Advanced), French (Elementary), Italian (Elementary).

Peter has at least 44 years of experience. During this time, Peter has worked in at least 66 different roles and for 42 different companies. The average length of individual experience is 1 year and 7 months. Note that Peter may not have shared all experience and actually has more experience.

Based on recent experience, Peter would be well-suited for roles such as: Calculator Redesign, Database Optimization, Inventory.

Peter's most recent position is Calculator Redesign at TD Synnex GmbH & Co. oHG.

In recent years, Peter has worked for TD Synnex GmbH & Co. oHG, HVU Bildungsakademie gGmbH, MV E-Systems UG, COLIFT GmbH, and Fit4Business GmbH.

Peter is most experienced in industries like Education, Manufacturing, and Construction. Peter also has some experience in Automotive, Information Technology, and Banking and Finance.

Peter is most experienced in business areas like Information Technology, Operations, and Logistics. Peter also has some experience in Production, Business Intelligence, and Finance.

Peter has recently worked in industries like Automotive, Information Technology, and Education.

Peter has recently worked in business areas like Information Technology, Business Intelligence, and Finance.

Peter attended F.W. Schubert GmbH for Business Specialist through an integrated vocational education program.

Peter is immediately available for suitable projects.

Daily rate distribution

0% 25% 50% 75% 100%
10% of experts charge less than €800 per day.
40% of experts charge between €800 and €880 per day.
20% of experts charge between €880 and €960 per day.
20% of experts charge between €960 and €1040 per day.
10% of experts charge €1120 or more per day.
<€800 €800-​880 €880-​960 €960-​1040 €1120+

The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1000
750
500
250
Rate comparison chart
Daily rate avg. 865 €

The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.

1000
750
500
250
Rate comparison chart
Median rate 840 €

The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.

Calculated based on our freelancers’ daily rates as of 6 Nov 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.