Headline

MIS & Data Analyst | Python, SQL, Power BI, Google Apps Script | Reporting Automation & Internal Analytics Tools | Monetization Analytics @ NoBrokerHood

About

I'm a Data Analyst who turns messy, manual operational work into automated systems people can actually trust. At NoBrokerHood ,I work on the Monetization Analytics team, where most of my work starts the same way: a number nobody can explain, a report that eats days of someone's week, or a decision stuck waiting on one person. I find out why, then build something so it doesn't happen again. What that has looked like: - SocieTiQ: a web app that builds a society's monetization plan from its location and size. Plans used to wait for a senior BDM's review, and quotes were sometimes too high. Pricing now follows belt-level payout data across 4 tiers and 11 campaign formats, and sales gets a client-ready Excel on the spot. - CampaignIQ: a role-based dashboard and email automation for brand campaign permissions. Updates used to depend on one person compiling them, with no fixed format. Now one campaign ID returns the full summary across 3 teams, data refreshes hourly, and managers and directors get a formatted status email daily. - Unolo CRM automation: three tools that sync CRM files to Google Drive, download field reports and photos into brand-wise Drive folders with a live performance dashboard, and validate and assign field tasks across 8 cities with a duplicate check. Together they cut manual work on Drive filing, reporting and task assignment by ~90%. - Proof-of-Execution validation: a Python + Tesseract OCR pipeline that extracts brand, date and GPS from field documents and uses Haversine distance to flag location mismatches, cutting manual verification ~90%. - Lift Occupancy report: rebuilt a weekly report that took 3–4 days across multiple people into a Google Apps Script workflow, cutting turnaround ~80%. - KPI dashboards: consolidated 8+ operational datasets into Looker Studio and Google Sheets dashboards used by senior stakeholders. - Duplicate detection: a pHash + xxHash workflow that removes duplicate and near-duplicate field records before they reach the audit queue. Across these, I've eliminated roughly 80–95% of the manual reporting workload. What I care about more is that teams can now act on the data without second-guessing it. Tools: Python, SQL, Google Apps Script, JavaScript, Power BI (DAX), Looker Studio, Snowflake. I'm most useful where "the data's a mess and nobody trusts the dashboard" is the starting point. Open to Data Analyst and BI Analyst roles: sakethabhi11@gmail.com

Location

Greater Bengaluru Area

AI stack

claude code

deepseek

gemini

grok

openai

ChatGPT

Work experience

MIS Executive Analyst at NoBrokerHood, Jul 2025 - Present · 1 y 3 mo, Bengaluru, Karnataka, India, - SocieTiQ — Built a web app in Google Apps Script that generates a society's monetization plan and revenue projection from its location and size, using belt-level payout data across 4 tiers and 11 campaign formats. Removed the wait for senior BDM review and standardized pricing that was sometimes quoted too high. - CampaignIQ — Built a role-based dashboard and daily email automation that returns a full campaign summary across 3 teams from one campaign ID, refreshed hourly. Replaced manually compiled, unformatted updates that depended on one person. - Unolo CRM Automation — Built three tools that sync CRM files to Google Drive, download field reports and photos into brand-wise Drive folders with a live performance dashboard, and validate and assign field tasks across 8 cities with a duplicate check. Cut manual work on Drive filing, reporting and task assignment ~90%. - POE Validation Pipeline — Built a Python + Tesseract OCR system that extracts brand, execution date and GPS from Proof-of-Execution documents and applies Haversine distance to flag location mismatches. Cut manual verification ~90% across multi-city field operations. - Lift Occupancy Report Automation — Rebuilt a weekly report that took 3–4 days across multiple team members into one Google Apps Script workflow, cutting turnaround ~80% and removing cross-team dependencies. - Duplicate Detection System — Combined pHash and xxHash to catch duplicate and near-duplicate field-execution records before they reached the audit queue and reports. - Centralized KPI Dashboard Suite — Consolidated 8+ operational datasets into Looker Studio and Google Sheets dashboards, giving senior stakeholders real-time monitoring in place of fragmented manual tracking. - Reporting Automation — Standardized MIS reporting across multiple cities into automated workflows, reducing manual reporting workload ~90%.

Data Analyst at SmartInternz, May 2023 - Jul 2023 · 3 mos, Built an ML model using Random Forest to predict medical insurance costs. Performed data cleaning, preprocessing, and visualizations using Python libraries. Shared key insights with stakeholders to support predictive analysis goals.

Education

Bachelor of Technology - BTech, Computer science and engineering, Vellore Institute of Technology