Arun Gupta Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

● Eliminated dependencies from the codebase to remove unused tables and views, streamlining and optimizing the system.● Initiated the optimization and restructuring of Indexes to enhance performance by eliminating redundant indexes, deduping overlapping ones, and removing unused indexes, resulting in the reclamation of ~30GB of space in the production environment.● Detected inefficient queries through Datadog/Query Store and subsequently fine-tuned them for improved performance.

Noida, Uttar Pradesh, India

● An active member of the core SQL team to implement the Database Unit Test Case(tSQLt) process● Removed ~60% blocking from DB Server byo Optimizing most blocked querieso Removing unused indexes and Merging overlapping indexes o Removed legacy truncate/Insert by applying batching

India

● Individual Contributor.● Working with 8+ teams in India, the United States, and Australia and providing Data solutions.● Coordination with the stakeholders for requirement gathering and planning.● Monitoring the Database server performance.● Conducting global training sessions for new hires on standardized SQL database processes and tools.

Noida Area, India

● Overseeing all facets of application development, including analysis, design, development, testing, implementation, and documentation.● Providing demonstrations of new functionalities and features to the testing team and Product Owners.● Actively participating in grooming and test review meetings to analyze the scope of new features andfinalize the development and testing roadmap.● Responsible for creating and maintaining Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, UserProfiles, User Defined Functions, and Relational Database Models, ensuring Data Integrity by adhering toBusiness Rules.● Consistently achieving high code quality, with a daily practice of writing intricate Unit Test cases onT-SQL.● Managed and generated new reports utilizing SQL Server Reporting Services (SSRS).

Mumbai Area, India

● Database Modeling.● Led a domain team overseeing the entire data flow process, managing the journey from unstructured datacollection to the production of structured data.● ETL automation by developing batch scripts.● Implemented data quality checks, resulting in a 70% improvement in data accuracy.● Designing & formulating Procedures, triggers, and validation checks to implement calculation logic withinthe objects to fetch data from the staging environment to the production environment.

Mumbai Area, India

● Designed, maintained, and coded database objects, including stored procedures, functions, views, triggers,and cursors to efficiently process substantial volumes of data.● Performed system integration with front-end developers & QAs.

Bachelor Of Engineering - Be, Computer Science

High School, Science