Data Consultant - Data Engineer

Just Analytics by Rackspace - Rackspace Technology

(*) Global port management company headquartered in Philippines:
- Designed and proposed solution for data platform, using change data capture pattern (CDC)
- Designed and implemented data pipelines from changelog data capture to source image tables to foundation
- Integrated to third party applications/APIs using data from foundation data lake
- Prepared operation analytics (container workload and related events), sales analytics (volume, revenue, yield) dashboards for business users
- Built Rest APIs for downstream usages in frontend applications, APIs include container, vessel visit, truck visit, container events, vessel events, truck events.
- Built notification push for frontend apps using structured streaming
- Technology: Python, SQL, Java, Spring boot, Eventhub, Databricks, Azure Data Factory, Apache Spark, Spark Structured Streaming, Azure Blob Storage, Cosmos DB, Power BI, API Management Service, Event Grid

(*) Vietnamese FMCG company:
- Designed and implemented data pipelines for sales department to track main sales KPIs, planning department to analyze target sales each month and supply chain department to track sale orders daily
- Delivered unit tests, system integration tests and support user acceptance tests for deployment purpose
- Built framework for archiving files to meet data retention policy using Azure Function
- Technology: Python, SQL, Azure Data Factory, Azure Synapse, SQL Server, Azure Blob Storage, Analysis Services, Power BI, Azure Function

(*) Singaporean telecommunications company:
- Designed and implemented batch and stream pipelines to track logging data of customers
- Delivered test cases, supported customer in deployment, consulted for further scaling issues
- Technology: Python, Scala, SQL, Spark, Azure Data Factory, Azure Databricks, Azure Blob Storage, Event Hubs, Snowflakes

(*) Singaporean hospitality company:
- Designed and implemented data pipelines for CRM department to support sales forecast and open opportunities
- Prepared unit tests, system integration tests and support user acceptance tests
- Technology: Python, SQL, Spark, Guzzle (data engineering workbench of Just Analytics), Azure Databricks, Azure Data Factory, Analysis Services, SQL Server, Azure Synapse, Power BI

Backend Software Engineer

Sentifi

- In charge of risk score project: developed sentiment risk score using heuristic methods - Python
- Company, market and portfolio modules projects: built Restful APIs - Java, Spring Framework, Hibernate
- API open SDK project: built main parts of open APIs for clients - Python, Restful API
- Worker project: built workers to accumulate and compress data for topics and events - Java, Apache Quartz
- Quality assurance project: performed acceptance tests, unit tests for various projects APIs - Python, Postman
- API documentation project: built technical documents for both internal and external uses - Swagger
- Data extraction project: built Elasticsearch, Google Bigtable, SQL interfaces to manipulate data - Python

Assurance Associate

Ernst & Young

- Performed risk-based audit procedures in financial statements of several financial institutions, including 02 Vietnamese Commercial Banks, 01 State-owned Bank, 02 Securities Companies, 01 Finance Leasing Company, 01 Finance Company, 01 Fund Management Company
- Performed analytical reviews, variance analysis on financial statements; prepare drafts for financials statements, usable reports, internal control reports.