Professional Summary
Junior SQL Developer with a background in business operations and formal training in business information technology. Skilled in relational database design, query tuning, and ETL pipeline implementation using Microsoft SQL Server and PostgreSQL.
Demonstrates a methodical approach to data integrity, reporting automation, and cross-functional collaboration within Swiss enterprise environments.
Professional Experience
AareLogix AG
Bern, Switzerland
Junior SQL Developer
Sept 2024 – Present
- Write and optimize complex T-SQL queries, views, and stored procedures to support internal dispatching and inventory tracking systems.
- Design and maintain ETL workflows in SSIS to ingest daily shipment feeds from external logistics partners into Microsoft SQL Server.
- Perform query tuning and index defragmentation, cutting average runtime on critical dispatch reports by 35 percent.
- Collaborate with application developers to define relational data models, constraints, and audit tables for new fleet management features.
Helva Logistics Solutions GmbH
Bern, Switzerland
Database & Reporting Intern
Sept 2023 – Aug 2024
- Constructed relational reporting tables and extraction scripts in PostgreSQL for daily logistics accounting reconciliations.
- Automated recurring billing exports using SQL scripts and Excel macros, eliminating 6 hours of manual spreadsheet reconciliation weekly.
- Assisted senior system administrators with database backup verification and sandbox test environment setup.
Bubenberg Treuhand Partner
Bern, Switzerland
Commercial Operations Assistant
Aug 2015 – Jul 2021
- Maintained client accounts and financial records using enterprise ERP software and structured ledger exports.
- Compiled monthly financial overviews and variance reports for medium-sized Swiss retail and trade clients.
- Validated data consistency across legacy accounting databases during a company-wide software migration.
Education
Bern University of Applied Sciences
Bachelor of Science · Business Information Technology · Bern, Switzerland · 5.4 / 6.0 · Sept 2021 – Aug 2024
Coursework emphasized relational database design, data warehousing architectures, enterprise systems, and business process modeling.
Completed a bachelor thesis project creating automated SQL transformation pipelines for localized operational reporting.
WKS KV Bildung Bern
Federal VET Diploma (EFZ) · Commerce and Office Administration · Bern, Switzerland · 5.2 / 6.0 · Aug 2012 – Jul 2015
Completed dual vocational education and training in business administration, managing billing workflows and operational accounting records.
Technical Projects
Clinical Resource Management Database
Feb 2024 – Jun 2024
- Designed a normalized PostgreSQL database schema with 18 tables to model patient appointments, medical staff shifts, and inventory.
- Authored stored functions and triggers to enforce business constraints and prevent double-booking across shared consultation rooms.
- Drafted documentation and comprehensive query execution plans comparing indexing strategies on multi-million row test datasets.
Skills
SQL
T-SQL
PostgreSQL
Microsoft SQL Server
SSIS
Query Optimization
Database Design
Stored Procedures
Data Modeling
ETL Pipelines
Languages
German
C2
English
C1
French
B2
Certifications
Microsoft Certified: Azure Data Fundamentals
Microsoft · Apr 2025
Oracle Database SQL Certified Associate
Oracle University · Nov 2024
Volunteering
Digital Competence Bern
Bern, Switzerland · Oct 2023 – May 2024
- Volunteer Database Tutor
- Instructed adult learners in basic SQL querying, relational tables, and spreadsheet data extraction techniques.