|
|
ROBERT PEEL CROWL
854 Edel Avenue
Maywood, N. J. 07607-1725
(201) 845-8919
E Mail [email protected]
SUMMAR
An experienced corporate accounting & budgeting professional for
multi-service corporations. Converted manual operations to personal computer & mainframe generation of reports & analysis. Demonstrated skills in research, analysis, and problem solving.
EXPERIENCE
United Water New Jersey, Oradell, N.J. 1996-1999 Plant Accountant
Inputted capital subprojects to PeopleSoft. Supervised two temporary employees to convert continuing Property Records to Excel Worksheets for uploading to PeopleSoft Project Costing module. Converted lotus worksheet to Excel workbooks including journal entries, retirement reserve.... Assisted the Construction Asset Management Team and Tax Department, utilizing PeopleSoft. Coached two new temporary employees on their first days on the job. Built model with Excel Pivot Table to compare difference between General Ledger and PeopleSoft for project costing. Commended by Director for ease of following worksheets. Built Excel to calculate Allowance for Funds Used During
Construction Journal Entry. Complement made by supervisor in discussion with Controller about quick turn around.
Public Service Electric and Gas 1967-1994 Staff Accountant, Budgeting Staff Coordinator, Cost Analyst, Bookkeeper, Statement Clerk
Prepared reports to the Board of Directors, quarterly and annual reports to SEC, Regulatory Commission, stockholders and bondholders. Organized budget data for corporate business units on mainframe package-Financial Management, Budgeting & Accounting System (FMBA). Analyzed budget variances using Excel & Lotus spreadsheets. Created budget reports and charts presented at senior management group meetings. Provided PC & Spreadsheet support for the Budgeting group and the capital authorization section, automating reports and analysis. Prepared journal entries, details of general ledger accounts, financial reports
to internal users, and monthly account reconciliation.
Designed, programmed and implemented a system to download data from the mainframe, Financial Management Budgeting & Accounting System (FMBA), into PC spreadsheets, comparing the number of employees at month-end and their labor costs. Information provided to corporate senior vice-presidents.
Developed a program to automate the comparison of actual versus budget for Other Direct Costs (Employee Benefits) utilizing Lotus. Report sent to all Company department heads.
Automated the downloading of mainframe data into PC spreadsheets,
comparing actual versus budget for Administrative and General Expenses to respond to the Chief Executive Officer's variance questions. Change to existing program improved response and analysis time (from four days to two hours).
Commended on professional performance appraisal for looking for better
ways to prepare statements and perform a job function utilizing electronic processing.
Computer Skills: Lotus 1-2-3, Excel, Office 95, Word for Windows, W/P, FMBA (mainframe package).
Education: Bachelor of Science, Fairleigh Dickinson University, Teaneck. Accounting major. Dean's List & Honor's List. Graduated summa cum laude.
Certificates: H&R Block Preparation of Individual Income Tax, Dec. 1999. Fourth degree black belt Kodokan Judo.
|
|
|
|
