Data Analyst with 1+ years in SQL, Python & Power BI
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Results-driven Data Analyst and Business Intelligence professional with hands-on experience across 3 internships and 4 end-to-end projects. Proficient in SQL (Joins, Window Functions, CTEs), Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn), Power BI (DAX, Data Modeling, Dashboards), and Advanced Excel (XLOOKUP, Power Query, Pivot Tables). Experienced in ETL processes, KPI reporting, MIS reporting, EDA, data visualization, and delivering data-driven insights to cross-functional stakeholders.
Unknown
Master of Commerce (M.Com) · Business Administration
October 1, 2022 – March 1, 2024
ContechHub Solutions
Data Analyst Intern
June 1, 2024 – September 1, 2024
Jaipur, Rajasthan, India
MeriSKILL
Data Analyst Intern
February 1, 2024 – May 1, 2024
Noida, Uttar Pradesh, India
Afame Technologies
Data Analyst Intern
October 1, 2023 – January 1, 2024
India
Automated Inventory Management System
June 24, 2026 – Present
• Built a fully automated inventory management system using XLOOKUP, SUMIFS, and COUNTIFS to track stock levels, incoming and outgoing inventory across 200+ SKUs. • Automated low-stock alerts using nested IF logic, reducing manual tracking errors by ~40% and saving approximately 5 hours per week in manual reporting.
Online Retail Customer Segmentation
June 24, 2026 – Present
• Applied unsupervised machine learning (K-Means clustering) on 500,000+ online retail transaction records to identify 4 distinct customer segments for targeted marketing. • Engineered RFM (Recency, Frequency, Monetary) features; segmentation insights enabling personalized outreach strategies across 3 customer tiers, improving campaign relevance.
Food Delivery Order Analysis – SQL Case Study
June 24, 2026 – Present
• Designed a normalized relational database (6 tables: drivers, customers, orders, rolls, ingredients, ratings) and wrote 20+ complex SQL queries for a food delivery platform. • Utilized window functions, CTEs, CASE statements, and GROUP BY aggregations to generate delivery performance reports and revenue analytics summaries.
HR Data Analytics Dashboard
June 24, 2026 – Present
• Built an interactive Power BI dashboard with 8+ visualizations (bar charts, treemaps, slicers, KPI cards) to track HR KPIs including attrition rate, headcount, and salary analytics. • Created custom DAX measures for workforce trends, headcount forecasting, and salary band analytics. • Reducing HR reporting time by ~25% and enabling self-service analytics for managers
Full Stack Data Science Program
Almabetter
June 21, 2026 – Present
Data Analyst Internship Certificate
Afame Technologies
June 21, 2026 – Present
Data Analyst Internship Certificate
MeriSKILL
June 21, 2026 – Present
Data Analyst Internship Certificate
ContechHub Solutions
June 21, 2026 – Present
Excel Content Creator
YouTube Channel
June 21, 2026 – Present
Cultural Fit Analysis
The candidate shows a good cultural fit for a data-driven organization, evidenced by diverse projects across inventory, retail, food delivery, and HR analytics. The pursuit of multiple internships and a 'Full Stack Data Science Program' certification indicates a proactive learning attitude and commitment to the field. The 'Excel Content Creator' initiative suggests a willingness to share knowledge and engage with the community, which aligns with a collaborative culture. The breadth of tools and techniques used across projects also indicates adaptability.
Soft Skills & Operational Fit
The candidate demonstrates good operational fit for a Data Analyst role, having experience in collaborating with cross-functional teams, delivering actionable insights, and improving reporting efficiency. The project descriptions indicate an ability to translate business requirements into analytical solutions. However, without specific assessment data on soft skills, a definitive evaluation of areas like stress handling or team collaboration is not possible.