Satyam Agrawal

About

I am an experienced Data Solutions Engineer with a strong background in creating automated ETL pipelines, data modeling, and real-time data processing. Skilled in Python and SQL, I have a proven track record of enhancing data quality and performance for enterprise clients. My passion lies in leveraging technology to provide data-driven solutions that meet evolving client needs.

Work

Hevodata

|

Data Solutions Engineer

→

Summary

Built and maintained automated ETL pipelines using Hevo's platform, reducing data latency by up to 80% and enabling real-time reporting for enterprise clients including RNDC, Clinicalink, and Hornblower.

Highlights

Developed advanced Python scripts for data cleansing, filtering, and workflow optimization, improving pipeline throughput by 3x and reducing data quality issues by 40%.

Designed 50+ SQL data models with dbt for post-load transformations, improving data reliability and reducing reporting errors by 35%.

Implemented Kafka-based real-time streaming pipelines processing 500K+ events/hour, reducing data lag to under 5 seconds for high-throughput use cases.

Integrated and managed cloud data warehouses including Google BigQuery, Amazon Redshift, and Snowflake for scalable storage and analytics.

Acted as primary technical advisor for 20+ global clients, resolving 95% of issues within SLAs and maintaining a CSAT score of 4.8/5.

Collaborated with engineering, product, and account teams to co-develop 3+ new features based on client feedback, reducing escalations by 25%.

The Tann Mann Gaadi

|

Yolo Object Detection Intern

→

Highlights

Contributed to developing a real-time object detection system using YOLOv3 and CNN, achieving 85%+ accuracy in model validation.

Performed image annotation, testing, and tuning using OpenCV and PyQt5 to enhance UI responsiveness and detection speed.

Education

Jaypee Institute Of Information Technology, Noida

→
B.Tech Electronics and Communication Engineering Grade: 7.8

G.D Higher Secondary School, Morena

→
XII (MPBSE) Grade: 91.6%

Skills

Tech Stack

Apache Kafka, dbt, REST APIs, Postman, AWS, Git, Linux, CI/CD (basic), ETL, Data Modeling, Data Pipelines, Analytics.

Databases

MySQL, PostgreSQL, MongoDB, MSSQL.

Languages

Python, C++.

Data Warehouses

Snowflake, Redshift, BigQuery.

Projects

Stock Price Prediction Model

Summary

Designed a forecasting system using LSTM and Linear Regression for time series analysis of stock prices.

Movies Recommendation System

Summary

Built a recommendation engine using clustering and classification algorithms.