Mackenzie Ellis Email & Phone Number

Cedar Falls, Ia, Us

Garden Grove, California, Us

-Successfully fulfilled contracts for various organizations totaling 15 months of experience in Administrative & Accounting roles.-Expedited collections for more than 600 past due invoices totaling over $1,500,000, reducing outstanding debt by nearly 60%.-Assisted in General Ledger Reconciliation (for example, parts inventory management and contractor payroll deductions & claims)-Assisted prospective clients through the application process including income qualification in compliance with federal regulation.-Conducted outreach efforts to reach targeted clients such as creating brochures, website updates, and social media posts.-Processed payments (credit card, direct deposit & check) directly from clients which included running checks weekly to deposit into company bank account.-Created and Improved file management system which allowed workers to find the information they needed quickly.

Waterloo, Iowa, Us

-Preformed data mining and cleaning techniques on CRM database, for example, purging 348 redundant entries which ultimately streamlined daily operations.-Improved Website UI, created various marketing materials (brochures, flyers, letters, etc.), managed social media accounts) & performed complex project management with several overlapping projects which ultimately led to raising over $25,000.

Omaha, Ne, Us

-Reviewed reports regularly, completed Months’ End Reconciliation, and ultimately submitted monthly Invoice to Client which included Staff & Craft workers’ hours, equipment hours, materials, etc.-Preformed A/P duties, including paying new invoices upon approval, submitting Goods Receipts, and invoice reconciliation if any discrepancies were detected.-Maintained and updated the Work Breakdown Structure and PO’s that described various cost centers.-Created 13 process documents with detailed instructions for all my work duties before our relocation to Iowa, which standardized cross-training protocols.

Washington, District Of Columbia, Us

-Successfully completed 2 contracted years of service with AmeriCorps, which is the domestic version of Peace Corps.-Updated data analysis capabilities in Excel databases by utilizing Pivot Tables, Visual Basic Applications (VBAs), and Macros which Improved data processing speed by an estimated 30%.-Decreased website load time 72% by conducting root-cause analysis to enact a strategy that included leveraging code optimization, image compression, and simplifying content.-Executed data-driven UI enhancements after Google Analytics audit resulting in a 15% decrease in customer bounce rate.-Conducted market research on 78 comparable facilities to create a data visualization proposal for off-season site rentals which estimated a revenue increase of 10-20%.-Planned, troubleshot, and oversaw a new VITA (Volunteer Income Tax Assistance) site which offered tax support that resulted in $5,400 collectively saved by participants with limited English proficiencies.-Created 17 internal training and 25 shareholder documents, with screenshots and graphics for enhanced comprehension.