Rishika Gupta

Experience

• 

  Sai Estate Consultants Chembur Pvt Ltd.

  May 2019 - Jul 2019

  Data Scientist

  ● Created and populated an extensive BigQuery database with 1 crore customer response details using SQL and Python, decreasing manual labour by 8 hours/week● Programmed robust forecasting using Scikit-learn on sales data for appropriate target campaigning to improve customer retention by 10%● Created a visually impactful dashboard from the scratch using Python, Django, Pandas, MatplotLib & JavaScript providing real-time insights and trends of the campaign's various key performance indicators Show less

• 

  ICICI Lombard

  Feb 2021 - Jul 2022

  Worked in the Database Team● Devised, debugged, optimised, tested & deployed over 100 PL/SQL scripts & Oracle procedures, enhancing data quality & accuracy by 18%● Automated daily runs & optimised data loads and refresh cycles using Oracle PL/SQL, yielding a time efficiency gain of 25% across daily operations● Assisted in migrating on-premise data infrastructure to AWS cloud services, resulting in 25% cost reduction & improved scalability for growing data demands● Compiled data flow diagrams and documentation for various in-house database-related integrations which improved the onboarding process for new team members by 50% Show less

  • Data Engineer

    Aug 2021 - Jul 2022

  • Technology Intern

    Feb 2021 - Aug 2021
• 

  The Kectil Program initiative of The Malmar Knowles Family Foundation

  Jan 2022 - Dec 2022

  Kectil Fellow 2022

  The title "KECTIL" refers to the "Knowles Educational and Charitable Trust for International Leadership". The goal of this program is to nurture, network, and mentor youth in developing countries who have the potential to be leaders and make a positive difference in their communities, countries and maybe even the world!The KECTIL Program was created to identify and nurture highly talented youth in developing countries who have the potential to make a positive difference in their communities and countries.The Program works to achieve these goals in three parts: a one-year Web-based Program. Show less

• 

  Erasmus Mundus Students and Alumni Association

  Sept 2022 - now

  Program Representative

  Programme Representative for BDMA

• 

  Omdena

  Jul 2023 - Oct 2023

  Junior Engineer
• 

  Demola Global

  Oct 2023 - Dec 2023

  Co-creator
• 

  L'Oréal

  Mar 2024 - Aug 2024

  Data Analyst Intern

  Worked at the Global L'Oreal Luxe Division● Developed Python scripts and Machine Learning methodologies to process, cleanse, and automate anomaly detection for website traffic data collected by Google Analytics, improving data accuracy by 15% and avoiding 10 hours per week of manual data verification● Performed deep-dive analyses of customer purchasing data using Python, unveiling insights that improved customer acquisition strategies by 10%● Engineered a Google Looker Studio dashboard to visualise various key business KPIs, eliminating manual reporting time of 20 hours per week Show less

• 

  The Alan Turing Institute

  Jan 2025 - Feb 2025

  Data Study Group Researcher

  • Analyzed Scotland’s rail (ScotRail) and road traffic data using PostgreSQL and Python to assess mobility trends and quantify the impact of rail disruptions on travel behaviour• Conducted exploratory data analysis (EDA) and visualised disruption impacts using Python & Knowledge Graphs, uncovering patterns in passenger fluctuations• Estimated carbon emissions from modal shifts using Python-based approaches to contribute to sustainable transportation solutions

• 

  CiTIUS - Research Centre on Intelligent Technologies

  May 2025 - now

  Researcher