JENNIFER C. OGLE

EDUCATION:

Currently self-employed as President of Radioactive Frog Web Designs, Inc.  Sub-contracting to the Center for Clinical Informatics as principal developer of its ACORN Clinician's Toolkit which collects and compiles statistics relating to patient outcomes for a number of major health organizations.  The application is being developed with ASP using SQL Server 2008 databases.  

Subcontracting to CompuPay, converted DSI Java/JSP payroll application from Apache/Solaris/Oracle to Sun Webserver 7/Windows/SQL Server platform.  Compiled FORTRAN check breakdown into Windows DLL to be called from the Java application server.  Modified and maintained the existing application as requested.

Built websites for local area businesses and non-profit organizations such as Dental Mission for Children.   Created customer maintainable online store for Consolidated Plumbing Industries at Durapex.Com.  Developed secure login screens for KidCareView.Com, a system whereby parents can view their children at daycare via web-cam.   

Also contracted with Hoover Materials Handling Group as interim SQL Server DBA and developer of Internet and Intranet customer service reporting applications using ASP (Visual Interdev) for tracking container movements.  Designed and built iTRAM.Com and Chemsort.Com commercial web sites for Hoover.

Member of development team contracting with Dept of Energy's Office of Scientific and Technical information (OSTI).   Developed front end (JSP and servlets) for multi-tier search applications for public and private access to OSTI's large collection of scientific/technical publications.   Database engine was Oracle 10g/9i with Intermedia full-text indexing.

Recently part of a development team at Hampton Tilley Associates  to develop 3-tier MTS applications to integrate manufacturing WIP systems (Wonderware, XFactory, etc) with ERP systems such as SAP, ROS, and PeopleSoft.     Responsible for database design,  Oracle and SQL Server back-end (SQL stored packages/procedures/triggers), and front-end browser based applications written in Visual InterDev.   Also functioning as DBA for development database instances (Solaris and NT).

Consulted with Lawrence Brothers, Inc. in Sterling Illinois to assist in their Fourth Shift manufacturing database migration and Y2K upgrade project.   Installed new Novell server, NT Server, E-Mail System, Internet Access,  many other upgrades.

Subcontracted  for Lockheed Martin for over 4 years, with continued as-needed support  since.  Assisted Analytical Services Organization's RadioChemistry group in creating Microsoft Visual Basic 5.0 applications to collect data from various laboratory instruments for analysis.   Installed and configured Oracle v7.3 on Novell NetWare 4.11 SFT mirrored server, with SQL*Net for both TCP/IP and IPX/SPX. Set up new database and created user accounts, security, and application tablespaces. Used Oracle Database Designer to convert existing Microsoft Access tables and indexes to Oracle. Wrote SQL scripts to create additional Oracle views and replica snapshots (with automated updating) to data in a remote Oracle 6.x database.  Modified some existing Visual Basic data-collection applications to use Oracle ODBC and RDO and Access and trained other developers to do same. Created data upload program for exporting Excel data to Oracle via SQL*loader. Installed and configured Oracle Web Applications server on Windows NT server. Also responsible for managing and troubleshooting Windows 95/NT workstations, Novell 4.x/SFTIII servers,  and Windows NT 4.0 servers. This included hardware and software installation and maintenance, network documentation, disaster recovery planning, and implementing LMES-OR computer security programs in compliance with DOE Order 1360.2B.  

Contracted at Data Research and Applications as a temporary replacement for their network administrator. Upgraded servers from Netware 3.x to 4.x, installed new e-mail system (Eudora WorldMail), upgraded workstations to Windows 95, installed new 3Com remote access server, configured Internet firewall and DNS on NT 4.0 Server, configured Ascend router, and assisted in locating and training permanent replacement.

Senior WAN Manager at Scientific Ecology Group (SEG), supporting 500+ users running Windows 95/NT accessing Novell Netware 4.11 servers and Oracle.  Administered IBM RS-6000 running AIX with Oracle database. Upgraded Oracle from v7.1 to v7.3. Created scheduled jobs for Oracle backup and promotion of applications and database tables from test to production. Tuned database for increased performance. Performed numerous upgrades and installations including Netware 3.1x to 4.11 and Lotus CC:Mail to Groupwise 5.   Previously, contracted with SEG as part of a software development team to complete the company's "AccuTrack" waste-management system, utilizing Oracle Designer 2000 CASE tool and Developer 2000 Forms and Reports designer. Also wrote Visual Basic/ODBC applications to support barcoded data-entry into the AccuTrack system.  

Also while subcontracting for Lockheed Martin, functioned as both the Software Development Team Leader and the Network Administrator for a group of approximately 30 users at Hazardous Waste Remedial Actions Program (HAZWRAP).  Designed and implemented the following software systems in CA-Clipper 5.2 and CA-Visual Objects (SQL/ODBC): HUD Lead-Based Paint Program (data entry screens, a comprehensive subcontractor bid/invoice/project account tracking system, barcode labels, and automated reporting), US Postal Service Radon Assessment & Mitigation Program (data entry, shipping/receiving of radon detectors, barcodes, serial transfer of data from radon detector reader, and reporting), US Navy Radon Assessment & Mitigation Program (final report CDROM query program for distribution to all Navy divisions), US Naval District Washington Lead-Based Paint and Radon Assessment Program (automated data assimilation from test equipment, forms entry, reporting, and WWW pages for data distribution), US Navy Pacific and US Navy SouthWest Divisions Radon Assessment & Mitigation Program (radon detector data entry, inventory, assimilation, statistics, and reporting). Responsible for writing data CDROMs for archival purposes and end-of- project reporting. Wrote numerous technical and user training documents relating to software systems and supported users on DOS, Windows, and NeXT Unix workstations.

Directed Knoxville technical team for Intelligent Systems & Networking to design, configure, install, and support Novell and Windows for Workgroups networks for East Tennessee School Districts as part of the statewide "21st Century Classroom" project. Also while at ISN, installed and configured ORACLE Release 7 (Novell NLM) on a 1000-user NetFRAME Super-Server at TVA - Watts Bar site. At Computer Network Center, modified extensively and supported a FoxPro/SQL application called CHART- TRACK, a medical records patient chart tracking system for LeBauer Clinic. Created several other smaller applications in Clipper 5.1 and supported Novell networks for clients in the medical and legal fields.

Information System & Services Specialist at AlliedSignal (formerly Bendix) Safety Restraints Division, responsible for all IS functions relating to keeping a sophisticated barcoded manufacturing system (written in ORACLE Release 6) running 24/7 with less than 0.1% downtime. This included: supporting and training up to 600 users (both office staff and manufacturing technicians), creating database query programs, barcoded scan sheet and label printing programs using ORACLE SQL/Forms 3.0, SQL/Plus, Pro-C, and Microsoft C and reports generation using SQL/ReportWriter, creating and implementing a personnel tracking system in Clipper 5.1, production barcode terminal programming (Burr-Brown TDL), creating barcode label generator software in QBasic, writing numerous support utilities in Microsoft C and Microsoft Assembler, supporting the legacy system written in Lowry ScanWare for data recall purposes, writing user and technical documentation, and troubleshooting hardware and software on the Novell 3.11 network, and the HP9000 minicomputer. Administered Oracle 5.x and 6.x databases running on Novell Netware 3.11 and HP-UX servers.  Included tuning database, writing SQL queries for ad-hoc user reporting requests, database backup, and security.

PROGRAMMING:

Database and Client/Server: Java (JSP, servlets, J2EE), Visual Basic v3-v6/.Net (ActiveX, ADO, RDO, DAO, ODBC), Visual InterDev (Active Server Pages/VBScript), Oracle v6 to 10g (Developer 2000, Forms, SQLplus, PL/SQL triggers and stored procedures, Pro-C),  SQL Server 6.5 to 2008 (including Transact-SQL triggers and stored procedures), Microsoft Transaction Server, Frontpage, ColdFusion, Dreamweaver, Microsoft Access, VBA,  CA-Visual Objects, dBASE, CA-Clipper 5.x/Clipper Tools/3rd Party Libraries, Advanced Revelation, PowerBuilder, K-MAN, R-BASE, Paradox, Btrieve, FoxPro/Foxbase+, DBXL

Systems: HTML, Java, JavaScript, Perl, Novell NetBasic,Watcom C/C++, Microsoft C, Visual C, COBOL, Basic, FORTRAN, PL/I, Pascal/Turbo Pascal, SAS, AutoLISP, Microsoft Assembler, Lowry Scanware/4GL,  Barcode terminal and printer languages (Intermec IRL, Burr-Brown TDL, Zebra ZPL)

Development Tools: NetBeans, Oracle Designer 2000 CASE tool, Sylvain-Faust SQL-Programmer,  Platinum ERWin Database Designer and SQL-Station, Informatica PowerCenter and PowerMart, Microsoft Visual Studio, PVCS, Microsoft Visual Source Safe

SOFTWARE EXPERIENCE:

Operating Systems: Novell NetWare v2/3/4/5, Windows 2000, Windows NT Server/Workstation 3.51 and 4.0, Windows 3.x/95/98/ME, MS-DOS, Sun Solaris 2.x, Artisoft LANtastic, OS/2, MacOS, Linux, NeXT, HP-UX, Novell UnixWare (AT&T UNIX), XWindows, Data General AOS/VS, Altos OASIS, DEC VMS & RSTS/E

E-Mail: Novell GroupWise and MHS Gateway, Microsoft Exchange Server, ICEwarp Mail Server,  Eudora WorldMail Server, Microsoft Mail/Outlook, Pegasus Mail, Lotus Notes, Pine, WordPerfect Office, Lotus CC:Mail

Internet: Web Servers (Microsoft IIS, Netscape, Novell, Quarterdeck, Apache/Tomcat), Oracle Web Application Server, Microsoft Proxy/DNS/DHCP Server, Novell Border Manager and FTP Server, Telnet

Communications: Citrix WinView & WinFrame, Cheyenne ARCServe and FaxServe, Eicon SAA Gateway, Windows NT RAS Server, Novell Netware for SAA and SNA Gateways, Novell LAN WorkPlace, Bulletin Board Systems,  PCAnywhere/LAN, Crosstalk, Kermit, LapLink, Close-Up

Manufacturing: Oracle Manufacturing, Wonderware Intrack, USData XFactory, Fourth Shift, SAP, ROS, LabelRight, AutoCAD, Lowry ScanWare, LoftWare

Office: Microsoft Office, Oracle Financials/Personnel, Platinum, Peachtree Accounting, Crystal Reports, R & R Relational Report Writer, Lotus 1-2-3, Quattro Pro, Norton Ghost, Norton 2000, Norton Anti-Virus, McAfee Anti-Virus, Lotus Organizer, Lotus Agenda, Microsoft Project, Timeline, Telemagic, WordPerfect, MarxMenu, Saber Menus, Direct Access/Net, WordStar, OfficeWriter, Brief, Norton Editor, Unix VI, DEC TECO and EDT, KEDIT, ESP-QC, Minitab, SPSS, BIOSTAT, Statgraphics, Paperless Filer/Toolkit, Presto!, Image-In, TeleForm, Calera WordScan,  Micrographics Charisma, Corel Draw, Lotus Freelance,  Microsoft CHART, Adobe Photoshop, PC Paintbrush, Windows PAINT, Ashton-Tate Diagram Master, WordPerfect Graphics, Easy-CD, Gear CDROM Recorder Software, CDROM Server Software (Celerity Systems VCDMAN NLM, Meridian CD-Net, Ornetix CDVision, and Sci-Net CD-Manager),   many others

HARDWARE EXPERIENCE:

Systems: Intel & IBM Compatible Microcomputers, IBM RS/6000, HP 9000, NeXT, NetFRAME, AT&T, V/386 Unix System, IBM AS400/System 3x/FEPs, Data General MV-4000, DEC VAX 11/780, DEC 20, DEC PDP 11/10, 11/70, 11/44 (and compatible minicomputers), SUN Workstations, ALTOS 8000-12, Amiga, Apple MacIntosh, II, & IIe, Radio Shack

Peripherals: Hewlett-Packard, Epson, Misc. Printers & Plotters, Barcode Printers, multiple brands of Tape drives/bernoullisRAID hard drive systems, Microtest DiscPort CDROM Server, HP, Microtek, and Fujitsu Scanners, Philips CDROM Recorder, NSM 100-Disc CDROM Jukebox, other CDROM Changers

Networking: Ascend, 3-COM, Bay Networks, Cisco, Allied Telesyn, Madge (LanNet) Ethernet Hubs, Routers, Bridges, and Switches (10 & 100 Mbit), Proteon & IBM Token Ring, SMC ARCnet, Burr-Brown Barcode Terminals/Networks, Modems, Digi-Boards, SDLC, ISDN, & other WAN Telecommunications hardware, T1, T3, TCP/IP and SPX/IPX protocols, Novell NACS, 3Com Remote Access Server