_edited.png)
THE NGUYEN EFFECT
Freelance Data Analyst & Web Developer
RESUME
OVERVIEW
Data-driven Analyst with exceptional analytical skills and experiences in data analysis, data mining, databases development, as well as Full Stack Web Development.
Demonstrated experience with consolidating data from multiple data sources in cross-functional environments.
Proficient in data visualization tools and relational databases and end-user tools (e.g., SQL language) to query data sets and create reports. Utilize SQL query languages and using them to ETL or manipulate data. Strong track record of experience with relational databases and understanding of potential causes of data quality issues.
RELEVANT SKILLS
Python, R, JavaScript, Excel, SQL, NoSQL, RDBMS, SPSS, Tableau, HTML, Agile, Spark, Git, Apache Cassandra, CSS, React, PostgreSQL, Jupyter Notebook, ETL.
LANGUAGES
Vietnamese (Native); English (bilingual)
CITIZENSHIP
Vietnamese and GreenCard Partitioning.
Do not require H1B sponsorship
EDUCATION HISTORY
2019 - 2021
CLAREMONT GRADUATE UNIVERSITY
- CLAREMONT, CA
Master of Science in Information Systems & Technology
Specialization: Data Science
GPA: 3.88/4.0
Received CISAT FELLOWSHIPS in 2019, 2020, and 2021
Relevant Research: Viability Pattern Discovery with the discovery of two viability paths exists and confirmed correlations between variables.
Relevant Course: Database (SQL Server), Machine Learning in Healthcare (Python), Seminar in Knowledge Discovery and Data Mining (SAS Enterprise Miner), Social Networking Analysis (R).
2013 - 2018
CALIFORNIA STATE UNIVERSITY OF SAN MARCOS
- SAN MARCOS, CA
Bachelor of Science Business Administrative
Specialization: Global Business and Marketing
GPA: 3.0/4.0
CERTIFICATIONS
FULL-STACK WEB DEVELOPER CERTIFICATION
University of California San Diego Extension, 2019
Front-end and back-end technologies including HTML5, CSS3, JavaScript, jQuery, Express.js, React.js, Node.js, progressive web apps, agile methodology, computer science, database theory, MongoDB, MySQL, Git.
DATA ENGINEERING NANODEGREE
Udacity, 2021
Design data models, build data warehouses and data lakes automate data pipelines and work. with massive datasets.
Data modeling with Postgres, Apache Cassandra.
Data warehousing on Amazon Web Services (AWS).
Store big data in a data lake and query it with Spark.
Schedule, automate, and monitor data pipelines using Apache Airflow. Run data quality checks, track data lineage, and work with data pipelines in production.
TABLEAU PREP BUILDER
Tableau Learning Center
Connect to, clean, and output your data for analysis in Tableau Desktop and Tableau Server or Tableau Online.
Apply cleaning operations, create calculations, and edit incorrect field values singly or in groups, replacing values manually or using built-in algorithms to address data issues.
Build data prep flows to address common scenarios, such as the need to combine data using joins and unions, and reshape data using pivots and aggregations.
Validate data preparation work in Tableau Prep Builder and in Tableau Desktop.
Configure and use Tableau Prep Builder's data sampling functionality.
Design a complex flow, end-to-end, applying the range of cleaning techniques available, for a real-world scenario.
TABLEAU DESKTOP INTERMEDIATE II
Tableau Learning Center
Combine data from multiple tables using joins and unions, and learn when to use blends.
Use extracts to improve performance.
Build advanced chart types, including bar-in-bar and bullet graphs.
Use advanced calculations and table calculations to modify data as needed for analysis.
Use statistical techniques to analyze data.
Use parameters and input controls to support audience analysis.
Implement advanced geographic mapping techniques and use custom images and geocoding to build visualizations of non-geographic data.
Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
PROFESSIONAL EXPERIENCE
2020 - 2021
GRADUATE TEACHING ASSISTANT
CLAREMONT GRADUATE UNIVERSITY | CLAREMONT, CA
Taught students using RDMS concepts and the SQL language, including joins, triggers, conditional statements, stored procedures, cursors, security, and grant privileges.
Supervises group projects for 40+ students, ensuring students understood concepts and on track to complete projects.
Grades quizzes, tests, homework, and projects, providing students with timely feedback and helping increase homework grades by 15%.
Assists professors with classroom management and document coordination, maintaining a positive learning environment.
Tutors struggling students individually and in small groups to reinforce learning concepts, helping 90% of students code in SQL language (query, function, and store procedure) and build and optimize databases.
2018 - 2019
EXECUTIVE ASSISTANT
CREATIVE LIFE SOLUTION | ESCONDIDO, CA
Managed and organized physical and digital files for easy updating and retrieval.
Prepared documents, reports, and presentations for the CEO using Microsoft PowerPoint, Excel, Word, and Publisher.
Developed and updated spreadsheets and databases to track, analyze, and report performance and sales data.
Formatted, edited, and researched evidence for the CEO’s published book.
OTHER RESEARCH AND PROJECTS
DYADIC PARTNERSHIPS AMONG MARVEL COMIC CHARACTERS
COURSE: SOCIAL NETWORK ANALYSIS
Data Visualization and Analysis using R packages.
Detected communities within the Marvel comic characters.
Determined the popularity of some characters among the community.
Analyzed the social network connections between characters and compared it to The Marvel Universe series.
VIABILITY DETECTION AND ANALYSIS
COURSE: DATA PRACTICUM
SPONSOR: KITE PHARMA (GILEAD SCIENCES COMPANY)
Used analytical and statistical methods such as Person’s correlation, Spearman’s correlation, and developed time series
to define the relationships between provided variables.
Answered client questions and presented new findings and insights based on provided datasets, resulting in client
interest in future R&D.
Performed data understanding, data preparation, and data modeling using data analysis tools, such as SPSS, Tableau
Prep, and Python.
MACHINE LEARNING AND DATA ANALYSIS IN THE MENTAL HEALTH TECH WORKPLACE
COURSE: ML IN HEALTHCARE USING PYTHON
Prepared and performed data wrangling, data understanding, and data modeling processes on the “Mental health tech
workplace 2014” dataset using python data analytic packages.
Statistically analyzed the dataset and provided visualizations using python data analytic packages.
Performed Logistic Regression and ANN models on the dataset to predict the outcomes, achieved an accuracy of 83%
in the result.
Delivered the report to answer the question “what are the main factors leading employees in tech workplace seek for
mental health treatment?” and provided the ML models to predict the outcome.
VOYAGERS TRAVEL WEBSITE
COURSE: SOFTWARE DEVELOPMENT
Led an agile team of five to develop a website focused on travel using the Django framework.
Created front-end and UI for the website using HTML, JavaScript, and CSS.
Developed backend functions using Python and MongoDB.
Deployed the website to the Heroku server.
Delivered the final product one week earlier than the stated deadline.
DATABASE SYSTEM DESIGN
COURSE: DATABASES USING MICROSOFT SQL MANAGEMENT SYSTEM
Designed a database system for a sales transaction application using Microsoft SQL Server, resulting in database
optimization and increased user security and privacy.
Analyzed, identified, and designed a relational database and appropriate integrity constraint specifications.
Conducted data modeling, data schema, created views, and stored procedures required by the business.
Determined access levels for different users.
Delivered final product with improvement in database optimization and cut down query execution time by 25%.