Data Analyst Real Estate

PHUONG ‘DESTINY’ NGUYEN

/destinyng 206-***-**** *******.*******@*****.***

https://public.tableau.com/app/profile/destinyng

Technical Skills

• SQL (SQL Server, MySQL, PostgreSQL, SQLite)

• Python (Pandas, NumPy, SciPy, MatPlotLib)

• Excel (VLOOKUP, XLOOKUP, PivotTables)

• AWS (S3, Glue, Athena, QuickSight)

• Power BI

• Tableau

Projects

NETFLIX DATA INSIGHTS AND VISUALIZATION (SQL) July 2023

• Employed SQL for data extraction, meticulously tracking Netflix's movie and TV show additions by year, genre, and rating.

• Transformed findings into dynamic visualizations, providing essential inputs for strategic content curation decisions.

• Utilized Tableau dashboards to articulate genre insights, optimizing content strategies for enhanced user engagement. COVID-19 DATA EXPLORATION (SQL) June 2023

• Leveraged SQL methodologies to perform an extensive analysis of COVID-19 data categorized by nations.

• Visualized key metrics, trends, and geospatial insights through interactive dashboard using Amazon QuickSight.

• Provided valuable data-driven insights to address impacts on different demographic groups and vaccination progress. BIKE SALES DASHBOARD (EXCEL) May 2023

• Created bar charts, graphs, and pivot tables to visualize customers average income, age, education per purchase.

• Tracked key metrics and identify areas for improvement by using advanced Excel functionalities.

• Designed interactive features, such as slicers and dropdown menus to filter and explore data. NASHVILLE HOUSING DATA CLEANING (SQL) May 2023

• Curated and integrated diverse housing datasets to create a comprehensive repository of Nashville's real estate market.

• Utilized SQL queries addressing missing values, duplicates, inconsistencies, and data format standardization.

• Implemented thorough quality checks and validation to ensure dataset reliable and meaningful insights. IFOOD DATA EXPLORATION (PYTHON) April 2023

• Conducted in-depth data analysis using Python based on customers behavior purchases and leveraged statistical methods.

• Aggregated and preprocessed raw data using NumPy, pandas and visualized data using matplotlib and seaborn.

• Gained insights to help business choose the better marketing campaign and propose data-driven solutions. Work Experience

RELATIONSHIP MANAGER – Bank of America - Shoreline, WA December 2020 - December 2021

• Cultivated strong client relationships, resulting in a 20% increase in portfolio value, 15% higher customer satisfaction scores.

• Analyzed financial data, investment patterns to provide personalized financial advice and strategic recommendations. ASSISTANT INVENTORY MANAGER – Nordstrom – Kirkland, WA September 2017 - December 2020

• Analyzed sales data to identify popular product categories, leading to a 10% increase in inventory turnover.

• Assisted in forecasting demand and optimized inventory levels, reducing stock outs by 20%, cutting inventory costs by 12%. Education

Business Intelligence Data Analyst – Codecademy February 2023 Certified Cloud Practitioner – AWS September 2022

Full Stack Web Developer – Coding Dojo Bootcamp June 2022 BA – Business Administration (Finance/Management) – University of Washington, Bothell June 2016

Contact this candidate