Faaran SaleemData Analyst
Bridging the gap between technical and business teams, by translating requirements, to align data points and strategies. Presenting information through reports and visualization using analytical tools for KPIs and data driven projects. Advanced knowledge of Business Intelligence tools, experienced in cleaning, organizing, validating data from various sources. Transforming and generating actionable insights from the data through scripting in Python & SQL.
Tech stack
Python (4)
ETL (3)
Logistics (3)
Analytics (3)
Performance (3)
Leadership (3)
BigQuery (3)
Usability (3)
SQL (2)
Microsoft Power BI (2)
Integration (1)
Algorithms (1)
Tableau
Microsoft Excel
Microsoft Office
Team Leadership
Data Analytics
Data Visualization
MATLAB
R
Statistics
Machine Learning
Experience
Founding Member - Data AnalystKrave Mart (YC S22)
02/2022 - Currently

Analytics manager working directly with stakeholders to help them manage and utilize their data for business growth. • Setting up dashboards for CEO and leadership for visibility on KPIs and growth • Managing the setup of first ever data warehouse of Krave Mart to enable data usability. • Setting up dashboards for commercial team for effective sourcing of products on Dark Stores including stock ageing, stock allocation and stock in hand visibility. • Built a price comparison dashboard for commercial function to assist them in pricing strategies. • Setting up dashboards for Warehouse Operations to enable stakeholders to identify inefficiencies in warehouse operations i.e transfer orders, putaways, order picking and packing performance, inventory losses. • Setting up dashboards for Finance for cash reconciliation of sales. • Setting up dashboards for Marketing for visibility on user acquisition and retention including analysis on discounts and ROI.

Analytics
BigQuery
ETL
Leadership
Logistics
Performance
Python
Usability
Strategy & Planning AnalystDaraz
11/2020 - 12/2020

• Coordinated with engineering team to revamp the existing ETL for data points, requiring modifications, based on new business processes. • Collaborated with marketing team to provide visibility on the ROI of marketing campaigns for Acquisition team. • Testing and monitoring the underlying data, assuring quality and optimizing the tables in data warehouse. Designed and executed SQL queries for extraction of data upon ad hoc request of data.

SQL
Python
Data EngineerAstera Software
06/2019 - 11/2019

• Support existing offshore clients with queries related to software and communicating bugs & issues to the Engineering Team. • Integrating machine learning algorithms to enhance software features and create models for the clients according to their business requirements. Tools: MSSQL, Astera Data Integration Software, MS Excel

Algorithms
Integration
Engineer trainee (Data Analyst)K-Electric
08/2017 - 09/2018

DATA ANALYST:  Analyze consumer data across different units to report the changes in consumer dynamics and identify consumers with theft billing over 0.5 million.  Launched the initiative to ensure correct mapping of 102,000 consumers resulting in an effective billing and consumer feedback system.

SQL
Python
Microsoft Power BI
Education
CertificateZero To Mastery Academy
02/2021 - 02/2021
CertificateZero To Mastery Academy
02/2021 - 02/2021
CertificateZero To Mastery Academy
02/2021 - 02/2021
CertificateZero To Mastery Academy
02/2021 - 02/2021
CertificationUdemy
02/2020 - 02/2020
CertificationUdemy
02/2020 - 02/2020
CertificationZero To Mastery Academy
02/2019 - 02/2020
CertificationZero To Mastery Academy
02/2019 - 02/2020
CertificationZero To Mastery Academy
02/2019 - 02/2020
CertificationZero To Mastery Academy
02/2019 - 02/2020
Bachelor's degreeLahore University of Management Sciences
02/2013 - 02/2017
A levelsBay View High School
02/2011 - 02/2013