|
        
| |
Dale Rainwater Consulting offers high-quality computing experience including
the design, development and implementation of custom applications; website
design with an emphasis on search engine recognition strategies; systems
conversions; and instruction with desktop applications and technical topics
related to Microsoft Office products. These experiences have been
accumulated in New York City, NY, Northwest Arkansas and across our nation.
Also available is a chronological experience
list of Dale Rainwater Consulting services provided over the last fourteen
years to public entities, international companies,
finance and financial services
firms, manufacturing concerns, not-for-profit organizations and other
businesses. A detailed list
of functional experience
is as follows:
Design, develop and implement custom applications using Microsoft Office products, Visual Basic for Applications (VBA),
and Visual Basic (VB).
 | Designed, developed and implemented user-friendly
Microsoft Access database applications using Microsoft Visual Basic for Applications
(VBA) to:
 | analyze user requirements to create a conceptual
design of solution architecture |
| setup relational database tables and fields that
meet requirements of logical design |
| create Microsoft Access Forms with extensive use of
Microsoft Visual Basic for Applications (VBA) validation code used to
control data integrity and provide a simple, non-technical user
interface experience |
| create Microsoft Access Code Modules containing
complex Microsoft Visual Basic for Applications (VBA) code used to
develop procedures that enforce business rules and access data from
queries and tables, including Data Access Objects (DAO) and Structured
Query Language (SQL) |
| create Microsoft Access Reports that automatically
create Adobe Acrobat .pdf files |
| create Microsoft Outlook Email Messages that attach
Adobe Acrobat .pdf files and are automatically distributed |
| create simple button-push procedures that generate
new Microsoft Outlook Contacts and Microsoft Outlook Tasks |
| upload invoicing, costing (including contractor
accounts payable), and general journal data into financial accounting
systems |
| develop error-handling code which assists in smooth
transitions during critical procedures and events |
| write information manual used as a reference
resource by end users and database administrators |
| create database backup and restore utility
procedures |
| account for stock options, stock appreciation
rights, payroll timesheets, etc. |
|
| Design, develop and implement advanced Microsoft Excel
workbook applications, many containing VBA functionality, to:
| prepare month-end and annual close schedules |
| generate daily and monthly profit and loss statements |
| consolidate multiple ACCPAC and generic trial balances |
| convert accounting systems |
| account for stock options, stock appreciation rights, marketable
securities, investments, fixed assets, depreciation, earnings per share,
payroll and human resources information |
| prepare reports for cash management, budgets, forecasts and product
costing |
| modify chart of accounts |
| split principle and interest lease payments |
|
| Design and develop an advanced Microsoft Word document application containing
automation through VBA, to:
| perform file management of several related
Microsoft Word documents such as renaming files, checking for specific
file existence, notifying user of missing files |
| automate find and replace procedures in body text,
headers, and footers |
| refresh table of references, including table of
contents and table of figures |
| present user with various controls to assist with
printing options |
|
| Use
Microsoft Excel workbooks to reconcile and analyze accounts receivable, inventory,
discontinued operations, cash disbursements, intercompany accounts and
subsidiary ledger to general ledger. |
| Use Microsoft Word to assist with preparation of SEC Forms 10K
and 10Q. |
| Use Microsoft PowerPoint to create presentation of annual audited
financial statements to Board of Directors. |
|
Setup and design websites to be highly recognized by
search engines.
| Use Microsoft FrontPage to design, create, maintain and publish
various webs on the Internet. |
| Modify Microsoft FrontPage web pages using hypertext markup
language (HTML). |
| Universal Resource Locator (URL) design and creation. |
| Web hosting setup, which includes host account
management, maintenance, web statistic follow up, and email forwarding. |
| Web optimization, which includes developing
strategies for web page content and title, description and keyword tags. |
|
Convert database, accounting and information
technology systems.
| Setup
Platinum accounting software working with consultants: general ledger and
accounts payable. |
| Convert
payroll system from accounting package to CompuPay software. |
| Develop Microsoft Access queries and Microsoft Excel VBA procedures to
extract data from various Microsoft Access, Microsoft Excel and FoxPro databases. |
| Create Microsoft Access import procedures to automatically
bring Microsoft Excel data into an Microsoft Access database. |
| Modify
chart of accounts using Microsoft Excel. |
|
Instruct staff on using Microsoft Office applications.
| Provide
Microsoft Excel workbook instruction and assistance to accounting staff. |
| Train staff in use of custom user interface in
Microsoft Access database applications. |
| Provide Microsoft FrontPage instruction and training, which
includes the basics of creating a web, adding pages, managing shared
borders and navigation, establishing hyperlinks, saving the web, and
publishing the web to the Internet. |
|
Target markets of Dale Rainwater Consulting are New York City, NY and
Northwest Arkansas.
|
