
Data Analyst with less than a year in Data Analytics & PostgreSQL
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Fresher Data Analyst with a 3-month EdTech internship building KPI dashboards and PostgreSQL validation pipelines using Power BI and Excel. Completed two end-to-end analytics projects covering sales trend analysis, customer segmentation, and BI dashboard development. Basic Python (pandas, numpy) applied for data cleaning and EDA through academic coursework and self-learning. Pursuing MBA in Data Science at LPU.
Lovely Professional University
MBA · Data Science
August 1, 2025 – Present
GGSIP University, Delhi
Bachelor of Computer Applications · Computer Applications
August 1, 2022 – June 30, 2025
UPTO SKILL - EdTech
Data Analyst Intern
January 1, 2024 – March 1, 2024
Delhi, Delhi, India
Iowa Liquor Sales Analysis
January 1, 2026 – March 1, 2026
Analysed government sales data to identify top-performing stores, product categories, and revenue periods - converting raw records into business intelligence. Used Python (pandas) to inspect dataset structure, handle null values, and verify data types before PostgreSQL ingestion. Wrote JOINS, CTEs, LAG(), and Window Functions to rank stores and products by revenue and calculate period-over-period trends. Built an Excel Pivot Table dashboard and a Looker Studio BI dashboard with store, category, and time filters for self-serve data exploration.
View ProjectMusic Store SQL Analysis
December 1, 2025 – Present
Queried an 11-table relational schema to answer three business questions: revenue by genre, top-selling artists, and customer lifetime value segmentation. Applied RANK() and ROW_NUMBER() window functions to segment customers by lifetime spend and identify the highest-value buyer tier. Structured all queries using CTEs for readability and reusability, reflecting professional analytical SQL standards.
View ProjectCultural Fit Analysis
The candidate's pursuit of an MBA in Data Science while also completing a Bachelor's degree and an internship shows a strong drive for continuous learning and career development, which aligns well with a growth-oriented culture. The personal projects demonstrate initiative and a passion for data analysis beyond formal education or work, indicating a self-starter mentality. The diversity of projects (liquor sales, music store) and tools used (PostgreSQL, MySQL, Power BI, Looker Studio, Excel, Python) suggests adaptability and a broad interest in data challenges. The remote internship experience also indicates an ability to work independently.
Soft Skills & Operational Fit
The candidate demonstrates a proactive attitude through personal projects and an internship, indicating a willingness to learn and apply skills. The ability to automate reports and deliver ad-hoc analysis suggests a focus on efficiency and responsiveness to business needs. The use of CTEs for readability reflects an understanding of professional analytical standards. However, the limited professional experience (3-month internship) means operational fit in a fast-paced, complex environment is yet to be fully proven.