|
|
Richard
P. Collette 133
Budding Ridge (203)
982-7487 Phone (413)
431-3867 eFax |
Word
XP Format |
|
Education 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. ·
·
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 ExperiencePLC 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 "Applying UML and Patterns: An Introduction to Object Oriented Analysis and Design" by Craig Larman (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 Domino 6.01 Apache Web Server and Tomcat
with Domino connector. |
|
|