Senior BI & Data Warehouse Consultant | SSIS • SSAS •SSRS• Power BI • SQL Server Expert

5/2015 – 5/2018

• Business Intelligence Environment Development and Support
• Consistent support and collaboration in the ongoing development of the Business Intelligence (BI) environment.
• Responsible for database design, including ETL (Extract, Transform, Load) processes using MS SSIS.
• Developed and optimized reporting systems and dashboards for high usability using MS SSRS and other tools.
• Dashboard and Report Creation
• Creation of dashboards and reports tailored for ease of use, ensuring high levels of user-friendliness and accessibility.
• Leveraged MS SSRS and Excel for developing dynamic, interactive reports.
• Monitoring and Optimization of Group-Wide DWH/BI Operations
• Ensured the smooth operation of the company's Data Warehouse (DWH) and BI systems.
• Regular monitoring and optimization of MS SQL Server environments to improve performance and data processing.
• Cross-Departmental Collaboration
• Cooperative work with various departments, particularly with the controlling department, to ensure accurate and timely reporting.
• Collaborated on developing solutions that met cross-departmental needs and business requirements.
• Special Projects Development
• Lead development for special projects such as the Budget Tool project.
• Utilized C# .NET, VBA, and Powershell to create custom solutions and tools for specific business needs.
• ETL Process and Database Design
• Worked on ETL processes to integrate data from various sources into the BI environment.
• Designed and optimized databases using MS SQL Server to ensure effective data storage and retrieval.
• Technologies Used:
• MS SQL Server: Used for database management and optimization.
• MS SSIS (SQL Server Integration Services): Used for data extraction, transformation, and loading (ETL).
• MS SSAS (SQL Server Analysis Services): Utilized for data analysis and reporting.
• MS SSRS (SQL Server Reporting Services): Used for report generation and management.
• C# .NET: Applied for custom development and integration.
• VBA: Used for automating Excel processes and creating user-friendly interfaces.
• Powershell: Utilized for scripting and automation of administrative tasks.
• Excel: Used for report creation and data analysis.

Business Intelligence (BI), Data Warehousing, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), Datenmodelierung, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL-Server (MS SQL), ETL-Entwickler, Reporting Analyst

1/2012 – 12/2012

1. Requirements Analysis for Reporting Systems
o Conducted workshops and interviews with business departments to gather requirements for requested reports.
o Analyzed existing data sources and defined data models to support customized reporting needs.
2. Development of a Reporting Data Foundation
o Built a centralized data foundation (data mart) to provide relevant and structured information for business analysis.
o Implemented ETL processes using MS SQL Server Integration Services (SSIS) to prepare and integrate data.
3. Reporting and Analysis
o Supported analytical evaluations through the use of MS SQL Server Analysis Services (SSAS).
4. Data Quality Improvement Measures
o Identified and corrected data inconsistencies in the central partner management system.
o Designed and implemented data quality assurance processes, including automated checks within the ETL workflows.
5. Optimization of Central Partner Management
o Contributed to the improvement of data structure and data maintenance in the central partner database.
o Developed tools and reports to monitor and ensure high levels of data quality.
________________________________________
Technologies Used:
• MS SQL Server
• SSIS (SQL Server Integration Services)
• SSAS (SQL Server Analysis Services)

Business Intelligence (BI), Data Warehousing, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS)

7/2011 – 4/2015

1. Requirements Analysis and Planning
• Conducted detailed requirements analysis to understand business needs and translate them into technical specifications.
• Planned the architecture and structure for the systems and tools to be developed.
2. Reengineering of Media Data Capture System
• Led the reengineering of the media data capture system to improve efficiency and data quality.
• Ensured the system's scalability and ability to integrate with various data sources.
3. • Development of Media Data ETL Tool
• Developed an ETL (Extract, Transform, Load) tool specifically for media data.
• Ensured seamless data extraction, transformation, and loading into the target system, enabling accurate and timely reporting.
4. • Creation of Action Calendar Tool
• Designed and developed an Action Calendar tool to track and manage media-related actions and events.
• Integrated the calendar with other tools to provide a comprehensive view of ongoing activities.
5. • Development of Activity Overview Tool
• Created an Activity Overview tool to give users a comprehensive overview of media activities.
• Enabled users to manage and track media campaigns, tasks, and deadlines more effectively.
6. • Database and System Integration
• Worked with Oracle PL/SQL, Postgres, and MS Access to ensure smooth integration of databases and systems.
• Optimized database queries and structures for better performance.
7. • Automation and Reporting Tools
• Utilized Excel, VBS (Visual Basic Script), and VBA (Visual Basic for Applications) to automate reporting processes and integrate with other tools.
• Enhanced data reporting capabilities by automating routine tasks and enabling users to interact with reports more easily.
8. • Technologies Used:
• Oracle PL/SQL: For database management and development of complex queries and procedures.
• Postgres: Utilized for handling media-related data storage and processing.
• MS Access: Used for small-scale database management and integration with other tools.
• Excel: Leveraged for reporting, data analysis, and tool integration.
• VBS: Applied for scripting and automating processes within the system.
• VBA: Used for automating tasks and enhancing the functionality of Excel-based tools.

Microsoft Access, Microsoft Excel, Oracle Database, PL/SQL Entwickler, VBA (Visual Basic for Applications), Vbscript

6/2010 – 3/2011

Requirements analysis, planning, and development to support the further development of the ALM Analysis System,
maintenance and enhancement of the reporting framework.
Technologies: Oracle, Microsoft SSAS, MS Access/VBA ,Excel VBA

Business Intelligence (BI), Microsoft SQL Server Analysis Services (SSAS), Reporting, Microsoft Access, Microsoft SQL-Server (MS SQL), PL/SQL Entwickler, VBA (Visual Basic for Applications), Microsoft Excel, Application lifecycle management (ALM)

1/2006 – 12/2006

This project, developed as part of my Bachelor's thesis, aimed to design and develop a fuel stock management system to efficiently track, control, and optimize fuel inventory. The goal was to streamline the management of fuel stock transactions (entries and withdrawals) while providing accurate reports and alerts for better decision-making.
Project Phases:
1. Requirements Analysis:
o Conducted a thorough analysis to gather user requirements, identifying essential features like stock level tracking, critical threshold alerts, and automatic reporting.
2. Database Design (SQL Server):
o Developed a relational database using SQL Server to store and manage data on fuel transactions (entries, withdrawals, stock levels, etc.).
o Implemented stored procedures and triggers to automate tasks such as stock updates and critical stock alerts.
3. User Interface Development (MS Access + VBA):
o Built a user-friendly interface in MS Access for data entry and report generation.
o Utilized VBA (Visual Basic for Applications) to automate key tasks, such as updating stock levels and generating reports.
4. Key Features:
o Stock Tracking: Real-time recording of fuel entries and withdrawals.
o Automatic Alerts: Notifications when fuel stock reaches critical levels.
o Reporting: Generation of detailed reports on fuel consumption and stock levels.
o Transaction History: Archiving all fuel transactions for auditing and review.
5. Testing & Validation:
o Performed comprehensive testing to ensure the system’s reliability, performance, and alignment with user requirements.
Technologies Used:
• SQL Server: Backend database for managing data.
• MS Access: Front-end user interface for fuel stock management.
• VBA (Visual Basic for Applications): Automation of key tasks such as stock updates and report generation.
Expected Outcomes:
• Optimized fuel stock management with real-time tracking and automated alerts.
• Reduced manual errors through system automation.
• Enhanced decision-making with detailed reports and comprehensive transaction history.
• Increased operational efficiency via automated processes.

Datenanalyse, Reporting, Datenmodelierung, Microsoft Access, Microsoft SQL-Server (MS SQL), VBA (Visual Basic for Applications)