Data Analyst with less than a year 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
Data Analyst with hands-on expertise in SQL, Python, Excel, and Power BI. Skilled in Data Analysis, Data Visualization, Business Analytics, and ETL. Proficient in Pandas, NumPy, MySQL, and statistical analysis. Proven ability to build interactive dashboards, perform exploratory data analysis (EDA), and deliver actionable business insights.
Jeevan Deep Mahavidyalaya, Varanasi
Bachelor of Computer Applications (BCA)
August 1, 2024 – June 30, 2026
Data Cleaning & ETL Pipeline | World Layoffs Dataset
May 1, 2026 – June 30, 2026
Built staging table architecture; removed duplicates using ROW_NUMBER() Window Function on all 9 columns. Standardized 50+ inconsistent industry values and fixed data quality issues affecting analysis. Populated 2,000+ NULL fields via self-JOIN to propagate known values from matching company rows. Converted date strings to DATE type; removed unusable rows creating analysis-ready dataset.
Customer Segmentation & Business Analytics
April 1, 2026 – June 30, 2026
Analyzed 23,000+ customer transactions using Pandas for Data Cleaning and accuracy validation. Applied RFM Analysis to segment customers into Champions, Loyal, At-Risk, and Lost categories. Conducted Pareto Analysis identifying top 20% customers contributing 80% of revenue. Created visualizations using Matplotlib and Seaborn for stakeholder presentations.
Workforce & Sales Intelligence Dashboard
February 1, 2026 – March 31, 2026
Designed interactive Power BI Dashboard consolidating workforce and sales data for management reporting. Automated data summarization using Power Query ETL process; reduced manual reporting by 60%. Implemented slicers and conditional formatting for quick identification of performance trends. Created self-service reporting tool improving data accessibility for decision-making.
Cultural Fit Analysis
The candidate's projects demonstrate a clear alignment with the target role of Data Analyst, covering key areas like data cleaning, ETL, customer segmentation, and dashboard creation. The diversity of tools (SQL, Python, Power BI, Excel) and analytical methods (RFM, Pareto) indicates a broad skill set relevant to data analysis. However, all projects are academic, which limits the assessment of cultural fit within a professional team environment or experience with real-world business constraints and stakeholder management. The candidate is currently pursuing a BCA, which suggests a junior profile, potentially impacting cultural fit for a senior role without further professional experience.
Soft Skills & Operational Fit
The candidate's project descriptions indicate an ability to work on structured data analysis tasks, focusing on data quality, transformation, and visualization. The emphasis on reducing manual reporting and improving data accessibility suggests a practical, results-oriented approach. However, without psychometric or English test scores, it's difficult to assess logical reasoning, work attitude, stress handling, or team collaboration directly. The academic nature of all projects suggests a learning-oriented individual, but real-world operational fit and collaboration skills need further validation.