Brian Cao Email & Phone Number

Coppell, Tx, Us

Coppell, Texas, Us

Analyze and inform treasury team our daily cash flow needs for current and next day by providing an AM & PM cash position report.Present to the treasury team our cash plan for the current and next few weeks by updating the cash plan with actuals and forecast to ensure continuity of business operations; cash plan is updated quarterly using information provided by FP&A.Reconcile and disburse maintenance payments to our dealers and provide outstanding customer service to our dealers.Maintain the Treasury Inbox. Tasks include, but are not limited to, replying to departmental requests, processing payment requests and AP runs, maintaining user access, filing away emails, processing stop payment and positive pay exceptions, etc.Fulfill audit requests (internal and external) by providing treasury management the supporting documents and reports on time. The audit results were satisfactory.Service our debt (i.e. CP, EMTN, bank loans, and derivatives) and wire loans to TICF’s intra-company business partners by ensuring payments or loans are processed on time. No payments were missed.Complete month-end, quarter-end, and year-end reporting for Treasury and Accounting. Tasks include, but are not limited to, intra-company debt reporting, ABCP/ABL, uploading bank statements for Accounting, IRS and facility utilization report, and other compliance reporting requirements.Utilize information systems and websites such as GTreasury, SAP, CashPro, JPMorgan Access, Citi Direct, MUFG, and Payconnexion. Have the ability to learn new systems quickly.Take initiative on ad-hoc projects such as bank fee analysis, improving desk guides, streamline several reports such as month-end interest rate swap derivatives, improve cash position reporting, assist with GTreasury projects, revise check/wire/ACH request forms, and automate many of our treasury reports via macros, formulas, and queries.

San Jose, Ca, Us

Assist team of eight or more people for global regions such as NA, LATAM, EMEA, and APAC in automating their work, resulting in 15 – 30 minutes saved per task.Utilize Microsoft Access and Excel macros to automatically populate cash position.Develop Excel formulas that can weight current year’s forecast using prior year’s actuals while factoring in FP&A’s inputs. Absolute value variance used to test forecast models.Automate our audit between our internal bank report and ERP by using conditional formatting and cross-referencing formulas.Implement queries in Access to extract from a large dataset to determine final amount.Record FX purchases for six foreign currencies.Train 10+ employees on new processes and provide written procedures to assist team in utilizing the new tools.Familiar use with SAP for researching bank transactions.Enter daily wire transfers and reconcile accounts in Quantum SaaS.

Chicago, Il, Us

Develop cash forecast models in Excel for faster and accurate forecasting using historical data and budget forecasts.Manage $100 million+ investment portfolio by investing in money market funds and fixed-income securities while maintaining portfolio compliance and operating liquidity. Familiar with use of Bloomberg terminal.Train 12+ staff and interns on how to conduct treasury operations.Assist external auditors with bank signature cards, internal controls, SOCR, and payment audits.Assist Accounting with GASB 40 by coordinating with team members in reconciling trial balances related to treasury.Facilitate with other stakeholders in the process of transitioning to a new bank by assisting in the RFP process, documenting and reviewing accounts, and participate in meetings with the new bank to discuss what services we require.Utilize online banking applications such as JP Morgan Chase Access, Bank of America CashPro, and US Bank SinglePoint to download reports, initiate wires, ACH, and book transfers, review and decision exceptions, and remote deposit capture.

Chicago, Il, Us

Enhance and consolidate various cash management spreadsheets such as Cash Position, Treasury Statements, Cash Reconciliation, Cash & Investments, etc. by improving readability and streamlining financial reporting.Automate via macros (VBA), complex formulas (i.e. XLOOKUP), and queries utilizing Excel, Power Pivot, Access, and Oracle to significantly increase efficiency in preparing, reconciling, and analyzing financial data.Co-managed the Treasury Policies and Procedure Manual project by auditing, updating, and implementing the department’s policies and procedures process.Process over 100+ transactions through positive pay checks, EFTs, ACH, Wires, and Epayment (P-cards) per week.Oversee Treasury SharePoint site as system administrator and developer.Record journal entries in Oracle, and track and record investments within a portfolio such as Tracker.

Master Of Science (M.S.), Accounting

Bachelor Of Science (Bs), Information Decision Sciences

Associate Of Science