Ari Pasternak

Over six years of experience as an analyst in multiple industries with strong capabilities for report making in Microsoft Excel.

Key accomplishments:
•Developed OPEX budget control report (BCR), using Excel VBA to instantaneously retrieve data from all business units, reducing time to create the report from 3 hours to one minute.
•Automated data-entry by developing VBA Add-Ins for Excel customized for our team’s tasks, simultaneously reducing workload and errors.
•Developed a comprehensive variance tool in Excel to analyze GL discrepancies, allowing for higher accuracy of accruals, journal entries, and month-end forecasts.
•Prepared monthly presentations for senior and executive levels that were insightful to finance and non-finance viewers.
•Automated month-end closing with Excel and VBA, reducing lead time by 75%.

Experienced bookkeeper with a strong knowledge of GAAP and IFRS.

• Managed payroll for a company of 50 employees.
• Successfully managed cash flow on day-to-day basis and forecasted cash balances by using Excel to import receivables, government remittances, and payroll.
• Developed new method for recording billable hours and directly comparing to estimates, centralizing reports and eliminating the need for data entry.
• Issued estimates and invoices, and client relationship management.
• Reduced A/R account by over 30% through creation of new collections process.