Randy Ying, B.S.

Accounting and Finance Department • Analyzed financial balance sheets and cash flow statements utilizing NetSuite, Sightfull, and Excel • Reconcile payroll and bank expenses for the United States and Global locations • Collaborated with a team to develop OPSWAT’s Avalara Project which addresses the company’s global sales tax • Acting SME for Expensify, consolidating company reimbursable expenses prior to payment and communicating with employees internationally about policy and procedures for reimbursable expenses • Primary contact for all new vendors globally, entering and updating all pertinent data information • Acting SME for Confluence for the Accounting Team, created and consolidated company accounting and sales rules • Reviewed OPSWAT’s Accounts Payable Register to create prepaid, fixed asset and depreciation schedule monthly Revenue Operations in Sales Department • Responsible for determining and calculating expansion, renewal, and new opportunities using Salesforce and Excel • Constructed and calculated Q1 commission statements utilizing Pivot Tables, IF functions, V-LOOKUP, and more. • Sent out commission statements and communicated with the sales representatives throughout the process • Worked with a team to achieve implementation of CaptivateIQ for use of the company’s sales teams • Primary contact for sending out quotes to retention team utilizing DocuSign and Adobe Acrobat

• Worked with client in the healthcare sector to attract new customers through increased social media awareness and engagement • Increased social media traffic by 25-117% in likes and views

• Communicated with park attendees effectively on a daily basis • Worked with culinary team to prepare food items for park attendees