Ibrahim Tamboli
FP&A Financial Manager at Johnson Control International, India.
About
A FP&A role with over 12 plus years of experience in Forecasting & Budgeting, Variance analysis, Revenue recognition, Flash & Dashboard published, Pricing short/long term deals, FTE time Utilization, Management & Financial Reporting, AR, Internal Audit/Controls as per US GAAP, & cost tracking.
Experience
Finance Manager (FP&A Sr. Analyst-3). - Johnson Control International Pvt Ltd. - Pune, India
(2022-10)
Working as FP&A Experts on reporting and various activities which support the JCI NA region function and business advisory services.
- Reviewed and reported revenue plans, forecasts, and actuals for NA–SA regions, presenting monthly to VP and Area Controllers/Directors, achieving forecast accuracy within ±3%.
- Prepared P&L reports (Secure Order, Secure Margin, TP Sales, Gross Margin, SGA, EBIT, TWC, Backlog Revenue), enabling leadership to make data-driven decisions that improved margin by MoM/QoQ/YoY.
- Prepare Web-Forecasting, Closing Data Validation and reporting trend analysis of pipeline of months as of 1st week.
- Cost Center level P&L 11 decks for various teams with commentary for comparison with Budgets & Previous Month.
- Oversaw daily MTD reporting and dashboard updates for revenue, margin, and cost, ensuring 100% timely delivery for 200+ stakeholders.
- Published weekly/monthly dashboards (Time Entry, Billing Velocity, Turn Rate, Slippage, Fire Backlog), improving operational visibility and reducing slippage.
- Partnered with business leaders to analyze change orders and prevent potential revenue leakage monthly.
- Developed operational review decks for America’s regions, streamlining reporting and reducing preparation time.
- Supported OneStream implementation (Oracle HFM replacement) through testing and data validation, achieving 100% compliance and zero migration errors.
- Led financial research and reporting for Fire Install Business and Drove process improvement initiatives, including reporting standardization and automation, saving 15% reporting time and enhancing accuracy.
- Ensure reporting aligns with Domain/Function Internal controls & SOX standards, maintaining zero audit findings.
- Collaborate with cross-functional for knowledge sharing, to resolve challenges and improve reporting efficiency.
Finance Controller Specialist (FP&A). - Dassault System Pvt Ltd. - Pune, India
(2020-02 - 2022-10)
Working as Financial Specialist which support the DS India function and business advisory services
- Developed monthly revenue forecasts from scratch with 95% accuracy, presenting insights to CEO and Geo Lead Director.
- Delivered utilization analysis for 100% workforce, categorizing billable/non-billable hours and reducing bench & uncharged time by 10% QoQ.
- Prepared annual budgets for 700+ headcount, maintaining variance within ±3% of forecast.
- Forecasted third-party business revenue and validated with PMs, improving margin accuracy by 1% through project-level analysis.
- Published weekly dashboards and presented intercompany/external revenue to CEO, enabling real-time visibility for Billing, Revenue, Cost and Margin.
- Performed headcount analysis to prevent $500K potential revenue leakage annually.
- Collaborated with PMs on pricing drafts, standardizing margins and reducing cost overruns by 2%.
- Delivered MIS decks with actionable variance commentary, reducing review cycle time by 10%.
- Reviewed STCs and hiring forms, corrected cost centers/OUs for 100% compliance, and supported PM’s in updating Trace File.
- Supervised one reportee, ensuring timely completion of reconciliations, accruals, and billing for employees and subcontractors with 100% TAT adherence.
CFM Sr. Financial Analyst - Accenture - Pune, India
(2011-08 - 2020-02)
Working as Client Financial Management Analyst which support the global financial management function and business advisory services.
- FP&A Support: Assist US client projects with financial planning, reporting, and revenue recognition under US GAAP.
- Variance Analysis: Prepare monthly P&L and KPI reports with detailed variance commentary for revenue, cost, and margin during review calls.
- Profitability Advisory: Provide financial insights and recommendations to engagement teams to optimize profitability.
- Budgeting & Forecasting: Develop annual budgets based on deal forecasts, pipeline trends, and leadership inputs.
- Pricing & Tools: Handle project pricing for outsourcing/consulting deals using Excel and MMP tools.
- Tracking & Reporting: Monitor time, cost, and expenses monthly/quarterly; report variances to India and US delivery heads.
- Inventory & Receivables: Manage variances and resolve discrepancies.
- Compliance & Controls: Ensure adherence to revenue/cost policies, support audits, maintain SOX controls, and secure approvals per thresholds.
- Adhoc Support: Assist team with quarterly deadlines and onshore queries.
- Systems Expertise: Track EAC, ODE, pipeline, and sales bookings via Salesforce (MMS), MME, and SAP; SME for MME forecasting tool and interface challenges.
- Team Management: Supervised two reportee, ensuring timely completion of reconciliations, accruals, and billing for employees and subcontractors, achieving 100% TAT adherence
Finance & Account Process Associate (AR & Recon) - Genpact Pvt. Ltd. - Hyderabad
(2009-09 - 2010-12)
Looking for Account Receivables and Reconciliation of International hotel groups.
- Process credit card, lockbox, ACH, and wire payments in Oracle ERP.
- Regularly, clear aged open items across all seven aging buckets.
- Manage month-end closing, resolve receivable account issues, and run automation in Oracle ERP.
- Complete daily cash application within TAT, send unapplied cash reports, analyze failed system entries using Oracle reports, and rectify errors.
- Resolve ServiceNow tickets within TAT, respond promptly to emails, and ensure proactive handling of future payment notifications
Education
Master of Business Administration (M.B.A) - Finance and Banking - Bharti Resources Learning Centre. (2010-05)
Bachelor of Commerce - Costing, Management & Corporates Accounting and Economic. - Rajarshi Shahu College Latur (2004-08 - 2007-06)
