chiragchhabra

• I played a pivotal role in the Base/Core team of the Smart Customer Mobile product, overseeing key functions such as managing major and submodules, performing data mapping, optimizing code, indexing, and creating numerous procedures. • Led performance tuning and optimization of database queries, achieving a 15% improvement in system response time. • Documented technical specifications, ETL workflows, and database configurations for knowledge transfer and future enhancements, leading to a 40% reduction in onboarding time. (Took almost 5 Database KT sessions for new joiners having an average strength of 10 members). • I was accountable for segregating, preparing, and distributing database patches across over 30 implementations. Additionally, I provided support for PF tickets.

• During my internship, I analysed existing SQL queries to identify opportunities for improvement. • Developing Custom Database Objects, stored procedure and delivered application support. • Ensuring the data quality and integrity in databases.

• Managed and maintained SQL Server databases, overseeing schema design, indexing, and query optimization to enhance overall performance. • In addition to day-to-day database tasks, I also designed dashboards using Microsoft Power BI to visualize essential data for stakeholders. • Designed and implemented complex SQL queries for data retrieval, transformation, and analysis, catering to the diverse needs of business stakeholders.