Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Soumya Upadhyay

Bengaluru

Summary

Analytics Engineer with expertise in SQL (MySQL, Redshift, Athena) and Python, specializing in building and optimizing data pipelines for large-scale reporting and analytics. Skilled in query tuning, reporting performance improvements, and integrating data from multiple sources into a data warehouse. Experienced in delivering accurate, high-quality datasets to power BI tools such as Power BI, Tableau, and Sprinkle. Adept at bridging the gap between data engineering and business analytics by ensuring scalable, reliable, and actionable insights for decision-making.

Overview

5
5
years of professional experience

Work History

Senior Software Engineer

LeadSquared
Bengaluru
04.2025 - Current
  • Designed and optimized SQL queries across MySQL, Redshift, and Athena, reducing query execution times and improving overall report refresh speeds.
  • Led initiatives to enhance report performance for large-scale analytical dashboards, enabling faster data-driven decisions.
  • Developed and maintained robust pipelines for ingesting structured and semi-structured data from various databases into data lakes, ensuring high availability and accuracy.
  • Introduced automation scripts in Python to validate datasets and identify anomalies before loading into analytical layers.
  • Mentored junior engineers on query optimization techniques, best practices for pipeline development, and BI tool integrations.
  • Collaborated with data science teams to support AI/ML initiatives by preparing and curating high-quality datasets for modeling purposes.
  • Acted as a point of escalation for troubleshooting performance bottlenecks in high-priority analytics reports.

Software Engineer

LeadSquared
Bengaluru
07.2021 - 03.2025
  • Wrote and optimized SQL queries to retrieve, transform, and aggregate large datasets for business reports.
  • Worked on improving dashboard performance in Power BI and Tableau by implementing query-level optimizations and incremental refresh strategies.
  • Set up and monitored ETL pipelines to transfer data from transactional systems to data lakes for analytics consumption.
  • Collaborated with analysts to define data requirements and design efficient query logic.
  • Performed data validation checks to ensure accuracy in reports delivered to stakeholders.
  • Maintained and enhanced BI reporting solutions using Logi Studio and Sprinkle.
  • Assisted in troubleshooting and resolving report-related issues within tight deadlines.

Intern - Software Engineering

LeadSquared
07.2020 - 06.2021
  • Collaborated with senior engineers to understand best practices in query optimization, report performance tuning, and data pipeline design.
  • Assisted in writing SQL queries to extract, clean, and transform raw data for business reporting and analysis.
  • Supported the development of dashboards in Logi Analytics/Sprinkle Data by preparing datasets and creating visualizations under senior guidance.
  • Participated in data quality checks, ensuring consistency and accuracy across reporting layers.

Education

Bachelor of Technology - CSE

LPU
School Of CSE
07-2021

Skills

  • Databases & Query Languages: MySQL, Amazon Redshift, AWS Athena
  • Programming: Python (data processing, automation)
  • BI Tools: Power BI, Tableau, Logi Analytics, Sprinkle Data
  • Data Engineering: Pipeline creation, Data Warehouse integration

Accomplishments

  • Star of the Quarter - (Q4 2023)

Timeline

Senior Software Engineer

LeadSquared
04.2025 - Current

Software Engineer

LeadSquared
07.2021 - 03.2025

Intern - Software Engineering

LeadSquared
07.2020 - 06.2021

Bachelor of Technology - CSE

LPU
Soumya Upadhyay