Mohammed Attia Mohamed Shahawy
Cost Controller Mezzan Holding Co. (SAP Key User)
Phone/ WhatsApp: +201********* / +965-********
E-mail: ***********.*******@*****.***
***********.*******@*****.***
Objectives
Seeking a position in accounting or finance field where excellent analytical and technical skills can be utilized to improve the company’s profitability.
Education
Bachelor of Commerce (Suez Canal University -Accounting and Finance -2012)
Experience
Cost Controller (SAP Key User)
Mezzan Holding Co. (4/2020 till Now)
Work in conjunction with all concern department to ensure maximum profitability
Assess all incoming products, resources and service to ensure the best price and lower cost
Ensure implement three way in incoming products and service
Create cost sheets for all incoming products and service were received
Maintain vendors and service provider relationship
Analyze invoices to ensure correct products and services were received at expected cost
Collaborate with department heads to strategic ways to minimize waste
Provide critical assessment of all budgets and cost projections
Create Bill of material (BOM) for products Materials
Preform Monthly Variance Analysis Report between actual, standard and budget cost
Prepare monthly closing for costing and cost of sale
Analyzed material requests and consumption reports to define materials needs.
Preparation and analyze random, monthly and annum physical count for all stores
Preparation monthly production report for concern department
Senior Costing Analyst and Account Receivables (SAP key user)
Velocity Apparels ESC CO. (06/2018 -3/2020)
CO (controlling)
Planning, studding, Construct, Validate and collecting and monitor data to determine cost elements
Of business activities such as prime cost (row material and direct cost and labor)
Provide cost analysis result for budget cost and actual cost to management for decision making.
Perform variance analysis between actual, standard and budget cost
Review and analyze product margins for customers
Reporting with sales which reflect margins.
Participates with operation to update and review standard, actual and budget cost elements
report monthly WIP calculation, semi-finished goods and follow goods to finishing
calculate and reporting cost elements monthly COGS and COGM
follow up cost elements for production from budget cost to finishing
follow up OCR report (rejection report) in production line
Review and release budget cost sheets and reporting budget cost and budget contribute margin.
achieved to make cost statement report by cost elements which effected in COGM
Implements standard costing, ABC costing, services costing, invoice costing and cost center costing
Participates in monthly and annual physical inventory process.
Analyzed material requests and consumption reports to define materials needs.
Analyzed and reporting standard and actual cost elements
Senior Account Receivables
Follow up Domestic and export buyer’s invoices and Air Waybills and B/Ls
Follow up swift receipts from export invoices and reconcile customer accounts
Follow up all deliveries and match them with outbound invoices
Reconcile buyer LCs when receiving payment swifts
Follow up scrap (contracts –invoices and payments)
Prepare assets accounts and prepare all data for assets and its monthly depreciation
Prepare monthly customers Ageing and confirmation balances
Prepare monthly sales report and analysis domestic and export monthly sales
Prepare Cogs report monthly, sales report and turnover for Account receivables and inventory
Communicate with bank to settle overdraft accounts
Prepare monthly advertising expense and prepare report for export Sale incentive invoices
FI-Account Payables
Partner in Review and processing POs for raw materials, direct material, indirect materials and general goods.
Release payments to vendors and follow up bank payments related to vendors
Review and processing all fleet expenses
Post monthly accrual salaries
Reconcile transactions and treatments between inter company
Achievement: prepare OLAP sheet helps to following up account’s payables easily.
Senior General Accountant SAP user (FI&SD) (05/2014 – 06/2018)
Rashideen Egypt Trading Co (FMCG)
SD (sales & Distribution)
Following up daily orders for all categories (KA-Whale sale-Retail-Supermarket) .
Processing orders to invoices by matching with warehouse balances.
Reviewing customers ageing and their credit limits.
Matching and reconcile account receivables related GL accounts on timely basis at month end and reviewing monthly closing sales.
Receiving and settle out coming and incoming checks.
Processing and reviewing and settlement debit and credit for customers.
Reviewing all tax related entries in sales invoice and discounts.
Follow up checks and payments for customers.
Prepare daily and monthly retail sales reps physical counts.
Prepare monthly closing sales, Customers balances, customer incentive and reps incentives.
Reviewing Monthly trail balance for region to ensure accuracy numbers related to account receivables.
FI (Finance)
Reviewing and processing Purchase orders from other parties.
Manage and settle advance payment, prepaid expense and down payment.
Issuing and processing WH Tax for vendors on their invoices and prepare form 4 for regulatory tax.
Following up and settle cash in transit and hedge.
Processing all transactions on cash journal, petty cash, custodies and pick up and settle it.
Prepare Bank reconciliation for cash journal and checks
Prepare monthly inventory accounts.
Assist in financial requirements for external audit.
Achievement: prepared more spreadsheet which helps us to hurry up our roles.
Financial Accountant (01/2014 –04/2014)
International Technical and Trading Co (FMCG)
Working all trends and transactions on Account receivables.
Working all trends transactions on accounts payables.
Working all transaction on cash journal, petty cash and monthly salaries.
Prepare all transactions on GL accounts.
Prepare monthly closing for revenues, accounts payable.
Prepare monthly trail balance and assist in income statements, financial position statement and cash flow.
Prepare monthly bank reconciliation.
Achievement: prepared more excel sheets in accounting trends those help daily
Revenue Auditor
Hilton Sharks Bay (04/2013-12/2013)
Reviewed all guest ledger invoices.
Reviewed all room rates.
Reviewed all room occupancy.
Prepared daily occupancy.
Reviewed all checks aspects food and beverage Department.
Determined all Revenue for F/B Department.
Prepared Daily worksheet and made the summary of Revenue and made journalizing.
Independent Career
Instructor at Pledge Center ( 7-2019 ) – part time
PFA instructor (Professional Financial Accountant)
Training candidate bookkeeping., Accounting Framework and Accounting cycle and how to apply
Preparing journal and by excel and by manual.
Preparing how to prepare financial statements under GAAP
How to apply on advanced excel and Peachtree Accounting cycle till closing entries
Instructor at Al Massa Institute (7-2019 ) – part time
PFA instructor (Professional Financial Accountant)
Training candidate bookkeeping., Accounting Framework and Accounting cycle and how to apply
Preparing journal and by excel and by manual.
Preparing how to prepare financial statements under GAAP
How to apply on advanced excel and Peachtree Accounting cycle till
Accounting Instructor at Accounting House (11/2017)-part time
Training candidate PFA (professional financial accountant) course.
Training candidate bookkeeping.
How to prepare accounting information system and accounting principles.
Preparing journal and accounting cycle by excel and by manual.
Preparing financial statements under GAAP.
Accounting Instructor at SCCO (2/2017) – part time
Training candidate on PFA program, advanced excel and Peachtree.
Advance Accounting instructor -freelancer (10/2016-2/2017)
Language:
English (Professional working proficiency)
Certificates &Courses
CMA (certified Managerial accountant)-in progress
Financial and Tax Accounting -EGYPTIAN ACADEMY FOR CERTIFIED PUBLIC-ACCOUNTANTS (08/2013)
E-Commerce-Hilton university (4/2013)
On Q Fidelio system – Hilton university (5/2013)
PFA, Peachtree, QuickBooks-bookkeeping, commercial advanced excel-oxford academy (2/2012)
Leadership – Suez Canal university (8/2008)
Skills
ACCA-IFRS
GAAP-Generally accepted accounting principles
VBA Application
SQL
Oracle ERP
More knowledge about ERP systems and prepare it with VBA
Preparing excel sheets by VBA
Personal data
Birthdate:7/7/1991
Nationality: Egyptian
Military Service: Exempted
Marital Status: Married
LinkedIn :https://www.linkedin.com/in/Mohamed-atia-shahawy-34306397