SHUBHAM TIWARI

Bengaluru

Summary

Detail-oriented Data Engineer with 5+ years of experience in developing and optimizing T-SQL solutions and SSIS-based ETL pipelines. Expertise in data extraction, transformation, and validation, complemented by hands-on experience with Azure Data Factory, Azure , and Power BI. Strong background in query optimization and data quality, targeting a Junior Data Engineer or SQL Server Developer role to leverage SQL proficiency and enhance cloud data engineering capabilities.

Overview

years of professional experience

Work History

Software Engineer – SQL Developer

Dyad Tech Private Limited

Ahmedabad

05.2023 - Current

Developed and maintained Microsoft SQL Server databases for production insurance applications, ensuring high performance, reliability, and data integrity.
Designed and improved stored procedures, functions, views, triggers, and T-SQL queries; tuned slow-running queries using indexing and execution plan analysis.
Created 150+ tables and 100+ procedures, optimizing pipeline performance by 30% for faster data processing.
Built ETL processes using SSIS to extract, transform, load, and reconcile data between source systems and reports.
Worked with Azure Data Factory (ADF) for cloud-based data movement and pipeline orchestration.
Used Azure Databricks on select tasks for data processing and analysis alongside core SQL Server development work.
Built Power BI reports and dashboards to support business reporting needs, in addition to SSRS-based reporting.
Wrote reusable SQL and Python scripts to automate data validation, significantly reducing manual checking efforts.
Provided production support and root cause analysis for database issues, validating deployments to minimize downtime.

Software Associate

Hike

New Delhi

02.2021 - 01.2023

Resolved client support requests efficiently through proactive communication, enhancing user satisfaction.
Diagnosed specific system issues by contacting clients for detailed assessments.
Utilized remote access and on-site visits for effective troubleshooting.
Restored system functionality by troubleshooting hardware and software issues, minimizing downtime.
Installed and upgraded operating systems and computer software.
Maintained operational continuity by resolving networking and connection challenges.
Configured Windows systems while effectively utilizing Linux networking commands.
Provided basic training in computer operations and management, empowering end users to utilize systems effectively.

Education

Bachelor’s Degree in Engineering - Computer Science / IT

Mumbai University

Mumbai

01-2015

Certification -

E-Learning

Skills

Databases & ETL: MS SQL Server, T-SQL, SSIS, SQL Server Agent, SSRS, Execution Plans, Indexing
Cloud / Data Engineering: Azure Databricks, Azure Data Factory (ADF), Azure SQL, Data Warehousing
Reporting & BI: Power BI (reports & dashboards), SSRS
Programming: Python, T-SQL

Tools: Git, SSMS, Microsoft Excel
Methodologies: Agile, Sprint Planning, UAT, Production Support
Languages: English, Hindi

Accomplishments

Delivered SQL Server and ETL enhancements supporting 150+ weekly production releases, maintaining a consistently low defect rate.
Built reusable validation scripts that reduced manual data-quality checking effort, and improved the reliability of recurring data loads.

Timeline