** Project: Electronics Retails Data Platform• Implement Python, Pyspark, SQL scripts to ETL data, create Delta Live tables in Databricks. • Build data pipeline with Azure Data Factory to transform data raw then ingest to data warehouse.• Implement analysis dashboards for Sales team using Power BI.• Get to understand with data from Power BI log data, SAP systems, Salesforce CRM• Technologies: Python, SQL, PySpark. Azure Platform: Azure Data Factory, Databricks, Power… Show more ** Project: Electronics Retails Data Platform• Implement Python, Pyspark, SQL scripts to ETL data, create Delta Live tables in Databricks. • Build data pipeline with Azure Data Factory to transform data raw then ingest to data warehouse.• Implement analysis dashboards for Sales team using Power BI.• Get to understand with data from Power BI log data, SAP systems, Salesforce CRM• Technologies: Python, SQL, PySpark. Azure Platform: Azure Data Factory, Databricks, Power BI.** Project data migration Azure to AWS- Migrate data pipelines/ notebooks from Azure Synapse to AWS EMR (notebook/python script) + Step Function- Get familiar with AWS S3, Secrets Manager, RDS SQL Server, Lambda function, (and Glue ETL)- Using python (Pyspark), SQL (Stored Procedure)** Project credit info (banking domain)- Build script with Pyspark in Zeppelin notebook to read parquet files from Minio, transform and write data into Postgres DB- Design Star Schema DWH, and datamart as required for further analytics purposes- Custom query and build dashboard with Superset** Project Oil & Gas domain- Building ETL data pipeline Python/SQL with Azure Data Factory, Azure Blob Storage, Azure Function, Azure PostgreSQL- Design and build Star schema model for analytics data warehouse- Engage with energy asset management domain experts, analyze requirement to build system reports and dashboards with Superset- Build automate Python tool to generate metadata for asset management system from excel manual source data.- Build automate Python script to work with system API to upload data and files from customer.- Get basic knowledge of ETL tool: Talend, Snowflake** Project Insurance domain- Custom query in T-SQL using SSMS, build data models by Tabular Studio- Analyze requirements and apply business logics to build reports/ dashboards by Power BI for Sales/Operations team.- Basic knowledge of ETL process by Informatica. Show less

** Project data migration Azure to GCP• Migrate Data, Store Procedure, Azure notebooks, Azure data pipelines from Azure Synapse to Google Cloud.• Keep track of correct logic for Store Procedure, notebooks and pipelines • Write scripts to validate data between Azure and GCP to make sure data align between two Cloud Services.• Technologies: Python, SQL, PySpark. Google Cloud Platform: Dataproc, Google Cloud Function, Google Cloud Composer (Airflow), BigQuery, Dataflow.

- Involve in Data model/Datamart design, custom data from staging tables to Dimension and Fact tables.- Optimize custom data process by Python/BigQuery, saving 20% monthly effort.- Preprocess data for reports and ad-hoc by Big Query, mainly support for Dept of Finance/ Fulfillment/ Customer Services (CS)/ Customer Experience (CX).- Develop metrics and KPI for analyzing performance of Operations/ Finance and detect operational trends for actionable insights.- Implement Cohort… Show more - Involve in Data model/Datamart design, custom data from staging tables to Dimension and Fact tables.- Optimize custom data process by Python/BigQuery, saving 20% monthly effort.- Preprocess data for reports and ad-hoc by Big Query, mainly support for Dept of Finance/ Fulfillment/ Customer Services (CS)/ Customer Experience (CX).- Develop metrics and KPI for analyzing performance of Operations/ Finance and detect operational trends for actionable insights.- Implement Cohort analysis, customer analysis; develop metrics for CS/CX team to analyze customer behavior and recommend for Marketing team.- Visualize metrics, data details and design user-friendly dashboards for Finance/ Fulfillment/ CS/ CX team by Google Data Studio.- Identify trends and forecast future sorting volumes for sorting warehouse and air volumes using Arima model, code by Python, with accuracy 85%. Show less

o Manage process: materials importing, garment production and garment exportingo Make Purchase Order for materials: fabric, accessories,..o Responsible for garment samples of production stage

o Manage inventory, vessel slotso Handle shipping documents and update status of export shipments.o Work with vessel operators, agents to solve arising issues

Main responsibilities:- Work with customer to prepare & declare documents for inbound and outbound customsclearance.- Send daily reports to customers (if request).- Understand customers’ business features, update new regulation fromcustoms/government.- Be responsible for special request of Customs such as getting certificate of culture, quality.