Renaud Le Berre Email & Phone Number

Sydney, Nsw, Au

Sydney, Nsw, Au

Sydney, New South Wales, Australia

Sydney, Australia

My role was predominantly divided between supporting the APAC Business Intelligence team and developing new process improvement solutions. Following the worldwide deployment of a new policy workflow system, I helped the Metrics team understand the underlying data mart and staging database structures. Thanks to my advanced SQL experience, I was chosen as the only APAC analyst to quickly absorb knowledge from the European Business Intelligence team in order to relay learnings in our region. As a result, we became self-sufficient in generating relevant operational reports and dashboards.Via our global IBM Netezza data-warehouse, I developed advanced SQL queries consolidating data from various underwriting systems and designed Qlik Sense reports for policy pre-renewal analysis and renewal processing (among others).As part of the Business Process Management team, I supported the complex integration of Ace and Chubb insurance. I participated in ETL effort to ensure the two companies’ systems consolidate over time. I also developed tools to simplify and bring transparency to our claims’ payment authorisation process, to control and automate quote generation in Asian countries which still relied on manual effort and to help automating inbound/outbound policy management for our multinational team. I also took part in research and development to introduce an RPA solution within Chubb. My focus was on discovering capabilities of WorkFusion and developing a pilot RPA project to automate policy documents download from broker platforms and indexing into our workflow system.

London, United Kingdom

I was responsible for the European IT Small Systems. The mission was to upgrade a legacy of Microsoft Access systems into a more robust work-frame supported by an SQL Server database. This effort drastically increased stability and security while still allowing for a quick development capability.Small Systems can be a real hazard for any company and yet they often are a necessity to complement larger strategic systems. By introducing a well-thought-out database, cohesive designs as well as standardised codes and a straightforward deployment method, I ensured the company had full transparency as well as a governed environment for those solutions to flourish.Some examples of projects covered under the Small Systems umbrella are:- An International Projects Dashboard and its worldwide deployment. This system tracks all IT & Business projects development. It has been built in partnership with the local PMOs in Asia, Australia, Canada, Latin America and Europe.- A Large Accounts Reporting solution collecting claims data from a wide range of Chubb strategic systems and compiling it into meaningful and individualized reports for our key clients.- A Prospect system allowing underwriters and managers to track prospects and report on each individual team’s activity.

Sydney, Australia

I was part of the Asia Pacific Business Process Management team. Our mission was to drive process efficiency by developing and deploying tactical solutions responding to the business’ immediate need. While we assisted most departments facing both or either efficiency and effectiveness issues, the core of our activities revolved around policy underwriting and claims processing.We worked following an agile methodology and in close collaboration with the diverse teams in need for technical support. This usually happened when larger IT systems were unable to rapidly adapt through transition phases, new products releases and so on. By offering short to medium term solutions, we successfully removed the burden of repetitive manual tasks, freeing time for team members to focus on more rewarding activities.Through innovative use of Excel, VBA, a bespoke SQL database, internal/external webservices and other tools we deemed necessary, we were able to provide advanced processing solutions by integrating complex rating engines, automating documents and emails generation, extracting and reusing data and automating data rekeying effort into our ‘green screen’ mainframe system. This resulted in an efficiency jump well recognised through APAC and our skillset became central to pivot teams into more efficient ways.By introducing low-cost/low-risk incremental change, we became a stepping stone between business managers and the often-misunderstood world of IT development. Business-oriented minds grew familiar with what it takes for an IT project to succeed, giving them an edge when more expensive projects required their input.From the IT perspective, value was in the creation of a controlled SQL environment from which data can be reused to prefill target systems via ETL processes. We regularly went through this exercise, decommissioned temporary solutions and provided the necessary data extracts along with well organised template and endorsement libraries to the relevant IT teams.

Sydney, Australia

I analysed the reserving guideline and developed the necessary tools to assess its effectiveness. I wrote reports on reserve estimation, reserving delay and worked on the loss ratio analysis. I produced claims tracking reports using SAS and designed systems to quickly manage and export data from Excel, using Visual Basic.

Rennes, France

I simplified data processing for the “Studies & Prospects” department in order to save time on repetitive tasks.

Brest, France

I performed data validation and reconciliation between various databases using SAS and developed a monitoring tool used by management to track invested funds.

Master'S Degree, Statistics And Econometrics, Specialty In Data Processing, Passed With Honours

Data Analysis • Data-mining • Econometrics (multiple equations model, panel data) • SQL querying

License (Bsc Equivalent), Economics Engineering

Econometrics (Simple regression, time series and forecasting) • Statistical Modelling • Databases management • VBA programming

License (Bsc Equivalent), Mathematics And Computer Science

Advanced concepts of theoretical mathematics • Introdution to Programming