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

Peter Listmann-Excel and Access Applications

Peter Listmann - Excel and Access Applications - profile avatar
Profile header overlay
Holzkirchen, Germany

Check rate

Experience

Mar 2026 - Apr 2026
Munich, Germany

Calculator Overhaul

TD Synnex GmbH & Co. oHG

Position Summary
Calculator Overhaul at TD Synnex GmbH & Co. oHG
Industries
Information Technology
Business Areas
Business Intelligence
Finance
Information Technology
  • Two suppliers made extensive changes to the calculations and data provisioning. Therefore, the calculation tool needs to be adjusted.
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, including structure, usability, and especially to achieve significant time savings in operation.
  • The optimization should be done in steps because all data must be preserved and the changes have to be implemented during operation.
  • The budget should be kept rather small.
  • 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 variety of individual components that need to be partially preassembled.
  • To keep track of stock levels, orders, and purchases, a simple, low-cost Access database is needed.
  • 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 modified to represent the changed price list structure.
  • Core features like simple item selection and creating customer calculators remain unchanged.
  • 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 different sources are to be loaded into a single Excel "database". Formatting corrections are applied for a uniform 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 show income and expenses from account transactions, with comparisons, expense categories, and a view of how they change 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 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 after several changes by suppliers (source data, products, calculations).
  • Responded to higher demands from country branches, requiring changes and expansions.
  • Updated a report tool to work with 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, enhancements, 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 the Access front end controls Excel and Excel controls the Access front end.
  • Kept data clean in the Access back end, made it easy to change data in the Access front end, and gave an overview through an Excel calendar.
  • Ensured maximum ease of use by having the target application already focused on the right records or cells when switching between Excel and Access.
  • 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 at a supplier from list price to Cost+.
  • Completely rebuild the exchange rate calculation to allow offering any sales currency regardless 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 local companies 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, and I handled the Excel implementation.
  • 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 heavily modified calculation tool must be significantly changed to map the completely new item structure of one supplier. At the same time, the change is 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 annual presentation must be updated. This requires checking and possibly improving many analyses and charts. The goal is to both finish the presentation and identify and implement improvement opportunities.
  • 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 improved and expanded over the years, needs to be completely rebuilt due to changed requirements. This includes a new data structure and, consequently, different workflows and output options.
  • With the newly built structure, enhanced functionalities can be created that were not possible before. It also allows other time-saving workflows. Many limitations that previously required significant manual intervention are removed.
  • Used: Access, VBA
Nov 2023 - Nov 2023
Neuenbürg, Germany

Bill of Materials

Höckh GmbH

Position Summary
Bill of Materials at Höckh GmbH
Industries
Manufacturing
Business Areas
Operations
Product Development
  • Bills of materials from CAD and the ERP system need to be reconciled. The Excel tool highlights differences in color and lists them.
  • Used: Excel, VBA
Sep 2023 - Sep 2023
Munich, Germany

Reconciliation Files

TD Synnex GmbH & Co. oHG

Position Summary
Reconciliation Files at TD Synnex GmbH & Co. oHG
Industries
Information Technology
Business Areas
Information Technology
  • The Excel tool, developed between Nov 2018 and Mar 2019, had to be quickly converted to Access due to more records than Excel's row limit allowed.
  • Used: Excel, Access, VBA
Mar 2023 - Aug 2023

Various

Various

Position Summary
Various at Various
Industries
Automotive
Information Technology
Business Areas
Business Intelligence
Information Technology
  • Various minor adjustments and changes on 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 monitoring systems needed to be combined into an Access database and exported together.
  • Previously, viewing patient histories across different systems was not practical. The database now allows cross-system analysis for the first time.
  • Used: Access, VBA, Excel
Dec 2022 - Feb 2023
Mönchengladbach, Germany

Invitation DB

Marketing Gesellschaft Mönchengladbach mbH

Position Summary
Invitation DB at Marketing Gesellschaft Mönchengladbach mbH
Industries
Advertising
Business Areas
Information Technology
Marketing
  • Created an Access database to manage invitations for larger cultural events.
  • Created invitations.
  • Tracked responses (attending / not attending, with how many guests).
  • Managed specific groups of invitees.
  • Handled seat allocations.
  • 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
  • Built an Access database to manage all people RuhrFutur has been or is in contact with.
  • Linked individuals with business partners (universities, ministries, companies, etc.).
  • Connected projects with people or business partners.
  • Created and managed lists (e.g., holiday mailings) for people at their business partners.
  • Enabled export and selection options across all areas (people, business partners, projects, lists).
  • Consolidated many separate Excel sheets into one database, eliminating duplicates, outdated data, inconsistencies, etc.
  • Used: Access, VBA, Excel
Jan 2022 - Jul 2022
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
Information Technology
  • Improved the tool created from 03/2018 to 10/2019 and integrated supplier updates.
  • Added additional functionalities.
  • Improved performance.
  • Addressed changes caused by suppliers.
  • 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
  • Supported an Excel-based evaluation: compiled data on social and environmental criteria of package tours into an Excel tool and presented it visually. Evaluation logic created by Leuphana; analysis implemented in Excel.
  • 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
  • Continued the project from 08/2017 to 11/2021.
  • Changed the calculation basis.
  • Enhanced graphical representation.
  • Expanded reports.
  • Provided support and advice on current topics.
  • Improved data analysis.
  • Implemented 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
  • Revised and extended the "GMC" project from 12/2015 to 4/2016, and again in 12/2016 and from 5/2018 to 6/2018.
  • Used: Excel, VBA
Dec 2021 - Feb 2022
Frankfurt, Germany

BCM Controls Consulting

KfW IPEX-Bank GmbH

Position Summary
BCM Controls Consulting at KfW IPEX-Bank GmbH
Industries
Banking and Finance
Business Areas
Information Technology
Quality Assurance
  • The Excel-based workflow was to be implemented in an Access database. Existing weaknesses were to be removed and the capabilities of a database leveraged. I provided pure consulting; another company handled the implementation.
  • The client knows and values my solution approaches (from another project at a different company) and the very fast execution. The implementing company can benefit from my knowledge of BCM, spotting improvement opportunities, and unusual application scenarios in Access.
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 transformed to create an individual price list for selected customers.
  • Used: Excel, VBA
Mar 2021 - Jun 2021
Germering, Germany

TNW Automation

Schober Beratung für Logistik

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

Project Overview Extension

Hermes Arzneimittel GmbH

Position Summary
Project Overview Extension at Hermes Arzneimittel GmbH
Industries
Pharmaceutical
Business Areas
Business Intelligence
  • Modified an existing Excel document to greatly improve editing and clarity.
  • Designed the modifications so that other similarly structured documents can be easily upgraded and incorporated into a template.
  • Covered selected topics in training on how to use 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 existing Excel pricing tools, create another one to include an additional supplier.
  • Used: Excel, VBA, Access
Sep 2020 - Oct 2020
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
Finance
Information Technology
  • Extend the tool created from 03/2018 to 10/2019 by adding additional calculation methods (bonus models).
  • Adapt the tool so it can be fully delivered to customers in their own corporate design.
  • Add support for other languages (currently DE, in 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. A code is scanned with an RFID scanner, and the associated value from a CSV file is printed 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 to 03/2020.
  • Transition to a production environment.
  • Create an extended calculation ("Impact Matrix") that provides significantly more accurate results.
  • Add several reports.
  • Add enhancements for a graphical view of the current state with notes on possible actions and prioritization.
  • Used: Access, VBA
Mar 2020 - Mar 2020
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
Business Intelligence
Information Technology
  • Enhance the tool created from 03/2018 to 10/2019 so it can be used in several country offices.
  • Used: Excel, VBA, Access
Jan 2020 - Jan 2020
Germering, Germany

Distance calculations

Schober Beratung für Logistik

Position Summary
Distance calculations at Schober Beratung für Logistik
Industries
Transportation
Professional Services
Business Areas
Logistics
  • Calculate and enter road distances in an Excel sheet with start and destination locations using the Google Maps API.
  • 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
  • Create or modify several small tools to process monthly time tracking internally.
  • Used: Excel, VBA
May 2018 - Jun 2018
Munich, Germany

GMC Overhaul

MGS GmbH

Position Summary
GMC Overhaul at MGS GmbH
Industries
Information Technology
Business Areas
Information Technology
  • Revise and enhance the "GMC" project from 12/2015 to 4/2016.
  • Used: Excel, VBA
Mar 2018 - Oct 2019
Munich, Germany

Excel Pricing Tool / Reconciliation Files

Tech Data GmbH & Co. oHG

Position Summary
Excel Pricing Tool / Reconciliation 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 generates a calculation interface from supplier price lists that takes into account the frequent dependencies and constraints and includes the customers' individual terms.
  • For the first time, a tool that considers all conditions of both suppliers and offers simple, intuitive operation via filters and dropdown fields.
  • Basis for long-term improvements and adjustments due to supplier changes.
  • Extremely efficient tool for creating quotes, giving the internal sales team a unique selling point in the market.
  • Selected customers receive their own tool that allows them to generate quotes or orders themselves. None of the competitors offers anything even remotely comparable, a massive competitive advantage.
  • Created a tool to present monthly billing data for customers both summarized and in detail.
  • Unrivaled presentation of business transactions for customers with the option to create calculations for end customers. The data volume no longer allows manual processing.
  • Used: Excel, VBA, Access
Feb 2018 - Feb 2018

Tours

Privat

Position Summary
Tours at Privat
Industries
Information Technology
Business Areas
Information Technology
  • Create a private Access tour database to record and analyze sporting activities (mountaineering, road cycling, MTB, ski touring, …).
  • Built to meet personal needs not covered by standard solutions.
  • No dependency on standard software that the vendor might discontinue or shut down.
  • 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
  • Revised an Access database design and created the final Access database to manage, track, and calculate continuity processes.
  • Contributed to the redesign of the underlying processes. Essentially rebuilt the Access database from scratch.
  • Data that was previously compiled manually is now processed within seconds and converted into standardized reports.
  • Changes can be made extremely efficiently thanks to a clean database structure. Significant staff savings while greatly expanding functionality and calculation accuracy.
  • Provided a foundation for further rationalization measures and feature extensions.
  • Tools 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
  • Revised an Access database design and created the final Access database for documenting database fields.
  • Tools 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
  • Implemented change requests and developed new features for various EKM clients.
  • Software environment: GDI.
  • Tools 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 rebuilt and functionally expanded the Access database worked on in May 2016.
  • Tools 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
  • Revised and enhanced the "GMC" project from December 2015 to April 2016.
  • Tools 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
  • Revised the look of some lists and cover letters.
  • Created a new 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
  • Integrated a calendar to display all trips and guides for an entire season in Access.
  • Added links from the calendar directly to edit the trips.
  • Changes to the trips are immediately shown in the calendar.
  • Used: Access, VBA
Sep 2016 - Sep 2016
Munich, Germany

Equal Opportunity

Fraunhofer Society

Position Summary
Equal Opportunity at Fraunhofer Society
Industries
Professional Services
Business Areas
Business Intelligence
Information Technology
  • Automated a previously manual Excel tool 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
  • Continued 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
  • Got an existing faulty Access application 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
  • Starting from an existing Excel solution, create a new Excel tool that lets you filter and summarize individual survey results and display the outcomes.
  • 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 Munich Urban Renewal Company Ltd. needed an Excel-based solution to create a custom energy check for existing buildings for its clients.
  • First "all-in-one" solution (Excel only).
  • Free data entry with no quantity limits.
  • The result is an approx. 30-page booklet that doesn't show it was generated with Excel.
  • Used: Excel, VBA
Dec 2015 - Dec 2015
Allersberg, Germany

Hotel DB Final Cost Calculation

bikeAlpin GmbH

Position Summary
Hotel DB Final Cost Calculation at bikeAlpin GmbH
Industries
Tourism
Business Areas
Business Intelligence
Information Technology
  • Expanded the hotel database to record and analyze 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
  • Continuously add to and improve the application upgraded in Feb. 2015.
  • Combine and clean about 10,000 addresses from different sources in Excel.
  • Set up a database (together with the client) for the Weclapp CMS.
  • Import 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
  • Modify the Access database created between July and August 2011.
  • Upgrade to Office 2013 and Windows 7.
  • Make 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 the functionality and appearance of an existing Excel file.
  • Used: Excel, VBA
Dec 2014 - Dec 2014
Allersberg, Germany

Jerseys

bikeAlpin GmbH

Position Summary
Jerseys at bikeAlpin GmbH
Industries
Tourism
Business Areas
Information Technology
  • Small Access database to get an overview of jersey sales 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
  • Made improvements to the database created last 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 to manage risks with quarterly data imports from Excel and implemented a four-stage update process.
  • Primarily reformatted Excel sheets of client claim data into machine-readable formats, partly using VBA tools I developed.
  • Also created smaller tools, reports, etc.
  • Converted the Excel solution created in April 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
  • Built an Access database to book all trips, hotel stays, luggage transports, return trips, and shuttles.
  • Created various lists and documents for customers and guides.
  • Developed a calendar to overview the status of all trips.
  • The new Access database made things much easier and set the foundation for many enhancements.
  • 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 key 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 tables of customer claims data into machine-processable formats, partly using custom VBA tools.
  • Expanding the functionality of the database created in July and August 2011 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
  • Finalizing an Excel-based database to manage sampling points for water (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/Fall 2012

BMW AG

Position Summary
Fahr & Spar Summer/Fall 2012 at BMW AG
Industries
Automotive
Business Areas
Information Technology
  • Adapting the existing database to the conditions of an additional promotion.
  • 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 promotion.
  • Migrating from Access 2003 / Windows 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
  • Mainly reformatting Excel sheets of customer claim data into machine-readable formats, partly using self-made VBA tools.
  • Also creating smaller tools, reports, 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
  • Having maps scanned.
  • Calibrating, cropping and stitching 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 to monitor business transactions.
  • Revising the existing Excel transfer front end.
  • Converting the existing Excel database.
  • Automating daily posting processes including reading data from Outlook, posting, limit checks and generating emails.
  • Developing several reports to monitor business transactions.
  • Through automation, for the first time gaining the ability to get exact data.
  • 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 matches insurance data with claims data.
  • Quarterly cumulative import of data delivery from the customer.
  • Displaying about 30 KPIs, both in tables and charts.
  • Adding 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 stitching 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
  • Mainly reformatting Excel spreadsheets of customer claims data into machine-readable formats.
  • Also creating small 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
  • Mainly reformatting Excel spreadsheets of customer claims data into machine-readable formats.
  • Automation resulted in massive time savings and elimination of manual errors.
  • 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 offered tours.
  • Reading GPX files and providing layout options for the elevation profiles.
  • Outputting 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.
  • Creating and maintaining an Excel-based order form.
  • Creating and maintaining an Access database for order tracking, production planning and coordination across multiple locations, including freight forwarding arrangements.
Mar 1997 - May 2000
Munich, Germany

Asset Management Clerk

Bankhaus Merck Finck & Co

Position Summary
Asset Management Clerk at Bankhaus Merck Finck & Co
Industries
Banking and Finance
Business Areas
Accounting
Finance
  • Checking daily automatically imported account transactions and corporate actions.
  • Manually updating corporate actions that cannot be automated.
  • Preparing daily Excel reconciliations of internal settlement accounts: extracting data from print files, creating the account balances, and reconciling them with externally provided summary 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
  • Producing sports items for ski touring equipment, backpacks, and clothing.
  • Creating production and demand plans with Excel.
Sep 1992 - May 1995
Munich, Germany

Trainee Wholesale and Foreign Trade Specialist

F.W. Schubert GmbH

Position Summary
Trainee Wholesale and Foreign Trade Specialist at F.W. Schubert GmbH
Industries
Retail
Business Areas
Procurement
Sales
Supply Chain Management
  • Apprenticeship as a Wholesale and Foreign Trade Specialist in a work-integrated training program.
  • Wholesale and Foreign Trade Specialist exam in May 1995.
  • Train-the-trainer (AdA) exam in December 1994.
  • Merchant in Wholesale and Foreign Trade exam in January 1994.
Oct 1991 - Dec 1991

Surveying student

University of Applied Sciences studies

Position Summary
Surveying student at University of Applied Sciences studies
Industries
Education
Business Areas
Research and Development
Jul 1990 - Jun 1991
Munich, Germany

Military Service / Administrative Role

Bundeswehruniversität Neubiberg

Position Summary
Military Service / Administrative Role at Bundeswehruniversität Neubiberg
Industries
Education
Government and Administration
Business Areas
Operations
  • Basic training in Amberg.
  • Administrative tasks in the student housing area at the Bundeswehr University.
Jan 1982 - Dec 1990
Munich, Germany

Student

Asam-Gymnasium

Position Summary
Student at Asam-Gymnasium
Industries
Education
  • High school diploma with advanced courses in Mathematics and Physics.
Jan 1976 - Dec 1982
Sauerlach, Germany

Student

Sauerlach Primary School

Position Summary
Student at Sauerlach Primary School
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

  • Extensive cross-industry knowledge
  • Flexible and prompt implementation of your programming requests
  • Attentive, dedicated, and structured work style
  • All the advantages of an external contractor

Skills

  • Windows Environments (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

Certified Business Administrator (work-integrated program) · Munich, Germany

Oct 1991 - Dec 1991

Surveying

Oct 1982 - Jun 1990

Asam-Gymnasium

High school diploma · Munich, Germany

...and 1 more

Statistics

Experience

Total positions 81
Experience in Education 16.5 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 Overhaul, Database Optimization, Inventory
Main industries Education, Manufacturing, Construction
Main business areas Information Technology, Operations, Logistics

Qualifications

Profile

Created
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 69 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 Overhaul, Database Optimization, Inventory.
Peter's most recent position is Calculator Overhaul 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 Tourism.
Peter has recently worked in business areas like Information Technology, Business Intelligence, and Supply Chain Management.
Peter attended F.W. Schubert GmbH for Certified Business Administrator (work-integrated program).
Peter will be available from June 2026.
Peter's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.
To hire Peter, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

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

1200
900
600
300
Rate comparison chart
Market avg: 856-1016 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.