AtliQ Technologies — Data Analyst Intern

Remote (WFH) | April–May 

• Cleaned and transformed business datasets using Microsoft Excel, SQL, and Power Query, resolving missing values, duplicates, and formatting inconsistencies to improve data quality and reporting accuracy.
• Performed ad-hoc analysis and variance analysis in Excel and Microsoft Power BI, identifying business trends, order fluctuations, and reporting anomalies to support strategic decision-making.
• Designed and optimized complex MySQL queries for data extraction, validation, and reporting, ensuring data consistency and analytical reliability.
• Automated client reporting workflows through Excel-based reporting solutions, reducing manual effort and improving turnaround efficiency.
• Analyzed 5G telecom performance data, tracking operational KPIs, revenue impact, and customer usage behavior to generate actionable business insights.
• Built an interactive Microsoft Power BI dashboard for Shield Insurance, enabling stakeholders to monitor customer acquisition, revenue growth, and key performance metrics through dynamic visual analytics.

Allied Engineers — Data Analyst

Delhi | Jan 2024 – Jun 2025

• Optimized reporting workflows using Advanced Excel and Python, achieving 99% data accuracy while supporting 12+ client projects across India, Kuwait, and Saudi Arabia.
• Conducted Level 1 & Level 2 site data analysis across 100+ locations, identifying operational risks and prioritizing corrective actions, reducing issue response time by 25%.
• Automated reporting workflows using Advanced Excel (VLOOKUP, Pivot Tables, lookup functions), reducing 2+ hours of manual effort daily and improving reporting efficiency by 30%.
• Developed and presented bi-weekly analytical reports on operational site performance, helping stakeholders identify the top 3 root causes of equipment failures, contributing to a 20% improvement in operational reliability.
• Collaborated with cross-functional teams on corrosion mitigation and asset integrity analysis, driving a 15% improvement in asset performance KPIs and strengthening compliance with safety standards.

Intervie Tech — Data Analyst Intern

Remote (WFH) | Dec 2023 – Jan 2024

• Cleaned and transformed 50K+ rows of raw data using Python (pandas) and Microsoft Excel, resolving inconsistencies and improving data accuracy to 98% for reliable business reporting.
• Built interactive dashboards in Microsoft Power BI to monitor sales performance, customer acquisition, and churn metrics, reducing reporting turnaround time by 40%.
• Performed Exploratory Data Analysis (EDA) on 50K+ records, uncovering trends, patterns, and 3+ actionable business insights that supported stakeholder decision-making.
• Partnered with marketing and finance teams to align analytical outputs with business objectives, improving cross-functional reporting accuracy and data-driven decision-making.