John E. Cooper

*. Precipice Rd.

Camden, SC *****

acu2w5@r.postjobfree.com

803-***-****

Education University of South Carolina Columbia, SC

Master of Accountancy, May 1997

Bachelor of Science in Business Administration - Accounting, May 1996

Experience

Robert Half Technology - Automatic Data Processing, Inc. (ADP) Florence, SC

Consultant & Business Analyst 2013 – 2016

Supported the Data Operations Director in completing the review and testing of payroll, reviewing reports, and day-to-day oversight of alerts in the DWH Controller

Responsible for day to day activity in the WOTC Data Warehouse Controller; including monitoring and troubleshooting all exceptions on payroll and tax credits files

Performed testing and repair of payroll files utilizing SQL Server, Data Warehouse Controller, Vista, CRM, Siebel, UC4, Access, Excel, and various macros

Completed client reviews by performing trend analysis to identify, locate, and request missing & incomplete payroll for tax credit reporting

Hubbell Power Systems Columbia, SC

Pricing Research Database Analyst 2008 – 2012

Analyst in charge of performing monthly reporting for the Pricing Department

Prepared Executive Summaries and financial models for senior management

Supported Vice President of Sales and Sales Managers as needed with various sales and analysis reports

Developed and implemented a metrics database with excel reporting that measured key metrics for management

Extensive experience in developing Access queries, macros, forms, and databases for various financial processes and projects

Experience in modifying SQL and VBA expressions in Access databases and Excel workbooks

Developed a competitive feedback database and prepared market research reports for group

Performed process improvement initiatives for various pricing functions and developed procedures for group

Developed a centralized comprehensive database for the pricing department that streamlined pricing processes

Wrote training manual and procedures for database and excel tools to train department staff

Developed price adjustment databases and pricing models that streamlined an existing three month price adjustment process down to a three week process

Implemented and maintained a pricing web repository that allowed all business units and sales regions to access various pricing reports from all locations via the internet

Developed and repaired excel macros for various processes

Extensive experience in building excel models; including pivot tables, graphs, and macros

Developed win/loss reports and price realization reports at various levels for management, sales regions, and business units

Developed financial impact & projection models for management

Lead instructional training meetings relating to new pricing databases, reports, & pricing tools

Trained key personnel that utilized reports, tools, & databases

Developed automated quote approval reports that interfaced with a centralized pricing database and e-mail system

Designed, implemented, and maintained various access databases and excel tools to streamline pricing functions within the company

Developed database tools that integrated Zilliant recommended price points into automated analysis reports

Consulted with the sales regions & business units on Pricing department reports and tools

NetBank, Inc. Columbia, SC

Senior Accountant / Analyst 2006 – 2007

Senior Accountant /Analyst reporting directly to Controller, supporting all accounting groups within the company

Developed and implemented process improvements for monthly commissions accounting Access database

Prepared and submitted commissions payment files to payroll monthly

Performed process improvements for various accounting functions and developed procedures

Performed audit testing for internal and external audit requests

Developed and implemented excel automated journal entry templates interfacing with Access databases to facilitate the recording and analysis of company accounting

Performed account reconciliations and financial journals

Performed FAS 133 Hedge accounting for mortgage operation

Accountant in charge of monthly commissions process for mortgage operation

Designed, implemented, and maintained various Access databases to streamline accounting functions within company

Developed procedures and trained staff on use of databases and journal templates

Developed and repaired excel macros for various accounting processes

Developed Account Data Dictionary Access database for accounting group to track monthly account reconciliation and procedure processes

South Carolina Electric & Gas Company Columbia, SC

Accountant 2000 – 2006

Integral part of accounting team responsible for month-end closing and complete forecasting of Fossil/Hydro generating facilities

Monthly analysis of reporting variances from forecast and budget for over ten generating plants

Performed account reconciliations and financial journals

Accountant assigned to phase I of the Saluda Dam Remediation Project

Responsible for Fossil/Hydro fuel accounting

Performed financial analysis for management

Assigned as plant accountant for the Urquhart & Williams Generating Plants

Assisted in developing and implementing unit based costing reports for senior management to help identify cost reductions and improve margins for cost centers

Prepared the Electric Operating Statistics Report & EIA-906 Power Plant Reports

Assisted with annual budget planning processes for Steam & Hydro Plants as well as the monthly rolling forecast

Prepared Federal Energy Regulatory Commission report filings

Prepared Major Maintenance financial budget models for management

Developed various Access databases/queries and excel spreadsheets for financial projects

Conducted variance analysis for Hydro & Steam operations utilizing EBS & PeopleSoft Financial Analyzers

Process Tester for Sarbanes Oxley section 404 compliance

Experienced in coordinating requests with internal and external auditors

Trained staff in accounting applications

Lang-Mekra North America Ridgeway, SC

Project Consultant 2000

Implemented fixed asset accounting system for plant

Developed fixed asset methodology for accounting operations

Trained accounting staff on accounting system and fixed asset procedures

Office of the State Auditor Columbia, SC

Auditor 1998 – 1999

Performed field & desk audits of state non-profit agencies

Audited Medicaid based cost reports

Audited fund / grant accounting for the State of South Carolina

Volunteer/Activities

Completion of American Management Association (AMA) course seminars

Awarded the 1996 Institute of Management Accountants scholarship

Inducted into Beta Alpha Psi, the International Honor Accounting Organization

Volunteer with the Oliver Gospel Mission

Volunteer with Habitat for Humanity

Volunteer with the United Way

Participated in the Volunteer Income Tax Assistance Program

Former member of the Professional Pricing Society

Computer Skills

Microsoft advanced Access, Microsoft advanced Excel, & PowerPoint

Experienced in writing Access & Excel queries, macros, and pivot tables

Experienced in training staff on Microsoft Excel, Access, & various computer and accounting applications

Proficient with SAP, BI, BW, Tortoise SVN, and Zilliant

Proficient with Microsoft Office Professional, ACL audit software, Crystal Reports, Power Plant & FAS fixed assets, FMS Fuel Management System, PeopleSoft & Flexi General Ledger systems, & Cognos Power play financial analyzer

Familiar with SQL Server Management Studio, Oracle CRM, Vista, and UC4

References Available upon request

Contact this candidate