Work History
Executive Assistant & Technology Consultant - 3 Years
Overseeing management of 20 apartment communities with 2000 residential units. As well as planning and implementing various workflow improvements
- Migrated company to using Office 365 and Teams to increase productivity and implement more efficient workflows 1
- Built more efficient Excel files using formulas, VBA, and UserForms, saving weeks’ worth of man-hours and reduced margin of error significantly 2
- Coded automatic functions in Power Automate to create file backups
- Coded automatic emails in Power Automate to be sent to managers based on missing items
- Created documentation for our managed service provider to maintain all workflows and ensure continued functionality
- Provided weekly reports on occupancy and rent delinquency to internal stakeholders
- Regularly performed extensive analysis of billing data to ensure consistency between expected and received rental income at stakeholders' requests
- Coordinating with staff to ensure deadlines and targets are met
- Maintained companywide calendar
- Scheduled and ran interviews
1 Our on-premises Exchange server was at its End of Life. Since the company operated from 20 locations, I took the initiative to lead the company on transitioning from on-premise Microsoft Exchange 2013 to cloud-based Microsoft Office 365. By shifting the company workflow to Teams and SharePoint, staff could work with increased efficiency and always have access to up-to-date files, saving both time and money.
2 The day-to-day Excel files used by the company were outdated and no longer user-friendly, as they prompted the same information multiple times within a single Excel file. I improved our regular user reports and condensed others to create a more accessible system. By creating a method for information to feed from tables to a dashboard, the sheets could be formatted and protected, which reduced the amount of work required to update and maintain the files and reduced user error.
Human Resources & Accounts Receivable - 3 Years
Running day to day operations for 2 Service-Disabled Veteran-Owned Small Businesses
- Website design for Air Force Reserve contract
- Payroll management using ADP
- Finance management using Quickbooks Online
- Head of employee hiring and onboarding
- Reviewed procurement listings to source relevant government contracts