Tejas Murgod

Business & Data Analyst

Bengaluru, India 2+ yrs exp 85 · Excellent

About

Business & Data Analyst with around 2 years of experience in operational analytics, KPI tracking, reporting automation, dashboard development, and data-driven process improvement. Skilled in SQL, Power BI, Advanced Excel, VBA, and Python for data analysis, reporting automation, data visualization, and data validation. Experienced in requirements gathering, root cause analysis, stakeholder collaboration, and translating operational data into actionable business insights.

Skills & Expertise (41)

SQL Intermediate

7.5/10

Years Exp

Data Analysis Intermediate

7.5/10

Years Exp

Excel Intermediate

7.5/10

Years Exp

Root Cause Analysis Intermediate

7.0/10

Years Exp

Reporting Automation Intermediate

7.0/10

Years Exp

Power BI Intermediate

7.0/10

Years Exp

Data Validation Intermediate

6.5/10

Years Exp

Python Intermediate

6.5/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

ETL Intermediate

6.0/10

Years Exp

VS Code Process Improvement Hypothesis Testing Microsoft 365 Regression Testing User Acceptance Testing Functional Testing Non-Functional Testing KPI Tracking BRD Frd Google Sheets GitHub Requirements Gathering Stakeholder Collaboration Trend Analysis Data Transformation Data Cleaning NumPy Pandas Advanced Formulas VBA Power Query PivotTables KPI Dashboards Data Modelling SQL Server Query Optimization Window Functions CTEs Joins

Work Experience

Business Analyst

Alchemy Techsol

Nov 2025 - Jun 2026

Analysed 50K+ operational and performance records to identify trends, anomalies, and workflow improvement opportunities, improving visibility into key operational metrics by 20%. Defined and tracked 10+ business KPIs across business and operations workflows, enabling faster performance monitoring and more consistent decision-making. Designed and automated 15+ Power BI dashboards for monthly business reviews and ad hoc analysis, reducing reporting turnaround time by 25%. Performed root cause analysis on recurring operational issues and translated findings into process improvements, contributing to approximately 15% improvement in workflow productivity. Collaborated with 3+ cross-functional teams to gather reporting requirements, validate datasets, and deliver actionable operational insights. Implemented structured data validation and quality checks, improving reporting accuracy to 95%+. Led UAT for key reporting and workflow changes – designing test scenarios, guiding business users through validation, and securing sign-off before go-live. Performed funnel analysis on operational workflows to pinpoint drop-off stages and prioritize targeted process improvements.

Data Analyst – Reporting & Analytics

Quess Corp

May 2025 - Jul 2025

Automated 10+ recurring business reports using SQL and Excel VBA, reducing manual reporting effort by 30%+ and improving reporting consistency. Cleaned, transformed, and validated operational datasets to improve reporting accuracy and reliability. Conducted trend, variance, and SLA analysis to strengthen operational performance tracking and identify performance gaps. Developed reusable SQL queries, reporting templates, and automated workflows to standardize KPI tracking and reduce repetitive analysis. Streamlined ETL and data-processing workflows to improve reporting turnaround time and collaborated with stakeholders on timely reporting delivery. Validated data flow across system integrations during integration testing to ensure consistency with actual business processes.

Business Data Analyst

Concentrix

Apr 2024 - Apr 2025

Analysed 200K+ operational records to identify recurring issue patterns and root causes, contributing to a 10% reduction in repeat cases and 12% reduction in backlog volume. Automated business reporting workflows using Excel VBA, improving reporting efficiency and reducing turnaround time by approximately 20%. Built KPI dashboards and performance reports to monitor operational trends, identify performance gaps, and support stakeholder decision-making. Conducted trend, variance, and KPI analysis and delivered ad hoc reporting to support faster issue resolution and performance monitoring. Standardized reporting formats and KPI definitions while applying data validation and quality checks to improve reporting consistency. Reviewed test cases against business rules and identified priority regression scenarios after change requests to support QA ahead of release.

Data Science and Analytics Intern

UpGrad

Apr 2023 - Nov 2023

Processed and analysed 1M+ advertising records using Excel and SQL to identify high-performing ad slots and revenue optimization opportunities. Built reporting dashboards to monitor campaign ROI and ad-slot performance, supporting more efficient spend allocation. Conducted funnel analysis across the ad-campaign journey to identify drop-off points and inform spend optimization. Automated reporting templates and workflows, reducing manual reporting effort by 30% and enabling faster stakeholder reporting. Performed exploratory data analysis on movie datasets using Python, Pandas, NumPy, Matplotlib, and Seaborn to analyse revenue, ratings, genre performance, and audience behaviour.