Ruthwik Rampelly
Sparks
Summary
Data Engineer with 3+ years of experience transforming complex datasets into actionable insights across diverse industries, including finance and logistics. Expertise developed in financial data analysis, predictive modeling, and supply chain optimization through a progression of increasingly complex roles. Developed intricate SQL queries and Python scripts to extract and transform financial data, visualizing key performance indicators in Tableau for investment product performance. Designed efficient data pipelines using AWS Glue, processed large datasets, and implemented dbt for automated data quality checks, ensuring accuracy for regulatory reporting. Utilized Snowflake for scalable data storage, optimizing retrieval times for complex financial analytics. Built predictive models with scikit-learn to forecast customer churn, informing marketing strategies. Optimized logistics data analysis for supply chain efficiency, identifying bottlenecks, and reducing spoilage. Created interactive dashboards in Tableau and Power BI, significantly improving daily reporting and supporting critical decisions in inventory management and on-time delivery. Delivered consistent measurable business value through advanced data solution design.
Overview
6
6
years of professional experience
Work History
Production Associate – LFP Cell Manufacturing
Tesla, Inc.
11.2025 - Current
- Operate in high-volume lithium iron phosphate (LFP) battery manufacturing, ensuring strict adherence to quality, safety, and operational standards
- Leveraged SQL and advanced Excel (dashboards, pivot tables, reporting) to analyze production metrics, identifying bottlenecks that impacted operational efficiency
- Develop data-driven insights to improve process efficiency, yield, and downtime reduction
- Collaborated with engineering, quality, and operations teams to troubleshoot production and system issues, ensuring timely resolutions to maintain production flow
- Built internal data tracking and reporting solutions, enhancing visibility into key manufacturing KPIs for informed decision-making
- Applied data analysis and monitoring techniques to support operational decision-making
- Achieved a high performance rating (2.5/3), a rare recognition for strong contributions and consistency
- Received multiple recognition shoutouts from managers, supervisors, and teammates for teamwork, ownership, and problem-solving
Data Engineer
Capgemini
05.2020 - 06.2023
- Built and optimized Big Data solutions using Hadoop and Apache Spark for distributed data processing and analytics
- Designed and developed scalable ETL pipelines to ingest, transform, and load large volumes of structured and unstructured data
- Engineered batch and real-time data processing workflows, improving system scalability and performance
- Optimized data pipelines by tuning Spark jobs and SQL queries, enhancing processing speed and workflow efficiency
- Implemented data modeling and data warehousing solutions to support enterprise analytics
- Developed complex SQL queries, joins, and stored procedures for data extraction, transformation, and reporting
- Designed and implemented CI/CD pipelines for data workflows, enabling automated deployment, testing, and monitoring
- Collaborated with data analysts, developers, and business stakeholders to deliver impactful data-driven solutions
- Monitored and troubleshot pipelines, resolving performance bottlenecks and system failures
- Contributed to secure data handling practices, aligning with enterprise security and compliance requirements
Education
Master’s - Information Technology & Management
St. Francis College
05-2025
Skills
- SQL, Python
- ETL pipelines
- AWS Glue and AWS S3
- Snowflake, Scikit-Learn
- Pipeline automation
- Hadoop and Apache Spark
- CI/CD
- Git version control
- Tableau
- Power BI
- Identity and access management
- Security monitoring
- Risk mitigation
- Advanced Microsoft Excel
Accomplishments
- Top Performer 2.5/3
Affiliations
- Data Pipeline Development(ETL Projects)
- CI/CD Implementations
- Cloud Projects(AWS, Azure)
Timeline
Production Associate – LFP Cell Manufacturing
Tesla, Inc.
11.2025 - Current
Data Engineer
Capgemini
05.2020 - 06.2023
Master’s - Information Technology & Management
St. Francis College