Data Analytics
Resume:
LE PHUC TUAN
************@*****.***
https://github.com/LePhucTuan
www.linkedin.com/in/lê-phúc-tuấn
Education&Certifications
• Van Hien University – Business Administration Aug 2018 – Aug 2023
• Google Business Intelligence
• Google Advanced Data Analytics
• Google Data Analytics
• Excel Deep Dive: Pivot Tables Workshop by Udemy
Work Experience
People Analytics Intern – Full time Apr 2024 – Present Transcosmos Vietnam Co., Ltd
• Leveraged technologies such as Python, SQL, and Power Query to extract data from diverse sources (Web APIs, databases, Excel files, Google Sheets, etc.), supporting departmental needs and facilitating preliminary data analysis.
• Developed, maintained, and optimized daily, weekly, and monthly reports on employee performance, recruitment costs, employee training, attendance, attrition and more for a workforce of approximately 3,000 employees, ensuring each department gains key insights and highlights that drive informed decision-making.
• Integrated Power Apps, Power Automate, and Power BI to design and build automated data-tracking systems for HR operations and employee historical data, enabling real-time access to essential operational insights across departments.
• Provided critical support to internal departments such as TA, L&D, C&B, and Operations by consolidating and analyzing data, recommending efficient data system solutions to enhance productivity and reduce workload.
• Managed HR systems including Base, People Life Cycle Management (PLCM), and Learning Management System
(LMS), Employee Biometric Time and Attendance System to ensure smooth onboarding and offboarding processes, configure systems per request, and provide timely user support across various HR functions Business Support – Part time Mar 2023 – Mar 2024
Van Phat Construction Materials Limited Liability Company
• Entered and checked data from records, invoices, and documents related to the company's business activities.
• Managed, classified, and stored company data sets according to criteria such as category, customers, products
• Supported processing, updating, and tracking input data for analysis and reporting. Market Development Staff/Sales Staff – Full time Feb 2022 – Jul 2022 Le Khac Construction, Trading and Production Joint Stock Company
• Assuming the lead role for a team of three in the research and development market team for construction products, analyzed market trends and developed strategies.
• Compiled, organized, and maintained a Excel record of approximately 1000 new agencies and existing customers. Regularly updated and refined an inventory of around 150 products.
• Provided weekly reports on new customer acquisitions, sales performance, and product inventory using the Base application platform. As a result, successfully expanded the network by onboarding 48 new agencies in just 5 months. Featured Frojects (more detail at here)
Sales Analysis with using Power BI
• Designed and implemented interactive Power BI dashboards for comprehensive analysis of product performance, business results, and customer information over the previous 3 years.
• Utilized global sales data to visualize dynamic core business KPIs, saving time on manual reporting tasks. Provided valuable insights on revenue variations, best-selling products and customer data through diagrammatic dashboards and visual images to help businesses evaluate sales strategies effectively. TikTok User Engagement Analysis with using Python
• Conducted deep exploratory data analysis (EDA) to evaluate user engagement metrics and video claim status, identifying significant correlations.
• From there, it was used as a basis to develop a machine learning model to distinguish between statements of fact and opinions in videos, allowing TikTok to streamline the handling of user reports and increase priority to operate more efficiently.
ETL Global Sales with using SSIS
• Designed a Data Warehouse using the star schema model. Implemented ETL processes to extract, transform, and load data from Excel files containing over 50,000 records.
• Utilized SSIS tools to convert the data into the Data Warehouse, incorporating key functions like derived column creation, aggregation, sorting, script compilation and lookup operations. Ensured the accurate transfer of data to the Data Warehouse for optimal reliability and performance. Skills
Languages: Python (Numpy, Pandas), SQL (MySQL, SQL Sever) Visualization: Power BI, Python (Matplotlib, Seaborn) Others: Excel, Power Automate, Power Apps, Spreedsheet, Visual Studio Code, SSIS, …
Contact this candidate