Sapna Bhawangirkar

Data analytics professional with 2+ years of experience in enterprise IT operations and hands-on experience in data analysis, dashboard development, and reporting. Microsoft-certified Power BI Data Analyst skilled in Power BI, SQL, Advanced Excel, Python, and Tableau, with domain knowledge in ServiceNow, SLA monitoring, storage capacity, incident management, banking, and e-commerce analytics.

Intern – Data Analyst at Ai Variant Ltd (2025-11 – Present)

Completed end-to-end analytics projects covering data preparation, SQL analysis, dashboard development, business performance analysis, and reporting across banking and e-commerce datasets.

• Cleaned, transformed, and validated datasets using Excel, SQL, and Python to support accurate analysis and reporting.
• Built interactive Power BI and Tableau dashboards to track KPIs, trends, and business performance.
• Analyzed banking loan portfolio data, including customer segments, repayment behavior, delinquency, and default trends.
• Analyzed Olist e-commerce data to evaluate sales, customer behavior, product performance, delivery efficiency, and revenue drivers.
• Automated recurring reports and presented actionable findings to support faster, data-driven decisions.

Data Analytics Trainee (Certification Program) at ExcelR (2025-01 – 2025-11)

Completed industry-focused analytics training and practical projects covering data cleaning, SQL analysis, dashboard development, and business insights across sales, finance, and operations.

• Completed certification programs in partnership with IIT Jammu and NASSCOM.
• Gained hands-on experience in Excel, SQL, Power BI, Tableau, and Python through structured assignments and projects.
• Performed data cleaning, transformation, exploratory analysis, and ETL on real-world datasets.
• Developed dashboards with KPIs, filters, drill-downs, and data storytelling features.
• Wrote SQL queries using joins, aggregations, subqueries, CTEs, and window functions.
• Delivered capstone projects across sales, finance, and operations analytics.

Planned Career Break (Maternity) (2024-03 – 2025-01)

• Took a planned maternity break and prepared for a transition into data analytics through structured training and practical projects.

Associate - Technical Consultant at Hitachi Vantara Ltd (2022-02 – 2024-02)

Analyzed capacity utilization, infrastructure alerts and ServiceNow ticket trends to support SLA compliance and operational decision-making.

• Monitored storage capacity, replication, system health, and alerts using HCS, Hi-Track, Mars Iris, Probe, and OpsRamp.
• Supported LUN allocation, expansion, reclamation, and host mapping based on capacity requirements.
• Performed SAN zoning/de-zoning and HCP health checks, including alert and log analysis.
• Investigated infrastructure alerts and recurring issues to prevent outages and capacity risks.
• Managed ServiceNow incidents, changes, and requests while ensuring SLA compliance.
• Prepared BAU handovers and supported on-call operations to maintain business continuity.

Bachelor of Technology (B.Tech.) in Electronics & Communication Engineering – GuruNanakDev Engineering College (VTU) (2015-06 – 2019-06)