KP

Business Analyst

Hyderabad, Telangana, India 2+ yrs exp 90 · Outstanding

About

Business Analyst with experience developing dashboards, reports, and data solutions for operational and commercial decision-making. Skilled in Power BI, SQL, Python, Tableau, and Excel, with hands-on experience integrating, validating, and analyzing data, building KPIs, and forecasting trends. Communicates complex findings clearly to non-technical stakeholders and translates analysis into actionable business insights.

Skills & Expertise (20)

Excel Advanced

8.0/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Data Analysis Intermediate

7.5/10

Years Exp

Analytical and logical thinking Intermediate

7.0/10

Years Exp

Tableau software Intermediate

7.0/10

Years Exp

Data Management Intermediate

7.0/10

Years Exp

Forecasting Intermediate

6.5/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

VBA Intermediate

6.0/10

Years Exp

Data Governance Intermediate

6.0/10

Years Exp

Looker Requirements Gathering Data Quality Management Dashboard Development Google Sheets Data visualisation Word PowerPoint MS Office

Work Experience

Business Analyst - Strategic Initiative Intern

WeRize

Nov 2025 - May 2026

Managed performance reporting in Google Sheets, applying data management practices and clear layouts to support weekly business reviews and decision-making. Connected and integrated multiple databases using SQL to create structured tables for reporting, analysis, and dashboard development. Utilized Python for data cleaning, analysis, automation, and report preparation to improve workflow efficiency. Developed interactive dashboards and visual reports using Microsoft Power BI, DAX, and Looker to track business performance and support decision-making. Prepared team invoices based on individual performance metrics and productivity data. Gathered requirements from cross-functional teams to design and maintain operational dashboards in Excel and PowerPoint, extracted data with SQL queries, and presented analytical findings to non-technical stakeholders, enabling faster decision-making. Validated records in SQL and Excel using data quality management and data governance practices, preventing workflow disruptions and maintaining continuous operations. Maintained existing trackers and built new performance dashboards in Google Sheets and Tableau, giving managers real-time visibility into team productivity and operational outcomes, which helped prioritize work and improve overall efficiency. Conducted funnel conversion analysis with Python and SQL to track lead-to-disbursal performance, uncovering bottlenecks that led to process refinements and higher conversion rates. Automated repetitive reporting tasks and streamlined data workflows using VBA macros and Power BI, reducing manual effort and report generation time. Assisted in converting raw business data into actionable insights by creating visual dashboards in Tableau and Looker and automating data cleaning with VBA and Python, helping stakeholders identify key trends and improve decision-making.

Business Analyst Intern

Outlook

Jun 2025 - Aug 2025

Collected, cleaned, and analyzed magazine subscription and customer data in Excel using pivot tables and VLOOKUP, uncovering a 12% churn pattern that informed the retention strategy. Developed interactive Power BI dashboards that visualized subscription trends, customer behavior, and key business KPIs, enabling senior managers to reduce reporting time by 30%. Performed time-series forecasting with Linear Regression, ARIMA, and Exponential Smoothing models to predict subscription demand, improving forecast accuracy by 15% and supporting inventory planning. Conducted trend analysis across multiple Outlook publications using Excel and Power BI, identifying emerging content topics that increased cross-sell opportunities. Created data visualizations and reports in Tableau and Power BI that supported business decision-making, highlighting growth opportunities that led to a pilot campaign in two new markets. Built multiple Power BI dashboards for subscription analytics and performance monitoring, enabling stakeholders to track key metrics and improve decision-making. Leveraged Excel, Power BI, and forecasting techniques to produce detailed reports, improving the accuracy of subscription performance insights.

Sales Executive

Garuda Automotives

Jul 2022 - Jun 2024

Managed customer interactions and handled 50+ sales inquiries monthly, optimizing customer satisfaction and increasing sales by 10%. Streamlined inventory management systems, reducing stock discrepancies by 15%, and prepared detailed sales reports. Assisted senior team members in analyzing sales data with Power BI, uncovering key customer preferences that guided targeted marketing campaigns and contributed to a 5% rise in sales. Collaborated with the sales team to implement customer feedback mechanisms, resulting in a 10% improvement in service response times and enhanced client retention.