s
shwetankpand154

Shwetank P.

@shwetankpand154

Google Sheets Apps Script Automation and Power BI Expert

India
About me
I help businesses save hours of manual work by automating Google Workspace and turning raw data into clear dashboards. - Google Sheets automation with Apps Script: auto emails, data routing, reports, triggers - Gmail automation: auto-forwarding, emails to Sheets, scheduled mails - Auto-generated Google Slides reports from Sheet data - Power BI dashboards with DAX (Microsoft PL-300 certified) - Data cleaning and SQL analysis I've built real automations that cut multi-hour tasks to minutes. Clear communication, on-time delivery.... Read more

Skills

s
shwetankpand154
Shwetank P.
Offline • 
Average response time: 1 hour

See my services

BI Analytics
I will create interactive power bi dashboards and reports for your business

Work experience

CHANDIGARH_UNIVERSITY

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.