Sales Performance Analysis

Analysed multi-dimensional sales data using Power BI to identify trends, performance gaps, and growth opportunities. Designed interactive dashboards to optimise inventory planning and enhance customer satisfaction KPIs.

Tools Used: Power BI, Excel Pivot Tables, DAX
Impact: Supported data-driven decisions that improved sales planning efficiency.

Supply Chain Simulation

Developed a simulated supply chain model to evaluate supplier selection, transportation modes, and cost-effectiveness. Used Excel and Power Query for data modelling and scenario planning, with visual insights delivered via structured presentations.

Tools Used: Excel (Power Query), Scenario Modeling, Visualisation
Impact: Enabled strategic evaluation of logistics choices in real-world case applications.

CNC Machine Optimisation

Conducted time and usage analysis of CNC machines to identify production bottlenecks. Proposed shift-based improvements and established SOPs, leading to a 15% increase in machine productivity and reduced idle time.

Tools Used: Industrial Time Studies, Excel, Lean Process Analysis
Impact: Improved shop-floor efficiency and operator utilisation.

Process Improvement Dashboard (FIUH IT Solutions)

Created KPI-driven dashboards for internal operations and compliance tracking. Mapped legal requirements to customer needs and developed data-backed strategies to adapt HR software solutions.

Tools Used: Power BI, Compliance Analysis, SQL
Impact: Increased decision-making transparency and compliance accuracy.

Sales Reporting Automation

Automated recurring sales reporting processes by integrating Excel macros and advanced formulas. Reduced manual effort by over 60%, enabling faster turnaround and consistent reporting standards.

Tools Used: Advanced Excel, VBA (optional), Reporting Templates
Impact: Streamlined operations and improved reporting reliability.