Bernhard Höhn - Conversion of external Excel and CSV delivery point lists for internal database interface, architecture

Q: Where is Bernhard based?

Bernhard is based in Stadtsteinach, Germany and can operate in on-site , hybrid , and remote work models.

Q: What languages does Bernhard speak?

Bernhard speaks the following languages: German (Native), English (Advanced) .

Q: How many years of experience does Bernhard have?

Bernhard has at least 28 years of experience. During this time, Bernhard has worked in at least 55 different roles and for 39 different companies . The average length of individual experience is 4 months . Note that Bernhard may not have shared all experience and actually has more experience.

Q: What is Bernhard's latest experience?

Bernhard's most recent position is Conversion of external Excel and CSV delivery point lists for internal database interface, architecture at Stadtwerke Heilbronn .

Q: What companies has Bernhard worked for in recent years?

In recent years, Bernhard has worked for Stadtwerke Heilbronn , Coinbook-Verlag , Breitzmann Edelmetalle Gmbh & Co. Kg , Unimed GmbH , and MATERNA GmbH .

Q: Which industries is Bernhard most experienced in?

Bernhard is most experienced in industries like Information Technology , Food and Beverage , and Sport . Bernhard also has some experience in Energy , Utilities , and Healthcare .

Q: Which business areas is Bernhard most experienced in?

Bernhard is most experienced in business areas like Information Technology , Project Management , and Product Development . Bernhard also has some experience in Business Intelligence , Operations , and Finance .

Q: Which industries has Bernhard worked in recently?

Bernhard has recently worked in industries like Information Technology , Food and Beverage , and Sport .

Q: Which business areas has Bernhard worked in recently?

Bernhard has recently worked in business areas like Information Technology , Product Development , and Project Management .

Recommended expert

Stadtsteinach, Germany

Experience

Jun 2025 - Jun 2025

1 month

Heilbronn, Germany

Conversion of external Excel and CSV delivery point lists for internal database interface, architecture

Stadtwerke Heilbronn

Conversion of external Excel and CSV delivery point lists for internal database interface.
The utility company receives delivery point lists from external service providers as Excel or CSV files. These lists are not interface-compliant and must be converted before importing into the database. Using Excel, the relevant data from the service providers for electricity and/or gas are prepared.
Extension of the program with new features.
Excel programming with VBA.
Operating system: Windows 2010.
Software: Excel, VBA.

Jan 2025 - Jun 2025

6 months

Meinhard, Germany

Further development of the Coinbook, Coinbook-Open, and Coinbook-Admin programs and the internal customer management website

Coinbook-Verlag

Maintenance of the programs, new features, building a web scraper.
Support.
Operating system: Windows 2010 / 2011.
Software: C#.NET, .NET 4.8, WPF, WinForms, FTP, Syncfusion.
Tools: Visual Studio 2022, Git, Jira, Confluence, FileZilla, XML, JSON.
Databases: LiteDB.

Dec 2024 - Dec 2024

1 month

Heilbronn, Germany

Conversion of external Excel and CSV delivery point lists for internal database interface, architecture

Stadtwerke Heilbronn

Conversion of external Excel and CSV delivery point lists for internal database interface.
The utility company receives delivery point lists from external service providers as Excel or CSV files. These lists are not interface-compliant and must be converted before importing into the database. Using Excel, the relevant data from the service providers for electricity and/or gas are prepared.
Excel programming with VBA.
Operating system: Windows 2010.
Software: Excel, VBA.

Jun 2024 - Jul 2024

2 months

Bayreuth, Germany

Development, architecture

Breitzmann Edelmetalle Gmbh & Co. Kg

The Breitzmann company publishes a subscription-based newspaper for its customers. For this purpose, an address management system with subscription management, direct debit collection, and automatic dispatch as PDF and print was created.
Operating system: Windows 2010.
Development environment: C#.NET, WinForms, LiteDB.
Tools: Visual Studio 2022, Git.
Databases: LiteDB.

May 2024 - Nov 2024

7 months

Meinhard, Germany

Further development of the Coinbook, Coinbook-Open, and Coinbook-Admin programs and the internal customer management website

Coinbook-Verlag

Operating system: Windows 2010.
Software: C#.NET, .NET 4.8, WPF, WinForms, FTP, Syncfusion.
Tools: Visual Studio 2022, Git, Jira, Confluence, FileZilla, XML, JSON.
Databases: MS SQL Server, LiteDB.

Jun 2021 - Apr 2024

2 years 11 months

Wadern, Germany

Second Level Support, Development, Data Analysis, Architecture, Requirements Analysis

Unimed GmbH

Unimed GmbH is a billing service for clinics and private doctors.
Maintenance of programs in VB6, C# and TSQL, including bug fixing, adding new features, new developments and program improvements.
Development of a software to transfer invoices, accounts receivable master data etc. to DATEV.
OS: Windows 2010.
Software: C#.net, WinForms, SQL, VB6, Access, TSQL, XML, PLSQL.
Tools: Visual Studio 2015, 2019, 2022, Git, Jira, Confluence, VB6-Studio.
Databases: MS SQL Server, MS Access.
Method: ETL.

Mar 2021 - Jun 2021

4 months

Accessibility Adaptation

MATERNA GmbH

EVA and Zolldesk are existing customs administration programs that needed to be adapted for accessibility.
OS: Windows 2010.
Software: C#.net, .net 4.6.1, .net 4.8, WPF, WinForms.
Tools: Unit Test, Visual Studio 2019, NDVA Screenreader.

Sep 2020 - Mar 2021

7 months

Lübeck, Germany

Camera control with liquid lens to monitor laser welds

SLM-Solution

SLM-Solution is the world's leading manufacturer of industrial 3D printers with laser welding technology.
Controlling cameras and the associated liquid lens in the build chamber to monitor the production process.
OS: Windows 2010.
Software: C#.net, WinForms.

Jun 2020 - Jun 2020

1 month

Kulmbach, Germany

Migration to .net 4.7.2

Malzfabrik Johann Zeitler

Customer, vendor and item management.
Warehouse management, quality billing, vendor billing.
Delivery notes for incoming and outgoing, individual invoices, credit notes.
Various sales statistics, check and bill of exchange management, technical analysis, appointment calendar.
All printouts can be exported to Word, Excel, PDF. Creation of Word templates.
OS: Windows 2010.
Software: C#.net, .net 4.7.2, PostSharp, Log4Net, Syncfusion, Okii dialogs, Json, Linq, WinForms, XML.
Tools: Git.
Database: MS SQL Server.

Apr 2020 - Jun 2020

3 months

Meinhard, Germany

Migration to .net 4.7.2 and LiteDB database, Architecture, Requirements Analysis

Coinbook-Verlag

Due to ongoing issues with Access from Microsoft updates and the limits of the Access database size, Coinbook was migrated to a new database.
As part of the migration, the program's performance and interface were improved and the code was refactored.
OS: Windows 2010.
Software: C#.net, .net 4.7.2, PostSharp, Log4Net, Syncfusion, Okii dialogs, Json, Linq, Rhino.Lizensing, CSharpZip, WinForms, FluentFTP, Paypal-Api, Json, XML.
Tools: Git.
Database: LiteDB/ MS SQL Server.

Dec 2019 - Mar 2020

4 months

Wertheim am Main, Germany

Development in C#, WPF MVVM, VB.NET

Ersa GmbH

Programming the UI (VB.NET) for soldering robots and developing the backend (.NET Core 3.0) for these devices.
Processing and visualizing machine data.
Operating system: Windows 10.
Software: C#, WPF, MVVM, Visual Studio 2019, Git, MEF, CRF, HaiNa, .NET Core 3.0, Unit Tests, JSON, XML, .NET 4.8, WinForms, VB.NET.
Tools: Git on DevOps.

Apr 2019 - Nov 2019

8 months

Fürth, Germany

Development in C# in the world's largest C# project

Siemens

SIMATIC WinCC Unified is a completely new visualization system for the challenges of digitalization in machinery and plant engineering.
Proven engineering in the Totally Integrated Automation Portal (TIA Portal).
The new SIMATIC HMI Unified Comfort Panels and SIMATIC IPCs allow the full potential of WinCC Unified to be leveraged.
Creation and daily execution of UI tests and unit tests.
Operating system: Windows 10.
Software: C#, WinForms, Visual Studio 2017, TASuite, Tiflib, Unit Test, XML.
Tools: Git.

Jul 2017 - Sep 2017

3 months

Heilbronn, Germany

Offer generation for customer retention on cancellation

Stadtwerke Heilbronn

Excel is launched from an Oracle database with a record ID. Using this ID, Excel then retrieves the relevant customer data for electricity and/or gas.
With Excel, this data is processed accordingly and then inserted into pre-made text blocks and Word templates in Word.
Excel controls the entire formatting and assembly in Word, as well as printing of the offers or contracts when offers are accepted.
Excel and Word programming using VBA, creation of Word templates.
Operating system: Windows 2010.
Software: Excel, Word, VBA.

Feb 2017 - Mar 2019

2 years 2 months

Luxembourg

New development of various modules, migration from VB6 to C#, architecture, requirements analysis

DWS (Deutsche Bank) Luxemburg

The software package manages assets and investments of DWS customers and is developed and maintained by an international team.
Migration of code parts from VB6 to C#.
Creation of a new module for issuing and managing gift cards in the back office.
Backend programming for the gift card web development (customer module).
Migration and extension (WYSIWYG) of the administration of standard and individual letters using text blocks, manual inputs, and automatically inserted data.
Creation of Word templates and programming a custom template management system in C#.
Partial use of the Telerik framework.
Operating system: Windows 7.
Software: C#, WinForms, .NET 3.5 - .NET 4.6, Telerik, JSON, XML, Word.
Tools: Git with Bitbucket.
Database: MS SQL Server.
Methods: ETL.

Oct 2016 - Dec 2016

3 months

Nuremberg, Germany

Development, architecture, requirements analysis

Bundesamt für Migration und Flüchtlinge

Development of software for rule-based decision letter generation for asylum seekers to reduce manual errors.
The decision letter generation is executed in many branch offices across Germany.
Operating system: Windows 7.
Software: C# WPF, Prism, .NET Framework 4.6, NHibernate, web service.
Database: Oracle.

Sep 2015 - Sep 2016

1 year 1 month

Aurich, Germany

Full programming, architecture, requirements analysis

Enercon

BladedSC is a program that controls the distribution of complex stability calculations for wind turbines to standalone servers.
Server program: Runs on each server, fetches time series from the database, performs calculations, and writes progress and results back.
Client: User interface for adding, monitoring, and controlling projects and for monitoring and configuring the servers.
Validation program: Checks each project after creation for certain criteria before handing it over to the servers.
Operating system: Windows 7.
Software: C#.net, WPF MVVM for the client, .net 4.5, PostSharp, XML.
Database: MongoDB.

Jun 2015 - Dec 2019

4 years 7 months

Meinhard, Germany

Full architecture, requirements analysis, programming, maintenance

Coinbook-Verlag

Creation of a digital coin catalog for coin collectors.
Recording collection areas, coins, images, and all relevant data.
Management of Coinbook customers with licenses for the program and collection modules.
Invoice writing and contact management.
Various customer letters via Word automation using Word templates.
Creation of Word templates.
Operating system: Windows 7.
Software: C#.net, .net 3.5, .net 4.5, ItextSharp, PostSharp, Log4Net, Syncfusion, Word, Excel, WinForms, XML.
Tools: Mercurial.
Databases: MS-Access, MS SQL Server.

Jun 2015 - Jun 2015

1 month

Berlin, Germany

Full programming

Der Wohnungsauflöser

Management of bidders, consignors and items for auctions.
Recording winning bids on the tablet.
Writing invoices for bidders and settlements for consignors.
Sales statistics.
Operating system: Windows 7.
Software: C#.net, .net 4.5, ItextSharp, PostSharp, Log4Net, WinForms.
Database: MS SQL Server.

Nov 2014 - Nov 2014

1 month

Münster, Germany

Full programming, architecture, requirements analysis

EHW

Import of trades and orders from the Trayport trading system for gas and power trading by accessing the Trayport server.
Providing the data in CSV files.
Operating system: Windows 7.
Software: C#.net, .net 3.5, ItextSharp, PostSharp, Log4Net, WinForms, XML.

Aug 2014 - Aug 2014

1 month

Switzerland

Migration of an Access solution from Access 95 to Access 2010

Bösch-Computer

Management of interpreters and translators.
Customer management.
Invoice writing.
Operating system: Windows 7.
Software: Access 2010, VBA.
Database: Access 2010.

Jul 2014 - Jul 2014

1 month

Nuremberg, Germany

Complete programming

Muteba

Management of interpreters and translators.
Customer management.
Invoicing.
Operating system: Windows 7.
Software: C#.NET, .NET 3.5, iTextSharp, PostSharp, Log4Net, XML.
Database: MS SQL Server.

Jun 2014 - Jul 2014

2 months

Münster, Germany

Complete programming, architecture, requirements analysis

EHW

Daily calculation of gas purchase and sales prices for day-ahead, BOM, following months, following quarters, seasons.
Spread matrix.
Operating system: Windows 7.
Software: Excel, VBA.

Jun 2014 - Jun 2014

1 month

Berlin, Germany

Complete programming

Bestwert

Management of apartment units with floor plans.
Financing calculation.
Operating system: Windows 7.
Software: C#.NET, Excel, VBA, iTextSharp, PostSharp, Log4Net, XML.
Database: MS SQL Server.

Mar 2014 - Mar 2014

1 month

Munich, Germany

Complete programming

Fa. Himmel

Assignment of voice actors to different episodes.
Calculation of the duration of speaking times for individual scenes, episodes, and voice actors.
Operating system: Windows 7.
Software: Excel, VBA.

Jan 2014 - Jan 2014

1 month

Münster, Germany

Complete programming, architecture, requirements analysis

EHW

Tranche fixing and storage of gas purchases.
Operating system: Windows 7.
Software: C#.NET, Excel, .NET 3.5, iTextSharp, PostSharp, Log4Net.
Database: MS SQL Server.

Oct 2013 - Oct 2013

1 month

Hockenheim, Germany

Full programming

Dr. Straub

Invoice program in Word including creation of Word templates.
Inventory management and profit and loss statement in Excel.
Automation of inventory management and profit and loss statement from Word.
Operating system: Windows 7.
Software: Excel, VBA.

Oct 2013 - Oct 2013

1 month

Berlin, Germany

Full programming

Samonig AG

Management of apartments with floor plan and apartment overview.
Sample calculation of financing costs, monthly burden and tax savings.
Operating system: Windows 7.
Software: Excel, VBA.

Aug 2013 - Aug 2013

1 month

Programming

Aktivhotel Wernigerode

Managing items, suppliers and prices.
Order processing and inventory management.
Importing price lists from Excel and mapping them; exporting price lists to Excel.
Operating system: Windows 7.
Software: Access, Excel, VBA.

Jun 2013 - Mar 2015

1 year 10 months

Holzwickede, Germany

Change management, workflow design, architecture, requirements analysis

Rhenus Access & Services

Creating a change management system with Matrix42.
Creating workflows of varying complexity (from linear to branched approvals).
Creating various reports.
Operating system: Windows XP/ Windows 7.
Software: Matrix42, Microsoft Workflow Foundation, Microsoft Report Builder, SQL Server Reporting Services, VB.net, XML.
Database: MS SQL Server.

Apr 2013 - Apr 2013

1 month

Programming, form design, database design, operation

Fa. Rhoden Frankenthal

Customer management for sales reps.
Product management.
Sales management.
Interface to main program.
Operating system: Windows XP, Windows 7.
Software: Access, VBA.
Database: Access.

Apr 2013 - Apr 2013

1 month

Programming, Form design, Database design, Operation

Various

Construction site monitoring: capturing deficiencies and to-dos related to subcontractors.
Recording defect fixes.
Graphical display of defect fixes by month to monitor reliability.
Statistics with various filters (date, subcontractor, component, defect type).
Operating system: Windows XP, Windows 7.
Software: Excel, VBA.
Database: Excel.

Oct 2012 - Oct 2012

1 month

Programming, Form design, Database design, Operation

Herr Edelmann

Invoicing program including customer management and item management.
Create delivery notes/invoices.
Operating system: Windows XP, Windows 7.
Software: Excel, VBA.
Database: Excel.

Sep 2012 - Present

13 years 7 months

Munich, Germany

Programming, Form design, Database design, Operation

Mr. Pizza Munich

Customer management and item management.
Create delivery notes/invoices.
Creation of Word templates.
Operating system: Windows XP, Windows 7.
Software: Excel, VBA.
Database: Excel.

May 2012 - Jun 2025

13 years 2 months

Design, Database design, Programming, Project management

Shooting clubs

Shooting result evaluation for shooting clubs; migration from VB6 to C#.NET, WPF.
Handling and analysis of shooting festivals.
Management of shooters, classes, clubs, and targets.
Scoring for air rifle, air pistol, small-caliber, muzzleloader.
Manual result entry and result import from DISAG.
Prize distribution, stakes, rebuys, various statistics.
Export to Word, Excel, PDF.
Operating system: Windows XP, Windows 7.
Software: C#.NET, ITextSharp, ZedGraph, .NET 4.0, WPF, Entity Framework, XML, Visual Studio 2008, Office automation, Log4Net, PostSharp, TXTextControl.
Database: Access.

Jan 2012 - Apr 2013

1 year 4 months

Wörth am Rhein, Germany

Programming, Form design, Database design, Operation

Daimler

Prototype tracking tool (AMS) for support in new launches.
Obtaining and comparing supplier quotes for purchased parts using Word letters.
Supplier assignment based on these offers.
Display and assignment of new parts to procurement managers.
Documentation of supplier quotes and award history.
Import of planned costs and sales.
Cost monitoring and part tracking.
Action-guiding reporting features for staff and managers.
Creation of Word templates.
Operating system: Windows XP, Windows 7.
Software: Visual Basic 6.0, Excel, VBA, Word, Outlook, Notes automation.
Database: DB2.

Aug 2011 - Dec 2011

5 months

Karlsruhe, Germany

Programming, form design, architecture, requirements analysis

ENBW

Gas quantity determination for supply contracts.
Transfer and connection program between SAP, vendor and network operator databases for long-term planning.
Operating system: Windows XP, Windows 7.
Software: VBA (Access).
Database: Access, Oracle.

Jun 2011 - Dec 2016

5 years 7 months

Kulmbach, Germany

Design, database design, programming, project management, architecture, requirements analysis

Malzfabrik Johann Zeitler

Malt billing and management system, ERP (migration from VB6 to C#.NET).
Customer, supplier and item management.
Warehouse management, quality billing, supplier billing.
Delivery notes for incoming and outgoing goods, individual invoices, credit notes.
Various sales statistics, check and bill of exchange management, technical analysis, appointment calendar.
Export to Word, Excel, PDF; creation of Word templates.
Operating system: Windows XP/ Windows 7.
Software: C#.NET, ITextSharp, Zedgraph, PDF, .NET 3.5, Windows Forms, XML, Visual Studio 2008, Office automation, Log4Net, PostSharp, TXTextControl.
Database: MS SQL Server.

Jan 2011 - Feb 2011

2 months

Karlsruhe, Germany

Programming, form design, architecture, requirements analysis

ENBW

Index quick reporting.
Interface between SAP and external program with review and correction features.
Operating system: Windows XP, Windows 7.
Software: VBA, Excel.
Database: Oracle.

Sep 2010 - May 2011

9 months

Karlsruhe, Germany

Programming, form design, GUI, migration from an Access project

ENBW

AwEL - application database for energy supply and logistics.
Handling of customers in the extraterritorial area in the deregulated energy market.
Display of open orders in a tree structure by priority.
Correction and addition of order data directly in the table or sub-forms.
Operating system: Windows XP, Windows 7.
Software: C#.NET, ITextSharp, .NET 2.0, .NET 3.5, Windows Forms, XML, Visual Studio 2008, Excel automation.
Database: Oracle.

Jul 2010 - Mar 2011

9 months

Karlsruhe, Germany

Programming, form design, effort estimation, operations, database design, GUI, architecture, requirements analysis

ENBW

Lead database as a small CRM system for managing contacts and orders.
Analysis of energy-saving measures for single- and two-family houses.
Various order statistics as tables or charts.
Export to Excel, import from Excel.
Operating system: Windows XP, Windows 7.
Software: VBA Access 2003/2010.
Database: Access.

Feb 2010 - Jun 2011

1 year 5 months

Karlsruhe, Germany

Adapting various programs to Windows 7 and Office 2010, architecture, requirements analysis

ENBW

Büko2011: migration to Windows 7 and Office 2010.
Adapting various programs and Word templates to Windows 7 and Office 2010.
Testing compatibility under Windows 7.
Operating system: Windows 7.
Software: VBA, Excel 2010, Word 2010, Access 2010, PowerPoint 2010, C#.NET, .NET 2.0, .NET 3.5.
Databases: Oracle, MS SQL Server, Access.

Feb 2010 - Jul 2010

6 months

Karlsruhe, Germany

GUI programming, design, database integration

ENBW

VerA-Tool: program for capturing and managing electricity and gas contracts.
Multi-tenant; analysis and business logic in the database.
Creating Word templates.
Operating systems: Windows XP, Windows 7.
Software: VBA, Excel.
Database: Oracle.

Jan 2010 - Jun 2025

15 years 6 months

Design, database design, programming, project management

SAN-Software

SAN club management system for shooting clubs.
Migration from MS-DOS to Windows.
User-friendly management of members, address book, role descriptions, and activities.
Custom mail merge letters, integration into existing printouts.
Extensive reports, list and form designer (label printing, certificates).
SEPA and DTA direct debits.
Export to Word, Excel, PDF.
Operating systems: Windows XP/ Windows 7.
Software: C#.NET, ITextSharp, ZedGraph, .NET 3.5, Windows Forms, XML, Visual Studio 2008, Office automation, Log4Net, PostSharp, TXTextControl.
Database: MS SQL Server/Access.

Sep 2009 - Feb 2010

6 months

Karlsruhe, Germany

GUI and business logic programming, design, architecture, requirements analysis

ENBW

DRULA - compressed air tool: questionnaire to collect energy consumption data for compressed air systems.
Analysis and consulting on savings measures.
Automatic report generation (PDF, Word, PowerPoint) with custom inputs and charts.
Creating Word templates.
Operating system: Windows XP.
Software: VBA, Excel, PowerPoint and Word automation.
Methods: Scrum.

Mar 2009 - Jun 2011

2 years 4 months

Karlsruhe, Germany

GUI programming, business logic, database design, database integration, architecture, requirements analysis

ENBW

Network usage statistics: storing and calculating network usage fees and metering prices from 2005.
Assumption planning overall and weighted on a monthly basis.
Display as table and chart with various formatting options.
Automatic report generation for management (printout, PDF, PowerPoint).
Data import from an Oracle database.
Operating systems: Windows XP, Windows 7.
Software: C#.NET, ITextSharp, .NET 2.0, .NET 3.5, Windows Forms, XML, Visual Studio 2008, Excel automation, ZedGraph, PowerPoint automation.
Tools: Team Foundation Server.
Database: Access/Oracle.

Mar 2009 - May 2010

1 year 3 months

Karlsruhe, Germany

Programming of GUI and business logic, design, architecture, requirements analysis

ENBW

IdEE: Questionnaire to capture specific energy consumption data.
Analysis and consulting on savings measures.
Collecting data, calculating energy demand and automatic report creation.
Creation of Word templates.
Operating system: Windows XP.
Software: VBA, Excel, PowerPoint and Word automation.

Jan 2009 - Dec 2010

2 years

Karlsruhe, Germany

Programming, UI design, effort estimation, operation, database design, migration

ENBW

Provis: Commission billing for field sales staff.
Migration from Access to C#.NET and MS SQL Server.
Data import from SAP and Excel.
Automatic commission calculation, cancellations and completeness checks.
Automatic cover letters and summary lists as printouts or PDFs for traceability.
Operating system: Windows XP, Windows 7.
Software: C#.NET, iText, .NET 2.0, .NET 3.5, Windows Forms, XML, Visual Studio 2008, Excel automation.
Tools: Team Foundation Server.
Database: MS SQL Server.

Oct 2008 - Dec 2011

3 years 3 months

Karlsruhe, Germany

Programming and reporting, architecture, requirements analysis, data analysis

ENBW

Calculation of claims for overpaid network usage fees.
Basis for recalculations, out-of-court settlements and legal proceedings.
Operating system: Windows XP, Windows 7.
Software: VBA, Access 2003, Excel 2003.

Jul 2008 - Dec 2010

2 years 6 months

Karlsruhe, Germany

Programming, form design, effort estimation, operation, database design, architecture, requirements analysis

ENBW

Commission billing for field sales staff.
Data import from SAP and Excel.
Operating system: Windows XP.
Software: VBA, Access.
Database: Access.

Jul 2008 - Aug 2008

2 months

Karlsruhe, Germany

Programming, form design, operation, database design

ENBW

UmfrageDB: Database to support call centers for telephone surveys on customer satisfaction.
Operating system: Windows XP.
Software: VBA, Access.
Database: Access.

Aug 2007 - Jun 2011

3 years 11 months

Karlsruhe, Germany

Programming, mask design, effort estimation, operation, architecture, requirements analysis

ENBW

Gas tariff calculator for calculating quotes and comparing gas contracts.
Printing of quotes and tariff comparisons.
Operating system: Windows XP, Windows 7.
Software: Excel 2003/2010, VBA.

Mar 2007 - Aug 2009

2 years 6 months

Karlsruhe, Germany

Programming, mask design, effort estimation, database design, migration

ENBW

WWU - CRM system for managing framework agreements with housing companies.
Migration from Access to C#.NET and MS SQL Server.
Management of objects, contract creation and automatic mailings.
Import/export of object lists from/to Excel.
Letters and contracts using Word templates.
Operating system: Windows XP, Windows 7.
Software: C#.NET, .NET 1.1, .NET 2.0, .NET 3.5, Windows Forms, XML, Excel and Word automation.
Tools: Team Foundation Server.
Database: MS SQL Server.

Jan 2007 - Nov 2011

4 years 11 months

Karlsruhe, Germany

Programming, mask design, effort estimation, database design, GUI, architecture, requirements analysis

ENBW

Forecast tool for gas demand based on last year's consumption, weekdays, and temperatures.
Output in tabular form and as charts; export/import to/from Excel.
Operating system: Windows XP.
Software: C#.NET, .NET 1.1, .NET 2.0, Windows Forms, XML, Excel automation, ZedGraph.
Database: Access.

Dec 2006 - May 2007

6 months

Karlsruhe, Germany

Programming, mask design, effort estimation, database design, GUI

ENBW

TAM tool: project management.
Operating system: Windows 2000.
Software: C#.NET, .NET 1.1, .NET 2.0, Windows Forms.
Database: Access.

Oct 2006 - Nov 2007

1 year 2 months

Karlsruhe, Germany

Programming, mask design, operation

ENBW

Plato-Gas: forecast tool for gas demand.
Projection of gas demand by comparing it to last year's consumption, considering weekdays and temperatures.
Output in tabular form and as charts.
Operating system: Windows XP.
Software: VBA, Excel.

Jul 2004 - Jun 2008

4 years

Stuttgart, Germany

Print Tool for Contract Generation

ENBW

DocGenerator: print tool for contract generation for the calculation tool.
Importing and processing CSV data from the calculation tool.
Assembling Word templates and text modules; controlling formatting in Word.
Custom template management in Excel.
Operating system: Windows 2000, NT, XP.
Software: Excel, Word, VBA.

Mar 2004 - Aug 2009

5 years 6 months

Karlsruhe, Germany

Frontend Programming, Form Design, Technical Documentation

ENBW

Calculation tool for calculating and creating electricity offers for large customers.
Calculating quarter-hourly electricity demand using measured and synthetic load profiles.
Visual Basic 6 frontend, Java server backend; data transfer via CORBA.
Interfaces to existing programs and storage in Oracle database.
Technical documentation in XML.
Operating system: Windows 2000, NT, XP.
Software: Visual Basic 6.0, CORBA, Excel, Forms.
Tools: CVS.
Database: Oracle.

Dec 2003 - Feb 2004

3 months

Kulmbach, Germany

Design, Database Design, Programming, Project Management, Migration, Architecture, Requirements Analysis

Malzfabrik Johann Zeitler

Migration from MS-DOS QuickBasic to Windows VB6 and SQL Server.
Customer, supplier, and item management, inventory management, quality billing.
Delivery notes, individual invoices, credit notes, and revenue statistics.
Check and bill of exchange management, technical analysis, appointment calendar.
Export to Word, Excel, PDF, and HTML.
Operating system: Windows 98/ Windows 2000.
Software: Visual Basic 6.0, SQL, Crystal Reports 8.5, ADO, Excel, Word, Forms.
Database: MS SQL Server.

Dec 2003 - Feb 2004

3 months

Design, Database Design, Programming, Project Management

various

Media management system specifically for films with key data and selection options.
Export to Excel, HTML, PDF; scheduling with a timesheet.
Data import from the internet, duplicate checking, and image management.
Automatic generation of scheduler files and control of the WinTV software.
Operating system: Windows 2000.
Software: Visual Basic 6.0, SQL, Crystal Reports 8.5, ADO, Excel, Word.
Database: MS SQL Server.

Jan 2003 - Oct 2003

10 months

Ludwigshafen, Germany

Design, Database Design, Programming, Architecture, Requirements Analysis

BASF Ludwigshafen

Pilot plant information system (TIS) for managing, monitoring, and billing pilot plants.
Modules: materials and inventory management, operational order book, technical order book, product management (formulations, reactor scheduling), work instructions, maintenance, order management.
Interface to the ZOV program for internal cost allocation.
Export to Word, Excel, PDF and HTML.
Operating system: Windows NT/ Windows 2000.
Software: .NET, C#.NET, Visual Basic 6.0, SQL, Access, Crystal Reports, ADO.NET, Excel, Windows Forms.
Tools: Source Safe.
Database: Oracle.

Dec 2002 - Dec 2002

1 month

Ludwigshafen, Germany

Design, programming, maintenance and project management, architecture, requirements analysis

BASF Ludwigshafen

Creation of various classes and controls.
Validation control as an OCX (textbox/combobox with limits and data type definition).
Classes for data access via ADO and for managing TrueGrids.
Operating system: Windows NT/Windows 2000.
Tools: Source Safe.
Software: Visual Basic 6.0, SQL, ADO.
Database: Access/Oracle.

Sep 2002 - Nov 2002

3 months

Ludwigshafen, Germany

Design, database design, programming, maintenance and project management, architecture, requirements analysis

BASF Ludwigshafen

Revision management for global storage and monitoring of revision results.
Tracking of reported issues with follow-up reminders and deadline monitoring.
Statistical evaluations and export to Excel.
Multilingual reports for worldwide use.
Operating system: Windows NT/Windows 2000.
Software: Visual Basic 6.0, SQL, ADO, Access.
Tools: Source Safe.
Database: Access.

Aug 2002 - Aug 2002

1 month

Ludwigshafen, Germany

Design, programming, maintenance and project management, architecture, requirements analysis

BASF Ludwigshafen

Caesar: simple CD burning program for data backup.
Use of administrator templates for automated directory structure compilation.
Operating system: Windows NT/Windows 2000.
Software: Visual Basic 6.0.

Apr 2002 - Jul 2002

4 months

Ludwigshafen, Germany

Design, database design, programming, maintenance and project management, architecture, requirements analysis

BASF Ludwigshafen

Electronic logbook for shift operations to hand over reports.
Consists of a core module and custom add-on modules per site.
Archiving of all reports and an electronic signature system.
Operating system: Windows NT/Windows 2000.
Software: Visual Basic 6.0, SQL, Crystal Reports, ADO, Access.
Tools: Source Safe.
Database: Access/Oracle.

Jan 2002 - Mar 2002

3 months

Ludwigshafen, Germany

Design, database design, programming, maintenance and project management, architecture, requirements analysis

BASF Ludwigshafen

Timesheet: planning system for shift supervisors (staff scheduling, vacation and appointment planning).
Management of overtime and deficit hours; can be used as standalone or integrated.
Operating system: Windows NT/Windows 2000.
Software: Visual Basic 6.0, SQL, Access.
Tools: Source Safe.
Database: Access/Oracle.

Nov 2001 - Dec 2001

2 months

Ludwigshafen, Germany

Design, database design, programming, maintenance and project management, architecture, requirements analysis

BASF Ludwigshafen

Program for managing and creating questionnaires for worldwide audits.
Generation of questionnaires as printouts, Word, RTF, Excel, or PDF.
Multilingual user interface and questionnaires.
Operating system: Windows NT/Windows 2000.
Software: Visual Basic 6.0, SQL, Word.
Database: Access.

Sep 2001 - Oct 2001

2 months

Ludwigshafen, Germany

Design, database design, programming, maintenance and project management, architecture, requirements analysis

BASF Ludwigshafen

Image archive for managing audit photos as good/bad examples.
Drag & drop input, keyword and full-text search, thumbnail overview.
Interface to MS-Paint and PowerPoint integration; multilingual comments.
Runs from CD without installation (built-in tools of Visual Basic Standard).
Operating system: Windows NT/Windows 2000.
Software: Visual Basic 6.0 Standard.

Aug 2001 - Aug 2001

1 month

Ludwigshafen, Germany

Design, database design, programming, maintenance and project management, architecture, requirements analysis

BASF Ludwigshafen

Incident and job log for managing service orders.
Input, editing, approval of orders, and creation of permits.
Electronic signature.
Operating system: Windows NT/Windows 2000.
Software: Access 97 / Access 2000.
Database: Access 97 / Access 2000.

Jul 2001 - Jul 2001

1 month

Ludwigshafen, Germany

Design, programming, maintenance and project management, architecture, requirements analysis

BASF Ludwigshafen

Interface for importing order data from SAP to the Merkur and Pago labeling program.
Data transfer via MQSeries using IDOCs directly into Oracle tables.
Operating system: Windows NT/Windows 2000.
Software: Visual Basic 6.0, SQL.
Database: Oracle.

Apr 2001 - Jun 2001

3 months

Ludwigshafen, Germany

Design, programming, maintenance and project management

BASF Ludwigshafen

ZOV - internal billing of pilot plant services to clients.
Service billing based on equipment value classes and labor intensity.
Rental cost charges and credits based on budget vs. actual costs.
Interface for transferring data to SAP.
Operating system: Windows NT/Windows 2000.
Software: Visual Basic 6.0, SQL, Crystal Reports, ADO.
Tools: SourceSafe.
Database: Oracle.

Nov 2000 - Mar 2001

5 months

Ludwigshafen, Germany

Design, programming, maintenance and project management

BASF Ludwigshafen

CATMAN - creation and management of catalyst offers.
Import of orders from DB2; master data management and assignment to offers.
Order and sales statistics (tables and charts), price development history.
Multilingual application; export to Word, Excel, PDF and HTML.
Operating system: Windows NT/Windows 2000.
Software: Visual Basic 6.0, SQL.
Tools: Source Safe.
Database: Oracle, DB2.

Jun 2000 - Oct 2000

5 months

Ludwigshafen, Germany

Design, programming, maintenance and project management

BASF Ludwigshafen

MERKUR - filling system for ammonia and ammonium hydroxide.
Control of filling of tank cars, tank trains, ships.
Import of orders via MQ-Series; planning and data exchange with the PLS (Foxboro).
Printing of reports, utilization statistics and repair monitoring.
Import of tank cars from DB2.
Operating system: Windows NT/Windows 2000.
Software: Visual-Basic 6.0, SQL, ADO, Crystal Report, MQ-Series.
Tools: Source Safe.
Database: Oracle.

Mar 2000 - May 2000

3 months

Backnang, Germany

Design, database design, programming, architecture, requirements analysis

Marconi

Margin controlling in Access; import of data from SAP and Excel.
Evaluation of actual data, performance, revenues for current and following years.
Report generation based on various selection criteria (sales channel, product line, region).
Consistency checks and database administration; data volume approx. 300,000 records/year.
Operating system: Windows NT.
Software: VBA, Access 97, SQL.
Database: Access 97.

Dec 1999 - Dec 1999

1 month

Programming

Altvater GmbH

Order management for a confectionery company including inventory management and commission accounting.
Interface to financial accounting, accounts receivable, sales statistics.
Trigger programming for Gupta database.
Operating system: Windows NT.
Software: Visual Basic 5, SQL, ODBC, Crystal Reports.
Database: Gupta database.

Nov 1999 - Nov 1999

1 month

Programming

Altvater GmbH

Enhancements for the logistics program BELLA.
Interfaces for TNT and freight companies; barcode support.
Database tools, update tools, shipping monitoring; multilingual application.
Software: Visual Basic 4, SQL, Crystal Reports.
Database: Access 97.

Oct 1999 - Oct 1999

1 month

Kulmbach, Germany

Design, database design, programming, and project management

Robert Backer KG

Order and revenue monitoring for two precast plants.
Construction site management, order and revenue entry.
Analysis of order backlog, increases/decreases, year-over-year comparison.
Software: Visual Basic 5, SQL.
Database: Access.

Oct 1999 - Oct 1999

1 month

Design, programming, project management

various

Developed several websites for the Internet and intranet for various service providers (sanatorium, bus dealership, retail).
Programming language: HTML.

Jul 1999 - Sep 1999

3 months

Kulmbach, Germany

Design, database design, programming, and project management

Parkett Ritter

Complete order management and inventory management for a wood wholesale business.
Customer, item, warehouse, and sales representative management.
Quotes, order confirmations, delivery notes, invoices, credit notes.
Software: Visual Basic 5, SQL, Crystal Reports.
Database: Access 97.

Jan 1999 - Mar 1999

3 months

Design, database design, programming, and project management

Salem / Humanitas

Donation management including address and account management.
Mailings by criteria, individual and annual receipts, duplicate checking.
Postal code lookup, word processing, and interface to Word.
Software: Visual Basic 5, SQL, Crystal Reports.
Database: Access.

Sep 1998 - Jun 1999

10 months

Kulmbach, Germany

Design, database design, programming, and project management

TBK Kulmbach

Complete order management and inventory management for a concrete plant.
Recipe, cement, accessories, mixer, and pump management.
Delivery note import from the mixing plant; hour tracking for mixer operators.
Software: Visual Basic 5, SQL.
Database: Access.

Sep 1998 - Apr 1999

8 months

Kulmbach, Germany

Design, database design, programming and project management

KDF Kulmbach

Complete order management, inventory management for a precast plant.
Customer and construction site management, single and jumbo items.
Collective invoice, individual invoice, credit notes; interface to accounting.
Software: Visual Basic 5, SQL.
Database: Access.

Jan 1998 - Feb 2000

2 years 2 months

Design, database design, programming and project management

Various

Industry-specific solution for physiotherapists - billing software.
Management of patients, health insurance companies, doctors and services.
Prescription management, individual and collective invoices; data exchange with health insurers.
Appointment calendar, word processing.
Software: Visual Basic 5, SQL.
Database: Access.

Industry Experience

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

Experienced in Information Technology, Food and Beverage, Sport, Energy, Utilities, and Healthcare.

Information Technology

Food and Beverage

Sport

Energy

Utilities

Healthcare

Business Area Experience

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

Experienced in Information Technology, Project Management, Product Development, Business Intelligence, Operations, and Finance.

Information Technology

Project Management

Product Development

Business Intelligence

Operations

Finance

Skills

Role:

Software Development / Programming
Consulting
Coaching / Training

Technical Focus:

C#.net
Vb.net
Visual Basic
Vba
Access
Excel
Application Programming
Ms Sql Server
Oracle
Crystal Reports
Windows
Wpf
Winforms

Hardware:

Cd Writer / Burner
Pc
Plotter
Process Computer
Scanner

Operating Systems:

Cp/m
Ms-dos
Novell
Unix
Windows
Olivetti Operating System: Hai And Pcos

Programming Languages:

C#.net (.Net)
Access
Basic: Visual Basic And Vba, Various Basic Dialects, Vb.net
Fortran
Gupta, Centura
Hpgl, Hp Pcl
Pl/sql
Html, Xml
.Net Framework 1.1 / 2.0 / 4.5
Windows Forms
Wpf
Mvvm

Databases:

Access
Dao
Db2
Gupta, Centura
Isam
Ms Sql Server
Odbc
Oracle
Sql
Ado
Ado.net
Sqlite
Mongodb
Firebird

Data Communication:

Ethernet
Internet, Intranet
Isdn
Novell
Pc-anywhere
Router
Rs232
Tcp/ip
Windows Network
Mq-series
Corba

Experience In:

Application And System Programming
Specification, Programming, Testing
Creation Of Online Help
Support
Error Management And Handling Problem Tickets
User Consulting
Analysis And Preparation Of Technical Requirements

Methods:

Object-oriented Analysis, Design, Programming
Event-driven, Visual, Structured Programming
Database Design
Scrum
Agile Development
Etl

Microsoft Standards:

Ole Automation Client/server
Dde
Odbc
Mapi
Api
Ado
Dao
Activex
Word
Excel
Access

Various Tools:

Crystal Reports
Wise Setup
List & Label
Eclipse
Visual Studio 6
Visual Studio 2003
Visual Studio 2005
Visual Studio 2008
Visual Studio 2010
Visual Studio 2013
Visual Studio 2015
Visual Studio 2017
Windows Forms
Forms
Dbvisualizer
Wpf

Add-ons And Frameworks:

Componentone - Formula One, Vs-flex, True Dbgrid, Ultragrid, Vs-ocx
Sizerone
Sax-zipobjects
Sheridan Calendar Widgets, Sheridan Datawidgets, Ole Tools, Farpoint Inputpro
Tx Text Control
First Impression
Nu-cdr
Zedgraph
Itextsharp
Postsharp
Log4net
Matrix42
Microsoft Workflow Framework
Entity Framework
Syncfusion
Telerik
Microsoft Report Builder

Version Control And Tools:

Cvs
Sourcesafe
Git
Mercurial
Subversion
Confluence
Jira

Interfaces:

Sepa Direct Debit
Idocs
Json
Xml

It Training:

Ms Office
Corel Draw
Windows
Windows Nt
Programming

Languages

German

Native

English

Advanced

Education

Oct 1975 - Jun 1980

FH Coburg

Diploma in Engineering (University of Applied Sciences) · Civil engineering · Coburg, Germany

Statistics

Experience

Total positions 82

Experience in Information Technology 15.5 y

Avg length 1 y 4 m

Longest experience 15 y 5 m

Global Experience

Countries worked in 3 (Germany, Luxembourg, Switzerland)

Primary country Germany

Expertise

Recent roles Conversion of external Excel and CSV delivery point lists for internal database interface, architecture, Further development of the Coinbook, Coinbook-Open, and Coinbook-Admin programs and the internal customer management website, Development, architecture

Main industries Information Technology, Food and Beverage, Sport

Main business areas Information Technology, Project Management, Product Development

Qualifications

Highest degree Bachelor

Profile

Created

August 2025

Last Update

February 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Bernhard based?

Bernhard is based in Stadtsteinach, Germany and can operate in on-site, hybrid, and remote work models.

What languages does Bernhard speak?

Bernhard speaks the following languages: German (Native), English (Advanced).

How many years of experience does Bernhard have?

Bernhard has at least 28 years of experience. During this time, Bernhard has worked in at least 55 different roles and for 39 different companies. The average length of individual experience is 4 months. Note that Bernhard may not have shared all experience and actually has more experience.

What roles would Bernhard be best suited for?

Based on recent experience, Bernhard would be well-suited for roles such as: Conversion of external Excel and CSV delivery point lists for internal database interface, architecture, Further development of the Coinbook, Coinbook-Open, and Coinbook-Admin programs and the internal customer management website, Development, architecture.

What is Bernhard's latest experience?

Bernhard's most recent position is Conversion of external Excel and CSV delivery point lists for internal database interface, architecture at Stadtwerke Heilbronn.

What companies has Bernhard worked for in recent years?

In recent years, Bernhard has worked for Stadtwerke Heilbronn, Coinbook-Verlag, Breitzmann Edelmetalle Gmbh & Co. Kg, Unimed GmbH, and MATERNA GmbH.

Which industries is Bernhard most experienced in?

Bernhard is most experienced in industries like Information Technology, Food and Beverage, and Sport. Bernhard also has some experience in Energy, Utilities, and Healthcare.

Which business areas is Bernhard most experienced in?

Bernhard is most experienced in business areas like Information Technology, Project Management, and Product Development. Bernhard also has some experience in Business Intelligence, Operations, and Finance.

Which industries has Bernhard worked in recently?

Bernhard has recently worked in industries like Information Technology, Food and Beverage, and Sport.

Which business areas has Bernhard worked in recently?

Bernhard has recently worked in business areas like Information Technology, Product Development, and Project Management.

What is Bernhard's education?

Bernhard holds a Bachelor in Civil engineering from FH Coburg.

What is the availability of Bernhard?

Bernhard is immediately available full-time for suitable projects.

What is the rate of Bernhard?

Bernhard's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Bernhard?

To hire Bernhard, 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

Market avg: 860-1020 €

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.

Similar Freelancers

Discover other experts with similar qualifications and experience

Experts recently working on similar projects

Freelancers with hands-on experience in comparable project as a Conversion of external Excel and CSV delivery point lists for internal database interface, architecture