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

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 the delivery point lists from external service providers as Excel sheets or CSV files. These lists are not interface compatible and need to be converted before importing into the database. Using Excel, the provider's data for electricity and/or gas is prepared accordingly.
Extending the program with new features.
Excel programming in VBA.
Operating system: Windows 2010.
Software: Excel, VBA.

Jan 2025 - Jun 2025

6 months

Meinhard, Germany

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

Coinbook-Verlag

Maintenance of the programs, new functions, 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 the delivery point lists from external service providers as Excel sheets or CSV files. These lists are not interface compatible and need to be converted before importing into the database. Using Excel, the provider's data for electricity and/or gas is prepared accordingly.
Extending the program with new features.
Excel programming in VBA.
Operating system: Windows 2010.
Software: Excel, VBA.

Jun 2024 - Jul 2024

2 months

Bayreuth, Germany

Development, architecture

Breitzmann Edelmetalle Gmbh & Co. Kg

The company Breitzmann publishes a subscription newspaper for its customers. For this, an address management system with subscription management, direct debit collection, automatic sending as PDF and print medium 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, Coinbook-Admin programs and the internal customer management website and

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, debugging, implementing new functionalities, new developments and program improvements.
Programming of software to transfer invoices, debtor master data, etc., to Datev.
Operating system: 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

Adaptation for accessibility

MATERNA GmbH

EVA and Zolldesk are existing customs administration programs and had to be adapted for accessibility.
Operating system: Windows 2010.
Software: C#.NET, .NET 4.6.1, .NET 4.8, WPF, WinForms.
Tools: unit testing, Visual Studio 2019, NDVA screen reader.

Sep 2020 - Mar 2021

7 months

Lübeck, Germany

Control of cameras with liquid lens for monitoring laser welds

SLM-Solution

SLM-Solution is the world-leading manufacturer of industrial 3D printers with laser welding process.
Control of cameras and associated liquid lens in the build chamber that monitor the production process.
Operating system: Windows 2010.
Software: C#.NET, WinForms.

Jun 2020 - Jun 2020

1 month

Kulmbach, Germany

Migration to .NET 4.7.2

Malzfabrik Johann Zeitler

Customer, supplier and item management.
Warehouse management, quality billing, supplier billing.
Delivery notes for incoming and outgoing, individual invoices, credit notes.
Various sales statistics, check and draft management, technical analysis, appointment calendar.
All printouts can be exported to Word, Excel, PDF. Creation of Word templates.
Operating system: 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 problems with Access caused by Microsoft updates, as well as reaching the size limit of the Access database, Coinbook was migrated to a new database.
As part of the migration, the performance and the program's interface were improved and the program code was refactored.
Operating system: Windows 2010.
Software: C#.NET, .NET 4.7.2, PostSharp, Log4Net, Syncfusion, Okii dialogs, JSON, LINQ, Rhino.Licensing, 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 in 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 machine and plant engineering.
Proven engineering in the Totally Integrated Automation Portal (TIA Portal).
With the new SIMATIC HMI Unified Comfort Panels and the SIMATIC IPCs, the performance of WinCC Unified can be optimally utilized.
Creating and performing UI tests and unit tests daily.
Operating system: Windows 10.
Software: C#, WinForms, Visual Studio 2017, TASuite, Tiflib, unit tests, XML.
Tools: Git.

Jul 2017 - Sep 2017

3 months

Heilbronn, Germany

Offer creation for customer win-back after cancellation

Stadtwerke Heilbronn

An Excel file is launched with a record ID from an Oracle database. Using this ID, Excel retrieves the customer data for electricity and/or gas.
Excel processes this data and then inserts it into pre-made text blocks and Word templates in Word.
Excel handles all formatting and assembly in Word, as well as printing the offers or contracts when the offers are accepted.
Excel and Word programming with 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 for DWS customers and is developed and maintained by an international team.
Migration of code parts from VB6 to C#.
Creating a new module for issuing and managing gift cards in the back office.
Backend programming for the web development (customer module) of the gift cards.
Migration and extension (WYSIWYG) of the administration of standard and individual letters using text blocks, manual entries, and automatically inserted data.
Creating 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

Creating software for rule-based notice generation for asylum seekers to reduce manual errors.
The notice generation is carried out 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 manages distributing complex structural stability calculations for wind turbines across standalone servers.
Server program: runs on each server, fetches time series from the database, performs calculations, and writes back progress and results.
Client: user interface for adding, monitoring, and controlling projects, as well as monitoring and configuring servers.
Validation program: checks each project after creation against specific 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

Creating a digital coin catalog for coin collectors.
Recording collection areas, coins, images, and all relevant data.
Managing Coinbook customers with licenses for the program and collection modules.
Invoicing and contact management.
Various customer letters using Word automation with Word templates.
Creating the 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

Managing bidders, consignors, and items for auctions.
Recording bids on the tablet.
Creating 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

Acquiring trades and orders from the Trayport trading system for gas and electricity 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

Managing interpreters and translators.
Customer management.
Invoicing.
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 determination 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 properties 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 speaking durations 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

Fixing tranches and storing 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 development

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 development

Samonig AG

Management of apartments with floor plans and apartment overview.
Sample calculation of financing costs, monthly payments 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.
Import price lists from Excel and assign them; export 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 creation, architecture, requirements analysis

Rhenus Access & Services

Creating a change management system with Matrix42.
Creating workflows with different levels of complexity (from linear to branching approvals).
Developing 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

Rhoden Frankenthal

Customer management for sales representatives.
Item management.
Sales management.
Interface to the 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: Recording defects and to-dos related to subcontractors.
Recording defect resolution.
Graphical display of defect resolutions 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

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

Sep 2012 - Present

13 years 5 months

Munich, Germany

Programming, form design, database design, operation

Mr. Pizza München

Customer management and item management.
Writing delivery notes/invoices.
Creating 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.
Processing and evaluating shooting festivals.
Shooter, class, club, and target management.
Scoring for air rifle, air pistol, small caliber, muzzleloader.
Manual result entry and result import from DISAG.
Prize distribution, entry fees, 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) to support new launches.
Requesting and comparing supplier quotes for purchased parts via Word letters.
Awarding suppliers based on these offers.
Displaying and assigning new parts to procurement managers.
Documenting supplier quotes and award history.
Importing planned costs and sales.
Cost monitoring and part tracking.
Action-guiding evaluation features for employees and managers.
Creating 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, dealer 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 administration system, ERP (migration from VB6 to C#.NET).
Customer, supplier, and product management.
Inventory management, quality billing, supplier billing.
Delivery notes for incoming and outgoing goods, individual invoicing, credit notes.
Various sales statistics, check and draft 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 report.
Interface between SAP and external program with verification and correction options.
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 provisioning and logistics.
Processing 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 subforms.
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-family and two-family homes.
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

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

ENBW

Büko2011: Migration to Windows 7 and Office 2010.
Adjustment of various programs and Word templates to Windows 7 and Office 2010.
Checking functionality 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

Programming of GUI, design, database connection

ENBW

VerA-Tool: Program to record and manage electricity and gas contracts.
Multi-client; reporting and business logic in the database.
Creation of Word templates.
Operating system: 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 association management for shooting clubs.
Migration from MS-DOS to Windows.
Easy management of members, address management, 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 system: 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

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

ENBW

DRULA - compressed air tool: questionnaire for collecting energy consumption data for compressed air systems.
Analysis and consulting on saving measures.
Automatic analysis as a report (PDF, Word, PowerPoint) with custom inputs and charts.
Creation of 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

Programming of GUI, business logic, database design, database connection, architecture, requirements analysis

ENBW

Network usage statistics: storage and calculation of network usage fees and metering prices from 2005 onwards.
Overall and weighted assumption planning on a monthly basis.
Display as tables and charts with various formatting options.
Automatic report generation for management (printout, PDF, PowerPoint).
Data import from an Oracle database.
Operating system: 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 for collecting specific energy consumption data.
Evaluation and consulting on savings measures.
Data collection, energy demand calculation and automatic report generation.
Creation of Word templates.
Operating system: Windows XP.
Software: VBA, Excel, PowerPoint and Word automation.

Jan 2009 - Dec 2010

2 years

Karlsruhe, Germany

Programming, form design, effort estimation, operations, database design, migration

ENBW

Provis: commission billing for field 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 letters and overview lists as printouts or PDFs for traceability.
Operating systems: 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 analyses, architecture, requirements analysis, data analysis

ENBW

Calculation of claims for overpaid network usage fees.
Basis for recalculations, out-of-court settlements and court proceedings.
Operating systems: 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, operations, database design, architecture, requirements analysis

ENBW

Commission billing for field 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, operations, database design

ENBW

UmfrageDB: database supporting call centers for telephone customer satisfaction surveys.
Operating system: Windows XP.
Software: VBA, Access.
Database: Access.

Aug 2007 - Jun 2011

3 years 11 months

Karlsruhe, Germany

Programming, Form Design, Effort Estimation, Operations, Architecture, Requirements Analysis

ENBW

Gas tariff calculator to calculate offers and compare gas contracts.
Print offers 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, Form Design, Effort Estimation, Database Design, Migration

ENBW

WWU CRM system for managing framework contracts with housing companies.
Migration from Access to C#.NET and MS SQL Server.
Management of objects, contract creation, and automatic letters.
Import/export of object lists to/from 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, Form 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 tables and 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, Form Design, Effort Estimation, Database Design, GUI

ENBW

TAM tool for managing projects.
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, Form Design, Operations

ENBW

Plato-Gas: forecast tool for gas demand.
Projecting gas demand by comparing with last year's consumption considering weekdays and temperatures.
Output in tables and charts.
Operating system: Windows XP.
Software: VBA, Excel.

Jul 2004 - Jun 2008

4 years

Stuttgart, Germany

Print tool for contract creation

ENBW

DocGenerator: print tool for contract creation for the calculation tool.
Reading and preparing CSV data from the calculation tool.
Compiling Word templates and text blocks; controlling formatting in Word.
Custom template management in Excel.
Operating systems: Windows 2000, NT, XP.
Software: Excel, Word, VBA.

Mar 2004 - Aug 2009

5 years 6 months

Karlsruhe, Germany

Frontend programming, GUI design, technical documentation

ENBW

Calculation tool for computing and creating power quotes for large customers.
Calculating power demand per quarter-hour using measured and synthetic load profiles.
Visual Basic 6 frontend, Java server backend; data transfer using CORBA.
Interfaces to existing applications and storage in an Oracle database.
Technical documentation in XML.
Operating systems: 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

Migrating from MS-DOS QuickBasic to Windows VB6 and SQL Server.
Managing customers, suppliers, and items; inventory management; quality billing.
Delivery notes, individual invoices, credit notes, and sales statistics.
Check and bill of exchange management, technical analysis, appointment calendar.
Export to Word, Excel, PDF, and HTML.
Operating systems: 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

diverse

Media management system specifically for films, with key data and selection options.
Export to Excel, HTML, PDF; scheduling with timesheet.
Importing data from the internet, duplicate check, and image management.
Automatic creation of scheduler files and control of 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 of pilot plants.
Modules: raw material and warehouse management, operational job book, technical job book, product management (formulation, reactor allocation), work instructions, maintenance, order management.
Interface to the ZOV program for internal cost accounting.
Export to Word, Excel, PDF, and HTML.
Operating systems: Windows NT, Windows 2000.
Software: .NET, C#.NET, Visual Basic 6.0, SQL, Access, Crystal Reports, ADO.NET, Excel, Windows Forms.
Tools: SourceSafe.
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 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 storing and monitoring revision results worldwide.
Tracking of reported items with follow-up and deadline tracking.
Statistical evaluations and export to Excel.
Multilingual statistics for global 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 assembly of directory structures.
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 individual add-on modules for each plant.
Archiving of all reports and 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

Time book: planning system for the shift supervisor (staff scheduling, vacation and appointment planning).
Management of overtime and shortfall hours; usable 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

Application for managing and creating questionnaires for worldwide audits.
Generation of questionnaires as printouts, Word, RTF, Excel or PDF format.
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 collection for managing audit photos as good/bad examples.
Drag & drop input, keyword and full-text search, thumbnail overview.
Interface to MS Paint and PowerPoint import; multilingual comments.
Run from CD without installation (using built-in features 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

Fault and work order log for managing service orders.
Entry, editing, release 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 for Merkur and Pago labeling program.
Data transfer using MQSeries via 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 staffing intensity.
Charging of rental costs and credits based on budget vs. actual costs.
Interface for transfer to SAP.
Operating system: Windows NT/ Windows 2000.
Software: Visual Basic 6.0, SQL, Crystal Reports, ADO.
Tools: Source Safe.
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 rail tank cars, tank trains, ships.
Import of orders using MQ-Series; planning and data exchange with the PLS (Foxboro).
Printing of records, utilization statistics, and maintenance monitoring.
Import of tank cars from DB2.
Operating system: Windows NT/Windows 2000.
Software: Visual Basic 6.0, SQL, ADO, Crystal Reports, 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.
Analysis of actual data, services, and 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 billing, 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

Extensions 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 of two precast plants.
Site management, order and revenue tracking.
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

diverse

Created several internet and intranet websites for various service providers (course institute, 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 wood wholesale.
Customer, article, inventory, and sales rep management.
Quotations, 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.
ZIP code search, 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 system for a concrete plant.
Management of mix recipes, cement, accessories, mixers and pumps.
Transfer of delivery notes from the mixing plant; monitoring of mixer drivers' hours.
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 and inventory management for a precast plant.
Customer and construction site management, single and jumbo items.
Batch invoicing, individual invoicing, credit notes; interface to financial 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 solution for physiotherapists - billing software.
Management of patients, health insurance providers, doctors, and services.
Prescription management, individual and batch invoicing; data exchange with health insurance providers.
Appointment calendar, word processing.
Software: Visual-Basic 5, SQL.
Database: Access.

Skills

Position:

Software Development / Programming
Consulting
Coaching / Training

Professional 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 Systems: 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
Creating Online Help
Support
Error Management And Handling Issue Tickets
User Consulting
Analysis And Preparation Of Business 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:

Component One - Formula One, Vs-flex, True-dbgrid, Ultragrid, Vs-ocx
Sizerone
Sax-zipobjects
Sheridan Calendar Widgets, Sheridan Datawidgets, Ole Tools, Farpoint Input-pro
Tx Textcontrol
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 Engineer (University of Applied Sciences) · Civil Engineering · Coburg, Germany

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Similar Freelancers

Discover other experts with similar qualifications and experience

Werner Mühlmann