Piyush Bajaj
BAN USERI am very much passionate about SQL Server. I want to persue my career in database field.
PIYUSH BAJAJ
Email : piyush.bajaj.2007@gmail.com
Mobile : +91-8884554161
Date of Birth : 05 November, 1989
Address:
Marwari Line, Khaparganj,
Bilaspur[C.G.] - 495001
Objective
Result oriented engineer seeking for an opportunity to utilize my knowledge, skills and abilities innovatively for the benefit of the industry and grow higher in the hierarchy.
Computer Skills
• Database Management System
o Microsoft SQL Server 2008 R2
o Microsoft SQL Server 2005 (Microsoft Certified Technology Specialist on SQL Server 2005)
o MySQL 5.1
o Oracle 9i
• Console Programming
o C#.NET, Visual C++, VB.NET (.NET Framework 4.0) (Windows Applications)
o C/C++
• Software Applications Familiarity
o Microsoft Visual Studio 2010
o Red Hat Linux 5.1
Academic Qualifications
2007-11 Shri Shankaracharya College of Engineering and Technology, Bhilai(Chattisgarh)
BE ,Computer Science Engineering, CPI 7.75
2006-07 Kendriya Vidyalaya School, Bilaspur(Chattisgarh)
Higher Secondary, 68%(aggregate)
2004-05 St. Xavier’s School, Bilaspur(Chattisgarh)
Senior Secondary, 70%(aggregate)
Work Experience
• TCS, Bangalore: Currently working here in a development team of “Bank of America” client project. The project name is Lean. The technology that I am working is Asp.net, and handling SQL Server work of my team. I have joined TCS on 26th December, 2011. (9 months).
• Worked on eDominer Systems Private Limited, Kolkata: SQL Server DBA. I have worked mostly on SQL Server 2008 and 2008 R2. I have been involved in assigning Security Permissions, Managing Data, Back Up and Restoration, Replication. I have worked from 1st June 2011 to 10th November. (6 months).
Guide: Mr. Amit Bansal, SQL Server MVP, Founder & President at SQLServerGeeks.com
Personal Achievements
• One among the Principal Contributor of SQLServerGeeks community for writing blogs and articles at: www.sqlservergeeks.com/blogs/piyush.bajaj.2007
• Microsoft Certified Technology Specialist on SQL Server 2005
• Selected as “Microsoft Student Partner” in December 2010
• Became the “Treasurer” of SSCET CORE Committee
• Organizer of “Microsoft DreamSpark Yatra (DSY)” held in Bhilai, C.G.
• Event Organizer. Student Technology Evangelist
• Secured 2nd in Football in Integrity Cup in SSCET
• Participated in Nexus Workshop conducted by ThinkLabs, SINE IIT Mumbai
• Participated in Robotix Workshop in KSITIJ 2008
• Won medal in 6th National Cyber Olympiad
• Participated in 51st Annual All General Knowledge Test by a wing of USO
• Secured 2nd in Football in Inter-House Competition in class 12th
• Secured 1st in Kho-Kho in Inter-House Competition in class 12th
Projects Completed
1. Tata Bank of India – Account Opening & Management (3 months)
Company: Tata Consultancy Services
Purpose: ILP Project
Project Duration: 3 months
Technologies Used: ASP.NET (.NET Framework 4.0), SQL SERVER 2008
Software’s Used: Visual Studio 2008, SQL Server 2008
Project Guide: Mr. Tejas Somaiya
Team Members: 06
Abstract:
It’s an online banking application which can be used by the bank to get shifted from its paper-work to computer system. In this application, we are providing four roles: Customer, Sales Representative, Branch Manager, and Bank Officer. We are providing many facilities to Customer like they can edit their Personal Details, Request for Cheque Book, Request for Debit Card and also Upgrade it, Transfer fund to other account, and View the Transaction Details.
2. Classifying employee as a Pension holder or Non-Pension holder using ID3 Technique (6 months)
Institute: Shri Shankaracharya College of Engineering and Technology
Purpose: College Project
Project Duration: 6 months
Technologies Used: VB.NET (.NET Framework 3.5), SQL SERVER 2008
Software’s Used: Visual Studio 2008, SQL Server 2008
Project Guide: Mrs. Samta Gajbhiye
Abstract:
It’s an application which can be used by the organization to identify whether a particular employee is a Pension Holder or not so that he would be getting the required privileged. The ID3 technique is a part of Decision Tree method which comes under “Data Mining”. Here we have done the calculation of Entropy and Information Gain, so we can have a Decision Tree.
3. Database Administration of Windows and Linux Server (2 months)
Company: Nestech Consortium Pvt. Ltd. New Delhi - 110068 (INDIA)
Purpose: Summer Internship Project
Project Duration: 2 months (May – June 2010)
Technologies Used: Linux OS, Windows OS, MySQL
Software’s Used: MySQL 5.1 Package, RedHat Linux 5.1
Project Guide: Mr. Rishabh Saini (Under the supervision of Col. Vinod Batra)
Abstract:
The main purpose of the project is to develop customized Database administrative tools –
o Backup Tool
o Restoration Tool
o Job Scheduler Tool
The above mentioned tool is being built specially for “Nestech Consortium Pvt. Ltd. New Delhi” and is being used by them.
4. Library of String Functions (2 months)
Company: Cain Technologies (India) Pvt. Ltd. Noida – 201301 (INDIA)
Purpose: Summer Internship Project
Project Duration: 2 months (May – June 2009)
Technologies Used: Windows OS, Visual C++
Software’s Used: Microsoft Visual Studio 2008
Project Guide: Mr. Robin Gupta (Under the supervision of Col. Vinod Batra)
I have built around 120 functions of Strings which give the flexibility to use it in any mode. The main motive of this project was to build all the functions without using any of the Microsoft in-built function, which can be possible only via pointers and arrays. This project has been of immense help for the software development in the industry. This function is being used and implemented in the industry “Cain Technologies (India) Pvt. Ltd. Noida”.
Interests and Extracurricular activities
• Reading Blogs and Articles in Database technologies.
• Playing Mouth Organ and Singing
• Plays Snooker and Carom
• Big Fan of Cricket, and also watched Tennis and Football
• Also interested in Painting and Dancing
Major Strengths
• Good Database Skills
• Keen to work on Server Administration as DBA, Cloud Computing and Virtualization Technologies
• Calm and passionate for being abreast with latest technological innovations around the globe
• Never give up, no matter how worst the situation is.
I, Piyush Bajaj hereby declare that the above information is correct to the best of my knowledge.
select top(10) r.name, count(r.id) as vote
from Persons P INNER JOIN Rides R
ON P.favorite_ride_id = R.id
group by name
order by vote desc
Please tell me, if it is correct.
By using Indexes, i.e., creating clustered, and non-clustered indexes, whenever its required.
- Piyush Bajaj November 24, 2012