Software Validation Requirements and Excel Spreadsheet Validation

19 -20 June 2019 at G Hotel, Gurney Penang, 9am-5pm

SOFTWARE VALIDATION REQUIREMENTS AND EXCEL SPREADSHEET VALIDATION

EARLY BIRD COURSE FEES (until 31 May)
AMMI Member: RM 1,200 per pax
Non Member: RM 1,400 per pax

NORMAL COURSE FEES (from 1 June onwards)
AMMI Member: RM 1,400 per pax
Non Member: RM 1,600.00 per pax

INTRODUCTION / OBJECTIVES

Software Validation Requirements and Excel Spreadsheet Validation is a formalized, documented process for testing computer software and systems. The FDA and other regulatory bodies require Software Validation Requirements and Excel Spreadsheet Validation to demonstrate that computer systems are in compliance with all regulations for electronic data management systems.  Softwares and excel spreadsheets used in GMP or GLP environments, as with any computer system, the regulatory bodies  expects measures to be in place to ensure system data are controlled and protected and to ensure accuracy, reliability, consistent intended performance, and the ability to discern invalid or altered records. This training session shall explore the requirements for Software and Excel spreadsheets used in production or the quality system and case studies on how verification/validation can be accomplished.

COURSE OUTLINE

  1. Overview of Excel Validation System
    1.1. Regulatory and QMS Requirements
    1.2. Introduction to GAMP 5 requirements
    1.3. 21 CFR Part 11 Regulations

 

  1. Types of Software/Computer Validation System
    2.1. Computer System
    2.2. Information System
    2.3. Control System
    2.4. Design system

 

  1. Software Category
    3.1. Category 1 – Operating System
    3.2. Category 3 – Standard Software Packages
    3.3. Category 4 – Configurable Software Systems
    3.4. Category 5 – Custom Built or Bespoke Systems

 

  1. Excel Spreadsheet Development Lifecycle4.1. Project Planning.
    4.2. Design
    4.3. Development
    4.4. Integration and Test
    4.5. Installation and Acceptance

 

  1. Elements of Excel Spreadsheet Verification and Validation
    5.1. Validation Master Plan
    5.2. User Requirement Specification (URS)
    5.3. Functional Requirement Specification (FRS)
    5.4. Design Specification (DS)
    5.5. Installation Qualification (IQ)
    5.6. Operational Qualification (OQ)
    5.7. Performance Qualification (PQ)

 

  1. Case Studies + Discussion
    6.1. The “V” Model and how to apply it to software
    6.2. Development of URS, FS, DS & Test Cases
    6.3. Development of IQ, OQ and PQ protocols
    6.4. Development of IQ, OQ and PQ report

TRAINER’S PROFILE
Mr. Gobu Devarajan possesses Master Degree in Electrical and Electronic Engineering and Certified Manager of Quality/Organizational Excellence (CMQ/OE, Certified Quality Auditor (CQA) from American Society of Quality (ASQ). Certified Six Sigma Green Belt.

He has more than twenty five years of working experience with extensive knowledge in the field of Quality Engineering, Statistical Analysis and Quality System Requirements. He possesses excellent communication and presentation skills. He is capable of designing, conducting training programs and perform gap analysis according to QSR (21 CFR Part 820), ISO 13485, ISO 9001, ISO 16949 and ISO 14971. MDD 93/42/EEC, CMDCAS and JPAL

PAYMENT AND CONFIRMATION OF REGISTRATION
All payment is due immediately upon receipt of invoice. Please note that a confirmation letter for HRDF submission will only be issued upon receipt of payment.

Option 1 :  Direct Bank-in or via E-Banking upon receipt of Invoice
An invoice will be sent to you within 3 working days upon your registration.  Please note that any Early Bird Discounts (for registration within validity period) will be reflected in the invoice. Please email us (admin@medsociate.com) the bank-in slip / remittance slip once the payment is made. A confirmation letter for your HRDF submission will be issued to you upon receipt of payment.

Please refer the following bank account details:

Beneficiary Name: Medsociate Sdn Bhd
Bank Account Number: 800 3930 348
Bank: CIMB Bank
Swift Code: CIBB MYKL 

For Government Sector – A Local Order (LO) or letter of approval to participate must be submitted before your registration can be confirmed. 

Option 2: Direct  Online Payment
You may choose to make direct online payment, via Paypal or your credit/ debit card. A tax invoice and confirmation letter will be sent to your email address within 3 working days, when you choose this option.

CANCELLATION / REFUND POLICY
AMMI reserves the right to cancel or postpone any training or event but with due notice to the registered participants / company(s). Any payment made will be refunded in full if the cancellation is made by AMMI.  No shows and cancellations made by participants/ companies within the specified period will incur the specified costs as per below schedule.

Prior to Training Date Cancellation Charges
30 days or more  No charges
15-29 days 25% of training course fee 
8 – 14 days 50% of training course fee
0 – 7 days 100% of training course fee

 SUBSTITUTIONReplacement of participant is allowed at no additional cost if you are unable to attend. Please inform us of the replacement in writing at least 3 working days before the training date.

 

CONTACT

For enquiries, please email to secretariat@ammi.com.my
Tel: +6010 4040 662  Fax: +603 2178 4347