Frank Speelmans - Software and Database Developer
Experience
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.
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.
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.
Software and Database Developer
B-Solution AG
- Developing project-specific extensions based on the existing framework in Delphi 5 with SQL Server.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Transportation, Information Technology, Retail, Professional Services, Banking and Finance, and Construction.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Product Development, Project Management, Logistics, Supply Chain Management, and Quality Assurance.
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
- Version Control: Freevcs, Cvs, Perforce, Subversion, Vss
- Office Products: Visio, Word, Outlook
- Installers: Installshield Express, Wise Installation Expert
- Virtualization: Vmware
- Xml Tools: Altova Xmlspy And Schemaagent, Oxygen Xml Editor
- Others: Rational Clearquest, Requisitepro, Jira
Database Experience
- Designing Database Models And Queries
- Enhancing And Optimizing Existing Databases And Applications
- Developing And Implementing Custom Database Solutions
- Analyzing And Optimizing Business Processes In Stored Procedures
- Identifying And Fixing Errors In Data Processing
- Sql Profiling, Query Optimization And Index Optimization
Languages
Education
CDI
Technical IT Specialist
Certifications & licenses
§ 70-461 Querying Microsoft SQL Server
§ 70-462 Administering Microsoft SQL Databases
§ ITIL Foundation
§ PRINCE 2 Foundation
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Frank based?
What languages does Frank speak?
How many years of experience does Frank have?
What roles would Frank be best suited for?
What is Frank's latest experience?
What companies has Frank worked for in recent years?
Which industries is Frank most experienced in?
Which business areas is Frank most experienced in?
Which industries has Frank worked in recently?
Which business areas has Frank worked in recently?
What is Frank's education?
Does Frank have any certificates?
What is the availability of Frank?
What is the rate of Frank?
How to hire Frank?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
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 Software and Database Developer
Nearby freelancers
Professionals working in or nearby Grafschaft, Germany