Summary
Overview
Work History
Education
Skills
References
PROFESSIONAL SYNOPSIS
PROFESSIONAL EXPERIENCE
Timeline
Generic

MAHENDRA KUMAR SASMAL

Bangalore

Summary

Financial professional with extensive experience at HP Inc., specializing in FP&A and lease accounting. Expertise in SAP and Power BI enables delivery of insightful reporting and strategic analysis. Proven ability to foster collaboration across teams, driving impactful financial decisions that enhance organizational performance.

Overview

19
19
years of professional experience

Work History

Program manager _FP&A, Lease Commercial

Hp Inc.
05.2024 - Current
  • Company Overview: (A Global leading Computer and software manufacturer Organization)
  • As a Program manager _FP&A, Lease Commercial

Advisor FP&A, R2R and indirect taxes, IFRS 16-Lease Accounting

RIO TINTO India Pvt. Ltd
11.2019 - 04.2024
  • Company Overview: (A Global leading mining Organization)
  • As a Advisor FP&A, R2R and indirect taxes, IFRS 16-Lease Accounting

Financial Analyst (Record to Report, Accounts Payable)

British Telecom
Gurgaon
05.2011 - 11.2019
  • Company Overview: (A Worldwide Telecom Service Provider Organization)
  • As a Financial Analyst (Record to Report, Accounts Payable)

Financial Analyst (Accounts Payable, Vendor Management)

EbusinessWare India Pvt Limited
Gurgaon
09.2006 - 05.2011
  • Company Overview: (A Worldwide industry in Consulting, Outsourcing and Human Resources)
  • As a Financial Analyst (Accounts Payable, Vendor Management)

Education

MBA - Finance & Marketing

Bachelors - Economics

Skills

  • Working knowledge of ERP system- SAP (FICO, FI-CA, RAR), Oracle Environment
  • Consolidation Tool- HFM
  • Reporting- Power BI
  • MS-Office (MS-Word, MS-Access, MS-Excel and MS-PowerPoint, MS Access)

References

Available on request

PROFESSIONAL SYNOPSIS

  • Over 18 years of experience in Finance planning & Analysis, Budgeting, forecasting, Variance analysis, R2R, Intercompany, Lease accounting, lease commercial, HFM reporting, month end close, General Ledger Group consolidation, Accounts Payable and Reconciliation (Bank, Intercompany, Balance sheet).
  • Successfully transitioned General Accounting process from Budapest, Hungary (Europe).
  • Successfully transitioned two General Accounting process remotely.
  • Working knowledge of SAP, Oracle, HFM, Reconciliation tool (Blackline and FCM) and Microsoft
  • Currently perform as process lead and manage a team of around 13 people.

PROFESSIONAL EXPERIENCE

  • JOB PROFILE AND CORE COMPETENCIES - HP INC
  • Financial Planning:
  • Developing and managing the annual budget, long-term strategic financial plans, and forecasting models.
  • Financial Analysis:
  • Analyzing financial data, including key performance indicators (KPIs), trends, and business drivers, to identify areas of strength and weakness.
  • Budgeting and Forecasting:
  • Collaborating with departments to create budgets and forecasts, monitoring performance against those plans, and identifying variances.
  • Performance Monitoring:
  • Tracking key performance indicators (KPIs) and providing regular reports to management on financial performance.
  • Variance Analysis:
  • Investigating variances between actual results and budgeted or forecasted figures, and identifying the root causes of those variances.
  • Reporting:
  • Preparing financial reports for internal stakeholders, including management and the board of directors.
  • Process Improvement:
  • Identifying opportunities to improve financial processes and systems to enhance efficiency and accuracy.
  • Collaboration:
  • Working with various departments, including sales, marketing, operations, and accounting, to gather information and ensure alignment on financial plans.
  • Compliance:
  • Ensuring compliance with financial policies, procedures, and regulations.
  • Lease Commercial
  • Deal Analysis: Identify critical elements influencing deal awards. Process Integration: Determine the entry point of the Global lease desk within the deal process.
  • Credit Approval: Manage requests for preliminary and formal credit approvals. Opportunity Submission: Utilize templates/tools/systems to submit opportunities to the Lease commercials, IRF (lease rate factor), leasing desk, including essential information such as customer legal name, HQ address, country scope, hardware opportunity details, quote, discounts, lease type, special conditions and more.
  • Lender Interaction: Act as the central point of contact for all lender-related requests and interactions.
  • Response Evaluation: Assess lender responses, including pricing, country coverage,And capabilities to support non-standard requests.
  • Deal Award: Summarize, justify, and communicate award decisions to lenders and relevant stakeholders.
  • Rate Card Management: Maintain and analyze quarterly rate cards, benchmarking across lenders, and monitoring rate changes.
  • Data Analysis: Analyze and report on rate changes, residual values, and award criteria.
  • Reporting: Identify trends and integrate data into the WWLF Power BI dashboard.
  • Pricing Support: Collaborate with the Renew Product Management Team on pricing-related activities.
  • Quarterly Business Reviews: Support Quarterly Business Reviews as required.
  • Negotiation: Note that the Lease Desk Analyst is not responsible for negotiating pricing; lenders are expected to provide Best and Final Offer (BAFO) pricing on submission.
  • JOB PROFILE AND CORE COMPETENCIES - RIO TINTO INDIA PVT LTD
  • SAP FI-CA
  • SAP FICA Functionality: Documents explaining the various functions and processes within SAP FICA, such as billing, payments, collections, and integration with other modules.
  • SAP FICA Tables: Documents listing and explaining the tables used in FICA for storing data.
  • SAP FICA T-Codes: Documents providing a list of transaction codes (T-Codes) used for accessing and managing FICA functionality.
  • SAP FICA Concepts: Documents explaining the core concepts and terminology used in SAP FICA
  • SAP RAR
  • Integration: Integrating SAP RAR with other SAP modules (e.g., FI, CO, SD, MM, PM) and external systems.
  • Compliance: Ensuring compliance with IFRS 15 (ASC 606) and other relevant accounting standards.
  • Analysis and Design: Analyzing business requirements, translating them into functional specifications, and designing solutions.
  • Documentation: Preparing documentation, including functional specifications, test plans, and user manuals.
  • Training: Providing training to users on SAP RAR functionality and processes.
  • Reporting: Building reports and analytics within SAP RAR to track revenue compliance and other key financial indicators.
  • Managing the Record to Report Process:
  • This involves overseeing the entire process from initial transaction recording to final financial reporting.
  • Financial Reporting: Preparing and analyzing financial statements (balance sheets, income statements, cash flow statements), ensuring accuracy and compliance with accounting standards.
  • Account Reconciliation: Reconciling general ledger accounts with subsidiary records and bank statements to identify and resolve discrepancies.
  • General Ledger Management: Maintaining and managing the general ledger, including recording journal entries and ensuring proper categorization of transactions.
  • Providing insights into financial performance through analysis of key metrics and trends.
  • Compliance: Ensuring adherence to accounting standards, internal policies, and regulatory requirements.
  • Process Improvement: Identifying and implementing process improvements to enhance efficiency, accuracy, and control within the R2R cycle.
  • Collaboration: Working with cross-functional teams (e.g., finance, accounting, operations) to ensure accurate and timely financial information.
  • Audit Support: Providing support during audits by ensuring proper documentation and explanations of financial transactions and balances.
  • Month-End and Year-End Close: Managing and participating in the month-end and year-end close processes.
  • JOB PROFILE AND CORE COMPETENCIES - British Telecom Limited
  • Record to Report, General Ledger & MIS Reporting
  • Pre-Month End activities: Checking AP & AR sub ledger close and processing Un-posted transactions from Sub-Ledger to General Ledger.
  • Month End Activities : Monthly processing of Journal entry review and posting for Cost, SG&A and Revenue for closing for various GFR’s (BT entities)
  • Consolidation: Perform group level consolidation activity and ensure all consolidation checks are performed from month end perspective. Doing Quarterly, half yearly, annual closing activities and perform group level consolidation.
  • IFRS 15 Revenue reporting
  • Reconciliations: Monthly reconciliation for various assets and liabilities for my entities. Preparing Intercompany reconciliations and report out IC mismatches.
  • Variance Analysis: Preparing Monthly and quarterly variance report.
  • Adhoc Activities: Working on analysis for Open Items, participation in internal control and SOX Compliance/audit.
  • As Reviewer: Working as first level approver for recons prepared by various team members before submission for second level/final approval.
  • Quarterly Activities: Deep dive analysis for Trade debtors, Prepayments and reporting to Stakeholders with commentaries and backups for Top 10.
  • Compliance Work (SOX): JV review for upload and post ID, backups and approvals. Validation check for IC entries.
  • MIS: Accrued revenue report after AR sub-ledger close. AR aging compilation, Expense-Revenue trending report to analyze over/under accruals.
  • Prepare VAT & WHT pack.
  • Deep Dive & Open Items reporting: as a part of MIS reporting publish Deep Dive Schedule and Open items Tracker.
  • Intercompany Reporting
  • Booking Cost and Revenue as per Company Guidelines in Titan Application and ERP/Oracle.
  • Preparation and Processing of Charges into GTH (Global Trading Hub) portal.
  • Booking Journals of Fiscal, Settlement, Re-Valuation (Forex), Treasury Interest in ERP/Oracle on monthly basis.
  • Raising formal Dispute for Incorrect and Inappropriate Transferred Cost to respective Entities and getting it resolved. Clearing and Maintaining of Suspense Account.
  • Debtors & Creditors and Treasury Reconciliations preparation and submission to In-Country Stakeholders on monthly basis.
  • Handling Stakeholders queries and substantiating the Costs and Revenues.
  • Ensuring customer is supplied with adequate and accurate financial information on a timely basis.
  • Ensure work is performed according to Group Accounting Policies and meeting with SOX requirements.
  • Handling of Internal and External Audits.
  • Managing efficient relationship with In-Country stakeholder and internal BT departments like AP, AR, RPA, and Local Finance Teams.
  • Ensure process documentation remains up to date.
  • Providing Process Training to new and current Resources and filling the knowledge gap within the Team also.
  • Reporting, Planning & Analysis
  • Reporting, planning & forecasting for different Line of Business.
  • Handled robust financial management for BT’s major IT contracts in Australia, Singapore, SSA and MENA.
  • Preparation and presentation of the contract financials, monthly rolling forecast and budgets in line with company policies and ensuring adherence to applicable IFRS.
  • Business partnering with contract/business managers to manage finance on the contracts in an effective and efficient manner.
  • Monthly intercompany transfers to ensure the entities involved with the contract are balanced and able to recover cost in an efficient manner.
  • Identified and provided accurate, timely and fit for purpose financial insight for all aspects of a contract financial performance (specifically revenue, margin, labour charges, intercompany accounting, capital expenditure and working capital).
  • Presentation of monthly contract scorecards to Senior Management
  • Maintained balance sheet integrity at all times to adhere SOX compliance and identified major financial risk and opportunities.
  • Hyperion HFM reporting for revenue and P&L flash and providing variance commentary.
  • Finalization of Budget & Quarterly forecast of the products on the basis of available budgets, future commitments and past trends in line with discussion from respective SBDs
  • Provide balance sheet commentary for various units on Monthly, quarterly, half yearly & annually variance analysis.
  • Presenting Flash results month over month.
  • Preparation of quarterly score cards for products along with Gross margin analysis
  • Consolidation of actual & forecast of current fiscal year for submission to group finance team & discussion with HQ team for analysis of unusual KPI & Variances
  • Presenting LOB wise P & L Month over Month and do variance analysis.
  • To do Trend analysis month over month & provide commentary
  • Achievements and value additions to process activity:
  • Successful transition of GL process from Budapest (Europe) to Gurgaon.
  • Transferred the knowledge & conducted the training sessions among the team members and resolving their issues to improve the process.
  • Stabilize the process in terms of knowledge and information within the agreed timeframe.
  • Bridge the knowledge gap among the team members and educate them about the exception of the process and this helped us to reduce overall error percentage rate of the process.
  • JOB PROFILE - Ebusinessware India Pvt Ltd
  • Accounts Payable
  • Reporting on SLAs, TATs, Quality Scores etc.
  • Monthly preparation of Aged Credit Report on WD 3 in order to check the balance of supplier’s amount outstanding on books.
  • Aging report of Invoices which are pending/on-hold/queried in our process.
  • Booking of Invoices & ensuring payments accuracy to vendors within period and interact with Treasury team for payment execution. Investigating with regard to Unidentified Payments.
  • Reconciling vendor statements on monthly and quarterly basis and monitoring Top 25 vendor accounts for prompt payment.
  • Monitor transactions on an ongoing basis and take corrective steps where necessary or make incremental improvements.
  • Update the accounting dashboard weekly and publish the status of various processes to customer & keep track of backlog items, assess reasons for backlog
  • Build strong partnership with customers and anticipate customer requirements and deliver accordingly
  • Effectively manage research/resolution/follow-ups for closure of open items
  • Working on P.O. based and non P.O. based invoices
  • Maintain data integrity as the process involves sensitive information like credit card numbers, social security numbers of customers
  • Reconciliation of credit card sales report and Bank settlement report and if there is any variance, analyzing the reason for the variance and report it to the Treasury department.
  • Regular Interaction with client and customers
  • Handling Client Escalations.
  • Yearly, Half yearly, Quarterly and Month end closing
  • Conducting Process training for new recruits and cross training of team members.
  • Preparation of Learning Paths for new recruits
  • Identify, facilitate and implement process improvement ideas to improve efficiency.
  • Quality Management
  • Maintaining & ensuring stringent adherence to quality standards, identifying gaps and opportunities.
  • Setting out quality standards for various operational areas, ensuring a high-quality customer experience while adhering to the SLAs and work processes.
  • Client Relationship Management
  • Managing service operations for rendering and achieving quality services; providing customer support by answering queries & resolving their issues, ensuring minimum TAT.
  • Assessing the customer feedback, evaluating areas of improvements & providing critical feedback to the associates on improvements and achieving higher customer satisfaction metrics

Timeline

Program manager _FP&A, Lease Commercial

Hp Inc.
05.2024 - Current

Advisor FP&A, R2R and indirect taxes, IFRS 16-Lease Accounting

RIO TINTO India Pvt. Ltd
11.2019 - 04.2024

Financial Analyst (Record to Report, Accounts Payable)

British Telecom
05.2011 - 11.2019

Financial Analyst (Accounts Payable, Vendor Management)

EbusinessWare India Pvt Limited
09.2006 - 05.2011

MBA - Finance & Marketing

Bachelors - Economics

MAHENDRA KUMAR SASMAL