Holger Klink
Data Migration Sage 100 to Odoo
Experience
Data Migration Sage 100 to Odoo
LRT Automotive
- SQL database development, design, and documentation of procedures, functions, and triggers
- Migration of data from Sage Line 100 database to Odoo
- Database design with MS-SQL Server and SQL (T-SQL)
- Use of Power Query and Excel
Application and database development
Aktive-Time
- Implementation of a general web API for various clients (WPF, ASP.Net Core app)
- Design and documentation of database and application architecture
- Technologies: C#.Net Core 8.0, SQL, Entity Core 9.0, LINQ, ASP.Net Core Web API (JSON), Docker, Serilog
ASP.Net application development
IF Blueprint AG
- ASP.Net application and database development
- Design and documentation of web APIs
- Bug fixing in C#, WPF, and unit tests
- Adjustments at ADO document level and VSTO add-ins
- Development of Office add-ins for Excel, Word, and SLV
- Technologies: C#, .Net Framework 4.8, VBA, Python, WPF, VSTO, Windows API, .Net Core, Excel-DNA, SQLite DB, Autofac, ClosedXML, Log4Net, COM interop, ActiveX, custom task pane, WCF, XAML
Application development
Alpine
- Implementation of a 64-bit legacy wrapper
- Implementation of EF Core (context manager, repository, SQLite DB)
- Bug fixing with debugging and testing in C#, WPF
- Implementation of an ASP.Net Core Web API for data exchange
- Technologies: C#.Net, SQL, Entity Core 2.2/3.1, LINQ, ASP.Net Core Web API (JSON), SQLite
Visual Studio application development
MDC Stuttgart
- Integration of .Net WinForms and WPF into Sage 100 GUI (MS Access)
- Project management, design, planning, and development
- Technologies: C#, Entity Framework, LINQ, Access VBA, WPF, WinForms, SQL
Application Development
MDC Stuttgart
- DRACOON cloud integration with Sage Line 100
- Project management, concept design, planning, and development
- Technologies: C#.Net, Sage add-in (Access, VBA), SQL, Entity Framework 6.2, LINQ, ADO
Application Development
MDC Stuttgart
- Revision and further development of the existing Sage Access add-in
- Project management, concept design, planning, and development
- Technologies: Access, VBA, ADO, SQL, Word, Outlook
Application Development
MDC Stuttgart
- Programming of the Sage task center
- Project management, concept design, planning, and development
- Technologies: C#, Entity Framework 6.2, LINQ, ADO.Net, SQL
Application Development
MDC Stuttgart
- Integration of Bonobo Git Server and DRACOON Cloud with JSON REST and version control
- Use of Thomson Reuters RFA API and OpenDacs
- Project management, concept design, planning, and development
- Technologies: IIS, Git
Application Development
MDC Stuttgart
- Creation of reports in SSMS (Reporting Services) and Excel
- Project management, concept design, planning, and development
- Technologies: VBA, SQL, ADO
Application development
1stVision
- Retrieval of currency, foreign exchange and precious metal rates via Reuters RFA API
- Development of Windows services for scheduled processing of export and import interfaces
- Technologies: C#.Net, SQL, XML
Application development
MDC Stuttgart
- Revision of auditor assignment and server certificate management in a Windows domain (AC)
- Creating new Word documents and coding text blocks
- Project management, concept, planning and development
- Technologies: MS-SQL Server, Sage Add-In (VBA), SQL
Application development
O & S EDV Weingarten
- Updating legacy systems
- Project management, concept, planning and development
- Technologies: VB.Net, Sage Add-In (VBA), SQL
Application development
MDC Stuttgart
- Development of an interface for data transfer to DADIS
- Project management, concept, planning and development
- Technologies: Core FTP, Sage Add-In (VBA), SQL
Application development
O & S EDV Weingarten
- Development of an interface from Sage Line (ERP, PPS) to Calitime (employee time tracking)
- Project management, concept, planning and development
- Technologies: VB.Net, Sage Add-In (VBA), SQL
Application development
O & S EDV Weingarten
- Customizations and updates of legacy systems
- Project management, concept, planning and development
- Technologies: VB.Net, Sage Add-In (VBA), SQL
Application development
O & S EDV Weingarten
- Updates of legacy systems
- Project management, concept, planning and development
- Technologies: VB.Net, Sage Add-In (VBA), SQL
Application development
O & S EDV Weingarten
- Development of SQL database triggers for table synchronization of different Sage databases
- Project management, concept, planning and development
- Technologies: SQL
Application development
Smeg Hausgeräte GmbH
- Development of a logistics interface between Sage OfficeLine and Rhenus
- Setup of a transfer database and a Windows service
- Implementation of an SFTP interface and MS SQL report server
- Technologies: VB.Net, Sage Add-In (VBA), SQL
Application development
SLS Kunststoffverarbeitungs GmbH & Co. KG
- Preliminary costing with quote creation for AktiveTime manufacturing
- Development of quantity-dependent quote creation based on a resource list
- Technologies: PowerBuilder application, VBA
Application Development
Smeg Hausgeräte GmbH
- Development of a purchase disposition in Excel with document workflow
- Project management, design, planning and development
- Technologies: VBA, SQL
Application Development
Smeg Hausgeräte GmbH
- Extension of the ServiceTool software to include a reminder system for technicians
- Project management, design, planning and development
- Technologies: Powerbuilder .Net Win Form Application
Database Development
SLS Kunststoffverarbeitungs GmbH & Co. KG
- Development and delivery of reports with MS-SQL Reporting Services
- Project management, design, planning and development
- Technologies: SQL (T-SQL), stored procedures and functions
Application Development
Smeg Hausgeräte GmbH
- Development of a logistics interface from Sage OfficeLine to COGLAS GmbH Logistic Solutions
- Project management, design, planning and development
- Technologies: Sage Add-In (VBA Access), SQL
Application Development
Smeg Hausgeräte GmbH
- Development of a .Net WCF service to connect the service software and web client
- Project management, design, planning and development
- Technologies: Powerbuilder .Net Winform Application, VB.Net WCF service, TAPI interface
Application Development
Smeg Hausgeräte GmbH
- Development of a service center web client for field staff
- Features for reports, customer lists, online orders and bonus calculation
- Technologies: Powerbuilder .Net Web Form Application
System Administrator
Smeg Hausgeräte GmbH
- Administration of servers, networks, devices and software
- Support of Windows Server domains (DNS, DHCP, AD), SQL Server, Exchange Server, ESXi Server
- Use of Symantec Backup Exec, time tracking systems and telephone systems
Application Development
Hadley Profiltechnik GmbH
- Customization of the AktiveTime manufacturing for coils in roll production
- Project management, concept, planning and development
- Technologies: Powerbuilder Application, Sage Add-In (VBA), VBA
Application Development
Aktive-Time Software
- Development of a PPS production management system as an add-in for Sage OfficeLine
- Project management, concept, planning and development
- Technologies: Powerbuilder Application, Sage Add-In (VBA), VBA
Summary
Creative professional with extensive project experience. My strengths include analytical thinking, creativity, perfectionism, passion, patience, and teamwork.
As a self-employed database and software developer, I have spent the last years designing and developing projects for mid-sized industrial companies, banks, government agencies, and automotive suppliers. My main areas include ERP systems (Sage 100), production planning (PPS), PowerBuilder applications, interfaces, as well as standalone solutions for government agencies.
Besides project work, I'm open to new challenges and can well imagine bringing my experience in a temporary assignment (ANÜ) or in a permanent position.
Skills
- Project Management And Consulting
- Legacy System Migration
- Digitization Of Government Authorities And Offices
- Analysis, Planning, Programming, Implementation, Documentation, And Training
Programming And Development
- Backend And Frontend Programming In C#/vb.net (Framework, Core), Vba (Winforms, Wpf, Wcf, Soap, Json/rest, Asp.net Web Service, Services, Interfaces)
- Database Programming (Ms-sql Server, Sqlite, Transact-sql)
- Erp Application Development, Especially Sage Line 100 (Officeline), In C#, Powerbuilder, Vb.net, And Access (Vba)
- Customizations In Sage Line 100 (Documents, Dcm, Add-in, App Designer, Task Center)
- Interface Programming For Logistics, Pps, Shop Floor Data Acquisition (Bde), Time Tracking, Cloud Integration
- Ms Office Programming (Vba, Vsto, Com Interop)
Programming Focus Areas
- C#
- Vb.net
- Vba
- Sql
- Ms Office
- Powerbuilder
Databases
- Ms-sql Server (Ssms, T-sql, Procedures, Functions, Triggers, Db Design, Reporting Services)
- Sqlite
- Sybase Ase
Frameworks And Technologies
- Entity Framework / Core
- Asp.net Web Api
- Linq
- Ado / Ado.net
- Winforms
- Wpf
- Wcf
Data Formats
- Xml
- Json
- Xaml
Tools
- Visual Studio
- Git
- Docker
- Jira
- Vs Code
Special Skills
- Thomson Reuters Api Rfa (Robust Foundation Api), Opendacs
- Dracoon Cloud (Json Rest, Swagger-codegen)
- Sage Task Center (Logisoft)
Administration
- Exchange
- Windows Domain (Ac), Networks
- Windows Server
- Ms-sql Server
- Vmware Esxi
- Hyper-v
- Linux Server
- Iis
- Core Ftp
Ms Office
- Word
- Excel
- Access
- Powerpoint
Languages
Education
Commercial School Donaueschingen
Secondary school leaving certificate · Secondary school leaving certificate · Donaueschingen, Germany
IT Consulting Weiss Schiltach
IT Specialist for Application Development · IT Specialist for Application Development · Schiltach, Germany
Similar Freelancers
Discover other experts with similar qualifications and experience