Avi Srivastava

Results-driven Data Analyst with 4 years of experience in data analysis, ETL testing, and business intelligence reporting. Delivered a 40% boost in reporting accuracy and cut processing time by 50% through rigorous data reconciliation and automation. Skilled in translating complex data into actionable stakeholder insights, aligning KPIs across cross-functional teams to improve operational efficiency by 20%.

Strong foundation in statistical analysis, trend analysis, and ad hoc reporting with hands-on expertise in Power BI, SQL, and Python.

Data Analyst - Xceedance - Gurugram

(2022-08)

• Applied descriptive statistical techniques, including trend analysis, variance analysis and outlier detection, to evaluate insurance data quality, identify reporting anomalies, and support root cause investigation across enterprise datasets
• Conducted stakeholder reporting and KPI alignment workshops with cross-functional business units, translating technical findings into data-driven insights and improving operational efficiency by 20%.
• Analyzed large datasets using SQL, MDX, Advanced Excel, and leveraged AI and prompt engineering in statistical analysis techniques to identify data discrepancies, uncover trends, and improve reporting accuracy by 40%, enabling more reliable business decision-making.
• Performed end-to-end data reconciliation between source systems, duck creek applications and enterprise data warehouse environment using complex SQL joins and Excel data-validation formulas, confirming data integrity across 10+ tables.
• Audited transformation logic and data pipelines across Staging, DWH, and Data Mart layers — identified 15+ hidden mapping errors through trend analysis and statistical checks.
• Engineered and maintained UI-to-database validation scripts in Katalon Studio, automating 50% of test cycles; coordinated daily status briefings with developers to ensure organized workflow.
• Authored a daily automation script consolidating data quality checks, cutting manual effort by 25%.

B.Tech - Safety Engineering - University of Petroleum and Energy Studies (2017-07 - 2021-07)