· Analysed various data and provide insights for further engagement growth

· Developed a dashboard using Power BI to assist in communicating analysis and insights to various stakeholders, including management team, C-level

· Built data pipeline and reduced data extraction and merging time from five hours to seconds

• Deployed SQL queries with Excel spreadsheets to merge data from various sources, to derive multivariate patterns and trends to fine tune marketing team’s strategy on improving engagement rates


• Built reports and dashboard that will assist in communicating analysis and insights to various stakeholders, including management team, C-level


• Established and implemented process items that improved the overall efficiency of the project

• Collaborated with front, middle, and back office on daily operation risk matters and crisis management


• Monitor incidents and put forward mitigating solutions; ensure appropriate documentation and incident reporting process followed


• Review and analyse information from risk management activities and in conjunction with changes, proactively monitor the control environment to identify potential weaknesses in a timely manner


• Collaborated with C-level on revamped of management information pack for oversight of business operations used in periodic regional meeting


• Automated Excel to increase efficiency of preparation of monthly meeting packs, reduce manhours by 95%


• Innovated Gantt chart for proper documentation and tracking of milestones and progression on a year-long project


• Liaised with stakeholders on risk closure evidence


• Coordinated transition of process to offshore team

Rotation in Core Operations and Collateral function

Core Operations:

• Monitored Capital market products trade confirmation and settlement and timely identify trade exception
• Ensured post-settlement reconciliation breaks are identified, investigated, and resolved in a timely manner
• Assisted in preparation and ongoing maintenance of Standard Operating Procedures

Collateral:

• Managed daily margin requirements across various counterparties
• Timely resolved margin disputes as per ISDA agreement
• Escalated aging issues and assisted in MIS reporting

• Conducted in-house Visual Basic training for 30 pax to equip individuals with the knowledge of automating their own day-to-day processes within Excel


• Automated monthly accounts reporting using advanced Excel and Visual Basic programming to reduce manhours by 90%


• Liaised with various cross functional stakeholders to understand and incorporate User-Acceptance Testing (UAT) requirements into new Oracle system


• Prepared and executed test script required for system testing


• Handled historical data migration while ensuring data integrity


• Documented work processes using Visio flowchart

(worked in Suzhou, China)

• Leveraged on bilingual skills (Mandarin and English) to prepare documentation for various international stakeholders
• Prepared documents for goods import and export