Solution Architect

Jack worked on a customer data migration application, linking two external systems using a cloud-native application built around Azure Data Factory. He also supported the development and deployment of a tactical solution for fast-tracked delivery of client data migration.

• Organised and oversaw the first and second deployments of the data migration and synchronisation solution to the client's production environment, organising troubleshooting and remediation where necessary
• Organised and oversaw the ingestion of clients into the new customer portal production environment, consisting of ~90,000 clients and ~35,000 users, with each account holding on average ~£2.3m
• Defined and documented architecture decisions, including context, scope, and options analysis
• Created and maintained architecture diagrams defining parts of the system, such as infrastructure and data entity relationships
• Defined and documented intended behaviour, such as the filtering criteria used to define different types of customers, so that it could be reviewed and approved before use in development
• Prepared material for, facilitated, and presented the proof-of-concept project conclusion presentation, and weekly progress meetings, with client stakeholders
• Wrote SQL queries to extract information about the customer population for analysis and documentation