Richard P. Collette

133 Budding Ridge
Southington, CT 06489
(203) 982-7487 Phone
(413) 431-3867 eFax
Richard.Collette@tritanka.com
http://www.tritanka.com	

	

Education
B.S. Electrical Engineering – University of Connecticut – May 1994

Work History
11/2001 – Present
Hartford Steam Boiler Insurance & Inspection Company – Hartford, CT
Technology Specialist
Lotus Notes, and Web Development including Peoplesoft, DB2 and SQL Server Integration

4/1999 – 11/2001
Tritanka – Southington, CT
Owner/Developer
Lotus Notes, VB and Oracle Development Consultancy

5/1991 – 3/1999
The Siemon Company – Watertown, CT
Lead Developer/ Developer / Network & Notes Administrator
Lotus Notes, VB and Oracle Development (Since Notes 4.0 and Oracle 7.3 release dates)
NT, Novell & Notes Administration including 5 international offices. (Since NT 3.1 release dates)

Lotus Notes Skills and Background
Programming and Administration of Lotus Notes since version 4.0 initial release date
Extensive Use of LotusScript including:
Obect Oriented/Class based design
ODBC database connectivity (Oracle, DB2, SQL Server and MS Access)
OLE/OCX/COM/VBA based application integration programming (ex. MS Office, Label Printers, Scanners, etc)
Mail Enabled/Workflow processes
User/Group/Role Based Security
Web development including:
Mail-in database enabled web form submission (DMZ Notes Server mails submitted forms to internal Notes Database)
Web applications emulating the notes user interface (Multiple Document Interface, Name Picker, Calendar Picker, Search, AlphaBar “jump to”, dialog boxes, enhanced error display, etc.)
User managed content, privately authored and publicly released documents
Web related agents (ex. Redirection of unwanted referring hosts/URL's)
Use of network packet capture software (Ethereal) for diagnostics.
Multi-database system design and coding including inter-database document linking.
Data migration and import using Replic-Action and Zmerge software.
International implementation and ongoing maintenance of Lotus Notes Networks hosted on Microsoft NT platform with Internet & Dialup connectivity including Notes 4 to 5 Migration
Helped define and test improvements to Lotus Notes ODBC driver released in version 2.05 and 3.01 (per correspondence with Nick Shellness, VP Lotus Development and Jeffrey Pappows, President Lotus Corp.)

Author of Notes FAQ regarding the dynamic display of RichText fields without requiring document save:
http://metro.turnpike.net/kyee/whychanges.html
Please excuse the formatting on this HTML page.  It was not constructed by me.
Use of Pylon Conduit and Starfish Truesync for Notes to Palm Pilot data transfer.

Project Methodology
Typical programming project management has included:
•	User request and initial justification documentation (Purpose, Benefits, Initial ROI Calculation)
•	Requirements documentation (What the application must do specifically)
•	Application Specification (How the application will meet the requirements)
•	System Documentation  (How the application is structured, relationships between components, agents, security mechanisms, user security configuration and application installation)
•	Have worked with Rational Rose UML software and ArgoUML
•	Training of System Owner(s) as first line of support and ongoing maintainer of the system.

Lotus Notes Project Work:
•	Contract/Rate Schedule database – This database maintained customer contracts including pertinent addresses, contacts, rates and assigned inspectors.  Utilized a unique to Notes design of serializing hierarchical objects to record rate schedules and rates as well as contacts and addresses on each contract document rather than using response documents.  The effect was reduced storage requirements and simplified security maintenance since there was only a main document for each contract.  This was done by using a Serializer class emulating Java serialization methods which convert in memory objects to a string representation enabling storage of complex object structures as text in a notes field.  Other classes developed included LinkedList with MergeSort capability, Observable class (emulating the Java Observable class) and a RecordControl class which provided MS Access “VCR” style navigation and display of in memory Records/Objects.   The system integrated with PeopleSoft 7.5 using Message Agent technology and with PeopleSoft 8.4 using Component Interface technology to allow the creation of Customers and addresses from the Contract system.  All system objects were implemented as Classes such as Contract, Rate Schedule, Rate Schedule Item, Contact, Address, Contract Database, PeoplesoftCustomer, PeopleSoftCustomerAddress.   The use of Object Oriented design allowed for rapid implementation of frequent specification changes and improved quality through code centralization and reuse.
•	Pressure Equipment Directive project management extranet database.  Tracks clients, projects and tasks, and project documentation with document approval workflow.   Database functions on both Notes client and web client with full fidelity.
•	Class Documentation database closely mirroring the JavaDoc class documentation format.   Multiple member documents dynamically displayed in a single Class document including dynamic document linking.   Class based design based on the Model/View/Controller pattern allowed for rapid implementation of web display.
•	Loss Prevention Report mailing address database.  Import of client data in MS Access format.   Included emulation of relational structure using dynamic data display.  Included design and coding of ApplicationLogging, DBService, DBRecord and DBResultset classes.  Used a Java agent to retrieve an MS Access file from customer’s FTP server and unzip to local drive.  ODBC was used to create database indexes and query the data for import.
•	Offensive mail vault application. User notification and prompted retrieval of emails quarantined by email filtering system.
•	Automation of mass user migration to a new Notes domain through Excel spreadsheet lookup and scripted user registration.
•	Automated processing of unsubscribe, bounce and “No Snail Mail” email messages for List Mailer system.   Oracle serves as a central repository for contacts from multiple Notes databases.  Oracle views drive Gordano NTList list mailer software to provide targeted emailing.  The Oracle database is also used during “unsubscribe” processing to find a contact’s original Notes database and document based on their email address so that the contact’s mailing properties may be updated.
•	Sales Force Automation/CRM database. Includes territory based reader security of Contacts, Call Reports, Account History, Action Items, Marketing Fulfillment and Contracts
•	Sales Project Pipelining, Project Registration and Warranty Registration
•	Documentation Databases (System Designs, Security Policies, Procedures, Marketing Library, etc.)
•	Training Database. Included Courses Offered, Scheduled Classes/Events, Attendees, Trainer Availability with automated registration confirmation via Email and Fax.  Used Dymo label printers to print labels for selected contacts.
•	Task and Project Assignment/Tracking databases
•	Help Desk and Problem Resolution Tracking Application
•	Web Forms
•	Implementation and customization of ISO 9000 document management software.
•	Marketing Literature Fulfillment processing with an outside service provider using orders, order acknowledgments and ship acknowledgments sent via emailed flat files.
•	Notes R4 to R5 Migration including management of: user training, application testing, configuration and testing, scripting of client local name and address book changes, network and internet configuration, and scheduling.
•	Exploratory use of Notes C and C++ API’s for server add-in tasks.

Database Skills and Background
•	Installation of Oracle 8 and 9 servers on NT and Linux platform
•	Relational Database Design
•	Oracle Administration including the creation of rollback segments, tablespaces, tables,  indexes, views, materialized views, partitioned tables, scheduled analyzing for cost based query optimization, user and role creation.
•	VB and VBA based development for database access.
•	Oracle Objects for OLE, Oracle SQL, PL/SQL and Java stored procedures.
•	Oracle Enterprise Manager, SQL Plus scripting, TOAD and Oracle PL/SQL debugger.
•	Crystal Reports 8.0
•	MS Access for Data Manipulation and Query (no form design or coding)
•	Extensive internet reading on principals of Star Schema Datamart design (I maintain a large list of related web links)

Internet Skills
Use of HTML 3.2 and 4.0 
CSS/Cascading Style Sheets
Javascript and DHTML (Read O'Reilly DHTML and Javascript books cover to cover) 
XSLT Template Development

Networking Skills and Background
NT Network Administrator on an International scale for 8 years including use of:
DHCP, WINS, DNS, TCPIP, RAS
Microsoft IIS 4.0 and FTP
Kixtart based login scripting
Mandatory and roaming profiles (including use of Office 2000 and IE 5 profile snap-ins)
Citrix Metaframe (windows terminal server)
Ghost (disk imaging)
WinInstall (software distribution)
Compaq Insight Management
HP Jetprint Printers/Jetadmin
Backup Exec and Arcserve backup software
Inoculan Anti-Virus software including NT domain and Win9x centralized signature
upgrade management
Borderware firewall management
Cisco Routers and Adtran DSUs
Internet Networking Related Skills:
Domain registration, transfers, DNS Server registration, etc.
DNS Configuration (MX records, A records, SOA Records, etc.)
Troubleshooting tools (dig, ping, tracert/traceroute, netstat and nslookup, packet capture and port scanners)
SMTP/Listserver configuration
Intel Proshare ISDN video conferencing (international implementation)
Maintained UNIX clients for engineering department (IRIX, Solaris)
User creation
Some c shell scripting and scheduling including backups via TAR and BAR and login profiles
Tape based data storage and retrieval
Application Installation
Device Installation and related Kernel compiling

AS/400 Skills
•	Software Installation and configuration
•	PTF Application
•	TCPIP Network Configuration  (Ethernet controllers, DNS, domain and host name configuration)
•	PPP and SLIP dialup configuration
•	Client Access/Express Installation and Configuration
•	User Creation and Deletion
•	Backup management (using standard OS utilities)
•	Query 400 and Query Manger (SQL) reporting
•	Printed Form Design
•	Device/Session/Job troubleshooting.

Additional Programming Experience
PLC Controller programming of pneumatic, motor and stepper motor driven assembly machines and robots
8 Month co-op programming an inventory and accounting system in C with Embedded SQL on a SCO UNIX Platform

Personal Development Pursuits
Gearing up for Java development both for Notes and general use through various reading:
"Applying UML and Patterns: An Introduction to Object Oriented Analysis and Design" by Craig  (completed)
"A Programmers Guide to Java Certification" by Khalid Mughal & Rolf Rasmussen (completed)
“Design Patterns” a seminal book on pattern based OO design by the “Gang of Four” (currently reading)
“More Servlets and Java Server Pages” by Marty Hall (currently reading)
“XSLT Programmer’s Reference” by Michael Kay (currently reading)
“The Java Web Services Tutorial” at http://java.sun.com/webservices/ (currently reading)
“Core J2EE Patterns” by Deeepak Alur, et al. (in the queue)
“Building Scalable and High Performance Web Applications Using J2EE Technology” by Greg Barish (in the queue)

Computing Resources:
Pentium 2.6GHz, 1Gb Ram, CD-RW, DVD, mirrored 120Gb SATA drives running Windows XP Professional loaded with:
Office XP
Lotus Notes 6
Oracle 9i Developer
Netbeans
ArgoUML
Microsoft Visual Studio 6.0
Pentium 500 Mhz, 512Mb Ram, CD-RW, dual 40 Gb IDE drives running RedHat Linux 9.0 loaded with:
Oracle 9iR2 Enterprise Server and Oracle 9iAS (Technology Network License)
Domino 6.01
Apache Web Server and Tomcat with Domino connector.