Accounting Sales
Resume:
John E. Cooper
*. Precipice Rd.
Camden, SC *****
***********@*****.***
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