Summary
Overview
Work History
Education
Personal Information
Projects
Training
Timeline
Generic
Abhinandan Dongare

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, India
01.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

CREATE PROFILE
Abhinandan Dongare