Phan Thanh Ngọc (Megan) 🚀 Senior Data Analyst • 4 years of experience in Data Analytics, specializing in Banking and E-commerce.
📄 Export PDF
🛠️ Core Skills Data Modeling
Data Visualization
Programing
Others
🛠️ Soft Skills • Fast learner
💼 Work Experience FE CREDIT Product Performance Expert Analyst | Nov 2024 to Now
Aspect Details Responsibilities Build and enhance report to track Product Sale performance, Product Profit and Loss performance, Customer Segmentation Monitor and control performance of products, campaign and projects by monthly basis Review and analyze the product’s activities and trends (sales, risk, cost and profit performance) and report the findings to identify the strategies that will address company goals Prepare ad-hoc analysis & material for BOD monthly review meeting Calculate commission to dealers Achievements and Skills Gained Automate Commission Calculation for Dealear Generate reports for Flexible CTD program Technologies
CAPGEMINI (Short-term Project) Data Consultant | Aug 2024 - Nov 2024
Aspect Details Project Data Migration Project for HSBC Life Singapore. Responsibilities Define data migration goals, including data transformation and cleansing needs Work with stakeholders to gather and record requirements for new system. Design and implement data transformation logic to ensure data compatibility with new system Achievements Technologies
CODER SCHOOL Data Analysis Mentor | Feb 2024 - Now
Aspect Details Project Mentor and support aspiring data analysts in their learning journey Responsibilities Develop and enhance the data analysis curriculum, creating engaging lesson plans and projects with SQL, PBI and Python Conduct interactive classes, workshops, and coding exercises to teach key data analysis concepts and practical skills Review student projects, provide constructive feedback, and evaluate their code and data analysis techniques Achievements Technologies
YES4ALL Senior Data Analyst | Dec 2022 – Jul 2023
Aspect Details Project Developed report for tracking P&L by SKU Responsibilities 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, Function) Collaborate with cross-functional teams to construct a comprehensive ERP database, data integration Proficient in analyzing requirements, documenting BRD, and ensuring alignment with stakeholders Proficient in building and maintaining Power BI Conduct data mining and analysis to generate valuable business insights. Achievements and Skills Gained Develop a solution for tracking P&L by SKU level Best team of the Quarter. Technologies
SHINHAN FINANCE VIETNAM Data Analysis Supervisor | Nov 2020 - Sep 20222
Aspect Details PRODUCT DEVELOPMENT TEAM Play role as Product Owner to design and go-live Sales Finance New Product from scratch Responsibilities Conduct market research and plan new product ideas Collaborate with cross-functional teams to build systems and enhance Core Banking system Monitor market trends & analyze performance metrics to optimize profitability and customer satisfaction MIS TEAM Design & build report for all department in company Responsibilities Proficient in SAS, and SQL Collaborate with cross-functional teams to analyze requirements Conduct in-depth analysis of key performance metrics Develop data science models Achievements and Skills Gained Develop a customer classification (reduced 60% workload) Best employee of the month Technologies SQL SAS PIVOT TABLE ML MODEL
NEWTECONS General Accountant | Apr 2017 - Mar 2020
Aspect Details Responsibilities Estimate, manage cost, and revenue of construction projects (the scale for each project was over 20 million USD) Collect raw data from other departments and making reports to evaluate the performance of Administrative Expenses Prepare, declare TAX report, and directly worked with the Department of Taxation Multi-task related to AR, AP, Bank, Fix assets. Achievements and Skills Gained Best employee of the month
SINOKOR MERCHANT MARINE General Accountant | Apr 2014 - Mar 2017
Aspect Details Responsibilities Follow the company's key account (revenue and cost) Track revenue, cost, and liabilities Directly work with the Head Office to report the efficiency of cash flow, performance, revenue, and expenses of the Vietnam Branch Prepare, declare TAX report, and directly work with the Department of Taxation. Achievements and Skills Gained Find VND 500 mil of missing collected invoice Clearance tax issue Best contributor of the month
🎓 Certificates & Education Certificate/Education Institution Year Details Bachelor Degree of Finance UEH University 2014 GPA: 7.9 TOEIC Certificate IIG Vietnam 2013 835/990 HSK 4 HanBan Chinese 2023 275/300 Data Scientist Certificate University of Science HCMC 2024 Good