Vijay Kumar

Computer Science & Engineering student focused on data analytics, with hands-on experience cleaning and analyzing 50,000+ transaction records using Python, Pandas, and SQL. Builds Power BI dashboards and uses exploratory analysis to surface sales, customer, and churn trends.

Data Analytics Intern - GeeksforGeeks

(2026-04 - 2026-07)

• Cleaned and analyzed 50,000+ sales and transaction records using Python, Pandas, and SQL.
• Resolved missing values, duplicates, inconsistent formats, and data-quality issues, improving dataset consistency by 95%.
• Queried datasets with joins, CTEs, aggregations, and window functions to investigate business performance.
• Analyzed customer behavior, revenue trends, churn patterns, and potential revenue leakage across 12 fiscal months.
• Performed exploratory analysis and visualized findings using Pandas, NumPy, Matplotlib, and Seaborn.
• Wrote complex SQL using ROW_NUMBER, DENSE_RANK, LEAD, and LAG to rank, compare, and trend transactional data over time.
• Built end-to-end cleaning, transformation, and validation workflows, so downstream analysis ran on consistent, verified data.
• Translated analysis into KPI summaries and reporting for business stakeholders as part of a 12-week BI and analytics program.

B.E. - Computer Science & Engineering - Institute of Engineering and Technology, Gorakhpur (2022 - 2026)