Data Analyst with 3+ years in data analysis, dashboarding, and business intelligence.
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with 3.5+ years of experience transforming complex datasets into actionable business insights. Proficient in SQL, Power BI, Excel, Python, and Azure technologies with expertise in data analysis, dashboard development, KPI reporting, and business intelligence. Experienced in identifying trends, improving operational performance, and supporting strategic decision-making through data-driven recommendations.
Himalayan University
Bachelor of Computer Applications (BCA) · Computer Applications
August 1, 2018 – June 30, 2018
Aranya Consultancy
Data Analyst
December 1, 2022 – Present
India
Retail Sales & Inventory Analytics Dashboard
January 1, 2023 – Present
Built a full-stack analytics solution for a multi-outlet food & grocery chain: raw SQL/Excel ingestion → Python cleaning pipeline → Azure SQL staging → live Power BI dashboards. Designed KPI framework: Stockout %, AOV, Promotion Uplift %, Regional Sales Index, and a retail customer engagement model (DAU/WAU/MAU) adapted from product analytics. Outcomes: significant reduction in stockouts | consistent sales uplift in underperforming regions | measurable increase in average bill value | major reduction in manual reporting effort | noticeable increase in promotion-driven sales. Dashboard adopted by all store managers as the primary operational decision-making tool within weeks of go-live.
HR Analytics Dashboard - SQL Server + Power BI
December 1, 2022 – June 1, 2026
Built complete HR analytics solution: imported 1,470 employee records into SQL Server, wrote analyst-level SQL (JOINS, GROUP BY, CASE WHEN, Window Functions), and created 4 SQL Views feeding directly into Power BI via Direct Query connection. Developed 8+ DAX measures and 2 calculated columns (Age Band, Salary Slab) - identified 20.6% attrition rate in Sales dept vs 13.8% in R&D, and confirmed low salary (<5K/month) as the primary attrition driver with 160+ exits. Delivered 5-page interactive dashboard covering Workforce Overview, Attrition Analysis, Employee Wellness, Salary Analysis, and Attrition Risk – dark theme professional design matching enterprise HR reporting standards.
View ProjectFreshMart Retail Analytics Dashboard
December 1, 2022 – June 1, 2026
Cleaned and transformed 500K+ retail transaction records using Python (Pandas), resolving date inconsistencies, duplicates, missing values, and data quality issues. Designed a star schema data model in Power BI by integrating 6 business tables to enable scalable reporting and analysis. Developed 15+ DAX measures and KPIs including Revenue, Gross Profit, Stockout %, Monthly Active Users (MAU), Customer Stickiness, and Promotion ROI. Performed store-level performance analysis and identified inventory-related issues contributing to underperformance, enabling data-driven recommendations for operational improvements. Built a 5-page interactive Power BI dashboard with drill-through analysis, KPI tracking, and automated reporting workflows, significantly reducing manual Excel-based reporting.
View ProjectSalifort Motors Employee Turnover Analysis
December 1, 2022 – June 1, 2026
Analyzed 15,000 employee records using Python (Pandas, Seaborn, Scikit-learn). Built Random Forest model achieving 98% accuracy and 89% recall. Identified key turnover factors: satisfaction level, workload, and salary. Created professional executive summary with data visualizations for HR stakeholders.
Relational Database Design and Advanced Querying
Unknown
June 1, 2026 – Present
Google Advanced Data Analytics Capstone (Python, Statistical Analysis & Predictive Modeling)
Google (Coursera)
May 1, 2026 – Present
Cultural Fit Analysis
The candidate's project diversity, ranging from retail sales and inventory to HR analytics and employee turnover, indicates adaptability and a broad interest in applying data analysis across different business domains. Their experience in a consultancy setting (Aranya Consultancy) suggests an ability to work with multiple clients and adapt to varying business needs, which aligns well with dynamic team environments. The focus on delivering measurable business outcomes in their projects also points to a results-oriented mindset.
Soft Skills & Operational Fit
The candidate demonstrates strong problem-solving skills through identifying and resolving data quality issues, and designing KPI frameworks. Their experience in collaborating with store managers and senior leadership, and presenting analytical findings, indicates good stakeholder communication and operational alignment. The ability to automate reporting and data preparation tasks suggests a focus on efficiency and process improvement.