Marcus K. - Senior Software Developer (APEX)

Go to Website

Berlin, Germany

Experience

May 2025 - Present

4 months

Senior Software Developer (APEX)

Pharmaceutical Industry

Further development and tuning of a mid-sized application for managing events and participants
Identifying bottlenecks
Adding missing foreign keys and indexes
Rewriting views and SQL queries in APEX
Report development with Jasper Reports
Mentoring other APEX developers

Jan 2021 - Aug 2024

3 years 8 months

Lead Software Developer (APEX)

Austrian Government Agency

Development of a very large application for online EU funding applications
Developing and presenting a prototype
Making application design decisions in cooperation with the REs
Developing supporting applications, e.g. for app configuration and managing application processes
Designing key parts of the application such as user flow, a dynamic menu specific to funding applications, configurable uploads, and generation of the funding application summary
Adjusting the app's CSS layout and introducing suitable classes for global formatting
Developing complex displays using views
Guiding APEX developers
Point of contact for the REs and the department for questions about the feasibility of requirements in APEX

Sep 2020 - Oct 2020

2 months

Consultant

Merck

Developing a prototype for a pharmacovigilance application in APEX 20.1 including database setup and APEX application in the Oracle Cloud
Alert inbound screen with faceted search and file upload for document attachments
Simple impact assessment workflow with signature section
Email sending
Dashboard and calendar
Two-hour presentation of the prototype and basic APEX architecture

Jan 2014 - Jan 2020

6 years 1 month

Switzerland

Senior Software Developer

Roche Basel

Documented DWH reports, including for health authorities
Implementing medical queries in DWH queries such as event searches with MedDRA terms and classification, unexpected events based on different labelings, SUSAR cases, SMQs, and algorithmic MedDRA queries
SQL tuning
Complex regex searches in case narratives
Application development with Oracle Application Express (APEX)
Validations, code reviews, tuning, documentation
GVP training (Good Pharmacovigilance Practices)
International project (project language English)

Jan 2012 - Dec 2013

2 years

Senior Software Developer, Tester

Siemens AG

Developing various test programs for the European Train Control System (ETCS)
Module, integration, and validation tests
Code reviews and specification reviews
International project (English and German)

Jun 2010 - Mar 2012

1 year 10 months

Switzerland

Senior Software Developer

Roche Basel

Collaborated on designing and implementing a new flat table data mart with Type II SCD
Validation documentation (UR, SDS)
Programming load runs and view layer generation
PL/SQL packages to support reporting
Migration of various reports and SQL tuning
Reports according to departmental requirements

Jan 2010 - Apr 2010

4 months

Senior Software Developer

Kassenärztliche Vereinigung

Development of an Oracle Application Express application to create review cohorts for practice comparisons in cost-effectiveness reviews
Authentication via MS Active Directory (LDAP), proxy user, session state protection, encryption
Generator for online help
SQL tuning
Set up database jobs to load required data from the physician directory
Input validation using Oracle regular expressions
Report development

Jul 2008 - Jun 2009

1 year

Senior Software Developer

T-Mobile

Technical design of data storage and processing for SMS and email dispatch and data warehouse export
Data model extension
Implementation of web services in C++ and PL/SQL
MFC GUI development
Technical documentation and operations manuals

Sep 2006 - Jul 2008

1 year 11 months

Software Developer

Boehringer Ingelheim

Creation of validation documentation including requirements and software design specifications, installation plans, and traceability matrix
Specification, development and documentation of a reporting application for legacy data using Oracle Application Express 3.0
Analysis of migration scripts and database-side analysis of migration errors
Development of distribution rules in PL/SQL and planning and execution of migration tests

Jun 2006 - Sep 2006

4 months

Switzerland

Software Developer

Imaging Solutions AG

Creation of UML class model
Implementation using in-house libraries, librsvg and Cairo plugin
Development of a Gnome Virtual File System module and porting existing libraries to Linux
Documentation with Doxygen

Apr 2005 - Jun 2006

1 year 3 months

Software Developer

Kassenärztliche Vereinigung

Development of the KVB doctor directory and various other applications
Report development

Mar 2002 - Sep 2002

7 months

Software Developer C++

Heidelberger Druckmaschinen AG

Concept, design and implementation of a CORBA subscription server (observer pattern)
Persistent storage management based on memory-mapped files
Development of multiple CORBA clients for testing and editing
Functional and load testing
Documentation

Jun 2001 - Jan 2002

8 months

Software Developer (Oracle)

Banken und Sparkassen

Takeover, customization and migration of an Oracle 7.3 batch application
Analysis and documentation of the job control of PL/SQL code and database objects
Cleanup and testing of the data model as well as ensuring interface consistency
Setup of multiple Oracle instances for development, test and production
Migration to Oracle 8.1.6 and support of the new production environment
Tuning measures (redo logs, indexes, RBO/CBO)
Support during the euro conversion