Abhinandan Dongare
Pune
Summary
- 12 years of experience in IT in Database design/ development & Support
- Deep understanding in MS SQL Server system and ability to design scalable solution.
- Experience in implementing end to end business logic using stored procedures, Functions, Tables, and views.
- Expert in performance tuning using Execution Plan, Statistics, Indexing, Query Store, SQL Profiler/ SQL Trace.
- Good knowledge in data modeling Extended Event, JSON, SQL Jobs, Autosys, JIRA, TFS, GIT, TeamCity, Unix script.
- Experience working on large size database OLTP & OLAP.
- Good knowledge of the Finance domain.
- Good at .Net, C#, SSRS,
- Experience in Agile & Scrum methodology.
- Successfully passed DP-900 Microsoft Azure Data Fundamentals
- Learning Data Engineering on Microsoft Azure
Overview
13
13
years of professional experience
Work History
Senior Tech Lead
TIETOEVRY FINTECH INDIA PRIVATE LIMITED
12.2022 - Current
- Part of Database Group
- This group is responsible for all database-related work for multiple projects.
- Design the database, or modify the existing database according to requirements.
- Working on performance tuning.
- Create a design for the import/export of data with other teams.
- Writing complex queries, procedures, triggers, functions, etc.
- Collaborated with other departments such as QA, BA, UI Designers.
- Provided technical support to junior when needed
- Reviewed code changes and monitored application performance.
- Identified opportunities for improvement in the development process.
- Participated in sprint planning meetings and daily standups.
- Created script for automation testing.
Officer
Citicorp Services India Private Limited
11.2019 - 12.2022
- (Nov 2019 to April 2021 ) On payroll of Collabera Technologies Pvt. Ltd.
- CITI has the product in the Equity Swap business
- Upgrade the database from 2008 to 2016.
- Design database / modifying existing database according to requirement
- Doing performance tuning
- Updating procedure, function, view as per business need
- Handling more than 1TB of the database, with more than 2000 procedures, 200 tables
- Creating jobs in AutoSys using JIL
- Build and deploy using TeamCity and Udeploy
- Version controlling tools like TFS, Github, and Bitbucket.
- Bug fixing in .Net, C# code
- Creating/modifying import export jobs
- Working on the server upgrade project
- Set up automation database backup process.
Lead Technology
Synechron Technology India
07.2019 - 11.2019
- Migration project from DB2 to Oracle Database.
- We are moving from DB2 to Oracle Database.
- Understanding of DB2 stored procedure and convert to Oracle database.
- Make sure all procedures execute in database without error.
Senior Software Engineer
Tieto India Private Ltd
11.2014 - 06.2019
- Gathering requirements from business stakeholders
- Creating and or updating tables, stored procedures, views per business logic
- Creating SQL scripts for tuning and scheduling
- Bug fixing and Unit testing
- Follow scrum rule
- Actively participated in all scrum ceremonies
- Working on import-export, where integrate with third party tool, The import /export file can be text, XML, excel
- Working in client office (Luxembourg and Sweden)
- Monitoring SQL Jobs
- Solving production critical issues
Team Member
SS&C GlobeOp Financial Services (India) Pvt Ltd
04.2012 - 11.2014
- Gather information about the applications
- Coding, Unit Testing, debugging of the assigned work
- Creation of new store Procedures, Functions, and Triggers
- Monitoring, tuning, and managing Database
- Developed source to target specifications for Data Transformation Services
- Creation of new store Procedures, Functions, and Triggers
- Changing existing Store Procedures, Functions, and Triggers
- Monitoring, tuning, and managing Database
- Use ETL tools like SSIS
Education
DAC-Diploma in Advance Computing -
Vidyanidhi InfoTech Academy
Mumbai, India01.2012
BE - Computer
05.2011
Personal Information
- Date of Birth: 09/26/89
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Projects
All in one USB OS installer. User can install all software at OS inatallation time it self.
Training
DAC-Diploma in Advance Computing,
Timeline
Senior Tech Lead
TIETOEVRY FINTECH INDIA PRIVATE LIMITED
12.2022 - Current
Officer
Citicorp Services India Private Limited
11.2019 - 12.2022
Lead Technology
Synechron Technology India
07.2019 - 11.2019
Senior Software Engineer
Tieto India Private Ltd
11.2014 - 06.2019
Team Member
SS&C GlobeOp Financial Services (India) Pvt Ltd
04.2012 - 11.2014
DAC-Diploma in Advance Computing -
Vidyanidhi InfoTech Academy
BE - Computer
Similar Profiles
Jitender KumarJitender Kumar
Consultant at Tietoevry Fintech India Pvt LimitedConsultant at Tietoevry Fintech India Pvt Limited
Abhinav RajAbhinav Raj
Software Developer at TietoEvry Fintech India Pvt. Ltd.Software Developer at TietoEvry Fintech India Pvt. Ltd.
Vicky Selvaraj SwamiVicky Selvaraj Swami
SIAM Service Manager at TIETOEVRY TECH SERVICE INDIA PRIVATE LIMITEDSIAM Service Manager at TIETOEVRY TECH SERVICE INDIA PRIVATE LIMITED
Shray YadavShray Yadav
Senior Associate at EXL Services (India) Private LimitedSenior Associate at EXL Services (India) Private Limited
Nikit KhopadeNikit Khopade
Key Account & Marketing Manager at Kuvos Tech (A DYNAMIK LABS GROUP OF COMPANY)Key Account & Marketing Manager at Kuvos Tech (A DYNAMIK LABS GROUP OF COMPANY)