Gourav Shrivastava

About Gourav Shrivastava

Proficient and results-oriented Postgraduate in IT and Marketing with 7+ years of diverse experience in the fields of Business Intelligence and Business Analysis. Adept at leveraging advanced data analytics tools such as Power BI, SQL, and other BI platforms to extract actionable insights and drive informed decision-making. Possessing specialized expertise in data modeling, I am a Microsoft Certified Power BI Data Analyst, reflecting a commitment to excellence in data visualization and analysis.With a solid foundation in IT and marketing, coupled with hands-on experience in the mortgage sector and successful project completions in Semiconductor and Renewable energy industries, I bring a unique blend of technical skills and industry knowledge to the table. My ability to navigate complex datasets and translate them into meaningful business solutions has consistently contributed to organizational success.Known for communication skills, I excel in articulating insights and recommendations to diverse stakeholders, facilitating collaboration and driving consensus.Seeking to leverage my expertise and certifications in Business Intelligence and Data Analysis, I am poised to contribute to dynamic teams and organizations in roles encompassing Business Intelligence and Business Analysis. With a proven track record of delivering value through data-driven strategies, I am committed to driving innovation and fostering growth in the rapidly evolving landscape of business intelligence.Please feel free to get in touch with me via email at g••••••••@gmail.comSkills: Tableau, Excel, SQL, Power Bi, Google Ads, Looker, Tally ERP, Canva

Experience

1. Lead Analyst

   Dentsu Global Services

   Oct 2024 — Present · Pune, IN

   Worked on multi-channel digital and marketing analytics data (Facebook, Snapchat, Instagram, Yahoo), applying SQL-based data validation, anomaly detection, and data reconciliation frameworks to improve data consistency and accuracy across key KPIs, fully eliminating manual reconciliation. Developed standardized SOPs and a triage framework for data quality and ETL issues, documenting workflows in Confluence and integrating with Jira to ensure consistent incident management, root-cause analysis, and faster resolution. Built a Tableau data quality monitoring dashboard to track data leaks across multiple sources, enabling near real-time detection, reducing mean time to resolution by 40%, and resolving 250+ data quality incidents per quarter. Developed an automated Python-based anomaly detection script for Meta ads, leveraging statistical thresholds and rules based logic to monitor near real-time data, flag abnormalities, speed investigations, and reduce financial and compliance risk. Collaborated with the AI/NLG project team to provide domain expertise and data analytics inputs for automated insight generation, leveraging LLMs to generate scalable, descriptive, and personalized insights across 1,800+ reporting brands. Led and mentored a 3-member analyst team, optimizing SQL queries, BI workflows, and triage processes to drive a 60% improvement in query handling efficiency while maintaining a 9.3/10 CSAT from business stakeholders.

Education

• Jaipuria Institute of Management

  PGDM, Business Administration and Management, General

  2019 — 2021

• St. Aloysius College , Jabalpur

  B.COM, Business/Commerce, General

  2014 — 2017