Data Analyst

Puneet Trivedi

Cell: 201-***-**** Email: **************@*****.***

EDUCATION: Stevens Institute of Technology, Hoboken, NJ

Master of Science in Computer Science, GPA – 3.60 Aug 2014- Dec 2015

Thakur College of Engineering and Tech, Mumbai, India

Bachelor of Engineering in Computer Engineering, GPA – 3.55 Jul 2010 - May 2014

CERTIFICATION: Core JAVA Programming, Python Jun 2014, Mar 2015

SKILLS: Programming Languages: C++, C, Java, SQL, Visual Basic and Python

Database Systems: MS SQL Server, Oracle, MS Access

Internet Technologies: .NET, HTML5

Scripting Languages: JavaScript, VB Script, CSS3

WORK

EXPERIENCE: Data Analyst, Western Connecticut Health Network, Danbury, CT Apr 2016 – May 2016

Worked in one of the client location as a Kronos Data Analyst.

Client name is Western Connecticut Health Network.

As a Kronos Analyst, my role was to make sure that the data in the system and the portal is stable and the payroll system which is in kronos is doing the work as per the assigned rules and access on those employer's data.

Client has a data of all the employees in the 3 hospitals of the western region of Connecticut.

First half of the role was to manage the system. So as I had a system admin access. All the tickets raised through the Helpdesk and ITG, it was all directed to me. So it was a responsibility to correct them and make them work as required.

Second half which is still continuing was to make new entries in the data using SQL inside the portal. First phase is to test it in test server then move in the production.

Also for payroll system it was my role to make sure all the employees are being paid according to their paycodes and schedule.

Last but not the least, clock setup was also a role through which employees can punch in/out their time.

Kronos portal and SQL were the most used during this role.

Stevens Institute of Technology, Hoboken, NJ

Graduate Teaching Assistant of computer science department. Jan 2015 – May 2015

Graduate Teaching Assistant of computer science department. Aug 2015 – Dec 2015

Data Analyst Intern, Punim Engg & Co, Mumbai, India May 2014- Jul 2014

Take all the incoming orders from client, orders are taken online through website or in-person via call. Make a BRD (Business Requirement Document) that will contain the entire requirement listed by the client saying how they want the product.

Make an entry in the database which will have all the entries, from the name of the client to the deadline of the delivery. After entering the details, update the database table and forward the document to the Manager for the necessary shipment.

Database entry was done using TALLY software. This helped me to keep track of our client activity.

Did Data Analysis on our database and analyze the cost and predict the future relation between us and the client. Used EXCEL to store and retrieve the data for analysis.

PROJECTS: Stevens Institute of Technology

Data Visualization and Analysis on Quality of Pictures Sept 2015 – Dec 2015

Conducted data analysis on the quality of pictures dataset containing all the information about numerous pictures quality and quantity clicked on earth.

The initial approach was to clean the data, remove the null/blank values and then normalized the data.

Then using R, followed 3 algorithms name, K means, KNN and CART.

Created visualization using ggplot2 and ggmaps.

Used earth.dist function to show exactly the area on earth that has many good pictures.visualization

Data Visualization and Analysis on Staples Data Set Jan 2015 – May 2015

Analysis of data based on number of sales per year in each state in US.

Using those data created a matrix to identify growth and future prediction.

This helps understand the current situation of their sales and shows visual data and present it in graphical and chart representation. Did SWOT, GAP analysis with functional organization, cube matrix, etc. Tableau was used to perform the visualization.

Creating and Retrieving Genealogical Data using Agile Methodology Jan 2015 – May 2015

Designed a family tree which will show generations of family data.

Using those data created a project where we can retrieve the data based on information we have.

This makes data retrieval very easy and quick. To make this possible we used Data Structure and Java program for that GEDCOM file and also we used Junit Testing to test them. Eclipse Juno was very handy.

ADDITIONAL

SKILLS:

Experience with the SDLC and an understanding of Java development

Experience with the Agile Methodology

Experience with Domain Driven Design and data modelling

Contact this candidate