Build and administer Oracle database systems in client-server and/or Web-based environments.
| RDBMS |
10g, 9i, 8i, 7.3, 7.2, 7.1, 6.0, 5.3 |
| Financials/E-Business Suite |
11.0 |
| Forms |
10g, 9i, 5.0, 4.5, 4.0, 3.0, 2.3 |
| Libraries |
|
| Menus |
(Forms 5.0, 4.5, & 4.0), 5.0 |
| Reports |
10g, 9i, 3.0, 2.5, 2.0, 1.0 |
| SQL*Loader |
|
| PL/SQL |
10.1, 9.2, 8.1, 8.0, 2.3 |
| CASE -- Designer2000 |
1.3; 6.0, 5.1 |
| Net Manager, Net8, SQL*Net |
10.0, 9.0, 2.0, 1.0 |
| SQL |
10.1, 9.2, 8.0, 3.3 |
| Designed, developed, implemented, and documented database security solutions. (Oracle 9i, 10g; Unix) |
| Installed databases for asset management system. (Oracle 10g; Unix) |
| Installed and upgraded databases for Web-based systems. (Oracle 8i, 9i; Windows) |
| Installed and upgraded databases for client-server systems. (Oracle 6.0, 7.0; UNIX, VMS) |
| For a staff management system, helped administer the database. (Oracle 7.1; UNIX) |
| Assisted database administrators determine database and tablespace problems. (Oracle 7.0, 8i, 9i) |
| Tuned a database and provided suggestions to system administrators regarding improvements for operating-related tuning issues. (Oracle 7.1, 8i, 9i) |
| Exported and imported databases both locally and across networks. (Oracle 6.0, 7.0, 8i, 9i) |
| Created and modified database-level stored procedures and triggers. (PL/SQL 1.0, 2.0, 8i, 9i; Oracle 7.0, 8i, 9i; UNIX, VMS, Windows) |
| Enhanced a manufacturing data entry/reporting system by creating and modifying tables and indexes and eventually creating or modifying corresponding front-end applications. (SQL*Forms 3.0; Oracle 7.0) |
| For a database system installed in several states, assisted in administering the database. (Oracle 7.0) |
| Upgraded property/asset management data from 4.x to 5.1 or 5.2 (Maximo; Oracle 8i and 9i; Windows) |
| Developed reports for property/asset management system (Actuate 5.0, 7.0) |
| Worked on a project for a company that analyzes and predicts consumer purchasing habits. Work involved entire software life cycle process and creating Web-based reports (Sun Solaris 5.7, Oracle 8i, PL/SQL, SQL*Loader, and ColdFusion 4.0) |
| Worked on several projects for a wireless telecommunications company using Oracle Financials application software (including accounts receivable and payable, purchasing, assets, human resources, inventory, payroll, projects, and corresponding Web-based products) |
| Created inventory management/tracking system (Forms 4.5, Reports 2.5, Oracle 8.0 database triggers) |
| Recreated reports from Microsoft Access-based system (Reports 6.0) |
| Administered reports and user accounts (Discoverer 3.1) |
| Modified database programs to be multi-lingual (procedures, functions, and triggers) |
| Enhanced Financials expense reporting functionality (database procedures) |
| Installed software (Oracle Forms, Reports, SQL*Net) |
| Assisted database administrator in solving various database issues |
| Helped users transfer files from Linux-based machines |
| Created a report listing employees and supervisors (SQL*Plus) |
| Created data entry screens, menus, and reports in a client-server environment for an enterprise-wide application. (Oracle 7.3; Oracle Forms 4.5, 5.0; PL/SQL 2.3; Oracle Reports 2.5; MS-Windows 95, NT; UNIX) |
| Enhanced a manufacturing data entry/reporting system by creating and modifying tables and indexes and eventually creating or modifying corresponding front-end applications. (SQL*Forms 3.0; Oracle 7.0) |
| Created data entry screens and reports in a client-server environment for an enterprise-wide application. (Oracle Forms 4.0; PL/SQL 2.0; Oracle Reports 2.0; MS-Windows, UNIX) |
| Customized data entry screens for Oracle's Manufacturing Application product. (Oracle Forms 4.0; UNIX) |
| Enhanced an in-house financial application by developing data entry screens and reports in a client-server environment. (Developer2000; MS-Windows, UNIX) |
| Created data entry screens, reports, menus, and libraries. (SQL*Forms 3.0, Oracle Forms 4.0; SQL*ReportWriter 1.0, Oracle Reports 2.0; SQL*Menu 5.0; Oracle 7.0) |
| Created and modified data entry screens for a manufacturing system. (SQL*Forms 2.3; 'C'; Oracle 5.3; UNIX) |
| Converted data entry screens from one version to another version. (SQL*Forms 3.0, Oracle Forms 4.0; IBM-compatible) |
| Converted a financial application from one platform to another platform. (Oracle Forms 4.0, 4.5; IBM-compatible, Macintosh) |
| For a database system installed in several states, taught developers how to create data entry screens; created and modified data entry screens. (SQL*Forms 3.0; Oracle Forms 4.5) |
| Developed a database application which determined skill level of employees in assigning tasks commensurate with their abilities. (FoxPro) |
| Enhanced a mail-merging system for a private organization. Created a employer-tracking system for a recruiting agency. (dBASE III Plus, IV) |
| Supported developers working on a staff management system. (Oracle Forms 4.0) |
Both provided access to and taught developers the use of various Oracle tools. (Book, Explain Plan, TKPROF) |
Taught developers how to create screens for a human resources and accounting application. (Oracle Forms 4.0) |
Taught employees operating system concepts, database system concepts, and development strategies. (UNIX; Oracle 5.3) |
Supported developers working on a management system in a client-server environment. (Oracle Forms 4.0; MS-Windows) |
Miscellaneous
| Created and installed military-based database security solutions. (Oracle 10g; Unix) |
| For a consumer analysis and prediction company, created Web-based menu and report (ColdFusion 4.0) |
| For a medical data warehouse system, loaded data from flat files, checked data validity, and reported results. (SQL*Loader; 'C'; Oracle 7.0) |
| For a manufacturing system, uploaded and downloaded data from personal computers to a minicomputer, facilitated data flow between departments, and manipulated data through other software application programs. (SQL*Loader; dBASE III Plus) |
| Created scripts to selectively upload data via a desktop database. (SQL*Loader 1.0; Oracle 6.0; FoxPro 2.0; dBASE III Plus; UNIX) |
| Created programs to interface between different database systems. (C++ ; Oracle 6.0, DB2) |
| Created programs to interface with a different manufacturer's database. (Gupta-SQLBase, Oracle 6.0) |
| Worked on several database systems (on different platforms) ranging from a software toolbox to a general ledger accounting system. (FoxPro, FoxBase; Macintosh, IBM-compatible) |
| Installed hardware and software systems. (IBM-compatible) |
| Wrote shell scripts as a front-end to data entry screens. (SQL*Forms 3.0; 'C'; UNIX) |
| Interfaced with several departments including Manufacturing, Quality, and Material Control to train data entry personnel and to facilitate efficient resource usage. |
| Was Management Information Systems Department Manager. |
| Performed general computer hardware and software troubleshooting. |
| Developed and administered World Wide Web pages for a non-profit organization. |
Education
| Bachelor of Science, Computer Science - 1989 - California State University, Long Beach |
| Astro-physics - 1981 to 84 - University of Colorado, Boulder |
Certificates
Links
of Page
Return
