Gaurav Bobade

Data Analyst | Business Intelligence Developer

Pune, Maharashtra, India 80 · Excellent

About

Data Analyst with 3+ years of experience in data analysis, business intelligence, and reporting across Banking, Financial Services, and Marketing Analytics. Skilled in SQL, MSSQL, Snowflake, Power BI, Tableau, Advanced Excel, DAX, Power Query, ETL, and dimensional data modeling. Experienced in converting multi-source data into validated datasets, KPI dashboards, MIS reports, and executive reporting solutions that support omni-channel marketing campaigns, digital marketing performance, ROI analysis, and ad spend optimization.

Skills & Expertise (34)

Power BI Desktop Advanced

8.5/10

Years Exp

Advanced SQL Advanced

8.1/10

Years Exp

Snowflake Advanced

8.0/10

Years Exp

Tableau Advanced

8.0/10

Years Exp

Power BI Service Advanced

8.0/10

Years Exp

MSSQL Intermediate

7.5/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

MySql Intermediate

7.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Executive Reporting Joins Advanced Formulas Pivot Tables XLOOKUP VLOOKUP Advanced Excel Dimensional Modeling Star Schema validation Deduplication Transformation Data Extraction ETL MIS Reporting Trend Analysis Customer Segmentation Digital Marketing Analytics Calculated Fields Dashboards CTEs Power Query Subqueries Window Functions Aggregations

Work Experience

Jr. Data Analyst

CaptoSoft Digital Solutions Pvt. Ltd.

Present - Present

Supported an enterprise analytics platform for a Leading Private Commercial Bank to centralize and analyze marketing campaign performance across 9 digital and offline channels, enabling end-to-end evaluation of digital marketing KPIs, campaign ROI, customer acquisition cost (CAC), channel efficiency, and ad spend optimization. Extracted, cleaned, and standardized multi-source JSON and CSV datasets comprising 5M+ daily records across 9 digital and offline channels using SQL, MSSQL, and ETL processes into Snowflake for unified reporting. Developed optimized SQL queries including joins, CTEs, window functions, and aggregations on multi-million row datasets to accelerate analytical query response times by ~35%. Designed Star Schema data models in Snowflake and established reporting relationships to enable scalable multi-channel campaign analytics and attribution. Built interactive Tableau and Power BI dashboards to track critical digital marketing KPIs including Click-Through Rate (CTR), Customer Acquisition Cost (CAC), Return on Investment (ROI), and conversion funnels to optimize ad spend. Created advanced calculated fields in Tableau and DAX measures in Power BI to translate complex marketing business logic into actionable visual scorecards. Performed data cleansing, validation, deduplication, and transformation using SQL, Snowflake, and Excel to ensure data accuracy and reporting reliability across omni-channel touchpoints. Generated MIS reports and executive summaries to support marketing leadership with campaign performance analysis, channel ROI trends, and budget-allocation insights. Configured scheduled dashboard data refreshes and delivery workflows in Power BI Service to streamline recurring operational reporting and eliminate manual refresh overhead. Collaborated with data engineers, digital marketing managers, and stakeholders to gather reporting requirements and deliver data-driven analytical solutions. Maintained documentation for ETL workflows, dimensional models, and Tableau / Power BI dashboard designs to support operational continuity and reporting standards.