Gurbain Singh Dua

Data Analytics Assistant Manager @KPMG UK

London, GB

Automated audit scoping with Alteryx and PowerBI, visualising key metrics based on dynamic selections that improved quarterly financial analysis for a multinational CPG company.• Recalculated margin using both independent and client FX rates with 100% accuracy, enabling data driven insights into the reasonableness for a leading global foreign exchange services provider.• Developed an Alteryx and SQL routine to recalculate profit of one of the largest UK bookmakers, analysing over 1 billion records and achieving a match rate above 99.5% to enable early detection of misstatements and provide assurance over reported financial statements.• Built and maintained a PowerBI dashboard for P&L risk assessment, defining and visualising key metrics to measure performance across different aspects of the business, integrating aggregated journal views, anomaly detection, and trend analysis that improved risk identification and financial oversight for a large UK energy company. • Led the development of a routine in Alteryx and Python to automate the generation of workpapers, saving 600+ audit hours annually for one of the largest insurance companies in the UK.• Managed the development of Alteryx and SQL routines to identify contra entries through dynamic criteria, enhancing general ledger analysis efficiency across 100+ engagements annually.• Facilitated walkthroughs with senior Risk and Economics stakeholders on client-developed Alteryx models to validate accuracy and compliance, delivering 15+ actionable insights that improved model accuracy.• Mentored 2 new team members on standard operating procedures (SOPs) and best practices, resulting in a 20% faster onboarding process and positive feedback.

Amity University

Bachelor of Technology, Computer Science and Engineering