CIVITTA Annual Review 2018 | Page 42

BUSINESS PROCESS AUDIT AND DEVELOPMENT Industry: IT CIVITTA team: Finland multinational IT security company with 30 offices and 2000 employees around the globe asked CIVITTA to conduct a renovation project of several tools used in finance, accounting and HR. Tools included a lot of manual work phases, requiring labor to process significant amount of information and being prone to errors. Our team specified the desired outcomes and main issues in current tools with the Client. 22 Tool renewal was conducted by improving processing of various calculations and visualizations with advanced Excel formulas, VBA macros and Tableau. Contin- uous check-ins were conducted with the Client end users to validate the progress. The deliverables from CIVIT- TA improved work efficiency and helped to achieve better quality of results since the manual workload was signifi- cantly reduced and automatic validation rules were added.