Dale Rainwater Consulting Chronological Experience

	*Dale Rainwater Consulting*

Dale Rainwater Consulting offers over fourteen 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

Specialized, Out-Patient Surgical Practice; Muskogee, OK

April '08 – Present, Microsoft Office Developer.

	Designed an enhanced workflow to maximize productivity of a small medical office.
	Developed and implemented custom Microsoft Access database application to handle automatic calculation of medical procedure percentage results.
	Patient scheduling data, from an outside service, is collected from Microsoft Outlook email messages and subsequently uploaded into Microsoft Access.
	Patient information is populated into Word documents to automatically create patient correspondence and records in hardcopy and softcopy formats.
	Created Microsoft FrontPage online forms that collect patient data that is automatically forwarded to Microsoft Outlook email messages and subsequently uploaded by Microsoft Access to minimize end-user data entry.
	Trained staff on proper Microsoft Access data entry techniques and custom application's features.

Commercial Truck Driver Recruiter; Rogers, AR

April '08 – Present, Microsoft Office Developer.

	Gathered requirements and features for an improved design of a Microsoft Access database that tracks commercial drivers license (CDL) truck drivers' recruitment and employment procedures.
	Developed Microsoft Access database that manages driver information from an easy-to-enter-and-access multi-tabbed form. (Designed driver form for manual end-user head-set, on-the-phone data entry and automatic import from an Outlook email message created from a FrontPage online application.)
	Truck driver data is automatically analyzed, compared and classified based on matching criteria from each active and hiring trucking company's predefined qualifications criteria.
	Truck driver employment information is populated into Word documents for automatic creation of employment applications from several matching-criteria trucking companies.
	Matching evaluation functions and procedures are based on criteria such as truck driver's home state, driving record, driving experience, driving education, driving violations, driving accidents, etc.

Valet and Concierge Service Provider; New York City, NY

December '08 – Present, Microsoft Office Developer.

	Developed Microsoft Excel automation procedures to modify existing archived Excel workbook data into a revised and updated format.
	Created Microsoft Excel execution procedure to automatically modify weekly accounting-related payroll data maintained in an Excel workbook.

Christian-Religion, Non-Profit Church; New York, NY

June '98 – September '08, Temporary Accounting Controller / Microsoft Office Developer / Trainer.

	Provided controllership functions to not-for-profit religious organization.
	Acted as liaison to auditors during annual audit engagements.
	Developed, 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, depreciation, general ledgers and combined financial statements.
	Developed, designed and implemented Microsoft Word document application to automatically update the annual notes to the financial statements.
	Setup procedures for repetitive tasks, such as monthly investment activity and monthly accounts payable disbursements, to be automated using import and export functions in NewViews.
	Trained staff on proper accounting procedures to allow less dependency and greater independence for annual financial reporting.

Computer Training Center; Rogers, AR

July '06, February '08, May '08, Microsoft Office Instructor.

	Created custom training class for major retail firm based on Microsoft Excel workbooks and related automation programming of Visual Basic for Applications (VBA).
	Provided classroom instruction for intermediate to advanced Microsoft Excel and Microsoft Word with an introduction to Visual Basic for Applications (VBA).

Computer Training Entrepreneur and Retail Supplier Consultant; Lowell, AR

March '08 – May '08, Business Consultant.

	Performed business creation and setup consulting services.
	Created FrontPage websites to market business on Internet and provide clients and customers an online resource of business service information.
	Recommended several business approach strategies to maximize potential for business success.

Technical Document Lawyer; Van Buren, AR

February '07 – October '07, Microsoft Office Developer.

	Modified existing Microsoft Access database to automatically populate data into technical legal documents created using Microsoft Word.
	Designed and developed procedures to allow end-users to create and build Microsoft Word document paragraphs used to build complete, reusable document templates that include database-populated fields, specific text / paragraph formatting and manual-entry stop points.

Technical Multi-Document Processor; Santa Barbara, CA

July '07 – August '07, Microsoft Office Developer.

	Created an easy-to-use Microsoft Word application that produces a loan document package by populating over 100 technical-document data fields in about 100 Microsoft Word documents.
	Developed high-productivity procedures automating file maintenance, sequential multi-document printing, finding manual-task locations and document cleanup.

International Consumer Health & Medical Products Retailer / Manufacturer; Norwalk, CT

December '05 – October '06, Microsoft Office Developer.

	Designed and developed a Microsoft Access database that allows a Project Manager to more efficiently track an unlimited number Microsoft Project files, including a single Resource Pool file.
	Created procedures in Microsoft Access that interact with Microsoft Project by downloading and uploading data about resources, tasks and assignments.
	Developed procedures in Microsoft Access that interact with Microsoft Outlook by sending and receiving text-based email messages that handle task assignments, start and end date modifications and percentage of completion updates.
	Designed procedures in Microsoft Access that track exceptions for accepting and declining task assignments, updating percentage of completion and modifying tasks start and end dates.
	Communicate periodic reminders utilizing automated email messages using Microsoft Outlook within Microsoft Access.

International Consumer Candy Products Retailer / Manufacturer; Bentonville, AR

October '05 – July '06, Microsoft Office Consultant.

	Assisted company management and independent service provider in developing a requirements / features list and an overall Microsoft Access database design to handle retail-based data and provide meaningful retail information.
	Continually assessed Microsoft Access' capabilities and limitations throughout project.

Equity Investment Holding Company; New York, NY

August '05 – July '06, Microsoft Office Developer.

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

Food Service Entrepreneur; Rogers, AR

April '06 – May '06, Temporary Accounting Consultant.

Briefly assisted food-franchise entrepreneur hopeful with developing an appropriate approach for creation of meaningful financial budgets and projections as part of an overall business plan.

Technical Document Independent Contractor; White Plains, NY

May '06, Microsoft Word Instructor.

Provided one-on-one Microsoft Word training to owner by presenting more effective Microsoft Word techniques and offering suggestions to improve productivity in document creation that utilizes more advanced features of Microsoft Word.

Fuel Transport Distributor; Fort Smith, AR

April '06, Microsoft Excel Developer.

Performed troubleshooting and correction of design flaws within a Microsoft Excel workbook that tracks customer fuel consumption from sales and customer fuel inventory by grade to determine the timing and volume of fuel transport shipments.

International Finance and Accounting Recruiter; New York, NY

April '03 - January '06, Microsoft Office Developer / Application Trainer; July '02 – September '02, Interim Controller.

	Train staff using custom applications developed with Microsoft Excel and Microsoft Access.
	Designed, 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.
	Provided interim controllership functions and temporary accountant services for an international executive recruiting firm’s New York City office.
	Designed, developed and implemented Microsoft Excel workbook solutions using advanced skills in Microsoft Visual Basic for Applications (VBA) to account for accounts payable, bank reconciliation, check writing, permanent and temporary payroll, temporary margin calculation and data uploading from Microsoft Excel to CODA Open financial accounting software.

Regional Bank Lawyer; New York, NY

November '05 – December '05, Temporary Accounting Services.

	Entered fiduciary bank account data by scanning bank statements into Microsoft Excel using optical character recognition.
	Hired independent contractor to reconcile bank statements to original-entry accounting records.

Technical Compliance Document Publisher; Englewood, CO

February '04 – November '05, Microsoft Office Developer.

Designed 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.

Public Water Works; Lowell, AR

October '05, Microsoft Office Developer.

Created a Microsoft Access database to document and report frequent water sample results.

International Information Provider; New York, NY

June '05 – October '05, Microsoft Office Developer.

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

Consumer / Commercial Carpet Retailer and Software Developer; Fort Smith, AR

April '05 – June '05, Microsoft Office Consultant / Trainer.

	Installed Microsoft Visual Basic software onto company computers.
	Provided Visual Basic for Applications (VBA) training to owner and outside software consultant.
	Modified poorly written, non-standardized Visual Basic for Applications (VBA) code from a statistically specialized, technical-discipline textbook.

Medical University; Newark, NJ

September '02 – August '03, Microsoft Office Developer.

	Develop 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.
	Sequentially processed series of Microsoft Access queries using Macros.
	Cross reference and map database fields from 8 universities' original data sources to destination Microsoft Access database tables.

Investment Bank; New York, NY

July '02, Assistant Microsoft Office Trainer.

Provided Microsoft Excel 97 training to 45 Financial Analyst.

Internet Investment Holding Company; New York, NY and Los Angeles, CA

February '99 – January ‘02, Temporary Accountant / Microsoft Office Developer.

	Assisted with preparation, review and editing of SEC Form 10K and 10Q, including footnotes, using Microsoft Word, Microsoft Excel and Adobe Acrobat.
	Performed 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.
	Researched accounting issues using resources from SEC, FASB, APB and AICPA.
	Recommended accounting treatment regarding accounting issue research.
	Designed, 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.
	Designed, developed and implemented a Microsoft Access database for stock option and stock appreciation right plans.
	Setup Platinum accounting software working with consultants: general ledger and accounts payable.
	Performed 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.

Investment Bank; New York, NY;

November '00 – June ‘01, Microsoft Office Developer.

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

Internet and Creative Arts Firm; New York, NY

June '00 – September ‘00, Temporary Accountant / Microsoft Office Developer.

	Assisted with chart of accounts preparation and modification for ACCPAC Accounting Software using Microsoft Excel.
	Designed, 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).

Advertising Agency; New York, NY

September '99 – October '99, Temporary Accountant.

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

Electrical Controls Manufacturer; New York, NY

August '98 – August '99, Temporary Accountant / Employee Accountant.

	Provided Microsoft Excel workbook training and assistance to accounting staff.
	Designed, 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.
	Converted payroll system to CompuPay software.

Top-Ranked French Restaurant; New York, NY

May '98 – June '98, Temporary Controller.

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

Insurance Company; New York, NY

April '98 – May '98, Temporary Accountant.

Assisted with preparation of an insurance industry regulatory report.

Accounting Regulation Organization; Jersey City, NJ

March '98 – April '98, Temporary Accountant.

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

Annuity Finance Company; New York, NY

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

	Provided controller functions to an entrepreneurial high-growth finance firm.
	Hired and trained temporary and permanent accounting staff to perform day-to-day accounting tasks.
	Prepared and managed cash flow and cash forecast reports using Microsoft Excel and Peachtree.
	Reconciled general and subsidiary ledger accounts, cash, accounts receivable and accounts payable using Peachtree and Microsoft Excel.
	Performed day-to-day accounting tasks and functions using Peachtree.
	Organized accounting office, including new filing system, in a high-turnover environment.

Legal Document Imaging Company; New York, NY

July '97 – November '97, Temporary Controller.

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

Medical Imaging Company; New York, NY

May '97 – July '97, Temporary Accountant.

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

Specialized, Community Newspaper Publisher; Cross River, NY

April '97 – May '97, Temporary Accountant.

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

Rubber Manufacturer; Fort Smith, AR

September '96 – November '96, Temporary Accountant.

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

Default Mortgage and Finance Company; Little Rock, AR

November '94 – February '95, Interim Controller.

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

Dale Rainwater's previous employment as an accountant was in New York City and Arkansas.

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