Architecture Flow
SOURCE SYSTEMS
T24
CRM
Cortex
Murex
Others
ONE-TIME IMPORT
Excel templates per system
DAILY ETL SYNC
Delta / full refresh
ODS DATABASE
· Master data
· Employees / Accounts
· Roles / Privileges
· Screens / Objects
· Classification mappings
· Audit / Load logs
ACCESS SEARCH
Who has access to what
CLASSIFICATION
Maintain screen classes
OUTPUTS
· Who has access to what
· Secret / Top Secret screens
· Unmatched screens
· Failed loads / exceptions
CLASSIFICATION LOAD:
Data Governance TeamExcel per system (Screen name + Classification)ODS Database
Technical Tasks by Team
1. Solution Architecture
- Finalize end-to-end solution design
- Confirm system boundaries and in-scope source systems
- Define canonical data model (user, account, role, privilege, screen, classification)
- Define integration pattern for initial load and daily ETL
- Define error handling, reconciliation, and audit approach
- Review wireframes and functional requirements
- Align security, audit, and compliance expectations with stakeholders
2. Data Architecture / Data Governance
- Define data dictionary for all ODS entities and columns
- Finalize classification model and allowed values
- Provide Excel files for initial classification by system
- Define matching rules between source privilege data and classification records
- Define data quality checks: duplicate accounts, missing employee IDs, unmatched screens, invalid classifications
- Support mapping of source fields into ODS target model
3. Application Team (Oracle Forms / ODS)
- Create ODS tables, indexes, constraints, and lookup tables
- Build Oracle Forms screens: Search user privileges, Add / modify classifications
- Implement validations and LOVs
- Implement search filters and results grids
- Implement add / edit / audit trail for classification maintenance
- Implement role-based access on the application itself
- Support UAT fixes and production rollout
4. ETL / Integration Team
- Prepare one-time import jobs for all source systems
- Build daily ETL jobs for privilege synchronization
- Build import job for Data Governance classification Excel files
- Create staging tables and validation rules
- Implement load status logging and reject handling
- Implement reconciliation reports after each run
- Schedule daily batch and alerting for failures
5. Source System Teams (T24 / CRM / Cortex / Murex)
- Populate agreed Excel export template for initial load
- Confirm source meaning of roles, profiles, privileges, and screens
- Provide field mapping and business meaning for extracted data
- Clarify whether daily extract will be full or delta
- Support data validation and defect resolution during SIT/UAT
- Identify source limitations, especially around screen/object granularity
6. Information Security
- Review access model for the new ODS application
- Ensure least-privilege access for maintenance users
- Validate audit logging requirements
- Review encryption / masking needs if sensitive user data is stored
- Review batch file transfer and ETL security controls
7. Infrastructure / DBA
- Provision Oracle DB schemas and storage
- Support performance tuning, backup, and recovery
- Support scheduling and monitoring of ETL jobs
- Prepare DEV / SIT / UAT / PROD environments
- Support database deployment and release activities
8. Testing / QA
- Prepare SIT and UAT scenarios
- Validate: search accuracy, classification maintenance, daily sync results, reconciliation reports, audit trail
- Validate negative scenarios and invalid input handling
- Support regression testing before go-live
9. Business / Operations / Audit Stakeholders
- Confirm reporting expectations
- Validate search outcomes and classification behavior
- Review unmatched / exception handling process
- Approve final reports and operational process