Randall Bankert
11333 Moorpark Street, #80
Studio City, CA 91602
rbankert@ossaudio.com
(818) 632-0692

DBA, Programmer, Data Architect, SQL Server, Oracle, MySQL, DB2/UDB, Sybase -

Website Developer, BroadVision Administrator, Systems Analyst, Quality Assurance

Technical Summary: I am an SQL Server, Oracle, DB2/UDB, MySQL and Sybase database administrator, developer, data architect, programmer, website designer and developer, quality assurance manager, systems analyst, website developer, and BroadVision Administrator with 20 years of experience in all phases of MIS development, programming, implementation, and operations; excellent skills in team building, people management, communications, and problem solving. Extensive development experience in Perl / CGI, Javascript, PHP, TOAD, PowerBuilder, dBArtisan, Redhat Linux, ETL, DTS and SSIS package design and programming, OLTP, OLAP, Systems analysis, specification, design, coding, optimization, implementation and deployment, quality assurance and documentation. Object-oriented analysis, design, and programming using Rational Rose, Unified Modeling Language, Jacobsen Use Case, Wirfs-Brock, Booch, Rumbaugh, and Yourdon methodologies; two and three-tier client server, application servers, transaction servers, content caching servers, automatic fail-over clusters, replication, hot standby database.

DETAILED EXPERIENCE

O. S. Services, Inc. - Los Angeles, CA, August 2007 to present. DBA / Developer. Application design, development, and quality assurance of a variety of shrink-wrap tools and development aids, including datawarehousing design and analysis, b2b supply chain, regional fulfillment, and basic stock inventory management application with electronic PO's, sourcing, fulfillment, electronic payment, reporting, metrics. Datawarehousing design and implementation, including slice and dice, star schema, online analytical processing, multi-dimensional optimazation and schema design. Environment: SQL Server, MySQL, Sybase 12.5, DB2/UDB, Oracle 8i. 9i / AS, 10G RAC, Oracle Financials 11, Oracle Reports and Forms 6i, Oracle Designer/2000 and Developer 2000, Oracle Portal, Oracle Portal Development Kit, Oracle Discoverer, Oracle RMAN, Visual Basic 6, VB Scipt, PHP, Java Script, Visual Studio C++, Microsoft .NET, ASP, ADO, COM, Active X, .NET, PowerBuilder, CORBA, Orbix, VisualAge Smalltalk, Websphere, Team Foundation Server, Embarcadero, Brio, XML, Java, Solaris. Visual Cafe Pro, BEA Weblogic, Brio, Redhat Linux, NT, PERL/CGI, AS400, HP3000 & MPE, VSAM, RS600 & AIX, HP K class & HPUX, HP View, Access, IQ Object, Image SQL, TurboImage DB, Essbase, Crystal Reports, Business Objects.

Oversee.net - Los Angeles, CA, June-July 2007. MySQL DBA, Oracle DBA. Installation of Oracle 10G for use with MicroStrategy for departmental data warehouse, 10G Standard Edition Release 2 10.2.0.1, with upgrade patch to 10.2.0.3. Troubleshooting and optimization of MySQL queries, review of MySQL 4.1 dynamic SQL queries for conversion to MySQL 5.1 stored procedures. Environment: MySQL 4.1 and 5.1, Red Hat Linux, x86_64 servers, Oracle 10G Standard Edition on Red Hat Linux, MicroStrategy 8, Navicat, Toad, design of data conversion and loading of data from MySQL production servers to Oracle data warehouse server.

O. S. Services, Inc. - Los Angeles, CA, December 2006 to May 2007. DBA / Developer. Application design, development, and quality assurance of a variety of shrink-wrap tools and development aids, including datawarehousing design and analysis, b2b supply chain, regional fulfillment, and basic stock inventory management application with electronic PO's, sourcing, fulfillment, electronic payment, reporting, metrics. Datawarehousing design and implementation, including slice and dice, star schema, online analytical processing, multi-dimensional optimazation and schema design. Environment: SQL Server, MySQL, Sybase 12.5, DB2/UDB, Oracle 8i. 9i / AS, 10G RAC, Oracle Reports and Forms 6i, Oracle Designer/2000 and Developer 2000, Oracle Portal, Oracle Portal Development Kit, Oracle Discoverer, Oracle RMAN, Visual Basic 6, VB Scipt, PHP, Java Script, Visual Studio C++, Microsoft .NET, ASP, ADO, COM, Active X, .NET, PowerBuilder, CORBA, Orbix, VisualAge Smalltalk, Websphere, Team Foundatin Server, Embarcadero, Brio, XML, Java, Solaris. Visual Cafe Pro, BEA Weblogic, Brio, Redhat Linux, NT, PERL/CGI, AS400, HP3000 & MPE, RS600 & AIX, HP K class & HPUX, HP View, Access, IQ Object, Image SQL, TurboImage DB, Essbase, Crystal Reports, Business Objects.

Manatt, Phelps & Phillips law firm – West Los Angeles, CA September to November 2006. Design SQL Server 2000 upgrade to SQL Server 2005 cluster server, including requirements, specifications, upgrade methodology, validation and acceptance tests, functional verification tests. 10 DTS packages, 70+ production databases, 100+ applications. Design and coding of stored procedures, views, reports, optimization, troubleshooting. Environment: Windows 2000, SQL Server 2000, SQL Server 2005, DTS, SSIS, .NET, ASP, ADP, Microsoft OLE DB provider for ADO//ODBC.

Sonist - Toluca Lake, CA August to Septermber 2006. Design, coding, deployment, upgrades, and maintenance of a commercial website, www.sonist.com. Push-button drop-down multi-level menuing, forms with drop-down picklists and field validation alerts, push-button popups, CGI email, floating navigation menu bar, anchor links, file downloads from website, compatible with both javascript-enabled browsers and javascript-disabled browsers. Environment: HTML, XHTML, DHTML, CSS (Cascading Style Sheets), Javascript, Perl, and CGI hosted on a Unix webhosting server. AlleyCode HTML and Javascript text editor, nVu WYSIWIG HTML editor, Ipswitch WSFTP, Xara Xtreme graphics tool, Xara MenuMaker tool, Internet Explorer, Windows XP Professional.

LiveNation - Beverly Hills, CA April to July 2006. SQL Server 2000 and 2005 Developer and Data Architect: SSIS package design, development, and deployment; ETL, data migration, T-SQL design and programming, schema design and implementation, Unit Test and Systems Integration Test Scripts, Functional Verification Testing, design and implementation for deployment and cut-over to new production system. Migrated production database application from SQL Server 2000 to SQL Server 2005, including schema re-design, conversion of stored procedures from row-at-a-time to “set theory” statements to improve performance, design and creation of pre-populated index columns to improve performance for multi-table joins of 20+ million row tables to 40+ million row tables, SSIS package design and development for ETL of large datasets into production SQL Server 2005 database. Environment: SQL Server 2000 and SQL Server 2005, SSIS, PHP, MySQL, Windows 2000 and Windows XP.

Warner Music Group - Burbank, CA. October to December 2005. Proof of technology project: Oracle 9i and 10G XML DB application design and development for mission critical application Schema design and registration in XML DB, structured and CLOB; insert and validation of large-scale xml data files; extraction and aggregation of sales transacation data for export to Oracle General Ledger and downstream production systems. Design, coding, and implmentation of UDF's, PL/SQL stored procedures, scalability testing and optimization, unit test, systems integration test, and functional verficiation test, creation and implementation of test plans and test fixtures. Design and preparation of XML DB documentation for company-wide knowledge transfer for use by in-house dba's and developers. Environment: Oracle9i Release 2, Oracle 10G, Oracle Enterprise Manager, Altova XMLSPY Professional 2006, TOAD, Advanced Queing, ACL, Streams, Oracle XML DB.

O. S. Services, Inc. - Los Angeles, CA, December 2004 to October 2005. DBA / Developer. Application design, development, and quality assurance of a variety of shrink-wrap tools and development aids, including datawarehousing design and analysis, b2b supply chain, regional fulfillment, and basic stock inventory management application with electronic PO's, sourcing, fulfillment, electronic payment, reporting, metrics. Datawarehousing design and implementation, including slice and dice, star schema, online analytical processing, multi-dimensional optimazation and schema design. Environment: SQL Server, Sybase, DB2/UDB, Oracle 8i. 9i / AS, 10G RAC, Oracle Reports and Forms 6i, Oracle Designer/2000 and Developer 2000, Oracle Portal, Oracle Portal Development Kit, Oracle Discoverer, Oracle RMAN, Visual Basic 6, VB Scipt, Java Script, Visual Studio C++, Microsoft .NET, ASP, ADO, COM, Active X, CORBA, Orbix, VisualAge Smalltalk, Websphere, Embarcadero, Brio, XML, Java, Solaris. Visual Cafe Pro, BEA Weblogic, Brio, Redhat Linux, NT, PERL/CGI, AS400, HP3000 & MPE, RS600 & AIX, HP K class & HPUX, HP View, Access, IQ Object, Image SQL, TurboImage DB, Essbase, Crystal Reports, Business Objects.

Herbalife International of America - Los Angeles, CA. June to August 2005. SQL Server T-SQL programming and stored procedures. Complex reporting project, snapshots and activity for monthly rollforward liability reports derived from 92 million row production tables, optimisation, clustered indexes, granular data extraction and aggregation on multiple-column keys, correleated sub-queries, inner and outer joins, aggregattions with sums and grouping, formating of output for use with Crystal Reports, trouble-shooting and implementation of Crystal Report interface. Explain plan, debugger, sql optimization, developing sql design from business rules, Data Flow Diagrams, primary lead sql programmer for this project. Environment: SQL Server 2000, Crystal Reports ver. 10, Windows 2000.

Rappatoni, Inc. - Sylmar, CA, March to June 2005. SQL Server T-SQL programmer. Stored procedures, data conversion, replcation live feeds to production server from client database. Inner, outer, and full joins, error handling and reporting, 20 million row conversions. Environment: SQL Server 2000, Windows 2000.

IBM - Torrance, CA, July to November 2004. DB2/UDB EE database administrator and developer, development and operational support. Schema design and implementation, stored procedures, tuning and optimization of 10+ production databases, trouble-shooting, design and implementation of production roll-outs, installation, configuration, integration, and testing of new versions of DB2, Websphere, Content Manager, for production upgrades, RAID design and deployment. Specification and design of hot standby database for Content Manager production servers, tuning of buffers, bufferpools, tablespaces, io cleaners, io contention tuning, tuning and re-design of application SQL statements, preparation and scheduling of REORG/RUNSTATS, backups and restores, day-to-day problem resolution and development support. Environment: DB2/UDB V7.2 and V8.1, Websphere 4.5 and 5.0, IBM Content Manager 8.1 and 8.2, IBM Text Information Extender, IBM Enterprise Information Portal, Microsoft Visual Studio C++, Java 2 SDK versions 1.3.1 and 1.4.1, Eclipse, Windows 2000 Release 5, Service Pack 4, Microsoft Cluster Server, SAN, .

O. S. Services, Inc. - Los Angeles, CA, December 2000 to June 2004. DBA / Developer. Back-end database design and development, including logical and physical database design, schema design and implementation, database administration, database optimization, datawarehousing, including extract, transform and load (ETL), stored procedures, triggers, multi-dimensional schema design and implementation. Environment: SQL Server, Sybase, DB2/UDB, Oracle 8i and 9i / AS, Oracle Reports and Forms 6i, Oracle Designer/2000 and Developer 2000, Oracle Portal, Oracle Portal Development Kit, Oracle Discoverer, Oracle RMAN, Visual Basic 6, VB Scipt, Java Script, Visual Studio C++, Microsoft .NET, ASP, ADO, COM, Active X, CORBA, Orbix, VisualAge Smalltalk, Websphere, Embarcadero, Brio, XML, Java, Solaris. Visual Cafe Pro, BEA Weblogic, Brio, Redhat Linux, NT, PERL/CGI, AS400, HP3000 & MPE, RS600 & AIX, HP K class & HPUX, HP View, Access, IQ Object, Image SQL, TurboImage DB, Essbase, Crystal Reports, Business Objects.

Hewlett-Packard Mountain View, CA, October to November 2000. 2^nd Tier Oracle 7.33 - 8i and Broadvision In-house Support Engineer: supported in-house Broadvision application, the Hewlett Packard Business Store, grossing $25 million/month. Quality

assurance, testing and trouble-shooting of JSP, Oracle PL/SQL and database, triggers, performance tuning and troubleshooting, Netscape Webserver, and BroadVision components, isolation and resolution of bugs, infrastructure, and network problems for production system; rollout of major application release; migration from Oracle 7.33 to 8i, BV 4.0 to 5.0, from HPUX 10.x to 11.x, from HP K class servers to HP N class servers. Assist in creation of Mercury Test Director test suites to replicate and isolate bugs and for performance testing. Performance analysis and tuning; analysis of BV log files, BV monitor, BV Interaction Manager engine configuration and operations, BV Enterprise Server monitoring, configuration, problem isolation and resolution.

Environment: Oracle 7.33, 8i, HPUX 10.x, 11.x; HP K and N class servers; Broadvision 4 and 5; Netscape Webserver; C++, Java, JSP, PL-SQL. triggers, Mercury Test Director, WinRunner, LoadRunner, OTL.

Silvertech, Inc. San Francisco, CA, July 2000 to September 2000. Oracle 8.0.5 and 8.1.5 database administrator and programmer / Broadvision Administrator: administrator for large-scale VPN website. Configuration and analysis of BV observation reports, management and distribution of log files, tuning, optimization, design, scalability, trouble-shooting, strategic planning, BV patch implementation, BV 5.5 upgrade planning and implementation. Design and implementation of OLAP datawarehousing for CRM analysis and identification of potential profit center opportunities. Environment: Oracle 8.0.5 / 8.1.6, BV 4.1 and 5.5, FormFlow, Informatica Metadata Exchange, Netscape Enterprise Webserver, HPUX 11.0, installation and configuration of Redhat Linux, Hewlett-Packard A-class, L-class, N-class, V-class servers.

Verisign Payment Services, Redwood City, CA, May to June 2000. Database Administrator/programmer; SQL Server 7.0, NT 4.0. Replication maintenance and enhancement, tuning and support of five different high-volume production servers, design and implementation of stored procedures, documentation of production system, disaster recovery plans. Designed and implemented a methodology with GUI front-end to alter published articles (tables) without breaking replication of entire publication. Environment: SQL Server 7.0, NT 4.0, Transact-SQL, replication, stored procedures, disaster recovery, tuning.

NorthGate, Inc, Santa Barbara & Los Angeles, CA, March to May 2000. Oracle 8.1.6 dba and programmer, project management, Sun Solaris 2.6 database analyst, programmer, dba, design architect. Designed and implemented port of java GUI and back-end applications from Objectstore to Oracle 8.1.6, schema design, logical/physical tablespace layout, stored procedures, triggers, stored functions, interface to java applications, tuning, optimization. Spec'd, sourced, and configured Sun Enterprise 250 with 24-drive dual SCSI drive chain, Solaris 2.6, RAID 10, installed and configured Oracle 8.1.6 as OLTP database server for this e-commerce client. Skills transfer to java application developers: BEA Weblogic configuration and architecture design and implementation, PowerSoft DataArchitect, SQL*Plus, SQL Worksheet, FormFlow, Oracle Schema Manager, schema design and management, PL/SQL programming, stored procedures, triggers, stored functions, Narrative Use Case, project management methodologies. Environment: Oracle 8.1.6, Oracle SQL+Plus, Oracle PL-SQL, Sun Solaris, Access, PowerSoft DataArchitect, BEA WebLogic, object-oriented methodology

iXL, Westwood, CA. November 1999 to March 2000. Oracle 8.0.5 dba, data architect and programmer, Sun Solaris 2.6. Designed, tested, and implemented data conversion and import scripts for e-commerce BroadVision real estate application, designed hot standby database and synchronous replication for BroadVision web-based children's on-line learning web application, prepared development team roles analysis for java / SQL corporate learning website using BroadVision, schema design of VLDB corporate distance learning web application, implementation and administration of Oracle 8.0.5 terabyte transaction and CRM database. Designed and prepared implementation plans for Broadvision One-to-One Enterprise 4.1, configured named Interaction Manager, customized database, interface with external data sources, familiarity with Broadvision data dictionary and file system architecture. Environment: Oracle 8.0.5, Sun Solaris 2.6, Java, PL-SQL, triggers, tuning, trouble-shooting, VLDB.

InsureTrade, a division of Paula Financial, Pasadena, CA: October to November 1999. Project Manager, SQL Server 7 dba and data architect, senior GUI developer and ASP server-side programmer on a business-to-business web application. NT 4.0 Enterprise Server, SQL Server 7.0 Enterprise Edition, Internet Information Server 4.0 (IIS), ADO. Business requirements, analysis, design, system architecture, schema design, physical-logical tablespace allocation, ASP Server-side VB script, PERL/CGI and HTML/DHTML programming, front-end GUI design and implementation. Visual Studio 6.0, script debugger, ODBC connection pooling, Symantec PowerDesigner DataArchitect for Entity-Relationship diagrams, schema design, scalability testing, business rules and object repository. Environment: SQL Server 7.0 Enterprise Edition, NT 4.0, IIS 4.0, Perl, ODBC, Access, Visual Studio 6.0, object-oriented design and analysis.

ATS/MerchanTrust, Brentwood, CA: August to September 1999. SQL Server 7.0 database administration of high-volume OLTP three tier internet application, tuning, trouble-shooting. Designed and implemented migration to Microsoft NT cluster active/active configuration on Dell 6350s with Dell Fiber Channel RAID array, cluster creation and administration, optimizing queries, design and implementation of referential integrity, conversion of dynamic SQL to Transact SQL stored procedures, analyzed and designed implementation for replication, data warehousing design and implementation for profit-center optimization and business analysis. Environment: SQL Server 7.0, Microsoft Cluster Server, NT 4.0, replication, Transact-SQL, data warehousing.

IBM Solutions Developer project - May to July 1999. Design, development, and quality assurance of supply chain vertical market GUI front-end and back-end module for IBM's San Francisco framework, VisualAge Smalltalk, Java, SQL Server 7, DB2/UDB, Oracle 8.0.5, Unix, AIX, Windows NT. Environment: Oracle 8.0.5, DB2/UDB, Unix, AIX, Windows NT, Java, object-oriented design and analysis.

Ralphs Grocery, Compton, CA: February to April 1999. SQL Server 4.2, 6.5 & 7.0 dba, Y2K remediation of Smalltalk & SQL Server upgrade compliance; design, code and implement ObjectRexx GUI interface and applications in support of SQL Server accounting database. Business requirements, analysis, design, coding, testing, documentation. SQL 4.2 to 7.0 conversion of new reserved words in all database objects, EXEC SQL statements in Smalltalk CLS files, and stored procedures. Replacement of OS/2 messaging system with ObjectRexx for NT code. Microsoft SQL Server 4.2, 6.5, and 7.0; OS/2 2.11, NT 4.0 Service Pack 4, Enfin Object Studio 6.0, ObjectRexx for NT version 1.0.2.1, PVCS. Environment: SQL Server 4.2, 6.5, and 7.0, Smalltalk, REXX, NT 4.0, PVCS.

Kaiser Permanente Group, Pasadena, CA: August to November 1998. Oracle 7.3.3 and 8.0 DBA - PL/SQL Developer. Installation, configuration and maintenance of multiple (10+) remote-site Oracle NT servers; application development support; QA; design and implementation of on-line automated backup scripts; design and implementation of Oracle Failsafe failover on Microsoft NT Cluster Server. Windows NT 4.0, Oracle Enterprise Server 7.3.3. and 8.0, Oracle Failsafe 2.1.3, PowerDesignor data modeling software, Microsoft SMS, Oracle 7.3.3, Oracle 8.0.5. Environment: Oracle 7.3.3 and 8.0, NT 4.0, replication, PL-SQL, Microsoft NT Cluster Server, failover.

Paramount Digital Entertainment, Hollywood, CA: April 1998. Oracle 8.0.5 DBA. Installation, configuration, and optimization of Oracle 8.0.5 on Sun Solaris 2.6 running on Sun Enterprise 450 with 1GB RAM and 50GB RAID 5 DASD. Reconfigured Solaris kernel to create Oracle shared memory and segments, created groups, users, logon shells, tablespaces, extents, archive logs, ran Oracle scripts to create stored procedure and import/export functions, TCP/IP configuration, listener. (Star Trek website).

Environment: Oracle 8.0, Sun Solaris 2.6, RAID.

IBM Solutions Developer April 1997 to March 1998. Requirements, analysis, design, coding, and quality assurance of shrink-wrap GUI front-end and back-end module for dbPublish to enable formatting and layout information stored in Oracle 7.3.3, DB2, and SQL Server relational database. Logical and physical database schema design and implementation, stored procedures, triggers, referential integrity. Environment: Oracle 7.3.3, SQL Server, DB2, Access, Windows NT

IBM Solutions Developer Project - May 1996 to April 1997. Development of shrink-wrap GUI front-end and add-on module for San Francisco vertical market framework. Environment: Java, object-oriented design and analysis, Sun Solaris, Windows NT.

ISC, Inc. - Glendale, CA / Huntington National Bank, Columbus, Ohio, April 1995 to April 1996. Oracle 7.3.3 DBA / PL/SQL Programmer. Specification, design, quality assurance, and implementation of two-tier client-server remote-access positive-pay imaging and financial accounting system for Ohio's Huntington National Bank. RS6000, AIX, OS390, Oracle 7.3.3, MS Visual C++, Windows 95 / NT / 3.11. Design and implementation of Oracle 7.3.3 relational database schema, PL/SQL stored procedures, DASD allocation, business rule allocation, referential integrity. Specification, design, sourcing, and implementation of 80GB DASD storage, including multiple fast & wide SCSI controllers, tape archival system. System optimization, including physical DASD allocation of Oracle data files, indexes, & system files, Oracle Developer2000, Oracle Forms, Oracle Reports, C and shell scripts to convert raw data for import into Oracle database - 10 months. Installation, configuration, and customization of HP-UX ver. 10 on Hewlett-Packard mini-computer; installation, configuration of Oracle 7.3.3 relational database on HP-UX system; customization and integration of Oracle with third-party accounting system; integration of HP system with NT network - 2 months. Design, testing, and implementation of GUI front-end and back-end extensions to three-tier client-server application using Visual Basic, HP View, SUPERTOOL, Fantasia, Image SQL, TurboImage DB, SQL Server, Windows NT, Novell, Windows 3.11 workstations, TCP/IP, Sniffer network protocol analyzer. Redesign of SQL Server schema, referential integrity, stored procedures, indexes, system optimization and tuning. Designed and implemented improvements to network bandwidth, including network segmentation, smart hubs, conversion from NETBIOS to TCP/IP - 3 months. Environment: Oracle 7.3.3, PL/SQL, Visual Basic, RS6000, AIX, VSAM, OS390, HPUX, C++.

IBM Solutions Developer - January to April 1995. Designed & developed database publishing GUI front-end and back-end add-on in a relational database to improve production process for printing catalogs. SQL Server, Oracle 7.1, DB2, dBPublish, Windows 3.1, OS/2. Logical and physical schema design and implementation, stored procedures, triggers, referential integrity.

Environment: SQL Server, Oracle 7.1, DB2, Windows 3.1, OS/2.

Southern California Gas Company - Los Angeles: September to December 1994. Business requirements analysis and documentation; design, coding, modification and creation of Smalltalk GUI front-end and back-end base/user classes and class/instance methods. Data export/import, Excel, design, coding & testing of macros; OS/2, Enfin/3, Smalltalk, Excel, Visual Basic. Environment: Smalltalk, OS/2, Access, Excel, Visual Basic.

College of the Desert - Palm Springs, CA: August 1994. Debugging and problem resolution of Gupta SQL Windows application. Novell, SQL Windows. Environment: SQL Windows, Novell.

Farmers Insurance, Inc. - Los Angeles, CA: April to July 1994. Programmer. Design, coding, and delivery of in-house GUI and back-end application logic version-control tracking system used by 200+ software engineers working on conversion of flat-file mainframe database to DB2 relational database. OS/2, VisPro REXX, IBM C Set C++, DDCS/2, DB2. Environment: OS/2, VisPro REXX, IBM C Set C++, DDCS/2, DB2.

Texaco Refining & Marketing - Universal City, CA: November 1993 to February 1994. Quality Assurance, debugging, program re-design, and problem resolution of show-stopping development problem on client server mission-critical project. Designed and delivered OSI model diagnostic methodology. Environment: Oracle 7.1, PowerBuilder, Smalltalk, Windows 3.11, Oracle - Data General AViiON running Unix, DBWIN, NuMega BoundsChecker, Network General Sniffer, FTP TCP/IP VxD stack, LAN Manager, Ethernet.

Nighthawk Services, Inc. - Lawndale CA: April to July 1993. Design, installation, and support of 8-user Novell 3.11 network, including custom application development for this air freight / bonded warehouse operation. Environment: Dell 486/33 EISA server, Adaptec SCSI adapter, 2 Conner SCSI mirrored 500MB drives, Wangtek SCSI tape backup, PowerChute with Smart UPS, 3-Com Ethernet. FoxPro, Word, Access, Excel, Windows 3.11, DDE, OLE, Peachtree Accounting, Crosstalk Mark 1, NACS, NSA Adapt SNA, APPC LU 6.2 connection to U.S. Customs mainframe in Washington D.C.

Coldwell Banker - Mission Viejo, CA: September 1992 to March 1993. IBM Branch Office sub-contract programmer. Design and development of Windows-based invoicing application, including GUI front-end, application layers, and SQL back-end interface to mainframe. Use cases, UML, Wirf's-Brock Object Oriented design. Environment: Workplace Shell environment ("drag & drop"), Enfin, Smalltalk, EDA/SQL, SQL Server, DB2, CICS, VSAM, Windows 3.11, DOS 5.0, IBM LAN Server.

SCE Nuclear Facility - San Onofre, CA: May to July 1992. Evaluated C and Quick Basic for integration of programmable dosimeter into existing applications - MS-DOS, Microsoft C, Quick Basic. Environment: MS-DOS, Microsoft C, QuickBasic.

Bank of America - Concord, CA: February to APril 1992. Designed and coded conversion tracking system for 80,000 Security Pacific commercial accounts, including GUI front-end and application logic. Environment: MS-DOS, Banyan Vines network, Clipper 5.01.

AVCO Financial - Irvine, CA: March to September 1991. MS-DOS to OS/2 conversion of seven COBOL PC to IBM 3090 host MVS/CICS GUI interface programs used in 700+ branch offices nationwide: 300+ multi-panel screens, Menu system, Transaction Handler, Cash Drawer Journal, Overnight Reports, Host-workstation messaging & query. Environment: IBM OS/2 1.3 LAN Server Token Ring network. Realia COBOL/2, MicroFocus COBOL/2, IBM C/2, Easel, Panvalet, VMS, LU 6.2 APPC, Network Services/2, Communication Manager, SNA, CUA.

IBM-Security Pacific Automation Corporation - Glendale, CA: July to September 1990. Quality Assurance - Design, building, and running of Systems Integration and Functional Verification test scripts for large-scale IBM High-speed Imaging Project (HSIP). Environment: IBM 3090 - OS/2 Presentation Manager environment. Microsoft C 6.0, IBM C/2, DB2, QMF, ISPF, ACF, EHLAPI, LU 6.2, SNA, Communications Manager, LAN Server. Logical and physical schema design and implementation, stored procedures, triggers, referential integrity.

Union Bank - Monterey Park, CA: April to July 1990. Designed and delivered multi-user purchasing and inventory system for end-user computing department, including GUI front-end, application logic, and database schema. Environment: MS-DOS, Banyan Vines, Clipper 5.01.

D. A. Campbell, Co. - Los Angeles, CA June 1987 to November 1989. Application Developer. Custom application development, including multi-user sales tracking/mailing system. Environment: IBM OS/2 1.2, LAN Server, Token Ring. IBM Database Manager, SQL, IBM C/2. Logical and physical schema design and implementation, stored procedures, triggers, referential integrity.

Barger & Wolen Law Firm Los Angeles, CA - September 1986 to May 1987. Unix Systems Administrator / Programmer. Operations and support of 75-user Unix system, including word processing, calendaring, electronic mail. Wrote automatic tape-archive program, conversion of LEXIS sessions to word processing documents, user-friendly menu system for terminal selection, MS-DOS and Unix integration of programs and data files. Spec'd, designed, & sourced 4-wire multiplexed leased lines between LA-SF and LA-SD offices. Environment: AT&T Unix System V, Bourne & C Shell, Informix, Unify relational database.

Hal W. Williams, Jr. Law Firm Studio City, CA - April to September 1986. 9/86 Systems Manager / Word Processing Supervisor. Design, installation, and operation of Novell Network with four workstations and two laser printers. Conversion of Displaywriter to Displaywrite 3 and 4, document assembly system, training and supervision of word processing operators. Case management, calendaring, statute of limitations and case status reports using dBase III and Clipper. Environment: IBM Displaywrite 3 and 4, dBase III, IBM PC AT and XT PC's, Canon and Hewlett-Packard laser printer, IBM Pageprinter. MS-DOS, Novell, Clipper.

Contract Computer Operations/Programming Los Angeles, CA - September 1982 to February 1986. Contractor. Legal time and billing, word processing, litigation support, pleading, contracts, corporate and real estate, financial. IBM Displaywriter, Office System 6, IBM 5520, Mag II, NBI, Wang. Aero Alloys - Fullerton, CA. Designed and delivered multi-user cost-accounting / bar code system for metal-casting operation. MS-DOS, Novell network, Clipper. Westwood Music - Los Angeles, CA. Sales tracking/mailing system for music store. MS-DOS, Clipper. Legal Careers - Century City, CA. Employment agency placement / tracking system. MS-DOS, Clipper. Environment: MS-DOS, Clipper, Novell, IBM Displaywriter, OS6, IBM 5520, NBI, Wang.

Rossco, Inc. Beverly Hills, CA January 1981 to August 1982. Project Manager / Programmer. Designed and implemented applications for property management, accounting schedule of payments, calendaring, 50,000 multi-page personalized mass mailing, trained and supervised data entry operators and collating staff. Environment: UCSD Pascal System, IBM Displaywriter.

Comptek, Inc. Los Angeles, CA April to December 1980. Marketing / Applications Support Representative. Systems configuration and implementation, data conversion, training, sales and applications support on turnkey multi-user systems, including time and billing, calendaring, financial analysis, litigation support and word processing. Environment: Data General RM-DOS and AOS on Nova and Eclipse mini-computers.

Wolcott, Inc. - Financial Public Relations - Los Angeles, CA October 1972 to September 1973. Research and preparation of financial reports for stock offerings, red herring documents, and annual reports.

Carter, Hawley, Hale Corporation Los Angeles, CA June 1971 to September 1972. Systems Analyst. Procedures and forms design for operations, finance, marketing, security, advertising, sales projection, management reports, marketing plans.

SKILLS

Skill Name Skill Level Last Used Experience

Oracle 7.3.3, 8.0.5, 8.1.5, 8.1.6, 9i, 10g Expert Currently used 7 years

SQL Server 6.5, 7.0, 2000 Expert Currently used 5 years

IBM DB2/UDB EE, EEE, 7.2, 8.0 Expert Currently used 4 years

Data Warehousing Expert Currently used 5 years

Microsoft Cluster Server Expert Currently used 4 years

Borland Delphi Expert Currently used 4 years

Smalltalk Expert Currently used 5 years

Object-oriented, Use Case, UML Expert Currently used 7 years

Unix Expert Currently used 10 years

Broadvision Administration Expert Currently used 1 years

Java Intermediate Currently used 3 years

HTML, CGI, Perl, etc. Intermediate Currently used 3 years

ASP Intermediate Currently used 1 years

ADO Intermediate Currently used 1 years

CORBA Intermediate Currently used 1 years

Orbix Intermediate Currently used 1 years

Active X Intermediate Currently used 1 years

COM Intermediate Currently used 1 years

.NET Intermediate Currently used 1 years

XML Intermediate Currently used 1 years

COBOL Expert 1 years ago 4 years

SNA/SAA, LU 6.2, ISPF, APPC, EHLAPI Intermediate 1 years ago 9 years

C++ Intermediate 1 years ago 2 years

SPECIALIZED TRAINING:

BroadVision Performance Analysis, August 2000. Configuration, Analysis, & Tuning of BV servers and e-commerce websites. Troubleshooting, scalability, heuristics, testing & monitoring tools.

MS NT Cluster Installation Configuration & Maintenance - September 1998. High-level design and architectural concepts, cluster configuration methodology, IP addressing, SCSI configuration and troubleshooting, fail-over concepts, high-availability optimization.

IBM Object Technology University:
VisualAge C++ for Windows NT - 4.5 days - 8/19/96
Application Construction Using VisualAge for SmallTalk - 5 days - 11/4/96
Practicing Object Oriented Analysis and Design - 4.5 days - 2/3/97
VisualAge for COBOL for OS/2 Application Development - 4.5 days - 3/3/97.

IBM Education & Training:
OS/2 Warp Server Administration I - 4 days - 11/10/95
MQSeries Transaction Processing - 5 days - 11/17/95
VoiceType Dictation Technical Fundamentals II - 1 day - 8/16/96
OS/2 LAN Server 4.0 admin workshop I - 3 days - 8/26/96
MQSeries Application Programming - 3 days - 9/10/96
OS/2 Warp Server Workshop - 4 days - 9/24/96
OS/2 Warp Technical Training Fastpath - 5 days - 10/14/96
Data Base Administration workshop for DB2 for AIX - 5 days - 10/21/96
Data Base Administration workshop for DB2 for OS/2 - 5 days - 10/28/96
DB2 Common Server Overview and Fundamentals - 2 days - 11/11/96
AIX Administration I - 4.5 days - 11/19/96
MQSeries Application Programming - 3 days - 12/3/96
OS/2 Warp Server Update - 5 days - 1/27/97
Technical Introduction to MQSeries - 2 days - 2/10/97
MQSeries Technical Workshop - 3 days - 2/12/97
MQSeries Application Programming - 3 days - 2/19/97
Warp Server Admin I - 4 days - 3/18/97
OS/2 LAN Server 4.0 Administration Workshop I - 3 days - 4/15/97
Transaction Server: CICS for AIX implementation - 4.5 days - 5/12/97
e-Business Technical Workshop - 1 day - 5/13/97
Warp Server Update - 5 days - 1/31/97
Practicing Object Oriented Analysis & Design - 5 days - 2/6/97
Technical Introduction to MQSeries - 2 days - 2/11/97
MQSeries Technical Workshop - 3 days - 2/14/97
OS/2 Warp Server Administration I - 4 days - 3/21/97

EDUCATION:

Southwestern University School of Law, Los Angeles, CA: September 1974 to May 1978. First and second year courses, including Torts, Contracts, Entertainment Law, Copyright Law, Criminal Law and Procedure Civil Procedure, Real Property, Wills and Trusts, Community Property, Family Law, Insurance Law, Sales, and Evidence.

California State University, San Bernardino, CA: January to May 1973. MBA courses. Marketing, Administrative Communications, Finance, Accounting, Managerial Accounting, Quantitative Analysis.

University of Southern California, Los Angeles, CA: September 1966 to June 1971. BA in English Literature. Four-year California State Scholarship, USC. National Merit Finalist; California Scholarship Federation; Lambda Chi Alpha Fraternity Service Award.

References available on request.