[Resume] Oracle OCP DBA

Jon Baumgardner
8745 Greenwood Ave. N. #303
Seattle, WA 98103-3650
Home (206) 789-9315

Objective
Oracle OCP DBA

Summary of qualifications

One year as a Senior Developer Support Engineer , one year as a project manager, eight years as project lead and thirteen years experience in a variety of areas including database analysis and programming using the complete Systems Development Life Cycle from architecture and design to implementation and maintenance. Other skills include: database administration, managing large projects, regression testing, change control management, training, writing documentation, network analysis, installation, troubleshooting, and network sniffing. Volunteer webmaster for the Puget Sound chapter of the Association of Information Technology Professionals, the AITP Region II and Greyt Rescues (www.greytrescues.com).

Technical proficiencies include expertise in PL/SQL, HTML, Sybase/Transact SQL database, Adabas/Natural database, and Novell NetWare. I have expertise in many applications including telecommunications, payroll, banking, health care, consulting, and system integration.

Technical Skills

Platforms and Operating Systems
Solaris, HPUX, AIX, Winframe, Oracle 8i, Glenayre paging terminal, MS Windows 2000,9x/NT, SUN, UNIX, IBM 3090, ES9000, Novell 4.11.

Languages
Java, PL/SQL, C/C++ (1 yr.), Visual Basic (1 yr.), HTML (2 yrs.), Excel Macro (VB), Transact SQL, Adabas/Natural, Cyberprise/Rumba.

Tools/Applications:
Network Monitor, TCP/IP, Visio, MS Front Page, MS Powerpoint (5 yrs.), MS Project (5 yrs.), Rapid SQL, Visual Source Safe, FTP, RLOGIN, PC-NSF, VI, TCP/IP, Network General Sniffer, GroupWise.

webMethods products:
webmethods Mainframe 4.6, Mainframe Integration Server 1.2.1, Enterprise Server 3x to 5.0.x, Integration Server (B2B server) 3x to 4.6, Developer 4.6, 4.6.1, Enterprise ADK 4.x to 4.2.1, JDBC adapter 4.x to 4.2.1.

Work Experience
6/2001 - 6/2002
webMethods, Inc., Senior Developer Support Engineer Worked with customers to install, configure, test, and debug integration projects using webMethods products. Worked with the developers, professional services consultants, sales engineers, and management to specify, test, and ship new products, service packs and fixes worldwide. Specialized in the webMethods mainframe products, integration server, and enterprise server along with database adapters. Worked thru 250 service requests in 53 weeks with over 50 customers.

9/2000 - 5/2001
Kanbay, Inc, Senior Consultant
Regence Membership and Claims conversion project. I wrote SQL queries to analyze the relationships in the provider database. I wrote program specifications, and programs to convert the data from the PIMS tables in Oracle to the FACETs tables in Sybase. I wrote test plans, and test scripts to test the converted data.

7/1999 - 9/2000 Metrocall, Inc. Bellevue Headquarters Bellevue, WA Systems Analyst
Coordinated the maintenance of the billing system with changes in the Glenayre paging terminals nationwide. Wrote the high level design specifications, detailed programming specifications, assigned programmer tasks and managed programmers’ progress. Wrote detailed test plans, scenarios, and test cases. Wrote implementation plans and operations’ procedures for implementing complex applications.

Managed the Y2K testing including: Building a comprehensive Y2K test environment with an HP 250D with Oracle, two MicroVaxes, one Novell Network server, three Windows NT servers with Winframe, a remote Glenayre 6.1 paging terminal in Oklahoma, and four Windows 95 workstations hooked together on a SynOptics LattisNet router, a Bay Networks 10/100 hub, and a Cisco 2600 Latgat. Tested 34 applications including 3 tier applications with Visual Basic front ends in Winframe that access files in the VAX with Cobol, and files on the HP in an Oracle database that are on an SQL*NET. Tested billing batch cycles. Worked with over 25 people to coordinate date changes, bug fixes, and testing issues. Worked with 25 vendors to send and receive files and document test results on the vendor’s systems. Documented the test results, test plans, test scripts, vendor certifications, contingency plans, bug fixes, and issues list. Analyzed the translations required to merge AT&T Wireless Messaging systems paging terminal databases with Metrocall paging terminal databases to allow access by separate billing systems on the same paging terminal.

1995 - 1999 Ciber, Inc. Seattle Branch Bellevue, WA Senior Consultant

3/99-7/99 Project Manager for 16 projects at the San Francisco International Airport Y2K office. I worked with vendors and city employees to assess, remediate, test, and certify systems for Y2K compliance according to the City of San Francisco and FAA regulations and guidelines. I wrote project plans, test plans, Microsoft Project timelines, test execution and results documents, contingency plans, and status reports. I met with users, vendors, decision makers, programmers and testers to motivate them to finish by the deadline.

10/98-3/99 Project Manager for Alternate Delivery Technologies with IBM Global Services at Washington Mutual Bank. Overseeing the Y2K End to End testing for alternate delivery technologies. Built the Inventory database using Access, Visual Basic, and Excel. I wrote test plans, test scripts, Microsoft Project timelines, and budget projections. Managed the building of the test systems Architecture.

1/98-10/98 Lead Analyst and Programmer for the Customer Service Center Vantive system at Group Health Cooperative - database administrator for the development environment for the project. Wrote the batch interface between the Unix system and the mainframe. Coded, tested and debugged SQL Server stored procedures, Visual Basic code in Vantive, Unix scripts, Ideal programs, Cobol programs, JCL streams, parmlib members, doclib members and changeman packages. Loaded Unix program source into Visual Source Safe.

3/96-12/97 Lead Analyst and Programmer for the Master Patient Index hospital integration system - Wrote a very complicated CICS Cobol II transient data queue transaction with 26 subroutines and a daily batch report job with 9 steps. Reviewed C code and TransAct SQL in the Sybase/Sun interface engine system while debugging problems involving TCP/IP ebcidic to ascii conversion and routing. Used Health Language 7 version 2.3, Roscoe, Librarian, Changeman, Version Merger, FileAid, Expediter in CICS, and BookManager. Conducted regressive integration testing involving four computer systems in two health care organizations and 20 user testers over 250 separate tests and more than 100 daily reports downloaded and emailed to the users. Year 2000 project - Conducted the analysis in the pilot Y2K project and converted 300 Ideal programs.

1/96 - 3/96 Analyst/Tester for the State of Washington Employment Security Division's new mainframe conversion project. Worked in the Windows NT system.

1995 Network Engineering Hawaii Ma'ili, HI Certified Netware Engineer
Started my own consulting company for network troubleshooting using the Network General Sniffer product. Installed Novell local area networks, as well as bridge/router configuration and installation.

1993 - 1995 Bank of Hawaii Honolulu, HI
Senior Systems Analyst
Project leader on the CA-11 rerun/restart system implementation.

1991 - 1993 Merchants National Bank Honolulu, HI Programmer/Analyst
Project leader for checking system and payroll systems in the Military Services Division.

1990 - 1991 University of Hawaii Honolulu, HI Computer Specialist III

1989 - 1990 HMSA Honolulu, HI
Staff Analyst

Education
1987 - 1989 Purdue University W. Lafayette, IN, Bachelor of Science / Computer Technology
1990 Institute for Certification of Computer Professionals, Certified Computer Professional (CCP)
1995 Novell, Inc. / Drake Learning Centers, Certified Netware Engineer (CNE)
1999 CIBER Certification in Consulting Skills Training - Twelve Course Workshop

1998-1999	Interactive Training in C++ and Visual Basic
3/1999	Cyberprise, DBapp Dev training at Wall Data - includes Active

4/2001 Oracle Certified Professional DBA 
7/2001 webMethods Mainframe for Developers 
9/2001 webMethods Enterprise for Developers

Professional  memberships
2000 - now	President,  Puget Sound Chapter of AITP (formerly DPMA)
1997 - now	Web site administrator	Puget Sound AITP