Data Engineer UL Solutions
RF test data for hardware compliance testing
- Cut end-to-end test-cycle analysis from 2 days of Excel work to 30 minutes by automating RF test-data collection and visualization with Python across 60+ test stations
- Delivered a Python and React validation app that analyzes 1M+ RF test records and 1,000+ plots per test, cutting manual review from ~30 minutes to ~5 seconds
- Unified 12+ RF test-case formats with different column sets into one queryable Delta table using Delta Lake mergeSchema, so new test types don't break the pipeline
- Wrote PySpark transformations and Spark SQL with joins and window functions. Date partitioning cut RF query time by 20%
- Developed 5+ Tableau dashboards on Delta tables that show RF test results to 3 client teams and 20+ internal engineers