Preview Resume

2024

Business Type : Consulting

Last Position : Excel Automation Specialist

Period : August 2024  to August 2025

Job Description :

- Developed dashboards to analyze Call Center performance, covering Answered, Abandoned, and Agent On Queue statuses with hourly and daily views.
- Designed and implemented dashboards and Survey On Sport tools to assess and evaluate service quality provided by agents after customer interactions.
- Improved Routine (Daily/Monthly) reporting processes using VBA Excel for enhanced speed and accuracy, reducing processing time and optimizing code for low-performance computers, with precise Prompt-based code generation and effective optimization techniques.
- Designed and developed automated programs using Excel VBA (VIBE Code) for Monthly Report generation, enabling handling of large datasets (up to 100,000 records) and filtering for target customers, reducing report creation time from 1015 minutes per individual report to under 50 minutes for all combined.
- Created and enhanced VIBE Code for Web Scraping via Chrome Extension to extract data from Web Apps, utilizing basic knowledge of HTML tags and Web UI libraries, processing data with JavaScript, and exporting results into ready-to-use CSV format.

2011

Last Position : Insurance Professional Training and Development Officer

Period : August 2011  to February 2024

Job Description :

- Managed and supervised online classroom live streaming, ensuring signal quality and broadcast reliability.
- Handled trainee data management from start to finish, including Data Cleansing and result reporting.
- Designed automated notification and data management systems to streamline workflows.
- Coordinated and managed Digital Data for online training, covering both data collection and distribution.
- Produced training and live streaming media using Adobe Photoshop, Illustrator, Premiere Pro, After Effects, and Vmix.
- Developed and improved IT processes (IT Process Improvement), including Automation Development, Google Apps Script (Web Development), and Microsoft Excel VBA.
- Designed and implemented solutions to reduce work processes, such as email verification systems, exam result tracking systems, training history verification systems, document download systems, and evaluation form systems.
- Provided consultation and designed training processes for obtaining non-life insurance agent licenses.