Primary 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.

1. MS Power Automation scripting to perform the below tasks.• Extract email (.msg) headers (to/from/subject/date) and list into an Excel spreadsheet.• Convert .msg files to PDF files and write to a folder.• Find legacy MS Word, Excel, PPT templates from SP and list them in a spreadsheet.2. Design and create a Governance Sharepoint site, links, and embed provided Governanceinformation/links and go live with that site.3. Create Power Automate scripts to automate selected Sharepoint workflows.