Analyst Sales

Andrew Bowman

adi4t3@r.postjobfree.com 224-***-****

*** * ******** ***, ***** Prospect, IL, 60056

Objective: To obtain a Senior Treasury Analyst position where I can utilize my degree and experience to make organizational contributions. Willing to relocate.

EXPERIENCE

William Blair & Co. LLC Chicago, IL

Treasury Analyst May 2019 - Present

Lead Monitoring cash activity and maintaining records of supply and transfers for daily cash allocation, balancing and account funding requirements

Reviewing and making recommendations for working capital levels, minimizing idle cash and ensuring adequate liquidity to meet operating needs

Tracking, analyzing, and reporting real rates of return on deposit and investment accounts

Participating in cash forecasting and authorizing the release of wires/ACH/checks less than $1 Million

Reviewing 39 domestic and 14 foreign bank accounts to verify cash inflows/outflows success while resolving discrepancies across 3 corporate entities

Performing daily bank account reconciliations and managing confirmations/escalations with AR, AP, Payroll, Accounting, Tax, Compliance and Institutional Settlements

Continuously looking for operational efficiencies and savings opportunities while making change recommendations to management.

Training and reviewing payment entries and records of entry level co-worker

Creating internal and external risk reports for specific account balances, activity, and Quarterly Investment Policy updates

Managing working capital accounts and maintaining close relationships with the firm’s 210 partners

Maintaining treasury records for audit and compliance

Transworld System Inc. Lake Forest, IL

Treasury Analyst June 2018 – May 2019

Overseeing checks, wires and ACH issuing, refunds, and voids from multiple accounts using SAP

Identify, research and resolve commission variances found in all ERP systems

Lead, develop, streamline and track client account reconciliations data and procedures utilizing Excel

Owning and maintaining large customer data base used between multiple departments and ERPs

Providing Treasurer with monthly and quarterly accounts receivable reports

Report to Treasurer regarding aging accounts receivable and track rehab payments

Disclose to Treasurer bad debt covenants in preparing financial statements

Reporting and maintaining lockbox to Treasurer and accounts receivable team onshore and offshore

Work closely with tax and financial analysts involving accounting queries

Essential analyst for all education clients’ accounts receivable and lead troubleshooting database

Realogy (NYSE: RLGY)

NRT LLC - Central Processing Center Deerfield, IL Commissions Auditor July 2017 – March 2018

Produce monthly metric reports for changes in sales price, commission levels and daily team volume to management using large data sets in ERP

Research and update commission reports using Pivot Tables, VLOOKUP, and Sum IF formulas

Calculate 75-100 agent commission deposits for 62 realtor branches in accordance to specific HUD and Compensation rules

Research sales taxation on short term transactions while keeping adequate documentation

EDUCATION

Eastern Illinois University Charleston, IL

B.S. in Business Finance June 2015

SKILLS

Advanced knowledge of Bank Portals, Reval, NetSuite, Sharepoint, Microsoft Word, PowerPoint and Excel

Understanding of financial statements (Balance sheet, Income statement, P&L and Cash Flows)

Deep interest in bank structures, Cash positioning/forecasting, Leveraging portfolios and FX exposure

Fast Learner with ability to adapt to unique and changing circumstances and developing improvements

Committed to high quality focus for internal and external customers as well as team work

Adept at processing and analyzing large volumes of sensitive financial data under short time constraints

Strong analytical skills, industry knowledge, attention to detail and solid work ethic

Proven interpersonal skills with existing long-term relationships

Certifications

FINRA SIE & Series 99 License

In pursuit of Certified Treasury Professional via Association for Financial Professionals 2021

Contact this candidate