Vic Ofori

I turn messy engineering and operational data into dashboards and decisions using SQL, Python, and careful data cleaning. In my Aircraft Manufacturing Engineering Intern role at Shenyang Aerospace University’s KLFSND, I refined aerospace component models with CATIA, validated material-selection criteria from collected datasets, and supported structural simulations in ANSYS and MATLAB.

On reliability and retention projects, I analyzed years of aviation incident and maintenance records (~5,000 entries) with Python and SQL to find failing-system patterns and reliability trends, including data quality validation and workflow documentation. I also ran regression analysis on workforce data (1,000+ records) with Python and R to identify turnover predictors.

Now, as a Student Consultant and Analyst at M&M Strategic Solutions (remote), I’m building a functional KPI reporting dashboard prototype for small business owners and translating survey findings into dashboard design requirements—using Google Sheets with the option to replicate in Tableau or Power BI.