Resume

Sign in

Data Information Technology

Location:
Auburn Hills, Michigan, United States
Posted:
February 04, 2018

Contact this candidate

Priyanka Chavan

****, ******* ***** **, ****** hills, MI, 483**-***-*** 0870 ac4cae@r.postjobfree.com

Objective

To work for an organization, which provides me the opportunity to improve my skills and knowledge to growth along with the organization’s goals.

Skills & Abilities

1 year work Experience in Data Analysis and Database Management

Good knowledge of writing SQL queries and object-oriented programming

Created reports using MS –Excel and Reporting tools for better understanding.

Experience working with Microsoft Power BI, Tableau and Excel to create dashboard

Effective working with large amount of data during internship program and other opportunities.

Used Excel Macros to automate various tasks during analysis.

Good knowledge of Microsoft Excel and Tableau.

Basic knowledge of Apache Hadoop

Effective in working independently & collaboratively in teams with minimal supervision

Highly motivated & eager to learn new things

Good written and verbal communication skills

Education

MS - INFORMATION TECHNOLOGY MANAGEMENT DEC 2017 OAKLAND UNIVERSITY

Major: Information Technology management

GPA: 3.62

MASTER OF COMPUTER APPLICATION MAY 2012 PUNE UNIVERSITY, INDIA

Major: Computer Science

GPA: 3.35

BACHELOR OF COMPUTER SCIENCE APRIL 2009 SHIVAJI UNIVERSITY, INDIA

Major: Computer Science

GPA: 2.99

Experience

DATA ANALYST INTERN OAKLAND UNIVERSITY, MI OCT 2017 -PRESENT

Working on data from various industries

Research on business transformation analytics

DATA ANALYST INTERN SAINT JOSEPH MERCY HOSPITAL, MI SEPT 2016 - DECEMBER 2016

Worked with the Saint Joseph Mercy hospital to analyze patient satisfaction data

Performed Data Cleaning using SQL server and excel

Performed Data analysis to find areas to improve patient satisfaction

Created dashboard for better understanding

Environment: MS-SQL Server 2012, Excel 2013, Tableau

DATABASE DEVELOPER SIMPLE SOLUTIONS, INDIA DEC 2011 - MAY 2012

Worked as Application Developer in simple solution

Worked on SQLite database

Environment: Advance Java, SQLite

Projects

TELCO EXPENSES DASHBOARD TATA TECHNOLOGIES JAN 2016

Worked with the business team to gather requirements & cleaning the data using XLMiner

Used advanced Excel functions to screen the data

Developed Data Warehouse and created ETL package using SQL server integration service to transfer the data from excel to SQL database.

Created Telco Expenses Reports & designed the dashboard to view the reports using the Power BI tool

Environment: Power BI, Visual Studio 2010, Excel, XLMiner, MS-SQL Server 2012

EXPEDIA HOTEL RECOMMENDATION TERM PROJECT MAY 2016

Extracted data from Kaggle website & cleaned the data

Explored the data using R & Python

Developed a Naive Bayes model using R to predict which type of hotel an Expedia

customer can book

Environment: R, Python, Excel 2013

DRIVER TELEMATICS TERM PROJECT JAN 2015

Collected data from Kaggle website & cleaned the data

Cleaned the data using advanced excel functions

Analyzed quantity and quality of a driver's behavior using excel graphs & VBA

Used statistical methods to determine driving behavior of the driver

Environment: Excel, VBA, Excel 2013 (Macros)

Software Tools and Training

Analytical Tools: R & Python, Macros, Excel (Pivot table, macros), Tableau, Power BI

Database Tools: SQL Server Management studio, MS Access

Programming Languages: C, C++, Core Java, Excel VBA

Programming Tools: NetBeans, Eclipse

Introduction to Apache Hadoop course from edX

Java Diploma Course from MZOS Institute, Pune, India

Mainframe Course from Techrel Institute, Pune, India



Contact this candidate