Sebastiaan Fransen

• Led the design and implementation of a new datamart for efficiency analysis within the Transaction Monitoring domain.
• Delivered scalable architecture using Databricks, DBT, Azure Analysis Services, and Power BI for robust reporting and analytics.
• Developed a custom Python-based migration tool to automate conversion of codebase from Synapse (T-SQL) to Spark SQL, including integrated unit testing, significantly reducing manual effort and errors.
• Collaborated across compliance, analytics, and IT to ensure alignment with strategic monitoring goals.

🛠 Tools & Technologies: Python, Databricks, DBT, Spark SQL, Azure Analysis Services, Power BI, T-SQL

• Spearheaded the implementation of critical risk models (AIRB and IFRS) for the Risk department, enhancing compliance and analytical capabilities.
• Designed and deployed multiple data marts, including one leveraging Azure Databricks, Data Lake Store, and Power BI, to optimize data accessibility and reporting.
• Engineered source system integrations for the enterprise data warehouse, streamlining ingestion pipelines and improving data reliability.
• Developed a scalable Azure-based framework for sourcing data to the data lake, enabling efficient onboarding of new data sources.
• Created a custom solution for data lineage visualization and impact analysis by extracting SQL code dependencies from execution plans and rendering them dynamically in Power BI.
• Technologies used: SQL Server, SSIS, SSRS, Power BI, Python, R, Visual Studio, VS Code, Git, Azure DevOps, PowerShell.

• Designed and implemented a custom data warehouse framework to enable seamless loading and maintenance of the central data warehouse and associated data marts.
• Delivered a dedicated finance data mart using SQL Server and SQL Server Analysis Services (SSAS) to support robust financial reporting and decision-making.
• Streamlined data ingestion and transformation processes, improving scalability and reducing development time for future BI enhancements.

🛠 Tools & Technologies: SQL Server, SSAS Multi dimensional, Power BI

• Designed and deployed a global reporting environment spanning ~30 countries and ~60 data sources, supporting both high-level international analytics and granular local insights.
• Engineered a unified data integration strategy centered on standardized product segmentation, enabling consistent reporting across diverse geographies and business units.
• Delivered a solution that consolidated fragmented data into a single source of truth, empowering strategic decision-making at all organizational levels.
• Ensured alignment in reporting methodology across markets to facilitate comparable KPIs and streamlined global operations.

🛠 Tools & Technologies: Oracle PL-SQL, Oracle OLAP, Scanmar MarketingTracker

• Designed and implemented a comprehensive data warehouse and data mart solution for a multi-country retail analytics initiative in the Middle East, spanning 6 countries.
• Led the integration of data from multiple supermarket chains, requiring the development of a centralized Master Data Management (MDM) framework for consistent product and store information.
• Delivered a scalable architecture to support cross-country reporting and analysis while maintaining flexibility for local operational nuances.
• Collaborated with stakeholders remotely and on-site in Dubai to ensure alignment with business requirements and technical feasibility.

🛠 Tools & Technologies: Oracle PL-SQL, Oracle OLAP, Scanmar MarketingTracker

• Contributed to the development and optimization of the enterprise data warehouse (DWH) to support scalable data infrastructure and analytics capabilities.
• Designed and implemented multiple data marts, including a solution for integrating market data from supermarket chains, enabling unified reporting across diverse product categories.
• Developed a specialized promotion analysis data mart to evaluate the effectiveness of promotions, integrating internal warehouse data with external third-party market data.
• Ensured consistent product segmentation and reporting standards across retail partners, supporting both strategic planning and operational analysis.

🛠 Tools & Technologies: Oracle PL-SQL, Oracle OLAP, Scanmar MarketingTracker