Tarek Sobhi
Financial and Operational Analysis Manager at Madinet Nasr For Housing And Development
Heliopolis, Cairo, EgyptWork 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
- 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.
Education
Bachelor's Degree in Accounting
Ain Shams University (ASU)Jan 2009 - Jan 2013 - 4 yr
High School - Thanaweya Amma
youssef el sebai language schoolJan 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
FluentEnglish
IntermediateFrench
Beginner
Training & Certifications
Finance Department
BAPETCO/Shell·2012ICDL
LandMark·2012Relationship Executive
NSGB·2012ICDL
2011