Software Engineer Oracle

MICHAEL A. FORSYTH

**** ********* *** ******* *****, CA 90278

Home 310-***-**** Cell 310-***-****

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

SUMMARY

Database Administrator professional with a working knowledge of Oracle databases. Proven ability to

consistently deliver high quality work and meet scheduled targets. Focus on solutions and results and

providing excellence in customer satisfaction. Work great in a team environment as well as on

individual projects.

TRANSITIONAL SKILLS

Oracle Forms Oracle Reports SQL *Plus PL / SQL

Database Administration Systems Analysis Oracle 8i Oracle 9i

Oracle 10g ColdFusion 4.0 Crystal Reports Windows

UNIX Linux Red Hat Oracle

CLEARENCES

DOD Secret

•

SSBI with SCI access w/ counter intelligence poly

•

APPLICABLE EXPERIENCE

Northrop Grumman Space & Technology June 2003 – Dec 2010

MTSII (Software Engineer)

• Data analysis for procedure writing and hardware special processes for spacecraft and payload.

• Configuration management for procedure writing and hardware special processes for spacecraft

and payload.

• Linux Oracle 10g installations, database imports & exports. Incorporated database back-up scripts,

which run nightly exports, weekly hot backups, and monthly cold backups, using RMAN and cron

jobs. Writing dynamic SQL for database object creation and part configuration.

• Installation of Oracle Databases 8, 9i and 10g with developed scripts.

• Configuration Management – Database software builds through database updates and software

updates with developed scripts and processes.

• Test set DBA for GSD (Ground Systems & Development). Performing backups, exports, and

maintaining data integrity.

• CAPE DBA – Installation and Support, using Oracle Forms and Reports. Database admin: using

OEM. Incorporated DB back-up scripts, which run nightly exports, weekly hot backups, and

monthly cold backups. Writing scripts for ad-hoc reports. Writing dynamic SQL for database object

creation and extracting data from the database.

• CAPE DBA - For open and closed systems.

TRW Inc. November 1998 – June 2003

Software Engineer II

• Participated in the JIT upgrade to web-based internal ERP (Enterprise Resource Planning) System:

Developed and enhanced, receiving, inventory and BOM (bill of material) modules. Using Oracle

developer Forms 6.0 and Reports 6.0

Designed and enhanced EVIP (Executive Vendor Information Portal) a web-based portal so

•

managers could look at strategic information on purchasing habits. Using ColdFusion 4.0, HTML

and Crystal Reports 8.5

Designed and enhanced portals including eBilling FAQ’s / LDD (lost, damaged, destroyed). Using

•

ColdFusion 4.0 and HTML.

Maintained and Enhanced JIT ERP system in the areas of, Procurement, Inventories, Receiving,

•

Property, Accounts Payable, Setting up UNIX accounts, Print queues Add-hoc reports, Also

provided technical user support with interfaces and how to questions: Using UNIX, SQL, PL/SQL,

Oracle Developer 2000 Forms and Reports.

SQL PL/SQL: Writing add-hoc reports, table and database scripts.

•

Provided help and technical support for JIT and eBilling.

•

Participated in the JIT upgrade to Y2K compliance.

•

Ullico Insurance Group

Systems Support Representative (Internship) March 1996 – November 1998

• Designed and implemented inventory control database with the company’s remote users verifying

equipment and tag numbers. Using a Microsoft Access Database.

• Revised and implemented documentation for help desk assignment sheet, software installation, and

system upgrades.

• Installed Novell Netware 3.1 & 4.1. And N/T.

• Ran patch cables from Cisco Routers, repaired RJ45 network jacks, routed network cables and

move and set up phone connections.

DeVry Institute of Technology October 1995 – October 1998

Related Class Work (School)

• Projects completed in class included designing and building database and applications.

• Work included creating multi-table database, including many-to-one relationships, primary and

foreign keys.

• Application design required multi-block forms and reports Oracle Forms 4.5 and Reports 2.5. For

senior project.

• Classes taken included but not limited to: Oracle, SQL & PL/SQL, UNIX, C/C++, System Security,

COBOL

EDUCATION

Bachelor of Science in Computer Information Systems

DeVry Institute of Technology October 1998

TRAINING

NGMS Policies and Procedures

Software Peer review 2002, 2008, 2010

Oracle SQL and PL/SQL 2001

Hazard Communication

Computer workstation safety

Violence in the workplace

ESD/FOD Training

Contact this candidate