Banothu Sravanthi

Business Analyst

Hyderabad, India 80 · Excellent

About

Business Analyst with nearly 2 years of experience delivering end-to-end data analytics solutions, from data extraction and transformation to dashboard deployment and stakeholder delivery. Skilled in SQL, Python, and Power BI with strong expertise in KPI tracking and data-driven decision-making.

Skills & Expertise (23)

Power BI Advanced

8.7/10

Years Exp

SQL Advanced

8.3/10

Years Exp

Data Analysis Advanced

8.0/10

Years Exp

NumPy Documentation Data Storytelling Data Quality Data Validation Power BI Service Databricks Azure Data Warehousing Data Modeling ETL Pipelines PySpark Business Analysis Pandas Python Tableau Advanced Excel Stakeholder Management Root Cause Analysis KPI Tracking

Work Experience

Assistant Manager – BI / Data Analyst

Mahindra and Mahindra Ltd.

Jan 2024 - Present

Delivered multiple end-to-end analytics projects including requirement gathering, data extraction, cleaning, transformation, modeling, and dashboard delivery to business stakeholders. Collaborated with business teams (operations, sales, service) to translate business problems into data-driven solutions. Designed and developed the Vehicle Summary Dashboard, providing consolidated KPI tracking across HCV, LCV, IC, and Bus segments. Built and delivered 10+ Power BI dashboards analyzing 5M+ records, enabling performance monitoring and faster decision-making. Wrote complex SQL queries (joins, window functions, CTEs) for large-scale data extraction and analysis. Automated reporting workflows using Python and SQL, reducing manual effort by 12–15 hours per week. Designed ETL workflows using SQL and Power Query to transform raw data into structured datasets. Developed AWS MIS cost dashboard, performing variance analysis (budget vs actual) to identify anomalies and improve cost control. Built sales performance dashboards tracking KPIs, revenue trends, and regional insights. Developed warranty and claims dashboards analyzing failure rates, repair costs, and risk indicators. Performed data cleaning, validation, and reconciliation to ensure data accuracy and consistency. Identified data anomalies and conducted root cause analysis to support business decisions. Presented dashboards and insights to stakeholders using structured storytelling. Managed Power BI Service including workspace creation, role-based access, publishing dashboards, and dataset refresh scheduling. Configured and maintained on-premises data gateway connections to enable secure and automated data refresh. Worked with large datasets using basic exposure to Azure, Databricks, and PySpark. Monitored dashboards in BAU operations, resolving issues and implementing improvements.