Catalina Duque, Mba Email & Phone Number

Orlando, Fl, Us

• Led automation projects for Direct to Consumer Receivables that included designing and managing testing scripts, conducting process simulations in Microsoft Access, and SAP testing environments. Project requirements included developing a controls datasheet, maintaining, and updating the Microsoft Access database, and providing project management support.• Partnered with project managers to create and submit a detailed Systems Requirements Document that included multiple process flow maps, decision trees, and a proposed user interface design for the Wholesale Payment Reconciliation process.• Utilized Tableau and Tableau Prep to build multiple reports, data visualizations, and dashboards that assist the teams daily in monitoring AR risk, outstanding customer balances, and revenue trends. • Developed 8 VBA macro files to automate daily the Annual Pass Monthly Payment reconciliation process, generating 177 hours of annual time savings.• Implemented 5 ad-hoc VBA macro files to automate accounting tasks for various teams including Wholesale, Resorts, Receivables Reporting, and Club 33 areas.• Created risk dashboards in Smartsheet to provide visibility of internal control status to the leadership team.

• Managed the Oracle Fixed Assets modules - responsible for maintenance and resolving technical problems.• Responsible for Month End systems close of all Fixed Assets and tax books (13 books and approx. $5 billion in assets)• Prepared Cash Flow recons for all 12 brands and Fixed Assets recons• Prepared journal entries for Fixed Assets and General Ledger • Lead the FA team in the Oracle and Discoverer R12.2.10 upgrade – approx. 6 month company wide project• Conducted multiple yearly internal and external audit requests and walkthroughs• Responsible for various ad hoc projects – restaurant closures, roll-outs, RPA implementation, Disaster Recovery, ProCo Tax

• Reviewed, recorded, and retired fixed assets for existing restaurants. • Applied capitalization guidelines while reviewing invoices to book.• Prepared month end reports.• Assisted with Roll-Out projects; research, interpret, and book invoices • Prepared files for various RPA processes.

▪ Maintained resort and HOA general ledger accounts, ensuring revenues and expenses are posted correctly.▪ Prepared monthly close process: 30 journal entries, reported financials to resort, adjusted accounts using PeopleSoft.▪ Reviewed and compared annual operating budgets and forecasts to monthly reports using PEAK.▪ Reviewed and reported monthly financial statements.▪ Prepared and submitted 25 reconciliations for resort and HOA accounts.

▪ Managed customer service needs sent to the Treasury email, became the main point of contact between other departments and Treasury. Recognized for timely responses and efficient execution of requests. ▪ Performed refund verification for all credit card activity within the company.▪ Reported all refund exceptions to appropriate leaders and departments to correct exceptions; recovered 37k worth of exceptions in 2018.▪ Researched and responded to cardholder credit card disputes/chargebacks, average of 10 to 20 a day.▪ Reported all credit card chargeback activity for Hyatt and provided bank-posting activity to Mortgage Operations.▪ Served as Supervisor’s backup when on 3-month leave. Duties included managing daily work volume, submitting chargeback responses, following up to inquiries from other departments regarding chargebacks and bank activity, while continuing with my daily tasks mentioned above.

• Audited revenue paperwork generated by all departments within the casino and hotel.• Specialized in The Cage Department, the location where all monetary transactions were reported.• Tracked and reported daily variances and exceptions to department leaders.• Cross-trained auditing in other business departments including: Food and Beverage, Slots and Poker.

Orlando, Florida Area

Master Of Business Administration - Mba, Business Administration And Management, General

Bachelor'S, Economics. Communication.

Activities and Societies: Economics Scholar Society- Secretary