Which tasks were implemented

• Analyzing and checking incoming rights and role information for completeness and correctness
• Performing manual and automated checks to ensure that the assigned rights and roles meet the requirements
• Development of a set of standard test procedures that are regularly used to check rights and role administration
• Integration of the standard test procedures into existing quality assurance processes
• Implementation of validation checks to ensure the correctness and plausibility of incoming data (such as email addresses)
• Regular exchange with those responsible for the respective applications to discuss current requirements and changes to the rights and role concepts
• Documentation of all communication processes and defined decisions
• Creation of VBA scripts in Excel to automate the plausibility tests
• Managing and monitoring user rights and roles in the IGI Access Government Core System
• Ensuring that all changes are implemented in a traceable manner and in accordance with compliance guidelines
• Creating reports on user rights and roles based on data from various applications
• Use of Excel templates to present the information clearly and consistently
• Preparing the environment for an ECB audit
• Careful documentation of all steps, measures and decisions throughout the process
• Ensuring that the documentation is kept up to date and can serve as a reference for future reviews and audits

Which technologies were used

• MS Windows 8
• MS Office 2016
• VBA
• IBM Identity Governance and Intelligence (IGI)