Experience

Genting Americas Inc.

• United States
• Gambling Facilities and Casinos
• 1 - 100 Employee

• Financial Analyst

  • Jun 2018 - Present

  - Leverage SQL Server Data Tools to extract, transform, and centralize data from ten systems to facilitate FP&A reporting.- Design custom queries in SQL Server Management studio for the executive team.- Collaborate with IT and external consultants to fully automate the data collection needed for the finance team.- Produce monthly and quarterly financial reports for over 20 companies under the Genting Americas banner and conduct variance analysis to budget and prior year.- Maintain Daily Operations Report file used by the revenue audit team to validate revenue and metrics for 50+ cost centers across multiple properties.- Distribute a weekly labor report for department heads to monitor and adjust staffing levels.- Prepare weekly KBI reports to identify trends in gaming segments, F&B outlets, and hotel operations to senior management.- Streamlined the budget process by creating standardized templates and consolidation tools that are disseminated to all departments.- Engage with accounting to reconcile different reporting packages and aid with month end close by providing data for SAP.- Assist the purchasing and AP team in tracking ~$15M in yearly capital spending.- Support HR with human capital management by managing data and troubleshooting errors in Ultipro and Kronos, recording personnel requisitions, calculating labor union payments, and ensuring that labor levels fall within budget.- Write scripts in Python and VBA to automate various tasks and reduce the amount of time taken to produce reports, which includes writing documents, retrieving data from websites, and formatting reports.



Merchant Link

• United States
• Financial Services
• 1 - 100 Employee

• Accounting and Financial Analyst

  • Jun 2016 - May 2017

  - Tested an API routine between Microsoft Dynamics CRM and Netsuite to identify bugs and miscellaneous end user needs- Audited the company’s Customer Relationship Management system and Netsuite by pinpointing and correcting any differences in customer information, order status, and PIN pad transaction status- Created Excel tools to automate the creation of CSV files compatible with Netsuite data upload functionalities to increase the efficiency of data entry into Netsuite - Tested an API routine between Microsoft Dynamics CRM and Netsuite to identify bugs and miscellaneous end user needs- Audited the company’s Customer Relationship Management system and Netsuite by pinpointing and correcting any differences in customer information, order status, and PIN pad transaction status- Created Excel tools to automate the creation of CSV files compatible with Netsuite data upload functionalities to increase the efficiency of data entry into Netsuite



Sodexo

• France
• Facilities Services
• 700 & Above Employee

• Student Manager

  • Jan 2013 - May 2016

  - Recognized unique strengths present in each of over 85 employees in order to more effectively schedule job assignments, working hours, and to dynamically reassign people as required by customer demand for each station- Dampened the effects of the extremely high turnover by training over 20 newly hired managers, cashiers, line cooks, and utility staff each semester- Maintained restaurant quality through conducting random food and safety checks, managing breaks, and reprimanding individuals for ignoring standard operating procedures- Audited the cash supply on hand each day when cashiers retrieved their drawers before their shifts and when they returned them at the conclusion of service hours



Tokio Marine Insurance Group (Asia)

• Singapore
• Insurance
• 700 & Above Employee

• Actuarial Intern

  • Dec 2014 - Jan 2015

  - Identified the potential profitability of various insurance divisions by conducting sensitivity analyses using econometric techniques along with historical frequency and severity distributions.- Acquired a hands-on perspective of rate creation from visiting potential clients throughout Indonesia and measuring their risk profile based on an underwriting rubric followed by translating the rubric into a premium using the actuarial framework. - Identified the potential profitability of various insurance divisions by conducting sensitivity analyses using econometric techniques along with historical frequency and severity distributions.- Acquired a hands-on perspective of rate creation from visiting potential clients throughout Indonesia and measuring their risk profile based on an underwriting rubric followed by translating the rubric into a premium using the actuarial framework.