Oracle 10G/11G, Toad, PL/SQL Developer, SQL-Loader, Unix Scripting

Robert Gillespie

*********@*******.***

734-***-****

P rofessional Overview

H ighly skilled technical professional who undertakes complex assignments, meets t ight

deadlines and delivers superior performance. Possess functional knowledge in the Health

and Wellness, Education, Automotive Manufacturing, Data and Marketing fields. Applies

to all assignments a strong knowledge of database structure, security requirements and

business acumen to design, develop and support enterprise wide systems and products.

Core Competencies include:

• Strong leadership of personnel and projects.

• Solid organizational planning and analytical skills.

• Capability to manage multiple assignments simultaneously.

• Effective problem solver who works well under pressure.

• Commit ted to professional standards, performance and customer service.

P rofessional Experience

Wellness & P revention (a Johnson & Johnson company)

2013–Present

Data In tegration Engineer within the Business Intelligence Operation & Maintenance

team, which oversees the data integrity/processing of health & wellness related biometric

systems data.

• Design Create and support reporting and data extracts for internal and external

customers, managers and end user.

• Perform data analysis and coding to create a comprehensive process reducing legacy

system run t ime from. 26+ hours to a 2 hour process and eliminating 18

p rocesses/tables to maintain.

• MS Office tools.

• UN IX scripting.

• Extensive use of TOAD to create/modify complex queries and SQL stored procedures

( Functions/Packages, etc.).

Environment ORACLE 10g/11g, Data Warehouse

Language Toad, PL/SQL Developer, UNIX, Pentaho

Eastern M ichigan University 2000 – 2013

Team Lead within the Enterprise Applications Systems Department which supports all

i nternal departments, processes and data.

• Responsible for the t ransition of a legacy system to Banner Software to support all

i nternal systems; including all student personal information (PII), H R, Finance,

Accounts Payable and Alumni.

Awarded t he Honorable Service Award from the Division of Student Affairs for

successful implementation.

• Directed the email conversion project designing and developing a process to extract

s tudent and employee information and validated email addresses. The end result

significantly reduced the count/cost of active email accounts and also increased

available storage.

Awarded CIO Honorable Mention Award, for successful implementation and meeting

aggressive timelines.

• Designed, developed and implemented an EMU Vendor audit processing and

reporting system. The program t racks of all changes to vendor data, and provides

audit reports to the Director of Accounts Payable. This program remedied the

p roblem of vendor data changes by person/groups outside the Accounts Payable staff.

• MS Office tools.

• UN IX scripting.

• Extensive use of PL/SQL to create/modify complex queries and SQL stored

p rocedures (Functions/Packages, etc.).

E nvironment SunSolaris, ORACLE 10g/11g

Languages PL/SQL Developer, SQL-PLUS, SQL-LOADER, UN IX,

X ML, Crystal Reports, Pro-C.

Cont ractor

Various contracts including Ford, Chrysler, RL Polk, CUNA Insurance

Designed, coded, implemented and supported medium to large programs.

U.S. NAVY

War Veteran with Honorable discharge

Education

Detroit Institute of Technology Computer Science

Contact this candidate