Muhammad Ehtisham Ul Hassan

Muhammad Ehtisham Ul Hassan

Data Engineer
United Kingdom
Urdu, English

About Me

A strategic and results-driven Data Engineer with expertise in developing modern cloud-based data solutions. Skilled in designing scalable data architectures, including unified storage systems, semantic models and dimens…

Experience

Database Assistant

Pickthall IT consulting, Bradford UK · Bradford, UK
Apr 2024 - Jan 2025 · 8 months

Analysed sensitive data across 600+ tables for GDPR compliance and metadata consistency., Implemented data masking and RBAC and created metadata lineage for regulatory tracking., Applied DevOps practices to automate deployment and monitoring of compliance-related data workflows., Collaborated on data governance initiatives involving Azure Purview and Snowflake sharing principles., Designed innovative solutions for automating compliance checks across big data environments.

SQL Developer

Brainiacs Co · Gujrat, Pakistan
Apr 2018 - Dec 2022 · 4 years 8 months

Developed scalable ETL pipelines using Python and SSIS for seamless data integration into SQL databases.Created and deployed data workflows via SSDT, managing multiple SSIS domains with scheduled automation.Designed 20+ SSRS and Power BI Report Server (PBRS) environments for enterprise applications.Built dashboards and paginated reports using Power BI and SSRS, enhancing decision-making capabilities.Complex T-SQL quires for data extraction, transformation, and feature engineering across large datasets.Automated data collection and transformation using Power Query, Python, and Google Apps Script.Integrated CI/CD pipelines using GitHub to streamline data processes and support reliable deployments.Collaborated with stakeholders and cross-functional teams to aligned with business goals.

Administrator

School Education Department · Gujrat, Pakistan
Apr 2012 - Apr 2018 · 6 years

Integrated data flow across 345 institutions using spreadsheet analytics and automated consolidation routines.Managed payroll and budget using Excel and automated reporting with VBA and Google Apps Script.Handled complex data analysis with pivot tables, macros, formulas and automation Scripting.Helped boost student attendance from 60% to 85% by applying actionable outcome insights.Identified 20,000 bogus student’s records to support expenditure regularisation.Trained end users to adopt the newly developed system through in-person sessions and documentation

SQL Developer / Data Pipeline Engineer

Brainiacs Co, Gujrat

Developed scalable ETL pipelines using Python and SSIS for seamless data integration into SQL databases.
Created and deployed data workflows via SSDT, managing multiple SSIS domains with scheduled automation.
Designed 20+ SSRS and Power BI Report Server (PBRS) environments for enterprise applications.
Built dashboards and paginated reports using Power BI and SSRS, enhancing decision-making capabilities.
Created complex T-SQL queries for data extraction, transformation, and feature engineering across large datasets.
Automated data collection and transformation using Power Query, Python, and Google Apps Script.
Collaborated with stakeholders and cross-functional teams to aligned with business goals.
Integrated CI/CD pipelines using GitHub to streamline data processes and support reliable deployments.

Data Analyst / Administrator

Govt. of Punjab, Gujrat

Integrated data flow across 345 institutions using spreadsheet analytics and automated consolidation routines.
Managed payroll and budget using Excel and automated reporting with VBA and Google Apps Script.
Handled complex data analysis with pivot tables, macros, formulas and automation scripting.
Helped boost student attendance from 60% to 85% by applying actionable outcome insights.
Trained end users to adopt the newly developed system through in-person sessions and documentation.
Identified 20,000 bogus student’s records to support expenditure regularisation.

PROJECTS

NSN Component Database

US Based Company
Duration : 01-Jun-2020 - 31-Aug-2020

Designed and deployed data warehouse using Snowflake schema for managing 5.6M NSN components.Built ingestion pipelines using python for mining, cleaning, and integrating metadata into the data warehouse.Improved searchability and analytics with structured queries and optimized schema for fast access.Developed complex model queries, views, functions, and stored procedures to streamline processes for cross-functional teams.

Skills

Big Data ETL Data Integration and Transformation (ETL) Python Reporting Structured Query Language (SQL) Problem Solving Data Analysis Communication Data Architecture Data Modeling Excel VBA Microsoft Azure MS Excel Scala Spark SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) T-SQL NoSQL Relational Databases Scalability Terraform Data Analytics KQL Delta Tables Delta Lake DAX CI/CD Predictive Analytics ML algorithms Azure Cognitive Services Azure Data Factory Synapse Analytics Data Lake Snowflake Databricks Real-Time Stream Analytics Power BI Event House Data Masking Metadata Lineage GDPR Compliance Azure Purview SSAS PBRS Database Design Schema Optimization Data Cleaning Lakehouse Architecture Pandas NumPy Selenium C# Google Apps Script Microsoft Excel VLOOKUP INDEX/MATCH Pivot Tables Macro Recording VBA Microsoft Access Power Pivot Client-Focused Reporting Stakeholder Communication Team Collaboration
Report this Profile?