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 CSE07-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
Similar Profiles
Alok AgarwalAlok Agarwal
SENIOR PRODUCT SUPPORT ENGINEER at LEADSQUAREDSENIOR PRODUCT SUPPORT ENGINEER at LEADSQUARED
Cassius CleetusCassius Cleetus
Product Solution Specialist KAM Sr.Manager SMB at LeadSquaredProduct Solution Specialist KAM Sr.Manager SMB at LeadSquared
Suchana NaskarSuchana Naskar
Senior Manager, Performance Marketing at LEADSQUAREDSenior Manager, Performance Marketing at LEADSQUARED
Sabir PashaSabir Pasha
Senior Technical Solutions Engineer at BARRACUDA NETWORKSSenior Technical Solutions Engineer at BARRACUDA NETWORKS
Vishnu Putri SVishnu Putri S
Secondary French Teacher at Ebenezer International SchoolSecondary French Teacher at Ebenezer International School