Sign in

Data Analyst

Raleigh, NC
January 13, 2020

Contact this candidate


Shahid Akbar 919-***-****

MBA & Industrial Engineering (supply chain) dual master’s graduate with proven leadership ability in delivering results through analytical problem solving; experience using data analytics tools like Python, SQL and BI


Master’s - Industrial Engineering - North Carolina State University August 2017 – December 2019

Master’s - Business Administration - North Carolina State University August 2017 – December 2019


LENOVO, Morrisville, NC May 2019 – August 2019

Supply Chain Data Analyst Intern

Improved Excel management tool using Visual Basic VBA coding in macros to automate fulfillment and logistics process with integration of new product shipment data, eliminating existing problems and improving time efficiency

Worked closely with a cross-functional team (i.e. Supply Chain, Sales Operations, Manufacturing and Planning) to replenish inventory in warehouse, perform inventory management and ensure delivery on planned timelines

Produced daily updates of shipment orders, change requests, product planned/actual shipment dates and updated receipts (actual arrivals) of product using ERP software (SAP)

RESTAURANT SC SOLUTIONS (RSCS), Louisville, KY January 2019 – April 2019

MBA Consultant Optimization of Beef Production

Created optimization model using optimization algorithm (linear programming & VBA in Macros) to identify the optimal point of lean for raw beef by considering operational constraints, resulting in increased capacity utilization

ADVANCE AUTO PARTS, Raleigh, NC August 2018 – December 2018

MBA Consultant Distribution Network Data Analysis

Evaluated factors resulting in variance in delivery times of auto parts from distribution centers to customers; issued recommendations including customer realignment using transportation routing, cut-off times, batching etc., leading to reduction in lost sales

FAUJI FERTILIZER COMPANY (Chemicals), Rawalpindi, Pakistan February 2007 – August 2017

Project Engineer

Managed capital and technical projects through all phases including budgeting, scheduling, design, fabrication, and installation, ensuring compliance with design requirements, technical specifications and regulations

Vendor Registration and Procurement of Non-OEM Items: Identified and evaluated new vendors and suppliers; moved procurement to new non-OEM (original equipment manufacturer) vendors, resulting in cost saving of 30%

Redesigned working procedures and improved processes using and communication with stakeholders to focus on quality, safety and environment to comply with ISO 9001&14001, and OHSAS 18001 requirements

Student Projects Skills

Supply Chain Data Quality and Governance Study: Cleaned and analyzed raw survey data obtained from Europe and Americas; performed statistical analysis on data set using ridge regression, lasso and best subset analysis to understand current state of data quality & data governance across the organizations

Recruiters’ Manpower Solutions Database: Created centralized database system and MS Access application dashboard, using SQL to update data, provide necessary insights, and visualize recruitment process

Knowledge Domain: Data Analysis, Visualizations, Statistical Analysis, Logistics Engineering, Machine Learning, KPIs Reporting, Forecasting, Inventory Management, Project Management, Business Intelligence

Tools: R programming, Python, SQL, Tableau, Advanced MS Excel, MS office, power BI

Work Eligibility: Eligible to work in the U.S. till 2023 without sponsorship

Contact this candidate