Project Sql Server

HIRAL SHAH

*** *. ******** ***. ********* CA, ***85

Phone: 201-***-**** ********@*****.***

PROFESSIONAL SUMMARY

. 2 Years of experience in SQL Server Developer.

. Highly proficient in the use of SQL for developing complex stored

procedures, triggers, tables, user functions, SQL joins and query

writing.

. Knowledge in Logical and Physical Database design, Normalization.

. Knowledge in Microsoft Business Intelligence technology SQL Server

Integration Services (SSIS), SSRS, SSAS.

. Knowledge in query analyzer, profiler and database components.

. Knowledge of ETL, Backup and Recovery.

. Knowledge in Java, .NET, and T-SQL with database analysis and design.

. Knowledge with all phases of software development life cycle (SDLC).

. Knowledge of PHP,MYSQL,HTML

. Quick learner and good performer both in team and independent job

environments.

. Excellent interpersonal and strong analytical, problem-solving skills

with customer service oriented attitude. A very good team player, self

motivated, dedicated in any work environment.

EDUCATION

Stevens Institute of Technology, Hoboken, NJ, USA GPA: 3.30

Master of Science in Computer Science Graduated: Dec 2009

Specialized course work includes Software Engineering and Database Design

V.V.P. ENGINEERING COLLEGE, Rajkot, India First Class

Bachelor of Engineering, Information Technology Graduated: June

2007

Acharya Institute Of Technology, Bangalore, India

Second Class

Diploma in Information Technology Graduated: June 2004

Learned SQL 9i and earned SQL 9i certification.

RELEVANT COURSEWORK

I learned about the role and purpose of the software architecture and how

to manage a project, as well as cost estimation of a project. The courses I

have studied include:

Software Architecture and Design Computer Architecture

Database Management Systems Knowledge of Distributed Systems

Web Programming Data Mining

Fundamentals of QSE Fundamentals of Project Management

Fundamentals of Cyber Security

TECHNICAL SKILLS

Tools: BIDS, Eclipse, IDE, Wampserver

Languages: C++, C, HTML, Java, PHP

Operating Systems: Windows (2000/XP/NT/Vista), Linux,Unix.

Databases: SQL Server2008/2005, Oracle 9i,

MYSQL, MS-ACCESS

GRADUATE PROJECTS

Designed a Webpage Using PHP and MYSQL.

Jan 09 - May 09

. Technologies worked on PHP, JAVA Script, and MYSQL.

. In Job portal we develop webpage for job seeker in this project they

can look for job and post their resume in it.

. Design the database for login of student as well Admin, job post,

report for all jobs.

Case Study presentation in Data Mining.

Jan 09 - May 09

. Case study about Neural Network to identify and reduce revenue losses

by preventing bad debt in telephone companies.

. In this we have to provide the solution to reduce bed dept in

telephone companies.

Develop a project report for project management

Aug 09 - Dec 09

. In this project we discuss the success, risk and also with the use of

Microsoft project we develop activity Diagram.

. In this project as a manager what are the steps we are taking to make

a project success, and what are the problem occurs in during managing

the project.

. Technologies Used: Microsoft project.

Library management system

Aug 08 - Dec 08

. A Library management system that maintains the database of all books,

account of all members. List of issued book and returned book.

. The front end used is java using SQL Server 2008 as back end.

UNDERGRADUATE PROJECTS

Paper (B.E. 5th sem): E-commerce

In which I discussed public key and private key cryptography.

Website (B.E.6th sem): Library Management System

In this project I created a database for a library and SQL

query.

Website (B.E.7th sem): Online System Banking

Project (B.E 7th sem): Chat System

WORK EXPERIENCE

Avani Software Pvt., Baroda, India (01/2007-12/2007)

Role: SQL Developer/BI Developer

Responsibilities:

. Used Joins, correlated and non correlated sub-queries for complex

business queries involving multiple tables from different databases.

. Automated the SSIS jobs in SQL scheduler as SQL server agent job for

daily, weekly and monthly loads.

. Design and develop SSIS packages, store procedures, configuration

files, tables, views, and functions; implement best practices to

maintain optimal performance.

. Proven ability in generating Drill down and Drill through reports with

Drop down menu option, sorting the data, defining subtotals in SSRS

2005.

. Created views to restrict access to data in a table for security.

. Used Index usage statistics to determine how useful an index is and if

an index is improving or hindering application performance.

. Designed SQL SSIS Packages to extract data from various data sources

such as Access database, Excel spreadsheet, and flat files into SQL

Server 2005 for further Data Analysis and Reporting by using multiple

transformations, scheduled and maintained nightly and weekly loads of

data by creating the corresponding job tasks.

. Enhanced performance of databases using optimization techniques-

normalization, indexing and Transaction Isolation levels, monitoring

logs to ensure the completeness of batch processes, scripts and

processes.

. Involved in developing database objects such as procedures, triggers,

constraints, indexes and views. Used T-SQL to build dynamic stored

procedures.

Environment:

SQL Server 2005,SSIS,SSRS, T-SQL, MS Access

Avani Software Pvt., (Internship) Baroda, India (05/2006-12/2006)

. Developed website on Project Management framework. Owned the MySQL

database module which allowed users to register using unique usernames

and passwords.

. Communicated with my peers and superiors giving regular status updates

about the progress of the project hereby assuring my ability to meet

deadlines.

. Specific accomplishments for this project included:

o Technologies used: PHP, JAVA Script, and MYSQL.

Contact this candidate