Resume

Sign in

Sql Server Management

Location:
Suwanee, Georgia, 30024, United States
Posted:
January 24, 2017

Contact this candidate

Piyush Kumar

770-***-**** acygl5@r.postjobfree.com

https://www.linkedin.com/in/piyush-kumar-47b099117

OBJECTIVE

Seeking a challenging position in technology strategy firm where my strong technical background can give an efficient and effective solution that would help the organization to achieve the best solution in business.

EXPERIENCE

Application Development Resources, Inc. Atlanta, GA

Consultant August 2016-Current

As a consultant, I worked mainly on data transfer, data conversion, and data validation using tools such as Sharepoint, Microsoft Visual Studio 2012, and SQL Server Management Studio 2014. I also learned about the Agile Methodology and Scrum. My tasks involved advanced SQL Querying and creating reports. I also got experience with Agile Methodology and Scrum.

MyOrlandoStay Atlanta, GA

Intern/Developer January 2015- May 2016

As a developer, I worked on and learned about database and front end development that required me to use my knowledge of SQL, JAVA, and the database concepts. My tasks involved advanced SQL querying, writing stored procedures with parameters, object oriented java programming, creating reports, and creating GUI for the end user.

RuffaloCODY Athens, GA

Call Center Caller August 2015-May 2016

As a caller, I had to persuade customers to donate money to the University of Georgia fund. I acquired excellent verbal communication skills through this job and a stronger sense of empathy.

EDUCATION

University of Georgia – Terry College of Business Athens, GA

Risk Management – BBA 2012-2016

Important Courses Completed:

Introduction to Information Systems in Business

Predictive Modeling and Optimization

Business Process Management

Interpersonal Communication

Data Management

Commercial Property and Liability Insurance

Employee Benefits

Corporate Risk Management

Advanced Liability Insurance

IMPORTANT PROJECT COMPLETED

Movie Recommendation Application(Java)

This capstone project required me to make a Java Application which could parse to a library of movies, their lengths, and their ratings. Using Eclipse, I used object oriented programming and created methods to manipulate the data. I created both getter methods and setter methods. I created methods that could find the average ratings for a movie or a director. I also made a number of methods that could other things. For my classes, I created constructors, some of which would call into each other using super . With these methods, the end user could find movies with the highest ratings as per the genre, director, or year. They could also use it to look up the average ratings per year or the average rating for their favorite director. The project involved me to use error handling, polymorphism, and multiple common Java libraries such as Apache Commons.

Database Design and Reporting for Multiple Databases (SQL Server and SSRS)

These projects required me to design databases for different types of businesses and a corporation. I was given scenarios and data which I had to turn into a usable database, along with stored procedures, triggers, and lookups. I split the data into their correct tables, and then I created primary and foreign key relationships in between those tables. Most of my projects contained one to many, one to one, and recursive relationships. To optimize my databases, I created indexes and triggers. I also wrote stored procedures that could be used easily access the necessary data. After designing the databases, I also used SSRS to create multiple report templates with stored procedures that the end user could use to easily create necessary reports for multiple situations and scenarios.

Library Database and Catalog Search (Java and SQL)

For this project, I made a library database on SQL Server that consisted of book data. Using Java, I created a front end application in which the user could search for books, author, and genre. They could also add a book to the library if they wished to. The Java Application had a String variables which consisted of SQL Queries, and methods that executed those queries in SQL Server. The project required me to establish connecting SQL Server to Java using Java Database Connectivity(JDBC).

Risk Analysis of a Small Business

This project required me to do extensive research on White Tiger, LLC., an outdoor restaurant. From my research I had to compile a detailed Risk Analysis report which included recommending loss control actions and price optimization. The project also required me to customize an insurance policy that would best suit White Tiger, LLC. I used SQL Server Management Studio to organize and sort all of the data that was required for this project.

Risk Analysis of a Corporation

This project required me to do extensive research on a fictional corporation through a case study. For my project, I compiled a detailed Risk Analysis report for the corporation with a customized insurance policy to best fit their needs. I was also required to come up with various loss control methods for the company. I used SQL Server Management Studio to organize and sort all of the data that was required for this project.

AFFILIATIONS

Society for Management of Information Systems (2 years)

Georgia Insurance Society (2 years)

Relay for Life (8 years)

SKILLS

Java

oUnderstanding of Object Oriented Programming Fundamentals

oAbility to code with for loops and while loops

oAbility to code with conditional if, else statements

oAbility to use JDBC to connect to local and remote servers

oAbility to create GUI

oAbility to use polymorphism concepts

oGood understanding of proper syntax

oAbility to create methods with parameters

oAbility to create constructors, setters, and getters.

Python

oAbility to work with loops and error handling.

oAbility to write Python functions

oAbility to create and manipulate tuples

SQL

oSQL Server 2014 Management Studio

oAbility to write complex queries, indexes, and triggers

oAbility to write complex stored procedures with parameters

oKnowledge of database design

oAbility to create relational database with efficient database design

SSRS

oMicrosoft Visual Studio 2012

oKnowledge of writing flexible reports with different variables and parameters

oKnowledge of writing reports using the wizard and stored procedures

oExperience making Lightswitch HTML and Desktop applications

Hadoop

oUnderstanding of MapReduce and HDFS Fundamentals

oKnowledge of querying in Hive and Pig

Sharepoint

CPCU

Excellent written and verbal communication skills

Microsoft Office

Scrum

TRAINING & CERTIFICATION

Six Sigma Yellow Belt Certification by isixsigma.com through The University of Georgia

Java Programming: An Introduction to Software (5 courses) by Duke University on Coursera

REFERENCES

Available upon request



Contact this candidate