Daniel L. - SQL, .NET and VBA Developer

Go to Website

Horgen, Switzerland

Experience

Jul 2024 - Dec 2024

6 months

Bern, Switzerland

SQL, .NET and VBA Developer

Postfinance AG

For the internal MIS, which collects data in a complex, extensive system landscape and loads it into a central database via ETL, existing processes and packages had to be maintained and new KPIs analyzed, specified, and implemented.
The contract was not renewed due to general, short-term budget cuts despite proven high customer satisfaction.

Jan 2023 - Dec 2023

1 year

Zürich, Switzerland

Requirements Engineer and Business Analyst

Abraxas Informatik AG

Creating the big picture and organizing the thousands of artifacts produced
Creating a reliable action plan with prioritization
Evaluating an integrable DMS and estimating the effort to migrate over a thousand existing Word templates

Jan 2022 - Present

4 years

Database Specialist, Analyst, Programmer

Absolut Distribution (Huawei Enterprise Solutions)

Designing and developing an Access application for inventory management with order recommendations
Contract management with expiry date monitoring
Ticket system with reminder management and logging in Excel

Jan 2021 - Present

5 years

Database Specialist, Analyst, Programmer

ACE Security GmbH

Complete overhaul of a complex MS Access application
Extending integration with Google Maps
Adjustments to wages and GAV

Jan 2021 - Present

5 years

Database Specialist, Analyst, Programmer

AK-Soft GmbH

Taking over support and further developing an industry solution for carpentry companies

Jan 2020 - Present

6 years

Programmer

LNR Lorenz Nesensohn Rabanser Rechtsanwälte

Word VBA programming – ribbon with tools for formatting complex legal documents

Jan 2019 - Present

7 years

Zürich, Switzerland

Project Manager, Developer, Tester

Department of Justice and Home Affairs, Canton of Zurich

Gathering requirements from the general secretariat
Creating a study to collect data from the districts
Developing the solution with Excel, Access and SQL Server
Implementing and training the solution

Jan 2019 - Dec 2021

3 years

Developer, Tester

Utilis AG

Creating solution design for geometry database
Formulating requirements into epics and user stories
Developing the system with MS Access and SQL Server

Jan 2018 - Dec 2022

5 years

Winterthur, Switzerland

Database Specialist, Analyst

Rieter Spinnmaschinenfabrik in Winterthur

As-is inventory of a complex, 25-year-old CPQ system
Defining the target state for the requirements specification
Responsible for data migration
Implementing a calculation program for spinning data

Jan 2016 - Dec 2018

3 years

Zürich, Switzerland

Business Analyst, Developer

Road Traffic Office of the City of Zurich

Requirement analysis for importing police reports
Implementing a Word add-in with C#, WCF and XML

Jan 2013 - Dec 2014

2 years

Zürich, Switzerland

Project Manager, Analyst

Office of Correctional Services, Canton of Zurich

Leading the IT side of the project
Analyzing and specifying, design
Coordinating requirements between business and IT
Quality assurance

Jan 2012 - Present

14 years

Zürich, Switzerland

RE, Scrum Master, Developer, Tester

Department of Justice and Home Affairs, Canton of Zurich

Gathering requirements from the offices
Formulating requirements into epics and user stories
Scrum Master for one of the teams
Agile coach for the transition to agility
Test engineer for automated GUI tests
Designing and developing a Word add-in and WCF interface for full document generation from the main system

Jan 2012 - Dec 2012

1 year

Zürich, Switzerland

Project Manager, Analyst

GWP Insurance Broker

Leading the IT side of the project
Analyzing and specifying, design
Coordinating requirements between business and IT
Quality assurance

Jan 2010 - Present

16 years

Hong Kong

Business Analyst, RE, Consultant, Developer, Trainer

Cosmowatch (Asia Pacific) Ltd.

Analyzing and designing a decentralized ERP system
Developing the main system and subsystems
Project manager in collaboration with FHNW, Brugg (webshop)
Documenting and training employees
Support and maintenance

Jan 2010 - Present

16 years

Schlieren, Switzerland

RE, Developer, Consultant

Mercedes-Benz (Switzerland) AG

Coordinating with the Indian implementation partner
Creating an interface between SAP and the local system
Technology consulting
Developing small tools

Jan 2010 - Present

16 years

Schlieren, Switzerland

Supporter, Requirements Engineer, Consultant, Developer

Mercedes-Benz Financial Services AG

Maintenance of all custom MS Office applications
Analysis, design and development of new applications

Jan 2003 - Dec 2004

2 years

Zürich, Switzerland

Analyst, Programmer

Torocom AG

Gathering requirements for a real-time multitasking telephony server
Developing new software and database, reporting
Replacing the existing system

Jan 2003 - Dec 2003

1 year

Fribourg, Switzerland

Analyst, Programmer

Road Traffic Office of Canton Fribourg

Interface programming

Jan 2001 - Dec 2004

4 years

Analyst, Programmer

Yellow Access AG / Pay4Services AG

Sub-project management
Requirements analysis
Coordination with Swisscom, BAKOM and other stakeholders
Application and database design
Application development

Jan 1998 - Dec 2001

4 years

Analyst, Programmer

Systor AG / UBS

Requirements analysis and design of various projects
Development of various database projects (SQL, VBA)
Maintenance of an existing inventory program

Summary

I have been a self-employed IT specialist since 1991 and see myself as a reliable, motivated partner who can quickly and effectively dive into new topics.

I am open, diligent, and loyal.

I enjoy working in a team as well as on my own, depending on what the project requires.

Thanks to my long experience, I can be used in many different roles.