Mary Brown

- Worked with the CFO to develop a comprehensive understanding of the accounting processes that existed. Then created automation solutions streamlining processes, reducing errors, and improving efficiency primarily through VBA scripts for the AR and AP departments.

- Established and lead a team with the goal of maintaining the day-to-day automations.

- Developed a VBA ad hoc reporting tools which generated reports to quickly identify pay-table discrepancies, accounting errors, provided forecasting reports.

- Implemented script validation checks and error handling mechanisms to ensure the accuracy and integrity of automated processes.

- Led the migration project from Sage 300 to Workday, overseeing all phases of the conversion process, including planning, data mapping, testing, and implementation.

-Trained each accounting department on navigating the new Workday platform, troubleshooting issues, and documenting the new procedures.

- Prepared monthly financial statements, variance analyses, and additional analytical reports for senior management.

- Collaborated with external auditors to ensure compliance with regulatory requirements and facilitate the bi-annual audit processes.

- Maintained merchant accounts, analyzing transaction data and ensuring all the chargebacks were within the merchant requirements.

- Create KPI's (Key Point Indicators) in Excel to identify chargeback trends to recognize root causes. Then implemented proactive measures to reduce future chargebacks.

- Designed and developed a comprehensive VBA-based system to automate payroll/ commission calculations for multiple sub-companies, reducing processing time by 50% and minimizing errors.

• Identified process improvements for cash application procedures, resulting in reduced errors and improved efficiency.
• Creating VBA scripts to automate the application of cash to the correct customers.
• Developed customized reports for management in Excel, highlighting trends and key metrics related to AR.
• Analyzed payment trends from clients to identify potential issues proactively and maintain healthy cash flow.