Turning Data into Actionable Business Impact

Perishable Inventory Optimization & Replenishment Analytics

Designed a service-level–based inventory control model to reduce stockouts and improve inventory efficiency.

Problem

A retail operation managing 20 SKUs used a uniform replenishment policy despite significant differences in demand variability. This resulted in frequent stockouts for high-demand SKUs and excess exposure for slow-moving items. The objective was to design a data-driven replenishment framework that balanced service levels with inventory risk.

Results

  • Reduced stockout days across high-variability SKUs

  • Improved alignment between SKU importance and service level

  • Demonstrated measurable trade-offs between availability and excess inventory

  • Built a scalable prescriptive analytics framework

Approach

Demand Analysis

  • Analyzed one year of daily SKU-level demand data

  • Calculated average demand and variability per SKU

  • Identified demand volatility patterns

ABC Classification

  • Segmented SKUs based on demand contribution

  • Assigned differentiated service levels (95%, 90%, 85%)

Reorder Point (ROP) Model Design

  • Modeled expected demand during lead time

  • Calculated safety stock using service-level-based z-values

  • Designed SKU-level reorder point policies

Simulation & Comparison

  • Simulated baseline replenishment performance

  • Simulated optimized service-level-based policy

  • Compared stockout frequency and inventory exposure

Institutional Data Strategy & BI Modernization

Designed a strategic data maturity and business intelligence roadmap to improve decision-making, governance, and performance visibility.

Conducted a comprehensive data strategy and business intelligence assessment for Humber College, identifying gaps in data governance, analytics maturity, and performance reporting. Developed a transformation roadmap integrating governance frameworks, KPI architecture, and dashboard strategy to support institutional decision-making.

Problem

Humber College faced:

  • Fragmented data across departments

  • Limited governance standardization

  • Inconsistent KPI definitions

  • Reactive reporting instead of proactive analytics

  • Limited visibility into institutional performance drivers

The objective was to evaluate current data maturity and design a scalable BI transformation framework.

Business Impact 

  • Reduced ambiguity in institutional performance tracking

  • Established governance-first KPI architecture

  • Provided structured roadmap for BI maturity

  • Enabled transition from reactive reporting to strategic analytics

Analytical & Strategic Approach 

Environmental & Strategic Analysis

  • PESTEL analysis

  • Porter’s Five Forces

  • SWOT assessment

  • Higher-education market positioning analysis

Data Maturity & Governance Assessment

  • Evaluated current-state data architecture

  • Identified silos and duplication risks

  • Assessed governance gaps

  • Analyzed reporting workflows

BI & KPI Framework Design

  • Defined institutional KPI structure

  • Designed role-based dashboard concepts

  • Identified leading vs lagging indicators

  • Proposed governance standards for metric consistency

Transformation Roadmap

  • Short-term reporting improvements

  • Mid-term governance integration

  • Long-term predictive analytics capability

  • Defined capability maturity progression

 

Scalable E‑Commerce Infrastructure & Performance Analytics

Rebuilt and optimized a commerce platform to support scalable growth, inventory intelligence, and data-driven decision making.

Slice Baby Slice required a scalable digital commerce system that could support evolving product offerings, wholesale operations, and improved customer conversion performance.

I led the platform rebuild, integrating backend logic, inventory tracking, and analytics to create a sustainable growth infrastructure.

Problem

  • Limited scalability of initial website structure

  • No structured inventory tracking logic

  • Manual product and order workflows

  • Weak visibility into user behavior and conversion metrics

  • Inefficient wholesale purchasing flow

 

Measurable Results

  • Improved checkout flow efficiency

  • Enhanced conversion path clarity

  • Increased backend manageability and scalability

  • Enabled ongoing KPI-driven optimization

  • Strengthened long-term growth infrastructure

Strategic Impact

Transformed the business from a basic digital storefront into a structured, analytics-enabled commerce system designed for sustainable scaling and operational clarity.

Strategic Approach

Platform Re-Architecture

  • Rebuilt site into full eCommerce platform

  • Structured product categorization and bundling logic

  • Implemented scalable backend configuration

  • Integrated secure payment systems

Inventory & Operational Systems

  • Implemented inventory tracking framework

  • Configured wholesale checkout flows

  • Structured product bundling logic

  • Optimized backend workflows for manageability

Conversion & Analytics Enablement

  • Integrated behavioral tracking tools

  • Defined conversion funnel KPIs

  • Implemented SEO and structured data best practices

  • Optimized site speed and performance metrics

Open to collaboration

GET IN TOUCH