Deborah Gollnick

DEBORAH N. GOLLNICK  
CERTIFIED ORACLE-PL/SQL DEVELOPER
GOLLNICK, INC.
 
FEIN# 30-0003355
 
5650 36th Ave SW
Seattle, WA 98126
(916) 606-2626
 
dgollnick@gollnickinc.com

 

SUMMARY OF EXPERIENCE

Certified, Certified, Senior Oracle Developer with 11 years experience in designing and building custom applications using Oracle databases and tools in Unix and Window environments. Energetic self-starter with excellent analytical and organizational skills. Achieves goals, objectives and milestones in an accurate and consistent manner. Strong leader and communicator with six years experience as a women's basketball coach including assistant and head coaching experience at high school, college and professional levels.

 

TECHNICAL PROFICIENCY

Software:

Microsoft Office (Excel, Word, Power Point, and Access), Visio, InstallShield, Clearcase and Dreamweaver

Operating Systems:

UNIX, Windows 95/98/NT/2000/XP, Linux

Languages:

PL/SQL, SQL, HTML, JavaScript, PL/1

Databases Environments:

Oracle RDBMS V7, 8, 8i, 9i, and 10g

Web Servers:

Oracle Application Web Server (OAS) 4, 9iAS, 10gAS

Tools:

Oracle Forms 10g, 9i, 6i, 6.0, 5.0, 4.5, 3.0, Reports 10g, 9i, 6i, 6.0, 3.0, 2.5, Designer 9i, SQL*Plus, SQL*Loader, Toad, WebAlchemy, Oracle Portal 3.02, 9.04, HTMLDB

Other:

Project management. Excellent problem-solving, organization and leadership skills. Quick learner.

 

PROJECT TITLES

Project Lead

Senior Oracle Developer - Analyst

PL/SQL Programmer - Analyst

Oracle Portal Developer

 

PROJECT HISTORY

Project: Service Request and Work Order Applications
Client: Seattle City Light - 1.3 years
Role: Oracle Consultant

Environment: PL/SQL; SQL; SQL*Plus; Oracle 9i, 10g; Oracle Forms 10g, 6i; 10gAS; Sun Solaris Unix; Windows XP; TOAD; Oracle Portal, HTMLDB; Oracle Reports 10g, 6i; Oracle Developer

 

• Designed and created an interface between custom application and accounting application, Summit.font>

• Mentored junior programmers in Oracle database design and development.

• Upgraded 6i client server Oracle Forms and Reports application to web based 10g and ran the application through Oracle Portal and Single Sign-on.

• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.


Project: Energy Monitoring Application
Client: Areva - 6 months
Role: Senior Oracle Developer

Environment: PL/SQL; SQL; SQL*Plus; Oracle 9i, 10g; TOAD; 9iAS; Sun Solaris Unix; Windows XP; Oracle Forms 10g, 6i; Oracle Reports 10g, 6i; Oracle Developer

 

• Wrote Advanced Queuing database package to send messages to clients based on events.

• Lead the upgrade process of Oracle Forms and Reports 6i to 10g including the setup of the 10g Oracle Development environment.

• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.

• Only developer for 3 different projects.


Project: Case Management Application
Client: State of Nevada - 2 years
Role: Senior Oracle Developer

Environment: Oracle Forms 9i; Oracle Reports 9i; Oracle Developer; Designer 9i; PL/SQL; SQL; SQL*Plus; Oracle 9i; Sun Solaris Unix; Windows 2000; TOAD

 

• Member of the team that setup the project standards for development.

• Used Designer for design and database object generation.

• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.

• Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures.


Project: Application Processing System
Client: Maximus - 1.5 years
Role: Team Lead - Senior Oracle PL/SQL Developer

Environment: Oracle Forms 9i; Oracle Reports 9i; Oracle Developer; Designer 9i; PL/SQL; SQL; SQL*Plus; Oracle 9i; Sun Solaris Unix; Windows XP; TOAD; 9iAS; Oracle Workflow

 

• Generated Oracle Forms and database objects through Designer.

• Wrote PL/SQL packages to calculate Missing Information and Determining Eligibility in the processing of a Medical/Health Families Application.

• Created Oracle Reports with Java Barcodes.

• Assisted in setting up the Forms and Reports Services on 9iAS.

• Documented business rules, functional and technical designs, test cases, and user guides.
• Lead the implementation of Oracle Workflow for processing applications.

Project: NetWORKS Procurement ERP Application
Client: Manugistics, Inc. - 1 year
Role: Senior Oracle - PL/SQL Developer

Environment: Oracle Forms 6i; Oracle Reports 6i; Oracle Developer; PL/SQL; SQL;SQL*Plus; Oracle 8i; Sun Solaris Unix; Windows 2000; Clearcase; TOAD

 

• Developed PL/SQL packages for electronic Document Exchange Manager

• Designed, created and maintained Web-enabled Oracle Forms & Reports for NetWORKS Procurement.

• Generated SQL and PL/SQL scripts to install, create and drop Trading Exchange Connection database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.

• Troubleshooted performance issues and bugs within packages, forms, and reports using dbms_output, Forms debugger, explain plan and TKPROF.

• Documented business rules, functional and technical designs, test cases, and user guides.

 
Project: DOJ Electronic Interface
Client: Department of Consumer Affairs - 6 months
Role: Project Leader - Oracle Developer

Environment: Oracle Forms 3/6i; Oracle Reports 1.1/6i; PL/SQL; SQL; SQL*Plus; Oracle 7.3.4/9i; SQL*Loader; Sun Solaris Unix; Windows NT; TOAD

 

• Lead team of 6 through the development life cycle of an electronic interface to the Department of Justice for the processing of fingerprint information.

• The interface reduced the time to license a security guard from 2 months to a week.

• Required coordination with 3 different teams and migration into current licensing system (ATS) that itself was being upgraded.

• Developed Oracle Forms and Reports for the user interface; a data load using PL/SQL and SQL*Loader; and cron jobs calling Unix scripts to download and manipulate files.

• Upgraded Forms and Reports from 3.0/1.1 to 6i.

• Created documentation for all aspects of the project including training the end users.


 
Project: Foreign Currency Back-office System
Client: First Data Corporation - 2 years
Role: Oracle Developer Consultant

Environment: Oracle Forms 4.5, 6, 6i; Oracle Reports 2.5, 6, 6i; Oracle Developer; PL/SQL; Web Toolkit; SQL; SQL*Loader; SQL*Plus; Oracle 7.3.4, 8, 8i; 9iAS; Unix; Windows NT; Oracle Portal; InstallShield; TOAD; Visio

 

• Lead in analysis and development of a foreign currency back-office system. The back-office included generating journal entries to be loaded into Oracle Financials; maintaining exchange rates, mark-up percentages and shipping costs; tracking inventory of multiple currencies and denominations for different locations; and several custom reports for invoicing, packing and auditing.

• Participated in the full software life cycle.


 

Project: Time and Rates Reporting Web Application
Client: AON - 6 months
Role: Oracle Portal/WebDB Developer

Environment: Oracle Portal, WebDB; PL/SQL Web Toolkit; SQL; SQL*Plus; Oracle 8;
Windows NT; Unix

 

• Created and implemented an intranet WebDB application for management on employee time and rates based on their Ceridian system.

• Development included using the security access from the Ceridian system on user login and different menus for different access levels.

• Effort also included development of stored packages with Oracle's Web Toolkit for creation of menus, security and data load pieces.

• Upgraded the WebDB application to Oracle Portal.

• Provided technical and user documentation.


 

Project: Customer Voice Application
Client: AON - 3 months
Role: Developer 2000 Consultant

Environment: Oracle Forms 5, 6; Oracle Reports 3, 6; Oracle Developer; PL/SQL; SQL;
Web Toolkit; SQL; SQL*Plus; HTML; JavaScript; WebAlchemy; Dreamweaver;
Oracle 7.3.4; OAS 4; Windows NT; Unix

 

• Upgraded, maintained and troubleshooted Oracle Forms and Reports.

• Oracle Reports were deployed in PDF format over the Internet for direct access by auto dealers throughout the United States on OAS using the PL/SQL cartridge. Oracle Forms created the back-end system for administrators.

• Development of PL/SQL and Web PL/SQL stored procedures. Also created Web PL/SQL stored procedures by creating Web pages through Dreamweaver and then used WebAlchemy to convert the HTML to PL/SQL.


 

Project: Golf Management\Scheduling Application
Client: Fairway Systems, Inc. - 1 year
Role: Oracle Developer

Environment: Oracle Forms 4.5, 5; Oracle Reports 2.5, 3; Oracle Developer; PL/SQL;
SQL*Loader; SQL; SQL*Plus; Oracle 7.3.4; Windows NT; Unix

 

• Wrote the functional design requirements and performed custom development for the scheduling and golf management modules: accounting, inventory and property management.

• Developed and maintained the system using Oracle Forms, Oracle Reports, SQL*Plus and PL/SQL.


 

Project: General Merchandise Retail System
Client: GERS, Inc. - 4 years
Role: Oracle Developer
Environment: Oracle Forms 3; PL/1; PL/SQL; SQL*Plus; SQL; Oracle 7; Windows 3.1, Unix
 

• Analyzed, developed and maintained Oracle Forms and Reports for a newly designed General Merchandise Retail System.

• Designed coding specification and documentation.

• Technical lead Oracle programmer for training and task assignment for entry-level programmers.

 

EDUCATION

University of San Diego, BA Computer Science
First Data Corporation, Project Management
Oracle Internet Application Developer 6/6i Certification
Oracle Internet Application Developer 9i Certification

 

 


Member number:8040
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2001 Deborah Gollnick and Software Contractors' Guild, Post Office Box 257,Nottingham, NH USA 03290-0257