Feb 2016 to Jul 2018
- A newly created role designed to streamline audit & compliance processes and build management information systems.
- Built a standardized audit template resulting in faster audit responses and less need for discussion around audit response.
- Audit response time decreased from 18+ months to 2 months.
- Received praise from Lloyd’s markets and audit staff on the efficiency of the system, usability, and comprehensiveness.
- Built, operated, and maintained a data lake on 2 distributed servers within the office network.
- The data lake was able to import 1,800,000+ rows from 4,200+ Excel spreadsheets in less than 24 hours.
- Brought the data from ~24,000 claims in ~2,000 spreadsheets into the data lake and built a tool for searching claims. Underwriters used this tool for renewals rather than discussing each renewal and each claim with the claims staff.
- Built reports combining all spreadsheets of underwriting and claims data. These reports were used in Lloyd’s contract negotiations to show immediate impact of management decisions.
- Built an online insurance quote tool in 2 months that worked within Lloyds’ requirements for human review of policies prior to binding. The tool was so efficient and easy to use it was preferred by internal underwriting staff as well.
- Built an web app for policy renewals in 4 months that was integrated in an associations website for the members’ use. Within specified criteria association members could fill out renewal details, obtain a quote, issue a policy, and pay by credit card.