Hi, I'm Shahan Arshad. I am a Data Analyst and a Full Stack Web Developer.

Most DevelopedSkills

Programming Languages

Python
JavaScript
TypeScript
SQL
Go
VBA

Frameworks

React
Vue
Svelte
FastAPI
NodeJS
Bootstrap
TailwindCSS
JQuery
D3.js
Pandas
NumPy
Scikit-learn
Matplotlib
Seaborn
Excel
LaTeX
Elementor
WordPress

Version Control

Git
GitHub

Linux
Windows

Databases

PostgreSQL
MongoDB
MySQL
MariaDB

BI Tools

Tableau
PowerBI
Cognos

Analytical Skills

Data Visualization
Data Analysis
Hypothesis Testing
Forecasting and Volumetric Projection
Linear and Logistic Regression
Market Research

ProjectORNATE Keyboard Layout

View Repo

Invented an optimized keyboard layout for easier and faster typing, made with scientific metrics including overall Finger Distance Travel, Same Finger Bigram Utilization percentage and Total Effort scores.

ProjectWhatsApp Bot

View Repo

Created open-source Python script for bot that sends customized greetings to contacts on special occasions.

ProjectVisualizations and Dashboards

View Repo

Created viz and dashboards in Tableau, PowerBI, Matplotlib, Seaborn for presentation to businesses and government.

ProjectFinancial models

Financial models of Pharmaceuticals, Cement manufacturers, Fertilizer manufacturers, Banks including UBL financial model for CFA Research Challenge 2015.

ProjectNational Exports Strategy

modeled strategy of Pakistan's Exports for the Ministry of Commerce.

ProjectTime Series Analysis of WhatsApp Group chats

View Repo

Scripted time series analysis of data in WhatsApp group chats.

ProjectMachine Learning Project: Bank Defaulter Classifier

View Repo

Constructed Bank Defaulter Classifier

ProjectMachine Learning Project: Traffic Severity Predictor

View Repo

Constructed Traffic Accident Severity Classifier.

ProjectSQL

Designed database of Pakistan’s exports and imports in PostgreSQL.

ProjectCoca Cola

Excel-based distribution model and financial model + market research leading to strategic recommendations to introduce bulk water format to market.

Work Experience

Pakistan Business CouncilSenior Analyst

Jan 2020 - Nov 2022

Economic analysis and report writing. Field work involved visits to manufacturers, surveys, interviews, data collection and integration. Liaison with various government agencies for development of Pakistan’s business environment.

Projects Executed:

Published reports on Pakistan Surgical Industry & Cutlery Industry.
Use of machine learning in finding impact of Brexit in Pakistan-UK trade.
Assessment of Pakistan’s performance under the EU GSP Plus scheme.

Impact

Initiated SQL Database creation and maintenance of 80 million records.
Began use of BI tools (Tableau, PowerBI) for visualization and dashboard creation.
Started use of JSON as a framework for data and knowledge storage.

Trade Development Authority of PakistanResearch Associate

Mar 2018 - Jan 2020

Economic analysis of Pakistan and other countries for policy recommendations on promoting and boosting exports.

Projects Executed:

Led effort to development of Pakistan’s first online e-commerce export platform pakistantradeportal.gov.pk at TDAP and Ministry of Commerce.
Created National Export Strategy model, a model of all of Pakistan’s exports, for presentation to Advisor, Ministry of Commerce.
Budgeting exercise for annual TDAP exhibitions.

Impact

Invited to Ministry of Commerce for presenting strategy on increasing exports to USA.

NED UniversityVisiting Lecturer

Sep 2017 - Mar 2018

Taught cost accounting and business finance to students.

Karachi School of Business & LeadershipBusiness Analyst & RA

Nov 2016 - Mar 2018

Financial modeling. Revenue channels analysis for optimization.

Projects Executed:

Financial modeling and budgeting for strategic planning.
Helped the University launch new undergrad programs.

Impact

Resulted in launch of 3 new programs: Masters in Business Analytics and Undergrad programs.

Meezan BankCorporate Credit Risk Analyst

Sep 2015 - Nov 2016

Risk analyses of new and existing corporate clients.

Projects Executed:

Analysis of Pakistan sugar industry
Analysis of Pakistan Banks industry-wide exposures

Mareet Pte Ltd SingaporeAccounts Manager

Oct 2010 - Dec 2012

Bookkeeping, preparing CVP analysis for every charter, coordinating vessel fixtures and documentation compliance between different parties, demurrage calculations, preparing bank instructions.

Projects Executed:

Costing for introduction of imported French bakery items in Singapore.

Impact

Led efforts to implement MYOB accounting system; resulted in increased efficiency and time saving in the bookkeeping process.

Hi, I'm Shahan Arshad. I am a Data Analyst and a Full Stack Web Developer.

Most DevelopedSkills

ProjectORNATE Keyboard Layout

ProjectWhatsApp Bot

ProjectVisualizations and Dashboards

ProjectFinancial models

ProjectNational Exports Strategy

ProjectTime Series Analysis of WhatsApp Group chats

ProjectMachine Learning Project: Bank Defaulter Classifier

ProjectMachine Learning Project: Traffic Severity Predictor

ProjectSQL

ProjectCoca Cola

Pakistan Business CouncilSenior Analyst

Trade Development Authority of PakistanResearch Associate

NED UniversityVisiting Lecturer

Karachi School of Business & LeadershipBusiness Analyst & RA

Meezan BankCorporate Credit Risk Analyst

Mareet Pte Ltd SingaporeAccounts Manager

Karachi School of Business & Leadership (KSBL)MBA

University of Bedfordshire UKBA (Hons) Accounting

CFA SocietyCFA Level 2 Candidate

Certifications