Mithun Thakkar

Investment Data Specialist

Utmost International•  November 2021 - February 2023

o Wrote T-SQL scripts for querying the database, setting up stored Procedures, views, tables, and SQL Agent jobs to allow seamless access of data for reporting in MS Excel format to the Central Bank of Ireland o Possessed a strong track record of introducing and implementing advanced constructs from SQL Server like triggers, advanced exception handling, lateral joins and cursors in the team o Worked on DBA specific scripting like tracking server activity, performing migration to new servers, backing up and restoring databases, comparing databases, setting user permissions, setting up sql audits and performaing index defragmentation.Additionally, wrote python scripts to make the file server migration seamless o Used XML for setting up custom functionalities in MS Excel ribbon o Requirements gathering, elicitation and analysis whilst using agile methodologies o Wrote python scripts for querying the database, manipulating and web scrapping data o Scripted in VBA for interacting with data from sql server and presenting data in MS Excel format