Data Analyst Python

DANIEL C. CHEN

347-***-**** LinkedIn: daniel-c-chen ******@********.***

EDUCATION

COLUMBIA UNIVERSITY IN THE CITY OF NEW YORK New York, NY M.S. in Enterprise Risk Management (GPA 3.7/4.0) Feb 2019 Relevant Coursework: Value-Based ERM, IT Risk, Securities Analysis, ERM Modeling, Data Science NATIONAL TAIPEI UNIVERSITY OF EDUCATION Taipei, Taiwan Bachelor of Digital Technology Design, summa cum laude (GPA 3.83/4.00) June 2016 SKILLS

Tools: Python, MySQL/MSSQL/PostgreSQL, VBA, HTML/JavaScript/CSS Tableau, QlikView, pgAdmin, Domo, MS Excel, MS Access EXPERIENCE

COLUMBIA ENGINEERING DATA ANALYTICS BOOTCAMP New York, NY Data Analyst July 2019 – Feb 2020

ETL process: Transformed and consolidated data from APIs, including Google Maps, IGDB, US Census, OpenWeatherMap, and datasets such as “NYC Airbnb 2019” and “NYC Bike 2019” on Kaggle.

Data Analysis: Utilized Python to demonstrate observable trend assessment, such as “the use of Capomulin for tumor therapy” based on the tumor response, and “Factors that affect the growth of membership of NYC Bike”.

Data Visualization: Built visualization dashboards with Tableau, Plotly.js and D3.js. COHNREZNICK (ACCOUNTING, TAX, AND ADVISORY FIRM) New York, NY Cyber Security Intern in Advisory Department Sep 2018 – Apr 2019

Model Prediction and Risk Awareness: Implemented predictive model analytics on department’s datasets to assess the nature of data breaching activity through data mining algorithms by using Python, and efficiently lessened likelihood of security breaches by 30% through various phishing awareness training for employees.

Project Development: Created enhanced “Privacy Framework” with “Privacy Maturity Model” from different aspects inclusive of strategy, operation, and security interface for CohnReznick Advisory Department.

DENTSU TAIWAN INC (ADVERTISING COMPANY) Taipei, Taiwan Intern in Creative Department July 2015 – July 2016

Teamwork: Collaborated closely with Creative Director and a 10-person creative team to communicate key insights of customers and to develop cross-channel marketing tactics for the 7-11’s “Slurpee happy hour campaign” by using imagery and sending out promotion message across all channels.

Design: Produced outline and story board of TVC for “7-Eleven” and “Band”, the dating app. PROJECTS

“COVID-19 Analysis” Tableau

Tracked COVID-19 cases globally with animated visualizations.

Demonstrated confirmed cases, deaths, and cured population with KPI, map, bar chart, and line graph.

“CNN News Sentiment Analysis” Python / Scikit-Learn / HTML / JavaScript / Pandas

Developed a website with Flask to classify user article between liberal and conservative.

Trained binary classification models with data scraped from CNN.com via BeautifulSoup.

Performed feature extraction with TF-IDF and achieved 92% accuracy with SVM by tuning parameters with GridSearchCV.

“Video Game Web Application” Python / PostgreSQL / HTML / JavaScript / Flask / Plotly / Pandas

Launched a website with Flask & SQLAlchemy where gamers can efficiently find video games that suit their interest while increasing revenue for game developers

Interacted with IGDB API to get up-to-date game feature data and developed a normalized database with PostgreSQL.

Developed a web dashboard with Plotly.js and deployed to Heroku to visualize game statistics.

“New York City Airbnb Analysis” Python / Pandas / Matplotlib / Seaborn

Performed exploratory data analysis and data visualization for “NYC Airbnb in 2019” dataset from Kaggle.

Utilized Google Maps API to render Airbnb density and occupancy rate heatmap with Matplotlib.

Derived correlations between number of reviews & price with linear regression and visualized with Seaborn.

Contact this candidate