OBJECTIVE

An engagement in software and database architecture, design and development involving, but not limited to, one or more of the following: data modeling; Oracle; PostgreSQL; Haskell; LISP, temporal data; data warehousing; SCADA; analysis and simulation; ETL; OLAP; OLTP; functional programming; declarative programming

EDUCATION:

M.S. Computer Science

B.S. Mathematics, W.M.U.

EXPERIENCE

1990- Software and Database Designer and Developer (Consulting/Contract) 07/09- Confidential

Summer of Haskell; Selenium RC test framework; darcs; cvs2darcs; DOM; Xpath; Xquery; JSP; CGI; Javascript; Perl; Oracle 11g; PostgreSQL; MySQL; MS SQL; SQL Server; Visual C#; .NET 2008 SP1; ARCgis SQL; ARCmap geoprocessing. Proposal development. Bench.

10/07-06/09 Confidential (Cambridge, MA)

Oracle 11g: PL/SQL, utPLSQL; Advanced Queuing; Oracle Streams; RLS; Perl; Lisp; svn; Erwin; zsh

Data Architect Lead for next generation airline reservation system. Object relational mapping. Physical data architecture. Framework evolution. Performance tuning.

10/05-07/07 Confidential (formerly Wireless Applications and Consulting Service) (Minneapolis, MN)

Oracle 10g R2; SQL; PL/SQL; CVS; ERwin; Visio; CM; PL/SQL Developer; utPLSQL; subversion (svn)

Designed implementation for advanced automated meter read (AMR) estimation and validation analytics using highest level Oracle rollup and materialized view capabilities. Developed backend aggregates for meter read management. Developed meter read gateway staging for ETL. Developed configuration management methods. Provided data model review; and test and configuration data infrastructure. Implemented complex California Public Utilities Commission validation, editing and estimation method 2 (CA-VEE). Led test driven development effort. Led timezone and DST2007 technical development. Harvested functional requirements for virtual metering and rate analysis capabilities

1/05-8/05 Confidential (Austin, TX)

Oracle; Ab Initio; MQ Series; SQL; PL/SQL; CVS; PowerDesigner10; TOAD; SQA

Software Quality Lead for new, semiconductor fab data warehouse. Analysis, testing and development involving data models, enterprise data bus; performance and ETL

5/04-10/04 Confidential (Farmington Hills, MI)

Data modeling; Oracle 10g; “SQL model”; data mart; SQL*Loader; ETL; materialized views; CVS administration

Designed an electrical energy load forecasting data architecture for a retail electrical provider\'s market trading processes (ERCOT market). Developed critical analytic applications. Established source control infrastructure. Performed data and dimensional modeling, and logical level DBA support (>300 tables, >1000 objects). Supported ETL development. Performance tuning. Attended DCI/Date Advanced Concepts in Database Management Seminar

10/03-12/03 Confidential Richmond, VA)

Oracle; SQL; PL/SQL; OLAP; ETL; Data mart; OWB; Crystal Reports

Performance and data model analysis for agricultural product quality and manufacturing performance data mart ETL and OLAP

An analyst, developer and designer in both a lead consulting and a hands-on capacity. Performed a complete analysis of recently developed OLAP cubes that represented agricultural manufacturing quality and production data. Facilitated data model surgery involving the cubes -- particularly regarding the proper use of surrogate keys. The dimensional models resided in ERwin. Designed intricate view materializations for cube rollups. Reviewed all data mart SQL and PL/SQL in regards to performance and made many performance improvements. Analyzed the data marts and related ETL processes for data quality issues. Facilitated cures for those data quality issues which were found. Was hands on with Crystal Reports so as to review reporting code and to develop Crystal/Oracle performance improvements for use by the reporting team. Worked closely with the ETL developers to analyze performance and resolve OWB ETL process data quality issues. This OWB work included troubleshooting OWB generated PL/SQL. Worked performance and data model quality issues with DBAs responsible for data marts, OLTP and OLAP beyond the initial scope of work involving manufacturing quality and production subject matters

6/03-8/03 Confidential (Palo Alto, CA)

Oracle 9.2, 8.1.7; SQL; PL/SQL; Java; OLAP; OLTP; Apache; TOAD; OEM; SQL*Navigator; AIX; Windows NT 2000 and XP

Analysis and repair of vendor communications management system database, performance and integrity, errors and omissions. Tuning, Data Model analysis.
Financial report run times were reduced from hours down to minutes. OLTP search performance response time chief complaints were reduced from minutes down to seconds or less. Other OLTP functions that took seconds were reduced down to sub-second. An extensive process of analysis of the production system yielded seventy five bug reports to the vendor. All reports included analysis and a thorough exposition of the required tuning or data model changes where such changes could not be done solely by this analyst on behalf of the customer. Data quality issues were also discovered and analyzed as well.
Part of this effort was forward looking in that incipient performance problems were identified so as to reduce time bombs associated with table and load growth. Part of this effort involved mentoring a junior report developer and a DBA

4/00-12/02 PaeTec Confidential (Rochester, NY)

Oracle 9.2, 8.1.7, 7.3 DB and AS; SQL; PL/SQL; SQL*loader external tables; XSQL; XML; J2EE; JSTL; jDeveloper; UML; OLAP; OLTP; XEmacs Lisp; Java; JSP; Apache Tomcat; TOAD; SQL*Navigator; OEM; RMAN; Workflow; Alerts; Materialized views; DMT; LMT; Linux; Windows NT 2000 and XP; ER; Oracle Designer; CVS; XML; XSQL

Summary: Communication Management System development, development process and standards development. Performance tuning. Software and database instruction. 
Reported to an engineering vice-president of a 100 person software product company. Served as a developer\'s developer by performing monthly database development reviews and seminars. Served as the developer and DBA of last resort for developers with tough logic and performance problems. He routinely tuned OLTP product functions to bring response times down from minutes or seconds to sub-second. He routinely tuned OLAP and batch processing functions to bring response times down from days and hours to minutes and seconds. He performed data model analysis in response to security and performance issues. He maintained a powerful reputation as an Oracle performance tuning top talent with the company and the company\'s customer base

Was asked to perform data model design for the start of Pinnacle\'s next generation technology product. Was made responsible for establishing database schema requirements and design in an object-relational context. Extended strong backend development capabilities by updating knowledge and competence in relevant front end technologies. This process was a natural extension of prior client-server and occasional web front end experience. This led to responsibility for database schema support for Oracle and Sun Java J2EE based Web technologies including JDeveloper, UML, JSP, JSTL, JavaBeans Components, HTML, JDBC, XML, XSQL, Workflow and BC4J. He was made responsible for the product\'s future schema enterprise security framework, normalization, domain analysis, materialized views, temporal data techniques, subject area interviews, prototyping, ER models and RDBMS design synthesis. Allegro Common Lisp code was converted to run under XEmacs Lisp. This code implemented relational synthetic methods for recurring normalized design efforts for communications management – as a complement to ER and decomposition methods. 
Incidental efforts included performing large scale product conversions involving multi-company, multi-tenant functionality. Was co-responsible for adaptation of CVS for use in configuration management. Began a shift to RMAN from traditional backup and recovery processes. Likewise for SQL*loader (as external tables). Contributed ideas that led to cost avoidance, never failed to satisfy those mentored. Had an ethical executives rapport with Pinnacle\'s customers even in difficult circumstances

6/99-3/00 Confidential (Ann Arbor, MI)

Oracle 8.1.7 DB and AS; MVS; Oracle Forms and Reports; Excel; Business Objects; CVS; TOAD; Peoplesoft Financial

Summary: Communications Management System conversion and reporting for Y2K avoidance. 

Addressed conversion issues involving data cleansing; legacy extract-transform and load (ETL); referential integrity conflicts and omissions; Peoplesoft financials and Business Objects data warehouse in a product startup and integration context. Did application performance tuning to bring many OLTP functions down from minutes to sub-second and many batch and OLAP functions down from days or hours to minutes.

Was recognized as a top Oracle developer AND DBA talent. Was made the development and application integration team liaison to the University\'s DBA group. Efforts were pivotal in the successful cutover and continuation of communications services for this world-class university – was successfully recruited by the communications management systems vendor

12/98-5/99 Confidential (Dearborn, MI)

Oracle 8.1.6, ERwin, Hyperion Essbase. QAD Financials.

Successfully designed and built the Oracle dimensional data warehouse for rollup of dozens of distributed UT automotive plant\'s QAD financials sales and purchasing data. Developed the extract-transform-load (ETL) functions. Used ERwin for comprehensive shared data modeling for hundreds of entities. The warehouse was used to feed Hyperion Essbase OLAP cubes. Formulated enterprise wide solutions that pulled data together into decision support dimensions from both the sales and the purchasing perspectives for OLAP analysis

7-11/98 Confidential (Troy, MI)

Oracle Financials and Manufacturing 10.7. 11i awareness; SQL; PL/SQL; C; PVCS; Oracle Forms and Reports; Solaris; TOAD

Was the lead developer for customizations to Oracle Financials and Manufacturing involving AP, AR, GL, PO, BOM and routing functions. This effort included both domestic and foreign operations for the worlds largest axle systems company. This effort was part of a legacy conversion for Y2K avoidance and modernization. Led two other developers in customized Oracle Reports report development as extensions to Oracle applications functionality. Developed some of the reports and also did Oracle Forms development. This effort involved a through knowledge of Oracle application customizations by extension standards and the Oracle Financials and Manufacturing data models. This included in depth work involving particularly challenging bill or material problems. Served as the client point of contact to Oracle Applications consultants and support

4-6/98 Confidential Kalamazoo and Detroit)

Performed LabView SCADA development; professional writing; Oracle 8 and Java self-education. Was a trainer in software development requirements engineering for a mix of people including more than a dozen Chrysler personnel. Became the first webmaster for the West Michigan Section of the Institute of Electrical and Electronic Engineers website

11/95-3/98 Confidential (Gary, IN)

Oracle 7.3, Oracle Forms, Reports and Graphics, SQL, PL/SQL, SQL*Loader, VB, C, VAX/VMS, DEC Unix, SCO Unix, ETL, DW, OLAP, OLTP, ksh, Perl, awk, i2

Summary: Oracle 7.3/Developer 2000/UNIX. Successful design and build of SCADA data warehousing for hot strip and pickle mills for quality tracking (Graphics, Tuning, Ksh, Awk, Perl, Pro*C). Industrial instructor for formal training in relational design, SQL, PL/SQL and SQL*Loader. Design and development reviews of truck entry control and caster maintenance systems

Began tenure at Steel by devising extract-transform-load (ETL) techniques for warehousing hot strip mill data that took weeks rather than months to develop. These Level II SCADA data warehouse capabilities involved twenty thousand values spread over two thousand variables every two minutes. He developed similar capabilities for other mills, e.g. pickling. Was involved in enterprise integrated steel mill quality tracking across the products development from steel making , through rolling and treating

In addition to extensive ETL, data warehouse and OLAP work, performed critical incidental work in other areas. He consulted on performance issues for an AI expert systems use of persistent data stores in Oracle for the purpose of steel making scheduling and matching to customer orders. He devised extensive emergency fixes to i2 supply chain management ETL code so the works could continue operations. Did the systems programming development to interface truck scale data acquisition to Oracle in real time. Performed data model design reviews and taught relational database design, SQL and PL/SQL to legacy and new programmers

5-10/95 Confidential Plymouth, MI)

C++/MFC, ODBC, Access, SQL, Sockets, TCP/IP, FTP, UDP, ICMP

Summary: Successful distributed processing communications design and build for drivers license, real time in the field, production system

5/95 Confidential (Ann Arbor, MI)

C++/MFC, DDE, OLE, Powerbuilder

Began an API design targeted to C++/MFC for a document management product venture with hundreds of existing customers. Was invited in the 11th hour of this venture capital funded misadventure

2-3/95 Confidential Communications (now Frontier Communications) (Green Bay, WI)

Oracle 7.x, Oracle Reports, SQL, PL/SQL, SQL*Loader, AIX Unix

Summary: Successful voice messaging response call detail and call statistics reporting contributing to acquisition of the call center teleprocessing company

10/94-1/95 Confidential (Troy, MI)

Oracle Financials, Oracle Forms and RPT, Oracle 7 DB, SQL, PL/SQL, SQL*Loader, query tuning. AIX UNIX, MVS, KnowledgeWare ADW data modeling, SCCS

Summary: Major reporting strategy role while teamed with Price Waterhouse involving Oracle Financials GL data mart for a retail industry consolidated corporate financials.
This effort involved ETL from over two thousand stores in an Oracle financials based data warehouse and OLAP capability. Performed debugging on some reports. Was pivotal in solving performance issues where many functions run times were projected to take weeks were brought down to minutes and hours. This experience led to an article in Database Programming and Design

7/91-10/94 Confidential (MI)

Oracle 7, SQL, PL/SQL, Smalltalk; Excel and Word macros; Oracle Card; Reportwriter (pre-Oracle Reports); ALCIE Financials; ethernet design and build; data modeling and OOD

Designed and built from scratch a comprehensive third party administration system including policy issuance; claims; management reporting; underwriting and reconciliation

Winter \'92 WMU Adjunct Assistant Professor of EE (Kalamazoo, MI)

Taught five different EECS courses at various times including computer architecture (twice), digital logic, digital electronics, digital design (VHDL) and electric circuits (six times). Managed up to seven graduate assistants

9-10/91 Confidential (Chicago, IL)

Worked on a team that performed data center consolidation of acquired media companies. Performed VAX/VMS systems consulting, ethernet on frame relay troubleshooting and integrated print drivers into the system

2-6/91 Confidential (MI, IN)

Developed ad hoc physical database file manager and access methods for blast furnace real-time data acquisition for level II SCADA capabilities

1/91 Confidential (Chicago, IL)

Performed user interface conversion systems programming

9-12/90 Confidential (Holland, MI)

SQL, PL/SQL, DB2, QMF, DXT, Oracle 7 DB, Oracle Forms, IBM TSO/ISPF/CLISTs/REXX, and VAX systems

Performed relational database analysis for an office furniture industry quality tracking system conversion

Spring and Summer 1990 MS Thesis completed and published

Academic Lisp experience – Thesis completely programmed in Allegro Common Lisp – q.v. Publications section of this resume. This 161 page thesis contains fifty nine segments of described Lisp code highlighted from the complete Lisp simulation program. Completed more than half of programming assignments for various courses in various dialects of Lisp: Xerox PARC InterLisp, Allegro Common Lisp and AutoCAD AutoLisp

1981 - 1990 Confidential MI, (formerly Lear Siegler)

This once top most division in sales of a mid-1980s Fortune 129 company designed and built military and commercial vehicle management systems and avionics. Was a key person in an engineering organization of a seven hundred people. Received formal management training, software methods training and Crosby quality process training

\'88-\'90 Senior Network Communications Analyst

Was responsible for selection process of voice and electronic mail (X.400) messaging systems. He performed a comprehensive needs assessment survey, requirements analysis, vendor RFIs, RFPs and RFQs and constraint programming based economic modeling using Mathematica. Performed LAN and WAN communications design and build. Was involved in telephony for the purpose of eventual convergence

\'87-\'88 Group Staff Engineer and Section Manager

Managed five people responsible for software engineering tools and databases. Knowledge of Oracle SQL relational and Codasyl network databases increased dramatically

\'83-\'86 Senior Staff Engineer, Engineering Facilities and Network Staff

Led Engineering Office Automation and Communications Networks Technology Teams. This effort included executive briefings with Apple, Microsoft and Compaq. Was responsible for the architectural design and advanced development of the 700 user engineering network Developed LSI/ID\'s Seattle Communications Facility and LSI/Boeing Computer Network Interconnect. Consulted on military crash survivable flight recorder communications protocols; was technical director on the M1 Abrams Tank Mobile Packet Radio proposal; supported clustering and scaling analysis for signal processing; developed facilities specifications for airlines navigational database revenue service and consulted on real-time simulation system performance. Brought up Xerox InterLisp Lisp capabilities on VAX systems for following purposes: an Artificial Intelligence two course sequence given by Dr. George Stockman of Michigan State University; Lear Seigler Instrument Division internal research and development (IRAD). Was lent, over a period of two months, a Texas Instruments Explorer Lisp machine for evaluation for the purpose of software engineering support tools and databases

\'81-\'83 Engineer II, I

Developed VAX Facilities backup procedures and he specified real-time VAX Facility and Tektronix Micro Development Facilities [Intel 8086, Zilog Z80], RJE Facilities [DECnet-IBM HASP gateway, 2780/3780, and militarized mylar tape handling]

1975 – 1981 Confidential (Kalamazoo, MI) \'78-\'81 Systems Research Programmer, Academic Computer Center

As a communications network pioneer developed a protocol gateway between WMU\'s DECsystem-10 and the Merit educational computer network (UM, MSU, Wayne State, Telenet PDN). Developed a PDP-11 based DECsystem-10 computer performance analysis tool that was used for discovering network communications performance bottlenecks. He was responsible for enhancement of communications front ends. Was mentored by distinguished operating system pioneers whose work was incorporated in Digital Equipment Corporation products. Some contributions made their way into DEC. Work here was a precursor to an embrace of object-oriented programming and multi-level comprehensive capabilities in performance analysis and tuning

\'78-\'80 Computer Coordinator/Consultant (1/4 time appointment) Center for Sociological Research

Consulted on social survey statistical databases and computing. Coordinated work in large sociological survey contracts, was a project lead for the 10,000 case, 500 variable, Toledo Public School System survey. Managed staff and presented workshops in SPSS, a statistical and data management package. Work here was a precursor to an interest and a second career in relational databases and declarative programming

HONORS, PRESENTATIONS & PUBLICATIONS

• K. Davis, D. Miller and F. Severance, "An Interactive Web-based Analog Grade Computer as an Electrical Circuits Capstone Lab Project," ASEE National Conference, Albuquerque, NM, June 24-27, 2001
• K. Davis, "Curvaceous Circuits: Encouraging Visualization in Mixed Series-Parallel Circuit Analysis," ASEE NCS Spring Conference, Michigan State University, Lansing, MI, March 31, 2000
• K. Davis and D. Miller, "Neural Networks as a Source of Introductory Electrical Circuit Analysis Problems," ASEE NCS Spring Conference, Penn State Erie, Erie, PA, April 9, 1999
• K. Davis, "The Declarative Transpose, "Database Programming and Design, March 1996
• K. Davis, "A Simulation of a Multihop Communications Network Using a Kinematic Topology Generator and Static Sphere-packing Power Control." M.S. Thesis, 1990
• Service Award. On the occasion of the 50th anniversary of the West Michigan Section IEEE. October 23, 2004

PROFESSIONAL AFFILIATIONS AND RESPONSIBILITIES

• Institute of Electrical and Electronics Engineers and West Michigan Section: Chair, \'97+, \'85-6; Vice-Chair, \'83-4; Professional Activities Chair, \'88-\'90, \'91-2; Treasurer \'92+
• Association for Computing Machinery
• Upsilon Pi Epsilon – National Computer Science Honor Society
• International Oracle User Group
• past member American Association for Artificial Intelligence
• past member American Society for Engineering Education. Served as the North Central Section Industrial Liaison and reviewed conference papers and chaired conference sessions