Nitin Kshirsagar
Summary
Senior-level Software and Application Developer passionate about creating cutting-edge products for the field. Strong work ethic and dedicated to quality assurance. Adept at working with teams or independently in fast-paced settings.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Sr.Tech Lead
Trangile Services Pvt. Ltd.
04.2024 - Current
- Implemented complex queries to retrieve data from SQL Server database by joining multiple tables with different conditions.
- Created SSIS packages to extract, transform and load data between heterogeneous sources like Oracle, MS Access and flat files into the SQL Server database.
- Provided technical assistance to junior DBA's in day-to-day tasks including writing T-SQL scripts for various purposes.
- Involved in trouble shooting replication issues related to synchronization conflicts or latency issues between publisher and subscriber servers.
- Migrated legacy system databases from older versions of SQL server to newer version while ensuring data integrity is maintained during migration process.
- Assisted in designing new database structures based on requirements provided by stakeholders.
- Developed stored procedures, triggers and functions using T-SQL for data manipulation, retrieval and updating of databases.
- Developed automated reports using Reporting Services which can be used by business owners for making informed decisions.
- Optimized existing queries for better performance utilizing query tuning techniques such as indexing, statistics update.
- Monitored long running jobs and troubleshoot any issues related to job failures or other performance related problems.
- Conducted database tuning and performance monitoring to ensure optimal system functionality.
Sr. Software Engineer
Viniculum Solutions Pvt. Ltd.
10.2010 - 03.2020
- Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.
- Designed complex reports using SQL Server Reporting Services.
- Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
- Integrated multiple data sources into one unified view using views or joins in SQL queries.
- Performed backup and recovery of databases on a regular basis.
- Developed stored procedures, functions and triggers to support application requirements.
- Used T-SQL scripting language for creating stored procedures, functions, triggers.
Education
Master Of Computer Management - Computer Engineering
Vidyabharti Institute
Amaravati04-2005
Bachelors Of Commerece - Commerce
Art And Commerce College
Yavatmal04-2003
Skills
- Data modeling and analysis
- Performance Optimization
- Continuous integration
- Database Management Software
- Efficient data management
- Source and Version Control: Git, Github
- Programming Languages: C#, Net, Python
- Databases: SQL Server,MySQL
- Teamwork and Collaboration
- Technical problem solving
Languages
Hindi
First Language
English
Intermediate (B1)
B1
Accomplishments
- Get 3 times Quarter of the Year Employee Award
Certification
- Mastering Data Modeling Fundamental
- Dot Net Certification course of CCIT
Timeline
Sr.Tech Lead
Trangile Services Pvt. Ltd.
04.2024 - Current
Sr. Software Engineer
Viniculum Solutions Pvt. Ltd.
10.2010 - 03.2020
Master Of Computer Management - Computer Engineering
Vidyabharti Institute
Bachelors Of Commerece - Commerce
Art And Commerce College
Similar Profiles
Minku MittalMinku Mittal
Team Lead at Trangile Services Pvt. Ltd.Team Lead at Trangile Services Pvt. Ltd.
Vaibhav BhatnagarVaibhav Bhatnagar
Software Engineer at Trangile Services Pvt. LtdSoftware Engineer at Trangile Services Pvt. Ltd
Ayush GuptaAyush Gupta
Software Engineer at Trangile Services Pvt LtdSoftware Engineer at Trangile Services Pvt Ltd