Hanan Bayad

Experience

• 

  Ministry of Employment and Social Solidarity – Quebec government

  Jul 2009 - Dec 2009

  IT Consultant

  • Analysis and performance evaluation of the local database application used by the administration members for managing thousands of projects funded through a +90M$ yearly fund, dedicated in recognizing and developing workforce skills in Quebec. • Redesigning and developing a faster, more user-friendly, menu driven database management system in MS Access, VBA, and MS SQL. • Development of automated dynamic management reporting system SQL.

• 

  CEGYCAN Consultants inc. – Montreal

  Jan 2010 - Nov 2016

  IT Consultant / Analyst

  • As an external consultant for the ministry of Employment and Social Solidarity, perform the analysis, present statistics and reports on collected and extracted data, from multiple government organization databases, for enterprises registered in Quebec MS Access, VBA and MS SQL. • Design online survey projects, develop the questionnaires. Collection, verification, processing data and producing table with MySQL & SAS.

• 

  Air Canada

  Jan 2016 - Jan 2017

  VDI project - SQL Data Quality and Integrity Consultant

  Virtualization Project for the working environment of 3000 users and about one hundred Air Canada applications. Citrix is the product deployed to virtualize applications across Air Canada's four business units.• Gather appropriate information and update SQL server databases.• Ensure data quality, integrity and accuracy in all reports.• Coordinate the planning of migration with four business unit’s clients via conference call.• Validation of results and production of dashboard.• Update document for any system's modifications. MS-SQL, Access, Excel, VBA, Windows. Show less

• 

  CGI

  Aug 2018 - now

  • Develop a Payroll Control Tool (SQL Server & Access) with objectives: - To help global business units validate payroll data in order to ensure the delivery of high quality & reliable services to our members. - To validate the pay by detecting and reducing errors. - This tool calculates the percentage in difference between two net payments for two consecutive months. - It goes into the details of payment codes to find the root cause of identified discrepancies. - It also validates the difference in basic gross salary. - Head Count by BU.• Develop a Payroll SOX report for UK with objectives: -To give an analytical review done prior the journal entry approval for Payroll UK and gives the key drivers for movements. - It is a control for FBS and SOX teams - It includes: Gross salary - deductions - Employers taxes, pensions etc. Show less

  • Senior Consultant SME - Global Payroll

    Oct 2021 - now

  • Consultant - Corporate Application Specialist

    Aug 2018 - Oct 2021