Vsztxhhujkbbvlqfqsmy

徐紹恩/Hsu Shaoen

.Accounting experience using VBA to fasten deposit and withdrawal funds for reconciliation
.Problem-solving person
.Adaptability 
.Business-related majors
.Related working experience with proven and traceable VBA achievements to solve practical issues

IELTS 6.0 Overall GPA: 4.0/4.0 TOEIC 835/S130/W150

[email protected]+886-900645074

Work experience

台灣 星聖資訊服務|財會專員 |2020 ~ 在職中
協助內部使用科技解決財會實務問題,如:
1. 已完成專案:
  • 出納出入金VBA審核程式(單日最多可高達500-10000筆出入金資料),可以簡化工作流程,至少省去每人每日1-3小時的時間。借助VBA已能達成約20%的工作量能半自動化。
  • 新人VBA使用概念教學。後續需與東南亞及各地區財務及客服人員對接處理各種問題。
2. 目前專案: 設計AppSheet,讓會計帳目連動手機App可以減少更多人工程序以及資料出錯的問題。
3. 預計專案: 運用Python及API技術,達成線上資料整合,能更即時、快速的處理資料。
List of the project I create:

1. Success project:
  • Simplify the process of cashier's work, save at least 1 hour per day per person, and same as the other duties like accounting reconciliation work.
  • VBA concept training for new colleagues and solve funding problems together with other teams from all countries.
2. Current: Working on AppSheet software which could reduce data double-entry errors in accounting work.
3. Future: Researching Python and API to retrieve data quickly from the Payment service provider(PSP).

會計事務處理:
1. 每日應付,應收帳款帳務處理 會計核算和監督,保證會計帳務即時處理,會計科目運用准確,會計核算信息真實完整。
2. 對原始憑證的合法性、金額的正確性和手續的完備性等進行審核,對銀行結算票據的印鑑、日期和背書内容是否正確進行審核。
3. 錄入(编制)記帳憑證,負責會計憑證匯總、帳簿登記,打印輸出記帳憑證和帳簿。
4. 繳交營業稅,綜所稅文件

Accounting:
1. Tracked and recorded expenses and reconciled accounts to maintain accurate, current, and compliant financial records.
2. Process journal entries and perform accounting corrections to ensure accurate records.
3. Manage accounting activities to ensure compliance with accounting principles, policies, and external audits.


新加坡 SATS Ltd. |客服代理|2019 ~ 2019 

代理各地的航空公司客戶服務人員於新加坡樟宜機場第四航廈
1. 加速起飛取票流程效率及效能,每日將近1000位旅客,超過3班航班,並處理客訴問題
2. 維護航空安全,並提供特殊旅客服務,包括行動不便者、肢體殘障者及帶嬰兒的媽媽...等

An agent of airlines company at Singapore Changi airport terminal 4
1. Handling nearly 1000 passengers from the checking-in process, customer complaints, and greeting passengers upon onboard and arrival over 3 flights per day. 
2. Maintain aviation safety and provide service for passengers who require special assistance. This includes passengers with reduced mobility, handicapped passengers, a mother with an infant, etc.


澳洲 GBR Helicopter|直升機地勤及中文口譯|2018 ~ 2018
任職首日便成功賣出豪華行程,價值$500澳幣,當天該趟直升機旅程發生機械問題,需通時與日本同事溝通並電話中同步處理客戶信用卡退款等帳務問題
1. 於總部販售旅客大堡礁觀光飛行行程
2. 客戶服務:報到手續、座位安排、行李處理、飛行安全解說
3. 於海上停機坪或陸地機坪管制區內進行機艙整理、客戶登機引導管控
4. 中文口譯

During my time as a ground crew at GBR Helicopter, I made a successful trading deal on the first day of my job- a deal with the value of approximately 500 Australian dollars; not only so, I helped establish effective communications between the customer and my Japanese colleagues, where teamwork was vital to the success of the company.
1. Great Barrier Reef scenic flight tour selling at headquarter
2. Customer services such as check-in, seat arrangement, baggage handled and flight safety briefing
3. Managed and checked pre- and post-flight cabin, boarding and unloading service at ground and sea helipad 4. Mandarin interpreter


澳洲 The Cultural Centre Pty. Ltd.|會議經理|2017 ~ 2017

藉由我們舉辦這場家庭和教育意義的展覽活動,來幫助白血病患者與我們的合作夥伴白血病基金會共同募款
1. 直效行銷,電話陌生拜訪,創意策略發想,如:尋找Youtuber
2. 貴賓接待、現場攤商協調及會議進行協助
3. 事前活動場勘、事前攤商合作套裝推廣

Work with our partner, the Leukemia Foundation, to help leukemia patients by fundraising in our family and educational exhibition.
1. Direct marketing, cold telemarketing, and innovation creative strategies like YouTuber collaboration plan
2. Receptionist, vendor coordination, and on-site event operation
3. Exhibition area pre-inspection and managed vendor collaboration package promotion

台灣 中國醫藥大學|PBL專案管理執行|2011 ~ 2012

作為PBL領導教授團隊、老師、醫學系及學生...等多方溝通橋樑,以提升教學作業流程,加強教學品質。
1. 招募Tutor教師、相關費用報帳核銷
2. 整體專案執行,超過40份P.B.L教案管理如: 從整合各方意見到教案編審以及印刷出版、系網資訊管理。
3. 負責教務及學務相關資料蒐集,建立資料庫並維護。

Implementation of Problem-Based-Learning (P.B.L.) project management and relevant programs, act as a communication bridge among P.B.L. stakeholders (leader group, tutors) to systematized standard admin procedure and academic qualities.
1. Tutor recruiting, payment applies and write-off, coordinate tutor conferences.
2. Handling over 40 cases of P.B.L. project to produce a comprehensive final case textbook for students.
3. Creating and maintaining databases such as questionnaires from students.

Education

Google Data Analytics Professional Certificate, 

Google on Coursera|2021 ~ 2021
  • Ask Questions to Make Data-Driven Decisions(Excel)
  • Foundations: Data, Data, Everywhere(Excel)
  • Prepare Data for Exploration(SQL)
  • Process Data from Dirty to Clean(SQL)
  • Analyze Data to Answer Questions(SQL)
  • Share Data Through the Art of Visualization(Tableau)
  • Data Analysis with R Programming(R語言-學習中)

Department of Leisure and Recreation Business Management

National Taichung University of Science and Technology|B.B.A. Overall GPA: 4.0/4.0|2010 ~ 2012

國立台中科技大學/休閒事業經營系/商學學士/2010~2012

Department of International tradeNational Taipei University of Business|A.B.A.|2005 ~ 2010

96-97, Instrument cadre of international trade & international trade cadre of the student association

94-97, Cadre of classical guitar society, carry out the final school exhibition, more than hundred people attend

國立台北商業大學/國際貿易科/商學副學士/2005~2010



Projects


VBA專案-出納新人訓練

成效:增加新人存活率60%。
主要擔任工作概念教學、新人輔導、協助使用程式,專案內容:

1. 新人訓練
2. 加強新人對VBA的瞭解與應用 
3. 增加新人對相關工作事物的認知
4. 加強核對流程、降低新人核帳所產生的錯誤


VBA專案-出納帳務核對及營運

成效:核對成功率增加90%,需求時間減少由1小時縮短為5-10分鐘,每人每日至少省下1-3時核對時間。
主要擔任程式撰寫、實驗測試、BUG除錯 .專案內容:  

1. 撰寫帳務核對VBA  
2. 提高核對準確率  
3. 減少人工核對流程  
4. 降低核對所需花費時間

References


王聖文/Gary Wang

台灣區財務負責人
Taiwan Deputy manager
星聖資訊服務有限公司

Zeal Capital Market (Seychelles) Limited


Suna Lau Flynn

CEO & Founder 
The Cultural Centre Pty Ltd  


Charlie Price

Account Manager 

Agri Labour Australia

Others


Showcase-In-Paradise (https://reurl.cc/kZYd3K)

活動過程及成效:
1. 團隊分工拜訪整個澳洲城市(Carins)超過百位商家
2. 與活動飯店Paradise Palm協調活動進行
3. 成功招攬超過10組攤商到現場擺攤
4. 成功募集捐款給白血病兒童


國際會展英語接待員

參與舉辦大型國際會議英語接待,國內外與會人數眾多
2018亞洲職業安全衛生研究機構會議 ,簡稱 AOSHRI
2018台灣國際智慧能源週 Energy Taiwan 2016全球自行車大會/台北國際汽車展覽
2015亞太消化會議,簡稱 APDW


在學活動經驗

103年, 室內設計實務班 副班長/羽球團體賽季軍/成果展幹部,負責資源整合並擔任對外協調窗口
101年, 台中舒跑盃路跑10公里,完賽時間 50分鐘
96-97年,台北商業大學-國際貿易科科會設備長/學生會幹部
94-97年,台北商業大學-吉他社-擔任幹部3年,舉辦期末校園成果發表會,校內及校外人士參與人數破百。
92年, 建德國中於總統府前升降旗典禮舞蹈表演

Powered by CakeResumePowered by CakeResume