Data Analysis Analytics

AIONA LAWRENCE

********@*******.*** 201-***-**** www.linkedin.com/in/aiona-lawrence

EDUCATION UNIVERSITY AT BUFFALO, The State University of New York Master of Science, Business Analytics (STEM), June 2024 UNIVERSITY AT BUFFALO, The State University of New York Bachelor of Science, Business Administration, June 2023; Cum Laude Concentration: Management Information Systems and Data Analytics TECHNICAL SKILLS Desktop Applications: MS Word, PowerPoint, Access, Excel (Pivot Tables and Charts, Data Analysis ToolPak, IF and Nested Formulas, VBA, Macros and Power Query), Teams Software Language: HTML, Python, Java, JavaScript, MATLAB Data Visualization: Power BI, Tableau, Salesforce Lightning, DOMO, R & RStudio Database & Cloud: SQL, MySQL, Snowflake, Oracle, Amazon Web Services (EC2), BigQuery Cybersecurity: Splunk

EXPERIENCE UB Student Engagement, Buffalo, New York Student Governance & Organizations Operations Intern, July 2023-Present

• Efficiently managed administrative functions and all back-end processes in UBLinked

(Anthology Engage - UB's virtual involvement platform), overseeing club registration, event approval, involvement imports, elections, paths, forms, and experience imports.

• Developed and implemented a complementary database to the existing virtual involvement platform, significantly enhancing data analysis capabilities. This initiative resulted in a 40% reduction in manual data processing time, allowing for quicker extraction of statistics and more efficient decision-making.

• Analyzed and visualized program attendance data to extract informative insights on the demographics of attendees

• Responded promptly to correspondents related to the system, demonstrating critical thinking skills to troubleshoot and solve problems effectively.

• Developed resource pages, training materials, instructional videos, and FAQs to assist students, staff, and faculty in understanding best practices for student organizations.

• Collaborated on inclusive assessment efforts to understand organization needs and make informed decisions about future programming and support.

• Conducted research and benchmarking activities with other institutions to stay informed about industry trends and innovative practices.

Robert Half, San Ramon, California (Remote)

Operations Analyst Intern, June 2022-August 2022

• 2022 Summer Intern supporting corporate business transformation and remote work operations of an international talent solutions firm.

• Categorized and evaluated 5000+ technical support incidents to identify operational efficiencies for Contractor laptop deployments.

• Presented findings to Sr. Leadership and provided actionable recommendations to reduce candidate technical issues.

• Extracted location data for 15k+ placements and built a prototype to calculate distance via Excel utilizing longitude and latitude data associated with zip codes.

• Evaluated quarterly online form inputs to identify trends of inaccurate and/or suspicious data.

UB South Lake Village, Buffalo, New York

Community Assistant, August 2021-Present

• Provide customer service and on-call emergency response to 600+ residents of apartment complex.

• Create and budget for monthly programs aimed at community building and academic success.

• Utilize resident life database to monitor and address needs of community.

• Effectively mediate arguments and conflicts among residents for a better living environment.

UB School of Management, Buffalo, New York

Teaching Assistant, August 2021-May 2022

UB Campus Living, Buffalo, New York

Student Assistant, July 2020-July 2023

BADGES Connect to and Transform Data, Tableau

Hands on Essentials – Data Warehouse, Snowflake

Insights from Data with BigQuery, Google

LEADERSHIP UB Pride and Service Award Winner, April 2023 Team Leader, Alternative Spring Break – Civic Engagement, Spring 2023 Dean’s List, Fall 2023

Volunteer, Alternative Spring Break – Civic Engagement, Spring 2022 Jury Member, UB Academic Integrity Adjudication Committee, Winter 2021 Secretary, UB School of Management Giving Council, Fall 2021 Student Participant, UB Virtual Leadership Academy, Spring 2021

Contact this candidate