DFRae
DFRae
|
Dale RaeStrengthsTechnical Skills Summary
SummarySince 1987, Mr. Rae has been working on Oracle-based systems with mid to large sized companies in many roles including database administration, systems analysis, development, installation and upgrades. His personal experiences include project planning, system analysis, design, creation and implementation, as well as custom forms, reports and PL/SQL development. ExperienceOctober 2006 - Present
|
 | Providing business development, account management, pre- and post-sales efforts, project management and technical consulting expertise for the Seattle office of a full-service northwest based professional consulting organization focusing on Oracle products. |
| For largest systems integrator in the northwest, supporting the pre- and post-sales process around customers Oracle software needs. Provide on-site Oracle DBA consulting for customers as needed. |
| For startup company, first "Oracle" person hired. Tasked with architecting/designing their first Oracle databases as well as backup and recovery strategies. Three other DBAs hired later to round out team supporting Oracle Applications 11.0 (around 16 modules, RDBMS 8i), Agile, Siebel, ADC Singl.eView and many custom developed database applications. Sun Solaris, Oracle 8i/9i. |
| Database Administrator for new Seattle-based flight safety training and education company. Supporting several instances of Oracle 8i. Responsible for leading effort to establish backup and recovery strategies, database health monitoring, database naming conventions and standards. Helping to mentor staff DBAs. |
| Main post-production Applications DBA for Seattle-based cruise/tour company. Release 10.7 SC Prod 16.1, Financials, Sun Solaris. Performed database upgrade, Apps upgrade from Prod 16 to Prod 16.1, installed EDI Gateway, Cash Management, Alerts, applied many patches. Also provided Applications developer leadership for AP interface that takes vendor shipping receipts and matches them to custom purchasing system, then loads invoice information into Oracle AP for approval and payment (Forms 4.5, Reports 2.5, PL/SQL, Unix shell scripts) |
| Performed initial Oracle Applications 11 installation (software stack and database, clients) for a large Oregon-based manufacturing company. Financials and ERP on IBM RS600 server, AIX. Pre-production release of R11 on AIX so received little support from Oracle. One of the first Apps on AIX customers for Oracle. |
| Performed initial Oracle Applications 10.7 SC Prod 16.1 installation (software stack and database, clients) for a small manufacturing company. Financials and ERP on NT server, Compaq. One of the first Apps on NT customers for Oracle. |
| Provided technical Oracle leadership on financial applications team for large express freight company. Redesigned and implemented PL/SQL interface program that took PeoplSoft HR data and loaded it into Oracle Apps. Tuned weekly/monthly PL/SQL batch programs for custom international GL system (HP 9000). |
Provided technical support for sales staff during the process of representing Oracle Applications sales in the middle market as a member of the Oracle Applications Dealer Network. Supported full installation of Oracle Applications demonstration system on Sun Ultra II system.
After contracting through TRIAD Group, was hired and eventually became the Applications development lead supporting user community of 75 users in Oracle Financials and Manufacturing applications (AP, GL, PO, FA, RA, INV, WIP, MRP, BOM) on Sequent computer. Provided Support Team leadership, including assignment of task and development of priorities, project plans, cost estimates, and schedules.
Contractor to USWest NewVector Group (now AirTouch Cellular). Assisted in development and support of Oracle Financials and Manufacturing on Sequent computer.
Assisted client in an installation of an Oracle Financials system on a Sequent computer. (General Ledger, Accounts payable, Accounts Receivable) Provided technical leadership in converting legacy systems data into new Financials system and creating interfaces to other non-Oracle Financials systems. (SQL*Plus, PL/SQL, SQL*Loader, SQL*Forms) Created custom reports using Oracle Reports and added to Oracle Applications system. Lead effort to change current GL interface with payroll systems provider, ADP.
Analyzed, designed, created, implemented and maintained an Investor Relations system. For Sales and Marketing group, analyzed, enhanced and maintained several applications including a Marketing and Sales Rep forecasting and reporting system (MASR), National Accounts forecasting system and Leads system. MASR system is used by three divisions including International users in SpaceLabs offices around the world. Reports from system are used by hundreds of personnel from sales reps up to senior management. Was main contact for users. Trained many in use of system, including new international office users. Development was done using SQL*Forms, SQL*Plus and SQR on a DEC VAX under VMS. Also analyzed, designed, created, implemented and maintained a Senior Management Summary reporting system using MS Access and an ODBC connection to the Oracle database on the VAX mainframe.
Analyzed, designed, created and implemented a Personnel Archive application. Enhanced and maintained this system, and Materials Management, Retirement Vouchers, Records Management and Financial Reporting applications. Development was done using SQL*Forms, SQL*Plus, SQL*Report and SQL*QMX, with some work in COBOL using REXX and ISPF panels, on an IBM 9370 under VM. Was the lead over two Programmer Analysts' Oracle training and assignments.
| For on-board New Ship Systems, analyzed, designed, created, implemented, enhanced and maintained a Point of Sale system. Analyzed, designed, created and implemented Purchasing and Inventory Control applications. Analyzed and designed a Personnel system. Programs written in SQL*Forms (some with C exits), SQL*Plus, SQL*Report, and several reports written in C, on a Plexus minicomputer under Unix. Was backup to Project Manager. |
| Developed the company's pilot Oracle application. Analyzed, designed, created, implemented, enhanced and maintained the Cruise Tour Forecasting and Modeling application. Programs written in SQL*Forms, SQL*Plus and SQL*Report on an IBM PC under MS-DOS, then ported to a Plexus minicomputer under Unix, then ported to Novell database server system. |
Created, implemented, enhanced and maintained Transportation and Hotel Scheduling systems, including a database with 45,000 customers. The applications were developed on an IBM PC under MS-DOS with dBase III and Lotus spreadsheets. Also assisted non-technical users with the PC's operation and software.
1983 - Seattle Pacific University
| Bachelor of Science, Computer Science |
| Bachelor of Arts, Business Management |
| 2001 Vice-Chair, Webmaster, Northwest Oracle Users Group (NWOUG) |
| 2000 Vice-Chair, Webmaster, Northwest Oracle Users Group (NWOUG), Webmaster, Oracle Apps on NT SIG |
| 1999 Chair, Webmaster, NWOUG, Webmaster, Oracle Apps on NT SIG |
| 1998 Chair, Webmaster, NWOUG |
| 1997 Chair, Membership Director, Webmaster, NWOUG |
| 1996 Membership Director, NWOUG |
| July 1997 - Oracle7 Backup and Recovery Workshop, Oracle staff, Portland, OR. |
| June 1997 - Oracle7 Database Administration, Oracle staff, Bellevue, WA. |
| April 1996 - Oracle Manufacturing Technical Workshop, Oracle staff, Chicago, Ill. |
| April 1996 - Oracle Payables, Oracle staff, Bellevue, WA. |
| Oct 1995 - MS Project 4.0 class, Logical Operations, Bellevue, WA. |
| July 1994 - Oracle Reports 2.0, Oracle staff, Redwood Shores, Ca. |
| Aug 1992 - Comprehensive UDMS, Interactive Software staff, Pleasanton, Ca. |
| July 1991 - Oracle v.6 DBA, Architecture, Oracle staff, Bellevue, Wa. |
| May 1991 - Advanced Oracle For Developers, Oracle staff, Bellevue, Wa. |
| May 1990 - Oracle v.5 DBA, Oracle staff, Chicago Ill. |
| Aug 1989 - Unix Advanced Systems Programming, Boeing, Seattle, Wa. |
| June 1988 - Plexus P95 Hardware Training, Plexus Staff, Seattle, Wa. |
| April 1988 - Intro. to Unix and System Administration, Plexus staff, Seattle, Wa |
| Sept 1987 - Oracle for Developers, Oracle staff, Belmont, Ca. |
Send mail to dale@dfrae.com
with questions or comments about this web site.
|