Business unit: Deals Analytics team in Advisory ServicesMain responsibilities: + Design, implement, and maintain cloud data warehousing architecture using Microsoft tech stack (Azure Data Factory, SQL Server, Analysis Services, Power BI)+ Build and maintain web apps written in Google Apps Script (HTML, CSS, Javascript). Apps include a WFH booking system, seat reservation system, financial statements management system+ Develop and maintain Python scripts. Scripts include a financial statements excel to csv reader, a script to convert pdf/images to excel using Azure Document Intelligence API, scripts to scrape websites for information

Pharmacity, as of Aug 2023, is one of the top pharmacy retailers in Vietnam with over 900 stores nationwide, 14 million customers, and 3 million monthly transactions.Main responsibilities:+ ETL/ELT: extract data from a wide variety of sources (Google BigQuery, MySQL, PostgreSQL, MongoDB,…) and ingest them into data warehouses using Microsoft tech stack (Azure Data Factory, SQL Server), maintain and optimize these data pipelines as needed+ Manage data warehouses (MS SQL Server): optimize/write queries and stored procedures, add tables/columns as reasonably requested by front-end users, data partitioning, maintenance of indexes+ Manage tabular data models (Microsoft Analysis Services): add tables/columns/measures per business demand, data partitioning, incremental load+ Push and pull data where needed: push/pull data with partner companies/projects such as Relex, Salesforce, Nielsen, IQVIA; ensure data are correct, on time, and of high quality+ Maintain internal-facing APIs written in Python using FastAPI

Main responsibilities:+ ETL: extract data from a wide variety of sources and ingest them into data warehouses using Microsoft tech stack (Azure Data Factory, SQL Server), maintain and improve these data pipelines as needed+ Train and equip new employees on the skills and knowledge needed+ Manage tabular models in Microsoft Analysis Services+ Build Microsoft Power BI dashboards and embed them into internal reporting website+ Hobby projects: build a Telegram bot with underlying Python script to scrape Google News and Yahoo News; write VBA macro to efficiently allocate goods among stores

Main responsibilities:- Extract data from Microsoft Power BI and compose weekly reports using Excel- Write Python script to scrape competitor websites for product prices- Develop VBA macros to solve problems where needed

Experiences gained:- Develop VBA macros to automate repetitive processes on SAP ERP Software- Raise tickets to pay for vendor invoices on MBV’s payment authorization system- Draw processes with Microsoft Visio