The following sections provide information on selected projects I have been involved with over the last years, both as self-employed IT consultant and as an employee. For improved readability on mobile devices and for printing you can download the profile as a document:

Download Consultant Profile Matthias Böge – PDF

Consulting Projects
Project: Data Lineage of SAS Production System;
Migrate a historic system to Production
Client: Banking and financial services company
Frankfurt / Main, Germany (2018/01 – 2018/11)
Position: SAS & Perl developer, IT consultant
Duties: – Analysis and data extraction from SCAPROC log files
– migration of historic system into DW landscape
Technology: SAS (Base, Macro), Perl, UNIX
Project: Maintenance of Code Generator for Regulatory Reporting
Client: Banking and financial services company
Frankfurt / Main, Germany (2018/01 – 2018/11)
Position: SAS & Perl developer, IT consultant
Duties: Redesign of code generator
– translate Excel specification to SAS code
– accomodate for latest changes
– new functionality
– increased report complexity
Technology: SAS (Base, Macro), Perl, Windows, UNIX
Project: Implementation of AnaCredit Reporting for German Bundesbank / European Central Bank
Client: Banking and financial services company
Frankfurt / Main, Germany (2016/10 – 2017/12)
Position: SAS developer, IT consultant
Duties: Technical implementation of AnaCredit framework
– Design and implementation of technical solution
– Creation of reporting tables based on prepared data mart
Technology: SAS (Base, Macro), UNIX
Project: Code Refactoring and System Performance Tuning
Client: Banking and financial services company
Frankfurt / Main, Germany (2015/10 – 2016/09)
Position: SAS & Perl developer, IT consultant
Duties: Software quality assurance
– Standardization of code
– Modularization
– Code and execution optimization
– Streamlining of execution processes
Technology: SAS (Base, Macro), Perl, UNIX
Project: Generative Programming for Regulatory Reporting / COREP
Client: Banking and financial services company
Frankfurt / Main, Germany (2014/01 – 2015/09)
Position: SAS developer, IT consultant
Duties: Technical implementation of COREP framework
– Analysis, design and implementation of technical solution
– Implementation of compiler to translate Excel-based specification from business unit into SAS
– Code generated: more than 1m lines of optimized SAS code
Technology: SAS (Base, Macro), Perl, UNIX
Project: Financial Data Warehouse
Client: Banking and financial services company
Frankfurt / Main, Germany (2012/05 – 2013/12)
Position: SAS developer, IT consultant
Duties: Planning and implementation
– Analysis, design and implementation of ETL processes
– Development of simulation models
– Standardization of developer tests
– Development of basic code generator for translation of regulatory requirements into SAS code
Technology: SAS (Base, Macro), Perl, UNIX
Project: Continuous Enhancements
Client: Banking and financial services company
Frankfurt / Main, Germany (2011/01 – 2012/04)
Position: SAS and Perl developer, IT consultant
Duties: Planning and implementation
– Implementation of simulation models
– Standardization of test environments
Technology: SAS (Base, Macro), Perl, Linux, Oracle
Project: Global Credit Risk Reporting
Client: Banking and financial services company
Frankfurt am Main, Germany (2007/06 – 2010/12)
Position: SAS developer, IT consultant
Duties: Planning and implementation
– ETL to process raw data into Oracle using SAS (txt/csv, XML, SFTP, …)
– Basel II regulatory reporting (1st pillar / technical / XML & XBRL)
– German Bundesbank feedback processing (XML)
– Management of meta data
– Development of Unix shell scripts
– Version control using CVS
– On-Call support on 24×7 shift
Technology: SAS (Base, Macro), Solaris, Oracle
Project: Introduction of Release und Project Management Practices
Client: EOS KSI Inkasso Deutschland GmbH
Bad Rappenau, Germany (2007/08)
Position: Management Consultant for Company Board
Duties: Improve software development processes within the company
– Support introduction of release and project management
– Area: internal IT developing the company’s client-facing B2B debt collection solution
Technology: SAP, MS Project 2007, Visio 2007
Project Work as Employee

Employed at SAS Institute GmbH, EMEA HQ, Germany

Project: Customer Relationship Management Suite / Data Warehouse
Duration: 24 months, 19 people across 6 countries
Position: Project manager, ETL developer
Duties: Adaption and deployment of a CRM solution across the company
– Lead the web development and the ETL development teams
– Coordinate business experts and other SMEs
– Integration with existing business critical systems and the enterprise data warehouse
– Standardization of business processes
– Development and execution of test plans incl. user acceptance tests
Technology: SAS (Base, SCL, htmSQL, broker), JSP, Apache, Tomcat, Linux
Project: SAS Message Queue System
Duration: 8 months, 3 people
Position: Project manager, SAS developer
Duties: Development of a Message Queue Systems
– Automatic synchronization and replication of distributed SAS instances
– System bridge from/to Oracle using IBM MQ Series communication
Technology: SAS (Base, AF/SCL), Java Message Service
Project: Events Management System for User Conferences
Duration: 2 phases over 12 months period, 7 people
Position: Project manager, business analyst, ETL developer
Duties: Paper stream und meeting management for user conferences
– Lead the web development team
– Coordinate business specials and other SMEs
– Define and control implementation of web-based solution
– Develop solution for scheduling conflict management
– Develop interfaces to feeding systems
Technology: SAS, MySQL, JSP / Struts, Linux
Project: Skills & Competencies Management System
Duration: multiple phases over 12 months, 3 people
Position: Project manager, business analyst
Duties: Implementation of a global skills and competencies system
– Areas: consulting, education and technical support teams
– Goal: identification of team members for international projects (“ideal fit” management)
– Lead the web development team
– Develop interface to other global systems in the company
Technology: SAS, MySQL, JSP / Struts, HPUX
Project: Corporate Address System
Duration: 10 months, 2 people
Position: Project manager, designer, developer (data quality web reports)
Duties: Develop customer and master file data system
– Lead development team
– Plan and execute release management
– Coordinate usage by internal third party systems
– Develop web reports to analyze & improve data quality
Technology: SAS (Base, Macro, AF/SCL, htmSQL, Broker, DQ/Cleanse), Unix Shell Script, HPUX
Project: IT Project Management Framework
Duration: 4 months
Position: Manager, developer
Duties: Develop a project management framework
– Define, implement, support and rollout
– Goal: Standardization of internal IT project management (international)
– Based upon PMI PMBOK (R) Guide
– Adapt to corporate culture
– Implement first version of a PMO project management office
Technology: HTML, Windows