Data Analyst Assistant

Gina Montesdeoca

Brooklyn, NY ***** adhzn5@r.postjobfree.com 347-***-****

Data Analyst Database Administrator

EDUCATION

Pace University, Seidenberg School of Computer Science & Information Systems New York, NY Master of Science (MS) in Information Systems Concentration: Data Analysis GPA: 3.80 May 2020 St. Joseph’s College Brooklyn, NY

Bachelor of Arts (BA) in Mathematics Concentration: Mathematics and Computer Science May 2018 Honors: Cum Laude GPA: 3.71

RELEVANT COURSEWORK

Data Mining and Data Visualization Data Analytics Predictive Modeling Database Administration Database Programming TECHNICAL SKILLS

Programming Languages: R SQL Python (beginner) PHP Database Management: Microsoft SQL Server Oracle RDBMS MySQL phpMyAdmin Software: RStudio MS Excel MS Access QuickBooks ACADEMIC PROJECTS

Big Data and Sentiment Analysis Project March 2020 – May 2020

• Collaborated in analytical, cross-functional teams to perform ETL by extracting unstructured data sets found in customer’s online reviews data sets for pre-processing and analysis.

• Developed visualizations such as word clouds using Python and R to display word frequency in product reviews.

• Performed usability testing, discovered common complaint for product, and gave recommendations to improve product quality with predicted 20% sale increase and increased overall buyer satisfaction.

• Created data documentation for report regarding analysis and data solutions for stakeholders. Exploratory and Predictive Data Analysis Project March 2019 – May 2019

• Worked to collaborate with group of four, including both data and engineering students, to analyze data set of suicide rates using R by performing ETL.

• Performed testing using statistical methods to display the impact Gross Domestic Product per capita and gender have on number of suicides for various countries using R tools like ggplot.

• Predicted the rate of suicide for next 10 years based on most contributing factors, achieving an accuracy rate of 73% for the predictive model using Root Mean Square Error (RMSE). SQL Project for School Database April 2019

• Prepared design of an entity relationship diagram (ERD) model for database architecture, storing a school’s data.

• Created tables and wrote SQL queries to perform data manipulation including insert, update, and delete queries.

• Wrote queries to calculate numbers for student information including academic scores resulting in an increase in school’s productivity and parental involvement.

EXPERIENCE

The Moret Group, New York, NY, Data Entry and Chargeback Analyst (temp) February 2020 – May 2020

• Performed data collection from various sources and disputed chargebacks for customers, employing problem-solving skills.

• Created several MS Excel spreadsheets and reports to track and record data regarding disputed chargebacks. Malin + Goetz, New York, NY, Data Analyst & Administrator (temp) October 2019 – November 2019

• Assisted head of Demand and Supply Administration by entering the purchase orders to suppliers, creating items in QuickBooks and 3PL warehouse system, and exporting files from QuickBooks into MS Excel to track global sales. St. Joseph’s College, Brooklyn, NY, IT Assistant September 2018 – June 2019

• Installed printers and routers, repaired installations, and configured hardware and software to assist IT department in their efforts of technical support.

Contact this candidate