Open to opportunities

Kedar Gaonkar

@kedargaonkar

Message

I’m a Data & Reporting Analyst automating analytics with SQL, Python, and PostgreSQL.

India

Message

What I'm looking for

I’m looking for a remote analytics role where I can own the data and reporting function. I want to build automated SQL/Python reporting, partner with stakeholders, and deliver actionable BI insights consistently.

I turn raw operational data into automated reporting systems, with 9+ years of experience spanning MIS reporting, database design, and analytics automation. I specialize in owning the data pipeline end-to-end—so reporting is reliable, repeatable, and fast.

Most recently as an MIS Lead at Vendiman Pvt Ltd, I architected a PostgreSQL database from scratch that now powers BI reporting for 100+ business locations. I automated client report generation and delivery with Python and Google Apps Script, cutting manual reporting effort by ~80% and reducing turnaround time from days to hours.

I also lead platform-critical migrations, including moving MIS operations from Microsoft Outlook to Google Workspace with zero reporting downtime. Earlier roles reinforced my strength in SQL-based analytics, Excel/Google Sheets reporting, operational audits, and stakeholder-ready KPI and management reporting—so insights can drive day-to-day decisions.

Experience

Work history, roles, and key accomplishments

MIS Lead

Vendiman Pvt Ltd

Apr 2024 - Dec 2025 (1 year 8 months)

Designed and built a PostgreSQL database from scratch to centralize business data and power BI reporting for 100+ vending machine locations. Automated end-to-end report generation and delivery with Python and Google Apps Script, cutting manual reporting effort by ~80% and reducing turnaround time from days to hours.

PostgreSQL SQL Python Google Apps Script Data Automation Schema Design

MIS Executive

Vendiman Pvt Ltd

May 2022 - Mar 2024 (1 year 10 months)

Produced daily, weekly, fortnightly, and monthly management reports in Excel and Google Sheets covering operations, inventory, and transaction trends across 100+ devices. Conducted monthly operational audits across machines and locations to ensure compliance with company standards and delivered ad hoc analytics under tight deadlines.

Excel Google Sheets KPI Reporting Reporting Analysis Trend Analysis

Assistant Manager - MIS

Kayfin Solutions

Jan 2020 - May 2020 (4 months)

Calculated monthly payouts for pan-India on-roll and off-roll channels for IDFC First Bank products (LAP, Suvidha, BIL) according to structured client policy. Consolidated market and competitor data into actionable surveys, reports, and management presentations.

Financial Reporting Excel Data Analysis Survey Design Data Consolidation Process Automation

MIS Executive

Taglr Technologies Pvt. Ltd.

Jul 2018 - Jan 2019 (6 months)

Created and maintained end-of-month, quarterly, and annual management reports used across multiple departments. Automated and scheduled recurring report generation, reducing manual workload.

Excel Google Sheets Automation Recurring Reporting KPI Reporting Trend Analysis

Finance Associate

eClinicalworks

Mar 2016 - Jun 2018 (2 years 3 months)

Analyzed financial data to identify deficient controls, duplication, and non-compliance with policy across teams. Evaluated financial systems and recommended controls to improve data integrity and reliability.

financial data analysis Controls Testing Compliance Reporting Data Integrity Risk & Policy Checks Excel Data Quality

Senior Customer Service Executive

Serco Global Services

Oct 2013 - Aug 2015 (1 year 10 months)

Processed and reviewed international wire transfers (SWIFT, CHAPS, FEDWIRE, IBAN) for compliance and fraud risk. Analyzed outgoing wire requests against policy to identify and prevent potential fraud.

Fraud Risk Analysis & Compliance Swift CHAPS Fedwire