sql,t-sql

D E E P A K . S

Mobile: +917*********

Email: ac8zpm@r.postjobfree.com

Career Objective:

To obtain SQL/T-SQL Developer position that would help me to utilize and update my skills on Database and Data Warehouse techniques.

Interested Areas:

Able to understand database design and write respective query for the business

Have good understanding in Database concepts

Have very good knowledge on System Functions (Date, Aggregate, String, Conversion and Windows)

Have very good understanding on different types of Joins (Inner, Outer, Self and Cross) also have idea of Merge and Cross Apply in MS-SQL

Have used different constraints in my project Primary Key, Foreign Key, Unique and Not Null constraint to keep the data consistency

Able to write complex query using T-SQL and have an idea of Database designing based on requirements

Created Stored Procedures, Functions and Views to achieve my project requirements

Have good understanding on the Indexing concepts in SQL Server

Have better understanding in Common Table Expression, Temporary Tables and Table variables

Have knowledge on Trigger and Cursors

Have learned how to design POWER BI reports

Have an idea of Data Warehousing concepts

Interested to learn and work in Business Intelligence tools SSIS, SSAS, SSRS Technical Skills:

Database : Microsoft SQL Server 2014

Programming Language : SQL, T-SQL

Databases Designer Tool : Data Modeler1.6

Operating Systems : Windows Server7/8/10

Microsoft Office Package : MS-Office (Word/Excel/PowerPoint) Project Experience:

Academy Project

Project Title : Potential Disease Prediction Using Deep Neural Network Role : Data Base Design and Development

Duration : Jan 2018-April 2018

Description:

Objective of the project is to predict whether the given patient might have heart or kidney disease by applying machine learning algorithms namely deep neural networks and algorithms random forest, with his medical history as the feed. With the available open dataset, our model predicted results with 83% accuracy for heart disease and 79% for kidney disease.

Responsibilities:

• I have designed the complete Database by understanding the Data Model

• Used SSIS package to load the data from Excel files to respective tables

• Created Functions and Producers to predict user disease based on their inputs

• Involved in Python coding to design front-end page

• Created SSRS reports to display the output information to the user

• Involved in meeting and discussion with Doctor’s at London via Skype calls to get the data about disease and its symptoms in stages and safety measures

Technologies:

Database: SQL SERVER 2014

Database Designer: DATA MODELER 1.6

Front End: PYTHON

Academic Qualifications:

DEGREE INSTITUTION UNIVERSITY YEAR AGGREGATE

B.E (CSE) Velammal Engineering College Anna University 2018 61.2% H.S.C Elite Matriculation Hr. sec school,

Chennai

Matriculation 2014 81.2%

S.S.L.C Alpha Matriculation Hr. sec school,

Chennai

Matriculation 2012 64.4%

Challenges and Achievements:

• Have organized project symposium

• Attended a workshop on “Booming and Boon of IoT” conducted at SSN, Chennai

• Have participated project symposium at Bannari Amman Engineering College

• Academic event Coordinator, 2017 at Velammal Engineering College, Chennai

• Visited Pentamedia Graphics Limited and understood the concepts of Computer Graphics

• Visited Kashiv Infotech and understood the concepts of big data Personal Information:

Father's Name : A. Selvam

DOB : 21-June-1997

Sex : Male

Nationality : Indian

Marital Status : Not Married

Languages : English and Tamil

Date: Signature

Place: Chennai [S. DEEPAK]

Contact this candidate