Frank S. - Software and Database Developer

Go to Website

Grafschaft, Germany

Experience

Mar 2021 - Dec 2024

3 years 10 months

Ransbach-Baumbach, Germany

Software and Database Developer

Frigosped GmbH

Upgrading the existing Delphi 2010 version to Delphi 10.4
Making all software products Terminal Server capable
Maintaining and further developing the in-house freight forwarding software until replacement by a new version
Technologies: Delphi 2010, Delphi 10.4, Advantage Database, DevExpress, GIT, Devart, OOP

Aug 2019 - May 2020

10 months

Karlsruhe, Germany

Software and Database Developer

TWI-Germany GmbH

Developing a web service for DHL's business customer division
Migrating projects from Delphi 7 to Delphi XE2
Refactoring and moving to SVN version control
Technologies: Delphi 7, Delphi XE2, Oracle 11, DevExpress, SVN, TOAD for Oracle, Devart ODAC

Apr 2019 - Jun 2019

3 months

Dietzenbach, Germany

Software and Database Developer

Dimetis GmbH

Migrating the BOM application from Delphi 7 to Delphi 10.3 Rio
Revising the messaging system
Implementing customer-specific GUI adaptations based on the requirements list
Implementing billing routines in Oracle 11 using PL/SQL
Adjusting and creating new PL/SQL packages
Technologies: Delphi 7, Delphi 10.3 Rio, Oracle 11, DevExpress, Git, TOAD for Oracle

Dec 2018 - Jun 2019

7 months

Sprockhövel, Germany

Software and Database Developer

B-Solution AG

Developing project-specific extensions based on the existing Delphi 5 framework
Connecting to SQL Server
Technologies: Delphi 5, SQL Server

Nov 2017 - Oct 2018

1 year

Friedrichshafen, Germany

Software and Database Developer

Aberle GmbH

Developing project-specific extensions in the logistics framework
Creating a WMS service for an OCR system
Technologies: Delphi 10.2 Tokyo, Oracle 12, SVN, Devart ODAC

Aug 2016 - Oct 2017

1 year 3 months

Düsseldorf, Germany

Software developer

Rechenzentrum der Finanzverwaltung NRW (RZF)

Further development and revision of tax software for external tax auditors
Object-oriented restructuring and improved maintainability
Migration from file system to MariaDB server
Migration from Delphi 2007 to Delphi 10 Seattle 64-bit
Technologies: Delphi 2007, Delphi 10 Seattle, MariaDB, UniDAC, FastReport

Mar 2016 - Apr 2016

2 months

Mannheim, Germany

Software developer

Mannheimer Versicherung

Created a host switch with Delphi 10 Seattle, Spring4D, Delphi Mocks, DUnitX
COM connection between host and web application
Automatic opening and closing of Internet Explorer dialogs for address changes
Technologies: Delphi 10 Seattle, Perforce, Spring4D, Mocks

Jul 2015 - Feb 2016

8 months

Hamburg, Germany

Software developer

Olympus Surgical Technologies Europe

Extended a DICOM interface with DICOM Storage Commitment for ENDOBASE release
Prepared IEC 62304 compliant documentation
Expanded the SQL Server database with attributes and functions
Technologies: Delphi 7, MS-SQL Server 2008/2012, Perforce

Mar 2014 - Dec 2014

10 months

Kaiserslautern, Germany

Software developer

VWD Group

Developed a transaction interface using Delphi 2007
Enhanced a SWIFT interface with various record types
Imported data via Portfolio Sync Interface into the portfolio manager
Technologies: Delphi 2007, MS-SQL Server 2008 R2, Scrum, Jira

Mar 2013 - Dec 2013

10 months

Schwäbisch Hall, Germany

Software developer

Seidenader Maschinenbau GmbH

Developed process control software for packaging machines using Delphi and SQL Server 2008
Commissioning at customer site in Italy
Adjusted existing database structures, created tables, attributes, and SQL queries
Technologies: MS-SQL Server 2008, FastReport 4

Mar 2012 - Present

13 years 6 months

Münster, Germany

Software and Database Developer

BabyOne GmbH

Development of an internal Delphi application (Delphi 2010–10.4) for invoicing payment and direct debit notifications between branches and suppliers
Creation of the GUI and reports with FastReport 4
Implementation of performance-intensive billing routines at the database level
Migration to test-driven development with DUnitX
Designed the database model, implemented stored procedures, optimized queries and indexes, and performed SQL profiling
Created cronjob events for scheduling and automation
Technologies: Delphi 2010, MySQL 5.5, SVN, Toad for MySQL, DBForge Studio, Developer Express, Devart MySQL Components, FastReport, TDD, DUnitX

Nov 2011 - Mar 2012

5 months

Bergisch Gladbach, Germany

Software and Database Developer

Mika Timing GmbH

Assisted in further development of SportsPro using Delphi 6 and Oracle 9i
Developed new GUI features in a 3-tier architecture
Created and extended stored procedures, adjusted tables and attributes
Optimized existing SQL statements, created complex queries
Technologies: Delphi 6, Oracle 9i, Oracle SQL Developer, SVN

Mar 2011 - May 2011

3 months

Cologne, Germany

Software Development and Consulting

Gesellschaft für Kanzleiorganisation mbH

Reorganized the software package in SVN by Delphi versions
Created a new setup routine
Analyzed all program modules and managed build versioning
Fixed bugs and created updates
Documented the new structure and trained a new team member
Technologies: Delphi 3, Delphi 6, Delphi 2005, MySQL, SVN

Jan 2009 - Mar 2012

3 years 3 months

Mönchengladbach, Germany

Software and Database Developer

Isban.DE (Santander Consumer Bank)

Further developed MatrixRevolution using Delphi 7, MySQL 5.0, and iSeries V5R4
Developed and maintained Java stored procedures on iSeries
Synchronized MySQL with the iSeries system
Migrated from Delphi 7 to Delphi XE
Supported HKM2010 redevelopment and porting
Migrated the iSeries database to Oracle 10g, developed PL/SQL stored procedures, and accessed host web services
Optimized database models and queries
Technologies: Delphi 7, Delphi XE, Report Builder 10, MySQL 5.0, VSS, iSeries V5R4, Java/Eclipse 3.4, OOP, OOA, XML, XSD, DUnit, Oracle 10g, PL/SQL Developer, SVN, ADO, MySQL Data Access Components, DOA Components

Apr 2008 - Dec 2008

9 months

Risch-Rotkreuz, Switzerland

Software and Database Developer

Roche Diagnostic AG

Enhanced the Windows software AmpliLink using Delphi 2006
Designed and implemented an XML interface for orders, samples, and raw data with XSD schemas
Developed new GUI features and fixed bugs at the GUI and business logic levels
Created and updated unit tests
Customized and extended the Firebird 2.1 database, wrote complex queries and optimized performance
Technologies: Delphi 2006, Firebird 2.1, IBExpert, Rational Rose, RequisitePro, PVCS, OOP, OOA, XML, XSD, DUnit, IBO, DeveloperExpress Quantum Grid

Dec 2005 - Apr 2008

2 years 5 months

Bochum, Germany

Software and Database Developer

Faber Lotto Service KG

Creation of a new backend for internal customer management
Development of an application framework for programs, screens, and batch runs
Implementation of an authorization system based on MS SQL Server
Framework extensions via DLLs through interfaces
Multithreading module for parallel data transfer with DCOM
Redesign of the data model, porting from SQL Server 2000 to 2005
Development of submission and evaluation routines at the database level
Load tests to identify bottlenecks
Modeling and updating the database structure and stored procedures
UML diagrams of program flows and classes
Technologies: Delphi 2005, MS SQL Server 2000/2005, SQL, CVS, ModelMaker 8, Visio, UML, Threading, SQL Server BI Dev Studio, TOAD for SQL Server, ADO

Sep 2004 - Nov 2005

1 year 3 months

Cologne, Germany

Software Developer, Quality Assurance

TelcoMedia Consult GmbH (Solvatis GmbH)

Extension of the EasyLog shipping package for Deutsche Post DHL with the EuroPlus procedure
Interface programming and DLL creation
Technical documentation and process modeling
Migration from Delphi 5 to Delphi 2005, adapting components to the new VCL and IDE
Update of the software package to Windows XP design
Technologies: Delphi 5, Delphi 2005, Sybase 8/9, SQL, CVS, XML, Elips, StarTeam 6.0, ModelMaker, Developer Express, ADO, BDE, Indy 9/10

May 2004 - Jul 2004

3 months

Wachtendonk, Germany

Software Developer (Project Lead)

Obschroef GmbH

Project management in the development of client/server shipping software for correctional facilities
Master data management (prisons, detention accounts, product groups, products, storage locations, users)
Document processing with barcode control
Forms: invoices, labels, fresh goods stock, order forms, various reports
Data backup and printer assignment with tray control
Technologies: Delphi 7, Firebird 1.5, SQL, Developer Express, SQLDirect, FastReport, ReportBuilder

Feb 2004 - May 2004

4 months

Neuwied, Germany

Software and Database Developer

Vario Software GmbH

Revision of existing modules: inventory posting in the warehouse management system
Automated import of Outlook emails into the application via address matching
Interface to AuctionWeb via web services/SOAP
Technologies: Delphi 5, Interbase/Firebird, OLE/COM+/DCOM

Jan 2002 - Dec 2006

5 years

Leverkusen, Germany

Software and Database Developer

SCM-Tools

Implementation of replication for CRM address and contact data
Definition of replication rules for ISDN/DSL clients
Creation of the replication concept at the database level
Conversion of database tables to GUIDs
Implementation of the replication concept on the server and client side
Technologies: Delphi 5, Interbase 6, SQL, process modeling, replication techniques, IBOObjects, Developer Express

Jan 2002 - Dec 2004

3 years

Essen, Germany

Software Developer

Mauve Consulting

Development of an Intrastat module for reporting on diskette
Independent of ERP system for separate maintenance
Technology: Superbase 2001

Mar 1999 - Aug 2003

4 years 6 months

Leichlingen, Germany

Software and Database Developer, Project Manager

European Consulting GmbH

Design and development of export software to model logistics processes
Components: document capture, multi-client capability, intercompany, planning, picking, bills of materials, shipping documents, item-customer prices, ERP/MRP interfaces
Analysis, design and implementation of the database model and metadata structure
Planning and design of the Windows GUI and object model, component selection
Setup and maintenance of a Windows network (10 clients, 2 servers, Windows 98–XP, Windows 2000 Server)
Technologies: Delphi 7, Oracle 8i/9i, Client-Server, OOP, process analysis, Windows, Exchange Server, Developer Express, ODAC, MDAC, SQLDirect, Fast Report, ReportBuilder

Jan 1999 - Dec 2002

4 years

Leverkusen, Germany

Software Developer, Consultant

Logisco GmbH

Consulting in Intrastat shipping/export under Baan
Development of a visual front end for generating shipping/export documents
Database design and implementation of the ASCII interface
Design and implementation of form-filling programs (~15 forms)
Technology: Superbase 2001

Mar 1993 - Jul 1993

5 months

Cologne, Germany

Software Developer

Klöckner Humboldt Deutz

Analysis and modification of a procurement database in dBase/Clipper
Programming printer control for form output
Adaptation of the ASCII interface file and Excel import routine
Technologies: dBase, Clipper (DOS), VBA

Jan 1992 - Dec 1999

8 years

Langenfeld, Germany

Software Developer, Project Manager

IFS Geimer + Partner GmbH

Implementation of complex logistics processes based on standard shipping software
Projects incl. ABS GmbH (DHL interface), Veit GmbH (packing line integration), Technocargo (SAP R/3 IDOC interface), Klöckner (Oracle 7 backend with Superbase 3.6i frontend)
Data migration from Baan, PsiPenta, Brain, Pro Alpha, SAP R/3 (IDOC, ODBC)
Design and implementation of customizations/add-on modules
Installation and training at the client site
Technologies: Superbase 2.x–3.6i, Oracle 7, SQL, PL/SQL

Jan 1991 - Dec 1995

5 years

Aachen, Germany

Consultant, Software Developer, System Administrator

Giessen Architecture Office

Advising on the selection of standard and industry-specific software
Setting up and maintaining a Windows NT 4.0 network (5 workstations)
Developing interfaces between the CAD system (Caddy) and Kohlhammer bidding software
Administering and configuring NT servers and clients
Training users on MS Office and architecture-specific software (CAD/AVA)
Technologies: C/C++, TCP/IP, Caddy, hardware and network expertise

Summary

Over the last 34 years, I have gained professional experience in developing database applications and their Windows GUIs. From analysis through design to implementation, I have been involved in all phases of various projects.

My main focus is on application and database development with Delphi 5 through Delphi 10.4, working with MS SQL Server, Oracle, Firebird / InterBase, MySQL, and IBM iSeries V5R4.

Strong skills in database design as well as PL/SQL and T-SQL round off my abilities.

I also have experience with .NET and Java (Eclipse).