Chandu H

Results-driven Data Engineer and BI Analyst with 6+ years of commercial experience architecting and implementing scalable data pipelines, ETL workflows, and business intelligence solutions. Proven track record across Azure Data Factory (ADF), Azure Databricks, Synapse Analytics, Power BI, and SQL-based data warehousing. Consistently delivers projects on time with high data integrity, enabling real-time, data-driven decisions for business stakeholders.

Azure Data Engineer - Innovic solutions ltd - UK

(2025-08 - 2026-03)

• Developed and published Power BI dashboards and interactive reports, enabling real-time, data-driven business decisions across multiple business units.
• Built and maintained high-complexity SQL queries and stored procedures in Azure SQL and MySQL for large-scale data extraction, transformation, and analysis.
• Automated data validation processes using Python and Azure, improving data accuracy by eliminating manual quality checks.
• Implemented Python ETL scripts integrated with Azure Databricks and Azure Data Factory (ADF) to ingest data from CRM platforms, cloud storage, and relational databases.
• Developed high-performance Power BI data models with complex DAX calculations, improving dashboard responsiveness and report performance.
• Integrated third-party and CRM data sources with Azure SQL and Power BI, enhancing customer data accuracy and reporting reliability.
• Designed and implemented database schemas, indexing strategies, and Azure Data Lake Storage (ADLS) solutions for scalable, fast-access architecture.
• Implemented metadata management and role-based access control (RBAC) using Unity Catalog to ensure compliant and secure data access.
• Enhanced ETL pipeline monitoring and alerting to maintain continuous, uninterrupted data processing and reporting.

Data Engineer - Hapag-Lloyd

(2022-07 - 2024-06)

• Designed and built complex ETL pipelines using Azure Synapse Analytics and Azure Data Factory (ADF) with mapping data flows, schema modifier transformations, and row modifier transformations.
• Orchestrated end-to-end data pipelines using ADF Medallion Architecture to ingest raw data from multiple sources into the bronze layer of Azure Data Lake Storage Gen2 (ADLS Gen2).
• Worked across Azure IaaS and PaaS services including Key Vault, Logic Apps, and Azure Functions for pipeline automation, networking, and security.
• Established CI/CD pipelines within Azure workspaces, improving deployment automation and release consistency.
• Implemented version control using Git, ensuring meticulous code management and fostering collaboration across development teams.
• Applied data lineage, data catalogues, and validation checks in SQL, ADF, and Synapse to ensure data quality for downstream reporting and analytics.
• Connected Power BI reports to Delta Lake for real-time streaming, improving data accessibility and report performance.
• Developed and published Power BI dashboards available via Power Platform Service and Mobile App, supporting business stakeholders at all levels.

BI & Analytics Engineer - Westpac Banking Corporation, Flipkart

(2021-03 - 2022-06)

• Designed and implemented data pipelines using Azure Synapse Analytics, Azure Data Factory (ADF), and Spark SQL to automate data ingestion and processing.
• Conducted data modeling and transformation on raw data from Azure Delta Lake into structured datasets using SSIS, ADF, and SQL.
• Built and maintained data models including data tables, relationships, and data dictionaries, enabling business trend analysis.
• Developed advanced Power BI reports with DAX-based calculated columns, measures, and row-level security (RLS) for non-technical stakeholders.
• Migrated existing Tableau reports and dashboards to Power BI, ensuring seamless transition and improved functionality.
• Optimised DAX formula performance using DAX Studio, applying best practices to reduce query execution times.
• Collaborated with cross-functional teams to gather requirements and design BI and ETL solutions tailored to specific business needs.

Data Analyst - AXA XL, Blue Dart

(2020-04 - 2021-02)

• Gathered and documented DWH, Data Engineering, and Business Intelligence requirements from stakeholders, ensuring alignment with strategic objectives.
• Built dynamic Azure Data Factory (ADF) pipelines using Watermark Tables, parameters, and variables to process multiple data tables and files within a single pipeline.
• Designed SSIS packages with robust error handling and event handling mechanisms for efficient ETL processes.
• Designed Tableau reports using table calculations, Level of Detail (LOD) functions, filter parameters, and actions.
• Created complex, self-service Power BI and SSRS reports with advanced chart types for business analysis.
• Wrote custom T-SQL statements including triggers, stored procedures, views, indexes, and user-defined functions.
• Developed reusable SSIS templates dynamically deployable across Dev, Test, and Production environments.

Business Intelligence Developer - HDFC Bank, MetroHealth

(2019-02 - 2020-03)

• Designed and developed end-to-end SSIS ETL packages for data extraction and transformation across multiple source systems.
• Created SSRS metadata reports including execution time and failure reports to support operational monitoring.
• Improved SSRS and Excel report performance by tuning stored procedures and T-SQL queries.
• Designed Data Marts and multi-dimensional models using Star and Snowflake schemas, implementing Slowly Changing Dimensions (SCD Type 2 and Type 3).
• Conducted backend database development in SQL using complex queries and stored procedures.
• Published dashboards and reports on Tableau Server for interactive data visualisation.
• Developed Dimensional Data Models to identify Facts and Dimensions and build fact and dimension tables.

Master's - International Business Management - Northumbria University (2025) London, United Kingdom

Bachelor's - Computer Science Engineering - Jawaharlal Nehru Technological University (2017) Kakinada, India