John Keller Email & Phone Number

Fort Mitchell, Ky, Us

Cincinnati Metropolitan Area

Erlanger, Kentucky, United States

• Lead board member in charge of financial management and oversight.• Manages cash flow for the organization.• Works closely with the President to develop annual budgets.• Reconciles bank statements while preparing monthly financials.• Ensures all receivable accounts are kept current.• Works closely with external CPA firm to ensure annual 990 tax filing and 1099s are delivered in a timely manner.

• Develops the annual company budget while collecting feedback from multiple sources at different levels within the company• Delivers to senior management and board of directors, monthly financial statements (IS and BS, revenue reports, billable hour reports, summary of results)• Provides key financial and budgetary reports on a weekly basis to project managers and executives• Develops project based budgets used to obtain funding from various sources (government, corporations, private and foundations)• Spearheads the annual financial and 401k audits• Owns the submission and analysis of the bi-weekly payroll for the company• Drives departmental capacity and efficiency through the development of various reports and process improvements (Payroll, software automation and integration)• Prepared all requested documentation for various program audits• Reconciles corporate investment accounts and prepares year end statements for annual audit• Relationship manager for third party software consultants• Accomplishments include:o Research and implementation lead for transition of in-house payroll to third party (Paycor) including the development of all integration files and testingo Created various SQL views to improve cost-to-date and work-in-progress reports from Crystal Reports that are used by project managers and directors to gauge status of contracts and their budgetso Key player for the implementation and training of current time and attendance application (via web services) from previous manual processo Lead communication and delivery of requested documentation for HUD/Department of Labor audito Researched and implemented a process change through coordination with third party software consultant that has led to improved reporting

19 Garfield Place, Cincinnati, Oh 45202

• Started as a Financial Analyst and progressed to a Financial Services Manager via promotions• Delivered to senior management monthly financial statements (consolidated IS and BS, sales reports, utilization reports, year end summary of results)• Prepared all requested documentation of European operations for annual audit• Reconciled corporate investment accounts and prepared year end statements for annual audit• Worked closely with senior management to establish budgets for European offices• Managed accounts payable from invoice entry to preparing checks for approval and signatures• Coordinated the month-end process• Managed multiple direct reports located in Cincinnati, Frankfurt (Germany) and Geneva (Switzerland) • Database administrator for Dynamics GP, Frx, Management Reporter, Crystal Reports and the time and attendance application• Member of the internal IT help desk in charge of Dynamics GP and our timesheet application• Built departmental capacity via various reports and process improvements (AR, AP, software automation and integration)• Accomplishments include:• Established a finance department in Europe• Set up initial processes for inter-company invoicing and consolidation while ensuring they supported the established transfer pricing methodology• Created cost-to-date and work-in-progress reports from Crystal Reports that were used by the company to gauge status of projects and their budgets• Research and implementation lead for new accounting software (Dynamics GP)• Implementation lead for the current time and attendance application (via web services)

19 Garfield Place, Cincinnati, Oh 45202

• Managed the intern program (interviewing, workload, salary and reviews)• Reviewed and signed checks for accounts payable• Analyzed cash management while assisting Controller in decision-making processes• Managed corporate credit card and rewards program• Database administrator for Clients & Profits while leading multiple upgrades• Prepared for annual year end audit (account reconciliations, collection of tax documents, flux analysis)• Accomplishments include:• Implemented and managed time and attendance application (via FileMaker Pro)• Created graphs for quarterly company meetings and as annual BOD meetings• Worked directly with legal counsel in the review of various master service agreements

19 Garfield Place, Cincinnati, Oh 45202

• Maintained manual general ledger while compiling financial statements and sales reports via Excel and completing account reconciliations• Managed petty cash, travel advances (domestic and foreign) and bank reconciliations• Reviewed both domestic and foreign expense reports for accuracy and compliance• Responsible for invoicing and budget management of various multi-million dollar brands• Accomplishments include:• Research and implementation lead for new accounting software (Clients & Profits)• Implemented the migration from manual to electronic General Ledger• Worked directly with internal IT department to implement electronic timesheets (via Lotus Notes)• Created cost-to-date and work-in-progress reports from Clients & Profits that were used by the company to gauge status of projects and their budgets

Bs, Accountancy

Activities and Societies: Soccer Team '93-'96

Associate’S Degree, Business Administration And Management, General