Data Analyst with 2+ years in Power BI, SQL & AI-augmented analytics
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Analytical and results-driven Data & Business Analyst with 3 years of experience transforming raw, high-volume data into revenue-generating business intelligence. Proven track record of owning full analytics cycles — from ETL pipeline design and advanced SQL querying to executive-level Power BI dashboards and automated reporting systems. Proficient in Power BI (DAX), SQL, Python (pandas, plotly, streamlit), Excel, and Tableau. Passionate AI-augmented analytics practitioner who actively integrates, N8N workflow automation to accelerate analysis velocity and eliminate repetitive tasks. Seeking a high-impact role where data storytelling and intelligent automation create measurable business outcomes.
Integral University, Lucknow
Master of Computer Applications (MCA)
August 1, 2025 – Present
University of Lucknow
Bachelor of Science (B.Sc.)
August 1, 2020 – June 30, 2023
Aakash Institute
Business Analyst
November 1, 2025 – March 1, 2026
India
Gravity Classes
Data Analyst
June 1, 2023 – November 1, 2025
India
Global Video Game Sales Analysis
June 1, 2026 – Present
Performed comprehensive exploratory analysis on a 16,500+ record global video game sales dataset spanning 40 years, 12 publishers, and 6 regional markets (NA, EU, JP, Other). Developed a market intelligence dashboard, identifying top 10 best-selling games and publishers by global revenue; revealed that Action and Sports genres accounted for over 40% of all North American sales. Analyzed year-over-year sales trends from 1980-2020, identifying peak gaming market periods and platform lifecycle patterns - findings presented as a visual story deck. Visualized the impact of critical reception on commercial success through a Scatter Plot analysis, revealing that 85% of "Global Hits" (Sales > 10M) maintained a Critic Score above 8.5.
E-Commerce Strategic Analytics Engine
June 1, 2026 – Present
Engineered an end-to-end interactive BI application using Streamlit to analyze 5,000+ transactional records, providing real-time visibility into 8+ core KPIs including Total Sales, Profit Margins, and Discount Impacts. Optimized data usability by 100% by building a robust preprocessing pipeline in Pandas to handle missing values, perform feature extraction (Order-to-Ship lag), and standardize categorical data across 15+ variables. Developed a high-granularity filtering system incorporating "Top-N" product selectors and dynamic Profit Margin range sliders, enabling stakeholders to perform deep-dive analysis on low-margin products and regional outliers. Architected complex data visualizations using Plotly Express, including a Multi-dimensional Scatter Plot for Profitability Deep Dive and Time-Series Forecasting trends, resulting in the identification of a 12% revenue leakage in high-discount categories.
Music Store Business Intelligence Analysis
June 1, 2026 – Present
Executed end-to-end relational data analysis on a database with 11+ interconnected tables (Invoices, Customers, Tracks, Artists), solving 15+ complex business problems to drive data-led marketing strategies. Architected complex SQL queries using CTEs and Recursive Subqueries to identify the most popular music genres and top-spending customers per country, enabling localized promotional campaigns. Optimized query performance and readability by implementing Window Functions (ROW_NUMBER) and Multi-table JOINs, reducing the time required to extract top-performing artist and track-level metrics by 30%. Delivered actionable customer segmentation insights by analyzing 15K+ transactional records, identifying "Best Customers" and "Rock Music Listeners" for targeted email marketing and loyalty programs. Automated revenue trend reporting across global cities, identifying the highest revenue-generating regions to facilitate strategic event planning (e.g., Music Festivals) based on localized invoice totals.
Employee Compensation Equality Analyzer
June 1, 2026 – Present
Engineered a comprehensive pay equity audit system using Tableau to analyze compensation across 4 global factories, identifying that 29.7% of roles were 'Unfair' and 18.9% were 'Highly Discriminative'. Uncovered systemic pay disparities in mid-senior management by visualizing "Equality Scores" across job roles, revealing significant negative trends (scores as low as -73) in specific units like Daikibo Factory Seiko. Drove strategic HR recommendations by creating a weighted "Equality Class" metric, resulting in a proposed policy review to align performance pay bands within a ±10 fairness threshold. Optimized organizational transparency by designing automated alerts for "Highly Discriminative" scores (breaching ±20), enabling real-time monitoring of compensation health across 11+ unique job roles.
Western Financial Performance Dashboard
June 1, 2026 – Present
Identified an 8% potential profit margin improvement by doing comprehensive analysis to pinpoint discount-driven margin leakage across global territories. Built 15+ advanced DAX measures including YTD Revenue, MTD Growth %, Rolling 3-Month Average, Profit Margin %, and Gross vs Net comparisons for executive KPI tracking. Implemented drill-through pages, dynamic territory slicers, and bookmarked navigation enabling non-technical stakeholders to self-serve business insights. Analyzed $118.73M in total sales data, achieving 249% YTD growth visibility and allowing management to correlate high-discount strategies with segment-wise profitability.
Data Analysis Certification
Unknown
June 1, 2026 – Present
Deloitte Virtual Internship
Deloitte
June 1, 2026 – Present
IBM SQL Certification
IBM
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's project diversity, ranging from video game sales analysis to e-commerce analytics and HR compensation analysis, indicates a broad interest in applying data analysis across various domains. Their experience in both Business Analyst and Data Analyst roles, coupled with a strong emphasis on business intelligence and stakeholder reporting, aligns well with a target role focused on driving data-led strategies. The use of AI and automation tools suggests a forward-thinking approach, which would be a good fit for organizations embracing modern analytical practices. The candidate's focus on delivering tangible business value, as evidenced by their project outcomes, aligns with a results-driven culture.
Soft Skills & Operational Fit
The candidate demonstrates strong problem-solving abilities through their project work, particularly in identifying revenue leakage and pay disparities. Their experience in automating reports and data cleaning pipelines indicates a proactive approach to operational efficiency. The integration of AI tools (ChatGPT API) suggests an innovative mindset and adaptability to new technologies. The candidate's ability to deliver actionable insights and manage analytics infrastructure for significant revenue streams points to a results-oriented and responsible work attitude. The descriptions of their projects and work experience highlight a clear focus on delivering measurable business outcomes.