Frank Speelmans - Software and Database Developer

Recommended expert

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 compatible.
Maintaining and enhancing the in-house shipping software until it is replaced by a newly purchased 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, XE2, Oracle 11, DevExpress, SVN, TOAD for Oracle, Delphi 5, Developer Express, Devart ODAC.

Apr 2019 - Jun 2019

3 months

Dietzenbach, Germany

Software and Database Developer

Dimetis GmbH

Migrating the existing BOM application from Delphi 7 to Delphi 10.3.
Reworking the messaging system.
Implementing customer-specific GUI adjustments based on the requirements catalog.
Implementing billing routines on Oracle 11 with PL/SQL.
Adapting existing and creating new packages.
Technologies: Delphi 7, 10.3 Rio, Oracle 11, DevExpress, Git, TOAD for Oracle, Delphi 5, Developer Express, Devart ODAC.

Dec 2018 - Jun 2019

7 months

Sprockhövel, Germany

Software and Database Developer

B-Solution AG

Developing project-specific extensions based on the existing framework in Delphi 5 with SQL Server.

Nov 2017 - Oct 2018

1 year

Friedrichshafen, Germany

Software and Database Developer

Aberle GmbH

Developing project-specific extensions based on the existing framework.
Creating a WMS service (Warehouse Management System) 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

RZF

Further development and revision of existing tax software for external tax auditors.
Object-oriented rework of the legacy program.
Improving maintainability and migrating from a file system to the MariaDB server database.
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

Developing a host switch using Delphi 10 Seattle together with Spring4D, Delphi Mocks, and DUnitX.
The program connects a host application with a web application via COM.
Automatically launching Internet Explorer on address changes or screen calls in the host, passing a call string.
Displaying data in the corresponding screens and returning control to the host after IE is closed.
Technologies: Delphi 10 Seattle, Perforce, Spring4D, Mocks.

Jul 2015 - Feb 2016

8 months

Hamburg, Germany

Software Developer

Olympus Surgical Technologies Europe

Extending a DICOM interface with the DICOM Storage Commitment function for a new software release of the in-house product ENDOBASE.
Creating the associated documentation according to IEC 62304 standards.
Expanding the SQL Server database with the necessary attributes and functions.
Technologies: Delphi 7, MS-SQL Server 2008/2012, Perforce.

Mar 2014 - Dec 2014

10 months

Kaiserslautern, Germany

Software Developer

VWD Group

Developing a transaction interface in Delphi 2007.
Enhancing a SWIFT interface with various message types.
Importing data via the Portfolio Sync Interface into the portfolio manager for reports and analysis.
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

Developing process control software for packaging machines using Delphi with SQL Server 2008.
Commissioning on-site at the customer's facility in Italy.
Adjusting existing database structures and creating tables, attributes, and SQL queries.
Technologies: MS-SQL Server 2008, FastReport 4.

Mar 2012 - Present

13 years 11 months

Münster, Germany

Software and Database Developer

BabyOne GmbH

Development of an in-house Delphi application from Delphi 2010 to Delphi 10.4.
Billing of payment and direct debit notifications between branches and suppliers.
Creating the GUI and related reports with FastReport 4.
Implementing performance-intensive billing routines directly on the database.
Switching the software to test-driven development with DUnitX.
Designing the database model, implementing business logic via stored procedures, optimizing queries and indexes.
Creating events (cron jobs) to control and automate processes.
Technologies: Delphi 2010, MySQL 5.5, SVN, Toad for MySQL, DBForge Studio for MySQL, Developer Express, Devart MySQL data access components, FastReport 4-6, TDD, DUnitX.

Nov 2011 - Mar 2012

5 months

Bergisch Gladbach, Germany

Software and Database Developer

Mika Timing GmbH

Assisted in further developing the SportsPro program using Delphi 6 with Oracle 9i.
Created new GUI features in a 3-tier architecture.
Developed and extended stored procedures and adjusted related tables and attributes.
Corrected and optimized existing SQL statements and 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 entire software package in SVN by Delphi versions.
Created a new setup routine.
Analyzed all program modules and assigned new build versions.
Fixed urgent software bugs and created updates.
Documented the new structure in detail and trained a new team member.
Technologies: Delphi 3, 6 and 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 the MatrixRevolution software with Delphi 7, MySQL 5.0 and iSeries V5R4.
Developed and maintained Java stored procedures on iSeries V5R4 and managed the databases.
Synchronized data from the MySQL database system to the iSeries system for a web-based frontend.
Created reports with Report Builder 10.
Migrated the software from Delphi 7 to Delphi XE and supported the redevelopment in the HKM2010 project.
Migrated the iSeries database to Oracle 10g, including database design and PL/SQL stored procedures.
Programmed Oracle DB accesses to the host system's web services.
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

Further developed the Windows software AmpliLink with Delphi 2006 in the PCR field.
Designed an XML interface for order, sample and raw data information, including XSD schemas.
Created new GUI features and fixed bugs at the GUI and business logic level.
Wrote new unit tests and revised existing test cases.
Adapted and extended the existing Firebird database, including query optimization.
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

Created a new backend for in-house customer data processing.
Developed an application framework to provide programs, screens, and batch jobs via interfaces.
Implemented a rights management system based on the MS SQL Server structure.
Built a multithreading module for periodic parallel data transfer via DCOM.
Redesigned the data model and ported from SQL Server 2000 to 2005.
Developed submission and reporting routines at the database level.
Performed stress tests on the SQL Server to identify bottlenecks.
Modeled the database structure and stored procedures, and documented processes in UML.
Technologies: Delphi 2005, MS SQL Server 2000 / 2005, SQL, CVS, ModelMaker 8, Visio, UML, threading, SQL Server Business Intelligence Dev. Studio, TOAD for SQL Server, ADO.

Sep 2004 - Nov 2005

1 year 3 months

Cologne, Germany

Software Developer, Quality Assurance

Solvatis GmbH

Extended the EasyLog software package for Deutsche Post DHL with the EuroPlus shipping process.
Used interface programming and created DLLs.
Modeled processes for technical documentation.
Migrated the project from Delphi 5 to Delphi 2005, including upgrading components to VCL.
Updated the software package to a Windows XP design.
Technologies: Delphi 5, Delphi 2005, Sybase 8, Sybase 9, SQL, CVS, XML, Elips bug tracker, 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

Developed a client/server database application for mail-order sales to correctional facilities.
Managed master data (prisons, inmate accounts, products, storage locations) and handled documents with barcode control.
Created forms such as invoices, labels, and inventory lists.
Implemented data backup and printer assignment with tray control.
Technologies: Delphi 7, Firebird 1.5, SQL, Developer Express, SQLDirect, Fast Report, ReportBuilder.

Feb 2004 - May 2004

4 months

Neuwied, Germany

Software and Database Developer

Vario Software GmbH

Revised parts of an ERP system.
Implemented inventory posting for warehouse management.
Automated import of emails from Outlook into the database through address matching.
Integrated with AuctionWeb via WebServices and SOAP.
Technologies: Delphi 5, Interbase / Firebird, OLE / COM+ / DCOM.

Jan 2002 - Dec 2006

5 years

Leverkusen, Germany

Software and Database Developer

SCM-Tools

Implemented replication of address and contact data for a CRM project.
Defined replication rules for client access via ISDN or DSL.
Designed the replication concept at the database level and converted tables to use GUIDs.
Implemented the concept on both server and client sides.
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

Created a module for Intrastat declarations on diskette.
Developed it as a standalone module to ensure independent maintenance.
Technologies: Superbase 2001.

Mar 1999 - Aug 2003

4 years 6 months

Leichlingen, Germany

Software and Database Developer, Project Manager

European Consulting GmbH

Developed export software to map internal logistics processes including document capture and order picking.
Analyzed, designed, and implemented the database model and defined the metadata structure.
Planned and designed the Windows GUI and object model.
Set up and maintained the Windows network for 10 clients and 2 servers.
Technologies: Delphi 7, Oracle 8i/9i, client-server technologies, OOP, process analysis, Windows 2000 Server, Exchange Server, Developer Express, ODAC, MDAC, SQLDirect, FastReport, ReportBuilder.

Jan 1999 - Dec 2002

4 years

Leverkusen, Germany

Software Developer, Consultant

Logisco GmbH

Advised in the Intrastat shipping and export trade area.
Developed a visual frontend for printing shipping and export documents based on an ASCII interface.
Designed the database for the interface and implemented fill programs for around 15 forms.
Technologies: Superbase 2001.

Mar 1993 - Jul 1993

5 months

Cologne, Germany

Software Developer

Klöckner Humboldt Deutz

Modified an existing procurement database.
Analyzed the database and software, and adjusted the DBase databases.
Programmed the printer control for procurement forms.
Adapted the ASCII interface and adjusted the import routine in Excel.
Technologies: DBase, Clipper (DOS), VBA.

Jan 1992 - Dec 1999

8 years

Langenfeld, Germany

Software Developer, Project Manager

IFS Geimer + Partner GmbH

Implemented complex logistics processes based on standard software.
Carried out projects such as the DHL interface for ABS GmbH and packing line integration for Veit GmbH.
Implemented an SAP R/3 IDOC interface for Technocargo.
Connected a shipping solution with Oracle 7 backend to a Superbase 3.6i frontend for Klöckner.
Migrated data from ERP/PPS systems like Baan, PsiPenta, Brain, and SAP R/3.
Designed, installed, and provided on-site customer training.
Technologies: Superbase 2.x - 3.6i, Oracle 7, SQL, PL/SQL.

Jan 1991 - Dec 1995

5 years

Aachen, Germany

Consultant, Software Developer, System Administrator

Architectural Office Giessen

Advised on acquiring standard software and industry solutions.
Maintained and built the Windows network on Windows NT 4.0.
Created interfaces between the Caddy CAD system and the Kohlhammer tendering software.
Administered and configured NT servers and clients, and provided user training.
Technologies: C/C++, TCP/IP, Caddy, hardware and network skills.

Summary

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

My main focus is application and database development with Delphi 5 up to Delphi 10.4 in combination with MS SQL Server, Oracle, Firebird/Interbase, MySQL and IBM iSeries V5R4.

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

I also have knowledge in .NET and Java (Eclipse).

Skills

Practical Experience

Analyzing And Optimizing The Target Processes In Use At The Client
Structuring User Requirements And Their Feedback
Creating Requirements And Specifications Documents
Designing The Software Architecture And Selecting Tools
Planning And Conducting User Training
Support
Porting Components And Gui In Delphi

Strengths And Social Skills

Analyzing Complex Problems And Finding Solutions
Quick Comprehension
Strong Ability For Self-learning And Training
Team Player
Flexibility

Languages

Delphi 5 Up To Delphi 12.2
Spring4d, Mocks, Oop, Ooa, Tdd, Devexpress, Devart, Ado, Tms Aurelius, Fastreport, Design Patterns, Dunitx, Modelmaker, Modelmaker Code Explorer, Reportbuilder, Web Services (Soap), Xml, Threading
Visual Studio: .Net Framework, C#
Eclipse: Java, Android Sdk, Junit, Maven

Databases

Sql Server: T-sql, Toad For Sql Server, Sql Server Business Intelligence Dev Studio, Management Studio
Oracle: Pl/sql, Pl/sql Developer, Toad For Oracle
Interbase/firebird: Ibexpert
Mysql: Toad For Mysql, Dbforce Studio

Software / Tools