o Partnered with CityBus stakeholders to analyze ridership patterns and trends for different bus routes to determine optimal bus type allocation o Undertook extensive data preprocessing to combine and transform datasets into visualizations using various software tools like Excel, Power BI, and Tableau o Employed Excel and R for statistical analysis of weather and historical ridership data to analyze and forecast possible correlations in weather and boards/alights

o Performed analysis on a popular seasonal product with a sales increase of 46% and consolidated multiple SKUs into a Power BI dashboard to track KPIs over time o Tracked customer commitments vs. actual orders to call out discrepancies to decrease backlog on orders o Transformed and converted data retrieved from SAP into Power BI to improve upon a previous tracker used by Business Development o Constructed 2 new OPLs (One Point Lessons) for the Customer Order Management Network Ops. Team

o Streamlined a new website for the organization to increase click rates on various social media outlets o Pioneered a new mentorship program for underclassmen to increase the organization’s awareness to new and enrolled students o Managed a group of 3 officers to maintain workflow and manage the organization’s website, attendance files, and membership details

o Collaborated with the Operation Sustainment (OSC) group to increase efficiency of supply chain routes by a threshold of 50% for Infantry Units o Engaged in translating and interpreting during high level operations with senior officials (majors- generals) of both the US and South Korean armed forces (CCPT Exercise) o Supervised a group of ~10 subordinate soldiers within a squadron with the responsibility of roll call, weapons check, and welfare check

o Collaborated with elementary students to improve their English speaking and writing skillso Responsible for multiple small groups of 3-4 children