Results-Driven Data & Business Analyst

Gutte Balaji Shamrao

+91-636******* *************@*****.*** linkedin.com/in/gutte-balaji Pune, Maharashtra, India Professional Summary

Analytics-focused Data Analyst with 3+ years partnering with cross-functional stakeholders to deliver self-service analytics solutions and actionable insights. Expert in complex SQL, DBT data modeling, and dimensional modeling with proven ability to build semantic layers and BI tools (Power BI, Tableau) for non-technical users. Experienced in defining metrics frameworks, owning critical dashboards, and analyzing product usage patterns to drive retention and growth. Strong track record collaborating with sales, product, and engineering teams to translate business needs into scalable data solutions with measurable impact.

Technical Skills

SQL & Data Modeling: Complex SQL (CTEs, Window Functions, Joins, Subqueries), DBT (Data Build Tool), Data Warehousing, Dimensional Modeling, Star Schema, Snowflake Schema Self-Service Analytics & BI: Power BI, Tableau, Semantic Layer Design, Dashboard Development, User Interface Design, Report Automation

Data Engineering & Pipelines: ETL/ELT Pipelines, Power Query, Ad-hoc Data Pipelines, Data Transformation, Data Quality

Programming & Scripting: Python (Pandas, NumPy), DAX, Data Automation, Statistical Analysis Cloud & Databases: Snowflake, AWS (RDS, S3, Lambda), MongoDB, Data Warehouse Architecture Analytics & Metrics: KPI Development, Metrics Framework Design, Product Analytics, Sales Analytics, Cohort Analysis, A/B Testing

Certifications: Microsoft Power BI, AWS Cloud Practitioner, AWS SysOps Administrator - Associate Professional Experience

Data Analyst Aug 2022 – Present

Tata Consultancy Services (TCS) Pune, Maharashtra, India

• Partnered with sales, product, and engineering stakeholders to understand workflows and define actionable metrics frameworks supporting strategic decision-making across 25+ KPIs

• Developed and owned 15+ critical self-service dashboards using Power BI and Tableau, enabling non-technical users to independently access insights and reducing ad-hoc reporting requests by 40%

• Built complex SQL queries and DBT data models on datasets exceeding 10M+ rows, implementing dimensional modeling and star schema architectures for efficient data warehousing

• Created semantic data layers and reusable data marts in Snowflake, improving query performance by 40% and enabling consistent metric definitions across business units

• Designed and maintained ad-hoc data pipelines using SQL and Python ETL workflows, automating data transformation processes and reducing manual effort by 30% (20 hours/week)

• Monitored product usage and sales performance metrics, conducting cohort analysis and retention studies to identify growth opportunities and reduce churn by 12%

• Prioritized competing analytical demands by assessing business impact, ensuring high-priority deliverables aligned with broader company strategy and delivered measurable outcomes

• Collaborated cross-functionally with GTM teams to document metrics definitions, data lineage, and analytical frameworks supporting transparency and data-driven culture Assistant Data Analyst - Automotive Domain Aug 2022 – Dec 2023 Tata Consultancy Services (TCS) Pune, Maharashtra, India

• Extracted and transformed 500GB+ vehicle sensor data using SQL and Python, building scalable data pipelines for performance analytics and operational reporting

• Applied dimensional modeling principles and advanced SQL (window functions, CTEs, aggregations) for data cleaning and transformation on complex automotive datasets

• Developed self-service Excel and Power BI dashboards for engineering stakeholders, identifying efficiency gaps and improving module performance by 12%

• Partnered with engineering teams to define metrics, document KPIs, and deliver actionable insights under tight deadlines, enabling data-driven decisions and 10% cost reduction

• Built reusable data models and semantic layers ensuring data consistency, 99%+ accuracy, and enabling non-technical users to independently analyze performance trends Key Projects & Impact

Self-Service Analytics Platform for Cloud Cost Monitoring SQL, DBT, Power BI, Python, AWS 2024

• Designed and built semantic layer using DBT with dimensional models (fact and dimension tables) for AWS billing data, enabling self-service cost analysis

• Developed automated ETL pipelines extracting and transforming cloud usage data, creating reusable data marts for non-technical stakeholders

• Built interactive Power BI dashboard with drill-down capabilities, reducing monthly cloud spend by 18%

($35K/year) through transparent cost visibility

• Partnered with finance and DevOps teams to define cost metrics framework and implement real-time anomaly detection alerts

Sales & Marketing Performance Analytics Platform SQL, Python, Tableau, DBT, Statistical Analysis 2023

• Collaborated with sales and marketing teams to understand workflows, document requirements, and define actionable metrics for campaign ROI and sales pipeline

• Built dimensional data models using DBT with star schema architecture, creating semantic layers for consistent metric definitions across teams

• Developed self-service Tableau dashboards with cohort analysis and attribution modeling, improving marketing ROI by 20% and optimizing $500K budget allocation

• Created predictive models using Python (85% accuracy) forecasting campaign success, enabling proactive resource allocation and strategic planning

Product Usage & Customer Retention Analytics SQL, DBT, Power BI, Snowflake 2023

• Analyzed product usage patterns across 5,000+ SKUs using complex SQL and dimensional modeling to identify retention drivers and growth opportunities

• Built semantic layer in Snowflake with DBT, creating reusable data models for inventory turnover, customer behavior, and demand forecasting

• Developed self-service dashboards enabling product and sales teams to independently track KPIs, reducing holding costs by 15% and improving efficiency by 22%

• Implemented automated restocking alerts based on usage metrics, demonstrating impact of data-driven insights on operational outcomes

Workforce Analytics & Metrics Framework SQL, Excel, Power BI, Power Query 2023

• Partnered with HR stakeholders to define workforce metrics framework analyzing 50,000+ employee records for overtime patterns and productivity

• Built ad-hoc data pipelines using Power Query and SQL transformations, creating dimensional models for workforce analytics

• Developed self-service Power BI dashboard enabling HR team to independently monitor metrics, reducing overtime costs by 12% ($75K annually)

Education

Bachelor of Science in Computer Science June 2019 – Dec 2022 Swami Ramanand Teerth Marathwada University Nanded, India

• GPA: 9.0/10.0 Relevant Coursework: Data Structures, Algorithms, Database Management, Statistics, Data Warehousing, Machine Learning

Additional Information

Stakeholder Collaboration: Proven ability to partner with sales, product, engineering, and executive teams to translate business needs into technical solutions

Autonomy & Impact: Self-directed in managing cross-functional analytics projects from requirements gathering through deployment and adoption

Communication: Strong documentation skills and ability to present complex analytical insights to non-technical audiences

Contact this candidate