
Shwetank P.
Google Sheets Apps Script Automation and Power BI Expert
Skills

Bekijk mijn diensten

Werkervaring
Deputy Manager - Operations and Analytics
CHANDIGARH UNIVERSITY
Aug 2025 - Present • 1 yr 3 mos
- Built an AI (Gemini LLM) + Google Apps Script workflow that converts 40+ unstructured emails/day into structured tracker rows across 10+ Google Sheets, saving 20+ hours/week. - Added human-in-the-loop review, validation rules and duplicate checks, cutting data-entry errors by ~50%. - Built rule engines for automated mail routing and workload-based task allocation, with rules kept in config so changes need no code. - Built and own a Power BI analytics dashboard (Power Query, DAX, star schema) covering 20,000+ records, used by senior leadership for monthly reviews. - Replaced manual consolidation of 20+ trackers with linked Google Sheets models, cutting weekly reporting time from 3 hours to 40 minutes.