Data Analyst with less than a year in Data Analytics & Automation
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Graduate from IIT Delhi with 1 year of hands-on BI Analyst experience delivering end-to-end analytics solutions with measurable business impact. Built automated dashboards tracking Rs.3.2M+ revenue and Rs.1.5M+ ad spend across 23 campaigns, reducing reporting turnaround by 60% and eliminating 80% of manual operations effort through process automation. Authored advanced SQL queries uncovering 3 critical revenue leakage points driving strategic business decisions. Skilled in translating complex, fragmented data into executive-ready insights using Power BI, SQL, Python, Excel, and automation platforms. Proven track record combining technical expertise with analytical rigor to solve real business problems and drive operational efficiency.
Indian Institute of Technology Delhi (IIT Delhi)
B.Tech · Textile Engineering
August 1, 2021 – June 30, 2025
Pulp Strategy (AI & Digital Consulting Agency)
BI Analyst
June 1, 2025 – May 1, 2026
India
Advanced Excel MIS Challenge
May 1, 2026 – June 1, 2026
Solved 15 business-oriented Excel problems demonstrating end-to-end MIS expertise—applied SUMIF, SUMIFS, VLOOKUP, XLOOKUP, INDEX-MATCH, IF statements, DATEDIF, COUNTIF, COUNTIFS, AGGREGATE, IFERROR, text functions (LEFT, RIGHT, TRIM, SUBSTITUTE), Pivot Tables, Power Query, Slicers, and Conditional Formatting for billing automation, text analysis, and financial reporting, achieving 25% accuracy improvement.
View ProjectDiwali Sales Analysis
November 1, 2024 – February 1, 2025
Cleaned and analyzed 10,000 raw records using Pandas and NumPy—improved data quality by 85%; conducted exploratory data analysis (Pareto analysis, statistical profiling) identifying female demographic (25-35 age) and Food & Electronics categories as primary revenue drivers, improving forecasting accuracy by 30%.
View ProjectPizza Sales Intelligence
December 1, 2023 – March 1, 2024
Analyzed 50,000 transactional records using advanced MySQL (CTEs, Window Functions, JOINs, indexing)—surfaced revenue trends, cohort retention rates, and customer lifetime value metrics; optimized query performance by 20%, delivering actionable insights on pricing and inventory optimization.
View ProjectSales BI Hub
May 1, 2023 – July 1, 2023
Transformed 7,000 multi-source records into comprehensive Power BI dashboard with Star Schema modeling, Power Query ETL, and DAX measures—delivered 15 drill-through KPI views tracking revenue, retention, average order value, and trends, enabling leadership self-serve analytics.
View ProjectPower BI Micro Course
Unknown
January 1, 2025 – Present
SQL & Relational Databases Certification
IBM
May 1, 2024 – Present
Cultural Fit Analysis
The candidate's diverse project portfolio, ranging from sales analysis to pizza sales intelligence and advanced Excel challenges, demonstrates a broad interest in applying data analysis across various domains. The experience at an AI & Digital Consulting Agency suggests adaptability and exposure to different client needs. The combination of technical depth and practical application in projects indicates a strong fit for a role that values both analytical rigor and business impact. The educational background from IIT Delhi further underscores a strong foundation and potential for continuous learning.
Soft Skills & Operational Fit
The candidate's resume highlights strong problem-solving abilities, a data-driven approach, and a focus on operational efficiency through automation. The ability to translate complex data into actionable insights and improve business processes aligns well with a senior data analyst role requiring strategic thinking and practical implementation. The project descriptions indicate a proactive and results-oriented mindset.