A LAN  F REDERICK  D ROEGE

107 South Deerwood Avenue ♦ Orlando, Florida 32825 ♦ (407) 823-8094 ♦ mail@alan-droege.com

Summary of Qualifications

Experienced and self-motivated IT professional utilizing proven skills in database administration and programming combined with strong leadership abilities to optimize performance of systems and applications. Analytical and creative problem solver with an outstanding record of identifying and implementing process improvements and cutting-edge technology solutions that maximize efficiency and minimize expenses. Results-focused individual able to work well independently or as a key team member to achieve objectives in fast-paced environments.

Technical Skills

Oracle DBA COBOL JCL
TOAD Starbase Versions Burton TLIB
CICS C Visual Basic
Delphi HTML MS-DOS
Digital UNIX Sun Solaris Windows 9.x
Windows NT PL/SQL SQL
Oracle Forms/Reports Designer 2000 SQLPlus OEM Oracle Enterprise Manager
Oracle Procedures Builder Btrieve PERL
CGI HP-PCL5 PhotoShop
MS Word XML JAVA
Macromedia Homesite

Professional Experience

Orange County Property Appraiser -  Orlando, Florida 1991 - 2002
Database Administrator/Analyst 1998 - 2002

Chosen to install, fine-tune and maintain multiple Oracle 7.x and 8.x databases on Sun Solaris, DEC Alpha and Windows NT platforms for this county government agency employing 120. Accountable for data integrity and conversion across four databases including GIS, CAT, Navigator document imaging and a public Web server, each housing between five and 15 GB of information. Monitor databases using Oracle Enterprise Manager and custom SQL scripts. Export/import Oracle data for backups and migration using SQL*loader.

  • Supplied proven programming expertise to complete numerous data conversion and manipulation projects by creating UNIX SHELL scripts using telnet, FTP, vi, grep and other UNIX utilities; utilized SQLPlus and Oracle Procedure Builder tools to create and maintain SQL and PL/SQL scripts.
  • Maintained current knowledge of new Oracle versions through ongoing education to ensure optimal performance.
Software Engineer/Team Leader 1991 - 1998

Provided technical vision and direction to plan and execute innovative, cost-saving solutions in addition to applying programming skills to fix bugs, modify existing code and ensure Y2K compliance of all programs and systems.

  • Saved approximately $1 million by researching and leading the early conversion of the entire software system from a costly IBM-4381 mainframe to a client/server LAN environment using inexpensive equipment and Btrieve database technology; served as Team Leader for a group of four programmers.
  • Converted on-line systems using CA-Realia, COBOL, RealCICS, Real370 and Btrieve development products and created MS-DOS batch scripts to provide job submission and queuing functionality.
  • Eliminated the tremendous expense related to the printing, filing and updating of several thousand pre-printed forms by using HP-PCL5 printer language to create custom laser printer overlays that saved $40,000 per year in the printing of one form alone.
Travelers EBS -  Orlando, Florida 1990 - 1991
Programmer/Analyst

Joined this software company specializing in the development of insurance applications to identify, re-test and document fixes for various bugs in COBOL code to operate flawlessly across Unysis, IBM AIX and IBM PC LAN platforms. Created patch programs on floppy disks to install changes at customer site. Performed maintenance and new development using COBOL, C and UNIX shell scripts and programmed enhancements to the ILAN (IBM LAN) product version.

DACCO Software Systems -  Longwood, Florida 1988 - 1990
Programmer/Analyst

Selected to develop and maintain quality programs in COBOL for this small producer of banking and mortgage, inventory/shipping and customer resource management software tailored to the needs of the small business owner.


Education

Keller Graduate School -  Orlando, Florida 2003

Current Student - Masters of Information Systems Management

University of Central Florida -  Orlando, Florida 1987

Bachelor of Science, Computer Science
Bachelor of Arts, Psychology


Specialized Training and Certifications

Valencia Community College -  Orlando, Florida
Introduction to Java 2002
Advanced Java Programming 2002
Distributed Java 2002
XML 2002
  
Oracle University -  Orlando, Florida
Oracle8i: SQL Statement Tuning Workshop 2000
Oracle Discoverer Administration 1999
Enterprise DBA Part 2: Performance and Tuning 1999
Oracle8: Backup and Recovery 1999
Oracle8: Database Administration 1998
Developer/2000 Build Forms I 1998
Developer/2000 Build Forms II 1998
Develop PL/SQL Program Units 1998
Introduction to Oracle: SQL and PL/SQL 1998
   
Certified Oracle 8.0 Administrator - brainbench.com 2001
Certified Florida Evaluator, Florida Department of Revenue 1993
Programming in Microsoft C, Microsoft University - Chicago, Illinois 1992
Xtrieve, Btrieve Corp. 1991
Programming for Btrieve, Btrieve Corp. 1991


References available upon request