Rohan Chopra

8 years' experience into Microsoft SQL Development along with an exposure of MS SQL Azure. Microsoft SQL Developer(T-SQL) and establish strong relationships with end users and technical resources throughout established projects. Work closely with the development team to provide support for database objects (stored procedures/functions/views) and perform code review.

Create, develop, and maintain SQL processes. Able to perform performance monitoring and perform SQL code optimization. Designed and developed On Demand reports by using SQL SSRS and deploy over report Server.

Experience creating packages and flow in Microsoft ADF to load data from excel to SQL Server.

Experience with SSIS tools like bulk copy programs. Collaborated directly with business stakeholders and functional teams to gather and analyze business requirements. Interact with the business users to understand the issue, create the use cases to verify the issue in test environment. Collect additional information regarding issues from the knowledge database and provide support to the clients.

Senior SQL Developer-IC Role - Genpact India - Noida

(2024-10)

Client: Ryan specialty

• Onboard and configure the Insurance Management system disconnected application to be integrated with Saviynt Connected.
• Responsible for automating the process of granting application access from ServiceNow to end insurance applications by using SQL Server Agent Jobs.
• Developed SQL-based solutions from scratch, translating business requirements into efficient and scalable database logic using stored procedures, functions, views, and complex queries.

Senior SQL Developer - HCL Technologies - Noida

(2021-10 - 2024-10)

Client: Pearson

• Analyzed query performance and optimized slow-running queries using indexing, CTE's, and Temp tables.
• SQL Development from scratch- Developed complex SQL queries, stored procedures, functions, views, and triggers to implement core business logics.
• Performed SQL query performance tuning by creating/modifying indexes.
• Implemented copy activity using Azure Data Factory.
• Automated Data ingestion from Excel to MS-SQL by using Logic Apps and Azure Data Factory.

SQL Developer - Accenture India - Gurgaon

(2019-08 - 2021-10)

Internal Project – security Insights

• Designed and developed relational database models based on business rules and data flow requirements by using Primary Key and Foreign Key.
• Generated ad-hoc and scheduled reports for business users using T-SQL and SSRS when needed.
• Interact with the business users to understand the issue, create the use cases to verify the issue in test environment.
• Designed and implemented ETL (Extract, Transform, Load) workflows to move and transform data from various sources into SQL Server.

Associate Analyst - Conduent Business Services - Noida

(2017-10 - 2019-07)

• Supporting the technical planning and work coordination with the team members.
• Coding, testing, debugging, and documenting programs on large-scale, complex projects.
• Translating functional requirements to technical design and development tasks.
• Optimizing the user interface.
• Developing and maintaining user interface.

L1 Support Engineer - Broctagon IT Solutions - Noida

(2017-03 - 2017-10)

• Prepared daily SQL scripts and send reports to client.

SQL Trainee - Techmind - Chandigarh

(2015-08 - 2017-03)

• Provide L1 support to the clients.

Master of Computer Applications - Maharishi Markandeshwar University (2013)