Utsav Gohat

I’m a Data Analyst with 1 year of hands-on experience delivering business insights and automated dashboards for finance and operations teams. I focus on data cleaning, KPI tracking, and stakeholder reporting, turning messy datasets into reliable, decision-ready outputs.

At Koch Business Solutions India Pvt. Ltd., I analyzed 1M+ general ledger transaction records to detect anomalies and irregular posting patterns that affect month-end close. I performed EDA across 50+ GL accounts, built SQL/Python data pipelines (Snowflake → AWS S3 → Amazon Redshift) for near real-time analysis, and automated journal-entry identification by posting regularity—reducing manual review volume by 60–70% for finance teams.

I also built an internal AI-based Finance Research Assistant (Natural Language to SQL) that enabled 10+ finance users to access general ledger and reporting data without manual SQL. By supporting 20+ finance tables and 30+ reporting scenarios, I reduced ad-hoc query and reporting turnaround time by 70–80% during month-end close, while improving reliability through controlled APIs and troubleshooting 15+ recurring pipeline issues that cut reporting delays by 30%.