Hoàng Minh Triết

LinkedIN +847******** ad3t20@r.postjobfree.com

Career Objective

A real go-getter and detail-oriented senior, majoring in International Business at Open University, seeks the highest possible opportunities to resolve complex data and provide thoughtful insights through storytelling. With a rock-solid background in data analytics, I’m always in my best self to contribute my knowledge to drive the business’s growth.

Technical Knowledges

MySQL: Data cleaning, Aggregate and window function, Sub-query/CTE, transaction SQL, joins function … PowerBI: Data Model, Data Visualization, Fundamentals Dax Query, Measures Creation, Transform, Diagnostic Analysis.

Python: Scrapy, Requests with BeautifulSoup, and Playwright for web-scrapping, Pandas, Numpy, Regular Expression – ETL, data extracting, transforming, and loading (mysql.connector, sqlachemy), Data visualization through Matplotlib.pyplot (plt) and Seaborn (sns), Fundamentals of object-oriented programming, PyTorch, Sklearn, Machine Learning, Natural Language Processing through preprocessing ‘Transformers’ model of Hugging Face, and features selection for preprocessing – in the progress of Computer Vision with OpenCV for Image Recognition.

Working Experiences

Teaching Assistant British Council April 2022 – July 2023

• Do mostly all administrative tasks with Microsoft Office and SharePoint.

• Support teachers in class by providing on-time reports for students of primary students, providing safeguarding for students during class, pick-up time, and drop-off time.

• Give phone calls for weekly reports and provide word-format-based monthly reports to inform parents about the student’s status throughout the learning week and learning month.

• Visit certifications: Here

Tele Sales Executive Rouen Program May 2023 – Oct 2023

• Give phone calls, introduce, and draw the attention of high school students to the current program.

• Work with the marketing department to resolve data from the Facebook page to consult unique students. Personal Projects / Working experiences

Customer Classification through RFM application Customers 360

• Use SQL query to extract 3 main values at “Last visit day” representing “Rencency”, “Total Access” representing “Frequency”, and “GMV” representing “Monetary”.

• For transactional data, query successfully the accesses day after the first access day

(dense_rank function for the day) to calculate the retention of customers.

• Spot out clearly 493 customers accessing the website without the account information through diagnostic analysis.

• Visit report: Here

Bank Data Analysis

• Differentiate the using pattern among customers groups of ‘Gold’, ‘Silver’, and ‘Regular’

• Apply diagnostic analysis to find relationships among visualizations and come up with better information for selection.

• Visit dashboard: Here

SEO Analytics Uniace Matrixes Analysis

• Apply matrixes and ratios such as total accesses for 1 template open, and conversion rate for purchase for one template open, by using DAX measures to successfully distinguish the cost between the group of users accessing the website with and without emails.

• Use regular expression in Python to extract ‘University Domain’ and ‘Referrer Sources Domain’ from hyperlink.

• Visit dashboard: Here

GContest 2023 – Round 1 – Data Analytics Competiton FTU University

• Build up a complete income statement dashboard with percent change and amount change from 2022 to 2023 fitting with every element in the dashboard.

• Pointing out unproductive operations in the ‘Retail’ section of a business

• Visit dashboard: Here

• Visit report: Here

Sentiment Analysis

• Use the pre-trained machine learning model of ‘Transformer’ library provided by ‘Hugging face’ to analyze the comments of users and then evaluate them according to 3 levels of ‘Neutral’,

‘Negative’, and ‘Positive’.

• Visit code: Here

Pizza-Hut Analysis

• Work solely with Python to apply the RFM models to classify group of customers, tried and applied the training and testing deep-learning model to predict the customers’ RFM segmentation based on the preprocessing training and testing data.

• Resolve the case study of PizzaHut using solely Python to transform and answer questions of the case study.

• Visit code: Here

Online Streaming Movies Analysis

• Work with python to mostly perform ETL process (Work with text files and perform data extracting to have relevant information for key analysis) using mostly Python.

• Effectively point out the 971 users that might leave or quit using the services since the accounts of these users were created but didn’t get to use for any further interactions with the websites.

• Visit code: Here

Web Scrapping For Model Multiclassification Task – In Progress

• Scrapped source: Color Hunt, Color Drop, Coolors, and Unsplash. Currently created the small pipeline to scrapped all the data from the first 3 sources and push the data to the database. For Unsplash source, dealing successfully with the scrapped images and using ColorThief to extract the 10 dominant color codes.

• Preprocessing data with Python to clean up all these sources and extract the color code data and its according rank based on the user preferences for the model (The expected result will be having the model received the color code and the targeted variable ranging from 0 to 3 indicating the likeliness of the color code, if more than 1 color code being input, the score will be averaged).

• Building up the own module and library Python file for code management and code efficiencies.

• Visit code: Here

Volunteer Experiences

Content Creator O.Marketing Club Feb 2022 – Jan 2023

• Be able to use Adobe Photoshop, and Adobe Premiere Pro at efficient levels to perform designed-base tasks of the club during events’ preparation times, mainly in charge of creating, and planning to come up with visualizations from the club’s ideas and using PowerPoint to efficiently present these ideas for approval.

• In charge of daily tasks for creating and designing posters and designs to support the day-to-day operation of the clubs.

• Visit products: Here

Educational Background – Awards

International Business – Rouen program of Open University GPA: 3.66/4.0

Received scholarship for student with outstanding performance in the first year Working as the translator to connect French and Vietnamese students together during all the extracurricular activites at the University August 2021 – Now

Certifications

Microsoft Office Specialist: Word, Powerpoint, Excel Microsoft Certificate Link Python for Data Analytics Datapot Certificate Link Analyzing and Visualizing Data with Microsoft Power BI Datapot Certificate Link Querying Data with Transact-SQL Datapot Certificate Link Microsoft Certified: Azure Data Fundamentals Datapot Certificate Link Languages

Vietnamese: Maternal language

English: IELTS 7.0

French: In progress – A2

Contact this candidate