Andrea Li Email & Phone Number

New York, New York, United States

Department Of Kinesiology

- Develop and maintain automated budget and scheduling systems using Microsoft Power Automate to free up to 50 hours of manual work each month- Streamline data analysis for payroll and course scheduling through the usage of PivotTables and formulas in Excel (i.e. INDEX and LOOKUP)- Implement ETL processes for over 125 courses to enhance data accuracy and productivity for the creation of easily interpretable datasets across multiple teams- Spearhead the migration and establishment of… Show more - Develop and maintain automated budget and scheduling systems using Microsoft Power Automate to free up to 50 hours of manual work each month- Streamline data analysis for payroll and course scheduling through the usage of PivotTables and formulas in Excel (i.e. INDEX and LOOKUP)- Implement ETL processes for over 125 courses to enhance data accuracy and productivity for the creation of easily interpretable datasets across multiple teams- Spearhead the migration and establishment of data governance guidelines of over 10,000 files from computer hardware to SharePoint to ensure secure and efficient acces- Assist with travel arrangements including organizing, booking, and expense reconciliation Show less

- Maintain smooth operations and high standards of customer service during high-volume rushes- Retain knowledge of current promotions, exchange guidelines, payment policies, and security practices- Improve sales by tracking company inventories, moving excess stock, and arranging product placements- Alerted management to potential security issues, supporting loss prevention and reducing shrink- Operated cash register and POS to process sales transactions and handle payments-… Show more - Maintain smooth operations and high standards of customer service during high-volume rushes- Retain knowledge of current promotions, exchange guidelines, payment policies, and security practices- Improve sales by tracking company inventories, moving excess stock, and arranging product placements- Alerted management to potential security issues, supporting loss prevention and reducing shrink- Operated cash register and POS to process sales transactions and handle payments- Promoted benefits of customer loyalty programs to encourage repeat business Show less

Storrs, Ct

- Reframed office operations through emphasized procedural organization and Excel database building- Trained students in technical protocols and policy outlines within the College of Liberal Arts and Sciences- Eliminated potential time conflicts between institution’s courses in regards to course scheduling, appointment, and labor budgeting- Interacted with over 100+ vendors, contractors and professional services personnel to receive orders, direct activities and communicate… Show more - Reframed office operations through emphasized procedural organization and Excel database building- Trained students in technical protocols and policy outlines within the College of Liberal Arts and Sciences- Eliminated potential time conflicts between institution’s courses in regards to course scheduling, appointment, and labor budgeting- Interacted with over 100+ vendors, contractors and professional services personnel to receive orders, direct activities and communicate instructions- Managed online travel inquiries and assisted professors, graduate students, and outside professionals with travel reimbursements Show less

Mashantucket, Ct

- Presented positive first impression of establishment's high standards by delivering exceptional service- Remedied guest complaints and escalated serious issues to restaurant manager for prompt resolution- Supported servers and bussers through high-volume shifts with food running and table clearing- Adhered to sanitation and safety control policies to protect establishment and patrons.- Communicated with patrons to record reservation data into company management system

Greater New York City Area

- Prioritized multiple tasks in dynamic environment and stayed calm and composed- Exchanged merchandise for customers and accepted returns- Maintained knowledge of current sales and promotions, policies regarding payment and exchanges, and security practices- Communicated with management and team regarding service-related issues and shortages