Hitesh Sonone profile photo 1 on Tal

Hitesh Sonone

Team Lead / IT Analyst | 9+ Years Experience | MS SQL Server | SSIS/SSRS | ASP.NET | C# | Azure Data Factory | Data Engineering Enthusiast

Mumbai

10+ years of work experience

Tata Consultancy Services
Apr 20233 yrs 1 moPresent

Thane, Maharashtra, India

Project: WTW (Willis Towers Watson) Mumbai, India ● Role: Team Lead & IT Analyst (Italy & European Applications) ● Simultaneously manage leadership duties for Italy-region applications while driving technical delivery for the broader European application suite. ● Lead a dedicated squad for the Italy market, ensuring 100% SLA compliance and overseeing the modernization of legacy reporting systems. ● Execute hands-on development and maintenance for European insurance applications, working extensively with SSRS, SQL Stored Procedures, and .NET. Project: CIBC Bank USA ● Migrated and refactored legacy 15 SSIS packages to Azure Data Factory (ADF), modernizing the ETL pipeline and improving data availability. ● Tuned long-running T-SQL queries using execution plans and indexing strategies, successfully reducing query execution time by 30%+. ● Improved .NET web application performance by 25% by upgrading to Framework 4.8 and optimizing backend data retrieval logic. Project: TRUIST Bank ● Developed and maintained robust MSBI (SSIS/SSRS) solutions to support core banking operations. ● Collaborated with business analysts to translate functional banking requirements into technical SQL specifications. ● Performed root-cause analysis on production data issues, ensuring data integrity across financial systems. ● Created 20 complex stored procedures to support real-time regulatory reporting and analytics.
LTIMindtree
Jan 20212 yrs 3 mosMar 2023

Mumbai, Maharashtra, India

● Revamped over 20+ SSIS packages and rewrote inefficient stored procedures to improve data pipeline performance. ● Reduced report generation and ETL processing time by 50% through aggressive query refactoring and database performance tuning. ● Designed reusable SQL views and parameterized queries for executive dashboards and compliance monitoring. ● Documented and maintained legacy VB and ASP.NET codebases while coordinating the modernization of data access layers. ● Managed production deployments and provided L3 support for SQL jobs and critical data workflows.
Infosys
Sep 20164 yrs 4 mosDec 2020

Pune/Pimpri-Chinchwad Area

● Automated manual reporting processes using VBA macros, reducing the team's manual workload by 60%. ● Created, scheduled, and managed SSIS packages and SSRS reports to automate daily status reporting for QA and project leadership. ● Developed dynamic SQL views to support ad-hoc reporting requests, improving data accessibility for non-technical stakeholders. ● Optimized slow-performing queries by applying indexing and statistics updates, significantly reducing report load times. ● Refactored nested subqueries and joins to enhance overall database performance.

Education

International Institute of Information Technology Bangalore

Postgraduate Degree, Information Technology

International Institute of Information Technology Bangalore

20221 yr2023
Liverpool John Moores University

Master's degree, Computer Science (Full Stack Development)

Liverpool John Moores University

20231 yr2024

Join Hitesh and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Hitesh Sonone on Tal

Headline

Team Lead / IT Analyst | 9+ Years Experience | MS SQL Server | SSIS/SSRS | ASP.NET | C# | Azure Data Factory | Data Engineering Enthusiast

About

I’m an experienced Team Lead & IT Analyst with over 9 years of demonstrated success in building and optimizing enterprise-grade applications, ETL processes, and reporting systems. My core strengths lie in MS SQL Server, SSIS, SSRS, ASP.NET, and C#, with additional experience in Azure and cloud migrations. I’ve had the opportunity to work across top-tier companies including TCS, LTIMindtree, and Infosys, where I’ve contributed to banking, finance, and enterprise platforms. Known for my performance tuning, problem-solving mindset, and ability to bridge development with business needs, I enjoy turning complex data challenges into scalable, maintainable solutions.

Location

Mumbai

Work experience

Team Lead at Tata Consultancy Services, Apr 2023 - Present · 3 yrs 1 mo, Thane, Maharashtra, India, Project: WTW (Willis Towers Watson) Mumbai, India ● Role: Team Lead & IT Analyst (Italy & European Applications) ● Simultaneously manage leadership duties for Italy-region applications while driving technical delivery for the broader European application suite. ● Lead a dedicated squad for the Italy market, ensuring 100% SLA compliance and overseeing the modernization of legacy reporting systems. ● Execute hands-on development and maintenance for European insurance applications, working extensively with SSRS, SQL Stored Procedures, and .NET. Project: CIBC Bank USA ● Migrated and refactored legacy 15 SSIS packages to Azure Data Factory (ADF), modernizing the ETL pipeline and improving data availability. ● Tuned long-running T-SQL queries using execution plans and indexing strategies, successfully reducing query execution time by 30%+. ● Improved .NET web application performance by 25% by upgrading to Framework 4.8 and optimizing backend data retrieval logic. Project: TRUIST Bank ● Developed and maintained robust MSBI (SSIS/SSRS) solutions to support core banking operations. ● Collaborated with business analysts to translate functional banking requirements into technical SQL specifications. ● Performed root-cause analysis on production data issues, ensuring data integrity across financial systems. ● Created 20 complex stored procedures to support real-time regulatory reporting and analytics.

Senior Software Engineer at LTIMindtree, Jan 2021 - Mar 2023 · 2 yrs 3 mos, Mumbai, Maharashtra, India, ● Revamped over 20+ SSIS packages and rewrote inefficient stored procedures to improve data pipeline performance. ● Reduced report generation and ETL processing time by 50% through aggressive query refactoring and database performance tuning. ● Designed reusable SQL views and parameterized queries for executive dashboards and compliance monitoring. ● Documented and maintained legacy VB and ASP.NET codebases while coordinating the modernization of data access layers. ● Managed production deployments and provided L3 support for SQL jobs and critical data workflows.

System Engineer at Infosys, Sep 2016 - Dec 2020 · 4 yrs 4 mos, Pune/Pimpri-Chinchwad Area, ● Automated manual reporting processes using VBA macros, reducing the team's manual workload by 60%. ● Created, scheduled, and managed SSIS packages and SSRS reports to automate daily status reporting for QA and project leadership. ● Developed dynamic SQL views to support ad-hoc reporting requests, improving data accessibility for non-technical stakeholders. ● Optimized slow-performing queries by applying indexing and statistics updates, significantly reducing report load times. ● Refactored nested subqueries and joins to enhance overall database performance.

Education

Postgraduate Degree, Information Technology, International Institute of Information Technology Bangalore

Master's degree, Computer Science (Full Stack Development), Liverpool John Moores University

Hitesh Sonone - Team Lead in Mumbai | Tal