profile-img

Tarek Sobhi

Financial and Operational Analysis Manager at Madinet Nasr For Housing And Development

Heliopolis, Cairo, Egypt

Work Experience

Madinet Nasr For Housing And Development

  • Financial and Operational Analysis ManagerFull Time

    Jul 2024 - Present -11 months

    Egypt , Cairo

    • Job Details:• Collect data from various sources (ERP systems, sales reports, market data, cash flow reports). • Analyze revenues, costs, and profit margins to prepare detailed reports on financial performance. • Develop forecasts and financial and business models to assist in setting growth and development strategies. • Monitor KPIs related to sales, such as the number of units sold, reserved units, and conversion rates. • Analyze daily operational activities to identify strengths and weaknesses, offering recommendations to improve efficiency and reduce waste. • Evaluate the performance of sales teams and work on enhancing the distribution of commissions and incentives based on established performance metrics. • integrate financial, operational, and commercial analyses along with strategic recommendations for performance improvement. • Deliver analytical summaries to senior management to aid in formulating future plans and financial strategies. • Develop periodic reports on liquidity status and analyze the movement of funds within and outside the organization. • Oversee payment processes with banks and ensure adherence to payment and tax deadlines. • Prepare sales and operations commissions • Issue broker commissions claim and transfer to broker’s bank account • Propose and execute operational improvements using data analysis tools to automate and streamline report preparation and provide accurate data to management. • Participate in performance review meetings and provide insights on developmental measures.
  • Treasury and Cash Management SupervisorFull Time

    Jan 2023 - Jun 2024 -1 yr, 5 months

    Egypt , Cairo

    • Job Details:• Cash Flow Management: Manages the inflow and outflow of cash to ensure adequate liquidity. • Investment Strategies: Develops strategies to invest funds for optimal returns. • Financial Reporting: Prepares accurate financial reports to reflect the company's financial status. • Cash Flow Analysis: Analyzes cash flow to identify strengths and weaknesses in financial operations. • Debt Management: Manages and monitors debt obligations, ensuring timely repayments and optimal financing. • Policy Development: Creates financial policies to ensure compliance and achieve financial goals. • Banking and Financial Relationships: Manages relationships with banks and financial institutions to secure the best financial services. • Team Leadership: Leads and directs the team to achieve the company's financial objectives.
  • Lead Treasury and Cash ManagementFull Time

    Apr 2021 - Dec 2022 -1 yr, 8 months

    Egypt , Cairo

    • Job Details:• Monitoring and managing the organization’s bank relationships and liquidity management. • Analyzing various scenarios and risks and reporting to Director Treasury. • Forecasting of medium and long- term funding. • Daily cash management. • Debt facilities management. • Team management. • Manage relationships with financial service providers. • Preparing management and board reports. • Liaising with senior management across the organization. • Prepare loan drawdown requests with related supporting documents. • Monitoring the loan reconciliation with Banks. • Prepare what needed in case of loans and bank facilities that insure the company rights. • Assist the Director Treasury in cash management of the group and preparing accurate cash flow forecasts. • Preparing Weekly, Monthly Treasury report including monthly cash & overdrafts position. • Supporting the month end process where necessary.
  • Senior Treasury and Cash ManagementFull Time

    Apr 2019 - Mar 2021 -1 yr, 11 months

    Egypt , Cairo

    • Job Details:• Overseeing the gathering of closing and reporting daily bank balances. • Forecasting payments and receipts going through these accounts. • Purchasing foreign currencies to make overseas payments when required. • Preparing draw-down schedules, debt runoff schedule, loan database. • Verifying payments and overseeing the approval process. • Ensure that bank mandates are in compliance with all payment transactions. • Secure proper filling of payments transactions. • Supervise and review short & long-term cash forecasting to aid forward planning of the cash position and debt payments. • Actual cash flow analysis. • Bank relationship management: • Manage bank accounts open/close process as well as banking services. • Monitor, review, and correct interest and banks charges. • Review bank documentation in relation to the bank's credit facilities. • Review term sheets, covenants, documentation, and reply to bank's credit queries. • Monitor bank guarantee expiries for cancellation or extension. • Strong liaising with the sales teams on the above. • control inventory & availability to facilitate the booking process • Manage reservation cancellation, sales cancellation process • Master inventory Management (Monitor & control the booking status, unit block/ unblock, release / unrelease) • Prepare sales and operations commission • Prepare sales performance reports • Manage pricing inventory units Increasing/ Reducing sales unit • Prepare units status (sold, reservation)
  • Treasury and Cash ManagementFull Time

    Dec 2015 - Mar 2019 -3 yrs, 3 months

    Egypt , Cairo

    • Job Details:• Managing business relationships with all kinds of financial service providers. • Managing domestic and international payments • Performing daily cash position report. • Accounting entries. • Wire transfers. • Prepare Bank Reconciliations. • Preparing a list of authorized signatures for the company. • Follow up financial transactions through online banking. • Ensure safe custody of LG's and all its related tasks (monthly renewal, reductions, cancellation, releasing & comprehensive filing for LG's original copies). • control inventory & availability to facilitate the booking process • Manage reservation cancellation, sales cancellation process • Master inventory Management (Monitor & control the booking status, unit block/ unblock, release / unrelease) • Prepare sales and operations commission • Prepare sales performance reports • Manage pricing inventory units Increasing/ Reducing sales unit • Prepare units status (sold, reservation)
  • Junior AccountantFull Time

    FedEx Express

    Mar 2014 - Dec 2015 -1 yr, 9 months

    Egypt , Cairo

    • Job Details:• Process Daily Outbound shipments. • Update Customer accounts with the Payment and Tax reports received from Credit Controllers after forwarding the Cash to Cash Receivable. • Reconcile the Customer Payments, Adjustments, and Taxes in the Sales Ledger. • Control Cash Shipments. Process Debit & Credit Note. • Process special billing requirements. • Process the monthly Inbound Billing. • Process Month End. • Monthly Local & External Billing • Prepare month-end reports. • Any other job-related duties.
  • Finance DepartmentInternship

    BAPETCO/ Shell

    Egypt

    • Relationship ExecutiveInternship

      NSGB

      Egypt

      • Education

        • Bachelor's Degree in Accounting

          Ain Shams University (ASU)

          Jan 2009 - Jan 2013 - 4 yr

        • High School - Thanaweya Amma

          youssef el sebai language school

          Jan 2009 

        Activities

        • Fundraising Coordinator & Projects Member at Enactus

          Volunteering

          Nov 2012 - Oct 2013 -11 months

        • Founder & Financial Coordinator at Association of Investment Business & Economics

          Student Activity

          Oct 2012 - Aug 2013 -10 months

        Skills

        • Microsoft Word
        • Microsoft Excel
        • Internet
        • Data Entry
        • Accounting
        • Microsoft Office
        • Microsoft Powerpoint
        • Microsoft Access
        • SAP
        • Financial Analysis
        View More

        Languages

        • Arabic

          Fluent
        • English

          Intermediate
        • French

          Beginner

        Training & Certifications

        • Finance Department

          BAPETCO/Shell·2012
        • ICDL

          LandMark·2012
        • Relationship Executive

          NSGB·2012
        • ICDL

          2011
        Share this Profile