Financial and Commercial Analyst
Iqarus Gulf
Total years of experience :9 years, 6 Months
Review of tender documents, Request for Proposals (RFPs), bids etc. to identify any commercial risk.
• Develop pricing/commercial models which includes financial modelling, sensitivity analysis, cash-flow, budgeting, financials risks & rewards for each tender, RFP, bid.
• Liaise with various internal stakeholders such as Delivery and Solutions, Procurement, Sales, Finance, Legal etc. to gather information for building the pricing and commercial model.
• Liaise with finance team members to understand and highlight performance related gaps i.e. budget against actuals.
• Conduct cost research and cost benefit analysis to ensure cost realism.
• Review draft contracts and identify risks and provide possible mitigations.
• Assist in developing a summary report for individual projects which captures all key information specific to the project such as start/completion date, changes in scope, assets allocation, profitability etc. for senior management’s usage.
• Assist senior management in project analysis, forecast and budget as required.
• Create operational project budgets for Delivery and Solutions team which covers key financial milestones, operational delivery plan, resource allocation and contractual compliance.
• Prepare and run pricing review meetings.
• Worked on Financial Modelling, Financial Analysis and Financial Forecast using Excel and Power BI.
• Formulated Pricing Matrix/Costing for Sales to understand the Cost Impact on Business.
• Worked on Commercial Tenders and Quotations with different Pricing Templates.
• Expertise on creating Power BI reports and Dashboards including Modelling and Reporting using both Import mode and Direct Query mode, used multiple visuals applied role-based security.
• Identified Loss making jobs for the total of approximately AED 3.5 million book of business and developed new strategies, resulting in 2% revenue increase over 6 months.
• Implemented Customer Ranking Model based on Revenue and Payment Cycle Time
• Reduced Accommodation Expenses by 15% by formulating Room Distribution Policy with HR Team.
Identification of Potential Clients, Developing Client Briefs, Delivering a Standardised Execution Plan with timelines for each transaction, Preparing Business Cases together with Supporting Market and Financial Analysis .
Achievements:
• Developed DCF Models, Financial Feasibility for Transactions, Business Model Analysis
• Worked on Transactions worth more than AED 500 Million .
• Successfully executed Sale transaction of more than AED 50 Million of a Running School in Dubai.
• Tied up Management Operators for two 4 star hotels.
• Build to Suit Expansion for Two Schools worth AED 195 Million .
• Managed and Successfully Handled Corporate Events for ICREA during my tenure.
Global Chartered Financial Analyst Certification Level 1 Cleared
B.Tech (Computer Laxmi Niwas Mittal Institute of Information 2012 69.00% Science) Technology (LNMIIT), Jaipur