Summary
Overview
Work History
Education
Skills
Websites, Portfolios and Profiles
Interests
Timeline
Generic

VAIBHAV GAHLOT

Market Research
Ghaziabad

Summary

Experienced and results-driven Data Analyst with over 9 years in the market research industry, including 2 years in an Associate Manager role. Proven expertise in quality assurance, data cleaning, statistical analysis, and delivering accurate insights that drive strategic decisions. Skilled in managing end-to-end survey processes, from survey link testing and platform validation (Decipher, Confirmit, Qualtrics) to data automation and error-free reporting.

Highly proficient in identifying data inconsistencies, leading QA efforts, and automating validation workflows using Excel, SPSS, SQL, and Python to ensure high data integrity and operational efficiency. Adept at managing manual testing cycles, resolving testing backlogs, and collaborating with cross-functional teams to meet tight deadlines and client expectations. Known for a detail-oriented approach, process improvement mindset, and strong commitment to delivering high-quality outcomes in fast-paced, data-intensive environments.

Management professional with knack for strategic planning and operational excellence bringing wealth of experience in team leadership and optimizing processes. Known for fostering collaborative environments and driving results seamlessly adapt to changing requirements and ensure consistent performance. My communication and conflict resolution skills are assets valued by employers.

Overview

11
11
years of professional experience
2023
2023
years of post-secondary education

Work History

Associate Manager

B3 Intelligence
08.2016 - 06.2025
  • Collaborated with project managers and clients to gather survey specifications, refine research methodologies, and deliver timely progress updates to ensure client satisfaction and alignment with project goals.
  • Delivered actionable insights and survey findings through clear, structured reporting tailored to business objectives.
  • Performed detailed data validation in SPSS based on complex questionnaire logic including base skips, routing patterns, consistency checks, range verifications, and quota adherence.
  • Developed advanced SPSS syntax scripts using IF, DO IF, ELSE IF, END IF, LOOP, END LOOP, and logical operators (AND, OR, GT, GE, LT, LE, NE, EQ) for dynamic rule-based validation and error flagging.
  • Validated grid and looped question sets using VECTOR and LOOP constructs, ensuring exclusive and complete responses across multi-dimensional datasets.
  • Created automated validation flags and summary variables to detect missing, inconsistent, or illogical responses using modular and scalable SPSS scripting.
  • Automated repetitive data QA workflows using Python (pandas, numpy, duckdb) and SQL, improving quality assurance efficiency and reducing manual intervention.
  • Executed large-scale data transformations and formatting in SPSS and Excel, tailored to client-specific formats and project requirements.
  • Led end-to-end browser-based survey testing across Chrome and Internet Explorer; coordinated QA to ensure consistent functionality and cross-platform integrity.
  • Managed testing on Decipher, Confirmit, and Qualtrics platforms, providing documentation, logging defects, and contributing to iterative improvements in survey deployment.
  • Directed module-level QA coordination with global teams, optimizing backlog clearance and ensuring timely, high-quality data delivery.
  • Led specialized testing for advanced survey methodologies, including Conjoint, MaxDiff, and Priority Logic, with scenario-based validations in Excel.
  • Responded to custom client data requests through advanced logic scripting, formatting, and troubleshooting using SPSS, Excel, and Python.
  • Managed and mentored a team of 10+ associates, creating a collaborative, performance-driven environment.
  • Designed and conducted training programs for new hires and existing team members to build technical proficiency and domain expertise.
  • Provided hands-on leadership in high-pressure scenarios, minimizing operational disruptions and ensuring business continuity.
  • Conducted structured performance reviews, recognized contributions, and addressed development areas to build a high-performing team.

Junior Engineer Product Support

HCL Technologies
04.2014 - 03.2015
  • Interacting with customers and gathering the required details, analyze and test them to finally provide resolution of the problem.
  • Oneview contains all the information about the customers and Service Request (SR) is made from our side by analyzing the situation and proper resolution is given as per Resolve.
  • Also worked as a Quality Support for the teams.
  • Troubleshooting of Networking connection, Outlook and Mac mail configurations, Configuration of Wi-fi devices like Printers, Xbox, Playstation4, Mobile devices and Pc’s with router’s and modems.
  • Testing of the BT products like Fixed lines, Modems and Routers (Homehub1.0 , Homehub1.5, Homehub2.0 , Homehub3.0, Homehub3A, Homehub4.0, Homehub4A, Homehub5), Digital boxes like Humax and Youview.
  • Worked on the software Go to Assist, Resolve, Oneview, and Webmail.
  • Direct interaction with the clients for resolution of the problem.

Education

Bachelor of Computer Applications - programming and software development

Swami Vivekanand Subharti University
Meerut
06.2022

Skills

Proficient in data quality assurance

Data manipulation using SPSS techniques

Expertise in managing complex data structures

Quality control for survey datasets

Skilled in Decipher and Qualtrics

Creating macros to streamline repetitive processes

Client-Specific Data Formatting, Merging, and Logic Execution

Workflow Optimization to Reduce Manual Effort and Errors

SPSS (syntax, data manipulation, statistical analysis)

Excel (Advanced functions, Pivot Tables, Macro recording)

Python (Pandas, NumPy, DuckDB)

Staff training and development

Project management

Operations management

Websites, Portfolios and Profiles

linkedin.com/in/vaibhav-gahlot-1b234176

Interests

Technology
Cricket
Music
Gaming
Dance

Timeline

Associate Manager

B3 Intelligence
08.2016 - 06.2025

Junior Engineer Product Support

HCL Technologies
04.2014 - 03.2015

Bachelor of Computer Applications - programming and software development

Swami Vivekanand Subharti University

Similar Profiles

CREATE PROFILE
VAIBHAV GAHLOTMarket Research