Skip to main content
SM
Looking for a job

Spandan Mohanty

@spandanmohanty

Senior Data Analyst at KPMG Resource Centre Pvt. Ltd. who automated audit workflows and cut manual data-review time by approximately 35%.

India
Message

At KPMG Resource Centre Pvt. Ltd., I designed SQL and Azure Databricks SQL queries that automated audit workflows, cutting manual data-review time by approximately 35%.

I built Alteryx workflows to reconcile Journals data against Trial Balance and General Ledger records, reducing reconciliation turnaround time by approximately 40%. I also developed validation logic to flag unreconciled or anomalous journal entries.

I developed ETL pipelines integrating SAP ERP and other datasets, processing upward of 5 million records per audit cycle on Azure Databricks. I also implemented Delta Lake structures and validation logic, reducing data-quality exceptions by approximately 30%.

At KPMG, I developed 25+ Power BI dashboards for risk scorecards, controls monitoring, and executive reporting. Previously, as a Business Analyst at Tata Consultancy Services Ltd., I created KPI-driven reports and supported Salesforce Cloud transformation; at Infosys Limited, I worked on a Hospital Management System web application.

Experience

Work history, roles, and key accomplishments

KPMG Resource Centre Pvt. Ltd. logoKL
Current

Senior Audit Analyst / Senior Data Analyst / Business Analyst

Oct 2021 - Present (5 years)

Designed and optimized SQL and Azure Databricks SQL queries to automate audit workflows, cutting manual data-review time by approximately 35%. Built Alteryx workflows to automate reconciliation of Journals data against Trial Balance and General Ledger records, reducing reconciliation turnaround time by approximately 40%.

IL

Associate System Engineer

May 2018 - Nov 2018 (6 months)

Engineered a comprehensive Hospital Management System web application (Python, .NET, C#) to manage user authentication and streamline role-based access across 4 user roles. Automated patient data management and discharge certificate generation via a secure, role-specific portal, reducing manual processing time by approximately 25%.

Education

Degrees, certifications, and relevant coursework

SR

Siksha 'O' Anusandhan, Institute of Technical Education & Research

Bachelor of Engineering, Electronics & Communication Engineering

Bachelor of Engineering in Electronics & Communication Engineering, graduated in May 2018.

SI

Simplilearn

Data Science with Python, Data Science

Completed Data Science with Python certification, co-sponsored by IBM.

Tech stack

Software and tools used professionally

Interested in hiring Spandan?

You can contact Spandan and 90k+ other talented remote workers on Himalayas.

Message Spandan

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan