Data Intern for Student Affairs - University of North Texas, Frisco

​

· Cleaned and scraped data to determine trends and help influence the decisions of the University

· Described and presented the issues within UNT at Frisco’s data collecting methods in regards to virtual and in-person contact tracing to ~45 UNT at Frisco leaders

· Created a new method of collecting the contact data enabling less error and ease of use through data validation

 

Data Analytics Intern - NT Logistics

· Masked over 14,000 rows of data in excel and helped create demo reports using advanced Power BI skills (disconnected slicers, DAX functions for calculations and date formatting) for the purpose of generic reporting

· Appended ~ 8,000 rows of data and used advanced Excel formulas (nested if/not/or/left, V-lookup, left/find) for the purpose of maintaining a monthly invoice report for a client

· Maintained weekly reports with great attention in Power BI that were sent to clients, utilized Mcleod (Transportation Management System), and worked alongside dispatch users to ensure proper data within the reports 

​

Operational Data Analytics Intern - First United Bank

​

· Starting late May 2022

​

 

​

​

​

​

​

​

​

​