Robert W. Gleason
1115 Sara Lane 630-983-8185
Naperville, IL 60565 [email protected] E-mail
SUMMARY
A Certified Oracle Database Administrator having spent the last 18 years in data processing, and the previous 4 years in accounting. Technical experience includes data base administration and data analysis, project management, systems analysis and design, coding, and support.
A proven professional with strong interpersonal skills, a logical thought process, and excellent troubleshooting skills.
EXPERIENCE
Kelco Consulting Inc., Naperville, IL April 1999 - Present
Database Administrator (Summer 02 - Present)
- For a major quick service restaurant company, managed and consolidated 15 to 20 Oracle databases running on 11 different servers onto 4 servers. These included production and development databases running various releases of Oracle's relational database, as well as Oracle Express. Migrated some of the databases to new releases. Installed various releases of Oracle's relational database software and Oracle Express on the new servers. Worked the corporate backup strategy onto these new servers. Cloned production databases to serve as development databases. Supported various production and development databases by monitoring and tuning the performance of the databases, creating new and modifying existing objects, and monitoring the security of the databases.
Database Administrator (Winter 00 - Spring 02)
- For a major insurance company, supported up to 25 Oracle databases. Installed Oracle 8i and migrated 7.3.4 databases to 8i. Created new instances of Oracle as needed to support development, training, and production requirements. Created snapshots to replicate data from one database to another. Worked with developers and end users to troubleshoot database issues. Tuned databases as needed. Refreshed training and development databases with baseline data to accommodate scheduling requirements. Developed, modified, and applied new database releases to remain in sync with application releases.
Database Administrator (Summer 99 - Winter 00)
- For a major communications company, supported up to 10 Oracle databases running various releases of Oracle 7 and Oracle 8. Installed Oracle software on new servers, and created new instances of Oracle on new and existing servers. Tuned new and existing databases to maximize performance. Created backup and recovery strategies for all of these databases, and created scripts to automate these backups. Generated miscellaneous reports from these databases using shell scripting, SQL, and PL/SQL.
Database Administrator/Data Analyst (Spring 99 - Summer 99)
- For an investment services company, modified the logical database design of a Web-based data warehousing application using ERWin. Developed the physical database using Oracle 8 from this logical model. This application served as a reporting vehicle for commercial clients involved in the trading of futures and options. Created hundreds of database objects to support this application. Tuned the application by writing stored procedures and partitioning large tables. Coordinated the conversion of data from NT to UNIX servers.
McDonald's Corporation, Oak Brook, IL January 1980 - March 1999
Database Administrator/Data Analyst (May 97 - March 99)
- Using ERWin, developed approximately one half of the logical and physical design of an Oracle database for a restaurant site development system used by hundreds of clients nationwide. Created approximately 400 database objects in a system consisting of nearly 800 database objects. Tuned the objects to maximize performance. Continue to support further development to the system by creating additional objects or modifying existing objects to accommodate enhancements.
- Developed the physical design of an Oracle database used to track people and their comments as they attend panels used to taste test new products. Built the data definition language (DDL) to create the 50 database objects used in the system, and turned the DDL over to an external company hired to write the application. Monitored performance issues encountered during the development phase. Created the database objects internally when the application was brought in-house for system testing. Tuned the objects to enhance performance.
- Evaluated the Oracle database used in a customer satisfaction software package, determining how it differed from our shop standards and areas of potential problems. Implemented the database, which consists of almost 200 database objects. Modified many objects to enhance the performance seen by the users of the application. Converted the data from the old system to the new system.
- Developed the logical and physical design of an Oracle database used to track and inventory the kitchen equipment used in company owned and franchised restaurants. This database is used by 50 regional offices to coordinate the purchase of new kitchen equipment as part of a new company initiative. Created the database objects used in the system. Fine tuned the objects to maximize performance.
- Developed physical design for a system used to store data related to the CAD drawings for individual restaurants. Worked independently to create the 50 database objects that made up this system. Converted the data from the previous system to the new system.
- Evaluated several tuning tools for Oracle databases. Recommended the purchase of Precise/SQL as the tool of choice to departmental management. Recommendation resulted in the purchase of the product.
Project Manager (August 90 - May 97)
- Managed a team of employees and consultants rewriting the corporate general ledger system. The system was written in COBOL, using APS, with DB2 and CICS. It interfaced with other systems, including some on a Tandem platform, and applications that ran on the ISP (in store processor) in each of our company owned restaurants.
- Managed a team of employees and consultants developing and enhancing application software that ran on the ISP (in store processor). The ISP ran in each of our company owned restaurants and several thousand franchised restaurants. The software was written in C++ using a UNIX operating system and an ISAM database. Managed the control of releases that were sent to individual restaurants electronically or via tape.
Programming (August 84 - August 90)
- Analyzed, designed, coded, and supported software for new development and enhancements to existing applications. These applications included real estate tax systems, treasury systems, fixed assets, general ledger, corporate benefits, payroll, marketing, etc. These applications were written in COBOL using IMS DB/DC.
- Made code modifications to a purchased payroll package used by Canadian offices and restaurants. Coded standalone programs which interface with the package. Supported the system remotely for our Canadian clients. The system was written in COBOL using IMS DB/DC.
Accounting (January 80 - August 84)
- Worked 4 years in various accounting disciplines. Generated profit and loss statements for individual company owned restaurants. Supported regional accounting offices in their efforts to provide service to the regional offices and restaurants in their area. Supervised a staff of accountants setting up depreciation schedules for newly purchased fixed assets.
TECHNICAL SUMMARY
Operating Systems UNIX, NT, MVS, MS-DOS, MS-WINDOWS
Software and Languages Oracle 7x/8x, DB2, Platinum Data Repository,
Oracle's Enterprise Manager, ERWin, Designer/2000,
SQL, PL/SQL, COBOL, MS Office, Shell Scripting, Lotus Notes,
MS Project, SQL*Plus, Precise/SQL, JCL, VSAM
EDUCATION
B.S. - Business Administration, University of Maine May 1978
M.S. - MIS, Northern Illinois University May 1987
CERTIFICATIONS
CPA Certification 1984
Oracle DBA Certifications
Oracle 7.3 1998
Oracle 8 2001
Oracle 8i 2001