Daniel K House Resume 111 Keeler Blvd Toronto, Ontario M1E 4K6 danny@cs.toronto.edu (416) 282-7003 CAREER HIGHLIGHTS 28 years experience. Team Lead - see employment history, Express Scripts, Enbridge Gas Distribution and Reuters Information Services. Expert in Oracle, UNIX/Linux, C and Java. MSc, 2004, University of Toronto. This recent master's degree in computer science may be taken as evidence of my continuing ability to absorb and apply large volumes of new information and technologies in very short time frames. Major Software Skill & Experience: Years Skills and Languages Years of experience -------------------- ------------------- Oracle 11 Unix/Linux 25 C , C++ 21 Java 3 Data Modelling 10 Business / System Analysis 10 SQL 14 Oracle - PL/SQL 6 Oracle DBA 2 Unix/Linux Scripting 23 Unix/Linux System Programming 13 Unix/Linux System Administration 3 Teradata Development 3 Teradata DBA 2 Configuration / Build Management 13 Top End 5 Software Engineering 14 Datastage 3 Object Oriented Design 14 Smalltalk 2 QA / Testing 5 Lisp 3 Prolog 2 Basic 2 EMPLOYMENT HISTORY CANADIAN SHARE OWNER Software Consultant (April 2007 to date) Technology used: Oracle, PL/SQL, Java, C++, XML, Swing, SQL, Oracle Financial Applications, Xerces, Sax, DOM, Developer, TOAD, Enterprise Manager, Borland C++ Builder, Linux, MS Server, Apache, Tomcat, VNC, MS-DOS scripts, Eclipse, CVS, NetBeans, Ubuntu, Vmware * Created and maintained Oracle Financial Applications forms and stored procedures used by the Canadian Share Owner stock brokerage to provide customer care and manage stock exchange transactions. * Enhanced graphical stock market analysis tools written in Borland C++ Builder. * Migrated stock analysis functions from C++ to Java rich client platform application. * Implemented multi-currency electronic fund transfers. * Implemented book value database scrub. * Created PL/SQL modules to generate Revenue Canada XML submission files. * Designed web-based stock data transfer controls. * Reverse engineered file formats. * Performed business and data modeling. STEELMAN SOFTWARE SOLUTIONS Special Projects Consultant (January 2007 to April 2007) Technology used: Oracle, Oracle Application Server, Oracle Metadata Repository, Developer, Designer, TOAD, Linux, Ubuntu, Red Hat Enterprise Edition, MS Server, VMware, Amanda, Bugzilla, Apache, Ant, Tomcat, Postfix, Openbravo, VNC, Samba, mtx, Dell PowerVault Tape Changer * Established multi-platform backup process using Amanda, Dell PowerVault Tape Changer, Samba, VMware and Linux. * Performed business modeling and wrote designs and technical specifications for changes to scheduling interface and data model in an enterprise management system specialized for steel industry. * Created user interface prototypes in Oracle Forms. * Installed and configured various software packages including: Oracle databases, Oracle Aplication Server, Oracle Metadata Repository, Amanda, Bugzilla, Apache, Ant, Tomcat, Postfix, Openbravo, Linux kernel. EXPRESS SCRIPTS Associate Consultant to Infomaxium (June 2006 to November 2006) Technology used: C, Pro*C, Insure++, CVS, GNU-make, UNIX, SQL, Oracle, TOAD, ksh, awk, sed, Tuxedo, Visio, HP/UX, PC compatibles * Architect and team lead for Pro*C and Cobol code migration from Oracle 8i (32-bit libraries) to Oracle 9i (64-bit libraries). * Lead a team of 7 to modify code in over 500 files and eliminate over 10,000 issues detected via automated code analysis. * Defined strategies for mapping machine dependent code from 32-bit to 64-bit data model. * Resolved issues involving blobs and binary representations. * Coordinated with QA and development groups to produce test suites and validate the migration of 74 applications. ENBRIDGE GAS DISTRIBUTION Associate Consultant to Infomaxium (April 2004 to June 2006) Technology used: Harvest, Datastage, UNIX, SQL, Oracle, Sybase, PL/SQL, T-SQL, TOAD, SQL-Programmer, Control-M, SyncSort, ksh, awk, sed, MS Office, Access, Erwin, Visio, PC compatibles. * Team lead for enhancements to data interfaces (ETL). * Performed business analysis, and design of a gas consumption normalization program used for forecasting revenue and budgeting. * Implemented gas consumption normalization program used for forecasting revenue and budgeting in Oracle PL/SQL. * Determined requirements, produced design, and implemented cross-system extract of data used for gas distribution network planning. * Worked with users to define user-acceptance criteria, and then to demonstrate conformance. * Wrote job-control package providing uniform transaction handling, locking, and messaging for batch processing in Oracle PL/SQL. * Performed testing of UI and data transforms. * Provided mentoring for business analysis, SQL, Unix scripting. COMPUTER SCIENCE DEPARTMENT, UNIVERSITY OF TORONTO Obtained Master of Computer Science Degree (January 2002 to April 2004) Technology used: Make, CVS, RCS, C, JAVA, UNIX/LINUX, XML, HTML, OpenGL, Maya, CUP, JFlex, ML, HOL, SMV, CCW, PVS, ksh, awk, sed, SUIF, SPIN, Prolog, Latex, MATLAB, Maple, DrJava * In a Master of Computer Science program. * Teaching assistant: U. of T. Computer Program Reading Comprehension Project * http://wwwcgi.cdf.toronto.edu/~www1/programs.html * Contributed content for web site. * Lead project planning. * Guided configuration management effort. * Teaching assistant: wrote skeleton compiler in Java to be given to students of compiler course. * Teaching assistant: wrote automarking scripts for systems programming course. * Teaching assistant: marked assignments for Software Engineering course. REUTERS INFORMATION SERVICES Technical Specialist (November 1993 to December 2001) * Promoted, July 2000, to Technical Specialist * Promoted, September 1999, to Specialist, Database Analyst * November 1993 to August 1999 Senior Programmer Analyst Technology used: Make, sccs, Sablime, C, JAVA, UNIX/LINUX/Solaris, SQL, Oracle, Designer, Developer, PL/SQL, TOAD, JDBC, TERADATA, TOPEND, ASN.1, ksh, awk, sed, gdb, BASIC, Datastage, MS Office, Access, System Architect, SUN 450/E10000 and family, NCR 5100 and family, PC compatibles. * Successfully lead 4 person team that constructed a proof-of-concept extract, transform, and load of a legacy long-row APL database to a short-row Oracle data warehouse. * Member of 4 person team that specified, designed, implemented and maintained a fault tolerant 200 megabyte cache of time-series data with real-time dynamic updates. * Created the detailed design of the fault tolerance and real-time synchronization mechanisms in the time-series cache. * Rescued project to provide API for arbitrarily large time-series queries. * Specified, co-designed and co-implemented API for arbitrarily large time-series queries. * Proactively represented Toronto, making significant contributions to multiple international teams (Toronto, London, New York) responsible for requirements analysis, data modeling, data model implementation, production monitoring, and database and system administration. * Coordinated systems maintenance activities for NCR UNIX, TOPEND, TERADATA development environment. * Senior member of systems support team for Solaris and Oracle development environment. * Designed and implemented logging subsystem for database feed from APL to Oracle via Datastage. * Created Oracle data warehouse cleanse programs in JAVA using JDBC. * Developed Oracle forms to support testing of database feed from APL to Oracle via Datastage. * Created and maintained multiple large-scale Oracle schemas integrated with work products from various sub-projects in support of development and testing. * Designed and implemented configuration management tools and procedures. * Co-authored effective database naming standards. * Coordinated the implementation of collection and analysis procedures for the performance of the time-series cache in the production environment. * Contributed to feasibility study for using Oracle8 to cache time-series data. * Contributed to preliminary design of a distributed version of the time-series cache in order to meet growth projections. * Performed feasibility study for using JAVA to distribute time-series data. * Provided mentoring, training and support for C, UNIX, SQL, data modeling, database design, and object oriented methodologies to various teams. COMPUTERVISION GIS Senior Software Engineer (May 1991 to November 1993) Technology used: Make, imake, sccs, C, Objective-C, Lex, Yacc, gdb, X-windows, Openwindows, Openlook, OLIT, Devguide, Xview, Empress, SYSTEM 9 GIS, UNIX, Solaris, MacProject II, Sun and DEC workstations, Macintosh. * Replaced hybrid interprocess communications used by in-house menu server with uniform client-server IPC. * Assisted in successful port of existing product from SUNOS4.2 to Solaris. * Coordinated software quality review process. * Enhanced in-house menu system to support extended ASCII on alphanumeric terminals and Sun and DEC workstations running Openwindows (which was ported to DEC in-house). * Debugged coordinate geometry subroutine library. * Performed requirements analysis for upgrade of user-interface from in-house menu system to provide Openlook compliance. * Independent reviewer for a subcommittee on GIS extensions to SQL. AASTRA AEROSPACE Senior Systems Analyst (January 1989 to May 1991) Technology used: Make, sccs, C, Objective-C, Smalltalk, Oracle Forms, Pro*C, SQL, PV-Wave, Sunview, UNIX, System Architect, MS-DOS, Sun workstations, PC compatibles. * Created data models for simulation laboratory and inventory control and material flow system. * Designed and implemented configuration management software. * Member of team that built a simulation of the Defense Early Warning System. * Performed system analysis for, and designed and implemented an inventory control and material flow monitoring system to be used in a piezoelectric ceramics factory using Oracle on a PC compatible. * Designed a distributed general purpose simulation laboratory using a client-server paradigm. * Prototyped the simulation executive in Smalltalk. * Implemented the final simulation executive as a server. * Designed and implemented Oracle Forms for specification of simulation configurations. * Given security clearance. * Provided training and mentoring in the use of C, UNIX, structured analysis methodologies, SQL. * Used Yourdon structured analysis and System Architect CASE tool to specify system requirements. * Evaluated object oriented languages prior for use in simulation laboratory. * Evaluated third-party graphics packages and databases for incorporation into the simulation laboratory. * Worked to military standards. NESBITT THOMSON DEACON INC. Senior Programmer-Analyst (July 1988 to January 1989) Technology used: Make, sccs, C, UNIX, Oracle, Pro*C, SQL, Lex, Unisys 5000/90. * Implemented a month-end reconciliation of accounts. * Used Lex to convert a manual data-dictionary to one maintained and accessed under Oracle. * Documented the development library. MOTOROLA DACSCAN Engineer III (Senior) (August 1983 to July 1988) Technology used: Make, sccs, C, UNIX, Yacc, Lex, RSX-11M, cXOS, Pyramid, Motorola cXSVM, PDP 11's. * Designed and implemented the following: event scheduler package, historical data storage and analysis system, dynamic object rule editor, 3-D relief graph generation tool. * Re-organized source to automate release generation. * Administered system library. * Enhanced the real-time display system. ALLIED ALUMINUM Consultant (November 1982 to May 1983) Technology used: BASIC, CP/M, Datastar, Z80 desktop. * Expanded scale and detail of the database. * Provided a new query language for the database. * Wrote a detailed user manual. * Debugged accounting software. MINISTRY OF NATURAL RESOURCES Programmer-Analyst (October 1981 to October 1982) Technology used: Make, sccs, C, UNIX, Lex, FORTRAN-77, PDP 11/50, Perkin-Elmer 3230, Calcomp and Nicolet-Zeta plotters. * Designed and implemented an automatic text placement program in C to find room in arbitrarily shaped polygons. * Rewrote Calcomp plotter interface written in FORTRAN-77 to allow use of Nicolet-Zeta plotters. * Aided in the design of an interactive map editor. * Ported geographic software written in C from a PDP 11/50 to a Perkin-Elmer 3230. ERUDITION DATA SERVICES Consultant (August 1981 to October 1981) Technology used: BASIC, CP/M, Datastar, Z80 desktop. * Implemented a customs brokerage database. * Provided a query language to handle government paperwork. * Technical support for customers. * Debugged accounting software. MATHEMATICS DEPARTMENT, UNIVERSITY OF TORONTO Research Assistant (May 1981 to August 1981) Technology used: FORTRAN, TRS-80 desktop. * Wrote software to evaluate a polynomial in five complex variables. * Designed and implemented a program to evaluate a very unusual version of the determinant. EDUCATION Master of Computer Science Degree - University of Toronto, 2004 Bachelor of Science Degree - University of Toronto, 1981 REFERENCES Furnished on request.