125 Locust Ave.
Larkspur, Cal 94939
(415) 924-4099                                                          Letter of Introduction
Email:      [email protected]
Website: Gries.Robert.org

I have six years of experience in database programming, Client Server, GUI design, and macro development using Visual Basic 5.0 Enterprise Edition, Microsoft Office 97 VBA, SQL Server 6.5, PC-Docs, Legal MacPac, Visio 5.0, Crystal Reports, ActiveX, Y2K Conversion, DHTML, Javascript, APIs, SDK, OLE, ODBC, Saros EDMS,
MS Agent Text to Speech and Wordbasic

U.C. Santa Cruz – BA Biochemistry, Honors, 1975 – CSF and UCSC Scholarships

Marcus & Millichap contract,                                                          Palo Alto, Oct. 98 – Jan. 99

q  Microsoft Office Solutions Programmer – created Microsoft Word 97 Wizards to produce all company contracts. I participated in defining business requirements to build strong technical designs for generation of legal contracts. Hypertext help is provided for all data fields via the Office Assistant and/or Microsoft Agent 2.0 Voice synthesis for usability.
Software: Microsoft Word 97, SQL, Microsoft Agent 2.0 ActiveX technology

3Com Corporation contract,                                                           Santa Clara, Nov. – Dec 98

q   Microsoft Excel VBA Developer – translated existing Lotus 1-2-3 macros for engineering analysis to Excel VBA 5.0 code standards. Defined technical design standards for analysis of engineering data. Created user dialogs, easy list selections, added editable menus for all macro functions and provided hypertext help via the Office Assistant. Software: Microsoft Excel 97, Excel Object Model

Graham and James LLP                                                       San Francisco, Jan. 97– Sept. 98

q   Microsoft Office Solutions Programmer – Visual Basic 5.0 Enterprise Edition, Word, Excel and Access VBA as well as WordBasic. Created SQL Server and OLE based distributed multimedia user solutions. Upgraded firm from Word 7.0 to Word 8.0 VBA with The Legal MacPac and PC-Docs 3.7. Created four firmwide database applications including SQL Server support for Address Book information. Software: Visual Basic 5.0 Enterprise Edition, Microsoft Office Developer Ed. 97, SQL Server 6.5, PC-DOCS Docs Open 3.7, Legal MacPac, Apex True DBGrid and Windows 95/NT

Fluent Traveler personal project,                                           Larkspur, May 97– Nov 98

q   Database Developer – Created multimedia foreign language translation application for French, German, Spanish and Italian languages. Employs 2000 phrases and a 20,000 word dictionary in each language with full sound support. Software: Visual Basic 5.0, Apex True DBGrid, MS Access

Elexsys International, Inc. contract,                                 San Jose, August 96–Dec. 96

q   Database Developer – Designed a Visual Basic, Access and Excel business information system to collect sales forecasting data from the field. Data is combined into corporate reports in MS Access. Sales Reps can also export their monthly data to a familiar Excel spreadsheet format. This improves the original worksheet data processing scheme by eliminating error prone performance links. Created an Access reports interface, and custom reports including a crosstab report with dynamic columns that is formatted entirely in Access Basic. Software: Visual Basic 4.0, TrueGrid Pro, Microsoft Access, Word 6.0, Excel 5-7, Windows 95 and RoboHelp 2.6

Heller Erhman White & McAuliffe LLP contract,                  San Francisco, Sept. 96–Dec. 96

q   Microsoft Office Solutions Programmer – Created a custom document management system based on the PC DOCs legal document management API. Debugged and polished existing code base and added new features. Redesigned corporate logo and added desktop publishing values. Created a Visual Basic Internet address book application. Attorneys can directly access client web addresses and email links using Internet Explorer as an ActiveX control on a VB form. Software: Word 6.0, Internet Explorer 3.0, Visual Basic 4.0 32-bit

Pacific Gas and Electric Co. contract,                                      Oakland, Nov. 95–July 96

q   Database Developer – created three turnkey database applications with custom reports and charts: a Healthcare benefits database, a scanned document database, and an Access reports front end for the Saros Electronic Document Management System (EDMS). Full featured security system with login, English language query interface, and Windows help docs. The Industrial Relations scanned document database included OLE hooks to MS Word. I then wrote elaborate WordBasic macros to automatically format approximately 2000 scanned documents for the EDMS and permit executive tracking of document origin and summary information in my database. Software: MS Access 2.0, SQL, ADT, API, ODBC, VB 4.0, Word 6.0, Excel 5.0 and RoboHelp 2.6

Pacific Gas and Electric Co. contract,                          San Francisco, Sept. 95–Oct. 96

q   Microsoft Excel VBA Developer – created macros for generating 500+ charts from pivot table data. Automatically generated reports with charts for all California cities energy conservation programs. Met the client's need for complex charts within the project deadline and improving overall accuracy through automation. Software: Microsoft Excel 5.0 VBA and Word 6.0

Wells Fargo Bank contract,                                                     San Francisco, Jan. 95–June 95

q   Microsoft Excel Developer – created worksheet pricer model containing two data entry "Wizards" and context-sensitive Windows help. Converted 1500+ Lotus and Supercalc worksheets to Excel 5.0 format and translated macros to Visual Basic for Applications. Automatically formatted most workbooks using my own VBA procedures. Designed an Excel worksheet template Wizard.   Software: Microsoft Access, Excel

Pacific Gas and Electric Co. contract,   San Francisco and San Luis Obispo, March–May 94

q   Microsoft Office Solutions Programmer – designed WordBasic Wizards to automatically create reproducible reports about power generating facilities for Federal agencies. Software: Excel 5.0 and Word 6.0

q   Fluent Traveler 4-language translator application. Microsoft Access translator application

q   Microsoft Agent (L&H engine) voice systhesis application integrated with Microsoft Word VBA

q   Excel Template Wizard published in The Excel 7.0 Bible by John Walkenbach, IDG Books

125 Locust Ave.
Larkspur, CA 94939
February 1, 1999
Website: Gries.Robert.org
Email:     [email protected]

Dear Sirs:

In my current position with a large national real estate firm, I created Microsoft Word 97 Wizards to produce all company contracts. I participated in defining business requirements to build strong technical designs for generation of legal contracts. Hypertext help is provided for all data fields via the Office Assistant and/or Microsoft Agent 2.0 Voice synthesis for usability.

I independently designed a multimedia Visual Basic application for rapid translation of useful English phrases for travelers into four major languages--French, Spanish, German and Italian. The program includes sound support for translations and contains 2000 phrases and a 20,000 word dictionary in each language.

Recently, I also developed voice-synthesis integration for Microsoft Word 97 document text and hyper-voice help for document Wizards using Microsoft Agent 2.0 ActiveX technology. These would also be excellent in a multilingual environment and for handicapped users. I plan to soon add voice-synthesis support for French, German and Spanish speakers, similar to my Fluent Traveler application.

With the major international law firm, Graham and James in San Francisco, I designed numerous databases and Visual Basic applications. There, I helped the firm complete its upgrade from MS Word 95 to Word 97 VBA and the Visual Basic version of the Legal MacPac for PC-DOCS. The firm's Address book data is accessed through Microsoft SQL Server 6.5 and RDO using a Visual Basic 5.0 Enterprise Edition application that I designed.

On previous contract assignments I created a complete Visual Basic, Access and Excel business information system, from concept to coding and error proofing. I used RDBMS design concepts in converting the client Network Administrator's Access reports database to offer a data collection front end written in Visual Basic; and the TrueGrid Professional ActiveX data control to implement live previewing and editing of data. Vital sales forecasts can now be automatically entered into executive reports on a timely basis, and a single Access Basic procedure replaces the tedious editing of approximately 25 spreadsheets from sales representatives every month. Sales reps are able to view their monthly data in a familiar Excel spreadsheet format via OLE export from my Sales Booking application. Monthly data is automatically compressed and mailed to corporate headquarters. This improved the original worksheet data processing scheme by eliminating error prone performance links in the system and reducing the workload of CNE Administrators.

see my VB Booking Sales Application

Prior to this I was engaged in database development for eight months at PG&E where I completed three turnkey MS Access applications. First I designed a document management database with OLE server links to Word for Windows on desktop systems. Then I created a Healthcare Benefits database with custom reports and charts, and designed a reports front end for the Saros Electronic Document Management System (EDMS) running on Microsoft SQL Server. I designed unique alias-type fields from memo field data which allow HR Managers to do independent analysis and reporting of critical company-union relations through the existing EDMS system.

Managers have the convenience of publishing their own reports in Microsoft Word, or examining details of the underlying records and queries in Excel with custom printing scenarios I provided via Excel VBA. I also created an English language database interface. As you may know, this allows users the flexibility of retrieving answers about data from questions formulated in ordinary language. The interface also creates customized charts without user programming. Full featured security with user login—somewhat difficult to implement in Access—is provided, ensuring the safety of vital company data.

For for additional information and examples of my work, please visit my website at:  Gries.Robert.org

Sincerely,

Encs.: Resume and References

Robert E. Gries – Professional References                                                   2/99