Paul Mcclure Email and Phone Number

· Oracle database creation, restoration, and backup. Implemented a new Oracle backup solutionusing archivelogs with scheduled logfile switches, and saving log files to disk and tape.Investigated the implementation of Oracle Streams for replication to different office locations.· Oracle PL/SQL procedures to automate data processing and email reports to management.- Oracle point-in-time restore, recovering lost business data- Oracle upgrade from 10g to 11g· Created VB.NET / Oracle database applications for data search, entry, and reportingneeds.· Created code routines for importing, merging, and exporting data between variousengineering applications. Created a simple .asp website for Intergraph PDS data reporting.Created Oracle views linking various application tables together to enable reporting on usefulengineering information.

· Implement Oracle based ERP infrastructure for local / WAN offices – Oracle servers, Citriximplementation· Executed significant ERP system upgrade, including Oracle upgrade from 8i to 10g· Expand rollout of MS SQL Server / SharePoint management reporting application from NorthAmerican offices to offices in Europe on different domains· Technical leadership role in a complex ERP data migration project for new acquisition.· Create custom Oracle PL/SQL API interface to existing ERP for creating orders via an externalweb interface. Create custom interface to port UPS shipment information to Oracle based ERPapplication.· Improve and manage all data backups and restores for SQL Server / Oracle / Exchange E-mail /shared file folders.

· Optimize project data usefulness through manipulation of data in Access with SQL code,Oracle database report creation utilizing SQL, and creation of databases for input and report.· Modify existing Access database forms adding functionality to semi-automate cable routingfrom power supply to load device using VBA and SQL code. Create an electrical bulk materialorder database, providing simple point and click search and populate methods.· Create VBA code procedures to manipulate data from various sources (flat text files,spreadsheets, Access databases).

· Oracle database custom reporting: Utilize SQL to status material orders from existing materialmanagement system’s Oracle back-end database.· Create a custom Access database for managing punch list activities from client.

· Create a new material management system in Access utilizing SQL with extensive codeprocedures to enforce complex business rules on the control of material from engineeringtakeoff to warehouse issuing.· Implement a new Oracle-based material management system, performing end-user training,custom reports, Oracle database creation, and program setup.· Supervise an Access based database management team of database programmers for allHouston office operations, including 3-6 separate natural gas fired power plant design teams.

· Modeled gas turbine plant performance for proposals using GTPro/GTMaster software.· Performed time critical proposal engineering support for management.

· Assisted in execution of performance testing on plant boilers and related equipment for a 1,050MW coal-fired power plant.