• Collaborated with cross-functional teams to gather requirements, analyze workflows, and design applications that streamline processes and improve operational efficiency• Many of the solutions I built where in the form of SaaS• Managed and participated in data migration from legacy systems to newly built Microsoft solutions that included Power Automate, Power Apps, Power BI, Power Query, Power Pages and ASP.net with cloud data stored in a mixture of Microsoft Dataverse, SharePoint and SQL.• Built Power Pages website solutions with Canvas Apps used on various pages. These Canvas apps were connected mainly to Azure SQL but at times to SharePoint and Dataverse. I incorporated most of the Power Apps functionality that I built in Power Apps in these.• Made RESTful API calls in Power Apps and Power Pages using Power Automate API calls that parsed JSON in order to use manipulate data.• Power BI reports were built using DAX and M code and embedded in Power Apps, Power Pages and ASP.net web apps. Alerts based on KPIs and other automation was an integral part of the Power BI build.• Used CoPilot AI in Microsoft Power Apps and Power Pages builds• The Power App/Automate solutions included functionality around accounting: including ordering, invoicing, purchasing, inventory control and so on. • The Power Apps included web data visualization built in Power BI using a real-time connection to the Dataverse and SQL. Power BI dashboards were embedded into custom pages in the model driven apps.• Used SQL triggers and Power Automate to initiate daily tasks and approvals. These were shared across the company using Outlook and Teams• Developed and managed development of ASP.net C# web solutions that worked with data in SQL Azure.• Technical documentation of process flows for solutions and migration gap analysis• Clients sites worked on included Landmark Underwriting Ltd, Ardonagh Group and Towergate Insurance.

• Managed systems migration from legacy software to Power Platforms on short-term contract using agile methodologies. • Collaborated with stakeholders in various areas of the business to formulate the data modelling needed for Power Platform solutions• Facilitated the data migration from L’Oreal’s legacy systems to the new SQL platform.• Facilitated and developed business intelligence dashboards with Power BI with extensive use of DAX & M code• Office 365 (SharePoint, Power Platform) solutions were managed to ensure optimal performance, scalability, and user satisfaction.• Conveyed business requirements to delivery teams

• Lead software analyst and engineer for arms control system using both Microsoft Cloud and Microsoft Office technologies (agile methodologies).• The project was funded by the United Nations and the system was used by police and military forces around the world• Worked with key stakeholders in the design and delivery of the system.• Used a mix of Microsoft cloud functionality, including ASP.net, Power Apps, Power BI and Power Automate• Created and maintained project documentation, including business requirements, process flows, and test plans.• Organized workshops with stakeholders, coders and users.• Managed police and military IT teams in the user acceptance testing and implementation of the product.• Countries that used it included Samoa, Fiji, Sierra Leone, Burkina Faso and several others in Africa were in the process of testing it• Data modelling, data visualization and report development using SQL and Power BI

• Worked with directors and managers to conceptualize, build and test a Microsoft Cloud and Office system that was used across 40 mining locations in South Africa, to gather daily core drilling data via an ASP.net Web solution (C# & VB.net) and analyze this using web data visualization (including Power BI).• Migrated existing legacy systems to cloud based mining solution using Microsoft ASP.net (C# & VB.net), Azure SQL and Excel VSTO (VB.net & C#)• Used Microsoft Power BI for data visualization• Used SQL triggers and Power Automate to initiate daily tasks and approvals. These were shared across the company using Outlook and Teams• Worked with the CEO and other senior stakeholders to model the system around existing processes and conceptualize and implement new ones.• Used Microsoft’s latest technologies to create a Cloud Azure and office 365 solution.• Microsoft Azure Active Directory, SQL, Web Apps, Servers and other features were used in the fully integrated solution.• Integrated the Microsoft Cloud solution to the newly implemented Xero accounting software• Used Power Apps to manage drilling systems maintenance and parts ordering• Created Canvas and Model-Driven apps to perform a number of data capture tasks for mining managers• SaaS solutions included in the build

• Solely responsible for design, development and maintenance of compliance systems in Access• Automated analysis of daily trading data using Access VBA• Developed trigger based system that compared legal requirements with trading information to detect non-compliance, which would be reported to management

• Automated analysis of trading data and reporting of this to senior management• Updated and developed new Access VBA coded solutions• General automation of data analysis in Microsoft Office Access, Excel, Word and Outlook

• Built Access VBA automated trading reports using Bloomberg feeds• Analysis of global emerging market data and money markets in Excel VBA• Integrated Microsoft Office solutions in Access, Excel and Outlook VBA

• Implemented new web based credit risk metrics system• Excel VBA automation• Managed user acceptance testing and roll out• Managed training and final go live for UBS EMEA, Switzerland and America

• Analysis and reporting during a SAP system migration• Analysis of global emerging market data and money markets