prachi gupta

+•• ••••• •••••••••••@•••••.com

Data Analyst · Reputation Leaders · 3.2 yrs

  • Newcastle upon Tyne, UK
  • Open to India
  • In 30 days

Ask about prachi

Skills

Claimed

Decision MakingFunctional TestingData ValidationSurvey Distribution and RecruitmentProject ExecutionRisk and Controls AssessmentWork Planning and PrioritizationDashboard UI DesignMicrosoft ExcelData VisualizationPower BIGoal setting (defining key results)

Proof of Experience

Data Analyst

Reputation Leaders · Dec 2024 – Present

  • Developed an API driven ETL data pipeline integrating the US Census Bureau and Eurostat APIs, with Google Sheets, automating demographic data extraction across 10+ countries.
  • This applied automated validation rules to ensure the most recent available demographic data was extracted while reducing manual effort by 100%
  • Developed a dashboard integrating the team's Google Calendar across 3 time zones, using Google Apps Script.
  • This enabled vendors to independently schedule interview slots, directly supporting 150+ interviews with zero manual coordination.
  • Maintained Python data pipelines supporting the global tracking study, enabling efficient preparation of datasets for seasonal adjustment and reporting.
  • Conducted statistical analysis of A/B message testing results to evaluate marketing concepts and provide evidence-based recommendations for client communication strategies.
  • Designed and analysed surveys across finance, healthcare, and education sectors to identify consumer attitudes, behavioural gaps, and campaign effectiveness, delivering actionable insights used in stakeholder decision-making.

Research Analyst

Squire Patton Boggs · Nov 2023 – Dec 2024

  • Analysed DEI data from 1,000+ UK employees using SQL and Power BI, developing KPIs, dashboards, and insights to support strategic workforce planning.
  • Reduced data preparation time by 40% by building a Power Query normalisation workflow for market data across 10+ countries, used by UK and Australian business development teams

Research & Data Analyst Intern

Northumbria University · Apr 2023 – Jun 2023

  • Analysed and visualised DEI data for 300+ architecture students using Excel and Power BI; results presented in the Athena SWAN application.

Proof-of-Work

No completed sessions yet. Anything prachi finishes shows up here with the evidence behind it.

Proof of Education

Certification, Advanced Data Analytics with Predictive Analysis

1Step Grow · 2024 — 2025

MSc, Marketing

Northumbria University · 2022 — 2023

BBA, BBA

Guru Gobind Singh Indraprastha University · 2017 — 2020

A Proof CV — one profile, kept current, with the proof attached. Back to the portal