Dor Gilan

About

Skilled in International Financial Reporting Standards (IFRS), internal audit, forensic accounting and data analysis & BI Knowledge and practical experience in writing scripts for building databases. Database server management Microsoft SQL server 2019 Administrative / application DBA. Knowledge and operation of the Microsoft Power BI system Experience writing BI queries. Knowledge and operation of the SSIS system. Knowledge of operation and planning of ETL processes. Certified payroll inspector -Ministry of Labor and Social Affairs, Israel Preparing financial statements of/for foreign companies and dealing with auditors' abroad. Accounting audit of Private Israeli's companies and nonprofits Israeli's organizations.

Experience

• C.P.A at Internal Audit, Forensic Accounting & Risk Management Departments at Navon Waisfeld C.P.A
  2021 - Present · 5 yrs 7 mos

  •Senior Manager- •Conducting and managing internal, investigative audit in companies, government ministries and government companies including audit committee. •Conducting Financial checks and inspections for Israel Innovation authority. •Auditing the English financial statements for health associations. •Analysis and processing databases by Power query, Power BI, etc.

• C.P.A at Internal Audit & Risk Management department at Private C.P.A Office
  2020 - 2021 · 1 yr

  •Conducting and managing internal audit in public corporations •Conducting and managing internal audit in government ministries and government companies including audit committee •Analysis and processing databases by Power query, Power BI, etc. •Conducting Financial checks and inspections for Israel Innovation authority. •Conducting Certified payroll inspector reports.

• C.P.A at Internal Audit, Forensic Accounting & Risk Management Departments at Navon Waisfeld C.P.A
  2017 - 2020 · 3 yrs

  •In charge of the Asset forfeiture budget of the Ministry of Justice. •Conducting and managing internal, investigative audit in government ministries and government companies including audit committee. •Analysis and processing databases by Power query, Power BI, etc. •Auditing the English financial statements for health associations.

• Senior Economist at Shalgam Consultants Ltd.
  2007 - 2017 · 10 yrs

  •In charge of bookkeeping, balance sheets, profit & loss of several foreign companies. •In charge of internal audit and supervision of the ongoing management activities abroad. •Monitoring budgets for projects under construction and preparing business plans.