Download PDF

Jas Sohi

Supply Chain Coordinator at BuildDirect

Work experience

Aug 2013Present

Supply Chain Coordinator

BuildDirect
*Responsible for ensuring the accuracy of ETAs within our inventory system and communicating any changes to the Sales team (delays, early containers, etc.) *Implemented checks and balances to significantly reduce the number of ETA delays *Ensuring quality control of several Smartsheets which have increased collaboration across departments *Managed the Project Queue as well as worked on several projects to improve/develop processes *Helped lean out and optimized several Supply Chain processes: Transfers, Returns, Billing, & Tracking *Acting as the one of the main contacts for our 4PL Supply Chain partner ABF *Lead, mentored, and trained the new Inventory Administration team to ensure the analysts could focus on their core competencies: analysis and supplier relationship management *Developed the weekly Supplier Replenishment Schedule to help increase transparency and improve communication between departments *Transfers - Saved thousands of dollars in freight by optimizing shipments based on different analysts' requests and ensuring the monthly budget was not exceeded. *Droptask - Introduced a project management tool to visualize the Project Queue and help prioritize and highlight important projects
Jan 2003Present

Webmaster

H & I Roofing
Reporting to the owner, Harjit, manage, update and improve website according to specifications on an ongoing basis. Google Analytics ♦Report on insights and offer suggestions to improve marketing success. ♦Recommended tracking phone leads to measure the effectiveness of Goal completions. Google Adwords ♦Recommended and initiated an ad campaign helped increase traffic to the site by 6.5x ♦Working on a new Google Adwords campaign for 2014 - focusing on the most cost effective keywords ♦Improved the campaign effectiveness by using negative keywords and location targeting *A major overhaul of the website was done by switching from Flash to Joomla CMS in 2012 *Completed a complete redesign of the website in October 2013. *The site is now fully responsive; it will adapt accordingly to all screen sizes and platforms. *Started off as a part-time Roofer working weekends and summers; which developed into an opportunity to develop a flash-based website according to specifications.
May 2012Aug 2013

Inventory Management Analyst

BuildDirect
Reporting to the Director of Inventory Replenishment, Jason McMurdo; managed inventory for the Engineered Hardwood & Accessories categories representing over a dozen different vendors & over 400 SKU/Locations. Previously, managed the Porcelain & Ceramic category which is one of the Top Categories at BD. Major responsibilities included inventory forecasting, replenishment planning, reconciliation, data analysis, and supplier communication. Keeping out of stocks low and monitoring hundreds of SKUs was a daily challenge. *Introduced a time management tool (Toggl) to track daily tasks and to help re-prioritize the work of the Inventory department *Several recommendations made to improve the Product Launch Process not only from an Inventory perspective, but from a holistic point of view. *Strong work ethic & focus demonstrated on a daily basis - demonstrated ability to work well under pressure and adaptable in a rapidly changing, dynamic environment. *Worked extensively with ABF Freight System's WMS - Logiview and reconciling inventory with the in house Product Availability System *Developed Excel-based Inventory Reports to summarizes data for key stakeholders
Oct 2010Apr 2012

Inside Sales Rep

BuildDirect
Reporting to the Director of Sales, James Komenda; ensured customer satisfaction by helping customers throughout the entire purchase cycle: order processing, logistics management and order tracking, warranty or damage in transit claims, and general product inquiries. *85% of my customers rated my customer service as good or excellent. *Finished May 2012 (last month in Sales) with personal best of $150k in Revenue showing steady progress from the start of the year. *Contributed over $1.1 million to top line growth in a product category known for low minimum order sizes, lower than average margins, and long lead times before closing (2011). *Consistently amongst the highest amount of daily touches with potential customers. *Recommended several suggestions to help improve business processes and increase efficiency. *Self-starter - Designed a tile layout diagram to educate customers on correct installation procedures. This helped to reduce customer error when installing product resulting in less claims.
Aug 2008Oct 2010

Senior Sales Consultant

Bell Mobility
Reporting to the Virgin Mobile store manager; sold the complete solution: handsets, plans, and accessories. Also performed other daily tasks such as opening/closing the kiosk, assisting customers, and activating phones. *100% score on a November mystery shop (2nd out of 9 employees). *Exceeded targets for 9 months and green in all metrics (activations, warranties, and accessories). *$43,500 added to bottom line with 145 activations (minimum $300 cancellation fee per sale) in 2009. *As a senior consultant, and key holder, showcased leadership by training/coaching newer employees (Amy, Johannes, and Jess). *Strong work ethic demonstrated with 200% to target for postpaid sales in August 2010.

Education

20142014

British Columbia Institute of Technology
MS SQL Server 2012, Database Design, ERDs, Views, Subqueries, Stored Procedures, Triggers, Business Rules, Requirements, ETLs, data modeling
20042009

BBA

Simon Fraser University

Skills

Databases
Database Design
ERD
Web Analytics
Machine Learning
SQL Server Management Studio
Visio
Matlab
Web Development
Analytics
Teamwork
HTML
Tableau
Project Management
Highly detail oriented
Task Management
QlikView
Vlookup
Writing
cPanel
HTML + CSS
Adobe Creative Suite
Google Adwords
Inside Sales
T-SQL
Logistics
Forecasting
Wordpress
Smartsheet
Github
Web Design
Pivot Tables
SQL
Python
R
Google Analytics
Business Intelligence
Leadership
Negotiation
Marketing
Customer Service
Microsoft Excel
Supply Chain
Data Analysis
Business Process Improvement
Inventory Management

Certifications

Certified Supply Chain Professional

Data Analysis and Statistical Inference

The Data Scientist’s Toolbox

R Programming

Getting and Cleaning Data

Exploratory Data Analysis

Reproducible Research

Statistical Inference

Regression Models