Jasveer Singh
Dehradun
Summary
ETL/SQL Developer with 4+ years of experience in data integration, migration, and performance optimization. Proficient in T-SQL, SSIS, SSRS, and Power BI, with hands-on experience in transforming data from SQL Server, MySQL, FoxPro, and Tally into actionable insights. Skilled in query tuning, API integration, and modern data platforms like Azure and DataBricks.
Overview
4
4
years of professional experience
Work History
TechOps Lead
PcsInfinity
05.2024 - Current
- - Spearheaded development and enhancement of the Asset Infinity application, creating dynamic menus, submenus, forms, and data grids.
- - Developed and integrated APIs for data exchange and implemented stored procedures for efficient data binding and storage.
- - Focused on optimizing stored procedures and SQL queries, reducing execution times and improving application responsiveness.
- - Provided ongoing production support, resolving critical bugs and issues reported by clients with quick turnaround.
- - Designed and implemented data ingestion workflows to synchronize daily data from Oracle, SAP, and other sources, seamlessly integrating it into the Asset Infinity application
- - Led cross-functional teams to enhance application performance, achieving noticeable gains in user satisfaction and system efficiency.
SQL Developer & Data Engineer
Scalability Engineers
04.2021 - 05.2024
- Client: Aditya Birla Capital
- - Diagnosed and optimized underperforming stored procedures and queries to enhance backend processing.
- - Developed robust SSIS packages for ETL processes and created SSRS reports tailored to business requirements.
- - Led the database migration project from SQL Server to DataBricks using PySpark, translating legacy SQL logic into modern workflows.
- Client: Teknik Engineers
- - Built a scalable ETL system from scratch, handling data ingestion from MySQL, SQL Server, Tally, and FoxPro.
- - Designed incremental staging logic and automated workflows using SSIS for reliable daily data sync.
- - Created SSRS and Power BI dashboards to support analytics for various departments.
- - Deployed scripts and ETL solutions across multiple distributor systems remotely, ensuring consistency and uptime.
- Client: CoreCard India
- - Conducted in-depth analysis of SQL Server performance using SQL Profiler to identify slow-running queries.
- - Rewrote stored procedures and introduced indexing strategies to improve system efficiency.
- - Supported code reviews and provided insights on SQL development best practices.
- - Maintained database versioning using SVN and participated in peer code evaluations.
Education
BCA -
DIT University
01.2021
12th - undefined
S.G.R.R. Public School
01.2018
10th - undefined
S.G.R.R. Public School
01.2016
Skills
- Languages: T-SQL, PySpark, Python
- ETL Tools: SSIS
- Reporting: SSRS, Power BI
- Databases: SQL Server, MySQL
- Big Data: DataBricks
- Version Control: Git, SVN
- Tools: SSMS, Visual Studio, JIRA, Azure DevOps, SQL Profiler
- Others: FoxPro, Tally
Timeline
TechOps Lead
PcsInfinity
05.2024 - Current
SQL Developer & Data Engineer
Scalability Engineers
04.2021 - 05.2024
12th - undefined
S.G.R.R. Public School
10th - undefined
S.G.R.R. Public School
BCA -
DIT University
Similar Profiles
ANKIT BAHUGUNAANKIT BAHUGUNA
Territory Business Executive at TALENT INDIA AHMEDABADTerritory Business Executive at TALENT INDIA AHMEDABAD
Shubham KumarShubham Kumar
Scrum Mater / Test Analyst at INFOSYSScrum Mater / Test Analyst at INFOSYS
Arjun VermaArjun Verma
Founder & Business Development Head at Xpress PharmacyFounder & Business Development Head at Xpress Pharmacy
BIRENDER SINGHBIRENDER SINGH
Bakery and Pastry Department (PASTRY CHEF) at BAKE WISH PVT.LTD. (Bakingo)Bakery and Pastry Department (PASTRY CHEF) at BAKE WISH PVT.LTD. (Bakingo)
Ashish GawandiAshish Gawandi
TechOPS-Lead (Team Size 12) at HealthEdge Technologies India Pvt. LtdTechOPS-Lead (Team Size 12) at HealthEdge Technologies India Pvt. Ltd