Primary Tasks and responsibilities- Environmental setup & system Cloning
• Set up the environment/DB required to perform the cleansing in client DMZ and validate the same with complete readiness
• Set up data filtration scripts to filter client data excluding SIMTRA data and continuous replication
• Remove security groups, permissions, or security keys from the cloned system (in the DMZ infrastructure environment)
Data Cleansing
• Analyze database structure and create data cleansing scripts for all database tables to clean SIMTRA data (Both Bloomington and Halle Data)
• Remove all SIMTRA data associated with SIMTRA Manufacturing sites, SIMTRA Product Codes, documents (files/attachments) including SIMTRA PII data from the cloned system
Testing and Validation
• Draft data verification scripts to ensure no SIMTRA data is being shared with client
• Perform regression testing to ensure system accuracy
Documentation
• Prepare documentation that client will need to clone the application on their end to enable system access
• Provide specific instructions for client to complete the integrations and complete system set up