FIND ME AT

Phone: +65 80206848

Email: phanthanhngoc92@gmail.com

http://phanthanhngoc.com

Singapore

 

EDUCATION

  • Bachelor of¬†FINANCE¬†
    (UEH University)

LANGUAGES

  • English (Toeic 835)
  • Chinese (HSK4)

DATA SKILLS

  • SQL (MySQL, PostgreSQL, Redshift, BigQuery)
  • SAS
  • DBT
  • Power BI
  • Power Query
  • Google sheets, Excel
  • Visual Studio Code
  • Python (Pandas, Numpy, Matplotlib, Selenium…)
  • Jupyter Notebook

SOFT SKILLS

  • Fast-learner
  • Quickly-adapt
  • Critical thinking
  • Working under pressure
  • Products & users first mindset
  • Teamwork
  • Problem-Solving
  • Data-driven

REFERENCES

  • DR. LE NHAT TAN

    Head of MIS – Shinhan
    Finance Lecturer – Fulbright University

    (+84) 888 926 768 tantoankhoa10@gmail.com

PHAN THI THANH NGOC
(MEGAN PHAN)

Data Analyst

ABOUT ME

  • 4 years of experience in Data Analysis.
  • Strong background in Banking, E-commerce, and Delivery industries.
  • Proficient in data modeling (SQL & DBT) and data visualization (Power BI), leveraging these skills to extract valuable insights from complex datasets.
  • Demonstrates a proactive “can-do” and “user-first” mindset, consistently exceeding expectations in delivering high-quality results.
  • Actively stays updated with industry trends, new technologies, and best practices in data analysis to drive continuous improvement.

WORKING HISTORY

YES4ALL - ECOMMERCE (USA)
Data Business Analyst- Strategy | Dec 2022 - Dec 2023
  • Consolidate data from multiple sources (AMAZON, WALMART, WAYFAIR) to design a reporting database.
  • Proficient in implementing PostgreSQL flow for transforming raw data to report-ready format (Query, Views, Procedures and Function).
  • Collaborate with cross-functional teams to construct a comprehensive ERP database, data integration, and optimize performance.
  • Proficient in analyzing requirements, documenting BRD, and ensuring alignment with stakeholders (Finance, Sales, IT, and Product Development)
  • Proficient in building and maintaining Power BI dashboards for effective data visualization (P&L, Sales & Expenses by SKU, Promotion by SKU…).
  • Conduct data mining and analysis to generate valuable business insights that guide strategic decision-making and optimization efforts.
  • Implement automated data pipeline monitoring workflow, ensuring data quality and integrity for enhanced efficiency and productivity.
AchiEvements
  • Develop a solution for tracking Expenses by SKU level.
  • Best team of the Quarter.
SHINHAN FINANCE VIETNAM (KOREA)
Data Analysis Supervisor | Nov 2020 - Nov 2022
STRATEGY & PLANNING DEPT (MIS Team) (Jun 2021 - Nov 2022)
  • Proficient in SAS, and SQL.
  • Collaborate with cross-functional teams to analyze requirements and build ad-hoc reports.
  • Conduct in-depth analysis of key operational and performance metrics for products.
  • Develop scorecard models for the Fraud teams.
PRODUCT DEVELOPMENT DEPT (PO) (Nov 2020 - Jun 2021)
  • Play the role of PO for the new product (Installment loan).
  • Conduct market research and planning new product ideas, including interest rates, target customers, and dealerships.
  • Collaborate with IT and other departments to build systems and enhance Core Banking system.
  • Monitor market trends and customer feedback for continuous improvement.
  • Analyze performance metrics to optimize profitability and customer satisfaction.
AchIEvements
  • Develop a customer classification model (reduced 60% workload)
  • Best employee of the month. 
THE MAKER KITCHEN
Data Analyst | Dec 2019 - Nov 2020
  • Develop data infrastructure and generate comprehensive reports for operational analysis, enabling data-driven insights and informed decision-making across the organization.
  • Budget planning and cash flow coordination, driving financial efficiency.
  • Monitor, alert profits and losses, contributing to business growth.
  • Provide data-driven analysis and strategic advice to empower the Board of Directors’ decision-making.
AchIEvements
  • Reduce 70% workload for accountants.