Giang's Portfolio.

— Passionate Data Analyst Making Sense of the Numbers —

Dear Hiring Manager,

I am Giang Pham, currently seeking a position as a:

  • Data Analyst.
  • Business Intelligence Analyst.
  • Business Analyst.
  • Roles related to data analysis.

Highlights

  • 1+ year as a Data Analyst at a logistics startup.
  • 2+ years as a Salesforce System Admin and Data Analyst in retail furniture.
  • Experienced in e-commerce, retail, and logistics, with a keen interest in exploring other fields.

Skills

  • Data tools : Excel, Gsheets, SQL, Looker, Superset, Power BI, Basic Python.
  • Platforms : SAP, Odoo, Salesforce, Magento, WordPress, Haravan.
  • Web tools : HTML, CSS, Google Analytics.
  • Other tools : ChatGPT, Jira, Confluence, Diagram.net.
  • English : Good reading and writing skills, basic speaking and listening.
  • Soft skills : Problem solving, analytical thinking, attention to detail, communication.

Strengths

  • Eager to learn and open to acquiring new knowledge.
  • Able to work well both independently and in teams.
  • Enthusiastic about learning and using tools to improve work efficiency and accuracy.

Preferred Locations

  • Ho Chi Minh City.
  • Binh Duong.

Personal Information

  • Marital status : Single.
  • Email : giangpnt.work@gmail.com
  • Address : Phu Nhuan District, HCM City, Vietnam.

Excel & Gsheets Projects

Skills: Pivot Tables, Power Query, Data Visualization, Storytelling

  • Adeline Drink - Sales Case Study

    Adeline Drink
    How to increase sales?
    Google Sheets Google Slide

  • Plato Pizza - Sales Dashboard

    Plato's Pizza
    What can we do to improve the pizza store's sales?
    Excel

  • Remote Working Survey - How has remote work changed in 2021, barriers and opportunities?

    Remote Working Survey
    How has remote work changed in 2021, barriers and opportunities?
    Excel

  • The global Unicorn landscape

    The global Unicorn landscape
    Despite the uncertainty of COVID-19, 2021 spawned more unicorns than the previous years combined
    Excel

  • Hiza logistics & Owee: Analyzing transport performance

    Hiza logistics & Owee
    Analyzing transport performance
    Excel

  • Hotel Group - Analyze cancellation rates, and average daily prices & revenue lost

    Hotel Group
    Analyze cancellation rates, and average daily prices & revenue lost
    Excel

SQL Projects

Skills: Joins, Subquery, Window Functions, Common Table Expressions (CTE), Views, User-Defined Functions (UDF), Stored Procedure

  • Fuzzy Factory - Analyze and optimize the business’ marketing channels, website, and product portfolio

    Analyze and optimize the business’ marketing channels, website, and product portfolio
    MySQL

  • Fuzzy Factory - Analyze and optimize the business’ marketing channels, website, and product portfolio

    Analyze Pizza metrics, runner and customer experience, ingredient optimisation, pricing and ratings
    MySQL

  • 120 years of Olympic history: athletes and results

    Analyze athletes and results
    PostgreSQL

  • Analyzing student marks

    Analyze student marks
    PostgreSQL

BI Projects

Skills: Connect Data Sources, Clean & Shape, Data Model, Power Query, DAX, Data Visualization, Dashboard Design

  • Adventure Works - Sales & Customer Analysis

    Adventure Works - Sales & Customer Analysis
    Power BI

  • Human Resources Report - Overview, Income, and Satisfaction Insights

    Human Resources Report - Overview, Income, and Satisfaction Insights
    Power BI

  • Adventure Works - Sales & Customer Analysis

    Financial Report - Income Statement, Balance Sheet, Cash Flow, Financial Details, Revenue Insights
    Power BI

Python Projects

Libraries: Pandas, Matplotlib

  • Adventure Works - Sales & Customer Analysis

    Electric store - Sales analysis

Storytelling Projects

Skills: Data Visualization, Storytelling, Present Insights

Projects: Updating

Certificates

Completion Month Issuing Organization Certificate Name
In Progress Maven Analytics Data Analysis with Python & Pandas
In Progress AWS AWS Cloud Technology Consultant Professional
09/2024 Codebasics SQL Beginner to Advanced For Data Professionals
08/2024 Meta Meta Data Analyst
07/2024 Google Google AI Essentials
01/2024 - 02/2024 CIP School (Philippines) ESL (English as a Second Language)
05/2022 Maven Analytics Python Foundations for Data Analysis
04/2022 Maven Analytics Advanced MySQL Data Analysis
12/2021 Microsoft Certified Power BI Data Analyst Associate
10/2021 Google Google Data Analytics Professional
05/2021 Maven Analytics MySQL Data Analysis
01/2021 Maven Analytics Power BI Desktop
01/2021 Maven Analytics Power Query, Power Pivot & DAX
12/2020 Maven Analytics Excel Analytics Tips
11/2020 Maven Analytics Excel Pivot Tables