AKSHIL
KUMAR

Business Intelligence and Supply Chain Analyst

Transforming complex data into actionable insights that drive operational excellence. 3+ years of experience optimizing operations and improving reporting efficiency across higher education, manufacturing, and supply chain environments.

Available for opportunities
Experience
3+
Years in Analytics
$
Impact
$535K+
Cost Savings Identified
Efficiency
80%
Report Time Reduction
SQL & Power BI
Forecasting & Analytics
Process Optimization
Supply Chain Management
Business Intelligence
Data Visualization

Start with My Story

Hello, you all—welcome! I’m Akshil. I found my niche where operations meets data. At Purdue’s Career Center, I worked as an Employer Relations Associate Intern, wrangling Qualtrics → Excel, cleaning the chaos, and turning it into dashboards that helped our team (and recruiters on Handshake) move faster. I loved that moment when a messy sheet becomes a clear next step. To go deeper, I pursued my M.S. in Industrial Technology & Manufacturing at Purdue University Fort Wayne and leaned into Supply Chain BI—forecasting (WMAPE, bias), KPI design, and bottleneck detection in Power BI. My style: questions before queries, KPIs before charts, automate the repetitive, tell the story simply. I’m dedicated to work that reduces noise and moves metrics—let’s see where we can go together.

What I Do

I bridge the gap between complex data and actionable business outcomes

Analytics & Dashboards
SQL-powered insights, Power BI/Tableau visualizations, and executive-ready KPI design that transforms raw data into strategic intelligence.
SQLPower BITableauKPI Design
Forecasting & Optimization
Demand forecasting with MAPE tracking, root-cause analysis, and throughput optimization that keeps operations running smoothly.
Demand ForecastingMAPE AnalysisStatistical ModelingProcess Optimization
Operations & BI Enablement
Report automation, process mapping, and stakeholder training that empowers teams to make data-driven decisions independently.
Process AutomationTraining & EnablementWorkflow DesignChange Management

How I Work

A systematic approach to transforming data challenges into business solutions

Discover

Understanding business context and stakeholder needs

Define KPIs

Establishing measurable success metrics

Model & Validate

Building robust data models and testing accuracy

Visualize & Automate

Creating intuitive dashboards and automated reports

Iterate & Enable

Continuous improvement and team empowerment

My approach emphasizes collaboration, data hygiene, and measurable outcomes. I believe in building solutions that not only solve today's problems but also empower teams to tackle tomorrow's challenges independently.

Philosophy & Approach

Four principles that guide every project and decision

Clarity First

Ask the right questions before writing queries. Understanding the business problem is more valuable than perfect syntax.

Measure What Matters

Align every metric with business goals. If it doesn't drive decisions or outcomes, it's just noise.

Automate Repetition

Eliminate manual effort wherever possible. Time saved on routine tasks is time gained for strategic thinking.

Tell It Simply

Complex insights delivered simply beat simple insights delivered complexly. Clarity trumps cleverness.

Skills

A comprehensive toolkit for turning data into strategic advantage

Analytics & BI

SQL
Power BI
Tableau
Excel (Power Query, PivotTables, VBA)
Frontline Solver

Databases & Programming

SQL Server
MySQL
PostgreSQL
Python
JAVA

Methods

Forecasting (MAPE)
Statistical/Predictive Modeling
Root Cause Analysis
SCOR
Lean Six Sigma

Business Tools

SAP
Jira
MS Project
SharePoint

Collaboration

Stakeholder Engagement
Agile
Process Optimization

Experience

A progressive journey through data analysis, business intelligence, and operational excellence

Business Data Analyst – Employer Relations
Purdue University, Fort Wayne
Aug 2024 – Dec 2024
Fort Wayne, IN

Leading data-driven initiatives that transform operational challenges into strategic opportunities through advanced analytics and stakeholder collaboration.

Key Achievements

  • Developed forecasting models that improved demand prediction accuracy
  • Created automated dashboards reducing manual reporting by 60%
  • Collaborated with cross-functional teams to optimize supply chain processes

Technologies Used

SQLPower BIPythonStatistical Modeling
Operations and Budget Data Analyst
Helmke Library
May 2024 – Jul 2024
Fort Wayne, IN

Specialized in process optimization and data analysis to enhance operational efficiency and reduce costs across multiple business units.

Key Achievements

  • Implemented SCOR methodology for process standardization
  • Reduced inventory carrying costs through improved forecasting
  • Streamlined reporting processes using advanced Excel and VBA

Technologies Used

Excel VBASAPProcess MappingSCOR Framework
Business and Research Data Analyst
Globe Minded
Sep 2022 – Jun 2023
India

Built foundation in data analysis and business intelligence while supporting various departments with reporting and analytical needs.

Key Achievements

  • Created standardized reporting templates for multiple departments
  • Performed root cause analysis on operational inefficiencies
  • Developed SQL queries for complex data extraction and analysis

Technologies Used

SQLExcelTableauData Visualization

Certifications

Continuous learning and professional development in data analytics and business intelligence

Business Intelligence Analyst
GooglePresent

Comprehensive program covering data modeling, dashboard creation, and business intelligence best practices.

Skills Covered

Data ModelingDashboard DesignBusiness IntelligenceStakeholder Communication
SQL: A Practical Introduction (with Honors)
IBMMar 2025

Advanced SQL techniques, database design, and relational database management systems.

Skills Covered

Advanced SQLDatabase DesignQuery OptimizationData Management
Implementing Supply Chain Analytics
UnileverFeb 2025

Advanced analytics implementation in supply chain operations and strategic decision making.

Skills Covered

Supply Chain AnalyticsImplementation StrategyData-Driven DecisionsProcess Optimization
Using Data Analytics in Supply Chain
UnileverFeb 2025

Practical application of data analytics tools and techniques in supply chain management.

Skills Covered

Data AnalyticsSupply Chain ManagementPredictive AnalyticsPerformance Metrics
Supply Chain Management & Analytics
UnileverJan 2025

Comprehensive supply chain management principles with integrated analytics approach.

Skills Covered

Supply Chain ManagementAnalytics IntegrationSCOR FrameworkLean Principles
Introduction to Business Analysis
IBMJan 2025

Fundamentals of business analysis including requirements gathering and process improvement.

Skills Covered

Business AnalysisRequirements GatheringProcess ImprovementStakeholder Management
Excel Basics for Data Analysis
IBMJan 2025

Excel fundamentals for data analysis including pivot tables, formulas, and data visualization.

Skills Covered

ExcelData AnalysisPivot TablesData Visualization

Interactive Analytics Dashboards

Comprehensive supply chain analytics suite demonstrating advanced BI capabilities, forecasting accuracy, and operational insights

Supply Chain Analytics Dashboard

Business Intelligence & Supply Chain Analysis

Last Updated: 8/14/2025

Sales Amount

$2.4M

+12.3%

Units Sold

45.2K

+8.7%

WMAPE %

12.4%

-2.1%

Fill Rate %

94.2%

+1.8%

Inventory Turns

6.8x

+0.3x

DIOH

53.7 days

-4.2 days

Stockout Events

23

-7
WMAPE % Trend vs Target
Units by Category & Region

Projects

Real-world solutions that delivered measurable business impact

Inventory Forecasting & Bottleneck Detection
Developed predictive models and automated dashboards that transformed supply chain visibility and reduced stockouts by identifying demand patterns and operational bottlenecks.

Key Outcomes

  • 35% reduction in stockouts
  • 20% improvement in on-time delivery
  • 50% faster bottleneck identification

Technologies

SQLPower BIPythonStatistical Modeling

Interactive Dashboard

Financial Risk Analysis
Built comprehensive risk modeling system with variance detection capabilities that accelerated account reviews and improved predictive accuracy for financial decision-making.

Key Outcomes

  • 60% faster account reviews
  • 25% improvement in risk prediction accuracy
  • 40% reduction in manual analysis time

Technologies

SQL ServerExcel VBAPower QueryRisk Modeling

Interactive Dashboard

Employer Engagement Analytics
Created segmentation and prioritization framework for outreach campaigns, resulting in significantly higher engagement rates and conversion improvements.

Key Outcomes

  • 45% increase in engagement rates
  • 30% improvement in conversion
  • 25% more efficient resource allocation

Technologies

SQLTableauStatistical AnalysisCampaign Analytics

Interactive Dashboard

Labor Allocation & Budget Dashboards
Designed dynamic staffing models and budget reconciliation dashboards that became the single source of truth for workforce planning and financial tracking.

Key Outcomes

  • 70% reduction in reconciliation time
  • 90% improvement in budget accuracy
  • Single source of truth established

Technologies

Power BISQLExcelFinancial Modeling

Interactive Dashboard

Need something specific? Let's work together

Additional projects and case studies are being prepared for showcase

Book a 15-min Chat

Ready to transform your data challenges into strategic opportunities? Let's connect.

Get in Touch
I'm always interested in discussing new opportunities and challenging projects.