You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Mike GölzMG

Mike Gölz

IT Consultant: Excel, VBA, Access, SQL & AI

€1,000/day
Mannheim, DE
15+ years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Mike

I'm Mike, with over 15 years in IT: starting in support, through ITSM administration, to Data Engineering at BGHW in Mannheim. Since early 2026, I've been doing this independently as MikeIT.dev.

My specialty is systems that have grown over years and that hardly anyone understands anymore. The Excel file with 50 sheets and cryptic macros. The Access database from 2009 that only runs on a single computer. The report that costs three hours of manual work every month. That's exactly where I come in: first understand, then clean up, then automate. Refactor instead of Rebuild, because that's usually cheaper and less risky than a complete new development.

Specifically, I help with:
- Excel/VBA and Access: Untangling macros, stabilizing databases, backend migrations to SQL Server
- Reporting with Power Query and Power BI: Manual click-athons become reproducible pipelines
- Python and SQL when Excel reaches its limits
- Local, GDPR-compliant AI integration (Ollama, RAG), pragmatic instead of hype
- Internal business tools and data pipelines

In addition, I bring experience from over 15 years of IT infrastructure: Active Directory, IAM, Citrix, ITSM. And because I enjoy programming myself, I also develop my own apps and small software tools on the side.

Part of my work also includes training and workshops on Excel, VBA, SQL, Power Query, Reporting, and AI. For me, a good handover is part of the delivery, not just an additional service.

Honestly: When it comes to data, automation, or an IT problem that has been lingering for years, I can almost certainly help, even if it's not exactly on my skill list. I prefer to get back with an honest assessment than with empty promises.
  • German

    Native or bilingual

  • English

    Fluent

Can work on-site
Mannheim (up to 50km)

Experience

  • MikeIT.dev
    Freelance IT, Data, and AI Consultant
    DIGITAL AND IT
    January 2026 - Today (6 months)
    Mannheim, Germany
    Development of individual data analysis, reporting, and automation solutions. Consulting on databases, business intelligence, and process optimization. Automation of business processes with Python, VBA, and SQL. Development of AI-powered applications and workflows. Refactoring and stabilization of legacy Excel, VBA, and Access systems for SMEs.
    VBA Python SQL Access Microsoft Power BI
  • BGHW
    Data Engineer / DevOps
    PUBLIC SECTOR
    April 2024 - April 2026 (2 years)
    Mannheim, Germany
    Operation and further development of ITSM and data warehouse systems. Conception and implementation of ETL processes for data integration and transformation. Development of complex SQL analyses and data-based evaluations for business units. Ensuring data quality, data consistency, and data integrity. Automation of data processes with Python, VBA, and shell scripting. Creation and optimization of BI reports with Power BI and Cognos. Management of database systems such as MySQL, PostgreSQL, and DB2.
    SQL Microsoft Power BI VBA Python MySQL
  • BGHW
    ITSM Administrator
    PUBLIC SECTOR
    October 2022 - March 2024 (1 year and 5 months)
    Mannheim, Germany
    Administration and further development of an IT Service Management system. Ensuring data quality and consistent data storage. Creation of reports and KPI analyses. SQL-based database management and maintenance. Automation of routine processes with Excel, VBA, and Office automation.
    SQL VBA ITSM Microsoft Power BI Access

Recommendations

Be the first to recommend Mike

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

  • IT Specialist Application Development (IHK)
    Biotopia gGmbH, Mannheim
    2011
    Ausbildung zum Fachinformatiker Anwendungsentwicklung. Abschlussprojekt: Entwicklung und Integration einer Web-Datenbankanwendung mit PHP, CSS, MySQL und JavaScript. Schwerpunkte: IT-Systemintegration, Netzwerkmanagement, Support sowie mobile Entwicklung mit C# und Java.

Skill set

Categories