Data Analyst Intern

PRACHI PATEL **** S KING DR APT **** CHICAGO, IL *0616

**************@*****.*** https://www.linkedin.com/in/prachipatel25/ EDUCATION

Master’s in Computer Science EXPECTED JUNE 2021

DePaul University– Chicago, IL

Bachelor’s in Computer Applications JUNE 2015 – APRIL 2018 KadiSarva Vishwavidhalaya– India

INTERNSHIP

DATA ANALYST INTERN

SoluteLabs APRIL 2017 - JULY 2017

Gujarat (INDIA)

Classified the tables in RDBMS and performed SQL queries, operations, constraints, and procedures.

• Worked with senior data analysts and generated visualization of reports from RDBMS results using tableau. EXTRACURRICULAR ACTIVITIES

Presented international research paper on the importance of E-commerce at Ambedkar University -Ahmedabad

Taken “Data Capstone” class from Harvard University through edX platform ACADEMIC PROJECTS

The Effects of Reduced Mobility on Chicago Air Quality Index September 2020 - November 2020 Technology:-RStudio+

Analyzed quantitative air quality measure factors that contribute to the overall AQI within the Chicago city

Created a regression analysis model that can predict the overall AQI

Compared the effects of AQI due to various transportation changes to the last two years and in COVID19 IBM HR Analytics Employee Attrition & Performance(Kaggle Dataset) June 2020 - July 2020 Technology:-RStudio, Tableau

Executed different visualization and marketability techniques on the Kaggle dataset and optimized their appearance for clutter, clarity, graphical integrity, and human perception.

Performed visualization in both R and tableau by showing different examples(comparison of monthly income by education and attrition)and gained expertise in coding as well as visualization. Refactoring VVVVVV Steam Game code March 2020 – June 2020 Tool: Understand, Designate Java

Focused on the desktop version of the VVVVVV steam game which is coded in C++ with applying six metrics

(NOC, DIT, CBO...)

Analyzed the source code of the game and used its metrics to identify bad code smells and anti-patterns.

Refactored a steam game(VVVVVV) by breaking down game entities and maintaining the game state. Block-chain Technology March 2020 – June 2020

Technology: JAVA (Eclipse)

Designed a simple block-chain system to support a ledger shared among networked peers

Broadcast (send) the UBs to all the processes (in JSON format).

Performed the basic idea of "work" and got some idea of public-key cryptographic techniques Database Management System September 2017 – January 2017 Technology: JAVA (Eclipse), Database: Oracle (SQLDeveloper)

Developed a management system for students to store, manipulate and search their projects.

Designed an ER model and translated that model to relational schema and applied PL/SQL constraints.

Created and implemented desktop applications using JAVA swing, JDBC, and ORACLE. TECHNICAL SKILLS

Programming Languages: Python, Java, C, C++

Database: MS Access, MYSQL, RDBMS

Web Technologies: HTML, CSS, PHP

Development Tools: Eclipse, R-Studio, SQL Developer Visualization Tools: Tableau

Contact this candidate