Data Analyst

Benjamin Mao

********@*****.*** 240-***-****

Aspiring data analyst and script developer seeking to use excellent data visualization and database management skills to inform information driven decisions.

SUMMARY OF SKILLS

SQL SAS Python Tableau R Excel Java AWS Adobe HTML CSS Javascript

CERTIFICATIONS

Certified Entry-Level Python Programmer (PCEP), Python Institute, 2020

EXPERIENCE

Data Analyst at Navient Feb 2020-Apr 2021

Wrote complex SQL queries in the Hadoop environment to collate and load large amounts of customer data for output into SAS workbooks while maintaining maximum data security. Used SQL queries to analyze financial datasets to evaluate customer eligibility. Designed a Tableau dashboard to display and filter summary statistics from multiple databases.

Teaching Assistant at University of Maryland, College Park Aug 2019-Dec 2019

Developed SQL query scripts and debugged database queries to organize and examine historical department data; developed Tableau reports and visualizations to support ongoing growth initiatives.

Researcher at University of Maryland, College Park Aug 2019-Sept 2019

Developed Python scripts to extract information from large datasets while implementing privacy protection practices to ensure user anonymity.

Drone Instructor at CodeNinjas, Germantown, MD Jul 2019-Aug 2019

Wrote Python scripts to generate data visualizations of flight paths through interactive graphs and charts; prepared reports using simulated data to optimize flight parameters.

Academic Peer Mentor at University of Maryland, College Park Jan 2019-May 2019

Developed a SQL database to track weather phenomena, wrote SQL queries to securely retrieve data points, and published analysis reports to improve disaster preparedness.

Data Analyst at USDA, Washington D.C. May 2018-Aug 2018

Utilized SAS to amalgamate and tidy large Excel datasets and analyze data elements from Excel pivot tables, transformed SAS datasets into charts and interactive dashboards, and disseminated findings through work reports and presentations to increase crop yield efficiency.

RELEVANT PROJECTS

Washington D.C Gentrification Visualization Oct 2019-Dec 2019

Used Python Folium and Geojson libraries to extract meaningful data and create an interactive map to pinpoint locations of urban construction.

iConsultancy Visualization Capstone Sept 2019-Dec 2019

Deployed an interactive Tableau dashboard tool to visualize career goals and user data; distributed analysis reports to the Tableau Server to drive future course development.

University Services Assistance Forum Feb 2019-May 2019

Built a web forum in Adobe Dreamweaver to collect and review participant feedback, incorporated use of an AWS cloud server to maximize the quantity of data gathered, and integrated data analysis results to produce targeted reports in order to improve department operations.

Textbook Trading Application Project Sept 2018-Dec 2018

Implemented Agile project development guidelines and incorporated user feedback to develop mock-ups of a mobile application to facilitate student access to affordable textbooks.

AIDS Mortality Assessment Mar 2018-May 2018

Used Excel functions to access and collate data points from multiple datasets; integrated R scripts to provide mortality estimates.

COURSEWORK

Introduction to Data Visualization Database Design and Modeling Teams and Organizations

Data Sources and Manipulation Data Science Techniques Dynamic Web Applications

EDUCATION

University of Maryland, College Park

Bachelor of Science in Information Science Dec 2019

Minor in Statistics

Contact this candidate