photos | dave's resume | dave's writing | software | dvd library

david kerr

Professional Summary

Eight years IT professional working with ERP systems and databases
Creative thinker with proven leadership skills
Worked as Technical Team Lead, Senior Oracle DBA, Systems Administrator and Technical Analyst
Oracle Certified Associate (OCA) with Oracle 10g
Published articles for Oracle setup and tuning

Work Experience

Infor/SSA Global Technologies	Team Lead
Grand Rapids, MI	Janurary 2005 -- Present

As a Team Lead of the Core Technologies Group I manage a team of approximately 15 Technical Support Consultants. My duties include maintaining support readiness, handling customer escalations, case, salary and performance reviews as well as managing day-to-day activities of analysts.

Some successful projects that I've initiated include:

Major call intake procedure improvements, which resulted in an improvement of call output by 50%.
Implementation of an internal 'Wiki' website for knowledge sharing and documentation repository.
Morale improvement project involving movie night and focusing on "Fish" philosophy.
Implementation of Jabber IM protocol for secure communication with remote offices and increased teamwork on incoming cases.

In addition to these duties I also perform scoping for consulting engagements, allocate and manage resources and act as the Technical Lead for all services. I also work on special projects including performing training, writing articles for internal and customer publications and attending trade shows and user groups.

Communication skills, Self-reliance, crisis management, time management, multi-tasking skills and the ability to keep up with quickly evolving technologies are all required traits of this position.

SSA Global Technologies	Senior Technical Support Consultant
Grand Rapids, MI	April 2002 -- April 2005

This position required that I work extensively with Oracle and have a familiarity with IBM UDB (DB2), Informix and Microsoft SQL Server. I would also diagnose and resolve both database and non-database related technical problems, debug programs, troubleshoot OS and connectivity issues. Handled high profile cases and customers. Worked as liaison between support and development

I was awarded the SSA Global "PRO Award" for outstanding professional excellence for my work with designing and implementing SSA's Application Management Services.

L-3 Electron Devices	Oracle DBA Consultant
San Carlos, CA	Janurary 2000 -- April 2002

In this position I act as the primary Oracle, Unix and Baan administrator. The environment is a Baan 4c4 system on HP-UX running Oracle that supports 150 users in two locations (California and Pennsylvania). My primary responsibilities include:

Managing and maintain all Baan and Oracle systems
System security (Oracle and Baan)
System monitoring (24x7 support)
Monitor and tune system performance
Install and test OS, Database and Baan patches
Create and implement disaster recovery plan
Maintain the test environment
Creation of Unix shell scripts and perl scripts, oracle triggers, Baan 4GL programs to handle data problems, monitor the system, or customize the Baan ERP package.
Troubleshoot functional and technical problems (requires extensive tracing and debugging)
Writing technical documentation
Make recommendations for and perform all duties regarding migrating Baan and the database to new hardware.

ComauPico	Senior ERP Administrator
Southfield, MI	Janurary 1998 -- Janurary 2000

My work at ComauPico was primarily as Sr. Baan Systems Administrator and Oracle DBA. I maintained the Baan and Oracle systems on a 24x7 on-call basis. I wrote and maintained system and application monitoring programs across all systems. I wrote shell scripts and PL/SQL programs to automate repetitive tasks. I managed security, upgrades, patching backup and recovery of the Baan and Oracle systems. My duties also included meeting with end users to determine system requirements and researching new products, software and new methods for doing business.

Along with my administration duties I did some development, including designing and coding Pro*C programs to run an internal homegrown barcode scanning system using Intermec scanners. This design had to take into account installation, setup and maintenance of 45 Oracle-NT databases, barcode scanners and networking. Another project involved developing PL/SQL code for use with Oracle 9i AS to create a CRM website.

Technical Skills

Databases: Oracle 7/8(i)/9i/10g, DB2 v8, SqlServer 2000
ERP: Baan (All versions), SSA ERP LN
Operating Systems: Unix (Solaris, HP-UX, Compaq Tru64), Linux (SuSE, Red Hat), Microsoft Windows
Programming: PL/SQL, Perl, C/C++/Objective C, Pro*C, HTML, CSS, XML, Unix Shell Scripting, sed, awk

Education

Bachelor of Science in Computer Science (1997 - Western Michigan University)

Certifications

Oracle Certified Asscociate - OCA (Oracle 10g)
Baan Logistics
Baan Tools (Expert Level)

Publications

Advanced Guide for 3 Tier Oracle setup and Baan (SSA Global 2004)
Performance Tracing with SSA Global Flow Monitor (BWU Newsletter, Feb 2004)
Oracle 9i: A Whole New Animal (BWU Newsletter, Feb 2005)

Professional Organizations

Baan World Users Group (Member Performance Subcommittee)
Oracle Users Group (Grand Rapids, MI)