Ryan Tay Email & Phone Number

Singapore

Singapore

Singapore

Domain: Cross Border Commercial- Revamping and maintenance of SQL-based Marketplace P&L projection pipeline for all Cross Border Markets for direct reporting to Chief Commercial Officer.- Led data alignments for Marketplace commission foregone revenue tracking project and built subsequent SQL-based workflows to monitor profitability of shops under special commission waiver programs. - Led data alignments and devised script logic to provide centralized source for Marketplace Paid Ads revenue data, to enable efficient querying for stakeholders.- Creation of automated database ingestion pipelines for for offline projected target inputs to enable enhanced archiving and SQL querying- Liaising with cross-functional teams to align on management metrics calculation logic to meet business requirements-Developed dashboards to monitor KPI metrics metrics such as "Fulfilled By Shopee" Marketplace P&L, Livestream performance and cost efficiency and E2E Lead Time distribution.

Singapore

Domain : Cross Border Shipping and Logistics (SLS)- Constructed and maintained various PrestoSQL workflows and BI Tableau-like dashboards to facilitate better monitoring of lead time, parcel outbound volume and other SLS-related metrics.- Day-to-Day querying (PrestoSQL) of data relating to Shipping and logistics and marketplace orders, to facilitate JIRA data requests received from various stakeholder teams- Co-ordinated with Business Product Managers to identify and pull orders with shipping fee (ASF) issues and simulate correct calculation of ASF revenue- Performed analyses on lead time, service point capacity, last mile area serviceability and return and refund rates to provide actionable insights with stakeholders to better optimize operations.- Developed PrestoSQL-based download boards to enable automation of SLS-related data pulling by non-SQL versed stakeholders to facilitate ad-hoc data requests- Liaised with cross functional stakeholders to ensure alignment of data logic and definitions for consistent and accurate reporting - Developed CB BI SLS sub-domain website utilizing Google sites and html, providing a centralized source of CB BI related tools and resources to stakeholders. - Utilized Python, Spark and PrestoSQL workflows to create database intermediate table ingestion cron jobs for automated ingestion of external vendor raw data and enabling automated calculation various SLS related-metrics

Singapore

• Collaborated with various audit teams to perform the statutory audits for over 30 entities, including that of a group audit. • Performed substantive audit procedures and testing on various income statement and balance sheet line items to ensure compliance with International Financial Reporting Standards (IFRS), such as IFRS 9, IFRS 15 and IFRS 16• Utilized Excel spreadsheet and analytics tools to perform analytical reviews for various entities' financial statement line items based on historical and current financial data, to identify and investigate unusual trends and fluctuations • Performed reviews and documentation on significant risk items such as in management override of controls and the audit planning memorandums. • Co-ordinated client facing communications and acted as frontline client liaison to over 25 different clients, to facilitate the timely completion of the audit engagements.

Singapore

• Supervised operations and communicated actively with team members as Team-in-Charge to ensure the proper and safe running of operations for the main attractions• Constant on-the-ground decision making to ensure crowd control and incident management• Acted as ambassador for the attractions by providing in-depth information and other general information in English and Chinese to over 200 guests and tourists to ensure customer satisfaction

Singapore

• Assisted audit teams in performing substantive audit procedures for at least 7 different entities through vouching, statutory audits, bank confirmations, authentications and inquiries• Performed sample counts for entity’s inventories for physical verification and to ascertain the reasonableness of its inventory valuation• Communicated actively with clients and team members to seek clarifications on audit matters• Utilized audit analytics software to extract financial and non-financial data for the purpose of analytical procedures

Singapore

- Utilising Spreadsheet tools (Excel) for data entry purposes as well as organising and summarising data relating to manage and track premium payments

Bachelor'S Degree, Accountancy, Honours With Distinction

Graduated with Honours with Distinction (Second Upper Class Honours) Achieved Distinction and Awarded Deloitte and Touche LLP book prize.

Diploma, Accountancy, Graduated

Activities and Societies: Finance Manager, Diploma in Accountancy Student Management Committee Achieved academic excellence in modules.

Business, Distinction

Attended 4 week overseas Business research and Exchange program with Tianjin University and Dalian Polytechnic University. - Tianjin.

Gce "N" Level, Gce "O" Level, Graduated

Activities and Societies: National Cadet Corps, Prefectorial Board executive committee Valedictorian – Serangoon Secondary Achievement.