Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Robin John

Bangalore

Summary

Results-driven Project Management Advisor with IBM India Ltd, excelling in financial forecasting and contract reconciliation. Achieved over 95% forecast accuracy while managing 200+ proposals. Proficient in invoicing and financial reporting, complemented by strong collaboration skills. Proven track record in enhancing profitability and ensuring compliance across multiple projects.

Overview

17
17
years of professional experience

Work History

Project Management Advisor (Port of Rotterdam)

IBM INDIA LTD
03.2024 - Current
  • Raising the request for contract registration in iERP: Once the contract is signed, I raise a request in ORM to register the contract and create a new WBS (Work Breakdown Structure) for resource hour claims in the project.
  • Invoicing: Raising the invoice request in the Intelligent Workflow tool for monthly invoices and ad hoc requests received from the PM.
  • Raising customer PO request: Submitting PO request in the Ariba tool and follow-up with the procurement team for PO approval.
  • Assigning for e-signing the contract: Assigning the final version of the statement of work to the customer and the IBM account partner.
  • Handling payment queries and disputes: Collaborating with the procurement team to check the payment status of external invoices, and addressing the PM’s payment queries.

Project Management Advisor (IKEA)

IBM INDIA LTD
Bengaluru
03.2021 - Current
  • Forecasting: Collect project plan data from the project manager. Based on this input, I work on the financial forecast for both current and future months. Afterward, I review the forecast with the account Project Executive, before submitting the forecast in the system.
  • Consistently achieving 95%+ forecast accuracy across multiple projects.
  • Assigning a new proposal request number, reviewing, and approving: assigning a new RFS number to the project manager. Once the proposal is ready with all the necessary approvals, the PM will assign it for the review. I will review the deal approval, Statement of Work (SOW), and financial documents, and approve them. Afterward, the proposal is sent for project executive approval. Once approved, the SOW is sent to IKEA for their review and signing.
  • I have reviewed over 200 proposals over time.
  • Raising the request for contract registration in ORM: Once the contract is signed, I raise a request in the Order Management Tool to register the contract and create a new WBS (Work Breakdown Structure) for resource hour claims in the project.
  • Maintaining the cost management tracker: Based on the claim report, I update the claimed hours for the project, validating the hours and cost details with the project manager.
  • Labor cost rate analysis: I extract the labor claim report from the IPPF tool and update the latest resource cost rate in the tracker. I compare this with previous months to identify any variance in labor costs.
  • Reporting claimed hours data: Every week, I extract the claimed hours data and send it to project managers, delivery leads, and partners for their review. This report is used for various purposes.
  • WBS backlog clearing: I extract the financial backlog report, obtain approval from the Project Manager, and work with the project support team to write off the backlog for WBS entries that have passed their end date.
  • Financial Reporting: I work on various financial reports, such as Actual Vs Forecast (based on the claim report). Preparing and presenting the financial actual report to management. Claimed hours analysis report for invoicing. Sharing the WBS-wise GP (Gross Profit) percentage report with delivery leads and PMs to understand the current GP status. Based on this, PMs can manage project resources.
  • Supporting During Account Audits: I provide the required evidence to the data security and privacy consultant during the audit. I have received appreciation and cash awards from the IKEA account leadership team for presenting the process to the auditor.

Contract Management Specialist

IBM INDIA LTD
12.2014 - 02.2021
  • As a contract management specialist, I manage contracts to maximize the performance in line with contract requirements and ensure compliance with the terms and conditions of the contract.
  • Contract reconciliation: Analyzing the actual vs. planned gross profit of the contract and advising on appropriate actions and strategies to address contractual GP shortfalls. Additionally, ensuring that revenue is generated in a timely manner.
  • Project Tracker: The sector finance team will provide the monthly forecast details. Based on this, we will work with project managers to ensure revenue generation aligns with forecasts and will review the forecast when presenting it to stakeholders.
  • Contract Audit: Conducting contract audits to verify whether revenue is being generated as per the agreement signed with customers, and whether gross profit is in line with the plan.
  • Contract termination: Upon receiving a customer’s termination request, we verify the documents and obtain the necessary approvals to terminate the project.
  • Financial Reports: Responsible for handling the Financial Reports for stakeholder.
  • Revenue Management: Driving the revenue of the contracts which is either nearing the milestone of work or nearing the completion of work.
  • Contract Progress Reports: Responsible for handling various reports to track the progress of the contract assigned to team members.
  • Collaboration: Working with the Project Managers, Financial Analyst, sales team and Technicians to resolve the discrepancies related to the contracts.
  • Contract GP Report: Responsible for preparing the Contract Gross Profit report to assist Project Managers and Finance Controllers in evaluating the financial performance of contracts.

Senior Finance Executive

Mahindra Holidays and Resorts India Ltd
Bangalore
06.2008 - 09.2014
  • As a senior finance executive, I was mainly handling accounts receivables, accounts payable, bank reconciliation, day today cash transactions and many more as mentioned below.
  • Processing vendor payment, franchise commission, salary and incentive for off roll employees.
  • Handling day to day cash transactions of the branch and reporting to the corporate office daily.
  • Preparing the monthly bank reconciliation statement.
  • Analyzing budget Vs actuals and presenting the report to zonal manager.
  • Calculating commission and incentive for the credit management, sales and marketing department and providing the data to HR.
  • Conducting periodic review of general ledger accounts to ensure compliance.
  • Handling monthly provision entries and assisting the manager for month end book closing.
  • Preparing presentations for management to review the sales performance.
  • Interacting with the bank regarding vendors payment related queries and issues.
  • Resolving customers payment related queries and issues assigned by the corporate and branch customer relations team and management.

Education

MBA - Finance & Marketing

Nehru School of Management Calicut University
Thrissur, Kerala
01.2007

B.com -

NSS College
Kottayam, Kerala
01.2005

Skills

  • Financial forecasting
  • Contract reconciliation
  • Contract proposal review
  • Contract auditing
  • Invoicing
  • Financial reporting
  • Variance Analysis
  • Profitability analysis
  • Project tracker
  • Accounts receivable and payable
  • Cash management

Accomplishments

Achieved $1,000 in monthly savings on request for service (RFS) tool maintenance costs for the project in 2023 by using IBM Box for storing documents, and streamlining the approval process for contract proposals

Timeline

Project Management Advisor (Port of Rotterdam)

IBM INDIA LTD
03.2024 - Current

Project Management Advisor (IKEA)

IBM INDIA LTD
03.2021 - Current

Contract Management Specialist

IBM INDIA LTD
12.2014 - 02.2021

Senior Finance Executive

Mahindra Holidays and Resorts India Ltd
06.2008 - 09.2014

MBA - Finance & Marketing

Nehru School of Management Calicut University

B.com -

NSS College

Similar Profiles

CREATE PROFILE
Robin John