KE
Kareem Ahmed Elbahey
Senior Financial analyst at Coats PLC
Zaytoun, Cairo, EgyptWork Experience
Acting Finance managerFull Time
Wssel Co.
Feb 2021 - Present -4 yrs, 4 months
Egypt , Cairo
- Job Details:Provide financial reports and interpret financial information to managerial staff while recommending further courses of action monthly and quarterly. - Advise on investment activities and provide strategies that the company should take - Create and develop the long term financial projection model to aid in investment process - Analyze costs, pricing, variable contributions, sales results and the company’s actual performance compared to the business plans. - Conduct reviews and evaluations for cost-reduction opportunities -Follow-up daily activities and approval of purchases, POs, daily expenses and contracts. - Oversee operations of the finance department, set goals and objectives, and design a framework for these to be met. - Manage the preparation of the company’s budget - Review with auditors to ensure appropriate monitoring of company finances is maintained. - Correspond with various other departments, discussing company plans and agreeing on future paths to be taken - Ensure compliance with accounting policies and regulatory requirements
Senior Financial analystFull Time
Wssel Co.
Sep 2019 - Present -5 yrs, 9 months
Egypt , Cairo
- Job Details:- Monthly analysis of Actual costs versus plan and forecast(Budget Control) - Compare actual CAPEX (FA) expenditure monthly compared to plan and forecast - Prepare cash flow for the next three months and Compare it to actual, plan and forecast - Handling daily purchase requests and expense sheets compared to budget, approval hierarchy and allocation of expense accounts and Cost centers - Preparing Sales Profitability report. - Review for audited financial statements and tax return annually and Compare it with the Company TB and analyze the adjustments and classifications. - Handling Daily Payments in respect of the current cash flow position.
Senior Financial analystFull Time
Coats PLC
Mar 2014 - Present -11 yrs, 3 months
Egypt , Cairo
- Job Details:A) Analysis - Monthly analysis of Actual costs versus plan and forecast (Budget Control) - Compare actual CAPEX expenditure monthly compared to plan and forecast - Prepare cash flow for the next three months and Compare it to actual, plan and forecast - Handling daily purchase requests and expense sheets compared to budget, approval hierarchy and allocation of expense accounts and Cost centers. - Preparing Sales Profitability report. (By Customer, Article, Area, and Brand GM analysis.) - Dormant and Slow moving analysis monthly and its provision - Forex accounts analysis monthly and shows the category of gain or loss. - Review for audited financial statements and tax return annually and Compare it with the Company TB and analyze the adjustments and classifications. - Handling Daily Purchase requests and manual expense sheets in respect of budget, account and cost center allocations B) Planning - Prepares actual data analysis annually and quarterly to help in building the new plan. - Prepare Capex planning expenditure and depreciation for the plan and forecast. - Uploading plan and forecast data to SAP. C) Costing - Collecting the Data for last purchase prices for each material in the production process and its last additive costs and building the new standard costing per item. - Providing standard cost for new created material - Creating the general prices for new products D) Taxes - Review and prepare the sales tax (form 10) report and WHT (form 41) report to be submitted to tax authority - Handling all tax inspection requirements needed - Deferred tax calculations annually - Prepare and create the annual income tax report (form 28) - Doing Provision analysis monthly report. (For each provision movement and its reasons. - Preparing Withholding tax 20% for outside transfer payments and analysis. (art. 56) - The calculation of the reverse commissioning and fill form 111 - Handling Sales tax, Payroll tax, income tax, stamp tax and property taxes inspections and payments.
Education
BS. in Accounting
Ain Shams University (ASU)Jan 2009 - Jan 2013 - 4 yr
High School - Thanaweya Amma
Um kalthoum Lang. School.Jan 2008
Achievements
Best Employee in the accounting Department Q1 2015. Best Employee in the accounting Department Q3 2016. Best Employee in the accounting Department Q3 2017. Best Employee in the accounting Department Q4 2018. From the top five Cooperative members in SAP implementation in 2015.
Languages
Arabic
FluentEnglish
FluentFrench
Intermediate
Training & Certifications
Power BI
Freelance·2019Excel VBA
EDU Academy·2019Excel BI
EDU Academy·2019English Conversation course
Berlitz Egypt·2012