
Rohan Chopra
                                              M.No: +91-8168046323 
                                              Email: rohanchopra059@gmail.com
EXPERIENCE SUMMARY
7+ years into Microsoft Sql Development.
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 performing code review.
Create, develop and maintain SQL processes.
Able to do performance monitoring and perform sql code optimization.
Designed and developed On Demand reports by using SQL SSRS and deploy over report Server.
Experience with created packages and flow in Microsoft ADF to load data from excel to Sql Server.
Experience in SSIS tools like bulk copy program.
Interact with the business users to understand the issue, create the use cases to verify the issue in test environment. Collect the additional information regarding issues from the knowledge database and provide support to the clients.
SKILL SUMMARY
T-SQL
MS Sql Server Management Studio
MS Azure
Sql Server Data Tool(Visual Studio)
SQL Server Reporting Services
EXPERIENCE HIGHLIGHTS
Deputy Manager HCL Technologies Oct 2021- Present
 Independently participating in database development activities.
Work closely with the BI team to provide support for database objects (stored
procedures/functions/views) and performing code review.
&bull; Performed SQL query performance tuning by creating/modifying indexes.
&bull; Implemented copy activity using Azure Data Factory.
&bull; Automated Data ingestion from Excel to MS-Sql by using Logic Apps and Azure Data Factory.
   
Analyst Accenture India August 2019 &ndash; October 2021
 
Work closely with the front end development team to provide support for database objects (stored procedures/functions/views) and performing code review.
Experience in design and implement processes for Deploying and Extracting data by using
SQL Reporting Services (SSRS).
Interact with the business users to understand the issue, create the use cases to verify the issue in test environment.
Associate Analyst Conduent Business Services October 2017-July 2019
 
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

Support Office Broctagon IT Solutions March 2017- October 2017
 
Worked as L1 support engineer.
Prepared daily sql scripts and send reports to client.

Software Engineer Techmind August 2015- March 2017
Worked as Sql Trainee and provide L1 support to the clients.

EDUCATION
Master of Computer Applications from Maharishi Markandeshwar University in 2013.

