Savitri Ranjan
Summary
Experienced in transforming complex datasets into actionable insights using Python, SQL, and Tableau. Adept at visualising data trends to guide business decisions and optimise performance. Enthusiastic about tackling analytical challenges and making data-driven recommendations.
Overview
1
1
Certification
9
9
years of professional experience
Work History
Data Analyst
ShiftPartner
London
02.2024 - Current
At ShiftPartner, an NHS workforce platform. I turn workforce data into reports that help teams make decisions about operations, staff performance, and skills development. I also build the backend APIs that deliver those reports, working with the development team to get them into the application.
- Programming: R, Python, SQL
- Data sources: AWS Athena, MongoDB, Google Firebase
- APIs: Building and deploying R APIs (Plumber, Docker, AWS ECS), with Python APIs (FastAPI) in progress
- Reporting and design: Designing reports and dashboards, using Figma and Claude Design
- Testing and delivery: User acceptance testing, report testing, and handover documentation for developers
Research Analyst
Aravind Eye Care Hospital (AEH)
Chennai
09.2021 - 05.2022
- Designed and led a 400-patient survey at AEH, Chennai
- Analysed patient demand and demographics within the hospital’s cross-subsidisation model, identifying marketing opportunities and gaps in insurance coverage to improve cost recovery.
Data Analyst – Investment Banking Division (IBD)
Goldman Sachs
05.2019 - 04.2021
- Sourced and analysed financial and market data to support IBD deal teams with valuation, pricing and competitive market analysis.
- Tools & Programming: Microsoft Excel (advanced formulas) and VBA (basic)
Data Analyst Intern – IBD
Goldman Sachs
04.2018 - 06.2018
Education
MSc - Global Healthcare Management (Analytics)
University College London
09-2023
Bachelor of Commerce -
Stella Maris College
India04-2019
Certification
- 2024
- Coursera
- Excel / VBA for Creative Problem Solving
- 2023
- SQL Basics for Data Science
- Health Economics Research Council, University of Oxford
- Applied Methods of Cost Effective Analysis
- 2018
- Excelgoodies Inc, India
- Model Building and Advanced MIS Reporting Microsoft Excel
Timeline
Data Analyst
ShiftPartner
02.2024 - Current
Research Analyst
Aravind Eye Care Hospital (AEH)
09.2021 - 05.2022
Data Analyst – Investment Banking Division (IBD)
Goldman Sachs
05.2019 - 04.2021
Data Analyst Intern – IBD
Goldman Sachs
04.2018 - 06.2018
MSc - Global Healthcare Management (Analytics)
University College London
Bachelor of Commerce -
Stella Maris College