﻿                           
Jasveer Singh
                                                                                                    38 Park Road 
    Patel Nagar, Dehradun
                                                                                                    Cell :+91 7906370607            
      Email:singh.jasveer1374@gmail.com
02794000
Career Objective
Seeking a career as a SQL developer in a professional company and to effectively utilize the knowledge gained in my academic curriculum,experience  &amp;amp; from life for attaining a responsible, challenging and rewarding position.

Course Details
Degree: BCA Specialization: Computer science
Education
Qualification Institute University/Board Passing Year
BCA DIT University
 University
   2021
XII S.G.R.R. Public School CBSE Board    2018
X S.G.R.R. Public School CBSE Board    2016
Software Skills
Skills                       
SQL development 
SSIS Packages development
ETL
SSRS Report Development
Query Optimization
Indexing
Tools Used      
SQL Server and SSMS
Microsoft SQL Server (SSIS, SSRS)
Visual Studio and SSDT
MySQL
SQL Profiler
Power BI
DataBricks
SVN
S  Professional Experience
 Self Confidence, Positive Attitude    
April. 2021- Till Date- Working at Scalability Engineers As Software Developer
S   Strengths
 Self Confidence, Positive Attitude    
Positive Attitude, 
Good Communication Skill, 
Team Work Skill
Effective Time Management   
Project Details
Project1 &ndash;  Teknik Engineers ( Nov&rsquo;2022 &ndash; Till Date )
Creation of a new database.
All SQL Development i.e. Creating tables, Writing Stored Procedures to handle all the business requirements.
Development of SSIS Packages to pull data from different sources like SQL Server, MySQL, FoxPro and Tally on daily basis and sync all the data in our main database.
Automating the process so that its scalable and able to accomodate more data sources in the future.
Creation of SSRS reports from the scratch.
Development of PowerBI Dashboards.
Optimization of SPs and reports using indexes, re-writing the code and other optimization techniques.
Project2 &ndash;  Internal Support in Aditya Birla Capital ( Oct&rsquo;2023 &ndash; Till Date )
Optimization of slow running SPs and adhoc queries.
Debugging and development of SSIS packages.
Data Analysis for any discrepancies in the data.
SSRS Reports development.
Worked on Database Migration from SQL Server to DataBricks. Creation of notebooks and dataflows and replicating the logic of SPs from existing system into databricks.
Project3 &ndash;  Optimization of Stored Procedure and adhoc queries in Corecard (Aug&rsquo;2022 &ndash; Till Date)
Identifying the Problem areas and finding the slow running Queries.
Using profiler to find the problem queries and understanding the traces.
Re-writing the Code so as to Improve the Performance.
Further improving the Stored Procedure Performance by using the Indexes and Parallel query execution.
Project4 &ndash;  Code Review of the Stored Procedure and Scripts in Corecard (June&rsquo;2021 &ndash; Aug&rsquo;2022)
Reviewing all the Stored Procedure and Scripts according to the set guidelines to maintain the standard coding practice for every release.
Suggesting the Changes to avoid the problem creating areas.
Testing and Identifying slow running Queries.
Project5 &ndash;  Internal Support to Scalability Engineers Clients (May&rsquo;2021 &ndash; Dec&rsquo;2021)
Understand the complex procs and functions development done in different projects and provide internal support 
Understand the basics of performance tuning like indexing and provide level 1 analysis
Provide help in maintaining the versioning of database objects using SVN.
                        
Hobbies
Reading Novels
Watching movies/TV
Listening to Music
Personal Details
Father&rsquo;s Name            :   Mr Bhupender Singh
Mother&rsquo;s Name           :   Mrs. Narender Kaur
Nationality                 :   Indian
Gender                       :   Male                                                                 
Marital Status             :   Unmarried
Declaration
I here by declare that all the particulars given above are true to the best of my knowledge and belief.
Place&nbsp;: Dehradun                                                                                  Signature
Date&nbsp;:                                                                                            Jasveer Singh



