Huy Truong

● Researched 5+ technical publications, analyzed 10+ data sources, and examined 20+ enterprise dashboards to provide insights into urgent squadrons’ operational issues for senior leadership.
● Developed 5+ Extract-Transform-Load (ETL) processes to compute key metrics and Key Performance Indicators (KPIs) for the program office, solving a 30-year-old computational challenge and freeing up 80 hours per month for senior analysts to focus on higher-priority work.
● Designed a data pipeline to streamline a major aircraft compliance report, allowing squadrons to reinvest 1,000+ man hours annually in improving the Fleet’s operations.
● Partnered with contractors from Boston Consulting Group to design executive-level reporting dashboards using Tableau, SQL, and Power Automate within 3 weeks of joining the organization.
● Collaborated with the Chief Information Officer and senior leads to implement version control for Tableau dashboards using VS Code and Git, accelerating team-wide dashboard development by 200%.

● Saved $200K+ per quarter in labor costs by automating report generation using Microsoft Access, VBA, and SQL, producing 2,000+ Excel reports for cost forecasting.
● Designed a comprehensive database application for Human Resources that streamlined the manual tracking process of candidate hiring, enabling HR to allocate 30% more time toward strategic initiatives like reducing attrition rates.
● Implemented Natural Language Processing (NLP) techniques, including tokenization, n-grams, and word clouds to analyze 10,000+ task descriptions submitted by employees, enabling leadership to make key decisions on resource allocation.
● Conducted 5+ technical training workshops, assisted teammates with database schema design and rapid prototyping, and provided consultation on best practices for software development.

● Developed six predictive models in Python to forecast aircraft availability for squadrons. Recognized by senior data scientists for designing a unique visualization to compare model performance by R-squared and training time.
● Automated data extraction by writing Python scripts to parse 10+ heavily formatted Excel spreadsheets into CSV files, enabling the analytics team to build Tableau dashboards for senior leadership.
● Created an automated reporting system to track clock-ins for 500+ employees during the COVID-19 telework period, reducing the administrative burden on supervisors.