Summary
Overview
Work History
Education
Skills
Languages
Personal Information
Certification
Accomplishments
Timeline
Generic

Dipanshu Rawat

Indirapuram

Summary

Detail-oriented and proactive Senior Associate with extensive experience in GRIR (Goods Receipt/Invoice Receipt) Reconciliation at Rio Tinto. Proven track record in managing and resolving discrepancies and collaborating effectively with cross-functional teams. Previously worked as an Associate at HCL Technologies, where I honed my skills in financial operations and vendor communication. Recognized for exceptional performance with multiple awards, including the 3-C Award and Spot Awards.Seeking to leverage my expertise in a challenging role to contribute to organizational success.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Senior Associate – Reconciliation

Rio Tinto LTD
Gurugram
10.2024 - Current
  • Reconciling goods receipt and invoice receipt entries.
  • Investigating and resolving discrepancies between purchase orders, goods receipts, and invoices.
  • Collaborating with procurement, finance, and other departments to ensure accurate financial reporting.
  • Maintained daily dashboards to track key performance indicators (KPIs), and provide actionable insights for management.
  • Performed monthly account reconciliations using Blackline for particular G.L.s.
  • Communicated with vendors to address and rectify mismatches in data, ensuring accurate and timely invoice processing.
  • Provided clear and concise explanations to vendors regarding the nature of discrepancies and required corrective actions.

Associate – Finance & Accounting

HCL Technologies LTD
NOIDA
12.2020 - 10.2023
  • Verification of Invoices, processing of Invoices through SAP
  • Handling LAC countries Invoice processing
  • Processed, reclassed, verified and reconciled invoices using different T-codes and raise queries for wherever needed like variance maximum quantity hold, price variance etc
  • Processing prepaid expense invoices and passing adjustment entry at the month end closing
  • Collecting accrual data at the month end and passing accrual journal entry using T-code
  • Handling of Generic Mailbox and addressing the client’s queries
  • Helping the audit team in providing the details for their smooth flow of work
  • Using T-codes in day-to-day processing like FB60, F-43, MIR7, FBL1N, XK03 etc
  • Resolve process and Invoice related queries over the client call
  • Maintaining master file of cost centre and general ledger
  • Prepare weekly report like Open items, Vendor Reconciliation
  • Preparing weekly payment file using
  • Doing weekly Bank upload, unitary transfer, wire transfer
  • Doing Reclassification journal entry in T-code FB05
  • Doing Bank posting and Advance Bank posting in T-code F-53 & f-48
  • Prepare daily and weekly reporting like allocation, Workflow, Productivity report etc
  • Sending mails to the client for approval of payments made through bank portal and clearing the posted items
  • Have experience in creating dashboard using pivot table tool, sorting data using advance excel function like Vlookup,Hlookup,Index Match etc
  • Used VBA coding extensively for clearing, sorting invoice data which saved time in weekly routine work

Education

B.com (H) -

PGDAV College (DU)
04-2018

12th Class -

ST. Teresa School
Indirapuram, GZB
04-2015

10th Class -

ST. Teresa School
Indirapuram, GZB
04-2013

Skills

  • Advanced Excel
  • ERP – SAP
  • ERP – Exacto
  • Data analytics

Languages

  • Hindi
  • English

Personal Information

Date of Birth: 09/07/97

Certification

  • Received joint certification from NSE Academy and IMS Proschool in Financial Modelling.

Accomplishments

  • Recipient of the 3-C Award at Rio Tinto for demonstrating exceptional performance and contribution to organizational Goals.
  • Received Spot Award twice at Rio Tinto.

Timeline

Senior Associate – Reconciliation

Rio Tinto LTD
10.2024 - Current

Associate – Finance & Accounting

HCL Technologies LTD
12.2020 - 10.2023

B.com (H) -

PGDAV College (DU)

12th Class -

ST. Teresa School

10th Class -

ST. Teresa School

Similar Profiles

CREATE PROFILE
Dipanshu Rawat