Kenneth E. Denny

200 Parkside Circle, Chapel Hill, NC27516 919-968-9829 (h) 919-604-5082 (c) 

Qualifications Summary

A well-qualified software developer with over 25 years experience in various aspects of software design, development, and support. Particularly strong in database design and implementation. Well-versed in many varied application areas. Extremely competent in many software languages and tools:

Languages/Tools: Unix shell scripts, PL/SQL, SQL, SQL*Plus, SQL*Loader, Visual Basic, Java, Crystal Reports, C, Pro*C, C++, Developer/2000, Oracle Forms, Oracle Reports, TOAD, ERWin, HTML, BRIO, CVS, Clearcase, Microsoft Visual SourceSafe, Microsoft FrontPage, Perl, Korn shell, Bourne shell, C-shell, Unisys LINC, COBOL, ALGOL, PASCAL, Capstone Decision Manager

Databases: Oracle, Sybase SQL Anywhere, Microsoft Access, Unisys DMSII

Operating Systems: UNIX (HP and Sun), Windows 95/98, Windows NT, Windows 2000, MVS, Unisys MCP/AS

Selected Achievements

  • Worked on design and development of major HR application for Credit-Suisse, a worldwide bank. All deliverables were made on time or ahead of time. All defects discovered by QA were corrected easily and system went into production with minimum effort.
  • Designed code changes which reduced run time on an ETL process from 45 hours to 10 hours.
  • Developed database packages to control transfer of data between development, test, and production databases. Procedures were required to be able to pick up new columns that were added to tables without code changes or recompilation.
  • Helped get a large data warehouse project back on schedule. Project had gotten behind schedule and when brought in helped get the project back on schedule.
  • Diagnosed and corrected numerous problems in the revenue and cost reporting software system to streamline the month-end close process, resulting in a 60% reduction in month-end run-time.
  • Functioned as lead designer and developer of a customer configuration database, enabling customer switch configuration retrieval by numerous complex criteria.
  • Served as the designer of the database as well as the developer of the Resource Manager Software portion of the automated telephone circuit testing system, improving the efficiency of the overall testing process.
  • Designed and developed a generic database, enabling users to create tables of data and then query the contents of these tables.
  • Led development for the GUI database interface to the automated telephone circuits testing system, allowing users to query and update the circuit characteristics, view which circuits were currently reserved, schedule and reserve circuits for later testing, and query and update the generic database.

Professional Experience

(04/2006-12/2008) Credit-Suisse (contract)
Member of team to design and buildthree HR applications. The most comprehensive of these wasa web based application where employee objectives and ratings were managed. Employee objectives are set by employees and managers, managers approve objectives and yearly, employees received ratings.All three projects were released on a tight time schedule and all deliverables were met on time. Defects discovered by QA were corrected very quickly and systemswere put into production with minimum effort. Tools used included TOAD, PL/SQL, PL/SQL Developer, ERWin, MS Visual SourceSafe, SQL*Loader, Java, and korn shell. Subsequently charged with support of that same system. Also worked as lead database designer for Awards system and Promotions nominations system.

(08/2005-01/2006) Red Prairie (contract)
Responsible for customer support for Red Prairie Digital Logistix software. Duties included diagnosing and documenting customer support issues, including finding solutions and root causes. Tools used included PL/SQL, SQL*Plus, korn shell, and CRON scheduling.

(07/2005-08/2005) Böwe Bell+Howell(contract)
Responsible developing PL/SQL packagesfor use in critical downtime report. Short term contract required that I become familiar with a very complex system in a minimal timeframe. Tools used included PL/SQL, TOAD, SQL, Crystal Reports, and Visual Basic.

(12/2003-07/2005) Glaxo SmithKline (contract)
Responsible for support of Weekly Sales Reportingsystem while developing replacement system. Replacement system used PL/SQL and korn shell scripts with Oracle 9i database. Once development was complete for replacement system, took over support of it. Responsible for ensuring that weekly processes ran correctly and that reports were correct and delivered on time, troubleshooting problems, tuning to improve performance, and answering user questions. Tools used: korn shell, PL/SQL, SQL, CRON scheduling Visual Basic, TOAD, SQL Navigator, and Excel.

(10/2002-07/2003) Capital One (contract)
Developed PL/SQL packages to manage movement of data between development, test, and production databases. Packages were required to handle new columns being added to tables without code changes or recompilation. Developed PL/SQL packages to allow audited insert, update, and delete of selected tables, eliminating the risk of users using SQL*Plus to perform these updates. Worked on project to facilitate promotion of databases from development to test to production environments. Responsible for writing sql scripts to extract current state of database and generate sql to recreate that database. Responsible for maintaining an Access database used to track database change requests. Responsible for doing performance tuning when necessary. Tools used: Unix shell scripting, SQL, PL/SQL, TOAD, SQL*Plus, Java, and Microsoft Access.

(07/2002-09/2002) Royal & Sun Alliance(contract)
Responsible for writing ETL code using PL/SQL for Royal & Sun Alliance, a major business insurance vendor. Code was used to move and validate large quantities of data moving from the legacy system into the data warehouse running under Oracle 9i. Code was implemented in PL/SQL stored procedures grouped into packages. When originally brought on board the project had fallen four weeks behind schedule. Within ten days project was back on schedule and project deadlines were met.

(03/1997--02/2001) Nortel Networks (contract/full time)
Development team design leader in developing a telephone switch configuration database. Developer of all stored procedures and packages, which were extensively used in the database. This was an Oracle database and most of the application programs were written in Pro*C and the rest in Perl. Prime support person for Product Profitability, a financial reporting system consolidating data from diverse company segments into corporate financial reports.Duties included: making sure all programs in the process ran correctly, finding the root cause and correcting problems, tuning queries, making code changes to implement new features and correct bugs as required, and tracking down causes of discrepancies in numbers between Product Profitability and other systems. Code was written primarily in Pro*C with lots of embedded PL/SQL. In addition there were some C++ programs and some straight PL/SQL programs. Also responsible for designing queries to pull data from an Access database into Oracle. Y2K team for same database, and responsible for almost all Y2K C and PL/SQL code changes. Y2K team for another Nortel customer billing database, responsible for C and PL/SQL code changes including changes to stored procedures, also developing and implementing test plans.

(04/1995-03/1997) Insight Industries, Inc.(full time)
Software Engineer. Designed and developed database for use in phone circuit testing reservation/scheduling system to run on HP-UX. Database made extensive use of triggers and stored procedures. This was an Oracle database. Application programs were Pro*C and C++. User interface programs were created using Oracle Forms (Developer/2000).

(09/1974-12/1994) Burroughs/Unisys Corporation(full time)
Customer support for LINC on A_Series, UNIX, PCs. Customer support for V_Series, DMSII (Database Management System) and Data Communications. Designed, developed, and implemented a Call Tracking System. Supported all system software for B1000. Participated in numerous benchmarks and conversions

EDUCATION
BS in Mathematics, University of South Carolina, Columbia, SC
AWARDS

Pride award for outstanding customer support -Nortel
Spot award for delivering fixes ahead of schedule - Nortel
Marketing of Unisys Technical Advantage Services - Unisys
Development of Call Tracking System - Unisys

RECENT SPECIALIZED TRAINING

Oracle Reports  Oracle Forms 2  Oracle Developer 2000  Oracle Forms

UNIX Advanced Administration  UNIX Shell Programming  C Programming