Supply Chain Analytics Intern
Drove operational intelligence, enterprise AI automation, and custom Python software tools across the Business Unit Operations (BUOP) team within Global Supply Chain and Repair.
Single Source of Truth Power BI Dashboard & Lean Six Sigma
- Developed a comprehensive Single Source of Truth Power BI dashboard consolidating all mission-critical operational KPIs for the BUOP team.
- Integrated data feeds across disparate Power BI reports, querying centralized data warehouses via Google BigQuery.
- Engineered a dynamic gauge system that adjusts contextual thresholds in real-time according to KPI health relative to specific timeframes.
- Applied Lean Six Sigma principles by constructing Pareto charts for root-cause defect analysis and time-series models for trend forecasting.
- Delivered ~$2,000 in direct operational cost savings, qualifying for and earning the Lean Six Sigma Yellow Belt certification.
BUOP Department SharePoint Portal & Gemini Enterprise AI Agent
- Built and launched the official BUOP department SharePoint portal to dramatically improve cross-team visibility within the Global Supply Chain and Repair organization.
- Constructed an interactive departmental escalation chart mapping escalation paths and ownership hierarchies.
- Prototyped a Gemini Enterprise Agent that integrates with the escalation chart to streamline, triage, and route all major operational escalations.
Python Bill of Materials (BOM) Comparison Tool
- Engineered a standalone Python desktop application equipped with an intuitive Graphical User Interface (GUI) for complex BOM differential analysis.
- Architected dual comparison modes: high-throughput batch processing for bulk multi-level assemblies and a one-to-one mode for granular component diffing.
- Streamlined agile workflows across engineering and supply chain teams, reducing manual comparison processing time by over 5 hours per run.