RAVICHANDRA DAYANNAVAR

Business Analyst
Bengaluru, IN.

About

Highly analytical and results-driven Business Analyst with over 6 years of experience across supply chain, market research, and IT/service industries. Expertly leverages SQL, Power BI, and Excel to deliver data-driven insights, automate KPI tracking, and optimize processes, consistently improving operational efficiency by 25-30%. Proven in BRD/FRD documentation, requirement gathering, and UAT coordination within Agile environments, driving strategic decision-making and enhancing client satisfaction.

Work

Temple Research Insights Private Limited
|

Business Analyst

Not Specified, Not Specified, India

Summary

Led the end-to-end implementation of automated, data-driven reporting solutions to enhance market intelligence and stakeholder decision-making.

Highlights

Led the end-to-end implementation of automated, data-driven reporting solutions using Power BI and SQL, reducing manual reporting time by 20% and enhancing real-time market intelligence for stakeholders.

Gathered and analyzed client business requirements, translating needs into actionable insights and data-driven solutions, ensuring project alignment and achieving a 20% improvement in client satisfaction.

Collaborated with cross-functional teams to document and streamline market research project workflows using JIRA, reducing requirement clarification time by 30% and enhancing project efficiency.

Designed interactive Power BI dashboards, tracking key KPIs (market share, customer acquisition rate, competitor performance), providing real-time insights that reduced operational inefficiencies by 25% and enhanced data-driven decision-making.

Extracted, transformed, and analyzed large datasets using SQL and Alteryx, uncovering customer insights, sales trends, and competitive intelligence to improve client project efficiency by 15% and contribute to strategic decision-making.

Managed sprint progress, requirement tracking, and User Acceptance Testing (UAT) within an Agile environment using JIRA, ensuring timely delivery and quality assurance.

HINDALCO INDUSTRIES LIMITED
|

Junior Engineer (Business Analysis)

Not Specified, Not Specified, India

Summary

Analyzed large datasets and optimized strategies to reduce operational downtime and improve cost efficiency within a manufacturing environment.

Highlights

Analyzed large datasets in IBM Maximo to identify critical data deviations, collaborated with cross-functional teams to implement data-driven improvements, and optimized strategies, reducing downtime by 15% and cutting maintenance costs by 10%.

Partnered with supply chain and production teams to optimize spare part inventory and forecast material consumption, successfully reducing stockouts by 30%.

Utilized Advanced Excel and Power BI to analyze past fiscal year expenditures, forecast annual budgets for 10+ shop centers, and identified cost-saving opportunities, achieving 20% procurement savings and preventing budget overruns.

Automated Purchase Requisition System (PRS) using VBA and Macros for the user department, reducing stockouts by 30% and cutting procurement delays by 25%.

Conducted comprehensive supplier performance and lead time analysis using Oracle, streamlining procurement strategies, and implementing a vendor scorecard system that reduced lead times by 15% and enhanced vendor selection efficiency.

Designed interactive Power BI dashboards to track KPIs like MTBF, MTTR, and cost trends, automating reporting processes and providing actionable insights to leadership, improving decision-making and cutting manual data analysis time by 30%.

Education

Rani Channamma University Belagavi
Belagavi, Karnataka, India

Bachelor's

Marketing & Finance

Grade: 8.6 CGPA

Department of Technical Education Bengaluru
Bengaluru, Karnataka, India

Diploma

Mechanical Engineering

Grade: 7.8 CGPA

Certificates

Top 5% Performer – Data & Business Analytics Certification

Issued By

Wipro & FutureSkills

Skills

Data Analytics & Business Intelligence

SQL, Power BI, Tableau, Excel, Python, Forecasting, Predictive Modelling, JIRA.

Data Transformation & Automation

Data Warehousing, Macros, ETL, Data Validation, VBA, Power Query, Alteryx.

Supply Chain Management

Demand Forecasting, Stock Turnover Analysis, KPI Tracking, Procurement Analytics, Vendor Evaluation, IBM Maximo, Oracle.

Financial & Business Analysis

FP&A Reporting, Data Modelling, Market Research, Business Process Optimisation, BRG.

Projects

Swiggy Funnel Analysis using PowerBI

Summary

Conducted a comprehensive customer journey analysis using funnel metrics, identifying critical drop-off points and increasing conversion rates by 15% through data-backed recommendations. Provided in-depth insights that strengthened Swiggy's user experience, aligning data analysis with customer retention and engagement goals.

Airline Operation Optimization

Summary

Optimized complex SQL queries using Common Table Expressions (CTEs) and window functions to improve data processing efficiency by 25% and ensure 100% query accuracy for strategic decision-making. Generated actionable reports for stakeholders, providing real-time insights that enhanced operational efficiency and forecasting.

FreshCo Hypermarket Sales and Customer Analysis

Summary

Prepared and analyzed sales, customer, and delivery datasets to improve data readiness and identify key trends, ultimately boosting operational efficiency by 30% and customer satisfaction by 25%. Developed data-driven insights that enabled FreshCo to make strategic business decisions, enhancing supply chain effectiveness.

RAVICHANDRA DAYANNAVAR