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