Diligent and results-oriented professional with over 7 years of experience in MS SQL development, SSIS development, EDW data warehousing, production support, and team management.
Strong command of SQL, T-SQL, including SQL joins, subqueries, dynamic SQL, views, functions, stored procedures, and performance tuning.
Proficient in working with JSON for data exchange and storage; experienced in parsing, manipulating, and formatting JSON data using SQL Server (OPENJSON, JSON_VALUE, etc.).
Skilled in ETL development using SQL Server Integration Services (SSIS), building robust data integration, and workflow automation solutions for different data sources.
Experienced in automating SQL jobs, configuring email notifications, alerts, and scheduling SSIS packages via SQL Server Agent.
Demonstrated leadership as a Technical Lead, with a deep understanding of the software development life cycle (SDLC), project management, and team coordination.
Recognized for delivering creative solutions to complex client requirements, and ensuring on-time, high-quality deliverables.
Effective team player and leader with a reputation for strong problem-solving skills, positive team dynamics, and a customer-first approach.
Overview
8
8
years of professional experience
Work History
Technical Lead
Simplify Healthcare
Pune
09.2020 - 12.2024
Project Overview and responsibilities: Benefits1 is the product/application of Simplify Healthcare and is being used by U.S. healthcare insurance companies to manage their healthcare benefits, plans, reports, and more.
Analyzed user needs and software requirements to determine design feasibility.
Understand business requirements from the BA team and provide a solution approach, building standard dynamic solutions such as SQL stored procedures, functions, and SSIS packages.
Optimized existing time taking code, solution, like SQL procedures and SSIS packages.
Worked with client team to resolve the defects within SLAs, prioritizing them based on severity.
Lead and manage the team to ensure high performance and successful project outcomes.
Environments: SQL Server 2019, Oracle, SQL Server Data Tools 2017 (for SSIS)
Manager-IT
Bajaj Finserv
08.2019 - 02.2020
Project Overview and responsibilities: BRS is an application developed for the daily disbursement and collection payment reconciliation between banks and Bajaj Ledger accounts
Collaborated with the PMO team to understand new business requirements and developed solutions in coordination with the vendor team, provided application support to resolve the defects.
Developed SQL procedures and SSIS packages for different requirements, synchronize data across processes in the EDW (Enterprise Data Warehouse).
Managed and led the team, ensuring efficient workflow and project execution
Environments: SQL Server 2016, Oracle, EDW, SQL Server Data Tools 2017 (for SSIS)
Software Engineer
Bajaj Finserv(Payroll of Mphatek System)
04.2017 - 08.2019
Project Overview and responsibilities: Managed Bajaj customer accounts, EMI card, banking, and billing data processing, integration for collection operations, ensuring seamless movement of data into the EDW(Enterprise Data Warehouse).
Implemented and modified SQL Schema, SQL procedures and SSIS packages to accommodate new requirements or business rules in existing processes for data warehousing.
Performed optimization, unit testing and data validation to ensure accuracy and consistency.
Managed modifications, deployments, email alerts and daily monitoring of SQL jobs, procedures, and SSIS packages to ensure smooth operations.
Environments: SQL Server 2016, EDW, Oracle, SQL Server Data Tools 2015 (for SSIS), SFTP (Win SCP, Putty)
Education
Bachelor of Computer Science (BCS) -
MIIT College Beed
Dr. Babasaheb Ambedkar Marathwada University.
05-2016
Skills
MS SQL Server 2008 and higher versions
Oracle
SQL
T-SQL
JSON and semi-structured data
SQL Server Integration Services (SSIS)
ETL and Data Integration
Informatica
Performance tuning
Languages
English
Hindi
Marathi
Personal Information
Date of Birth: 09/13/95
Disclaimer
I hereby declare that the information mentioned above is true to the best of my knowledge