CV

View A PDF Copy

Education

B.S. in Biometry and Statistics, Cornell University, 2023
- GPA - 3.95 (Magna Cum Laude)
- Concentrations:
  - Mathematical Statistics
  - Computational Statistics & Data Management
B.S. in Applied Economics and Management, Cornell University, 2023
- GPA - 3.92 (Magna Cum Laude)
- Dyson Diversity Scholar
- Research Honors (Distinction) in Social Science

Research Interests & Experience

Innovation | Strategy | Science of Science [2 Projects; 2 Years]
Urban & Transport | Industrial Organization [2 Projects; 2 Years]
Development | Education | Healthcare [4 Projects; 4 Years]

Relevant Coursework

Graduate Mathematics
- Real Analysis (A) | Honors Introduction to Analysis (A+) | Stochastic Processes
(Theory) Statistics
- Econometrics | Theory of Statistics | Advanced Biological Statistics | Probability & Statistical Inference
(Applied) Statistics
- Statistical Computing | Risk Simulation & Monte Carlo Methods | Computing using MATLAB | Analytic Modelling
Computer Science
- Object-Oriented Programming & Data Structures | Database Management
Fundamental Mathematics & Economics
- Linear Algebra | Multivariable Calculus | International Trade & Finance | Intermediate Microeconomics | Intro Microeconomics | Intro Macroeconomics
Strategy, Business, & Law
- Strategy | Finance | Business Law

Research Experience

Research Assistant, Cornell University (Spring 2021 - Present)
- Worked under the guidance of Daniela Scur, co-authoring with Michel Best and Renata Lemos, leading the data collection and processing for State Capacity and Responses to Natural Disasters: Evidence from Brazilian Municipalities.
- Successfully web-scraped ~25 million PDF files in Portuguese, and processed them.
- Converted the complicated and unstructured PDFs into more accessible .csv files for further analysis.
- Created topic models to classify text data using the LDA algorithm.
Dean’s Summer Research Fellow, Columbia Business School (Summer 2022 - Present)
- Worked under the guidance of Jorge Guzman (Columbia Business School), co-authoring with Maria Roche (Harvard Business School) and Annamaria Conti (IE Business School) for Incentivizing Innovation in Open Source: Evidence from the GitHub Sponsors Program.
- Created data pipelines and authored an open-source R package (STE).
- Worked on projects in Strategy, Entrepreneurship, and Digital Innovation.
Data Reproducibility Researcher, American Economic Association (Summer 2021)
- Responsible for reproducing results in manuscripts submitted for review to AEA journals under the AEA Data Editor, Lars Vilhuber.
- Debugged and reproduced code in 30+ manuscripts, and verified the validity of the data. Generated reports of the replication process, which were then used to make the review decision for the manuscripts.
- Authored an open-source data utility tool which is used by AEA to upload their reproduction files to Zenodo.
Research Assistant, Cornell University (Spring 2021)
- Worked under the guidance of Reza Moghimi, studying Twitter sentiment’s effects on the financial markets.
- Carried out literature reviews for the paper, studying NLP algorithms to understand which one would be the most effective for our use case.
- Helped in the development of Python code to collect the data and conduct the analysis.

Research Projects

Incentivizing Innovation in Open Source: Evidence from the GitHub Sponsors Program

With co-authors Annamaria Conti, Jorge Guzman, & Maria Roche.

Published in National Bureau of Economic Research (Working Paper), 2024

This paper seeks to understand the effects of the introduction of GitHub Sponsorships on digital innovation. Read more

Dampening Natural Disasters’ Disruptive Effects on Firms and Labor Markets

With co-authors Michael Best, Renata Lemos, & Daniela Scur.

Work In Progress, 2023

This paper seeks to understand the effects of climate shocks on firms and labor markets in Brazil. Read more

Approaches and Resources for Improved Student Outcomes: Evidence from Brazil

Independent Project.

Published in Social Science Research Network (Working Paper), 2022

My undergraduate thesis explores how strategic choices in schools affect student outcomes. Read more

Treatment Effects in Managerial Strategies

Under the guidance of Jorge Guzman.

Published in Social Science Research Network (Working Paper), 2022

This paper seeks to formalize the treatment effects of strategic choices under the Rubin Causal Model. Read more

Data Reproducibility - American Economic Association

Under the guidance of Lars Vilhuber.

Work In Progress, 2021

Worked as a Data Reproducibility Researcher to run reproducibility checks for manuscripts submitted to the AEA. Read more

Twitter Sentiment & Financial Markets - An Event Study

Under the guidance of Reza Moghimi.

Work In Progress, 2021

This paper seeks to study the impact of Twitter sentiments on stock prices. Read more

Dropout Mitigation: A Logistic Modelling Approach

Independent Project.

Working Paper, 2019

This paper seeks to understand and mitigate the determinants of dropout-likelihood in rural Indian schools. Read more

Teaching

CS 1112: Introduction to Computing Using MATLAB Permalink

CS 2110: Object-Oriented Programming and Data Structures Permalink

Software Development

[Open Source] R Package: STE
- R Package to implement the framework developed in Treatment Effects in Managerial Strategies, using machine learning in a causal inference setup.
[Open Source] Python: Upload-To-Zenodo
- Python code to parse directories and upload the code to Zenodo. This is used by the AEA replication team for smoother synchronisation of their files.
[Commercial] Python Package, STATA Package, EXE: Google Maps API - Geocoding & Distance Matrix Calculator
- Used Python, Azure, and Google Cloud to create and maintain a secure environment that authenticates a user within the organization and provides them an easy interface to do geocoding and routing calculations for coordinates.
[Commercial] Python Package: Divestment Optimization Calculator
- Worked on the development of an internal tool that leverages proprietary algorithms to compute large-scale optimization solutions and recommend divestiture packages for multi-market mergers - especially the ones that rely on geographic market definitions (such as hospitals).
[Commercial] Python Package, EXE: Interactive Map Creator
- Pioneered the use of fully-customizable and native interactive maps as legal support exhibits. Innovated internal tools that make this technology readily available to all employees within the firm without any prior training necessary.

Professional Work Experience

Charles River Associates (Antitrust & Competition Economics)
- Associate & Data Scientist (June 2023 - Present)
- Produce economic analyses evaluating the competitive effects of healthcare mergers in the US, building on research from industrial economics, urban economics, and healthcare economics.
- Author white-papers presented to the U.S. Department of Justice and juries to discuss the efficacy of legal frameworks that govern antitrust enforecement policies in the US for the healthcare industry.
- Hold a dual role as a data scientist/software engineer as well, creating interactive EXE tools to enable economic analyses with large scale data with ease.
- Assist with the adoption of cloud computing practices for economic analyses involving big data.
Ascenta Management Consulting
- Founder & CEO (August 2019 - May 2023)
- Recognized as India’s Top 10 Consultants (CEOInsights Mag)
- Headed teams of volunteer consultants working pro-bono with local Indian Small and Medium Enterprises to improve their operations workflows, cut costs, expand their clientele, and provide effective data-driven marketing strategies.
- Consulted 20+ local businesses using data-backed insights to aid resource mobilization and advance the expansion of revenue streams for the firms – raising revenues for our customers by an average of 28% in a 4-month project period.
Cornell Business Analytics
- Vice President (August 2020 - May 2023)
- Motivate team-members to ensure the nurturing of innovative ideas and the timely delivery of deliverables.
- Lead a team of 30 analysts to organize the recruitment screening of 180+ applicants, designing innovative challenges.
- Optimized inventory management for an MNC using management science theory and MS Excel and JavaScript.
- Leveraged data to create visual insights and Tableau dashboards for a startup to establish hotspots for its launch.
Meta
- Big Data & Market Intelligence Analyst Extern (February 2022 - May 2022)
- Collaborated with teams to use data-driven insights for suggesting clients to Meta’s Global Business Group.
- Innovated machine learning models (k-means clustering & random forests) for insights and predictive analytics.
- Consulted for internal teams in Meta, curating a client acquisition strategy for the Small Business Clients Group.
Grant Thornton International LLP
- Research Trainee – Global Research Centre (December 2018 - January 2019)
- Developed a database of client information in order to streamline communication across Grant Thornton India by leveraging Capital-IQ and Avention databases, implementing a heavy use of SQL and VBA for business analytics.
- Analysed companies to profile their strategies and risks to produce thorough SWOT analyses for industries GT India’s clients operate in, while consulting with Australian clients and compiling market-competition research reports for them.

Coding Skills

Scripting Languages
- Python | Java | Visual Basic (VBA) | JavaScript (Intermediate)
Statistical Analysis
- STATA | MATLAB | R
Mapping & Spatial Data
- ArcGIS Pro | Google Maps API | Folium/Leaflet (Interactive Maps)
Data Scraping
- PDFPlumber | BeautifulSoup | Selenium
Big Data & Data Management
- Microsoft Azure | Databricks | SQL | GraphQL | Excel | Google Cloud | Microsoft PowerBI (Intermediate)
Data Visualisation
- Tableau | Adobe InDesign

Honors & Media Coverage

Distinction in Social Science research, with Magna Cum Laude honors at Cornell University.
Recognised as one of India’s Top 10 Business Consultants by CEOInsights Magazine India for my work with Ascenta Consulting.
Research covered in the NBER Bulletin on Entrepreneurship.
Research covered in the Harvard Business School Working Knowledge Newsletter.
Dean’s List for all my semesters at Cornell University.

Vansh Gupta

CV