Roman Z.

An expert with 12+ years of experience in investment banking, consulting, financial research and analysis, audit and accounting. Formerly employed with a Big-4 audit firm. CFA and ACCA candidate. Extensive experience with VBA, Excel, Word, Access, Powerpoint. Custom solutions in Excel and Google Sheets: • automation using VBA and complex formulas • dashboards, charts and reporting tools • macro and spreadsheet optimization and streamlining • multiple spreadsheets environments • Excel Solver and statistical analysis • Word and Access integrations, PDF creation and e-mail distribution • any kind of data processing and analysis using Pivot Tables, VBA and complex formulas Finance and accounting services: • financial modelling • ratio analysis • financial analysis and business valuations • preparation of budgets, financial and management accounts • academic assignments • Quickbooks Automation of Word, Access and Powerpoint Web scraping and data entry