Gui Vendemiatti Email & Phone Number

Reston, Va

• Developed macro-enabled Excel files to assist 56 Illinois rural transit agencies in submitting to National Transit Database.• Coordinated with MTA’s Transit Asset Management stakeholders to project future enhancements and replacements.• Created Kimley-Horn Asset Management Survey, an R Shiny app used for asset risk management and maturity assessments.• Updated Fairfax County travel demand models on CUBE, considered different network alternatives and presented findings.• Organized and presented a Microsoft Power Series tutorial to leadership (Power BI, Power Query, Power Automate).As an on-site consultant to the Maryland Transit Administration Office of Performance Management:• Discovered new applications for agency’s big datasets (such as GPS pings stored on SQL servers) and small datasets (such as staff survey data) engaging with scheduling, operations, finance, procurement, maintenance, and asset management teams.• Extracted and analyzed speed and runtime data from Automatic Vehicle Locators using Swiftly and R and coordinated insights with Dedicated Bus Lane team responsible for adding seven miles of new dedicated bus lanes in Baltimore.• Created over 20 Power BI reports and dashboards, tracking in real-time, “finger-on-the-pulse” operational statistics which served as the cornerstone of six performance programs across all modes of transit, engaging bi-weekly with CEO and COO.• Created the Operator Report Card, using R and Power BI, to consolidate on-time performance, worker attendance, gate departures and customer complaint metrics allowing management to better enact both disciplinary and laudatory measures.

Blomquist Gym - 617 Foster Streeet, Evanston, Il

• Managed two Northwestern gyms: Blomquist and Patten.• Aided customers with daily activities and oversaw facility operations.• Provided medical assistance in emergency situations. Cared for injured patrons until professionals arrived. • Responsible for scheduling a team of about 25 monitors and 20 supervisors; approved shift covers and schedule changes.

Greater New York City Area

• Developed and updated standard operating procedures using Word, decreasing impact of turnover within Supply Logistics• Rationalized monthly arbitration process by creating auto-refreshing Excel tool based on a set of various logical rules • Resolved complications with dependent demand explosion process in SAP, resulting in 6% higher forecast pass accuracy

Cochabamba, Bolivia

• Oversaw inauguration of 3 dentistry clinics. • Collaborating with 3 interns, designed and conducted a comprehensive survey of partners’ consumer behavior and applied results to analyze prices and project future demand.• Advertised new clinics and services by creating and distributing 2,000 brochures and impacting 14,000 clients.

Draper, Ut

• Revised company Excel workbooks; evaluated and created various accounting formulas to analyze loan portfolios.• Directed research and reported data on advantages of opening a Mentors branch in Nepal and Papua New Guinea.• Analyzed a survey of 600 Mentors; formulated regressions, tested hypotheses, and demonstrated findings to management.

11507 S Pkwy Plaza Dr, South Jordan, Utah

• Led a team of 5 to 8 employees in the most profitable Jamba Juice in Utah; assigned weekly cleaning jobs to Team Members, managed labor productivity by calling workers on/off and allocating breaks, and interviewed Team Member applicants. • Handled customer feedback both in-store and on the phone; reported feedback to General and District manager. • Organized a push for food waste reduction. Developed a prototype for a device that minimized spilt frozen fruit by 5%.

Triple Major: Economics, Statistics, International Studies - Minor:Transportation

Activities and Societies: Sailing Team, Project Wildcat, ISBE Analytics, Delta Sigma Pi, Competitive Intramural Sports.

High School Diploma

Activities and Societies: Percussion Ensemble, Debate, South Jordan Youth Council