Assistant Manager
London, England, United Kingdom
Working in the Analytics & Modelling team within the Assurance group.Main tools used: SQL, Alteryx, Tableau, Excel, VBA, Python.• Co-founded a new accounting tool for complex reorganisations – Partnered with technical accounting team to build a new self-service tool, which enabled the team to win and deliver complex reorganisation projects. The tool drove £1m of incremental revenues while reducing manual workload by up to 70%. I was the technical owner of the tool and was responsible for requirement gathering, system design, end-to-end development, budgeting / cost tracking and supporting go-to-market efforts. The solution incorporated intuitive VBA enabled Excel input forms and an engine built on Alteryx.• Automated and cut client’s month-end process by 64% – Overhauled the month-end close process for 30+ entities of a global chemicals company, reducing close timeline from 14 days to 5 days. Developed a model that used SAP extracts to automatically prepopulate individual pro forma financial statements and create consolidated Group reports using VBA.• Reconciled large datasets to streamline audit projects – This commonly involved extracting data from the client’s SAP or other accounting software databases consisting of hundreds of millions of rows; processing the various tables within Alteryx/SQL and then reconciling the platforms, i.e. Payment Systems → Journals → Bank Statements. Built dashboards in Tableau/PowerBI tailored to the client to visualise the data showing key insights for various stakeholders and revealing discrepancies that need further investigation.• Co-founded the Alteryx Centre of Excellence – The centre is responsible for promoting the tool, showcasing projects, and providing L&D resources. I introduced an Alteryx Build Guide to harmonise workflow structure and layouts across the team to allow easier review and handover processes.