Ruchira Ramani

About Ruchira Ramani

Experienced Data Engineer specializing in SaaS cost reduction, data system optimizations (AWS Glue, Snowflake, DBT Cloud), and driving data insights. Proficient in PySpark, Python, SQL, and cloud solutions, with degrees in Computer Science and Mathematics from Michigan State University. Dedicated to using technology to solve complex challenges and boost efficiency.

Experience

1. Senior Data Engineer

   Vanta

   Sep 2022 — Present

   Significantly reduced SaaS costs by 85% through strategic replacement of Stitch with AWS Glue,using PySpark for job scripting and Terraform for deployment.Participated in the migration from Redshift to Snowflake, optimizing data loads and enhancing data accessibility.Oversaw and enhanced the company’s ARR pipeline in DBT Cloud, improving daily ARR visibility. Utilized draw.io for data flow diagrams and Sigma for dashboard visualizations, with data dictionaries maintained in Secoda.Developed and optimized datasets for the support team in Zendesk using DBT models in Snowflake, ensuring efficient data access through Polytomic reverse ETL syncing.Led a pivotal Dagster orchestration POC, validating its ROI and integration capabilities for SaaS efficiency.

Education

• Michigan State University

  Bachelors of Arts, Mathematics

  2010 — 2014

• Michigan State University

  Bachelors of Science, Computer Science and Engineering

  2010 — 2014

Skills

• Php
• Sql
• C
• Programming
• Microsoft Office
• Html
• Hive
• Microsoft Excel
• Java
• Databases
• Research
• Mysql
• Hadoop
• Joomla
• Css
• Mathematica
• Python
• Javascript