Data Analyst Power Bi
Resume:
JAYESH CHIKANE
Data Analyst
****************@*****.***
https://www.linkedin.com/in/jayesh-chikane-a86387338 Professional Summary
A Data Analyst with ~ 3 years of experience across Finance, Supply Chain and Analytics domains. Proficient in SQL, Power BI, Python, Excel, Statistics and Machine Learning.
Education
• B.Tech – Dr. D. Y. Patil Institute of Technology 2019 –2023 Graduated with a GPA of 8.5/10, ranked 2nd in the course Work Experience
Data Analyst, Reliance Jio BP Mobility Limited – Mumbai, India Jul’23 – May’25
• Designed and deployed a Power BI-based C-Store Dashboard for a national cafe chain, analyzing 223M+ in sales, 9,800+ transactions, and 1.39M WBC orders and used advanced DAX to calculate dynamic KPIs, leading to a 35.6% WBC sales contribution and a ~28% increase in category-level decision accuracy.
• Implemented segmentation algorithms and time-series forecasting on WBC customer data (Python, SQL, Power BI), enabling targeted strategy revisions that boosted WBC's YoY contribution by ~17%.
• Developed an EV Charging Consumption Intelligence System, integrating over 1M charging sessions and 6.7M kWh consumption using complex SQL logic and Power BI models and identified top-performing cities like Bengaluru (1.94M kWh), optimizing charger allocation and improving utilization planning by 15%.
• Created dynamic MTD/YTD trend analytics for EV infrastructure using nested SQL CTEs, DAX measures, and interactive Power BI visuals, enhancing leadership’s visibility into city/site-level usage patterns
• Engineered a Freight-as-a-Service (FaaS) Dashboard from raw logistics data, analyzing 13.5 Cr revenue across 1,698 trips and 4.2 Cr in fuel revenue and delivered insights into margin fluctuation and route profitability, enabling a 6.5% rise in avg revenue/trip and contributing to a 131.5% YoY revenue growth.
• Automated end-to-end reporting pipelines using SQL, Power BI service, and scheduled refreshes and reduced manual effort by
~10 hours/month and ensured real-time access to freight, EV, and retail analytics across multiple business verticals. Delta India – India Aug 22 – June 23
• Assisted in building interactive dashboards using Power BI and Excel, transforming raw transactional data (~500K+ rows) into actionable insights that improved weekly reporting accuracy by 25%.
• Wrote efficient SQL queries for ad-hoc data extraction and trend analysis, supporting cross-functional teams with insights on customer behavior, campaign performance, and operational KPIs.
• Conducted exploratory data analysis (EDA) using Python (Pandas, Matplotlib) to identify patterns in sales and churn data, contributing to a retention strategy that projected a 12% improvement.
• Supported data cleansing and pipeline validation for ETL workflows, ensuring 99% data accuracy and timeliness across reporting systems and collaborated with senior analysts on hypothesis testing and root-cause analysis. Skills
• Data Analysis Tools & Languages: SQL, Python, Power BI, Tableau, Excel, GitHub, Jenkins, Statistics
• Specialties: Business Intelligence, Dashboard Development, Data Visualization, Customer Segmentation, Time Series Forecasting, KPI Automation, Reporting Pipelines, Exploratory Data Analysis (EDA), Revenue Analytics, Operational Efficiency Tracking, Cross-functional Collaboration, Stakeholder Reporting
• Coursework: Data Analytics, Supervised & Unsupervised Learning, Time Series Analysis, Statistical Modeling, Data Mining, Predictive Analytics, Linear/Logistic Regression, Business Intelligence, Forecasting Techniques, Data Governance Certificates
• Power BI Data Analytics 3.0 – CODE BASICS (Issued on Jul 2024)
• SQL Advanced For Data Professionals – CODE BASICS (Issued on Oct 2024)
• Excel: Mother Of Business Intelligence – CODE BASICS (Issued on Jan 2025)
Contact this candidate