11/10/2026 updated

**** ******** ****
100 % available

Senior Analyst, Data Analyst, Data Engineer, Data Specialist

Kortrijk, Belgium
Worldwide
MBA
Kortrijk, Belgium
Worldwide
MBA

Profile attachments

Pratap_Resume.pdf

Microsoft AzureAzure SQLAzure Data FactoryMicrosoft FabricFreelancing
Core Technical Skills & Tools
My primary technical stack revolves around the Azure ecosystem. I build scalable, metadata-driven ETL pipelines using Azure Data Factory (ADF) for orchestration and secure ingestion into ADLS Gen2. For heavy data processing and transformation, I extensively use PySpark and Azure Databricks to manually code Data Vault models, enforce schema validation, and optimize Delta Lake performance. Recently, I have also modernized platforms by integrating Microsoft Fabric to evaluate OneLake capabilities. On the visualization side, I develop semantic data models and interactive dashboards using Power BI and DAX. To ensure secure, automated code deployments, I actively manage CI/CD release pipelines and Git version control using Azure DevOps.

Methodologies
I operate strictly within Agile and Scrum frameworks, managing development lifecycles via Jira and Confluence. From an architectural standpoint, I am highly proficient in native Data Vault 2.0 methodologies—specifically building Hubs, Links, and append-only Satellites using cryptographic hashing—as well as Medallion Architecture and Kimball's dimensional modeling.

Professional Experience Highlights
Most recently, operating as an independent Data Engineering sub-contractor, I engineered parameterized ADF pipelines to extract daily sales data from REST APIs, utilizing PySpark to cleanse and load the data into structured SQL databases while implementing source-to-target reconciliation checks. Prior to this, as an Azure Data Engineer at Softech Management BV, I transitioned legacy financial records into a scalable Data Vault structure with complete historical auditability to meet strict regulatory compliance.

During my tenure at Barco, I orchestrated automated workflows to ingest global CRM metrics, mapping complex B2B entities into scalable Hub and Link structures while optimizing large sales datasets in Delta Lake through strategic partitioning. Previously, as a Freelance Azure Data Engineer for major clients like Toyota Motor Europe and KBC Bank, I deployed interconnected Data Vault tables to track slow-changing dimensions and preserve state changes in highly sensitive financial records, fulfilling European banking compliance mandates. Across all my projects, I have consistently collaborated with business stakeholders to translate raw pipelines into actionable Power BI datasets that empower end-users with self-service analytics.

Experience

Professional experience5 - 10 years
Freelancer since2021

Languages

EnglishFluentDutchBasic knowledge

Project history

Data Analyst

Softech Management BV, Belgium
  • Built and deployed Azure Data Factory pipelines integrating data from Blob Storage and SQL-based sources, enabling automated refresh cycles and reporting.
  • Developed Power BI dashboards for Sales and Finance, and collaborated on HR-related KPIs like headcount movement and training metrics.
  • Developed SQL-based data models and stored procedures to support ad-hoc requests and improve metric accuracy across teams.
  • Created parameterized, reusable pipelines in ADF with basic error handling and linked service configurations.
  • Collaborated with business stakeholders to gather data requirements, prioritize reporting enhancements, and deliver meaningful KPIs.
  • Ensured data quality and auditability through structured ETL processes using MS SQL Server, ADF, and versioned deployment practices

Business Analyst

Barco
  • Designed and developed dynamic Power BI dashboards for Sales and Finance teams, improving visibility into KPIs and operational metrics.
  • Partnered with business stakeholders to define KPIs across HR and operational metrics, improving visibility into retention and workforce trends.
  • Used Power Query to clean, reshape, and combine multiple datasets, reducing manual data prep and improving accuracy.
  • Conducted reporting workshops and coached business users on Power BI adoption and self-service analytics best practices.
  • Led the creation of reusable Power BI reporting templates, ensuring consistency across business units.
  • Supported Power BI deployment in Azure workspace, enabling version control and secure, centralized access for global users.

Freelance Data Analyst

Toyota Motor Europe
  • Built and optimized enterprise-level ETL pipelines using SSIS, enabling seamless integration of cross-functional business data across Finance, Logistics, and Sales.
  • Led the transition of legacy BI workflows towards Azure, contributing to the setup of Azure Synapse Analytics, Azure Data Lake Gen2, and Azure SQL for central reporting.
  • Developed impactful Power BI dashboards connected to Azure SQL, improving decision-making and KPI visibility across departments.
  • Collaborated with business units to design scalable, cloud-ready data models, aligned with reporting and governance requirements.
  • Assisted in onboarding technical teams to early-stage Azure data components and documented cloud migration procedures.
  • Ensured high data quality and auditability through structured SSIS jobs and best practices in data validation, cleansing, and transformation.

Freelance Data Analyst

KBC Bank
  • Performed end-to-end data validation and cleansing across structured finance datasets to ensure reporting accuracy and regulatory compliance.
  • Developed Power BI dashboards that enabled real-time visibility into financial KPIs, used by senior decision-makers.
  • Contributed to building data ingestion pipelines using Azure Data Factory, integrating core banking data into cloud-based reporting environments.
  • Participated in monitoring and maintaining Azure DevOps pipelines for version control and deployment of reporting assets.
  • Collaborated with business analysts and IT teams to scope BI initiatives and align data models with compliance goals.
  • Supported testing and documentation of cloud ETL workflows, combining ADF, Azure SQL, and Power BI for scalable delivery.

Data Engineer

Sunday Natural Products GmbH
  • Partnered with cross-functional teams to resolve technical data challenges, improving data infrastructure capabilities and supporting seamless analytics workflows.
  • Designed advanced data tools and solutions, enhancing analytics capabilities and driving product innovation, contributing to a 15% increase in operational efficiency.
  • Developed and optimized robust ETL pipelines using SSIS, streamlining data integration processes and reducing processing times while ensuring data quality and auditability.

Business Intelligence Analyst

Bank of Scotland
* Partner with key stakeholders to pinpoint reporting requirements and deliver cutting-edge
Business Intelligence (BI) solutions.
* Conduct thorough impact analyses on source system modifications and evolving regulatory
reporting frameworks, assessing their influence on the data warehouse.
* Strategically define and scope BI initiatives, aligning them with stakeholder priorities for optimal
project sequencing.
* Translate complex reporting demands into actionable functional and technical specifications,
overseeing their management from inception to completion.

Business Analyst

Noesys Software
* Streamlined Agile workflows through effective collaboration with development and QA teams.

* Pinpointed and resolved process bottlenecks, enhancing operational efficiency.
* Bridged communication between tech teams, customers, and SMEs to define precise
requirements and user expectations.

Senior Process Executive (Business Intelligence/Data Analysis)

Cognizant Technology Solutions
* Leveraged Business Intelligence Reporting Tools to devise strategic KPIs and Scorecards,
enhancing corporate profitability metrics.
* Executed comprehensive data extraction, modeling, and analysis to construct insightful reports
for business and operational units.

* Crafted innovative and interactive data visualizations, empowering stakeholders to make
informed, Maintain and Interpret data-driven decisions while ensuring utmost data integrity
and reliability.

Certificates

Advanced Certification in Data Science and AI

IIT Madras

2023

Master of Business Administration (MBA)

GEMS B School

2013


Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in