Madan Koti MM
Business Planning And Analysis Specialist
Bangalore
Summary
Dynamic finance professional with over 10 years of experience in Business Planning & Analysis and General Ledger management, dedicated to leveraging extensive knowledge and skills for organizational growth. Proven track record in enhancing financial forecasting accuracy and streamlining month-end close processes while translating complex financial data into actionable insights for senior management. Expertise in SAP, Hyperion, and advanced Excel modeling drives strategic decision-making within a collaborative team environment. Eager to contribute to an esteemed organization that values innovation and continuous improvement.
Overview
1
1
Language
11
11
years of professional experience
Work History
Senior Financial Analyst
Teva Pharmaceuticals
07.2021 - Current
- Managed AOP planning and executed monthly roll-forward analysis, supporting accurate QBU presentations for senior management.
- Collaborated with finance to reconcile headcount data, improving the accuracy of company budget tracking.
- Managed the monthly absorption reporting process by collecting and validating data from source systems before submission into Oracle.
- Oversaw the monthly absorption tracking process, ensuring accurate data collection from business units.
- Ingested and validated goods receipt data in Hyperion Planning/Essbase, reducing the monthly closing cycle time by two days.
- Timely review of laboratory expenses to ensure numbers remain within minimal margin expectations.
- Validated freight charges by reconciling invoices against contracts to prevent overcharging.
- Develop an effective presentation deck by outlining a clear narrative and emphasizing one key takeaway per slide, using a simple, consistent design.
- Monitoring monthly and year-to-date sales reports on a monthly basis.
- Streamlined month-end revaluation reviews while reducing negative PPV through rigorous supplier analysis.
- Analyzed and synthesized write-off justifications collected from commercial teams to provide senior leadership with clear visibility into revenue leakage.
Senior Accounts Executive
Cargill Business Services
12.2019 - 05.2021
- Prepared and executed complex month-end journal entries, including accruals, reclassifications, and prepayments, ensuring strict alignment with matching principles and GAAP/IFRS standards.
- Conducted comprehensive month-over-month (MoM) financial statement reviews, identifying budget variances, anomalies, and operational trends to deliver actionable insights to senior leadership.
- Spearheaded comprehensive management account reviews, cross-referencing sub-ledgers against corporate targets to evaluate business performance and margins.
- Reviewed and prepared intricate monthly payroll reconciliations, validating total earnings, deductions, and tax withholdings against general ledger entries to ensure flawless compliance.
- Calculated precise, multi-tier royalty distributions, and systematically uploaded financial data sets into SAP BPC applications to automate stakeholder payouts.
- Oversaw balance sheet reconciliation workflows, enforcing best practices to eliminate open items, minimize aged variances, and mitigate financial reporting risks.
- Oversaw balance sheet reconciliation workflows, enforcing best practices to eliminate open items, minimize aged variances, and mitigate financial reporting risks.
Senior Accounts Executive
Tesco
12.2015 - 12.2019
- Executed high-volume payroll balance sheets and intercompany reconciliations, with careful sub-ledger to general ledger (GL) reconciliation, to maintain zero variance.
- Delivered month-end reporting cycles and confirmed strict general ledger accuracy, resulting in financial statements produced within tight corporate deadlines.
- Prepared, confirmed, and posted complex FX gain/loss journals to maintain accurate accounting treatment for multi-currency intercompany trade.
- Managed targeted recovery strategies for aging debt greater than 90 days past due, securing payments within stipulated timelines to strengthen liquid cash flow.
- Evaluated daily cash inflow and outflow variances by reconciling internal cash reports against third-party bank data to strengthen treasury visibility.
- Managed the end-to-end intercompany cycle, including raising outbound invoices, processing incoming counterparty billing, and executing clean net settlements.
- Owned the resolution of cross-border counterparty disputes and ad hoc queries, providing rapid, data-backed solutions to prevent ledger bottlenecks.
- Acted as a primary liaison for internal and external auditors, supplying comprehensive schedules and walk-throughs to ensure seamless compliance sign-offs.
- Facilitated periodic control summary discussions with stakeholders, presenting critical operational issues, risk assessments, and remediation plans.
- Identified structural accounting issues and workflow gaps, proactively proposing and implementing long-term process fixes.
Education
Accounting And Finance
Institute of Cost Accountants of India
04.2001 -
Skills
Financial budgeting
Variance analysis
Standard operating procedure development
Reporting and analysis skills
Financial reporting analysis
Process automation expertise
Effective stakeholder engagement
Power BI expertise
SAP proficiency
Proficient in Qlik Sense
Accomplishments
- Silver Award for smooth Mexico and EMSO transition
- Silver Award for Process Improvement
- Team Award for overall Performance
Interests
Hobbies: Chess, Cricket, Carrom
Declaration
I hereby declare that the Information given above is true to the best of my knowledge. Date: Place: Bengaluru (Madan koti MM )
Timeline
Senior Financial Analyst
Teva Pharmaceuticals
07.2021 - Current
Senior Accounts Executive
Cargill Business Services
12.2019 - 05.2021
Senior Accounts Executive
Tesco
12.2015 - 12.2019
Accounting And Finance
Institute of Cost Accountants of India
04.2001 -