Shivam Srivastava

About Shivam Srivastava

I am a Data Analytics Professional with expertise in Power BI, SQL, Python, data analytics, business intelligence and customer insights, helping organizations transform raw data into actionable strategies. Currently working as Senior Data Consultant at Allianz, I specialize in building scalable dashboards, automating reporting processes, and delivering insights that drive measurable business impact. What I do best: • Design and deploy interactive Power BI dashboards to improve visibility into engagement, retention, and campaign effectiveness. • Conduct deep-dive analytics on pricing, customer behavior, and market segmentation to optimize ROI and conversion rates. • Partner with global stakeholders to translate business needs into data-driven solutions across Marketing and CX journeys. • Implement automation and governance in reporting workflows, saving time, reducing errors, and enabling faster decisions making. Impact Highlights: • Improved campaign ROI by 10–15% through targeted postcode analysis and conversion insights. • Delivered postcode-level market analysis that contributed to a 12% increase in campaign conversion rates. • Reduced manual reporting by 40+ hours per month via SQL- and Excel-based automation techniques. • Delivered dashboards that accelerated decision-making by 30%, empowering non-technical teams to self-serve decision making.I am passionate about using data to tell stories, uncover hidden opportunities, and enable smarter business strategies.

Experience

1. Senior Data Consultant

   Allianz

   Mar 2025 — Present · Pune, IN

   Consumer Partners & Customer Insights (Allianz Australia)• Partnered with Marketing, CX, and Product teams to embed data-driven decision-making across the customer lifecycle, resulting in a 10–15% uplift in digital & offline campaign ROI.• Delivered postcode-level market analysis for Western Australia (WA) that refined targeting strategies and contributed to a 12% increase in campaign conversion rates.• Built an early-performance forecasting framework using Excel, Power Bi and historical sales patterns—calculating daily sales index vs. annual targets to predict daily/weekly plan numbers, enabling proactive planning and faster performance visibility.• Developed and deployed 15+ Power BI dashboards to track customer engagement, retention, and campaign effectiveness—boosting business decision-making speed by 30%.• Automated end-to-end reporting workflows using SQL, Power Query, and Excel, reducing manual effort by 40+ hours/month and increasing reporting accuracy to ~98%.

Education

• Shri Ramdeobaba College of Engineering and Management

  Bachelor of Engineering - BE, Civil Engineering