Dale Rainwater Consulting
Chronological Experience

Home Services Experience Certifications Skills Training About Us Contact Information Site Map

 

Dale Rainwater Consulting offers ten years accounting and computing experience serving needs of public entities, international companies, finance and financial services firms, manufacturing concerns, not-for-profit organizations and other businesses.

 

(Note: Click blue diamonds below for details)

 

Chronological


Michael Page International, Inc.; New York, NY  10174

April '03 - Present; Database Consultant; July '02 – September '02; Interim Controller.

bulletTrain staff using custom applications developed with Microsoft Excel and Microsoft Access.
bulletDesigned, developed and implemented user-friendly Microsoft Access databases for temporary payroll, temporary billing, and temporary margin calculation; Microsoft Access forms with extensive Microsoft Visual Basic for Applications (VBA) validation code used to maintain data integrity for customers, clients, contractors, projects, and timesheets; Timesheets processed in various multipurpose formats from a single form; Payroll provider detail data imported automatically from .csv files; Adobe Acrobat used to automatically create .pdf files for customer invoices, statistics reports, new temps reports, and temporary margin reports; Microsoft Outlook automatically creates Email Messages and attaches .pdf files containing either customer invoices or internal management reports for automated distribution to Directors, Managers, and Consultants; Customer contact and Accounts Receivable collection communication information is documented and reported, including follow up reminders using Microsoft Outlook Tasks; Financial information in the form of invoice, costing, and general journal detailed data is efficiently uploaded through a Citrix connection into CODA Open financial accounting software located at parent office in Great Britain; wrote a resource information manual to be referenced by users and database administrator; and utility procedures create backups and, if necessary, restore database table data.
bulletProvided controllership functions for an international executive recruiting firm’s New York City office.
bulletDesigned, developed and implemented Microsoft Excel workbook solutions using advanced skills in Microsoft Visual Basic for Applications (VBA) to account for accounts payable, check writing, permanent and temporary payroll, temporary margin calculation and data uploading from Microsoft Excel to CODA Open financial accounting software.

 

Reed Elsevier; New York, NY 10017

June '05 – Present; Consultant.

bulletDesigned and developed Sarbanes Oxley 404 reporting application with Microsoft Excel using Visual Basic for Applications (VBA).
bulletImports .csv data, based on Axentis web application, that is modified with a custom file generator procedure that allows easy updates when column data changes.
bulletCreates summary reports based on custom report generator procedure that allows easy modification of report column data content and related column widths.
bulletOffers reports at various organizational levels and several column data content formats.
bulletPerforms backup of previous reports that are retain for later review.

 

Harvest Partners, Inc.; New York, NY 10017

August '05 – Present; Consultant.

bulletPerformed troubleshooting on Microsoft Access database that tracks marketing-related deal data.
bulletTrained staff on proper Microsoft Access data entry techniques and minor Visual Basic Editor Debugging.
bulletRecommended adding error handling to database's Visual Basic for Applications (VBA) code.

 

Calvary Baptist Church; New York, NY 10019

June '98 – May '05; Consultant Controller.

bulletProvided controllership functions to not-for-profit religious organization.
bulletActed as liaison to auditors during annual audit engagements.
bulletDeveloped, designed and implemented Microsoft Excel workbooks using advanced skills, including macros using Microsoft Visual Basic for Applications (VBA), to account for accounts payable, investments, fixed assets and depreciation.
bulletSetup procedures for repetitive tasks, such as monthly investment activity and monthly accounts payable disbursements, to be automated using import and export functions in NewViews.

 

GLN Compliance Group; Englewood, CO  80112

February '04 – March '04; Consultant.

bulletDesigned and developed user-friendly Microsoft Word application that automatically updates data in airplane user manuals, operations manuals, and pilot manuals by performing file management of related Microsoft Word documents; executes various find and replace procedures of fields values in body text, headers, and footers; searches for non-automated updates that require user intervention, refreshes various table of contents, and assists user in various printing options.

 

University of Medicine and Dentistry of New Jersey; Newark, NJ  07107

September '02 – August '03; Consultant.

bulletDevelop queries to extract data, using Microsoft Access and Microsoft Excel Visual Basic for Applications (VBA) procedures, from various Microsoft Access, Microsoft Excel and FoxPro databases.
bulletSequentially processed series of Microsoft Access queries using Macros.
bulletCross reference and map database fields from 8 universities' original data sources to destination Microsoft Access database tables.

 

Bank of America (Computer Generated Solutions); New York, NY

July '02 – July '02; Assistant Trainer.

bulletProvided Microsoft Excel 97 training to 45 Financial Analyst.

 

Liberty Digital, Inc.; New York, NY  10003 and Los Angeles, CA  90024

February '99 – January ‘02; Consultant.

bulletAssisted with preparation, review and editing of SEC Form 10K and 10Q, including footnotes, using Microsoft Word, Microsoft Excel and Adobe Acrobat.
bulletPerformed quarterly accounting tasks and functions: APB 25 accounting for stock issued to employees and FAS 123 accounting for stock-based compensation and Black Scholes Pricing Model calculations using Microsoft Excel and Microsoft Access.
bulletResearched accounting issues using resources from SEC, FASB, APB and AICPA.
bulletRecommended accounting treatment regarding accounting issue research.
bulletDesigned, developed and implemented Microsoft Excel workbooks with advanced functions, including macros using Microsoft Visual Basic for Applications (VBA), for stock options, stock appreciation rights, marketable securities, earnings per share, discontinued operations, chart of account development and accounting system conversion.
bulletDesigned, developed and implemented a Microsoft Access database for stock option and stock appreciation right plans.
bulletSetup Platinum accounting software working with consultants: general ledger and accounts payable.
bulletPerformed quarterly accounting tasks and functions: FAS115 marketable securities calculations, FAS 128 earnings per share calculations, APB 30 accounting for disposal of a segment of a business and FAS 130 comprehensive income.

 

Paine Webber/UBS Warburg (Robert Half Management Resources); New York, NY 10019;

November '00 – March ’01; June ‘01; Consultant.

bulletDesigned, developed and implemented Microsoft Excel macros for daily profit and loss statements using Microsoft Visual Basic for Applications (VBA).
bulletImplemented advanced Microsoft Excel workbook functions that improve effectiveness and efficiency.

 

Digital Creative Development Corp.; New York, NY 10003

June '00 – September ‘00; Consultant.

bulletAssisted with chart of accounts preparation and modification for ACCPAC Accounting Software using Microsoft Excel.
bulletDesigned, developed and implemented Microsoft Excel macros for financial reporting consolidation of multiple ACCPAC FR reports and trial balances using Microsoft Visual Basic for Applications (VBA).

 

Bronnercom (Robert Half Management Resources); New York, NY 10104

September '99 – October '99; Consultant.

bulletPrepared analysis and reconciliation of a major client’s account receivable and inventoried costs using Microsoft Excel and Lotus Notes.
bulletGenerated invoices for client’s approval and payment using Lotus Notes.
bulletPerformed day-to-day accounting tasks using Lawson's general ledger software.

 

Quadlogic Controls Corp.; New York, NY 10018

August '98 – August '99; Consultant / Employee Accountant.

bulletProvided Microsoft Excel workbook training and assistance to accounting staff.
bulletDesigned, developed and implemented Microsoft Excel workbook and Lotus 123 spreadsheet files using advanced skills to process complex salary and hourly payroll, reconstruct cash disbursement data to actual cash disbursements for bank statement reconciliation, summarize large accounts receivable report data into a summary report and setup procedure for mass production of general ledger account analysis.
bulletConverted payroll system to CompuPay software.

 

Restaurant Daniel (Cross and Guard); New York, NY 10021

May '98 – June '98; Temporary Controller.

bulletProvided controller functions, including day-to-day accounting tasks, to a well-managed top-rated French restaurant using ACCPAC.

 

Empire Insurance Company (Access); New York, NY 10011

April '98 – May '98; Temporary Accountant.

bulletAssisted with preparation of an insurance industry regulatory report.

 

American Institute of Certified Public Accountants (Access); Jersey City, NJ 07311-3881

March '98 – April '98; Temporary Accountant.

bulletReviewed conference and seminar profit and loss statements using Microsoft Excel.
bulletCompared and analyzed actual to budget profit and loss statements for the conference and seminar activities.
bulletModified profit and loss statement workbooks that were creatively designed with advanced skills using Microsoft Excel.
bulletPerformed internal accounting tasks for a new CPA service focused on Internet security called WebTrust.

 

Woodbridge Sterling Capital, LLC (Cross and Guard); New York, NY 10169-0005

November '97 – February '98; Temporary Controller / Employee Controller.

bulletProvided controller functions to an entrepreneurial high-growth finance firm.
bulletHired and trained temporary and permanent accounting staff to perform day-to-day accounting tasks.
bulletPrepared and managed cash flow and cash forecast reports using Microsoft Excel and Peachtree.
bulletReconciled general and subsidiary ledger accounts, cash, accounts receivable and accounts payable using Peachtree and Microsoft Excel.
bulletPerformed day-to-day accounting tasks and functions using Peachtree.
bulletOrganized accounting office, including new filing system, in a high-turnover environment.

 

CTI Information Systems, IKON (Access); New York, NY 10007

July '97 – November '97; Temporary Controller.

bulletProvided controller functions to digital imaging corporation.
bulletPerformed month-end closing and transmitted monthly financial reporting to the parent's accounting department using IMRS.
bulletModified Microsoft Excel workbook files using advanced formulas for maintaining fixed assets and calculation of depreciation.
bulletPerformed day-to-day accounting tasks and functions in the areas of client billing and cash receipts using ACCPAC.

 

MTC Imaging Services/World Care Imaging (Cross and Guard); New York, NY

May '97 – July '97; Temporary Accountant.

bulletPrepared intercompany account analysis and reconciliation for approximately 120 accounts using Lotus 123 and MAS 90.

 

Tucker Communications: Patent Trader; Cross River, NY 10518

April '97 – May '97; Consultant.

bulletDesigned, developed and implemented a fully integrated budget  spreadsheet using Lotus 123 that accounted for revenue and expenses for 12 unique publications.

 

Williams Tool Company; Fort Smith, AR 72903

September '96 – November '96; Consultant.

bulletPrepared GAAP balance sheet, income statement and cash-flow statement in a non-financial accounting reporting environment.
bulletProvided controller functions to entrepreneur while making recommendations regarding accounting and computing.
bulletPerformed many internal audit functions and procedures while gathering information for product profitability analysis.
bulletAssisted production manager in development of a complex product costing and inventory analysis spreadsheet using Lotus 123.

 

PBC Servicing Corp. (Quest Organization); Little Rock, AR

November '94 – February '95; Temporary Controller.

bulletProvided controller functions, such as safe guarding assets, during a top management change.
bulletPerformed day-to-day accounting and treasury tasks and functions.

 

[ Home ] [ Services ] [ Experience ] [ Certifications ] [ Skills ] [ Training ] [ About Us ] [ Contact Information ] [ Site Map ]