Abdul Wasay
​
BEng Mechanical Eng | MSc Accountancy & Business management
2 years + contracting experience working with large volumes of data, cleansing, analytics, reporting, data modelling, and automations of pipelines
​
Contracting experiences
-
1 year contract in Commercial: Reporting analyst (Thames Water)
-
6 months contract in Finance: Business intelligence analyst (Bristan)
-
3 months contract in ESG: Data analyst consultant (SustainIT)
-
3 months research Survey project: Survey analyst (PostGrad research at Brunel University)​​
​
Key Takeaways​
-
Mathemtical background in statistics as well as accountancy experience alongside masters in accountancy
-
Graduate of Mechanical Engineering and Accountancy & Business Admin
-
Data modelling in PowerBI and SQL for building pulse database and star schema for project savings data
-
VBA macros for report automation and workbook events for non-technical users
-
Python for data pipelines (REST API's , Excel and CSV's) built using pandas and wrapped in tkinter app.
-
Data visualisations in PowerBI for Gantt chart, User Login, Sales data, and PMO status management
-
DAX programming and context transition experience and understanding. Commonly used alongside VAR and RETURN with conditionals if necessary such as SWITCH() AND IF() ELSE(), as well as calculating relative dates with EDATE(), and converting calculated columns to equivalent DAX measures using FILTER() and CALCULATE()
-
Built data entry forms as well as surveys to collect data analyse as part of research within IBM SPSS
Achievements
-
First prize winner in chess (Uxbridge College)
-
Twice a mechanical design winner (Brunel University)
-
Nominated for technological innovation brought to commercial department via automations, using Python, M-Query, and VBA (Thames Water)
-
Received commendation from national account manager on time savingmacros for automating lookup (Bristan)
-
Created PowerBI report that impacted feasibility of ML implementation for AvonFire client (SustainIT)
-
Received praise from PMI client on rigorous software failures report on around 1700 cases (SustainIT)
-
Won prize for insights into product's financial data from Chief Marketing Officer (Bristan)
-
Fully automated outstanding order report that sends the Excel file to the recipients on click of a button which saved 50% of the time spent (Bristan)
My learning certifications
​​
-
PowerBI, Python, PowerQuery certification (Udemy)
-
Docker for data science (linkedin)
-
Github for data science (linkedin)
-
HTML5 (sololearn)
-
API and Web Scraping with Python (dataquest)
-
SQL bootcamp (udemy)
-
VBA Excel (udemy)
Main Skills
PowerBI, QlikView
DAX measures and visualisations - including context transitions with CALCULATE() and building complex measurs using VAR and RETURN
PowerQuery & PowerPivot
Advanced Excel - functional programming in M-Code, OOP-VBA, DAX for insights
Python, VBA Excel (+ customised add-ins), SQL, HTML, M-Code
Pandas, Numpy, Regex, Data Entry Forms, API's, Database Design
IBM SPSS
Statistical modelling and analysis using Chi Square, Chronbach Alpha, Spearman rho, and descriptive & exploratory analysis with various hypothesis models and statistical measures e.g. standard deviation from mean.
SalesForce, Jira
CRM - for ticket resolution and case handling within SLA deadlines
Visual Studio Code, Jupyter notebook, Spyder, Databricks
IDE - mainly use Jupyter and VScode for learning and implementing Python Code. Databricks was learnt to learn PySpark.
SQL & RDB knowledge window functions, stored procedures, queries, CTEs
DB Queries, and RDB understanding
Built database in Access; queried sample databases in SQL Server; Modelled data in PowerPivot and PowerBI
Contact Us
Thank you for your interest in our skills and experience.
Get in touch with us for any questions or comments regarding our work and publications.
07899563397