Zust Bachmeier Hanover, Maryland. Account Receivable Analyst March 2024 – Present • Conduct daily bank reconciliations, employing VLOOKUP to accelerate processing.• Developed automated weekly accounting reports for clients' open invoices.• Utilize Excel for over 60,000 rows data exporting and cleaning, employing pivot tables to generate financial reports, balance sheets, and profit-by-customer tables. Create visualizations for company fiscal years to aid decision-making for the owner.• Quickly familiarized with accounting software within one week.• Proactively engage with clients to optimize cash flow and extend payment periods.

• Conducted complex financial analyses for five clients in diverse industries, including metal-casting, utilizing Solvency Ratios to evaluate debt repayment capacity and performance, earning commendations from the supervisor.• Utilized specialized accounting valuation models to accurately assess the value of various assets by Excel, including fixed, intangible, and equipment depreciation, streamlining the asset evaluation entry process by 50%.• Facilitated communication and alignment between technology and business cross-functional teams, resulting in a 20% reduction in handover process time for automotive value analysis projects.• Prepared and designed detailed Tableau financial reports and analyses promptly, supporting informed decision-making processes through clear and concise presentations.