Summary
Overview
Work History
Education
Skills
Timeline
Generic

Fadi El-Khouri

Laval,QC

Summary

Results-driven Data Analyst with extensive experience at AIG Insurance Company of Canada, specializing in SQL, Excel, and Power BI for advanced data reporting and analysis. Proven ability to enhance collaboration across teams, achieving a remarkable 70% reduction in data refresh times. Adept at bridging technical and business sectors to support strategic decision-making.

Overview

26
26
years of professional experience

Work History

Data Analyst

AIG Insurance Company of Canada (PCG - data engineering)
Montreal, Quebec
06.2021 - 02.2024
  • Developed comprehensive data and reporting infrastructure leveraging SQL, Excel, Power BI, and Tableau.
  • Established real-time insights into product and business KPI visibility using advanced tools.
  • Contributed , maintained and owned monthly and quarterly financial reports such as policies retention rate, premiums policies rate change, actuarial business indications, inforce policies, reinsurance, DNR, and master business reviews.
  • Worked closely with actuarial and executive teams to swiftly create a temporary data collection application for new policies following the Covid-19 pandemic utilizing SQL plus Microsoft Access database.
  • Collaborated with four delivery teams in business, IT, data modeling, and data quality to migrate data warehouse business processes to Snowflake, reducing manual data refresh from 21 hours to 6 hours.

Business Services Specialist

AIG Insurance Company of Canada (Administrative services Canada)
Montreal, Quebec
07.2008 - 06.2021
  • Supported Canadian employees with hardware and software issues.
  • Facilitated escalations to AIG Central helpdesk for advanced troubleshooting.
  • Handled reception mailroom duties, including scanning documents.
  • Oversaw inventory for the Montreal site.
  • Facilitated videoconference meetings at the Montreal location.
  • Ensured seamless project execution through effective liaison between both head offices and Montreal.
  • Designed and developed a small application to enhance efficiency and reduce mistakes.

LAN Network Administrator

AIG Insurance Company of Canada (Infocentre)
Montreal, Quebec
11.1997 - 07.2008
  • Performed regular maintenance of server hardware and software systems.
  • Performed regular maintenance of server hardware and software systems.
  • Maintained inventory records of all hardware components used in the LAN environment.
  • Installed, configured, and tested network hardware, software, printers and cabling.
  • Trained end-users on proper usage of computers connected to the local area network.
  • Installed security software to protect networks.
  • Implemented and provided technical support for voice services and equipment.
  • Managed user accounts on the local area network.
  • Deployed new applications and upgrades to existing applications on the LAN environment.
  • Provided technical support for LAN users in resolving computer-related problems or questions.

Education

Some College (No Degree) - Electrical Engineering

University of Quebec - ETS
Montreal, QC

Skills

  • Visual data representation
  • Data filtering
  • Defect tracking
  • Gap analysis
  • Data formatting
  • Report preparation
  • Microsoft transact SQL code
  • Microsoft Excel
  • Microsoft Power BI
  • Tableau
  • Microsoft Access
  • VBA (Visual Basic for Applications)

Timeline

Data Analyst

AIG Insurance Company of Canada (PCG - data engineering)
06.2021 - 02.2024

Business Services Specialist

AIG Insurance Company of Canada (Administrative services Canada)
07.2008 - 06.2021

LAN Network Administrator

AIG Insurance Company of Canada (Infocentre)
11.1997 - 07.2008

Some College (No Degree) - Electrical Engineering

University of Quebec - ETS
Fadi El-Khouri