Shivani Chauhan

Collaborated in the migration of Assets & Flows and Client Accounts Management applications from On-prem Oracle to Snowflake Data Warehouse. Designed 15+ fault tolerant data pipelines and implemented data models in Snowflake using dbt to transform data coming from disparate sources. Orchestrated vendor data ingestion to AWS S3 data lake from various file types (JSON, .csv, excel, .txt) using Airflow. Deployed Stored procedures, UDFs, and data models using GitLab CI/CD. Established robust data cataloging using dbt docs and Automated discovery & investigation of data quality issues using data products. Contributed to the enhancement of Master data management (MDM) application, ensuring data consistency and optimal performance. Assisted business delivery teams in implementing scalable solutions and provided technical guidance on best practices.

Collaborated in water quality assessment of River Ganga using Machine Learning on a large structured time-series dataset. Improved the model accuracy by data mining and statistical analysis using DST.

Developed an end-to-end model using AWS to capture, compare and update attendance information on an hourly-basis and display it in a web dashboard.