I have more than six-years of experience in the finance analytics and data analytics field. My main domain focuses on banking, financial industries (fund management, payment services). I can work with various data analytics technology tools in both the Data platform and BI platform. I build up myself with not only the technical skills but also a strong business mindset and analytical thinking skill where I can fit very well with any data analytics opportunities.

• Programming Languages: PowerBI, Excel Power Pivot, Google Data Studio, Tableau 

• Data Processing: SQL, Python, VBA 

• Cloud Platform: Google Cloud Platform, Azure, AWS 

Digital e-wallet Payment – Data and BI Platform - Singapore

Senior Data Analytics Consultant, April 2022 – Present

Project description 

• Automation reporting process with Python 

• PowerBI dashboards top management 

• Ad Hoc data analytics use cases 

• Migrate data from existing data warehouse to the Datalake 

• Migrate existing Tableau Dashboards to PowerBI 

Responsibilities 

• Work directly with various business functions to understand the project’s requirements and document project Functional Specification Documentation (FSD) 

• Build python job for automatic excel reporting 

• Work directly with Company’s Director Develop PowerBI dashboards for analytical purposes and build analytic papers for adhoc cases 

• Migrating Tableau analytic dashboards to PowerBI 

• Conduct data analysis process for data migration from MySQL to new Data lake 

• Lead the BI team to deliver the project timely and with high quality 

Technologies 

• Data lake: AWS S3 

• Data warehouse: MySQL 

• Visualization and Analytics: PowerBI, Tableau 

‍

Fund Management – Data and BI Platform - Singapore

Senior BI consultant, April 2021 – April 2022

Project description 

• End-to-end process of migrating data sources centralized in 1 single data platform and used for management reporting purposes 

• PowerBI dashboards for finance and investment management 

• Cashflow approval automation process using Power automate 

Responsibilities 

• Work directly with Company’s Director Level to understand the project’s requirements and document project Functional Specification Documentation (FSD): Data Element, Source-Target mapping, metrics calculation rules 

• Build stored procedure for data transformation in Data warehouse and Data mart layers 

• Develop PowerBI dashboards for top management  

• End-to-end process of migrating data sources centralized in 1 single data platform and used for management reporting purposes 

• Lead the BI team to deliver the project timely and with high quality 

  Technologies 

• Data lake: Azure Blob Storage, Data Lake G2 

• Data warehouse: Azure SQL 

• Data transformation: Databricks 

• Visualization and Analytics: PowerBI 

‍

Large Retail Chains - VietNam

Senior Data Analytics in-house, Aug 2019 – April 2021

Project description 

• Business Intelligence and Data Analytics 

• Review daily business performance from PowerBI reports and come up with any key 
    highlights for businesses 

• Using analytics to provide insights for businesses: Correlation, Regression analysis Ex: Evaluate impacts from types of marketing expenses and discount expenses in boosting the Gross Revenue (GMV)  

• End-to-end BI Report Developer

• Write SQL code to connect Data from Data Warehouse (Google BigQuery) into visualization tools (capable of writing complex coding to handle business metrics and issues) 

• Develop visualization for Management Reports using Power BI and Google Data Studio 

• Develop dashboard to monitor data pipeline from data lake to data marts 

Technologies 

• Data lake: Google Cloud Storage 

• Data warehouse: Google BigQuery 

• Data transformation: SQL procedures 

• Visualization and Analytics: PowerBI, Google Data Studio 

‍

Banking – VietNam 

Business Finance Analyst in-house, April 2016 – Aug 2019 

Project description 

• Finance/ MIS Reporting and Risk Analysis: 

• Daily, weekly, monthly performance tracking in terms of financial results/ indicators of Wholesale banking products: Lending (Loans & Bonds), Deposit (TD, Casa), NFI (LC, Bank Guarantee), NFX, ...and Risk Management/ Risk Analytics reporting: Risk Weight (RWA), EL, PD, LGD (Analyze the risk measurement result and the key drivers – under Basel II/ Circular 41 logics) 

• Set up reporting forms per request from business: write SQL code to generate the needed data and automatically link to the excel template forms 

• Build up database, financial dashboard combining actual result and forecasting data for Asset Liabilities Management, RWA (under Return on RWA tracking) and Performance Management 

• Conduct periodic and ad-hoc analysis then propose action plans to support the business in decision making progress to improve the performance 

• Strategic projects: 

• Join in Wholesale Banking Group Strategic project to: 

• Quantify the market revenue pool by using financial statements, key indicators and assumptions, from which finding out the potential market for business to focus on. 

• Build up the financial model for Wholesale Banking based on key drivers: market shares, growth rate, … 

• Involved in strategic project to improve CASA balance and NFI, NFX by conducting analysis on 

• current customer portfolio then propose action plans, solutions properly and effectively. 

• Work stream leader/ training manager: 

• Build up timeline/ key milestones planning for major work streams of the team: Budgeting, Data Centralization, Reporting Automation, Power BI Visualization, etc. 

• Assign/ Guide/ Train team member to get the tasks done within the timeline planned/required Technologies 

  Technologies: 

• Data warehouse: SQL Server 

• Data transformation: SQL procedures, VBA 

• Visualization and Analytics: PowerBI, Excel Power Pivot 

Passed CFA (Chartered Financial Analyst) Level 2, CFA Institute 

Awards:

• Staff of the year 2019 
• National mathematic competition award