Aron Tai Email & Phone Number

London, Gb

Global, Us

- Drive vision and direction of travel for Lockton Europe's Data visualisation and Data engineering practices.- Set-up multi-team show and tell to enhance corporate data analytics and engineering bests practices.

Global, Us

- Developed and increased Lockton Europe's data maturity.- Together with the Head of Data created a new role for Data Governance in Lockton Europe.- Developed ETL piplines in Informatica IDQ- Developed and architected Lockton Europe's Data Warehouse- Implemented and developed PowerBI as Lockton Europe's Visualisation platform.- Sucessfully implmented Kanban and agile into project and team management.

Global, Us

• Configure and Develop Reporting and Dashboards for Senior Leadership.• Manage and developed custom UI for specific Departments• Provide data migration from legacy systems• Develop visual flow to facilitate better Producer engagement and drive the right MI.• Provide both remote and in-person training and skills development on the platform to the business.

Global, Us

- Solo full stack development and support of ELT process which is key to the Revenue Budget process for Lockton Europe.- Acted as a SME in Lockton UK's Data Strategic workstream.- Driving process change with data governance using best practices and new definitions.- Lead data analyst for Lockton UK's Brexit Strategy.- Created systems and controls for the collation of information from the business on client EEA exposure.- Provided data to the Head of International Risk & Compliance to facilitate conversations with regulators to create both an Irish and Maltese Entity.- Provided analytics for FCA information requests and exposure analysis across the group.- Developed automated solutions to aggregate multisource processes to generation core monthly KPIs.- Presented Operational KPIs and trend analysis to Ops Leaders and C-Suite.

London, England, Gb

Working on M&A project specification (written specification as well as Swimlane flow charts MS Visio/UML modelling) to integrate policy administration, underwriting, and accounting onto one platform (RiskWrite) to replace current legacy systems and to improve and streamline current processes. Reporting directly to the Director, who is acting as project manager.Reported directly to the financial controller to provide assistance in premium declarations, bank reconciliation and invoice trackingAnalysed data for the managing director in excel which contained in total over 50,000 records to produce reports used to underwrite Millstream’s most important client, and to produce reports for the insurer.

London, England, Gb

From scratch, developed Microsoft Excel VBA business software used in processing data, distribution of documents and issuing invoices. Simplifying policy administration processes, through automated data verification and shaping to enable end-to-end processing (cut start to finish processing time in half)From scratch developed an invoicing system in VBA to enable invoice tracking and to supersede legacy invoicing procedures.Investigated, built, developed and maintained an intranet and back office system (Google Sites)Worked closely with lead Underwriter to develop pricing tools for travel insuranceAnswered PA, Travel and Medical Underwriting QueriesBasic accounting and bank reconciliation (Premium Collection)Built a standardised framework for documents used by both the underwriting team as well as customer support to maintain a professional level of customer facing stationary.

City Of London, England, Gb

* Helping with general administrative jobs.* Draft up client letters for renewal reminders and contact changes.* Uplifting and renewing client’s insurance policies.* Amend internet receipt database for client renewals.* Created trade banners for business startup exhibition.* Designed web site layout.* Shadowed a senior insurance broker whilst he meet up with underwriters.* Spent a day on the box in Lloyd with Travelers UK.* Created Macros for Word and Excel to simplify complex and lengthy tasks.

Master Of Engineering (Meng), Electrical And Electronics Engineering

3 A-Levels, Maths, Physics, Chemistry