Manager Sql Server

KUNAL PATHAK

***, *** *****, ******* ******, Jersey City, NJ 07306 ? Ph: 803-***-**** ?

************@*****.***

Objectives

Information System graduate and current employee of Department of

Transportation, NYC Gov.(DOT-NYC) seeking a position to utilize my

expertise and aptitudes in the field of Database Management System(DBMS) &

Application Development Industry that results in to strong technical skills

and a professional growth while being resourceful, innovative and flexible.

Summary

. 2+ Years of database development experience in IT industry with SQL,

PL/SQL, Administration tasks, Business Intelligence, Web Application

Development

. Expertise in Relational Database Management System(RDBMS) and Data

Warehouse related concepts

. Excellent understanding of Business Intelligence(BI) including

Reporting Services(SSRS), Integration Services(SSIS) and

programming experience in T-SQL, HTML, C# .NET, JavaScript, PHP

. Deep knowledge of Software Engineering Life Cycle and developing

UML diagrams

Education

Pace University, Seidenberg School of Computer Science and Information

Systems, New York, NY

Master of Science in Information Systems (Focus: Database Management) GPA

3.67 August 2011

The Maharaja Sayajirao University of Baroda, Faculty of Engineering and

Technology, Vadodara, India

Post Graduate Diploma in Computer Applications

June 2009

Sardar Patel University, Vallabh Vidyanagar, India

Bachelor of Science in Information Systems

June 2008

Experience

Department of Transportation, IT & Telecom Division, New York City

Government, NY June-2011-Present

Application Developer (Database & Web Development)

. Perform various SQL queries including building databases, tables,

stored procedures, user defined functions and triggers using system

and mathematical forms

. Develop SSIS packages to pull, process and transfer data from

different sources to destinations

. Create various SQL reports using SSRS and embed in web applications

. Transmit data between server(database) and client using XML

serialization

. Create Crystal Reports using MS Visual Studio 2010 and integrate into

application

. Design user Interfaces for application administrators to maintain

reference tables in database

. Fix burst parts of database tables by performing normalization

processes and by maintaining referential integrity

. Create indexes for fast query execution and tuning

. Develop Intranet web application using C#.NET, HTML, CSS, JavaScript

and Crystal Reports

. Use custom control of asp.NET for log-in, create new user, password

recovery wizard through SMTP configuration

. Define application test conditions and develop complete test plan by

using Microsoft Test Manager 2010 for QA team

. Export/Import data from different file sources such as Excel

spreadsheets, Text files to SQL Server 2008 tables, views using DTS

packages facility

. Use MS Project for project time estimation based on work breakdown

structure principle

Technologies/Tools: SQL Server 2008 R2, Business Intelligence

Development Studio( BIDS), MS Visual studio 2010 Ultimate, .NET

framework 4.0, IIS 7, Microsoft Test Manager 2010 and MS Project

Pooja InfoTech, Vadodara, India

May 2008-June 2009

Freelance Website Designer

. Updated client database to reflect new product features and

competitive advantages

. Designed website using HTML and PHP and analysed data based on

customer requirements

. Generated excel reports containing detailed competitive price

benchmarking of clients' products based on market conditions and

internal business needs

. Documented website performance and metrics using MS office

OHM Infosys, Vadodara, India

January 2008-May 2008

IT Intern

. Analysed and maintained database

. Performed maintenance on hardware and software for 10 computers

Technical skills

. Database: SQL Server, SSRS, SSIS, SSAS, Oracle, My

SQL, MS Access

. Programming Languages: T-SQL, PL/SQL, C#.NET, VB/Java

Script, PHP, ASP,ASP.NET, C/C++, Java(Basics)

. Design Language: HTML, UML, ASP.NET

. Software: MS SQL Server, Visual

Studio, MS Crystal Report, MS Visio, MS Test Manager

. Designing front-end tools: MS Front Page, Dream Weaver

. Office Tools: MS-Office 2003/2007/2010

. Hardware: Computer Assembling, Hardware

Troubleshooting, Software Installation

Course Work

Database Design & Development Database Programming Data Analysis

Project Management Techniques

Database Mining & Warehousing Web Development E-commerce

Technology Information System Principles

Project Work

Capstone Project, the Maharaja Sayajirao University of Baroda

. Designed Content Management System (CMS) using PHP, HTML, My SQL, and

Apache Server Package

Capstone Project, Sardar Patel University

. Developed Online Quiz System using HTML, ASP Classic, MS ACCESS, MS

FrontPage Package

Group Project, Pace University

. Created Hotel Management System using PHP, HTML(Dreamweaver), My SQL

(XAMPP software)

. Created Library Management System using ASP.NET(C#), SQL Server 2008

. Created and analysed credit card company's database algorithm using

Customer centric module and Apriori algorithm

Leadership Experience & Achievements

. Received "Job Well-done Appreciation" certificates from NYC Department

of Transportation

. Won 1st Prize in Painting & Drawing competition at state level

. Inter-College Cultural Festival, Team leader

Contact this candidate