Economics Student @ University of Manchester

Nancy Gidwani

Data Analyst | Economics

Final-year BSc Economics student at the University of Manchester with public-sector and research experience across the Office for National Statistics and SEI. I use SQL, Python, Power BI, R, and Excel to turn economic and financial datasets into clear analysis, dashboards, and decision-ready insights.

SEI research internshipONS data science summer schoolPortfolio projects in SQL, Python, and Power BI
NG

Nancy Gidwani

Data Analyst | Economics

nancyjgidwani@gmail.com
Manchester, UK
Open to analyst, research, and internship opportunities

Education

Academic background

BSc Economics Hons

University of Manchester | 2023 - 2026

Final year

Core Modules

Advanced EconometricsAdvanced StatisticsAdvanced MathematicsInvestment AnalysisFinancial Decision MakingApplied Practical InvestingEconomics for Public Policy

Work Experience

Professional journey

Research Intern, SEI

Jul 2025 - Oct 2025

University of Manchester

Stock Picking Strategies: Evaluating Buy and Hold Investments Over a Quarter Century

  • Collected and cleaned CRSP returns for S&P 500 constituents via WRDS from 1963 to 2024, enabling analysis across 38 rolling 25-year windows.
  • Modelled buy-and-hold and annually rebalanced Top 5 portfolios versus the S&P 500, calculating CAGR, Sharpe ratio, volatility, and maximum drawdown.
  • Ran Chow and Bai-Perron structural break tests, identifying a post-2015 regime shift in alpha.
  • Built an automated R tidyverse pipeline for data cleaning, rolling-window analysis, and publication-ready tables.

Data Science Summer School

Jun 2025

Office for National Statistics

Group research project

  • Analysed multi-year traffic-camera data for London and Greater Manchester with an ONS mentor.
  • Built an R tidyverse workflow to clean, reshape, and visualise daily time-series data.
  • Engineered time-series features and evaluated anomaly-detection models including Isolation Forest, clustering, and PCA.

Positions of Responsibility

Leadership and impact

Multi-Brand Ambassador

HigherIn Academy | Police Now & Audit

Feb 2026 - present
  • Designed and executed a digital-first marketing strategy across social media.
  • Led on-campus promotional events and stalls, converting passive student interest into verified sign-ups.
  • Collaborated with other ambassadors to coordinate event logistics, increasing stall engagement by 20%.

Peer Mentor, Economics BSc

University of Manchester

Sep 2024 - Jun 2025
  • Mentored first-year economics students through one-to-one and group sessions.
  • Signposted academic and wellbeing services, supporting a smoother transition and retention.

Economics BSc Student Representative

University of Manchester

Sep 2023 - Jun 2024
  • Collected and presented structured student feedback across 8 modules, contributing to improvements in curriculum delivery and teaching practices.
  • Synthesised diverse student feedback and presented key issues to faculty, contributing to 5 improvements in course delivery and learning experience.

Projects

Research and analysis

Power BI | Python | Macroeconomics

UK Economic Health Dashboard

Interactive macro case study linking economic shocks to policy response

Built a 3-page macro dashboard tracking UK inflation, unemployment, GDP growth, and Bank Rate from 2010 to 2024 using official ONS and Bank of England data.

View case study
Python | Finance | Data Visualisation

Pound Cost Averaging vs Lump Sum Investing

Interactive investing case study comparing 4 index ETFs with equal-capital strategy analysis

Tested whether drip-feeding into index funds beats investing the same capital upfront using 10 years of historical ETF data across global markets.

View case study
SQL | Python | React

FTSE 100 Dividend Consistency & Price Stability Analysis

Interactive portfolio case study with SQL outputs and visual dashboards

Built an end-to-end equity screening case study to test which FTSE 100 companies combine reliable dividend growth with lower share-price volatility.

View case study
R

The Impact of Inflation on Exchange Rates and GDP Growth: Germany vs Hungary

Applied Economics Project, University of Manchester. Coordinated project workflow and presented findings on macroeconomic dynamics and policy implications.

Led a 4-person team analysing relationships between inflation, exchange rates, and GDP growth using macroeconomic datasets in R. Cleaned and structured economic datasets and developed data visualisations to identify key trends and relationships across the two economies.

Investment Research

ShadeTree Stock Pitch, Intuitive Surgical (ISRG)

Team awarded 30% of a GBP 25,000 investment pool to be allocated to ISRG within a long-horizon buy-and-hold strategy supporting future student scholarships. Selected as the student representative speaker at the ShadeTree investor dinner in London.

Conducted 3 months of investment research on Intuitive Surgical, combining macroeconomic, demographic, and technology-adoption analysis with industry and competitor mapping. Built a country-screening dataset to assess demand drivers and developed a pitch deck outlining the investment thesis, risks, and catalysts.

Skills & Interests

Technical and personal

Technical Skills

SQL (querying, joins, aggregation, case-study analysis)
Python (pandas, time-series analysis, data preparation)
Power BI (dashboard design, data modelling, storytelling)
R (tidyverse, time-series analysis, statistical modelling)
Excel (financial modelling and structured analysis)
Data analysis (econometrics, anomaly detection, data cleaning)
Bloomberg Terminal

Interests

1

Public speaking and debating - completed 4 years of graded Trinity College London communication examinations, achieving 2 distinctions. Developed through competitive debating and formal elocution training.

2

Dance training - several years of structured training across multiple styles including hiphop, contemporary, and bollywood, developing discipline, performance skills, and the ability to learn complex techniques through consistent practice.

3

Personal investing - actively manage a diversified portfolio focused on global index funds, applying market analysis and asset allocation principles.

Certifications & Awards

Recognition and achievements

Bloomberg Market Concepts (BMC)

Bloomberg LP

Completed a 10-hour course covering economic indicators, currencies, fixed income, and equities, with hands-on exposure to the Bloomberg Terminal.

The Stellify Award

The University of Manchester

Recognized for social responsibility and leadership through the Ethical Grand Challenges in social justice and workplace ethics.

Trinity College London Communication Skills Examination

Trinity College London

Completed 4 years of graded communication examinations covering public speaking, debating, and elocution, achieving 2 distinctions across the examination series.

Volunteering

Community impact

Science and Industry Museum (PowerUp)

Volunteer

Supported visitors at interactive gaming exhibits and assisted with event logistics across 25+ hours. Developed communication skills engaging with diverse audiences including children and non-technical visitors.

Ardwick Climate Action

Volunteer

Participated in community park clean-ups and environmental initiatives including the World Record Breaking Bulb Bonanza. Contributed to a team effort planting approximately 200 bulbs in a single afternoon as part of a local ecosystem restoration project.

Let's Connect

I'm open to analyst roles, internships, research collaborations, and conversations about economics, investing, and data.