Data Engineer with expertise in ETL and BI tools | Nam | 1997 | Nam Tu Liem – Hà Nội
Giới thiệu về ứng viên
Data Engineer, ETL, SQL Server, AWS, PowerBI, Data Processing, Dashboard Management, Data Modeling, BigQuery, CRM, Data Analytics …
● Kinh Nghiệm:
○ NMS
• Collect data, build pipelines from Honda Vietnam’s data storage sources such as CRM, Salesforce, SAP, CDP-Treasure Data, AWS
• Build data processing environments to improve data automatic dashboard charts by Tableau or PowerBI
• Build ERD to find relationships and optimize data models for customer data platform systems (CDP)
• Managed dashboards, financial reports, Ad-hoc, and forecasts
○ Viettel Aerospace Institute
• ETL data from software and electronic, embedded devices in the factory
• Managed production data systems with SQL Server, SSIS, SQL Agent, and ERP tracking manufactured process
• Managed dashboards and periodically reported to superiors or users, issued warnings and timely monitoring for assembly lines
● DỰ ÁN
○ ETL for car customer data for mobile app development
• Build a pipeline that migrates data from AWS, mapping with web-scraped and available data
• Technology used: AWS, Python, Airflow, SQL Server, Excel
○ Calculate, optimize, and build Ad-hoc for active customers’ data
• On-premise pipeline for migrating data from Data warehouse (Oracle DB) to Data Mart (SQL Server DB)
• Technology used: PL/SQL, SQL Server, SSIS, SQL Agent
○ Build pipeline for RFM customer segmentation analytics for marketing strategy
• Get data from BigQuery, load, and transform to datamart, and run procedures in SQL Server
• Technology used: BigQuery, Airflow, SQL Server
● KỸ NĂNG
○ Database: SQL Server, Oracle, MySQL
○ ETL: SQL Agent job, Airflow, SSIS, Power Query
○ Environment: on-premise, AWS, GCP (BigQuery)
○ BI tools: PowerBI
○ English: Upper-intermediate in 4 skills
● THÔNG TIN CÁ NHÂN
○ Ngày sinh: 13/08/1997
○ Giới tính: Nam
