Michael T.-MS Fabric Data Engineer

As an Interim Business Intelligence Specialist at Coulisse, I led a crucial project focused on migrating QlikSense reports to PowerBI. This role required a comprehensive approach to ensure that the transition not only met technical needs but also aligned with business objectives and stakeholder expectations.

Key Responsibilities and Achievements:

• Project Leadership: Spearheaded the migration project, coordinating between C-level executives, senior key users, and IT to ensure seamless communication and project success.
• Business Requirements Gathering: Conducted thorough analysis and collection of business requirements, ensuring that only necessary reports were migrated to PowerBI, thereby optimizing resources and enhancing efficiency.
• Report and Dashboard Redesign: Identified the need for redesigning reports and dashboards to better address the evolving questions and needs of the business, leading to more insightful and actionable data analysis.
• Data Model Implementation: Recognized the initial lack of a proper data model and took the initiative to design and implement a robust data backend using Microsoft Fabric, laying a strong foundation for future BI activities.
• Technical Expertise: Applied my extensive technical knowledge in BI tools, particularly PowerBI and Microsoft Fabric, to manage and troubleshoot complex issues, ensuring the project's smooth execution and ongoing support.

This experience not only honed my technical skills in data modeling and BI tool migration but also enhanced my ability to operate effectively across various levels of an organization, driving strategic initiatives to successful completion.

I played a pivotal role in establishing PostgreSQL-based analytical databases at Scharenborg Groep. My responsibilities spanned database setup, foreign data wrapper integration for external sources, and collaboration with a Python scripting team for seamless data insertion.

Key achievements include:

• Data Warehouse Layer Establishment: Took full ownership of designing and implementing the Data Warehouse layer within PostgreSQL. This provided a structured foundation for analytics.
• Star Schema Design and (multi) Datamart Development (Kimball): Led the design of star schemas and tailored datamarts by collaborating closely with business stakeholders, ensuring relevance and usability for insightful analytics and reporting.
• PowerBI Integration and Gateway Management: Managed the PowerBI gateway and orchestrated the integration with PostgreSQL databases. Personally developed impactful dashboards, facilitating data visualization and analysis while maintaining security standards.
• Cron Job Implementation and Dynamic SQL Functions: Implemented cron jobs for automation and architected dynamic SQL functions for efficient record management within the database.

Notable contributions:

• Solely designed and implemented the PostgreSQL-based Data Warehouse layer, providing a robust platform for data storage, retrieval, and analysis.
• Orchestrated PowerBI integration and dashboard development, empowering stakeholders with data visualizations.

My tenure was defined by a commitment to establishing a robust data infrastructure, fostering collaboration, and empowering stakeholders through data-driven insights.