John Sun
Notes Domino Consultant

As a Dual Certified Lotus Professional ( Principle CLP) with 9 years of professional service, including 6 years of Notes/Domino, I provide Lotus Notes Domino consulting sevices in Toronto, Ontario Canada.

If you have a contract or need a Lotus Notes freelancer, please contact me via email and I will respond to all messages as soon as possible.

 

Pround to be an IBM Business Partner


Thanks for taking time to review my resume! The following is a truncated version of my resume, the complete version (including employer names) will be furnished upon request.

CERTIFICATIONS






  • PCLP Domino R5 Principal Application Developer
  • CLP Domino R5 Application Developer
  • PCLP Notes Principal Application Developer R4
  • CLP Notes System Administrator R4
  • CLP Notes Application Developer R4
  • CLS - Notes R4 System Administration 1
  • CLS - Notes R4 Application Development 1

  • SCJP- Sun Certified Java Programmer (Java 2)

  • Certificate in Continuing Studies in Management Fundamentals of University of Toronto (In Progress)

EDUCATION


MASTER OF COMPUTER SCIENCE 1996

BACHELOR OF PHYSICS 1993

EXPERIENCE


SENIOR CONSULTANT
February 2002 - Present

  • Developed an online adverse event reporting 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.
  • Developed a trial data management application. It is designed in strict compliance with FDA's guidelines on "Electronic Records, Electronic Signatures". Modules include: CRF definition, data (double) entry, data validation, DCF resolution, SAS export, Reporting and etc.
  • Technologies used included: Lotus Domino (Lotusscript, Formula) combined with DHTML, JavaScript, SAS, Crystal Enterprise (8.0) and Crystal Report (8.5) (RDC programming and Crystal Report design). Experienced all SDLC (System Development Life Cycle) aspects including system architecture and design, programming, testing and documentation (System Architecture and Design, Installation, Testing Plan and part of User Guide)
  • Helped the company to prepare for regulatory audit. Assisted to develop Standard Operating Procedure (SOP) of SDLC.

SENIOR CONSULTANT
February 2001 - February 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.


CONSULTANT
February 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.

CONSULTANT
January 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

CONSULTANT
April 2000 - December 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 NOTES DEVELOPER
February 1999 - March 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
March 1996 - August 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
July 1993 - February 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

PROFESSIONAL TRAINING


  • CPAC Professional Day Training 2002
  • The Foundation of Marketing 2001
  • Accounting Fundamentals 2001
  • Delivery Dynamic E-Business: IBM’s Websphere Offering 2001
  • Websphere for Results 2001
  • Domino R5 application architecture 2000
  • Domino R5 Application Security and Workflow 2000
  • Y2K Lotus Notes LotusScript Workshop 1999
  • Developing Interactive Web Applications 1998
  • Lotus Application Development Level 2 course 1997
  • Lotus System Administration Level 2 course 1997

If you have any questions, please contact me via email.