Data Reports Analyst  |  Excel VBA Automation \ Accounting

• Developed and maintained complex Excel spreadsheets and VBA macros to automate data analysis and reporting processes. • Conducted data cleansing and transformation activities to ensure accuracy and consistency of data used in reports. • Analyzed large datasets using Excel functions and pivot tables to identify trends, anomalies, and insights to inform business decisions. • Created automated workflows using VBA to reduce manual data entry, improve data accuracy, and save time.

• Developed and maintained advanced Excel/VBA scripts to automate the generation of monthly income statements, enhancing reporting accuracy and reducing manual processing time. • Streamlined Appfolio Reports API to produce automated, dynamic reports and dashboards that provide real-time insights into company financials, significantly aiding strategic decision-making for senior management.

- Automated Data Processing: Proficient in writing VBA macros to automate repetitive tasks, such as data cleaning, formatting, and report generation. - Custom User Forms: Experienced in designing and implementing custom UserForms to enhance data input and improve user interaction within Excel. - Advanced Data Manipulation: Skilled in using VBA for complex data manipulation, including filtering, sorting, and merging data from multiple sources.