I have 9+ years of experience in the IT industry and 7+ years of working in the Data Analytics field. I am an Innovation-oriented, open, responsible, problem-solving Data Consultant with good leadership skills. I love to work with number, data, and logic equations by using various Data Analytics platforms. I would be well fit with the career path requiring data-driven, analytical and logical thinking, resource management and planning ability.

• Databases: MS SQL Server, Oracle, IBM Netezza, IBM DB2, MariaDB, Postgres SQL, MongoDB 

• BI and Reporting: PowerBI, Tableau, R Studio, SSRS 

• Data Processing: SQL, Python, R, Pyspar, Airflow 

• Cloud Platform: Azure, Databricks, AWS 

Manufacturing Data Platform – US 

Data Team Leader, Aug 2023 – Present

Project description 

• Automate Data Validation process 

• Migrate data from on-prem Oracle Data Warehouse to the Azure Data Lake 

Responsibilities 

• Develop, migrate and tune successfully 50+ functions, procedures, triggers, tables, views from existing on-prem DWH (Oracle) to a new Data Lake (Azure) 

• Lead Data team and manage tasks to design and build 30+ notebooks and jobs to perform Data Validation between Oracle source system and Azure Databricks target system  

• Define KT Plan and create documents to on board the solution 

Technologies 

• Azure SQL, Tableau, Looker, SQL, Python, R, Power BI 

Data and BI Platform – Singapore 

Data Consultant, Aug 2022 – Aug 2023

Project description 

• Build end-to-end Datalake from scratch 

• Build end-to-end Power BI reporting and dashboard platform from scratch 

Responsibilities

• Worked directly with Business users to understand the project’s requirements (Data Sources, Data mapping, metrics calculation rules) 

• Defined KPIs, built data models, and developed 20+ Reports and Dashboards to provide insights for product analytics. 

• Designed and developed 30+ Data batch and streaming pipelines to automate data integration process and build Azure Datalake on Databricks Delta Lake multihop architecture 

• Built 3+ Data science models using Fuzzy Logic in Databricks to detect similarity and predict the best course of CAPA actions for the non-conformances

Technologies 

• SparkSQL, PySpark, Databricks, Power BI, Azure Data Factory, Azure Synapse Analytics, Scikit-learn, Azure AI Form Recognizer, Azure Logic Apps.

‍

E-Commerce Data Platform – Ireland 

Data Analyst, Jan 2022 – Aug 2022

Project description 

• An E-Commerce Data Platform collects and stores data from online sales, customers, and marketing activities. It helps businesses understand customer behaviour and track sales performance. This platform supports better decision-making and enables personalized shopping experiences.

Responsibilities

• Defined new KPIs and developed 10+ Reports and Workbooks to automate 50% Time series data quality and Price & Inventory Monitoring activities. 

• Decreased database server response time by 30% by restructuring SQL queries. 

• Built dashboards to provide a holistic view of review analysis and content compliance

Technologies

• Azure SQL, Tableau, Looker, SQL, Python, R, Power BI

‍

Financial Data Warehouse – US 

Sub Lead Data Engineer, Aug 2019 – Aug 2021

Responsibilities

• Coordinated with Project Manager to plan 5 projects and manage a cross-functional team of 10 (Dev, BA, QA). 

• Built 20+ ETL Jobs to integrate data files into Azure DWH (500+ tables, 10TB+ data)  

• Developed and migrated successfully 30+ reports from the old BI Platform system to the new one with full-stack responsibility. 

• Tuned 50+ SQL packages, functions, and procedures to reduce the latency of database processing time by 30%. 

• Produced 50+ confluence documents for knowledge transfer and got referenced by other teams.

Technologies

• Azure Cloud services, Azure Data Factory, T-SQL, Python, SSIS, Unix, Oracle, Java, IBM Cognos MS SQL, C#, HTML, JavaScript, SSRS, Power BI 

‍

Banking Data Warehouse – VietNam (Banking Clients) 

Lead Data Team, Jun 2018 – Aug 2019

Responsibilities

• Led 2 Agile-Scrum projects and managed a cross-functional BI team of 15 (Dev, BA) to design data model, develop ETL Jobs and build DWH (20+ sources, 2000+ tables, 50TB+ data)  

• Improved banking report performance by 30% by optimizing SQL packages, triggers and procedures. 

• Documented 50+ confluence pages for knowledge transfer and training plans, which helped 30+ team members enhance their knowledge in SQL and DWH

Technologies

• PL/SQL, T-SQL, IBM DataStage, Oracle DB, MS SQL, SSIS, Unix, Python. 

‍

BI Platform – Singapore 

BI Developer, Jan 2018 – Jun 2018

Responsibilities

• Developed 20+ reports to provide product insights  

• Reduced database server response time by 20% by restructuring SQL functions and procedures. 

• Created documents to support the monitoring team to keep track of report performance and extract data. 

Technologies

• PL/SQL, SAP Crystal Report, Unix, and Control-M

‍

ERP Reporting Platform – Singapore 

Reporting Analyst, Nov 2016 – Jan 2018

Responsibilities

• Designed and created 150+ ERP reports using SQL and Jasper iReport. 

• Deployed 20+ new features for Reporting module in ERP platform using Java and SQL. 

• Produced confluence documents and guided 10+ enterprise clients using Jasper Studio to create custom reports. plans, which helped 30+ team members enhance their knowledge in SQL and DWH. 

Technologies

• SQL, Jasper iReport, Java, Jasper Studio  ‍

Network and System Management – Cambodia 

Lead System Engineer, March 2020 – July 2020

Responsibilities

• Led a team of 5 level-2 networking and system engineers to operate, monitor and troubleshoot Network and Server systems in use by 5000+ Fiber subscribers over 6 branches in Cambodia. 

• Designed a training plan and created documents to train 50+ staffs from customer support and deployment teams. 

Microsoft Azure Fundamentals (AZ-900) 

Microsoft Azure Data Engineer Associate (DP-203) 

Microsoft Azure Data Analyst Associate (PL-300) 

AWS Data Analytics Specialty 

AWS Machine Learning Specialty 

Databricks Lakehouse Fundamentals 

Databricks Data Analyst Associate 

Databricks Data Engineer Associate 

Databricks Data Engineer Professional 

Azure Databricks Platform Architect