Headline

Data & Business Analyst | 2.5+ Years | SQL · Power BI · Python | BI Dashboards · Revenue Analytics · Commercial Insights

About

🎯 Data & Business Analyst | 2.5+ Years | Power BI | SQL | Python | BI Reporting | E-commerce & Commercial Analytics I’m a Data & Business Analyst with 2.5+ years of experience turning messy, fragmented business data into clean, automated insights that help teams make faster and smarter decisions. At Pontika Aerotech, I built end-to-end BI solutions handling 1M+ data points and created automated Power BI dashboards that gave senior leaders clear visibility into performance, operational KPIs, and commercial growth metrics. I worked closely with stakeholders to understand reporting needs, implemented strong data validation processes for 100% reporting accuracy, and ran ad-hoc analyses to identify operational inefficiencies and practical improvement opportunities. During my internship at Tirupati Group, I partnered with the AVP to analyze sales trends, build performance-tracking dashboards, and perform basket analysis using SQL and Excel, uncovering purchasing patterns that supported commercial decision-making. Key strengths: • Power BI dashboards for executive and operational reporting • Advanced SQL for revenue, sales, and e-commerce analysis • Python, Excel, Power Query, DAX, and Tableau for analytics and reporting • Data cleaning, validation, ETL workflows, and KPI tracking • Commercial insights across revenue, conversion, inventory, and channel performance • Stakeholder collaboration, reporting accuracy, and business problem-solving I’m currently open to Data Analyst, BI Analyst, Business Analyst, MIS Analyst, Operations Analyst, and Product Analyst roles. Happy to connect with recruiters, hiring managers, alumni, and analytics professionals working in data, BI, business intelligence, e-commerce, retail, operations, or product analytics.

Location

Gurugram

Work experience

Data Analyst at Pontika Aerotech, Mar 2024 - Feb 2026 · 2 yrs, Paonta Sahib, • Drove data-driven initiatives by building scalable analytics solutions using SQL and Power BI, transforming manual processes into automated insights that improved executive decision-making for key clients. • Designed and maintained advanced dashboards using Advanced Excel and Power BI to track key business metrics such as sales performance, order fulfilment, client retention, growth trends, and target achievement. • Conducted in-depth gap and root-cause analysis using SQL across operational workflows, identified key bottlenecks, and presented actionable recommendations to senior leadership. • Served as the lead analyst for 8+ high-value clients, delivering tailored reports and insights on performance and sales cycles to enhance visibility and operational efficiency. • Integrated data-backed insights into daily cross-functional discussions, supporting agile decision-making across teams. • Recognized by the CEO for analytical excellence and entrusted with managing analytics for the company’s largest client.

Data Analyst Intern at Tirupati Group, Oct 2023 - Mar 2024 · 6 mos, Paonta Sahib, • Developed comprehensive dashboards and reports using Advanced Excel, Power BI, and SQL to provide insights on sales and inventory. • Created quarterly order and growth trackers to enhance business visibility and client relationship management. • Collaborated with clients to gather requirements and deliver tailored reports addressing specific business needs.

Education

Bachelor of Technology - BTech, Communication and Computer Engineering, The LNM Institute of Information Technology