Tajammal Hussain
Data Engineer | Systems Analyst | Development Specialist · Derby, United Kingdom
https://github.com/TajammalHussain · https://www.linkedin.com/in/tajammal-hussain-233293ab/
Professional Profile
Data and Technology professional with four years of applied experience spanning data engineering, business analysis, automation, and full-stack systems development. Proven ability to design and build end-to-end data pipelines and ETL/ELT workflows, automate complex business processes, develop dashboards and reporting solutions, and deliver production-grade software across cloud and on-premises environments. Proficient in Python, PySpark, SQL Server, Databricks, Power BI, Azure, Go, PostgreSQL, and React, with hands-on delivery across sectors including construction, infrastructure, and the third sector. Equally comfortable translating ambiguous business requirements into technical solutions as building and deploying them.
Professional Experience
Data Engineer and Development Specialist
September 2023 – Present
Control Electrical Engineers Ltd, London
- Designed and built a suite of financial automation systems on Zoho Creator — covering supplier payment workflows, subcontractor payment certificates (with CIS/HMRC/BACS logic), and CIS payment sheets — eliminating a full administrative role and replacing manual approval chains with structured digital workflows including e-signature and multi-level authorisation.
- Built a full-stack Materials Requisition Portal using Go, PostgreSQL, React, JWT authentication, and Docker, deployed on Railway — replacing a manual spreadsheet process with a versioned, searchable product catalogue and a complete point-in-time requisition audit trail.
- Developed and deployed a Python web scraping pipeline (BeautifulSoup4, Selenium, Pandas) ingesting and normalising product and pricing data from 15+ MEP/construction supplier sources into a single SQL-backed catalogue, feeding Power BI reporting.
- Built HiredToolExpiryReminder — a Python/Task Scheduler automation system generating weekly admin summaries, individual reminder emails, and HTML table reports for tool hire expiry management across the business.
- Built CEE Tool Tracker Pro — a single-file HTML asset tracking application with QR-code-driven location and status updates, replacing a manual spreadsheet with a live, always-current equipment register.
- Developed and maintained Power BI dashboards consuming SQL Server data, surfacing material usage, cost patterns, and compliance status for operational and senior stakeholders.
- Designed SQL Server database structures underpinning multiple operational systems — applying normalisation, stored procedures, indexing, and performance tuning to support reliable, scalable data storage and retrieval.
- Produced clear technical documentation — data flow diagrams, field mappings, runbooks, and user guides — for all systems, supporting audit readiness and team knowledge continuity.
- Led UAT across multiple projects, coordinating business users and technical teams to validate system behaviour and data accuracy before go-live.
- Managed Agile delivery across concurrent projects — sprint planning, backlog refinement, and retrospectives — maintaining alignment between business priorities and technical delivery.
Data Engineer
April 2022 – July 2023
United Communities Network, Nottingham
- Designed and built ETL pipelines integrating datasets from finance, HR, and operations systems — using Python (Pandas, NumPy) and SQL to extract, clean, transform, and load data from disparate sources into a unified reporting layer, significantly improving insight accuracy and consistency across the organisation.
- Engineered automated data workflows that replaced recurring manual data-preparation tasks — scheduling extracts, applying transformation logic, and routing outputs to downstream consumers — reducing processing time and removing bottlenecks for analytical teams.
- Implemented data quality and validation frameworks using SQL and Python, embedding automated checks into pipeline execution to catch inconsistencies at source and prevent errors from reaching reporting outputs.
- Built interactive Power BI and Excel dashboards consuming pipeline outputs, enabling self-serve access to key performance data across finance, HR, and operations and reducing reliance on manual report generation.
- Worked with IT and departmental leads to identify data integration requirements, map existing data flows, and design pipeline solutions that improved the speed and reliability of data available for decision-making.
Data Engineer (Internship)
June 2017 – June 2018
Prime Minister's Youth Skill Development Programme (PMYSDP), Pakistan
- Designed and implemented automated SQL-based data pipelines to replace 12 manual processes over six months — standardising data flows across student and management systems, improving data integrity, and contributing to a 25% increase in overall system efficiency.
- Led the migration of 8 college data workflows to cloud platforms over four months, re-engineering on-premises processes for cloud delivery and reducing system downtime by 30% while improving scalability to support over 2,000 active users.
- Built and maintained large-scale operational data repositories — digitising legacy records, restructuring data storage, and establishing access controls — improving data retrieval reliability by 20% across the institution.
- Collaborated with departmental leads to gather data requirements, map existing manual processes, and design pipeline solutions that transitioned the institution toward automated, SQL-driven data management.
Portfolio — tajammalhussain.co.uk
- Bronze to Silver to Gold pipeline (live): Scheduled ingestion of UK grid carbon intensity data through a three-layer medallion architecture, with data quality monitoring and a documented public REST API. Deployed and verifiable.
- Materials Requisition Portal: Go/PostgreSQL/React full-stack system with JWT auth, Docker deployment, versioned product catalogue, and full requisition audit trail.
- Supplier Data Pipeline: Python pipeline (Requests, BeautifulSoup, Selenium, Pandas) normalising data from 15+ sources into a single SQL-backed catalogue.
- Asset Tracking System: QR-code-driven Python/SQL Server pipeline replacing a manual spreadsheet with live equipment status and location data.
Education
MSc Software Engineering — Awarded with Commendation
2019 – 2021
University of Hertfordshire, UK
- Relevant modules: Distributed systems, database management, software architecture, secure computing, research methods.
- Projects: Emotion Detection system (R, MySQL); Timesaving Appointment platform (PHP, MySQL, cPanel); Green IT / Sustainable Computing research.
BSc Computer Science — CGPA 3.5/4.0
2011 – 2016
University of Azad Jammu and Kashmir, Pakistan
- Relevant modules: Data structures and algorithms, database systems, networking, operating systems, software engineering.
- Projects: Transport Tracking System (Java, GPS, MySQL, Apache Tomcat); Commercial Database Development; Integrated Enterprise Management System.
Technical Skills
- Languages:
- Python (Pandas, NumPy, Requests, BeautifulSoup4, Selenium, Scikit-learn, SciPy), PySpark (DataFrames, Spark SQL), SQL (T-SQL), R (ggplot2, dplyr), Go, Bash, VBA, JavaScript, PHP
- Data Engineering:
- ETL/ELT pipeline design and delivery, Data quality and validation frameworks, Pipeline monitoring and alerting, REST/SOAP APIs, JSON, XML, CSV, Bronze/silver/gold medallion architecture, Databricks and PySpark for distributed data processing
- Databases:
- Microsoft SQL Server (stored procedures, indexing, performance tuning, backup/recovery), PostgreSQL, MySQL, SQLite, Schema design, normalisation, data integrity
- Cloud & Azure:
- Databricks (notebooks, Delta Lake), Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure Functions, Logic Apps, AWS, Cloudflare Workers, Railway
- BI & Visualisation:
- Power BI (DAX, Power Query), Tableau, Matplotlib, Excel (advanced), Google Sheets, R Markdown
- Full-Stack Dev:
- Go (REST APIs, backend), React, Next.js, PostgreSQL, JWT, Docker, HTML/CSS, Zoho Creator (Deluge scripting), cPanel web hosting
- Automation:
- Power Automate, Python scripting automation, Zoho workflows, SMTP alerting, Task Scheduler, Event-driven and scheduled pipeline execution
- BA & Delivery:
- Requirements elicitation and documentation, Process mapping, Stakeholder facilitation, UAT coordination, Agile/Scrum, SDLC, Technical documentation and runbooks
- Dev Tools:
- Git, Visual Studio, Docker, CI/CD awareness, Zoho CRM
Professional Certifications
- Power BI Desktop for Business Intelligence — Udemy
- Google Data Analytics Professional Certificate — Google (Foundations, Data Preparation, Processing, Analysis, Visualisation)
- Business Analysis & Process Management
- Data Analysis with R Programming
- Python Essentials — Cisco
- Learning Excel Data Analysis
- Google SEO Fundamentals — UC Davis (Coursera)
- Attention to Detail — TestGorilla (96th percentile)
- Data-Driven Decision Making — TestGorilla (100th percentile)
- Advanced Excel — TestGorilla (97th percentile)
- NoSQL Databases — TestGorilla (98th percentile)
- Statistics & Probability — TestGorilla (100th percentile)
Additional Information
- Full UK driving licence held for over seven years, with own vehicle.
- Multilingual: English (professional), Urdu and Punjabi (native).
- Live project portfolio: tajammalhussain.co.uk — deployed pipelines, full-stack applications, and documented case studies.
References
Available upon request.