Customer Service Manager

Y. Marie Dawson

*********@*****.*** 330-***-****

treasury manager

Leverage Sharp Eye for Detail to Ensure Accuracy

Technical Expertise

Software:

Excel, Access, Word (15+ years), Power Point (13+ years), Outlook (10+ years), Share Point (7+ years)

Systems:

Hyperion [HFM] (10+ years), Bloomberg (9+ years), Hyperion Essbase / INEA (4+ years), SAP (1 year)

Other Skills:

Online banking systems, Lotus Notes, GroupWise, MoneyNet (wire transfer system), Fedline, Attachmate Extra! (database), Tableau (online training only)

Banking & Cash Financial Modeling & Analysis Revolving Credit Agreements and Compliance FX/Commodity Regression Testing & Compliance Forecasting Database IR SEC Reporting

Professional Experience

STONERIDGE, INC., WARREN, OH Jul 2006 to Present

Treasury Manager / Treasury Analyst

Responsible for various treasury, IR, and financial analysis functions:

Administrator for North American online banking.

Manage various bank documentation (i.e. resolutions, signatories,…)

Monitor and execute funding as needed from the company’s Revolving Credit Agreement (previously ABL structure with Long Term Debt).

Responsible for quarterly and yearly revolver (previously ABL) bank covenant compliance.

Quarterly regression testing for all hedges (forex contracts / commodity contracts).

Analyze Forex exposure (B/S and I/S) for natural hedging or active derivative positions.

Confirm monthly settlement of spot & forward contracts (cash & physical delivery).

Budget and forecast forex rates, interest income, interest expenses, and bank fees.

Issue and Renew Letters of Credit.

Helped to create and maintain the SharePoint intranet portal Treasury page.

Responsible for ad hoc financial reporting related to what if scenarios for budget/forecast change assumptions, M&A, or divestiture inputs within an excel based model.

Monitor and evaluate domestic bank fees for accuracy and opportunities for fee reduction.

Oversight and review domestic daily cash reporting and global 6 week rolling weekly cash forecast.

Initiate or approve payment transactions via online or phone banking systems.

Perform various types of financial analysis including competitive peer and bank group analysis using Bloomberg extracts into excel. Also use Bloomberg to monitor and analyze FX rates, Interest Rates, and / or other relevant information as needed.

Assist in the creation of all Investor, management, and Board of Director presentations per CFO and Corporate Treasurer guidance.

Produced the quarterly financial footnote disclosure relating to Fair Value of Financial Instruments (senior notes, derivative instruments and hedging activities) and Long-Term Debt (senior notes & credit facility).

Previously built a database (MS Access) in order to consolidate divisional data (from various ERP systems) for ABL reporting

Manage various other Ad Hoc projects to support Treasury / Corporate Finance team:

oAssist the Budget and Forecast department to create / update reports for upper management.

oManaged or assisted in projects to upgrade our cash reporting requirements, adding fraud prevention services, converting N.A. banking to a new provider, divesting a segment of company, and changing and refinancing the capital structure.

oOccasionally help other departments create excel based files to retrieve accounting data from the Hyperion system.

oIncreasing exposure to ad hoc analysis related to M&A activity involving consolidated financials and covenant calculations.

KEY BANK, CLEVELAND, OH Oct 2001 to Jun 2006

Business Analyst Jan 2005 to Jun 2006

Enhanced and updated consumer credit LOB forecasting / planning models. Partnered with individual product managers to enhance forecasting accuracy.

Developed district level product forecasting / planning Excel-based models to help set Balance Sheet and P&L target goals for field representatives.

Updated competitive analysis reporting to aid in establishing market rates for each product.

Utilized competitor database to provide quarterly reporting for external presentations.

Provided various ad-hoc reports as needed.

Partnered with other internal departments for projects, ad-hoc reporting, research, and education.

Treasury Analyst, Regulatory Capital Jan 2003 to Dec 2004

Forecasted monthly regulatory capital for the parent company and the subsidiary banks.

Prepared annual / quarterly Risk Based Capital information for FRY-9C, Call Reports and SEC reporting.

Forecasted quarterly regulatory capital ratios in order to recommend a dividend or capital surplus withdrawal from the subsidiary bank(s) to the parent company (can be used to service debt and pay dividends to shareholders).

Partnered with the Federal Reserve (FRY-9C), The Office of the Comptroller of the Currency (Call Reports), legal, and / or regulatory reporting to research changes in regulatory requirements, provide requested audit information, and / or update all relevant modifications to models and reports.

Developed, implemented, maintained, and utilized various databases to retain historical information in order to analyze trends and to aid in the forecasting process.

Created and / or updated various Excel-based models used for calculating and reporting actual and forecasted information.

Prepared information packages for the Finance Committee, a subcommittee of the corporation’s Board of Directors.

Continually worked with internal departments to provide guidance and education on regulatory capital.

Funding Analyst, Treasury Operations Oct 2001 to Jan 2003

Maximized the use of funds by managing the position of the Fed account in order to maintain a target balance at the Federal Reserve Bank.

Monitored the Federal Account Daylight Overdraft position and implemented any controllable action to ensure that the bank does not incur fees.

Supported Fed Funds and Eurodollar trading activity (monitoring incoming and outgoing wires).

Developed and maintained management reports illustrating the department’s activity and expenses.

Built customer relationships and strived to maintain excellent customer service for our internal clients.

Created, implemented, utilized, and trained other department members on the purpose and use of an Access database to monitor and analyze cash movements across various components of the Fed account which ultimately effected the bank’s funding requirements.

JO-ANN STORES, Hudson, OH Nov 2000 to Oct 2001

Financial Merchandise Analyst

Performed divisional and corporate wide analysis pertaining to revenue and profitability on a monthly, quarterly, and year-to-date basis.

Performed various analysis on actual versus plan / forecast results.

Reported on a weekly basis, the effectiveness of key seasonal products to divisional and regional managers on a store-by-store level.

Built and maintained a database (MS Access) to store detailed information retrieved from SAP to analyze store and product level data.

Performed various ad-hoc analyses pertaining to advertising / marketing decisions, stock levels and inventory turns for the warehouses, receivables, and residual impact of closed stores on effected markets.

Education

Master of Business Administration (MBA), Concentration in Finance,

Kent State University, Kent, OH

Bachelor of Science (BS), Business Administration, Major: Finance,

Minors: Economics and Management Youngstown State University, Youngstown, OH

Contact this candidate