Gary Horner Email & Phone Number

Minneapolis, Mn, Us

• Achieved a 70% reduction in the time required to complete daily investment portfolio activity recordkeeping by implementing Excel macros, pivot tables, and formula functions• Managed the collection and disclosure of unrealized gain/loss on Available for Sale and Held to Maturity portfolio security positions along with realized gain/loss on AFS securities• Enhanced and maintained complex Excel workbooks which were used to monitor and reconcile daily Investment Portfolio activity•. Maintained and improved monthly Investment Portfolio Book Value roll forward reporting • Effectively used Workday General Ledger and Essbase to retrieve information and report on Investment Portfolio activity• Responsible for the accounting and reconciliation processes related to Corporate Treasury’s complex tender option bond program

• Realized a significant reduction in the time needed to prepare cashflow, budgeting, and forecast reports through the implementation of Excel macros, functions, and pivot tables • Effectively created, enhanced, and managed processes used in presenting Timber Owner expense, income, forecast, and budget numbers• Maintained a variety of complex Excel workbooks which dramatically decreased the time necessary to prepare Timber Owner reports • Responsible for fixed asset record keeping and the accurate allocation of Limited Partnership timber income and expenses

Toronto, Ontario, Ca

• Accurately posted tender option bond trades, accruals, revenue, and expense general ledger entries • Attained a 25% reduction in the time required to post accruals and pay fees through the implementation of Excel sumif, if, and vlookup functions in Journal Entry Template worksheets

San Francisco, California, Us

• Enhanced funding processes and accurately forecast three business units’ daily cash needs through effective communication and efficiently using a variety of reports and Excel workbooks• Prepared and analyzed monthly general ledger trend analysis workbooks and distributed them to management

San Francisco, California, Us

• Precisely executed stock, bond, option, mutual fund, and treasury transactions during fast paced market conditions • Provided excellent customer service by asking insightful questions and using internal resources to quickly address customer inquiries and concerns

• Assisted Advisors with executing security orders and transferring their clients’ assets• Reviewed client risk levels and analyzed transactions for suitability

• Engaged with mutual fund companies to reconcile and correct differences between customer account balances and mutual fund networked positions• Assisted branch personnel with the requirements and procedures for opening new accounts, clearing estates, settling trades, distribution of retirement funds, and transferring accounts

• Accurately executed stock, bond, and option orders in a fast-paced work environment• Worked with a variety of customers to set up accounts based on their needs, responded to requests for information, and resolved issues quickly