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.