Prabhjot Singh| prabhs2000uk@gmail.
com | +44-7407394350 | Manchester, UK | LinkedIn
SUMMARY
Data Engineer with experience building scalable data pipelines, optimising reporting systems, and delivering actionable insights
using advanced data engineering tools and frameworks. Proficient in SQL, Python, and Snowflake, with hands-on experience in
ETL processes, data pipeline automation, architecture optimisation, and cloud-based analytics.
EDUCATION
The University of Manchester | M.Sc. Advanced Computer Science | 2023 – 2024
Relevant Modules: Data Engineering, Systems Governance, Cryptography
Guru Gobind Singh Indraprastha University | B.Tech. - Computer Science & Engineering | 2018 – 2022
Relevant Modules: Software Engineering, Algorithm Design, Database Management Systems
WORK EXPERIENCE
Business Technology Solutions Associate | ZS Associates Aug 2022 – Jun 2023
● Spearheaded development and operations for a $1MM data analytics product, designing pipelines, establishing ETL
processes and enhancing security through IAM and security management in Snowflake databases
● Acted as the head for resolution and management of all product issues, meeting SLAs with a 98% success rate, driving
client satisfaction
● Designed and developed a staffing management system using Python and Snowflake, enabling real-time tracking of
employee allocation across projects and improving headcount by up to 80% in understaffed projects
● Engineered a stencil framework using PySpark, SQL, Hive and HDFS to optimise pharmaceutical sales operations,
enabling faster development for future projects, and cutting delivery time by almost 70%
● Developed a next-best-action (NBA) model in Python for pharmaceutical sales, delivering predictive insights for
healthcare provider engagement
● Conducted user testing, in addition to analysing and reporting key performance metrics related to product performance
RESEARCH PROJECT
AI-Based Intrusion Detection Systems in Cloud Servers May 2024 – Sep 2024
● Developed a Machine Learning-based intrusion detection system (IDS) in Python to detect adversarial events in cloud
systems, based on the CIC IDS 2018 dataset, achieving 98%+ accuracy across multiple scenarios
● Integrated Explainable AI (XAI) techniques (SHAP, LIME) with the XGBoost ML Algorithm. to establish trust and
explainability for Cyber Security Professionals, facilitating transparency in decision-making
● Engineered a framework using Python to mitigate critical vulnerabilities in virtualised environments
SKILLS
Programming Languages: Python, C, C++, SQL, BASH, MATLAB
Data Engineering Tools: Apache Spark, PySpark, Snowflake, Apache Hive, HDFS, Airflow, Microstrategy, Power BI, Tableau
Specialised Skills: ETL Process Automation, Data Warehousing, RTDS, Data Governance
Cloud Technologies: AWS (S3, Lambda, Redshift, EMR, CloudWatch), Docker, GCP (BigQuery, Dataflow)
ML and AI: Predictive Modeling, Explainable AI, Gradient Boosting, XGBoost, SHAP, LIME, NumPy, Pandas, Scikit-learn
PROJECTS
Secure Architecture Design - Automated Offense Monitoring and Ticketing System Nov 2023 – Dec 2023
● Architected a multi-layered data processing system, integrating ANPR and speed camera data for real-time analytics.
● Designed middleware APIs for seamless database operations, ensuring secure access control and audit logging.
● Developed a Balanced Scorecard to measure data accuracy and system uptime, achieving 99.9% operational reliability.
● Deployed an ISO 27001-compliant infrastructure to safeguard sensitive data for an automated traffic ticketing system
involving multiple stakeholders, improving efficiency and resilience
PM School x Aegon - Product Design for Buying Insurance on WhatsApp (Finalist) Jan 2022 – Mar 2022
● Designed a seamless end-to-end user journey for insurance purchases entirely via WhatsApp, improving ease of use while
aiming for a theoretical user retention of 90%
● Engineered a data-driven approach to calculate TAM and target segments for an insurance chatbot on WhatsApp.
● Designed performance metrics to track conversion rates, user engagement, and journey efficiency. Designed the interface
using Figma and integrated with Setu API to deliver a fluid WhatsApp transaction experience. Received recognition for
an innovative approach and strategic product management acumen by the panel
Cloud Architecture Design - Stock Market Analysis with AWS Resource Optimization Dec 2021 – Mar 2022
● Engineered and deployed a scalable AWS-based Infrastructure and service for stock market analysis based on Python,
boosting server efficiency and delivering actionable insights through a Streamlit-powered interface
● Optimised resources with load balancers, security protocols, and CloudWatch monitoring, enhancing system performance
CERTIFICATIONS
DigitalTrust® Professional (DTPr®) Foundation Certificate - The Digital Trust Academy
Cyber Security On-Premises Hacking - ICT Academy, IIT Kanpur
EXTRA-CURRICULARS
Upraised Embark Achiever - Placed in the Top 80 Product Managers from over 350,000 aspirants across the country.
Anti-Plastic Rally in New Delhi City Centre - Co-Leader
Group Discussion Pro - Semi-Finalist (National Level)
