Data Analyst

Khang Nguyen

**** *. ** **** ***, Los Angeles, CA 90046

209-***-**** **************@*****.*** linkedin.com/in/khangnguyen518/

Certifications

The Complete SQL Bootcamp 2020: Go from Zero to Hero November 2020

●Utilize PostgreSQL and PgAdmin, learn the basics of SQL syntax (SELECT/FROM/WHERE clauses).

●Analyze data using aggregate functions with GROUP BY commands.

●Run advanced queries with string operations and comparison operations.

●Learn to use logical operators to add logic flow to your SQL queries, create tables and databases with constraints on data entries, and execute JOIN commands.

Python for Data Science and Machine Learning Bootcamp (In Progress)

●Learn to use NumPy for Numerical Data, Pandas for Data Analysis, Matplotlib for Python Plotting, Seaborn for statistical plots, Plotly for interactive dynamic visualizations, Spark for Big Data Analysis, and SciKit for machine learning tasks.

●Implement Machine Learning Algorithms, K-Means Clustering, Logistic Regression, Linear Regression, Random Forest and Decision Trees, Natural Language Processing and Spam Filters, Neural Networks, and Support Vector Machines.

Experience

Business Analyst Los Angeles, CA

SDI Presence May 2020 – Present

●Assist with identifying client requirements through customer interviews, workshops, and review of project documentation, such as RFPs, proposals.

●Analyze business requirements and translate them into effective & efficient application configuration for managers of local government departments such as IT and Finance.

●Obtain knowledge of Enterprise Resource Planning (ERP) Finance applications (Ex: Accounts Payable, Accounts Receivable, General Ledger, Fixed Assets, Cash Management, Procurement & Sourcing, Inventory Management) as well as Land Management Systems (LMS), Enterprise Asset Management Systems, and Utility Billing/ Customer Information Systems.

●Provide IT strategic planning to identify issues, trends, and opportunities to improve processes.

●Facilitate the development of testing scripts and user acceptance testing (UAT) processes.

Operations Analyst Intern Culver City, CA

City of Culver City September 2019 – May 2020

●Updated and recreated transit ridership reports using Excel and PowerBI for the Department of Transportation.

●Developed SQL queries to pull in On Time Performance data for reporting and visualization.

●Coordinated focus group surveys, facilitate presentations, data collection and analysis for the implementation of the NextCCbus app alongside the Communications Division.

●Facilitated system verification and testing for the launch of the Culver City Smart Bus System alongside the Operations, Planning and Clever Devices Teams.

Research Analyst Los Angeles, CA

UCLA Luskin School of Public Affairs April 2019 - June 2019

Key participant in a research project examining the landscape of accessory dwelling units (ADU) in Pacoima, resident needs, and anti-displacement methods, such as community land trusts.

●Performed an aerial analysis of undeveloped backyard space in the Pacoima neighborhood of Los Angeles using Google Maps.

●Conducted door-to-door surveys to understand the current ADU landscape, providing data on current ADU households, housing conditions, tenant/landlord relationships, and household tenure.

●Explored the causal relationship between the physical environment of ADUs and the spatial practices of the residents who live in them.

Education

University of California, Los Angeles (UCLA) Los Angeles, CA

Bachelor of Arts in Economics, Minor in Urban & Regional Studies March 2020

●Relevant courses: Computational Finance and Data Analysis for Financial Engineering, Econometrics, Geographic Information Systems, Programming in C++, Statistics.

●UCLA Achievement Scholarship: Awarded by the UCLA Undergraduate Admission Office in recognition of students’ academic excellence.

Skills

●Programming Languages: Python (pandas, matplotlib, numpy), SQL, R, Stata, C++

●Business Intelligence Software: Tableau, PowerBI

●Microsoft Office: Word, Excel (V-Lookup, Pivot Tables, IF formulas, Macros), PowerPoint, Outlook, SharePoint

●GIS Software: QGIS

●Languages: Spanish & Vietnamese

Contact this candidate