I can create for you a KPI Analysis Module in Excel to calculate the staff performance and its commission based on chosen parameters. The performance reports show results per period, person, working group and company levels. during the process, Excel validates the information, prepares a creates a structured database and pivot tables which enables to develop templates reports independently. the module is secured by usernames and passwords.
About me:
I am a financial expert and a guru in Excel/VBA/Macro. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I develop financial modules and financial projections including business valuation & terminal valuation methodology & ratios (INPV, IRR, DSCR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.) Furthermore, I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts.
I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in Financial Reports, accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation.