PG

prachi gupta

Newcastle upon Tyne, UK

Open to

India

Work style

full-time, contract

Availability

Available in 30 days

Contact details — on requestProof of Work — on request

Experience

R

Data Analyst

Reputation Leaders · Dec 2024 – Present

Not yet confirmed
  • 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.
S

Research Analyst

Squire Patton Boggs · Nov 2023 – Dec 2024

Not yet confirmed
  • 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
N

Research & Data Analyst Intern

Northumbria University · Apr 2023 – Jun 2023

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

Skills 0 proven through work

Also works with

Decision MakingFunctional TestingData ValidationSurvey Distribution and RecruitmentProject ExecutionRisk and Controls AssessmentWork Planning and PrioritizationDashboard UI DesignMicrosoft ExcelData VisualizationPower BIGoal setting (defining key results)PostgreSQL Database UsageTask AutomationETL Pipeline DevelopmentData TransformationVBA ScriptingData ExtractionAPI IntegrationData-Driven RecommendationsSurvey Design

Proof of Work

Proof of Work

prachi shares this with people who ask. You'll hear back either way.

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

Links

LinkedIn

linkedin.com/in/prachigupta2609

Projects

Demographic Data Pipeline (API Integration)

Case study

UK Energy Pricing Analysis (SQL Python. API)

Case study

Coffee Shop Membership Dashboard (Power BI)

Case study

Contact details

Contact details

prachi shares this with people who ask. You'll hear back either way.

Ask about this candidate

ClaudeChatGPTPerplexity

AI responses may contain errors. Proof status and source information are provided by Proof of Skill.

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