Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
ARJUN PANDEY

ARJUN PANDEY

Delhi

Summary

To strive for excellence, continuous learning and seeking collateral growth for self as well as for my organization and to set high standards of professionalism & commitment to achieve the desired output for the organization while being resourceful, innovative and flexible

Overview

12
12
years of professional experience

Work History

Finance and Accounting

Jones lang Lasalle
11.2018 - Current

• Revenue Analysis for two products of JLL IPS Portfolio, basis on the yearly forecast and report the missing revenues to the stakeholders and business.

• Updating of Client Wise Actual numbers from GL to Revenue Trackers.

• Extracting JAR reports and providing revenue tracker according to the region.

• Directly review and coordinate with Business for client and IC invoicing and revenue recognition

• Preparation of Accruals & Re-class Journals.

• Prepare reconciliations for missing revenue and chase with counterparts.

• Reconciliation of accruals with actual billing on a monthly basis.

• Raising client invoices

• Preparing Invoice Tracker

• Preparing Revenue Tracker

• Preparing SOX

• Prepare IC fee share forms and agreements to ensure smooth revenue transfer within JLL.

• Upload Invoices on Client Portal

• Raising Contract and Project Id’s In PeopleSoft

Contract approval for India PDS

▪ Pull and check the report of Block orders from SAP.

▪ Releasing the block order for European and UK market.

▪ Processing orders.

▪ Unblocking the orders.

▪ Raise ISR( Internal Service Request) with Webform and without webform.

▪ Creating the customers for Direct Debit in SEPA( Single Euro

Payment Area) ▪ Taking care of Month-end and Year-end close for

Accounts receivable

Financial & Accounting

Genpact India
06.2013 - 08.2018
  • Responsible for providing program facilitation through planning, organizing, coordinating, and monitoring implementation activities
  • Assists with project management and working across multiple geographies and time zones
  • Facilitate communications between project teams, management and stakeholders
  • Creation of management reports for leadership teams
  • Defining and collecting project metrics including cost, time, quality, and risk
  • Part of transition, taking new business from Romania(Europe)
  • Raising invoices for client
  • Pull and check the report of Block orders from SAP
  • Releasing the block order for European and UK market
  • Processing orders
  • Unblocking the orders
  • Raise ISR( Internal Service Request) with Webform and without webform
  • Creating the customers for Direct Debit in SEPA( Single Euro Payment Area)
  • Taking care of Month-end and Year-end close for Accounts receivable
  • Analysis the aging items and do follow-up with customers
  • Apply the received payment against respective Invoices
  • Perform Manual Journal Entry and Stop pays
  • Handling Tickets Query
  • Employees to submit Department expenses through pre-defined billing file and that expenses will be charge back to the particular department
  • Extracting trending report and comparing allocated expenses with the current file generated from the BIS
  • Posting BI Book Entry and Sending all expenses to GL
  • Perform Variance analysis for each department cost center
  • Review and Analysis monthly allocation report
  • Managing rules, product and channel for allocation
  • Validating the allocation pre-checks and expense (Departmental and NonDepartmental)
  • Managing post allocation activities (Suspense clearing, preparing MJE and publishing report to client)
  • Lean trained and tested and certified (3Star) in Genpact
  • I have submitted 3 Lean ideas which are implemented in my process
  • Those Lean ideas reduced significant time and improved the Accuracy level of the process
  • LEAN certified, I have been appreciated and awarded for automating monthly reports from client
  • “INSURANCE BOOT CAMP” certified
  • Awarded as spot awards for customer appreciations and doing excellent job on Invoice audit
  • Behaviour and helping out other teams in work

Education

B.com -

Delhi Univercity

High School Diploma -

Commercial Sr Sec School
Delhi

MBA - Finance and Internation Business

Manglayatan Univercity
Delhi

Skills

  • Python
  • Knowledge of ERP and EPM tools of People soft
  • BIS (Business interface system) tool
  • Revenue analysis
  • Proficient knowledge of MS office package (Word, Excel, PowerPoint)
  • Hyperion report
  • Tally
  • SAP

Accomplishments

  • Voice of customer
  • Going Beyond from Controllership
  • Received client award
  • Received appreciation from Global lead

Timeline

Finance and Accounting

Jones lang Lasalle
11.2018 - Current

Financial & Accounting

Genpact India
06.2013 - 08.2018

B.com -

Delhi Univercity

High School Diploma -

Commercial Sr Sec School

MBA - Finance and Internation Business

Manglayatan Univercity
ARJUN PANDEY