Power Bi Business Intelligence

PRADIP MALI

+91-876******* — **************@*****.*** — LinkedIn Profile

SKILLS

Technical Skills:

• Excel (PivotTables, VLOOKUP), Power BI (DAX, Dashboards), SQL (Advanced Queries, Joins, Window Func- tions)

• Python (Pandas, NumPy, Matplotlib, Seaborn, scikit-learn), Data Cleaning

• Statistical Analysis & Reporting, Data Visualization, Business Intelligence Soft Skills:

• Analytical Thinking & Problem Solving, Data Interpretation & Communication, Team Collaboration & Presen- tation Skills

EDUCATION

B.Tech Computer Science & Engineering — Rajarambapu Institute of Technology — CGPA: 6.23 2022–2026 HSC Science — Azad Vidyalaya, Sangli — 61.00% 2021-2022 SSC — Shivraj Vidyalaya, Sangli — 84.40% 2019-2020 PROJECTS

Power BI – ShopNest Store Dashboard — View

• Situation: Required comprehensive business tracking dashboard for e-commerce store with fragmented data across 9 datasets

• Task: Integrate multiple data sources and create interactive visualizations for sales, customer, and inventory KPIs

• Action: Built Power BI dashboard using DAX measures, slicers, and drill-through features for real-time monitoring

• Result: Identified top categories contributing 65% of total sales, enabling data-driven business decisions SQL – Retail Store Analysis — View

• Situation: Retail store needed insights from complex customer, product, and regional sales data for marketing strategy

• Task: Analyze sales performance patterns and identify high-value customer segments across different regions

• Action: Designed complex SQL queries using JOINs, CTEs, and window functions for comprehensive data analysis

• Result: Discovered customer segments contributing 20% of revenue, enabling targeted marketing campaigns Excel – Sales Performance Analysis — View

• Situation: A large retail data set had inconsistent formats, making it difficult to analyze sales trends.

• Task: Create dynamic dashboard for tracking product performance, trends, and regional growth patterns

• Action: Applied VLOOKUP, INDEX-MATCH, PivotTables, and Conditional Formatting for data standardization

• Result: Identified 15% growth in top categories, improving inventory planning and sales forecasting accuracy Python – Data Cleaning & Transformation — View

• Situation: Multi-source project data split across 3 DataFrames with missing values and inconsistent formats

• Task: Clean, transform, and integrate employee, project, and seniority data for comprehensive analysis

• Action: Applied Pandas and NumPy functions with control logic for end-to-end data wrangling and aggregation

• Result: Delivered fully cleaned and integrated dataset, demonstrating proficiency in real-world data challenges PROFESSIONAL EXPERIENCE

Result Analysis System Developer — Freelance Project Aug 2024 – Sept 2024

• Developed C# desktop application with SQL backend for automated exam result compilation and analysis

• Achieved 60% reduction in report generation time, improving accuracy for teachers and administrators CERTIFICATIONS & ACHIEVEMENTS

Data Analytics Certification — SkilloVilla (2025)

Problem Solving: Solved 100+ DSA problems on LeetCode and GeeksforGeeks using Java Hackathon: Developed Collaborative Project Management Tools using MERN Stack

Contact this candidate