Application Developer

KUNAL PATHAK

***, *** *****, ******* ******, Jersey City, NJ 07306 Ph: 803-***-**** ************@*****.***

Objectives

Recent Information System Graduate and current employee of Department of Transportation, New York City Gov.(DOT-NYC)

seeking a position to utilize my expertise and aptitudes in the Information Technology Industry that results in to strong

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

Summary

2+ Years of Database Experience in IT industry with SQL, PL/SQL, Administration tasks, Web Application Development

Expertise in Relational Database management system(RDBMS) and related concepts

Excellent understanding of Business Intelligence(BI) and programming experience in HTML, C# .NET, PHP, SQL Server,

Reporting Services and Integration Services

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 Application 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 tables, stored procedures, user defined functions and triggers using

system and mathematical forms

Export/Import data from different file sources such as Excel spreadsheets, Text files to SQL Server 2008 tables, views

using DTS packages facility (Drug and Alcohol (DART) Project)

Fix burst parts of database tables and perform data insertion to Database from User Interface using XML file

Create indexes, integrity constraints and views and Convert database tables to normalized forms (Advocates Project)

Generate Crystal Reports based on retrieved data from database (Advocates Project)

Define application test conditions and develop complete test plan by using Microsoft Team Foundation Server/Visual

Studio Team Web Access for QA team (CASH-III Project)

Create user interfaces using C#.NET, Data modeling and database designing

Use custom control of asp.NET for log-in, create new user, password recovery wizard through SMTP configuration

(RCP Project)

Use MS Project for project time estimation based on work breakdown structure principle

Technologies/Tools: SQL Server 2008 R2, MS Visual studio 2010 Ultimate, .NET framework 4.0, IIS 7, Crystal

Reports, 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, SSAS, SSRS, SSIS, Oracle, My SQL, MS Access

Programming Languages: 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

Achievements/Activities

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

Received “Job Well-done Appreciation” Certificates from New York City Department of Transportation

Inter-College Cultural Festival, Team leader

Language Skills

Fluent in English, Hindi, Gujarati

Contact this candidate