Yuvraj Lokhande

Yuvraj Lokhande

Business Analyst
India
English

نبذة عني

Results-driven Business Analyst with practical experience transforming complex datasets into actionable insights. Proficient in Excel, SQL, Power BI, SAP and data visualization. Strong expertise in KPI tracking, trend an…

الخبرة

Business Analyst Intern

Nukind Healthcare
Sep 2025 - حتى الآن · 10 أشهر

Analyzed large datasets covering 400+ SKUs using Excel and SQL, tracking performance, availability and regional trends to support data-driven business decisions
Built a KPI Driven Sales Dashboard to give a real-time view of monthly - region wise performance
Performed market and competitor analysis on products attribute, pricing, schemes using Excel-Based Analytical Frameworks; identified gaps and delivered actionable insights
Evaluated the impact of pricing strategies and discount structures through Structured SQL Analysis and Excel Scenario Modeling
Worked on Requirements Gathering with stakeholders to understand reporting and analysis needs; translated business questions into data and reporting solutions
Prepared stakeholder-ready business insights using Advanced Excel and Power BI, that improved visibility into critical performance metrics and enabled strategic decision-making
Developed a deep understanding of Easysol & SAP - effectively extracted, validated and structured required data to support accurate business analysis and reporting

Business Analyst Intern

Nukind Healthcare, Delhi, India
Sep 2025 - حتى الآن · 10 أشهر

Analyzed large datasets covering 400+ SKUs using Excel and SQL, tracking performance, availability and regional trends to support data-driven business decisions, Built a KPI Driven Sales Dashboard to give a real-time view of monthly - region wise performance, Performed market and competitor analysis on products attribute, pricing, schemes using Excel-Based Analytical Frameworks; identified gaps and delivered actionable insights, Evaluated the impact of pricing strategies and discount structures through Structured SQL Analysis and Excel Scenario Modeling, Worked on Requirements Gathering with stakeholders to understand reporting and analysis needs; translated business questions into data and reporting solutions, Prepared stakeholder-ready business insights using Advanced Excel and Power BI, that improved visibility into critical performance metrics and enabled strategic decision-making, Developed a deep understanding of Easysol & SAP - effectively extracted, validated and structured required data to support accurate business analysis and reporting

Senior Territory Manager

Mankind Pharma
Mar 2025 - Aug 2025 · 5 أشهر

Supported SKU Performance Analysis, prescription trends and demand forecasting, contributing to 12-15% territory growth
Enabled Brand Positioning and in-market promotion execution, driving 110-120% sales target achievement for focus brand
Improved product availability, retail penetration and Channel Efficiency, expanding distribution coverage by 20-25%
Generated Field Insights, competitive intelligence and HCP feedback to support product strategy and portfolio optimization

Senior Territory Manager

Mankind Pharma, Satara, India
Mar 2025 - Aug 2025 · 5 أشهر

Supported SKU Performance Analysis, prescription trends and demand forecasting, contributing to 12-15% territory growth, Enabled Brand Positioning and in-market promotion execution, driving 110-120% sales target achievement for focus brand, Improved product availability, retail penetration and Channel Efficiency, expanding distribution coverage by 20-25%, Generated Field Insights, competitive intelligence and HCP feedback to support product strategy and portfolio optimization

Analytics Work - GitHub

KPI Dashboard for Tracking Business Performance & Driving Insights - GitHub, Strategic Analysis of the US HFrEF Therapy Market - GitHub, India Oral Anti-Diabetic Market Strategy & Analytics • Excel • SQL • Power BI - GitHub

المشاريع

KPI Dashboard for Tracking Business Performance & Driving Insights

Nukind
المدة : 31-Dec-2025 - 03-Feb-2026

This project showcases an interactive Power BI Sales Performance Dashboard designed to track, analyze, and visualize distributor and retail sales across regions, teams, and time periods. The dashboard provides a single, decision-ready view of sales performance with dynamic filters and geographic insights.

الشهادات

Data Analytics Internship

deloitte · Delhi, India · 2026

المهارات

إكسل بوربوينت بحث ساب لغة الاستعلامات الهيكلية (SQL) التواصل الاستراتيجي تحليل السوق المعلومات التنافسية مؤشر الأداء الرئيسي (KPI) العروض التقديمية إطلاق المنتجات تحليل الاتجاهات فيزيو التصور البياني للبيانات باور بي آي سيلز فورس (منصة علاقات العملاء) تابلو تحليلات البيانات MS Word ERP Tools JIRA Market/Sales Forecasting Tools Business Management Tools Business Analysis Tools Advanced Excel Performance Dashboards Strategy Consulting Gen AI Powered Data Analytics Excel-Based Analytical Frameworks Structured SQL Analysis Excel Scenario Modeling Requirements Gathering Reporting and Analysis Stakeholder Communication Field Insights HCP Feedback Product Strategy Portfolio Optimization Brand Positioning In-Market Promotion SKU Performance Analysis Prescription Trends Demand Forecasting Product Availability Retail Penetration Channel Efficiency Distribution Coverage Strategic Analysis US HFrEF Therapy Market India Oral Anti-Diabetic Market GATE GPAT 2023 NIPER JEE Gold Medalist Bachelor of Pharmacy (B. Pharm) Master of Pharmacy (M. Pharm) Pharmaceutics Formulation and Evaluation of Nanosuspension Formulation and Evaluation of Effervescent Tablet Nano-micelles formulation Published work Lifecycle Management Reports Product Performance Updates Logical Thinking Problem-Solving Skills Corporate Communication Cross-Functional Teams
الإبلاغ عن هذا الملف الشخصي؟