Developer Sql Server

NIKHIL SRIVASTAVA

Email-:******.*******@*****.*** contact-:965-***-**** SYNOPSIS

5.5 years of relevant experiences in Microsoft sql server database administrator cum sql server database developer in top Companies. Currently I am working as DATA WAREHOUSE SPECIALIST in MILLIMAN INDIA PVT LTD (large international, independent actuarial and consulting firm) which is based in Gurgaon (Haryana-India).

Current Employer(Nov 27 2018 to till now)

Milliman India PVT LTD

Working as a Data Warehouse Specialist in one of the large international, independent actuarial and consulting firm.

Job Profile:

In this company besides sql server (dba, developer, bi) skills, I have started to gain the domain knowledge for the health care domain (United States). Right now I am working in a team size of 25 people in our department (SAAS-India), dealing with n number of US based clients.

Previous Employer (Oct 28 2015 to Nov 24 2017)

ANNIK TECHNOLOGY SERVICES PVT. LTD.(Liquid Hub)

Working as a sql Server Database administrator cum sql developer(Designation-: Tech Lead 1)

Job Profile:

In this company my first project was start(Saratoga Taking Actions and Reporting Tool). This project belonged to a U.S client (PricewaterhouseCoopers PVT. LTD.). In this project I worked as a sql server database administrator and sql server developer. The project is all about a reporting tool. The reporting tool creates and shows reports about the users(Customers) feedback for example(different questions were asked in the feedback from the users about their company like -:what is their intent to stay in a company is? How satisfied are they in their company? Are they satisfied with their managers? what improvements they want in their company? And yes there are so many questions like that).The users feedback data coming in excel sheets and then from the front end (.net), this data is loaded into the database in various tables and views. And then with the help of sql stored procedures, sql built in and user defined functions, sql views, sql triggers ETC, the reports are generated.

Currently I am Busy with another project and this project belongs to the Microsoft (Annuity weekly refresh project). And in this project I am doing various dba tasks.

As a sql server database administrator I am doing the following tasks-:

SQL Dba Jobs-:

1-:Managing databases(Regular)

2-:Managing sql server Instances. (Regular)

3-:Daily checkup activity (database and sql server instances)(Regular)

4-:Backup, recovery,restore (Regular)

5-:Performance tuning(latest ongoing project for one of the U.S. client)

6-:Database design(as and when needed)

7-:Managing security(managing users, creating logins, mapping logins, creating database users ETC)

8-:Importing and exporting the data to and from sql server by using various features like

bulk insert, ssis, import export wizard etc.

9-:Working with sql server agent services(creating and managing jobs, tracking job history ETC)

10-:Trouble shooting issues raised by the developers through raised tickets.

As a sql server developer I am doing the following tasks-:

Sql Developer Jobs-:

1-:Database design

2-: Writing complex T-sql Queries

3-:Creating complex Stored Procedures and further optimizing it also

4-: Creating complex functions(scalar functions and table valued functions)

5-:Creating Triggers (after insert, after delete and instead of trigger)

6-:Creating Views

7-:Implementing joins

8-:Writing Subqueries

9-:Writing Correlated subqueries

10-:Merge statement

ETC

Previous Employer (May 18 2015 to till Oct 2015)

Aequor Information Technology Solutions Ltd

Working as sql server database administrator cum sql developer

Job Profile:

In this company I handledprojects for the clients of United States and China. My project that was pathgroup project and this project belonged to U.S. Client. In this project I worked asMS sql server dba. I didprojects like srds and travel china. Srds project belonged to another U.S. Client. In srds project worked as a sql server developer and sql dba.Travel china project belonged to a client of China. In this Project I worked as a sql developer and sql database administrator.

Previous Employer: (September 9 2014 to April 23 2015)

STPL

Job Profile:

Worked as Sql Dba cum Sql developer

Previous Employer

Aptech Tech Ltd. (April 13 2012 to November 19 2012)

1-:Worked as Sql Dba cum Sql developer

Previous Employer

NIIT Ltd. (June 01 2010 to November 30 2011)

1-:Worked as Sql Dba cum Sql developer

Previous Employer

NIIT Ltd. (September 11 2007 to May 31 2010)

1-:Corporate Trainer

Ongoing Projects-:

1-:Start(PWC)-: As a database developer and database administrator I have created various reports like summary report and this summary report has got some sub reports like -:

A-:Summary Report-:

1-: Top-Bottom report (top three question which has got highest punches from the users and bottom three questions which has got lowest punches from the users)

2-:Intent To stay report (different questions were there in this report).

3-: Behavior Change Index (this reports actually shows that follow-up’s for those users who are least satisfied in the previous year feedback.)

4-: Response Rate (total users present and in these how many users actively given the response)

5-:Core Dimension Summary report (this report shows the data according to the user punches (satisfied, neutral, not satisfied)).

B-: Detailed Report-:

This report is the detailed report about the user feedback data.

2-: Annuity Weekly Refresh Project (Currently engaged)

Achievements-: I have got the Team Excellence and Star Performerawards with the start team.

Previous Projects-:

1-World Wide DMS -: This Project was all about hotel Reservation, attraction reservation and transfer reservation. In this project I worked as a lead database developer and handled agent module and agent payment module.

2-: Travel china -: Giving database development support to database Team.

IPL Cricket Fantasy Game Project -:

Basically this project is dependent on the IPL 2015 Cricket League.This is a betting game project which operates in two

Modes -:

1-:Match

A-Actual

B-Virtual

2-:Tournament

A-Actual

B-Virtual

The user needs to create his own team by selecting the ipl cricket 2015 players or the user can bet on one of the teams in 8 team playing the tournament.User will earn the points based on ipl players real performance .user will also get 100 crore when he starts the game and then he can purchase the players and also bet on any teams.

Newco Project(Duration 6 months)

This was the US project in this Project I and one more sql developer worked on it.In this project there is a company called Bolt under this company many banks are coming so these banks can be understood as the clients of the bolt. Actually What bolt is doing is, it provides various services related to ATM machines installed at different locations by the bolt clients(different banks).so bolt do have many ATM mechanics and with the help of these mechanics bolt manages to provide services to its clients. So first Bolt mechanics are assigned to different clients (banks) and then these mechanics visits the locations where the client ATM are installed and then they(mechanics) take the photographs of the present situation(before installing any equipment or services like ac, electricity) and then after installing these equipment and services at the ATM locations they again take the photographs. And finally upload these photographsto the website and then the client if satisfied by the services provided says ok.

As a developer my role was to understand the project and then with one more developer I created the Entity-Relationship Diagram for this Newco project and then converted it into the physical data model. And then written stored procedures to perform insert,update,delete and select operations. Actually whatever the stored procedures I have written accordingly to the screen shots provided by the front end application developers.

Medical Tool Project(Duration 8 months)

This was the Us Project and as a sql developer I have worked on it. In this project there were three parts

1.Clinical Data-:In this part we do have records of different patients who are suffering from various diseases

So in this data various patient’s tests are given(like bmival,bp_systolic,bp_diastolic ETC).

2. Pharmacy Data-:In this part of data we do have records of different patients related to medicine purchases from different pharmacy Example-(written date of medicine, transaction date of medicine, No of Doses, Patient Id, Drug name ETC)

3.Output data-:First we process the Clinical data so that we can catch those patient records whose for example-:

Bp_Systolic is negative and then we process the Pharmacy Data to catch those patient records who are properly following the doctor’s Prescription or those patient records who are not following the doctor’s prescription properly and then we intersect or union the clinical data and pharmacy data to get the final output of the patient records.So in the following outputdata we can reach a decision that if a patient is suffering from any

Disease then this patient is properly following the medicine routine or not.

As a developer my role was to understand the project and thenI created the Entity-Relationship Diagram for this Medical Tool project and then converted it into the physical data model.After creating the database structure

The records were inserted in the different tables and then I have written stored procedures and various scalar and table valued functions (like calculate adherence,first prescription picked up or not,last prescription picked up or not, Consecutive days missed ETC).Also in this project I have created the drug Diary stored procedure which tells that a patient has taken a medicine on which date ETC)

CSV data upload to the sql server database

Actually in one of the project client asked us that he do have the data in the excel sheet and he wanted to upload the data to the sql server database.So according to his requirements first we have converted the excel sheet to the csv file format and then filtered out the dirty data and then we have loaded the data to the sql server tables with the help of Sql server Integration services.In other project same as above requirement we used bulk insert to upload the data from the csv file to the sql server tables.

PROFESSIONAL QUALIFICATIONS / CERTIFICATIONS

QUALIFICATION

PGDCA (A-LEVEL) DOEACC Lucknow(Indraprastha University Delhi) (Year 2007)

BCom Lucknow University.

XIIth: U.P Board.

Xth: U.P Board.

TECHNICAL SKILLS

Technologies: SQL Server 2005/2008 R2/2012,Development,Administration

Microsoft Office 2007, 2010.

PERSONAL DETAILS

Name : Nikhil Srivastava

Father’s name : Mr. Raj Kumar Srivastava

Gender : Male

Address : 30, Savitri Sadan, Subhash Nagar, Lucknow-226022

Date of Birth : 06 June 1982

Marital Status : Married

Nationality : Indian

Strengths : Good Analytical Skills, Sincere & Hardworking and Good Team Player.

Contact this candidate