Data Analyst Power Bi

Dhananjay Hemke

****************@*****.*** • +91-957*******

GitHub link : https://github.com/dhananjay77hemke

LinkedIn profile : www.linkedin.com/in/dhananjay-hemkay-0918631b1 PROFESSIONAL SUMMARY

Analytical and detail-oriented Data Analyst with 2+ years of hands-on experience in transforming raw data into actionable insights using Python, Power BI, SQL, and Excel. Proficient in data cleaning, visualization, and reporting to support strategic decision- making. Experienced in building automated dashboards, conducting root-cause analysis, and collaborating with cross-functional teams. Adaptable to both technical and analytical roles, with strong problem-solving and communication skills. PROFESSIONAL PROJECTS

MEASTRO INTELLECT, PUNE

Data Analyst April 2025 – Present

Developed interactive Power BI dashboards for e-commerce sales, customer trends, and KPIs.

Automated reporting by integrating data from Amazon datasets, SQL, and Excel.

Analyzed product performance and customer behavior to identify growth opportunities.

Presented data-driven insights to stakeholders for strategic decision-making. SQUAREYARDS,PUNE

Analyst June 2023 – Feb 2025

Developed and automated KPIs using advanced SQL queries to support data-driven decisions across teams.

Executed and managed end-to-end real estate transactions, ensuring compliance and timely closures.

Analyzed property market data to identify emerging trends and high-value opportunities.

Presented investment insights and study outcomes to stakeholders and project teams for informed decision-making.

Facilitated property valuation assessments to support strategic investment decisions. EDUCATION

YESHWANTRAO CHAVAN COLLEGE OF ENGINEERING RASHTRASANT TUKDOJI MAHARAJ UNIVERSITY NAGPUR B.E. IN ELECTRICAL ENGINEERING 2017 – 2022

HSC – S.P.M COLLEGE OF SCIENCE GADGEBABA AMRAVTI UNIVERSITY AMRAVATI 2017 TECHNICAL SKILLS

● Data Visualization & BI: Power BI, Tableau, Matplotlib, Seaborn, Excel (Pivot Tables, Charts)

● Data Analysis & Cleaning: SQL (Joins, Window Functions, CTEs), Excel, Python (Pandas, NumPy)

● Database Management: SQL (MySQL, PostgreSQL,XAMPP)

● Python: Data analysis, automation, scripting, data cleaning (Pandas, NumPy, Matplotlib, Seaborn) INDEPENDENT PROJECTS

Online Fashion Store (Ajio & Myntra)

Tools: Python, SQL, Power BI

Analyzed e-commerce sales data to uncover trends in customer purchases, product categories, and seasonal demand.

Designed dashboards to visualize revenue patterns, top-selling fashion items, and customer demographics.

Provided insights to optimize pricing strategies, improve inventory management, and enhance customer engagement. Price Comparison Analysis

Tools: Python, Pandas, Matplotlib, Seaborn

Collected and analyzed product price data across multiple e-commerce platforms to identify pricing differences.

Built visualizations (bar charts, line plots, scatter plots) to compare price ranges and discount patterns.

Provided insights on competitive pricing strategies, helping to identify the most cost-effective platform for customers. Google Image Scraping

Tools: Python, BeautifulSoup, Selenium, Requests, OS

Developed a Python-based web scraping script to automate downloading of images from Google.

Implemented search query customization, enabling collection of images across multiple categories and keywords.

Utilized Selenium for dynamic page loading and scrolling, ensuring maximum image retrieval.

Contact this candidate