As a Dual Certified Lotus Professional (principal CLP) with 10 years of professional service, including 8 years of Notes/Domino, I provide Lotus Notes Domino consulting services in Great Toronto Area (GTA) and surrounding cities.

If you have a project, look for Lotus Notes support or need a Lotus Domino freelancer, please contact me via e-mail and I will respond to all messages as soon as possible.

Senior Lotus Notes Consultant / Developer
2002 - Present

• Developed an online serious adverse event application for a CRO (Contract Research Organization). The web-based system is to help drug manufacturer to manage adverse reactions during a clinical study (phase III and IV). Features include online data validation, role-based workflow process, MedDRA data integration, CIOMS I and MedWatch 3500a compatibility, regulatory compliance (FDA 21CFR Part 11), SAS data export, versioning and etc.

  The application is based on Lotus Domino (Lotusscript, Formula) combining with DHTML, JavaScript, SAS and Crystal Report (8.5). My tasks included system design, programming, testing and documentation (System Architecture and Design, Installation, Testing Plan and part of User Guide)

• Principle developer of a Clinical Data Management product. Features include workflow based CRF (Case Report Form) design, SOP driven document management and tracking functions, role based clinical trial management and data management, electronic signature enabled approval process, regulatory compliant audit trial and digital signature and etc.
  
  
• Helped the company to prepare for regulatory audit. Assisted to develop Standard Operating Procedure (SOP) of SDLC.

• EDC (Electronic Data Capture) project developed for a Toronto based medical device company to collect clinical trial data worldwide. The clinical data, which is obtained from clinical sites, is sent to a SSL (Secure Sockets Layer) enabled Lotus Domino server. A Domino application randomizes the incoming data, keeps the testing data and sends the training data back to the sponsor through Domino S/MIME (Secure Multi-Purpose Internet Mail Extensions) messaging system. Lotus Domino identifies Internet users using their X.509 certificate. (Click here details)
  
  
• Lotus Domino based web project for a Toronto shopping center builder. The drawing files are submitted through Lotus Domino web server in the company’s DMZ (De-Militarized Zone). Domino identifies each architect using HTTP Basic Authentication process via SSL. Validations on both client side (using JavaScript) and server side (business logic through Lotus Notes program) make sure the submission accuracy. The Lotus Notes replication process between the HUB Domino and the Domino in DMZ will synchronize the submitted files into the corporate network. Scheduled agents then pick the submission, detach them into large storage and notify project managers and assistants. (Click here for details).
  
  
• Other projects including: a Lotus Notes based workflow SOP approval application for a Pickering based manufacturer company; a Management Information system for an international insurance company (Lotus Notes as frontend and SQL Server as backend); a web based survey application (using Lotus Notes to set up survey information and survey is done through Microsoft IE browser); a centralized meeting management application and timesheet & payroll management system for a gobal health care enterprise in Mississauga Ontario and etc.
  

Senior Lotus Notes Consultant / Developer
2001 - 2002

• Principle developer of one of the largest intranet project of a Canadian bank. Pathway users in more than 1500 branches across North American are using this site as their main portal access to other intranet sites of the bank. Tasks include scope of work definition, functions and design specification, development, usability and user acceptance testing and rollout. The system enables the administrator to compose and create, edit and archive intranet web pages via a Notes client without knowing any HTML. The site went through strict testing procedures to provide the bank’s employee a robust home page (including employees working on OS2 with Netscape 4.x).

• In charge of redesign Account Payable Tracking System for the bank's Operations Finance. The system tracks and manages all the bank's capital and expense invoices. System functions include data input, categorizing, analysis and report. SQL Server/Cold Fusion team developed the reporting part while the data are transfer from Notes via Replic-Action (a product of Casahl Technology, Inc.). Tasks included screening the requirement, scope definition, system/function design/redesign, coordinating development between Notes and SQL Server groups, third party product evaluation, Notes-side development and QA testing.

• Developer of Quick Vote version 1.0 product for the bank. Quick Vote is a database that can be embedded into any intranet web sites through its programmable interface, serving as a survey component. Features include: Intranet Content Managers use Notes client (or web) to create and maintain a survey (Quick Vote), the survey can be single choice (Radio Buttons) or multi-choices (Check Boxes), the number of choices/answer is flexible, the statistical number is real-time and visualized in colorful bars and etc. Many intranet sites are using Quick Vote as their embedded survey system. The product was designed and developed independently by myself.

• Other projects including Communication Calendar, Database Billing System, Intranet Authentication System, Web site indexing (Websphere Analyzer) and etc.
  

Lotus Notes Consultant
2001

• Developing schemas to export data in 4 Notes databases to Oracle. Tasks include: export plan, data validation, rich text field conversion, data conversion to MS Excel by VBA and data importing from MS Access. Responsible for planning, programming, testing and documentation.

Lotus Notes Consultant / Developer
2001

• Working on Facilities Management project. Responsibilities include: to develop the project request specification, development plan and deliverables, testing schema, timeline and cost/budget. This project is a part of the Facilities Management Works website
• Designed with Domino R5 on AS/400 and used by intranet user with internet browser

Lotus Notes Consultant / Developer
2000

• Successfully developing Request for Proposals (RFP's) in bidding for Design Change Automation System for a renowned international computer vendor. This application is used as the PDD primary tool for processing new and updated part code, design and pricing change requests. Responsible for creating system with following features: documents accessible to teams working from any location worldwide while retaining data security; role-based workflow control; automatic data archiving and etc..
• Designed and built system using Lotus Domino R5, combined with Microsoft Office using VBA
• Working with project manager to finish project global roll-out
  

Senior Lotus Notes Developer
1999 - 2000

• To design and develop internal applications, such as Sales Communicator (for Warehouse Dept.), Employee Satisfaction Survey, Professional Services (include PS Time manager, PS Expense and PS Leave), Request for Services, Customer Feedback, HR Request (Domino Web application), Creating connection between Sales Navigator (Domino Application) and OQS (SQL Server application) and etc.
  
• To make intranet web application domino.cti.ca using Lotus Domino 4.6.6 and Microsoft FrontPage
• Working closely with Notes Administrator to solve complex Notes Administrative and user end problems
  

Lotus Notes Developer
1996 - 1998

• Responsible for the technical management and operation of a 4-person consulting team of Lotus Notes, Visual C++ and Visual Basic developers, scope of work including customer requirement analysis, system design and advanced programming (Lotus script)
  
• Projects including: migrating a 14-Database Lotus Notes application from Lotus Notes R4.1 to R4.5;redesign of the application's interface and archiving data to MS-Access using NotesPump; development of workflow applications using LotusScript and Visual C++, including documentation
  
• Working in team to develop Notes applications such as Knowledge Management, workflow enabled project management and application integration (Notes and Access through ODBC, Notes and Excel and Word through OLE automation)
  

C++ Programmer
1993 - 1996

• System design and programming on CAD software. Worked with a 6 person development team using MS-Access, Visual C++ and Visual Basic
  
• Developing the interface module of a Tele-communication software, using Borland C++ 3.1 in DOS environment
  
• Developing a Sales Management Application using Foxbase for a retail company
  

Home | Lotus Notes Consulting Service | Lotus Domino Basic HTTP Authentication | Lotus Domino Authentication using X.509 Client Cerificate (PKI) | Rate | Experience | Certifications | Education | Professional Training | Technical Skills | Resume | Lotus Notes Domino Solutions | About Me/Resume | Logistics Partner

Email: john_sun@notesdominoconsultants.com