Data Analyst Financial

Cheryl L Johnson

PROFESSIONAL SUMMARY:

Professional with over 5+ years of experience in cash applications management, 4 years of treasury analysis, and 1 year of financial management.

Highly skilled in Microsoft Access, Excel, Word, and PowerPoint, with advanced expertise in V-Lookups, Pivot tables, and various financial software systems.

Certified AS/400 Manager, adept at international money market operations, and experienced with multiple banking platforms. Proven ability to multitask, solve problems, and work effectively in team settings.

EDUCATION:

Bachelor's Degree in Business Administration, Northwood University, Cedar Hill, TX, 2007 – 2011

Associate's Degree in Management – Cum Laude, Northwood University, Cedar Hill, TX, 2007 – 2010

SKILLS:

Advanced proficiency in Microsoft Excel (V-Lookups, Concatenating, Conditional Formulas, Pivot Tables), Access, Word, and PowerPoint

Knowledgeable in SAP, PeopleSoft, Concur, and Sungard software

Experience with Wall Street Suite, TD Bank, JPMorgan Chase Access, Bank of America CashPro, TIB, High Radius System, RAPID T3, and IBAN/SWIFT codes

Strong communication, problem-solving, multitasking, and team collaboration skills

PROFESSIONAL EXPERIENCE:

Toyota Financial Services (Contract Role), Plano, TX 06/2023 – 02/2024

Treasury Financial Analyst

Validated and confirmed daily settlements of debt and derivatives via RAPID and Wall Street Suite (WSS).

Ensured daily CSA confirmations were performed with external counterparties and processed in RAPID T3.

Worked with the AM Treasurer on strategic analysis to support ongoing funding and investment decisions, presented to AM’s ALCO and the AM/GWM Operating Committees.

Designed comprehensive ALM reports for the ALE Asset/Liability Committee, Investment Committee, and Board Risk Committees.

Supported investment relationships within Individual Wealth portfolios, including performance communication and policy/strategy development.

Contacted counterparties (worldwide banks) to resolve issues, negotiated, confirmed, and followed up as needed.

Performed month-end preliminary reports and first-of-the-month CSA interest payment tasks.

Greyhound Lines, Dallas, TX 07/2021 – 03/2023

Treasury Analyst

Initiated all wire and ACH debit and credit transfers, both international and domestic.

Led the development of systems for robust Asset/Liability modeling, integrating the company’s dynamic hedging program.

Analyzed monthly billing statements (JMPC Access and PNC Pinacle banking systems).

Monitored daily treasury cash actions and reconciled prior-day treasury activities.

Managed daily branches' opening balance reports and maintained the cash position report.

Updated treasury procedures as needed.

Service King Collision and Car Repair, Richardson, TX 09/2019 – 04/2020 and 07/2020 – 03/2021

Treasury Specialist

Managed EFT exceptions using the High Radius system and posted EFTs for insurance carriers.

Performed monthly front-end matching recon for ECA transactions and researched outstanding check payments.

Posted credit card, American Express, lockbox, and desktop deposit check payments.

Performed research for outstanding check payments.

Performed fund transfers and adjustments.

BNY Mellon, Dallas, TX 07/2018 – 08/2019

Trust Associate

Managed Debt Service payments (both interest and principal) for a bond portfolio of over 100 accounts.

Created and updated ticklers for administrative tasks in the ACS system.

Monitored accounts for fund positions to prevent overdrafts and performed asset vault deposits and withdrawals.

Processed OFAC screenings for foreign accounts and used Workflow tools to manage client service requests.

Southern Glazers, Addison, TX (Contract Role) 05/2017 – 11/2017

Treasury Analyst

Compiled special reports for employees and audited employee expenses using the Concur system.

Reconciled prior-day treasury cash activities and monitored daily treasury cash actions.

Initiated/approved international and domestic wires, including FX wires for USD, CAD, and EUR currencies.

Performed prior-day bank reporting for the company's Canada office and maintained daily branch accounts.

Backfilled for Card Service Representative - performed credit card balance and purchase overrides, ordered new cards, and reset passwords.

Trust Management Network, Dallas, TX 09/2014 – 03/2017

Income and Cash Management Specialist

Reconciled and posted income on securities, processed cash receipts and disbursement requests, and performed ACM trades.

Maintained and posted income for 11 banks and reconciled cash information for accurate end-of-day balancing.

Developed and maintained cash procedures and built a database for check number monitoring, which earned a performance bonus.

Posted dividend and interest income (BNY and Fidelity) for 22 banks.

Contact this candidate