Download PDF

Michael Rorig

Business Intelligence Architect and Developer with 13+ years of work experience

Summary

I am an experienced BI Architect/BI Developer.

Additional roles I have worked on during my career are Data Architect, Data Analyst as well as Database Developer.
I have profound knowledge of the full MS BI stack (SSMS, SSIS, SSAS, SSRS) for SQL Server 2008R2 - SQL Server 2014.
Additionally, I offer expert knowledge in MS Excel and MS Access, including VBA coding.

My credo is, Business Intelligence should provide insight into company data, to enable the business to generate meaningful action to improve.

Work history

August 2017Present

Business Intelligence Manager (Customer Contact Center)

IKEA South East Asia, Petaling Jaya, Malaysia

Responsibilities:

  • Implementation of a reporting framework, to track Customer Contact Center performance, Quality Assurance for the whole South East Asia region
  • Building tools (interaction volume prediction, agent scheduling automation) to optimize agent utilization
  • Managing the Business Systems department, insuring system availability for operations and improving it's stability
  • Insure applications support business requirements and advised points of improvement
  • Close collaboration with country Managers for any adhoc data queries
December 2015July 2017

Business Intelligence Lead Developer

Pandora A/S, Hamburg, Germany

Responsibilities:

  • Data Analytics (Warehouse setup based on ABC analysis and demand forecast of items, productivity data mining model in SSAS)
  • Requirement gathering for new BI projects
  • Architecture and successful implementation of new distribution analysis cube (Dynamics AX, SSIS, SSAS)
  • Streamlining and optimization of existing IT processes, changing the development process to be based on agile methodology, using Team Foundation Server as Source repository and task management tool
  • Development of several QlikView dashboards
  • Implementation of several Excel applications to support operational business (Excel, VBA)
  • Performance tuning of existing database objects for OLTP as well as Data Warehouse (views, functions, stored procedures)
  • Supporting the business with any urgent Ad-Hoc requests
May 2011November 2015

Senior Business Intelligence Consultant

ERGON Datenprojekte GmbH (IT consulting company), Hamburg, Germany

Working in various projects for national and international companies, including Royal Dutch Shell, Delta Air Lines, Staples Inc., Otto Group, Axel Springer AG and RWE DEA.

Projects:

BI Architect/Developer for a German retail company
(location: Hamburg, Germany)

Responsibilities:

  • Acted as technical lead, overseeing the work of three developers
  • Translated business requirements into design specifications
  • Planning of ETL strategy and multidimensional data model for a new analytic cluster for web shop analysis purposes (SSIS, SSAS)
  • Developed multiple SSIS packages to extract data from various source systems (AS400, SAP, MS Excel and flat files), transform and load into the Data Warehouse to be used in Sales Analysis data mart
  • Applied calculated measures in MDX, based on business requirements, to existing cubes and new cubes (SSAS)
  • Design and implementation of incremental partition based loading and processing strategy for all production cubes, effectively cutting daily load times in half (VB.NET, SSIS)
  • Performance tuning of SSIS packages, as well a stored procedures and responsible for indexing strategy
  • Monitoring and troubleshooting of scheduled SQL Server Agent jobs for data loads and cube processing.
  • Added various SSRS reports based on user requirements, hooked to relational (Data Warehouse) and multidimensional data sources

Database Developer for an international airline
(locations: Hamburg, Germany and Philadelphia, Pennsylvania)

Responsibilities:

  • Development of ETL packages to move data from RightAngle into the data warehouse (SSIS)
  • Performance tuning of existing stored procedures (SQL Server 2012)
  • Design and implementation of reporting solution in SSRS for new mass balance analysis application

BI Developer for an international retail company
(locations: Hamburg, Germany)

Responsibilities:

  • Monitoring and troubleshooting of existing BI solution (SSIS, SSAS, SSRS)
  • Extended the existing multidimensional models in SSAS, the ETL packages in SSIS and the scheduled SQL Server Agent jobs running the SSIS packages and cube processing, based on additional business requirements
  • Performance optimization of existing SSIS packages

Data Architect/Analyst for a multinational oil and gas company
(location: Hamburg, Germany and Houston, Texas)

Responsibilities:

  • Data Architect and Analyst as part of a global development (Scrum methodology) team, with members in the US, the Netherlands, Belgium, India and Germany
  • Involved in requirement analysis and work segment prioritization in direct collaboration with the business (Team Foundation Server, SCRUM)
  • Created the logical data model in collaboration with the Solution Architect
  • Successfully designed and implemented the user self-import of monitoring plan data with T-SQL stored procedures, added integrity exception reporting in SSRS
  • Responsible for database performance tuning: indexing strategy, stored procedures, functions and views (SQL Server 2008R2)
  • Developed a data cleansing tool for Subject Matter Experts and Business Analysts with MS Access 2010 hooked to stored procedures in SQL Server 2008R2
  • Reporting solution implementation for internal project, as well as for application users in Excel (pivot, VBA) and SSRS.
  • Created SSIS packages to synchronize environments
  • Recommended for problem solving skills, out of the box thinking and exceptional customer orientated work ethic

BI Developer for a national food delivery company
(location: Hamburg, Germany)

Responsibilities:

  • Planned and implemented a data mining algorithm for daily Order forecast (SSAS)
  • Employed daily model training and forecasting with scheduled SSIS packages
  • Effectively improved forecasting accuracy by 50% compared to legacy methods
July 2006April 2011

Database Developer

GeoInformationsDienst GmbH (IT-service provider for agricultural enterprises), Göttingen, Germany

High level responsibilities:

  • Developed an interface for an agricultural software to file applications for EU subventions (MS Access, VBA, XML)
  • Architect and Developer of a CRM Software for soil sample laboratories (MS Access, VBA)
  • ETL Developer using PostgreSQL, MS Access and XML
  • Application and Database developer using MS Access and ESRI MapObjects
  • Database Architect PostgreSQL
  • Second level support
  • Reporting and Data Analytics expert
July 2003June 2006

Database Developer

Bunzendahl Software (IT-service provider for agricultural enterprises), Göttingen, Germany

High level responsibilities:

  • Data Architect PostgreSQL and MS Access
  • Application and Database developer using MS Access, PostgreSQL and ESRI MapObjects, developed several GIS applications using these tool
  • Reporting and Data Analytics expert
  • Second level support

Education

Aug 2000June 2003

Certified IT Specialist, Software Development

German Chamber of Industry and Commerce

Certified vocational education, one quarter school education and three quarter on the job training.
Employer: Bunzendahl-Software, School: BBS 2 Göttingen

Certifications

September 2016Present

Microsoft Certified Solutions Expert (MSCE)

Data Management and Analytics
October 2014Present

Microsoft Certified Solutions Expert (MCSE)

Business Intelligence
Nov 2012Present

Microsoft Certified Solutions Associate (MCSA)

SQL Server 2012
Nov 2012Present

Microsoft Certified Professional (MCP)

Sep 2011Present

Microsoft Certified Technology Specialist (MCTS)

SQL Server 2008, Database Development\Implementation and Maintenance, Database Development

Certifications

  • Microsoft Certified Solutions Expert: Data Management and Analytics
  • Microsoft Certified Solutions Expert: Business Intelligence
  • Microsoft Certified Solutions Associate: SQL Server 2012/2014
  • Microsoft Certified Professional
  • Microsoft Certified Technology Specialist: SQL Server 2008, Database Development, Implementation and Maintenance

Interests

Books, movies, tv series, fitness, my cat, keeping up-to-date with IT trends and news.

My first language is German, but my English is fluent in speech and writing