About Sönke
German
Native or bilingual
English
Conversational
Experience
- SeSoft GmbH Web/Database/SolutionsMD | Data Architect | Data Shepherd 🐑 | Structure before AI | SQL Server • Access • VBA • ETL • DWHJanuary 1999 - Today (27 years and 7 months)Sierksdorf, SH, GermanyData architecture, process digitalization, and IT consulting for small and medium-sized enterprises. Accompanied over 30 clients in industry, trade, associations, and services since 1999.Current and selected projects:- Federal Association: XRechnung/ZUGFeRD implementation for automated invoicing + extension of an existing Access/SQL Server solution, continuously developed since 1999- Ship Supplier: Menu planning and goods ordering app for ship's cooks with offline operation + connection to MS Navision and Business Central via Azure SQL and Power Platform- Real Estate Fund: Backend for multi-client fund management and balance sheet forecasting models + SQL Server, Power Platform, Azure Dataverse- Wholesale Timber Company: Development of a central data warehouse with automated ETL processes from the ERP + individual key performance indicator system for management (since 2022)- Window Manufacturer: Data warehouse, ETL from ERP, reporting for management, change and release processes for data quality- Manufacturing Company: DWH, forecasting, drill-down analyses, time tracking system, and control of series production (since 2019)- Health Insurance Company (BKK): New creation of databases for all claims departments (300 users), ETL data import, controlling provision- Law Firm: Word automation and case management with Access/SQL Server (since 2003)Technologies: SQL Server (T-SQL, SSIS, SSAS, SSRS), Microsoft Access, VBA, Power Platform (Power BI, Power Automate, Power Apps), Azure SQL, Dataverse, Python, WordPress, Oracle PL/SQL, PostgreSQL, MySQL, PHP, WordPress
- ESYLUX GmbH,Head of Data Management → Head of IT / CDOJanuary 2015 - January 2021 (6 years)22 Ahrensburg, GermanyStrategic and operational IT management. Infrastructure migration, DWH expansion (SSIS/SSAS/SSRS), ERP integration, insourcing of critical applications.
- ESYLUX,Head of Data Management, later Head of IT / CDOJanuary 2015 - January 2021 (6 years)22 Ahrensburg, GermanyCompany-wide key performance indicator system, DWH with SSIS/SSAS/SSRS. Infrastructure migration, ERP data migration (odoo).Access VBA, SQL Server, SSIS/SSAS/SSRS Agile project management (10 employees). Windows Phone App + ASP.NET API for business process mapping. ASP.NET, Access VBA, SQL Server Rapid Word automation and case management. Access frontend with SQL Server backend. Long-term support and further development. Access VBA, Word VBA, SQL Server Inventory management for approx. 20,000 shipments/month. Webshop and bank interfaces, Outlook import, dunning. Access VBA, Outlook VBA, SQL Server New development of several specialized databases (300 users): Sickness benefits, DRG, nursing care, dental prosthetics, etc. ETL import, controlling provision, load optimization. Access VBA, SQL Server, ASP Membership management, statistics, revenue distribution, intranet/extranet (ASP). Long-term support. Access VBA, SQL Server, ASP
Recommendations
Be the first to recommend Sönke
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- MCSA: SQL Server 2012/2014MCSA: SQL Server 2012/2014
- ExamExam