Summary
Overview
Work History
Education
Skills
Personal Information
Languages
Process Improvement
Erp Systems And Software Skills
Timeline
Generic
BIPLAB KUMAR SARKHEL

BIPLAB KUMAR SARKHEL

Bangalore

Summary

Demonstrated track record of delivering excellence in budgeting, forecasting, variance analysis, month-end close, and financial reporting. Skilled in utilizing ERP systems and data visualization tools to support strategic decision-making and drive business insights. Committed to meeting deadlines and achieving organizational goals.

Overview

8
8
years of professional experience

Work History

Accountant (Financial Analyst) FP&A

Caterpillar India Pvt. Ltd.
Bangalore
07.2024 - Current
  • Variance analysis Forecast Vs Actual.
  • Headcount Reporting
  • Rolling Budget Model( RBM) preparing in Quarterly Basis.
  • Conducting in depth financial analysis, including variance analysis, trend analysis using power query
  • Developed a predictive analytics model using Python to analyze Seasonality trends (Agency, Labor, Headcount etc).
  • Revenue Recognition as per ASC-606 ( Time & materials, Deferred Revenue & Fixed pay)
  • Developed and maintained business intelligence dashboards using Power BI, providing real-time insights that improved business performance.
  • Provide a commentary for the variances & same will be discussing in call with Stakeholders
  • Preparing new job code &WBS element for charging the expenses.
  • Setup a monthly call with stakeholders after the close to discuss about the variances compare to ABP & RBM.

Accounting Specialist

Honeywell Pvt. Ltd.
Bangalore
03.2022 - 07.2024
  • Conducted contract reviews and revenue recognition checklists based on IFRS15
  • Prepare and present comprehensive financial reports to senior management and stakeholders.
  • Preparing & presenting monthly financial results, updated revenue plans & forecast assumptions to the senior executive leadership.
  • Vigilantly monitored variances between actual & forecasted.
  • Executed Comprehensive revenue accounting
  • Performed detailed financial analysis supporting investment decisions, leading to the selection of high ROI project.
  • Conducted quarterly variance analysis, identify potential cost savings by restructuring vendor agreements using negotiation best practices.
  • Utilized scenario planning techniques to forecast financial outcomes, directly contributing to a 20% improvement in strategic investment decisions.

General Accounting Ops Analyst

Accenture Services Pvt. Ltd.
Bangalore
09.2017 - 12.2021
  • Balance sheet Review (Flux Analysis). Calculation of Jubilee Bonus, Untaken Holidays accruals, In house bonus yearly activities, Re- class from cost center split.
  • Revaluation report, MRO, Auto Accrual (ARO), purchase order (PO) run and understanding the movement of the balances.
  • The only SPOC for all the UK activities that are being delivered across all the regions. Successful completion of remote transition from Warsaw & Chester to Bangalore Location.
  • Working on month end sub ledger books close and Material ledger (ML run). Preparation of Cash flow statement on monthly basis.
  • Preparation and reviewing Control Checks- Sales/General pre-load checks & post-load checks, Assessment & Revaluation program.
  • Preparation/Reviewing of cash and Bank Reconciliation also understanding the action Items in Reconciliation. Calculation of Sales forces bonus and monthly reconciliation of the same.
  • Verification the monthly Bank entries which is posted or not, if not identified the entries and post it in SAP after the approval from market.
  • Preparing Quarterly report analysis for Audit query. Connecting with controllers and market for weekly updates.
  • Reviewing and processing the request for - GL/CC extension, block or unblock GL/CC. TB review & confirm to controllers before closing the books.

Education

Master of Commerce -

IGNOU
01.2016

CMA (Inter) -

The Institute of Cost Accountants of India (ICWAI)
01.2012

Bachelor of commerce (H) -

Ranchi University
01.2010

Skills

  • Financial Analysis & Reporting
  • Budgeting & Forecasting
  • Process Optimization & SOP Documentation
  • Variance analysis
  • Record to Report
  • Financial Planning
  • RBM (Rolling Budget Model)
  • MS Office
  • Power BI
  • Python
  • SAP S4 Hana
  • HFM
  • SAP EDW
  • Citrix
  • IRIS
  • Blackline

Personal Information

  • Gender: Male
  • Marital Status: Married

Languages

  • English
  • Hindi

Process Improvement

  • Reduced working time on a Services charges report by macro ideas resulting in simplifying the process which saved almost 9 hours to prepare and publish the report.
  • Automated the financial reporting process using advanced Excel power Query and Power BI, saving 1 hours per week in manual data entry and improving report dissemination speed.

Erp Systems And Software Skills

  • MS Office
  • Power BI
  • Python
  • SAP S4 Hana
  • HFM
  • SAP EDW
  • Citrix
  • IRIS
  • Blackline

Timeline

Accountant (Financial Analyst) FP&A

Caterpillar India Pvt. Ltd.
07.2024 - Current

Accounting Specialist

Honeywell Pvt. Ltd.
03.2022 - 07.2024

General Accounting Ops Analyst

Accenture Services Pvt. Ltd.
09.2017 - 12.2021

Master of Commerce -

IGNOU

CMA (Inter) -

The Institute of Cost Accountants of India (ICWAI)

Bachelor of commerce (H) -

Ranchi University

Similar Profiles

CREATE PROFILE
BIPLAB KUMAR SARKHEL