Financial Planning And Analysis Manager
Taiba Hospital
Total years of experience :12 years, 6 Months
Budgeting & Reporting
Key Responsibilities:
- Leading and managing the budgeting & forecasting activity for the business.
- Compile and present monthly financial reports and KPIs.
- Develop and enhance various financial reporting dependent on business needs. Oversee the review and analysis of periodic (monthly/quarterly/annual) financial performance to determine key drivers impacting financial statements.
- Analyze actual results vs. budget, forecasts, and prior year; provide detailed measurements and explanations to all variances.
- Monthly review meetings in collaboration with business owners and discussing future roadmap for rest of the year to achieve the targets.
- Undertake revenue enhancing and cost saving analysis e.g., pricing, profitability, etc.
- Undertake ad-hoc analysis projects including feasibility studies, ROI / IRR, etc.
Key Achievements:
- Dashboards & Data Visualization of Financial information & KPIs for Top Management and Board of Directors.
- Designing of overhead cost allocation system with cost drivers and business assumptions.
- Building of 10-year financial model with multiple assets / entities for the group.
- Built a detailed payroll working file (employee wise) capturing each payroll component for planning & forecasting purpose.
- Introduction of Balance Sheet & Cash Flow statements for planning & budgeting purpose to track KPIs.
- Successful implementation of EPBCS Hyperion and designing of Financial, HR, Projects & Capex modules along with dashboards.
- Consolidation of Financial Report
• Timely consolidation of monthly financials for all the operating regions of the organization.
• Prepare Monthly Performance Report with detailed analysis of performance for the month and comparing its performance over a period.
• Ensuring smooth year end closing and liaising with auditors for the year end audit on a group consolidated level.
• Developed audit template for all the subsidiaries to facilitate timely consolidation and completion of audit.
- Budgeting and Forecasting
• Prepare yearly consolidated budget (Financials, Manpower, KPIs) based on the individual region’s inputs and presenting it to the management.
• Prepare weekly cash reports for foreign payments with available FX covers and additional requirements.
- Performance Management Reporting
• Weekly/monthly Sales & GP Analysis report.
• Monthly inventory & receivables report for reviewing and monitoring the aging.
• Developed an inventory item-wise template which calculates short/excess quantities based on multiple parameters such as ideal quantity, stock cover, lead time, etc.
• Developed an advanced financial model for studying 7 years trend analysis of individual region’s operating performance (Profitability, Growth, Manpower, etc.)
- ERP implementation (Oracle Fusions)
• Appointed as key personnel for ERP implementation for the company along with its subsidiaries.
• Planned and designed the enterprise structure for the new system, for each entity across all the regions.
• Designed the new chart of accounts for the company with multiple segments as required by the new system, to be used universally by all the entities of the group.
• Understanding the business user requirements and communicating to the implementation consultants and vice-versa.
- Additional responsibilities and achievements
• Appointed as project leader for implementation of DMS software across the organization. Successfully implemented and administered the DMS software for the company, improving work efficiency and achieving the organization goal of paperless work.
• Conduct basic & advanced MS Excel training sessions for colleagues as a part of organization’s objective of on-the-job training and development of the employees.
• Financial Accounting & Reporting
-Timely upload of financial data (TB, Management adjustments) into the corporate’s reporting tool (Hyperion).
-Prepare Monthly Operational Report with detailed analysis of business unit’s performance for the month and comparing its performance over a period.
-Ensuring smooth year end closing and liaising with auditors for the year end audit.
• Budgeting and Forecasting
- Prepare yearly budget and quarterly reforecast and uploading it into the corporate’s reporting tool.
-Prepare weekly treasury & cash flow projection reports.
• Performance Management Reporting
- Computing weekly/monthly KPIs.
- Monthly operating metrics report.
- Weekly/monthly Sales Analysis report along with Management commentary.
Successfully handled the following assignments as an Article Assistant:
• Maintenance of accounts up to finalization of various companies & firms in manufacturing, trading & service industry with reference to compliance of Accounting Standards.
• Ledger scrutiny of account balances in accounting packages & verification of financial statements.
• Financial Ratio Analysis on the basis of Balance Sheet and Profit & Loss Account.
• Independent Statutory and internal audit carried out to check the accuracy and reliability of financial statements, compliance with laws & regulations & effectiveness of operations.
• Was outsourced to a company named Konecranes India Pvt. Ltd. (Konecranes is the world's largest crane making company) for a period of 1 year as an Accounts Receivable (AR) executive. Handled the entire AR activities of the organization and worked closely with the Finance & Accounts manager of the company.
• Handled all the fixed assets related activities and maintained FAR of the above mentioned company.
• Managed the reinstatement activity of the foreign group company balances.
• Was a key team member in the data migration activity of its newly acquired company, WMI Cranes, from Tally ERP to SAP B1 and then merging the data of both the companies.
• Was on the SOP development team for the above mentioned company and worked closely with the individual process heads to understand the present processes followed and develop & suggest the standardized processes followed by the industry.
• Maintenance of accounts up to finalization of various companies & firms in manufacturing, trading & service industry with reference to compliance of Accounting Standards.
• Financial Ratio Analysis on the basis of Balance Sheet and Profit & Loss Account.
• Independent Statutory and internal audit carried out to check the accuracy and reliability of financial statements, compliance with laws & regulations & effectiveness of operations.
• Adequate documentation of work and preparation of report.