Data Analyst with 1+ years in Python, SQL & 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 with hands-on expertise in SQL (T-SQL), Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI, and Advanced Excel. Certified in Data Analytics by IIT Roorkee (Intellipaat) with proven project experience in EDA, data cleaning, relational database design, and KPI dashboard development. Adept at translating complex datasets into actionable business insights and stakeholder reporting. Seeking an entry-level Data Analyst role to contribute to data-driven decision-making in a fast-paced organization.
Women's College of Arts and Commerce
Bachelor of Commerce · Commerce
August 1, 2022 – June 30, 2025
Women's College of Arts and Commerce
Higher Secondary Certificate
June 1, 2022 – May 31, 2022
K. John Public School
Secondary School Certificate
June 1, 2020 – May 31, 2020
COVID-19 Global Data Analysis
January 1, 2025 – January 1, 2026
Analyzed 150+ country COVID-19 dataset (500K+ rows) using Python (Pandas, NumPy) - performed end-to-end EDA, time-series analysis, and created 8+ visualizations to identify peak infection periods and mortality trends across 6 continents. Performed data cleaning, column renaming, and date-based filtering; reduced data inconsistencies to enable accurate downstream analysis. Built heatmaps and time-series line plots using Matplotlib and Seaborn to communicate data-driven insights to stakeholders through structured analytical reporting. Aggregated and compared country-level mortality and recovery rates using Pandas groupby - enabling continent-wise outbreak severity benchmarking.
View ProjectSQL Relational Database Design & Analysis
January 1, 2025 – January 1, 2026
Designed a relational database from scratch (Salesman, Customer, Orders tables) with primary keys, foreign keys, and constraints - simulating real-world database maintenance scenarios. Wrote multi-table queries using INNER JOIN, RIGHT JOIN, and UNION to extract cross-table business insights and generate sales performance reports. Filtered and analyzed sales data using WHERE, BETWEEN, and LIKE clauses to identify high-value customers and top-performing salespersons; applied ALTER TABLE for schema optimization.
KPI Dashboard Development - MS Excel
January 1, 2025 – January 1, 2026
Cleaned and standardized datasets of 10,000+ rows in Excel using Power Query, reducing data inconsistencies by 100% and enabling accurate downstream analysis. Built dynamic KPI dashboards using Pivot Tables, VLOOKUP, and INDEX-MATCH across multi-sheet datasets, generating business-ready reports for data-driven decision-making. Designed dynamic charts with conditional formatting to improve data storytelling and presentation for stakeholder reporting.
Python Programming & Data Structures
January 1, 2025 – January 1, 2026
Built Python programs covering data types, string operations, lambda functions, list comprehension, and modular code design for real-world data tasks. Applied NumPy for array operations, slicing, and mathematical computations including statistical calculations and compound interest modeling.
Data Analytics (SQL, Python, Power BI, Advanced Excel)
IIT Roorkee via Intellipaat
June 1, 2026 – Present
C & C++ Programming
Unknown
June 1, 2026 – Present
Microsoft PL-300 — Power BI Data Analyst Associate
In Progress
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's academic projects demonstrate a proactive approach to learning and applying data analysis techniques across various domains (COVID-19, sales data). The pursuit of certifications, including an 'in progress' Microsoft PL-300, shows a commitment to continuous learning and professional development, which aligns well with a growth-oriented culture. The diversity of tools and techniques used (SQL, Python, Excel, Power BI) indicates adaptability. However, the lack of professional experience makes it difficult to fully assess cultural fit in a real-world work environment.
Soft Skills & Operational Fit
The candidate's project descriptions indicate an ability to translate complex datasets into actionable business insights and communicate them effectively through structured reporting and visualizations. The English test score of 71 suggests adequate communication clarity for professional settings. However, the psychometric test score of 0 indicates insufficient data to assess logical reasoning, work attitude, stress handling, or team collaboration.