Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Raj Saini

Markham,ON

Summary

Analyst with expertise in advanced Excel, SQL, Tableau, and Power BI reinforced with an educational background in business administration and finance. Proven track record of developing comprehensive visualizations and dashboards to inform strategic decision-making. Skilled in implementing data-driven approaches to enhance operational efficiency and drive cost reductions. Successfully managed procurement and inventory systems, achieving significant cost savings and optimizing supply chain processes.

Overview

5
5
years of professional experience

Work History

Business Operations Analyst

YHDistributors
01.2023 - Current
  • Utilized SQL for extracting, transforming, manipulating and loading data from multiple sources, ensuring data integrity and accuracy for analysis and reporting.
  • Created comprehensive dashboards in Tableau for C-level executives, senior leadership and stakeholders, driving strategic decision-making with data-driven insights.
  • Utilized advanced Excel functions(XLOOKUP, VLOOKUP and pivot tables) and SQL to analyze data, improving overall efficiency in daily operations with data-driven approaches.
  • Implemented data-driven approaches to improve overall efficiency in day-to-day operations.
  • · Spearheaded implementation of Kanban inventory control system to ensure cost reduction, healthier cashflow and just in time availability of products.
  • Managed purchasing activities ensuring timely procurement of materials while maintaining optimal inventory levels and maintaining an order fulfillment rate of 96%.
  • Setup an automated replenishment alert system in ERP software to allow the organization to be proactive in sending purchase orders keeping in mind lead times based upon lead times and delay rates.
  • · Implemented inventory management systems to track and analyze purchasing trends, customer behavior and reducing inventory value by $300,000.
  • Successfully created and managed purchase orders for over 3,000 products from over 50 suppliers utilizing QuickBooks, ensuring accuracy and efficiency in procurement processes.
  • Utilized data visualization tools to effectively communicate business insights.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Coordinated implementation of marketing and social media strategies.
  • Improved customer engagement with tailored content creation and social media management.
  • Used adobe creative suite(InDesign, Photoshop) to create monthly flyers with discounts that boost sales while keeping profitability goals.

Security Supervisor

Garda World Security
12.2019 - 01.2023
  • Regularly patrolled the premises and monitored security cameras to maintain a safe and secure environment.
  • Controlled facility access by checking credentials, allowing entry to authorized individuals, and keeping unauthorized persons out.
  • Quickly reacted to alarms and incidents, handled emergencies efficiently, and coordinated with law enforcement when needed.
  • Followed and enforced security procedures, ensuring adherence to company policies and safety regulations.
  • Provided assistance and directions to visitors and employees, balancing customer service with security responsibilities.
  • Supervised and evaluated security staff performance to determine compliance with safety regulations.
  • Kept detailed logs and wrote clear, accurate reports on security breaches and incidents.
  • Managed and resolved conflicts, maintaining order and ensuring a peaceful environment.
  • Oversaw team of security officers and managed scheduling and performance evaluations.

Education

Associate of Arts - Business Administration - Financial Planning

Seneca College
Toronto, ON

Skills

  • Excel Functions (XLOOKUP, VLOOKUP, Pivot Tables, Dashboards)
  • SQL (Joins, Aggregate, Window Functions, Database Manipulation and Data Cleaning)
  • Data Visualization and Presentations
  • Data Analysis
  • Data Cleaning
  • SQL Databases
  • Analytical Problem Solving
  • Statistical Analysis
  • Tableau
  • Google Analytics
  • Currently Learning Python (Pands, NumPy, SciPy, MatPlotLib)

Projects

Supermarket Sales Data Tableau Visualization Project

Technologies Used - Excel, Tableau


Used excel to clean and standardize data used statistics functions to calculate profit margins, transferred to tableau and created dashboard to display data to help make insightful business decisions as per below.


  • Arrived on a few notable conclusions, company is overall not making profit in the following categories:

Bookcases, supplies and tables.

As a recommendation, it would be recommendable to look into cost reduction measures for these categories and potentially look for cheaper shipping methods for these products to move them towards profitability.


  • Profitability per discount rate depicts that company overall did not make profit when offering profits over 25%, so this would be another key metric to keep in mind while setting up discounts.


  • Company was not profitable in the Central region, a price hike for this region might be a drastic measure that the company might have to take. Adjacent to this, average discount offered per region shows discounts offered in Central region were 45% higher compared to other regions. It might be worth nudging the sales department towards offering smaller discounts in order to move towards profitability in that region.

Timeline

Business Operations Analyst

YHDistributors
01.2023 - Current

Security Supervisor

Garda World Security
12.2019 - 01.2023

Associate of Arts - Business Administration - Financial Planning

Seneca College

Similar Profiles

CREATE PROFILE
Raj Saini