Assistant Information Management Officer
CurrentPrimary Tasks include but not restricted to:Data Migration (SQL): Working on migration of confidential municipal data, including assets, properties, rates, and other critical records, from secure SQL servers to the centralised "OneCouncil" platform by TechnologyOne. Ensuring data integrity, accuracy, and compliance with strict security protocols throughout the migration process. Collaborated with cross-functional teams to identify and address migration challenges, optimise database performance, and ensure seamless system integration across multiple operations for the City.Geospatial Data Handling (QGIS): Utilised QGIS to manage and analyse real-world property data, land parcels, and associated municipal rates. Processed geospatial datasets to support accurate visualisation and integration into the City's data systems, enhancing decision-making and operational planning.ETL Development: Designed, developed, and implemented robust ETL (Extract, Transform, Load) processes using SQL and other relevant tools to facilitate seamless data migration. This involved extracting complex datasets from various sources, transforming the data to meet standardized formats and business requirements, and loading it efficiently into the "OneCouncil" system. Automated repetitive tasks to minimize manual intervention, ensuring accuracy, consistency, and faster processing times. Records Management: Conducted detailed searches, compilation, renaming, redaction, and conversion of confidential records to PDF format within the City's Records Management System (SharePoint).File Registration: Ensured proper registration and organization of converted records in SharePoint for streamlined accessibility and compliance.Policy Compliance: Adhered to the City's risk management policies and procedures, ensuring data security and operational integrity.
