Fasih Zulfiqar

Data Analyst

About Me

I’m a Client Success Manager at Trademor x Alibaba, a student, and an aspiring data analyst.

Having self-studied for my secondary education due to financial constraints, I’m a proud autodidact. A distinction holder in A-level Economics in Pakistan and was awarded a scholarship by Professor Tyler Cowen, Mercatus Center, to pursue Economics.

Aside from academics and work, I’m a big football fan and was part of a club, GSA, for 6 years. Super into travelling and Philosophy, particularly Stoicism and Absurdism. And dogs. I love dogs.

Why travelling? I love to travel because it allows you to be in cultures much different than yours. Plus I love tasting new foods :D

Why Powerlifting? Helps me push myself to new limits. When you have 250 lbs on your back and you squat down, there is always a chance you will fail. Your knees might strain, or worse, break. Conquering that fear is why I love powerlifting.

Education
Qualification: BS Econonomics & Mathematics at IBA
With a specialization in Business Intelligence.

CGPA: 3.91

The CFO of the Animal Welfare Society at IBA, Karachi.

Projects

FG Inventory (DOH) Dashboard

https://ibb.co/gP7k20Y

Lipton

July 2023 - Aug 2023

Building an interactive and automated dashboard for each SKU's Days on Hand in each of Lipton's DCs

Built a live dashboard that shows a complete inventory anaysis of each of Lipton’s SKUs.

Worked with the Lipton team during my internship to consolidate data and deliver a dashboard that can be utilized even after my internship ends.

Used Excel and Macros (VBA) to automate the dashboard.

The dashboard displays the inventory (tons), sales (tons) and the DOH of each SKU in each DC.

Tools: Excel, SAP, Macros

Code: VBA, MySql

Supply Planning Dashboard & MPS

https://ibb.co/XYF7Zt7

Lipton

Aug 2023 - Sept 2023

Displays current and future (predicted) Machines' Utilization in each factory of Lipton

An Excel-based dashboard that is fully interactive and automated with Macros enabled (via VBA).

As part of the Supply Chain dept, I came up with a Master Planning Schedule (MPS) that shows opening stock, closing stock, target inventory, predicted demand, and orders for each SKU.

The MPS also shows the capacity and shift plan of each machine that is producing each of Lipton’s SKUs in all weeks YTG.

The Supply Planning Dashboard provides a one-shot view of the capacity utilization of each of the 11 machines. It also shows future utilizations so that the supply planner can see choking points for each machine and shift some production earlier.

Tools: Power Bi, R, Excel, SAP, Macros

Code: DAX, VBA, Power Query

Predicting Berlin's and London's AirBnb Prices

tinyurl.com/airbnb-project

AAMD Course at IBA

April 2023 - May 2023

Ran a complete data science pipiline to most accurately predict Airbnb listings' prices in London and Berlin

With a dataset of current Airbnb prices, I split the dataset into train and test sets and performed EDA on R, coming up with many illumanating visualizations.

Ran different types of regressions, such as MLR, Logistic Regression, Step-wise regression, to predict Airbnb listings’ prices.

Tweaked parameters of the model to further increase R^2, decrease Mape, and improve predictive KPIs of the model.

Did Classification too (via RParts on R) and then regularization (L1, Lass) to further improve model and lastly evaluated more KPIs such as Precision, Recall, and F1-Score.

Tools: R, Excel

Code: R Programming

Polypropylene and PP Compounds Market Analysis

Confidential

Engro - Eximp FZE

May 2023

Analyzed the PP Compounds Market for Engro so that they could decide whether or not, and where, to set up their first PP Compound plant.

With a dataset of all the Polypropylene (PP) Compounds importers and exporters in Pakistan, I had to analyze the dataset to see who are the biggest players in the market and their market positioning.

Did EDA on the PP compounds market and the companies involved and some research to find out the estimated cost for setting up a plant.

After doing the analysis, I came up with a few options for where we could set up our first PP Compound plant.

Tools: R, SQL, Excel

Code: Python, R

Analysis of Borrowing Grades

tinyurl.com/Borrowing-project

DMV Course at IBA

Oct 2022 - Nov 2022

Data Exploration and Forming Hypothesis for what determines an individua's borrowing grade

Did data exploration and visualization on Excel and Power Bi to discover what are the most important factors affecting an individual’s borrowing grade in the US.

Came up with a proper report and 3 hypothesis for what affects borrowing grades.

Tools: Power Bi, Excel

Code: VBA, DAX

Professional Experience

Alibaba - Trademor

Client Success Manager (CSM)

May 2021 - Present

Trademor is the official channel partner of Alibaba.com in Pakistan.

I work with the North American team of Alibaba.com and spearhead the services department at Trademor. Through Zoom/Teams meetings, conferences, and emails, I’m basically acting as the CSM to 139+ US business owners who have started their e-commerce business on Alibaba.com.

Lipton (Teas & Infusions)

Demand & Inventory Analyst

July 2023 - August 2023 (7 Weeks)

The Supply Chain (Planning) and Data department of Lipton Teas and Infusions.

I worked on coming up with two live, interactive dashboards in Excel and Power Bi.

FG and Sales Dashboard: Analyzing and providing an overview, with multiple KPIs such as DOH, of how many finished goods are stocked and average sold at each DC.
MPS and Supply Dashboard: Showing how much stock of each raw material and packing material we have on weekly basis and what’s the predicted demand and utilization of each machine and plant.

Engro (Eximp FZE)

Marketing Analyst

May 2023 - July 2023

Eximp FZE is the international subsidiary of Engro headquartered in Dubai.

Analyzed the PP Compound industry in Pakistan & Tanzania, leveraging SQL to identify major players & market trends. Analyzed import/export data with Excel to understand trade patterns & market dynamics.
Collaborated with various departments to create and implement 6 SOPs, focusing on data integrity and analytics in customer auditing, payment terms execution, and successful commodity deliveries.
Analyzed the African Caustic Soda market, providing insights for strategic market penetration for Engro.

IBA x Academic Writing Center (ACCW)

Writing & Academic Consultant

August 2022 - Present

ACCW is a mini institution inside IBA which helps students with their pieces of writing and provides academic and career advice.

Guided a total of 190+ students with their writings (essays, SOPs, etc) and attained a rating of 4.7/5.