Demand Planner Toolkit — Excel
An Excel demand-planning workbook: 18 months of demand forecast with moving average and exponential smoothing, accuracy measured by MAPE and bias, safety stock and reorder point at a 95% service level, and a six-month PSI (production–sales–inventory) plan built on live formulas. View on GitHub ↗
Quality Inspector Toolkit — Car Manufacturing
An Excel inspection toolkit for automotive manufacturing: incoming parts judged against specification with automatic PASS/FAIL, a final-inspection defect Pareto, a 12-point final vehicle checklist, and an 8D corrective-action log. View on GitHub ↗
SQL Data Quality Checks
Eight SQL data-quality checks executed against sample order data — duplicates, orphan records, invalid and missing values — with a written findings report: 11 of 15 sample orders carried at least one defect. View on GitHub ↗
Excel Data Quality — Supplier Orders Cleanup
A messy supplier-orders file cleaned and validated in Excel: duplicates removed, formats standardised, a unit-price variance check, live validation formulas, and summary reporting — the finished workbook is formula-verified. View on GitHub ↗
QA Testing Suite — Demo Web Shop
A complete manual test cycle on a demo web shop: test plan, 15 test cases, defect log, and summary report — executed for real, with all 15 cases passing. View on GitHub ↗
Power BI Quality & Delivery Dashboard
A Power BI dashboard for defect rate and on-time delivery built from weekly quality metrics, documented end to end: dataset, DAX measures, and step-by-step build instructions. View on GitHub ↗
Low-Speed Flying Demo of a Hypersonic Transport Vehicle
B.Tech capstone at Vel Tech (team of three): a 1:1000 scale-down of MBDA France’s hypersonic transport concept, modeled in CATIA V5 with ANSYS Fluent CFD at 50 m/s to evaluate lift, drag, and moment coefficients and elevon efficiency.
Graduate Capstone & Applied Business Research
Used quantitative and qualitative methods to investigate technology-management operational bottlenecks at the University of Bridgeport.
Lean Manufacturing & Process Optimization
Applied 5S, Kaizen, and Value Stream Mapping to manufacturing case studies focused on eliminating operational waste.
Supply Chain Risk Analysis
Built mitigation frameworks addressing global disruptions across demand forecasting, logistics, and supplier networks.