Ed Cooper Email & Phone Number

Cleveland/Akron, Ohio Area

Responsible for providing key technical support, application maintenance and resolution of issues for procurement, account certification and business intelligence financial systems.Led business intelligence and database upgrade projects-responsibilities include developing the project plan/timeline, coordinate regression testing and communications to stakeholders.Identified and implemented process improvement efficiencies for client deposit reporting and regulatory data to general ledger reconciliations.Developed code, used for database upgrades, which automates the adding of new data sources to user workstations and relinking Oracle tables to Microsoft Access databases.

-Developed a cash forecasting database used to calculate the overnight borrowing need based on bank models and provide analysis and commentary on the current day’s forecast and any variance on the prior day’s estimate.-Designed and implemented a shared workbook structure between the user and the trader to provide real-time updates for bank data and trade activity in an effort to improve the accuracy and timeliness of the computation of the bank’s overnight borrowing need.

-Reviewed cash levels and short-term financing needs and adjusted short-term investment portfolio accordingly.-Calculated and reviewed monthly interest income and the effects of any fluctuations in market value as it related to various investment portfolios and operating entities.

-Calculated and reviewed daily cash position, effective interest rates, and availability on the lines of credit.-Forecasted weekly cash flow and prepared analysis and recommendations regarding a time frame for future borrowings.

-Analyzed cash accounts and forecasted daily cash reserve requirements.-Balanced asset/liability general ledger accounts, bank statements and student loan accounts.