Summary
Overview
Work History
Education
Skills
Adhoc Projects
Timeline
Generic

Saurabh Pandey

New Delhi

Summary

Dynamic Quality Analyst with extensive experience at Vaco Binary Semantics, excelling in data analysis and quality assurance. Proven track record in process improvement and stakeholder communication, utilizing SQL and Power BI to drive impactful insights. Recognized for team leadership and mentoring, enhancing productivity and achieving high customer satisfaction.

Overview

4
4
years of professional experience

Work History

Quality Analyst

Vaco Binary Semantics
07.2023 - Current
  • Process Overview: Google Hotel Ads
  • Monitored bug resolution efforts and tracked successes.
  • Utilized seven quality control tools.
  • Conducted data analysis leveraging Power BI, Google Spreadsheets, and Excel.
  • Tested functionality, performance and compliance of each product against design specifications to maintain strong development standards and high customer satisfaction.
  • Monitored and facilitated bug resolutions to optimize software.
  • Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
  • Conducted root cause analysis to investigate the source of problems in production process.
  • Implemented corrective actions when necessary to improve overall product quality.

Senior Analyst

Vaco Binary Semantics
04.2023 - 06.2023
  • Process Overview: Google Ads Creative Automation
  • Conduct data analysis using Power BI, Google Spreadsheet, and Excel, presenting actionable insights to stakeholders.
  • Develop visually appealing reports and dashboards using Power BI desktop, utilizes DAX queries for handling diverse datasets and implements Row-Level Security (RLS) in some reports.
  • Gather, arrange, and correct data to create representative graphs and charts for presentations.
  • Analyze profit and income segments of the E-Commerce Product Model for Google Express, identifying opportunities for optimization and growth.
  • Creates reports with diverse visualizations including Charts, Gauges, Tables, Matrix, Develops Parameterized Reports, Dashboard Reports, Linked Reports, and Sub Reports organized by different timeframes (Year, Quarter, Month, Week).
  • Optimize data collection procedures, improving data quality and fixing data bugs to enhance the user experience on Live Mall.
  • Resolve Live Mall metadata queries through BUGS (Tier-3 critical workflow - mail handling analysis), ensuring timely and accurate resolution of issues.
  • Provide comprehensive training and effectively manage a team of 20+ individuals, fostering a collaborative and high-performing work environment.
  • Maintain and improve process SOP guidelines for the team.
  • Interact with Google Clients, PGMs, and PITs for process improvement and collaboration with new merchants.
  • Tools Used: Power BI, Reddup Tool, Lockbox Curation, SQL, Excel, Advanced Excel, Crowd Compute.

Analyst

Vaco Binary Semantics
04.2022 - 03.2023
  • Process Overview: Google Ads Creative Automation
  • Utilized Advanced Excel, Google Spreadsheet, and Google Analytics for data analysis purposes.
  • Conducted analysis on various projects and presented findings to stakeholders.
  • Collaborated with team members to optimize data collection procedures.
  • Generated reports using charts and graphs for presentations.
  • Led cross-functional teams in the delivery of high-quality analytics solutions, fostering collaboration and driving process improvements.
  • Improve data quality of Live Mall and fix data bugs for enhanced user experience.
  • Tools Used: Excel, Advanced Excel, Crowd Compute, SQL, Power BI.

Associate Analyst

Vaco Binary Semantics
10.2020 - 03.2022
  • Process Overview: Google Ads Creative Automation
  • Managed data analysis for Google Ads, ensuring smooth operations and mitigating disruptions.
  • Analyzing and deciding the sensitivities that needs to be analyzed for various merchants and their collaboration with our product.
  • Gathered, arranged and corrected data to create representative graphs and charts highlighting results for presentations.
  • Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis.
  • Demonstrated strong analytical and problem-solving skills, consistently delivering accurate and impactful analysis.
  • Maintained consistency and professionalism in reporting and documentation.
  • Tools Used: Excel, Google Spreadsheet, Power BI.

Education

MBA -

Indira Gandhi National Open University
06-2024

Bachelor of Science - Electronics

University of Delhi
07-2018

Skills

  • Data analysis
  • Quality assurance
  • Process improvement
  • Stakeholder communication
  • Data visualization
  • Team leadership
  • SQL proficiency
  • Root cause analysis
  • Project management
  • Defect tracking
  • Report creation
  • QC testing
  • Audit processes
  • SQL
  • Quality processes
  • Sampling
  • Quality improvement
  • Team building
  • Team mentoring
  • Task prioritization
  • Power BI tool
  • Power BI Knowledge
  • Microsoft Excel expertise
  • Advanced Excel Abilities

Adhoc Projects

  • Google Pay, Analyzed shop usage of GPay scanners in various locations to gauge adoption. Identified high-usage and low-usage areas to strategize efforts for increasing GPay adoption among vendors in India.
  • Google Maps, Assigned a specific area to input entries for all shops. Ensured accurate representation of shops on the platform, creating a comprehensive database for user exploration.

Timeline

Quality Analyst

Vaco Binary Semantics
07.2023 - Current

Senior Analyst

Vaco Binary Semantics
04.2023 - 06.2023

Analyst

Vaco Binary Semantics
04.2022 - 03.2023

Associate Analyst

Vaco Binary Semantics
10.2020 - 03.2022

MBA -

Indira Gandhi National Open University

Bachelor of Science - Electronics

University of Delhi

Similar Profiles

CREATE PROFILE
Saurabh Pandey