Sql Server Software Engineer

Ankur Upadhyay

** ***** ***** ***** *** *** Boston, MA 857-***-**** ********.*******@*****.*** LinkedIn

Education:

M.S. in Computer Science

University of Massachusetts, Boston 2014-2016

GPA: 3.64

B.E. in Electrical & Elect. Engineering

Rajeev Gandhi Technical University, India 2006-2010

GPA: 3.4

Related Courses:

Database Management

Introduction Of Software Engineering

Database Backed Website and Web services

Analysis Of Algorithms

Software Development Laboratory

Object-Oriented Design and Programming

Theory of Computation

User Interface Design

Object-Oriented Software Development.

Technical Skills: -

Languages

JAVA, C#, C++, PHP.

Technologies

J2EE, JSP, Servlets, JDBC, Asp.Net, HTML5, CSS, JavaScript, Angular.js, REST, AJAX, Web Services, JSON, XML, Crystal Reports.

Database

MS SQL Server, Oracle 11g, MySQL, MongoDB, SQLite, PostgreSQL.

Process & Methodologies

Spring, Hibernate, MVC4, n-tier, UML, Junit, JIRA, Design Pattern, Agile, Scrum, Waterfall.

Operating System

Windows, Linux, UNIX.

Tools

Eclipse, NetBeans, Maven, Code Block, Visual Studio, SVN, Tortoise Version Control.

Work Experience

Graduate Research Assistant (Intern), University of Massachusetts, Boston, MA Dec 2014 –May2016

Responsible for the maintenance and development of the website of Division of Enrollment Management.

Handled all aspects of the web application including development, maintenance, testing, debugging & deployment.

Developed and maintained MySQL database

Responsible for code optimization and testing of the website across different browsers.

Troubleshoot and fix systems as part of Production support.

Build an algorithm that provides the number of students attended for the specific event.

Reviewed the requirement and involved in database design for new requirement.

Responsible to solve IT related issue for the department and provide them system support.

Software Engineer, Diaspark Infotech Pvt. Ltd. India May 2012- July 2014

DIASPARK ENERGY [Java, J2EE, JSP, Spring MVC, Hibernate, JavaScript, REST, JSON, XML, SQL server]

Design and develop application using agile methodology and use spring frame work that leverages classic MVC architecture.

Implement Dashboard for the product that provide information of all sites current generation, total generation and provides details for Online and off line component and their current status.

Implement web interface for Smart Alert that generate alerts via email and report the fault in the system.

Build an interface which call the API and gather the live feeds from installed sites in every 15mins.

Implement and manage different stored procedures that provide the information for system failure and generate alerts.

Optimize the queries to improve the performance by 30 % in fetching the live reading to plot the graphs.

Worked on different modules independently like component graphs, Dashboard, MASS CEC & Alert management.

GMS (Gas Management System) [Java (1.7), JSP, Hibernate, JQuery, REST, JSON SQL server]

Responsible for requirement gathering analysis of design, defect fixing and enhancement of the application.

Create stored procedure for the calculation for rates and transportation modules.

Individually managed the release of the project which includes implementation of change request and migration the code to production environment.

Worked on some key modules independently like all rates, transportation and contract.

Academic Projects: University Of Massachusetts, Boston MA (Sept 2014- May 2016)

FILE SYSTEM [Java 1.8, Facade Design Pattern, Singleton Design Pattern, Ant, FindBugs]

Build a file system application that supports Directory, File and link data structure.

Implement all the cmd commands to access the data present in the file system.

DB BACK-END SERVER [Java1.8, Ant, Find Bugs, Jacoco, Multithreading, SQLite]

Build a Db-backend server that converts all the incoming HTTP request to a DB query and return a query result as a HTTP response.

It uses Http Exchange to manage server and client interaction using sockets and handle multiple request using thread pool.

JOURNALS: CRM tool for journals publication [JAVA, Spring, LINQ, HTML5, CSS, JavaScript, SQL server]

Build an online web-based application that allow used to submit their papers/journals to the university where a community can review their work and decide about the result.

Application consists of different modules as users, sub-editorial, EIC and reviewer.

Contact this candidate