Aidan Law.

1. CAD & Quality Checklist Automation (C# & SolidWorks API)
To eliminate drafting bottlenecks in high-mix, low-volume custom manufacturing, I engineered a standalone C# application that interfaces directly with the SolidWorks API. The tool automates parametric 3D modeling, drawing layout, view scaling, dynamic dimension ballooning, and first-piece quality control checklists. By automatically populating critical properties and notes, the software slashed drawing lead times from up to 45 minutes down to under 30 seconds across more than 1,000 custom parts annually.

2. Coating Offset Math Engine (C# & ASME/ISO Thread Math)
Precision machining for plated fasteners requires complex geometric calculations to offset thread profiles prior to surface treatments. I developed an algorithmic engine in C# that automatically recalculates ASME and ISO thread profiles and pitch tolerances based on user-specified plating thicknesses. This converted over an hour of manual math into instant code execution, delivering exact pre-plate tolerances directly to 5-axis CNC operators and quality inspectors.

3. Quality Calibration System Overhaul (Python & ISO 9001 / AS9100D Compliance)
To overhaul plant-wide metrology management and ensure compliance with ISO 9001 and AS9100D standards, I authored official corporate Standard Operating Procedures (SOPs) for calibrated equipment and built a Python inventory optimization tool. The script analyzes gage usage patterns, floor availability, and failure rates to stagger external recalibration cycles and identify redundant tooling for storage or retirement. This reduced annual external calibration costs by 75% while raising shop-floor tool availability by 25%.

4. Design for Manufacturability (DFM) & Blueprint Conversion
Serving high-precision aerospace and defense clients requires translating complex customer blueprints into standardized internal manufacturing plans. I analyzed customer GD&T callouts, thread specifications, and tolerances to build floor-ready SolidWorks production drawings optimized for 5-axis CNC turning, passivation, and captive assembly operations, ensuring full compliance with part quality assurance standards.

1. Automated Reporting Pipeline (Python, SQL & VBA)
To streamline monthly operational reporting, I re-engineered a labor-intensive manual workflow into an automated end-to-end data pipeline using Python, SQL, and Excel VBA. The pipeline automates data extraction, transformation, cleaning, and deck generation, reducing process cycle times from several hours to 5 minutes while eliminating recurring manual data-entry errors.

2. Campaign Data Validation & Automation (Python)
Working with high-volume marketing datasets, I implemented root-cause analysis and data validation routines to identify and fix operational bottlenecks. I authored custom Python scripts to validate data integrity and automate stakeholder status updates, improving data accuracy and accelerating cross-functional execution cycles.

3. Operational Analytics & Business Dashboards (Power BI & SQL)
To drive data-informed decision-making across leadership teams, I conducted statistical analyses across datasets exceeding 100,000 operational records. I designed interactive Power BI and Excel dashboards that synthesized complex performance metrics into clear visual insights, directly informing campaign optimizations and pricing strategies.