Surbhi Mehrotra
Researh Analyst and Data Analyst
Gurugram
Summary
Analytical Research & Data Analyst with 7 years of experience leveraging data for strategic business decisions. Proficient in SPSS, Power BI, Excel, Decipher, Qualtrics and statistical modeling to deliver actionable insights. Skilled in managing large datasets, ensuring data accuracy, and optimizing workflows for operational efficiency. Experienced in survey research, market insights, consumer analytics, and collaborating with cross-functional teams to drive business growth.
Overview
7
7
years of professional experience
3
3
Certifications
Work History
Operations Research Analyst
Paradigm Sample
04.2022 - 05.2024
- Conducted link testing and survey validation using tools such as Decipher and Confirmit to ensure a smooth respondent experience and data integrity.
- Performed comprehensive data quality checks, including identifying straight-liners, speeders, and verifying open-ended responses (verbatim checks).
- Reviewed and quality-checked diverse deliverables, such as data tables, coded data, reports, and scorecards, to maintain 100% accuracy.
- Created and analyzed cross-tabulations using Decipher and Qualtrics for actionable insights and reporting.
- Utilized SPSS for data management tasks, including writing basic syntax, running frequencies, updating datasets, and validating outputs.
- Designed and developed insightful PowerPoint reports, summarizing key findings and business implications.
- Leveraged advanced Excel skills (pivot tables, lookups, formulas, and data visualization) for data analysis and dashboarding.
Associate Project Manager
Paradigm Sample
10.2020 - 04.2022
- Led end-to-end research projects (B2B and B2C, Tracker, Full-Service, Healthcare), delivering 100% on-time, high-quality outputs within budget.
- Managed data collection, sampling, and survey execution using tools like Pure Spectrum, Lucid, Ipsos, and Cint, improving project efficiency by identifying gaps.
- Developed project plans with clear milestones, assessed feasibility, and implemented risk mitigation strategies, reducing potential delays and resource constraints.
- Acted as the primary client liaison, providing timely updates, resolving escalations, and maintaining consistently high client satisfaction.
- Coordinated with vendors and internal teams, enhanced survey design, and optimized workflows to improve reporting accuracy and overall operational efficiency.
Associate Project Manager
Quest Mindshare
05.2019 - 05.2020
- Led cross-functional teams to streamline project workflows, enhancing efficiency and ensuring timely project delivery.
- Mentored junior project staff, fostering professional growth and enhancing team capabilities within project management practices.
Research Analyst
Penguin International
05.2018 - 05.2019
- Led market research projects, providing insights on revenue forecasting and financial trends.
- Collected, cleaned, and transformed raw datasets into usable formats for analysis.
- Demonstrated excellent teamwork by coordinating with cross-functional teams to meet tight deadlines.
- Delivered clear and concise communication to global clients and internal stakeholders.
- Conducted comprehensive market research and analysis to support data-driven decision-making, enhancing project outcomes and operational efficiency.
Research Analyst
Project Guru
08.2017 - 05.2018
- Developed and maintained complex databases to track research findings, improving data accessibility and stakeholder engagement across projects.
- Collaborated with cross-functional teams to design and implement strategic research initiatives, resulting in increased project alignment and stakeholder satisfaction.
- Analyzed trends and patterns in data sets to identify insights, informing strategy development and enhancing overall project performance.
- Led training sessions for junior analysts, fostering skill development and promoting best practices in research methodologies and data analysis.
Education
Master of Arts - Economics
Guru Gobind Singh Indraprastha University
Delhi06.2017
Bachelor of Arts - Economics
Galgotias University
Greater Noida, India07.2015
Skills
Data Analysis & Tools: IBM SPSS, STATA, E-Views, Python, SQL, R, ETL, Power BI, Tableau, Qualtrics, Data Mining, Data Warehousing, Regression Analysis, Forecasting
Additional Information
Skills & Learning During Career Break (April 1, 2024 - May 8, 2025)
- Data Analysis & Statistics: Regression, classification, clustering, outlier detection, missing value treatment, correlation analysis.
- Programming & Databases: Python (Pandas, NumPy, Matplotlib, Scikit-learn, TensorFlow), SQL (Oracle, CRUD, joins, subqueries).
- Data Visualization & BI Tools: Power BI & Tableau dashboards, DAX, charts, slicers, KPIs, drill-down reports.
- Machine Learning & AI: Supervised & unsupervised learning, Decision Trees, Random Forest, SVM, KNN, CNN, RNN, NLP (text preprocessing, classification, feature engineering).
- Advanced Excel & Reporting: Pivot Tables, VLOOKUP/HLOOKUP, INDEX-MATCH, conditional formatting, macros, dashboards, data cleaning.
Key Takeaways:
- Strengthened ability to translate complex data into actionable insights using modern analytics tools.
- Enhanced skills in data visualization, predictive modeling, and AI applications.
- Prepared to apply these technical skills in real-world market research, consumer insights, and business analytics projects.
Certification
PCP, Data Science and Business Managerial Analytics
Timeline
Operations Research Analyst
Paradigm Sample
04.2022 - 05.2024
Associate Project Manager
Paradigm Sample
10.2020 - 04.2022
Associate Project Manager
Quest Mindshare
05.2019 - 05.2020
Research Analyst
Penguin International
05.2018 - 05.2019
Research Analyst
Project Guru
08.2017 - 05.2018
Master of Arts - Economics
Guru Gobind Singh Indraprastha University
Bachelor of Arts - Economics
Galgotias University