• Managed global equity compensation program for 19 APAC countries • Coordinated equity awards (RSU, PSU, DCSU, and DCA) vesting/payout and granting processes• Collaborated with in-country HR and Tax teams on vest income allocation and tax withholding• Arranged dividend equivalents and fractional share refunds with compensation and payroll teams• Worked with external vendor to support legacy ESPP program• Conducted deferred equity award buyout valuations for new hires• Coordinated KPMG audit and HKMA Key Personnel Remuneration disclosures for Hong Kong, BCBS Pillar 3 disclosure for Singapore, and monthly award amortization reporting using Workday and Excel/Power Query• Managed senior executives' deferred equity awards portfolios analysis for cash flow• Planned, supervised, and supported incentive award structures and deferral overrides per local regulations during year-end compensation processes • Developed and delivered training on global equity compensation program and processes• Subject matter expert and main contact for employee inquiries on deferred equity awards• Achievements:1. Led deferred award buyout valuation migration project, covering requirement elicitation, gap analysis, process redesign, and implementation and communication plans2. Designed and managed APAC cross-border remote work database, including reporting, ad-hoc queries, and status dashboards using Workday, Excel/Power Query, and Access3. Automated stock price extraction for buyout evaluations with Excel VBA4. Coordinated HR aspects of the Hong Kong Legal Entities Amalgamation Project5. Planned, designed, and trained staff on Secondment Data Capture processes in PeopleSoft HR Management System6. Streamlined award amortization reporting, Hong Kong tax reporting, and KPMG audits using Workday, Excel/Power Query, and Access

• Enhanced Equity Compensation Web (ECWeb), Equity Compensation System (ECS), and Deferred Compensation System (DCS) functionalities, contents, and database management using MS SQL Server, Java, Servlet, JavaScript, HTML, PowerBuilder, and Access• Gathered user requirements, estimated project costs/timelines, designed technical specifications, and planned UAT for system development projects• Created ad-hoc queries using MS SQL Server Query Analyzer and Access• Investigated data discrepancies and conducted system risk assessments• Achievements:1. Integrated SOAP messaging for user access synchronization using .Net, C#, and MS SQL Server2. Added email capability in ECWeb using Java, Servlet, and JavaMail3. Designed and implemented Tax Profile functionality in ECS for tax calculation and reporting4. Developed accounting reports in ECS for regulatory compliance

• Responsible for designing and implementing Audit Progress Tracking and Risk Assess Management functions, Confirmation Response System, Quarterly Confirmation System, Anti-Money Laundering (AML) System for the Internal Audit Department using ASP, VBScript, MS SQL Server, Crystal Report, and PowerBuilder.• Installed, configured, managed MS SQL Server.• Designed and implemented databases, tables, stored procedures, triggers, and Data Transformation Service (DTS) packages for various audit systems using MS SQL Server.