You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Sönke SchäferSS

Sönke Schäfer

Data Architect

€960/day
Lübeck, DE
15+ years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Sönke

Ten years of Excel. Fifteen years of databases. A SQL Server that "runs".

And every month the same question: Why don't the numbers add up?

If you know this, you're in the right place.

I am Sönke Schäfer – the data shepherd.

For over 25 years, I've been bringing order to the engine room of medium-sized IT.

My approach in three words: Structure before AI.

🐑 STRUCTURE

Clean data, clear processes. Every tool fails without a foundation.

🐑 SYSTEM

Pragmatic extension instead of expensive replacement. Access and SQL Server around your legacy systems, not instead of them.

🐑 SPEED

From a few days to the first productive evaluation.

No ERP migration projects lasting two years.

Specifically, this means:

→ Consolidating data from multiple legacy systems into a central DWH

→ Evaluations that your standard ERP reporting doesn't provide

→ Access forms for special processes that the ERP handles too clumsily

→ Bridges to the outside: Webshop, WordPress, Power Platform, APIs

→ Writing synchronization between systems that officially don't talk to each other

Local AI on your own data is part of it when the topic fits – not as an end in itself.

My clients: Managing directors in medium-sized businesses in Schleswig-Holstein and Northern Germany who want to keep their ERP and build around it – quickly, pragmatically, without large projects.

If you have an ERP change offer and are looking for a second opinion:

→ Write me a message

→ Or book an initial consultation: sesoft de
  • German

    Native or bilingual

  • English

    Conversational

Can work on-site
Lübeck (up to 50km)

Experience

  • SeSoft GmbH Web/Database/Solutions
    MD | Data Architect | Data Shepherd 🐑 | Structure before AI | SQL Server • Access • VBA • ETL • DWH
    January 1999 - Today (27 years and 7 months)
    Sierksdorf, SH, Germany
    Data 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 / CDO
    January 2015 - January 2021 (6 years)
    22 Ahrensburg, Germany
    Strategic 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 / CDO
    January 2015 - January 2021 (6 years)
    22 Ahrensburg, Germany
    Company-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

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • MCSA: SQL Server 2012/2014
    MCSA: SQL Server 2012/2014
  • Exam
    Exam

Categories