Panwar - Software & Data Engineer

About Me

I'm a data-driven engineer who enjoys designing scalable systems, streamlining pipelines, and uncovering insights that power intelligent applications.

My Journey

With over 4 years of experience in data engineering and analytics, I specialize in building scalable data pipelines, automating workflows, and delivering clean, insight-driven solutions. I'm passionate about turning complex data into actionable outcomes through robust systems, clean code, and effective visualizations.

GitHub LinkedIn panwarprerak98@gmail.com

Quick Facts

Danville, California, 94526 (Open to Relocate)

4+ Years of Experience

Master's in Computer and Information Science | 3.97 GPA

Code & Data Explorer

Education

My academic background and continuous learning journey in computer science and technology.

Master's

Computer and Information Science

University of Massachusetts umassd.edu 🔗

September 2023 - May 2025 | GPA: 3.97

Bachelor of Technology

Computer Science and Engineering

Graphic Era University geu.ac.in 🔗

July 2015 - May 2019 | GPA: 3.50

Work Experience

From code to insights—my story of turning ideas into real-world software and data solutions.

Data Engineer, Analyst

May 2024 - August 2024

New England Coastal Wildlife Alliance

necwa.org 🔗

• Applied Random Forest to impute missing values, improving data completeness by 30% and reducing manual input collection
• Developed scalable ETL workflows in Python, cutting processing time by 30% and enabling faster analytics and reporting
• Deployed Power BI dashboards with KPIs and drill-downs, cutting manual reporting time by 50% for over 4M records

Data Engineer

August 2020 - July 2023

Erasmith

erasmith.com 🔗

• Enhanced SQL query performance by 15% through indexing and I/O optimization, speeding up dashboards and ad-hoc analytics
• Built fault-tolerant microservices and APIs to ensure reliable data tracking and integration across systems
• Maintained historical data accuracy by implementing SCD logic in reporting layers, enhancing trend insights
• Migrated to Cassandra and improved query speed by 40% through data modeling
• Built secure, ML-ready ETL pipelines to streamline data access and boost model accuracy by 20%

Data Engineer, Analyst

June 2019 - July 2020

Wipro

wipro.com 🔗

• Resolved 600+ data issues with Python and SQL validation, cutting support tickets by 40%
• Automated Power BI reports, saving 2 hours daily and enabling real-time monitoring of data quality issues
• Managed critical data tasks in Agile via Jira, accelerating analytics delivery
• Contributed to team meetings and project planning

Featured Projects

A collection of end-to-end projects showcasing my skills in real-time systems, machine learning, and cloud-based data engineering.

Real-Time Fraud Detection

Real-time fraud detection system with Kafka, Python, MySQL, and XGBoost. Deployed via Docker with 1.8M transactions streamed and LLM-powered insights using LangChain + RAG.

Python MySQL Kafka Docker Machine Learning

GitHub

Movie Recommendation System

Content-based movie recommendation system using Natural Language Processing and vectorization. Achieved 80% accuracy in matching top suggestions to user preferences.

Python NLP Vectorization Cosine similarity Machine Learning

GitHub

Scalable ETL pipeline for Analytics

End-to-end Azure ETL pipeline using Azure (ADF, ADLS, Synapse), Databricks and Spark. Reduced manual effort by 90% and enabled real-time analytics with Medallion Architecture.

Azure Services Databricks Python Spark SQL Power BI

GitHub