Data Analyst - Python, SQL, Power BI

ADITYA SINGH

Data Analyst

+91-947******* ************@*****.*** Indore, Madhya Pradesh linkedin.com/in/adityasingh PROFESSIONAL SUMMARY

Detail-oriented Data Analyst with a B.Tech in Computer Science and strong hands-on skills in Python, SQL, Power BI, and Excel. Skilled in cleaning and analyzing datasets, performing exploratory data analysis (EDA), and building interactive dashboards that support data- driven business decisions. Experienced in translating raw, complex data into clear, actionable insights for both technical and non- technical stakeholders. Immediate joiner seeking Data Analyst roles in IT/tech and e-commerce-driven organizations. TECHNICAL SKILLS

Languages: Python (Pandas, NumPy), SQL, Excel

Visualization: Power BI (DAX, Data Modeling), Matplotlib, Seaborn Data Skills: EDA, Data Cleaning, Statistical Analysis, Trend Analysis, Forecasting BI & Reporting: Power BI Dashboards, KPI Reporting, Excel Pivot Tables, Automated Reports Database: SQL (Joins, Subqueries, Aggregations, Window Functions, CTEs) Soft Skills: Problem Solving, Attention to Detail, Data Storytelling, Stakeholder Communication PROJECTS

Business Insights Dashboard Power BI, Excel, DAX

• Designed a multi-page interactive Power BI dashboard visualizing KPIs — sales trends, regional performance, and customer segmentation — using DAX measures and star-schema data modeling.

• Automated the monthly reporting workflow, eliminating manual Excel reports and enabling faster, data-driven decisions for non- technical stakeholders.

Weather Data Analysis Python, Pandas, NumPy, Matplotlib, Seaborn

• Collected and cleaned a real-world weather dataset, handling missing values, outliers, and data-type issues using Pandas and NumPy; performed EDA to identify seasonal and temperature trends.

• Applied statistical methods (mean, standard deviation, correlation) and visualized findings via heatmaps, line plots, and histograms to clearly communicate patterns in raw data.

Sales & Customer Analytics Dashboard SQL, Excel, Power BI

• Built an end-to-end analytics workflow covering revenue, orders, average order value (AOV), and product performance using SQL for data extraction and Power BI for visualization.

• Segmented customers by purchase behavior and repeat-order frequency, surfacing insights used to prioritize high-value customer groups in reporting.

EDUCATION

B.Tech — Computer Science & Engineering 2025

Sushila Devi Bansal College of Engineering, Indore

• Relevant Coursework: DBMS, Data Structures & Algorithms, Statistics, Python Programming, Operating Systems Diploma — Computer Science & Technology Engineering 2022 JIS School of Polytechnic, Kalyani

SELF-LEARNING & TRAINING

Data Analytics — Self-Directed Program

• Completed structured, self-directed learning in Python for Data Analysis, SQL for Analytics, Power BI Dashboard Development, Excel for Business, and EDA using real-world datasets.

• Built end-to-end projects applying SQL joins, window functions, DAX formulas, data modeling, and data storytelling techniques. KEY STRENGTHS & ADDITIONAL INFO

Availability: Immediate Joiner Work Mode: Remote / Hybrid / On-site (Indore) Languages: English (Professional), Hindi (Native)

• Strong analytical mindset with the ability to break down complex datasets into clear, actionable business insights using Python, SQL, and Power BI.

• Consistent self-learner who built a complete data analytics portfolio through structured, hands-on project work.