Author Image

Sherif ElGamal - CPA, CMA, CIA

Sherif ElGamal

Accounting and Advisory Professional

Audit and accounting professional with 18+ years of experience in audit, financial control and reporting. I am very enthusiastic about technology in the field of finance and I enjoy find solutions to improve and automate accounting, reporting and budgeting processes management. Extensive experience in information technology and business intelligence in the field of accounting and finance. I am CPA, CMA, CIA qualified.

Certified Public Accountant
Certified Management Accountant
Certified Internal Auditor
Enrolled Agent
Certified Fraud Examined
XBRL Individual Certification

Skills

Credentials

Certified Public Accountant (CPA)
2010
American Institute of Certified Public Accountants
Certified Management Accountant (CMA)
2012
The Institute of Management Accountants
Certified Internal Auditor (CIA)
2007
The Institute of Internal Auditors
Certified Fraud Examiner (CFE)
2009
The Association of Fraud Examiners
Enrolled Agent - Enrolled to practice before the IRS (EA)
2013
Internal Revenue Service
XBRL individual Certification
2020
XBRL International

Experiences

1
Accounting and Advisory Consultant

Nov 2010 - Present, Cairo, Egypt

Utilizing my professional network and upwork.com platform providing 4000+ hours of accounting, advisory and tax services to clients remotely and on site.

Responsibilities:
  • Accounting advisory including design and implementation of accounting systems, controls and process automation.
  • Advisory on business analytics including data warehousing, statistical analysis and visualization on multiple platforms.
  • Accounting information systems advisory including support in implementation and setting up accounting packages such as Quickbooks, SAGE and Xero.
  • Budgeting, planning and cash flow management.
  • Sworn court expert issuing reports on financial matters providing based on court assignments.
  • Tax services, for income tax and VAT, including preparation of various tax forms supporting schedules.
  • Tax, Accounting and auditing literature research.
Financial Expert
Expertise and Dispute Settlement Department at H.H. Ruler’s Court - Dubai, UAE

Dec 2018 - May 2019, Dubai, UAE

Sworn Expert at Dubai Courts and public prosecution, responsible for providing an opinion and preparing Financial Expert reports in compliance with the court assignments for all types of legal cases (civil, commercial, criminal, estate, liquidation) to assist the court in legal cases that require expert opinion.

Responsibilities:
  • Conducting meetings and debriefing personnel of organizations subject matter to a dispute or litigation.
  • Identifying elements of Expert assignment and related documentary evidence and interviewing witnesses.
  • Examining all accounting and financial documents, contracts, agreements, relevant to the case.
  • Examining and auditing financial transactions relating to criminal cases and providing an opinion to assisting the court in classifying violations.
  • Effectively and efficiently managing and coordinating expert meetings with parties to litigation.
  • Writing clear concise expert report to assist the court.
2
3
Director - Audit and Consulting
Sherif ElKamary & Co. Auditors & Consultants

Jul 2011 - Oct 2018, Cairo, Egypt

Reporting to the Managing Partner, managing a portfolio of clients providing audit and consulting services.

Responsibilities:
  • Managing engagement schedules and staff and budget allocations.
  • Ensuring engagements performance meets professional and quality standards.
  • Ensuring engagements conclusions are supported by appropriate documentation.
  • Ensuring high quality deliverables.
  • Providing guidance to team members.
Manager - Financial Control and Reporting
Al Khalij Commercial Bank (alkhaliji) QSC

Jul 2011 - Oct 2018, Doha, Qatar

During the startup period of alKhaliji I was responsible for the design and implementation of general ledger and reporting processes, when operation started I became responsible for all aspects of financial reporting including consolidation, annual disclosure and regulatory reporting.

Responsibilities:
  • Preparation of group consolidated financial statements.
  • Preparation of regulatory report required by the central bank.
  • Monitoring General ledger activities and ensuring compliance with internal processes and Central bank operational instructions.
  • Overseeing General Ledger reconciliation to other banking modules
  • Monitoring and reporting on performance in relation to liquidity, credit, market and forex risks compared to risk management strategies and objectives.
  • Monitoring compliance with IFRS, updating accounting policies and procedures and deciding on accounting treatments for complicated non-routine transactions.
  • Handling relation with external and internal audit teams.
4
5
Assistant Manager - Audit and Advisory
KPMG (and others)

Jan 2001 - Apr 2008, Doha, Qatar

In 2001 I started my career in audit and advisory, I moved between few firms and worked my way up to Assistant Manager with KPMG where I was responsible for managing audit teams in carrying out audit procedures in accordance with firm policies and professional standards.

Responsibilities:
  • Managing engagement schedules and staff allocations for assigned client portfolio.
  • Ensuring engagement performance meets Firm’s, professional and quality standards within the assigned budget.
  • Handling communication with clients on technical and administrative issues.
  • Providing guidance and training to team members.
  • Engagement responsibilities included leading opening meetings with clients, identifying inherent risks and significant risk areas.
  • Communicate understanding to engagement team members and guide them through planning, setting audit objectives, internal control evaluation, preparation of audit programs.
  • Review team members’ work and perform completion and reporting based on conclusions from audit work.
  • Secure engagement director’s approval on conclusions and resolve review points.
  • Prepare final deliverables and ensure compilation of the completed audit file.

Projects

R Shiny - Stock Price Analysis
R Shiny - Stock Price Analysis
Developer Jan 2018 - Present

Analysis tools for stocks historical prices based on R Shiny framework (go to app).

stock prices R Shiny Rscript
Star
arrellyPy plugin for arelle
arrellyPy plugin for arelle
Developer Dec 2020 - Present

A plugin for Arelle application providing as simple to used python API for arelle.

python arelle xbrl xml javascript html css
Star
rssDB plugin for arelle
rssDB plugin for arelle
Developer Dec 2020 - Present

Inspired by xbrlDB arelle plugin, this plugin retrieves and stores SEC XBRL feed for submitted fillings.

python arelle xbrl sec postgres sqlite mongodb xml javascript html css
Star
arelle
arelle
Contributor Dec 2021 - Present

Arelle open source XBRL platform.

xbrl python xml postgres sqlite javascript html css
Star
XBRL Glossary Collection
XBRL Glossary Collection
Author Sep 2021 - Present

Translation of XBRL terminology to Arabic Language (go to page).

xbrl translation arabic python html
Star
Notes on XBRL Specifications
Notes on XBRL Specifications
Author Aug 2021 - Present

This material is a collection of notes on XBRL put together to provide a basic understanding of what is XBRL, what it does, and how it is implemented (go to page).

xbrl R Rmarkdown
Star
Articles and Blogs
Articles and Blogs
Author 2015 - Present

Series of articles about using MS Power BI in data analytics.

xbrl R Rmarkdown
Details

Training

Maintaining minimum of 40 hours of CPE annually in various accounting, audit, and risk management topics since 2008
2008-Present
Continuing Professional Education
Advanced Data Analysis Nano degree (Udacity)
2021
Udacity
Certificate of International Audit (Cert IA)
2010
Association of Chartered Certified Accountants (ACCA)
Certificate in International Financial Reporting (Cert IFR)
2010
Association of Chartered Certified Accountants (ACCA)
Integration of Business Processes In SAP ERP
2012
SAP Academy

Education

Alexandria University, Alexandria, Egypt
1996-2001
Bachelor of Commerce (English Section) - Accounting Major
Victory College, Alexandria, Egypt
1981-1996
High School