Rishita Rao

Experience

• 

  Omdena

  Sept 2020 - Mar 2021

  Data Engineer intern

  • Worked on Omdena AI challenge with the World resource institute to build an AI model on Economic well being in India.• Implemented the model with satellite images and census data using K-NN algorithm.• The model looks for features related to urbanization and changing agriculture pattern to predict the level of economic well being more accurately.

• 

  Levio

  Jun 2021 - Jul 2023

  Junior Data Engineer

  - Developed stored procedures for backend OLTP database reducing 4X times network traffic between frontend and database.- Centralized data across multiple databases using IBM datastage which lead to streamlined analysis and enhanced decision making.- Designed robust data roll back database architecture for a feature using versioning and enabled efficient data recovery which improved user confidence in the feature.- Achieved more than 5X optimization for an existing alerts function, reducing the operating costs by 50%. Show less

• 

  Lotlinx, Inc.

  Jul 2023 - now

  Data Engineer

  - Developed CDC based event driven architecture to replace compute heavy salesforce to bigquery batch pipelines.- Designed pipelines to handle sensitive PII data from multiple different external data sources.- Developed pipelines to optimize vehicle inventory management by integrating with several internal and external interlinked api`s.- Built SCD type 2 Sqlmesh models designed in such a way that it achieved automated data backfilling, has version control enabled to track customer changes and orchestrated it using airflow saving 20 hours per week of manual effort. Show less