Bernhard H.-Conversion of external Excel and CSV delivery point lists for internal database interface, architecture
Check rate
Experience
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 the internal database interface.
- Stadtwerke receives delivery point lists from external service providers in Excel or as CSV files. These lists are not interface-compliant and must be converted for import into the database. Using Excel, the relevant data from the service providers for electricity and/or gas is prepared accordingly.
- Extension of the program with new features.
- Excel programming using VBA.
- Operating system: Windows 2010.
- Software: Excel, VBA.
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, development of 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.
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 the internal database interface.
- Stadtwerke receives delivery point lists from external service providers in Excel or as CSV files. These lists are not interface-compliant and must be converted for import into the database. Using Excel, the relevant data from the service providers for electricity and/or gas is prepared accordingly.
- Excel programming using VBA.
- Operating system: Windows 2010.
- Software: Excel, VBA.
Development, architecture
Breitzmann Edelmetalle Gmbh & Co. Kg
- Breitzmann publishes a newspaper by subscription for its customers. An address management system with subscription management, direct debit collection, and automatic delivery as a PDF and printed medium was developed for this purpose.
- Operating system: Windows 2010.
- Programming environment: C#.net,.WinForms, LiteDB.
- Tools: Visual Studio 2022, Git.
- Databases: LiteDB.
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.
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 under VB6, C# and TSQL, as well as troubleshooting, implementation of new functionalities, new developments and improvements to programs.
- Programming of software for transferring invoices, customer 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.
Adaptation for accessibility
MATERNA GmbH
- EVA and Zolldesk are existing administrative programs of the customs authority 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-Test, Visual Studio 2019, NDVA Screenreader.
Control of cameras with liquid lenses for monitoring laser welding
SLM-Solution
- SLM-Solution is the world's leading manufacturer of industrial 3D printers using laser welding processes.
- Control of cameras and the associated liquid lens in the build chamber, which monitor the production process.
- Operating system: Windows 2010.
- Software: C#.net,.WinForms.
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 goods, 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 and PDF. Creation of Word templates.
- Operating system: Windows 2010.
- Software: C#.net,.net 4.7.2, PostSharp, Log4Net, Syncfusion, Okii-Dialoge, Json, Linq, WinForms, XML.
- Tools: Git.
- Database: MS SQL Server.
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 the Access database reaching its size limit, Coinbook was migrated to a new database.
- As part of the migration, the program's performance and user interface were improved, and the program code was refactored.
- Operating system: Windows 2010.
- Software: C#.net,.net 4.7.2, PostSharp, Log4Net, Syncfusion, Okii-Dialoge, Json, Linq, Rhino.Lizensing, CSharpzip, WinForms, FluentFTP, Paypal-Api, Json, XML.
- Tools: Git.
- Database: LiteDB/ MS SQL Server.
Development in C#, WPF MVVM, VB.NET
Ersa GmbH
- Programming the UI (VB.NET) for soldering robots as well as backend development (.net Core 3.0) for these devices.
- Processing and visualization of 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, Win-Forms, VB.Net.
- Tools: Git under DevOps.
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 mechanical 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 performance of WinCC Unified to be used to its full potential.
- 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.
Preparing offers to win back customers after cancellation
Stadtwerke Heilbronn
- Excel is launched from an Oracle database with a record ID. Excel then uses this ID to retrieve the corresponding customer data for electricity and/or gas.
- This data is processed accordingly with Excel and then inserted into pre-prepared text modules and Word templates in Word.
- Excel controls all formatting and compilation in Word, as well as the printing of offers and contracts when the offers are accepted.
- Excel and Word programming using VBA, creation of Word templates.
- Operating system: Windows 2010.
- Software: Excel, Word, VBA.
New development of various modules, migration from VB6 to C#, architecture, requirements analysis
DWS (Deutsche Bank) Luxemburg
- The software package manages the assets and investments of DWS customers and is developed and maintained by an international team.
- Migration of program components from VB6 to C#.
- Creation of a new module for issuing and managing gift cards in the back office.
- Backend programming for the web development of the gift card customer module.
- Migration and enhancement (WYSISWYG) of the administration of serial and individual letters using text modules, manual entries and automatically inserted data.
- Creation of Word templates and programming of a dedicated 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.
Development, architecture, requirements analysis
Federal Office for Migration and Refugees
- Creation of software for rule-based decision issuance for asylum seekers in order to reduce manual errors.
- Decisions are issued at many branch offices throughout Germany.
- Operating system: Windows 7.
- Software: C# WPF, Prism, .net Framework 4.6, Nhibernate, Webservice.
- Database: Oracle.
Complete programming, architecture, requirements analysis
Enercon
- BladedSC is a program that controls the distribution of complex structural stability calculations for wind turbines across independent servers.
- Server program: Runs on each server, retrieves time series from the database, performs calculations, and writes progress and results back.
- Client: User interface for adding, monitoring, and controlling projects, as well as monitoring and parameterizing the servers.
- Verification program: Checks each project against specific criteria after creation before transferring it to the servers.
- Operating system: Windows 7.
- Software: C#.net, WPF MVVM for the client, .net 4.5, PostSharp, XML.
- Database: MongoDB.
Complete architecture, requirements analysis, programming, maintenance
Coinbook-Verlag
- Development of a digital coin catalog for coin collectors.
- Recording of collecting areas, coins, images, and all relevant data.
- Management of Coinbook customers with licenses for the program and collection modules.
- Invoicing and contact management.
- Various customer letters using Word automation and 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.
Complete programming
Der Wohnungsauflöser
- Management of bidders, consignors, and items for auctions.
- Recording successful bids on the tablet.
- Preparing 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.
Complete programming, architecture, requirements analysis
EHW
- Transfer of trades and orders from the Trayport trading system for gas and electricity trading by accessing the Trayport server.
- Provision of the data in CSV files.
- Operating system: Windows 7.
- Software: C#.net, .net 3.5, ItextSharp, PostSharp, Log4Net, WinForms, XML.
Migration of an Access solution from Access 95 to Access 2010
Bösch-Computer
- Management of interpreters and translators.
- Customer management.
- Invoicing.
- Operating system: Windows 7.
- Software: Access 2010, VBA.
- Database: Access 2010.
Complete programming
Muteba
- Management of interpreters and translators.
- Customer management.
- Invoice creation.
- Operating system: Windows 7.
- Software: C#.NET, .net 3.5, ItextSharp, PostSharp, Log4Net, XML.
- Database: MS SQL Server.
Complete programming, architecture, requirements analysis
EHW
- Daily determination of gas purchase and sales prices for Dayahead, BOM, subsequent months, subsequent quarters, Seasons.
- Spread matrix.
- Operating system: Windows 7.
- Software: Excel, VBA.
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.
Complete programming
Fa. Himmel
- Assignment of dubbing actors to different episodes.
- Calculation of speaking times for individual scenes, episodes and dubbing actors.
- Operating system: Windows 7.
- Software: Excel, VBA.
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.
Complete programming
Dr. Straub
- Invoice program in Word, including the creation of Word templates.
- Inventory management and income-surplus accounting in Excel.
- Automation of inventory management and income-surplus accounting from Word.
- Operating system: Windows 7.
- Software: Excel, VBA.
Complete programming
Samonig AG
- Management of apartments with floor plans and apartment overviews.
- Sample calculation of financing costs, monthly burden and tax savings.
- Operating system: Windows 7.
- Software: Excel, VBA.
Programming
Aktivhotel Wernigerode
- Management of articles, suppliers and prices.
- Ordering and inventory management.
- Importing and assigning price lists from Excel; exporting price lists to Excel.
- Operating system: Windows 7.
- Software: Access, Excel, VBA.
Change management workflow creation, architecture, requirements analysis
Rhenus Access & Services
- Creation of change management with Matrix42.
- Creation of workflows with varying levels of complexity (from linear workflows to branching approvals).
- Creation of 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.
Programming, form design, database design, operations
Fa. Rhoden Frankenthal
- Customer management for sales representatives.
- Article management.
- Revenue management.
- Interface to the main program.
- Operating system: Windows XP, Windows 7.
- Software: Access, VBA.
- Database: Access.
Programming, form design, database design, operations
various
- Construction site monitoring: recording defects and to-dos related to subcontractors.
- Recording defect rectification.
- Graphical display of defect rectification by month to monitor reliability.
- Statistics with various filters (date, subcontractor, component, type of defect).
- Operating system: Windows XP, Windows 7.
- Software: Excel, VBA.
- Database: Excel.
Programming, form design, database design, operations
Herr Edelmann
- Invoicing program including customer management and product management.
- Create delivery notes/invoices.
- Operating system: Windows XP, Windows 7.
- Software: Excel, VBA.
- Database: Excel.
Programming, form design, database design, operations
Mr. Pizza München
- Customer management and product management.
- Create delivery notes/invoices.
- Creation of Word templates.
- Operating system: Windows XP, Windows 7.
- Software: Excel, VBA.
- Database: Excel.
Design, database design, programming, project management
shooting clubs
- Shooting results evaluation for shooting clubs; migration from VB6 to C#.NET, WPF.
- Processing and evaluation of shooting festivals.
- Management of shooters, classes, clubs, and targets.
- Scoring for air rifle, air pistol, small-caliber rifle, and muzzleloaders.
- Manual entry of results and transfer of results from DISAG.
- Prize distribution, entry fees, additional purchases, 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.
Programming, form design, database design, operations
Daimler
- Prototype tracking tool (AMS) to support new launches.
- Requesting and comparing supplier quotes for purchased parts by sending Word letters.
- Awarding suppliers based on these quotes.
- Display and assignment of new components to purchasing managers.
- Documentation of supplier quotes and award history.
- Import of planned costs and revenues.
- Cost monitoring and component tracking.
- Action-oriented evaluation functionalities for employees 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.
Programming, form design, architecture, requirements analysis
ENBW
- Gas volume calculation for supply contracts.
- Transfer and connection program between SAP, trader and network operator databases for long-term planning.
- Operating system: Windows XP, Windows 7.
- Software: VBA (Access).
- Database: Access, Oracle.
Design, database design, programming, project management, architecture, requirements analysis
Malzfabrik Johann Zeitler
- Malt billing and management system, merchandise management (migration from VB6 to C#.NET).
- Customer, supplier and article management.
- Warehouse management, quality billing, supplier billing.
- Delivery notes for incoming and outgoing goods, individual invoices, credit notes.
- Various sales statistics, cheque and bill of exchange management, technical analysis, 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.
Programming, form design, architecture, requirements analysis
ENBW
- Index quick report.
- Interface between SAP and external program with review and correction options.
- Operating system: Windows XP, Windows 7.
- Software: VBA, Excel.
- Database: Oracle.
Programming, form design, GUI, migration from an Access project
ENBW
- AwEL - application database for energy supply and logistics.
- Processing of customers in the extraterritorial area of the deregulated energy market.
- Display of open orders in a tree structure according to priority.
- Correction and completion 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.
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.
Adaptation of various programs to Windows 7 and Office 2010, architecture, requirements analysis
ENBW
- Büko2011: Migration to Windows 7 and Office 2010.
- Adaptation of various programs and Word templates to Windows 7 and Office 2010.
- Verification of operability 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.
GUI programming, design, database integration
ENBW
- VerA-Tool: Program for recording and maintaining electricity and gas contracts.
- Multi-client capable; evaluation and business logic in the database.
- Creation of Word templates.
- Operating system: Windows XP, Windows 7.
- Software: VBA, Excel.
- Database: Oracle.
Design, database design, programming, project management
SAN-Software
- SAN club administration for shooting clubs.
- Migration from MS-DOS to Windows.
- Convenient management of members, address management, function descriptions and activities.
- Freely configurable form letters, integration into existing printouts.
- Extensive evaluations, list and form designers (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.
GUI and business logic programming, design, architecture, requirements analysis
ENBW
- DRULA - Compressed air tool: Questionnaire for recording energy consumption data for compressed air systems.
- Evaluation and advice on saving measures.
- Automatic evaluation as a report (PDF, Word, Powerpoint) with individual entries and charts.
- Creation of Word templates.
- Operating system: Windows XP.
- Software: VBA, Excel, Powerpoint and Word automation.
- Methods: Scrum.
GUI programming, business logic, database design, database integration, architecture, requirements analysis
ENBW
- Network usage statistics: Storage and calculation of network usage fees and metering prices from 2005 onward.
- Overall and weighted premise planning by month.
- Presentation as a table and chart with various formatting options.
- Automatic report generation for management (printout, PDF, Powerpoint).
- Transfer of data 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.
GUI and business logic programming, design, architecture, requirements analysis
ENBW
- IdEE: Questionnaire for collecting specific energy consumption data.
- Evaluation and advice on energy-saving 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.
Programming, form design, effort estimation, operations, database design, migration
ENBW
- Provis: Commission settlement for field sales representatives.
- Migration from Access to C#.net and MS SQL Server.
- Data transfer from SAP and Excel.
- Automatic commission calculation, cancellations, and completeness checks.
- Automatic 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.
Programming and evaluations, architecture, requirements analysis, data analysis
ENBW
- Calculation of claims for overpaid grid usage fees.
- Basis for recalculations, out-of-court settlements, and court proceedings.
- Operating system: Windows XP, Windows 7.
- Software: VBA, Access 2003, Excel 2003.
Programming, form design, effort estimation, operations, database design, architecture, requirements analysis
ENBW
- Commission settlement for field sales representatives.
- Data transfer from SAP and Excel.
- Operating system: Windows XP.
- Software: VBA, Access.
- Database: Access.
Programming, form design, operations, database design
ENBW
- UmfrageDB: Database supporting call centers with telephone surveys on customer satisfaction.
- Operating system: Windows XP.
- Software: VBA, Access.
- Database: Access.
Programming, screen design, effort estimation, operations, architecture, requirements analysis
ENBW
- Gas tariff calculator for calculating offers and comparing gas contracts.
- Printing of offers and tariff comparisons.
- Operating system: Windows XP, Windows 7.
- Software: Excel 2003/2010, VBA.
Programming, screen 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 letters.
- 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.
Programming, screen design, effort estimation, database design, GUI, architecture, requirements analysis
ENBW
- Forecasting tool for gas demand based on consumption in previous years, weekdays, and temperatures.
- Output in tabular and chart form; export/import from/to Excel.
- Operating system: Windows XP.
- Software: C#.NET, .net 1.1, .net 2.0, Windows Forms, XML, Excel automation, ZedGraph.
- Database: Access.
Programming, screen 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.
Programming, screen design, operations
ENBW
- Plato-Gas: Forecasting tool for gas demand.
- Projection of gas demand by comparing it with consumption in previous years, taking weekdays and temperatures into account.
- Output in tabular and chart form.
- Operating system: Windows XP.
- Software: VBA, Excel.
Printing tool for contract creation
ENBW
- DocGenerator: Printing tool for contract creation for the calculation tool.
- Importing and preparing CSV data from the calculation tool.
- Compiling Word templates and text modules; controlling formatting in Word.
- Own template management in Excel.
- Operating systems: Windows 2000, NT, XP.
- Software: Excel, Word, VBA.
Frontend programming, screen design, technical documentation
ENBW
- Calculation tool for calculating and creating electricity offers for large customers.
- Calculating electricity demand per quarter-hour using measured and synthetic load profiles.
- Visual-Basic 6 frontend, Java server backend; data transfer using Corba.
- Interfaces to existing programs and storage in Oracle database.
- Technical documentation in XML.
- Operating systems: Windows 2000, NT, XP.
- Software: Visual Basic 6.0, Corba, Excel, Forms.
- Tools: CVS.
- Database: Oracle.
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 article management, warehouse management, quality accounting.
- Delivery notes, individual invoices, credit notes, and sales statistics.
- Cheque and bill of exchange management, technical analysis, calendar management.
- 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.
Design, database design, programming, project management
diverse
- Media management system specifically for films, with key data and selection options.
- Export to Excel, HTML, PDF; time planning with timesheet.
- Data import from the Internet, duplicate checking, and image management.
- Automatic creation 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.
Design, database design, programming, architecture, requirements analysis
BASF Ludwigshafen
- Technical Center Information System (TIS) for managing, monitoring, and billing technical centers.
- Modules: Operating materials and warehouse management, operational order book, technical order book, product management (recipe, kettle assignment), 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: Source Safe.
- Database: Oracle.
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.
Design, database design, programming, maintenance and project management, architecture, requirements analysis
BASF Ludwigshafen
- Revision management for storing and monitoring revision results worldwide.
- Monitoring of reported issues with follow-up and deadline tracking.
- Statistical analyses and export to Excel.
- Multilingual statistics for worldwide use.
- Operating system: Windows NT/ Windows 2000.
- Software: Visual Basic 6.0, SQL, ADO, Access.
- Tools: Source Safe.
- Database: Access.
Design, programming, maintenance and project management, architecture, requirements analysis
BASF Ludwigshafen
- Caesar: Simple CD burning program for data backup.
- Use of administrator templates for the automated creation of directory structures.
- Operating system: Windows NT/ Windows 2000.
- Software: Visual Basic 6.0.
Design, database design, programming, maintenance and project management, architecture, requirements analysis
BASF Ludwigshafen
- Electronic shift logbook for shift operations to hand over reports.
- Consists of a basic module and individual additional modules for each department.
- 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.
Design, database design, programming, maintenance and project management, architecture, requirements analysis
BASF Ludwigshafen
- Hours logbook: Planning system for the shift supervisor (employee planning, vacation and appointment scheduling).
- Management of overtime and missing hours; usable as a standalone application or integrated system.
- Operating system: Windows NT/ Windows 2000.
- Software: Visual Basic 6.0, SQL, Access.
- Tools: Source Safe.
- Database: Access/Oracle.
Design, database design, programming, maintenance and project management, architecture, requirements analysis
BASF Ludwigshafen
- Program for managing and creating questionnaires for audits worldwide.
- Generation of questionnaires for printing and in 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.
Design, database design, programming, maintenance and project management, architecture, requirements analysis
BASF Ludwigshafen
- Image collection for managing audit photos as good/bad examples.
- Drag-and-drop import, keyword and full-text search, thumbnail overview.
- Interface to MS-Paint and PowerPoint import; multilingual comments.
- Executable from CD without installation (Visual Basic Standard built-in tools).
- Operating system: Windows NT/ Windows 2000.
- Software: Visual Basic 6.0 Standard.
Design, database design, programming, maintenance and project management, architecture, requirements analysis
BASF Ludwigshafen
- Incident and order log for managing contractor orders.
- Entry, processing and 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.
Design, programming, maintenance and project management, architecture, requirements analysis
BASF Ludwigshafen
- Interface for importing order data from SAP for the Merkur and Pago labeling programs.
- Data transmission via MQSeries using IDOCS directly into Oracle tables.
- Operating system: Windows NT/ Windows 2000.
- Software: Visual Basic 6.0, SQL.
- Database: Oracle.
Design, programming, maintenance and project management
BASF Ludwigshafen
- ZOV - Internal billing of pilot plant services to clients.
- Service billing based on plant value classes and personnel intensity.
- Allocation of rental costs and credits based on budget versus actual costs.
- Interface for transmission to SAP.
- Operating system: Windows NT/ Windows 2000.
- Software: Visual Basic 6.0, SQL, Crystal Report, ADO.
- Tools: Source Safe.
- Database: Oracle.
Design, programming, maintenance and project management
BASF Ludwigshafen
- CATMAN - Creation and management of catalyst offers.
- Transfer 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.
Design, programming, maintenance and project management
BASF Ludwigshafen
- MERKUR - Filling system for ammonia and ammonia solution.
- Control of filling tank cars, tank trucks and ships.
- Transfer of orders via MQ-Series; planning and data exchange with the PLS (Foxboro).
- Printing of records, utilization statistics and repair monitoring.
- Transfer 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.
Design, database design, programming, architecture, requirements analysis
Marconi
- Margin controlling in Access; transfer of data from SAP and Excel.
- Analysis of actual data, services and sales for current and subsequent years.
- Report creation 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.
Programming
Altvater GmbH
- Order management for a confectionery company, including inventory management and commission settlement.
- Interface to FIBU, accounts receivable posting, sales statistics.
- Trigger programming for Gupta database.
- Operating system: Windows NT.
- Software: Visual Basic 5, SQL, ODBC, Crystal Reports.
- Database: Gupta database.
Programming
Altvater GmbH
- Enhancements for the BELLA logistics program.
- 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.
Design, database design, programming and project management
Robert Backer KG
- Order and revenue monitoring for two precast plants.
- Construction site management, order and revenue recording.
- Analysis of order backlog, increases/decreases, comparison with previous years.
- Software: Visual Basic 5, SQL.
- Database: Access.
Design, programming, project management
various
- Creation of several websites for the Internet and intranet for various service providers (health resort, bus dealership, retail).
- Programming language: HTML.
Design, database design, programming and project management
Parkett Ritter
- Complete order management and inventory management for a wholesale timber business.
- Customer, item, warehouse and sales representative management.
- Quotations, order confirmations, delivery notes, invoices, credit notes.
- Software: Visual Basic 5, SQL, Crystal Reports.
- Database: Access 97.
Design, database design, programming and project management
Salem / Humanitas
- Donation management including address and account management.
- Circular letters based on criteria, individual and annual receipts, duplicate checking.
- Postal code search, word processing and interface to Word.
- Software: Visual Basic 5, SQL, Crystal Reports.
- Database: Access.
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.
- Transfer of delivery notes from the mixing plant; monitoring of mixer drivers' working hours.
- Software: Visual Basic 5, SQL.
- Database: Access.
Design, database design, programming and project management
KDF Kulmbach
- Complete order management and inventory management for prefabricated parts plant.
- Customer and construction site management, individual and jumbo items.
- Collective invoices, individual invoices, credit notes; interface to FIBU.
- Software: Visual Basic 5, SQL.
- Database: Access.
Design, database design, programming and project management
various
- Industry solution for physiotherapists - billing program.
- Management of patients, health insurance companies, doctors and services.
- Prescription management, individual and collective invoices; data exchange with health insurance companies.
- 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.
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.
Skills
Position:
- Software Development / Programming
- Consulting
- Coaching / Instruction / 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 Processing Of Problem 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
Additional Modules And Frameworks:
- Component One - Formula One, Vs-Flex, True-Dbgrid, Ultragrid, Vs-Ocx
- Sizerone
- Sax-Zipobjects
- Sheridan Calender Widgets, Sheridan-Datawidgets, Ole-Tools, Farpoint Input-Pro
- Tx-Textcontrol
- First Impression
- Nu-Cdr
- Zedgraph
- Itextsharp
- Postsharp
- Log4net
- Matrix42
- Microsoft Workflow-Framework
- Entity Framework
- Synfusion
- Telerik
- Microsoft Report-Builder
Version Control Systems And Tools:
- Cvs
- Sourcesafe
- Git
- Mercourial
- Subversion
- Confluence
- Jira
Interfaces:
- Sepa Direct Debit
- Idocs
- Json
- Xml
It Training:
- Ms-Office
- Corel Draw
- Windows
- Windows Nt
- Programming
Languages
Education
FH Coburg
Diplomingenieur (Fachhochschule) · Civil engineering · Coburg, Germany
Statistics
Experience
Global experience
Expertise
Qualifications
Frequently asked questions
Have questions? Find more information here.
Bernhard is based in Stadtsteinach, Germany and can operate in on-site, hybrid, and remote work models.
Bernhard speaks the following languages: German (Native), English (Advanced).
Bernhard has at least 29 years of experience. During this time, Bernhard has worked in at least 47 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.
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, Coinbook-Admin programs and the internal customer management website and, Development, architecture.
Bernhard's most recent position is Conversion of external Excel and CSV delivery point lists for internal database interface, architecture at Stadtwerke Heilbronn.
In recent years, Bernhard has worked for Stadtwerke Heilbronn, Coinbook-Verlag, Breitzmann Edelmetalle Gmbh & Co. Kg, Unimed GmbH, and Mr. Pizza München.
Bernhard is most experienced in industries like Information Technology, Food and Beverage, and Sport. Bernhard also has some experience in Energy, Utilities, and Healthcare.
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.
Bernhard has recently worked in industries like Information Technology, Food and Beverage, and Sport.
Bernhard has recently worked in business areas like Information Technology, Product Development, and Project Management.
Bernhard holds a Bachelor in Civil engineering from FH Coburg.
The availability of Bernhard needs to be confirmed.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 5 Nov 2026. 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
Nearby freelancers
Professionals working in or nearby Stadtsteinach, Germany
