RANJAN GUPTA

Valid Indian Passport

Mob No :+91-9910306344

Email ID:

DOB: 05th January 1984

PROFILE SUMMARY

  • 11.1 years of experience working with top brands like RBS, AonHewitt, TCS and Bank of America.
  • Comprehensive experience in leading projects related to process improvement and efficiency gain.
  • Proactive & self driven with hands on process expertise in Reconciliation

ORgANISATIONAL Experience

rbs services india private limited, GURgAON march 2013 till DATE

Designation: senior analyst ii financial control

Reporting line:- associate vice president

About Company: The RBS Group is a large international banking and financial services company. From its headquarters in Edinburgh, the Group serves over 30 million customers in the United Kingdom, Europe, the Middle East, the Americas and Asia. We have been in India since 1921.

RESPONSIBILITIES

  • Working in Lombard month end accounting team. This team looks after the asset finance business of lombard.
  • Working closely with balance sheet verification team for daily payments and receipts coming in bank accounts.
  • Working closely with reconciliation and investigation shared services team (RISS) to clear open items in each bank account as per inputs received.
  • Working closely with stakeholders of lombard.
  • Working closely with system and ledger control team for daily ledger files and also for opening new general ledger account in oracle.
  • Posting journals in oracle as per inputs received by reconciliation and investigation shared services team.
  • Ensure all treasury journals are posted in each bank account on a bi-weekly basis.
  • Balance matching of treasury file on work day three to reconcile the balance between treasury statement and ledger.
  • Ensuring all oracle journals are posted by work day two if not the same needs to be posted in hyperion on work day three.
  • Perform oracle and hyperion journals check control task to know the no of journals posted by the entire team.
  • Adhernce to SOX controls.
  • Timely submission of supplementary data packs in hyperion financial management as per statutory requirements.
  • Doing variance analysis of general ledger account from previous month if query received from business intelligence team.
  • Resolve any escalated issues related to general ledger reconciliations in line with requirements and on a timely basis.
  • Timely submission of supplementary data packs in hyperion financial management as per statutory requirements.
  • Timely delivery of audit work to auditors. Preparation of audit and liaise with E&Y auditors for the samples selected.

PROJECTS

  • Migrated bankrec reconciliation application to Intellimatch reconciliation application.
  • IFRS9

ACHIEVEMENTS

  • Won appreciation from leadership team for completing 5 years of excellent service.
  • Successful migration of bankrec application to Intellimatch reconciliation application.

aonhewitt, GURgAON june 2011---march 2013

Designation: team developer (Finance)

Reporting Line:- operations manager

About Company:- Aon Hewitt (formerly known as Hewitt Associates) is a provider of human capital and management consulting services headquartered in the United States in Lincolnshire, Illinois. From 500 offices in 120 countries, it provides consulting, outsourcing, and reinsurance brokerage services.The company was founded in 1940 and ceased to exist as an independent entity at the completion of its purchase by Aon in October 2010. Hewitt's operations were merged at that time with some elements of Aon's consulting arm to become a new subsidiary of the Aon Group called Aon Hewitt.

RESPONSIBILITIES

  • Support the Consulting business performing a variety of interactions and work; Review consulting contracts and work with the business to ensure that revenue recognition and billing occur correctly.
  • Set-up contract as per the SOX evidence received and within the defined SLA and change the status of contract for audit from revenue quality manager.
  • Bill revenue which is lying in our old system i.e. 8.4 as per project manager inputs.
  • Billing, invoicing and revenue recognition..
  • Coordinating with business partners and resolving day to day queries, Also handled the team members in absence of reporting line manager and able to achieve successfully the expectation of senior management.
  • Book accruals if revenue is received after the cut-off date. Ensure accurate recording of revenue against each client contract in according to the company’s revenue recognition policies.
  • Prepare invoices and bill clients after approval by project managers on monthly/quarterly basis as per contract terms. Reconciliation of manual invoices prepared in peoplesoft 9.0

TCS ESERVE INTERNATIONAL LIMITED, GURGAON JUNE 2008-JUNE 2011

DESIGNATION : SENIOR PROCESS ASSOCIATE

REPORTING LINE: TEAM LEADER

ABOUT COMPANY: Worked with CitiGroup Global Services Ltd. (CGSL) which was taken over by Tata Consultancy Services (TCS) as a Senior Process Associate for Finance & Accounting (Reconciliation) Process. TCS eServe is one of the largest providers of business processing outsourcing services within the Banking and Financial Services sector, providing end-to-end process management across the BFSI spectrum and a broad array of services to Citi’s consumer, corporate and global wealth orporate and global wealth management businesses world wide. TCS eServe has more than 14,000 employees located in India.

RESPONSIBILITIES

  • Reconciliation of US depository accounts of CitiFinancial branches as per US GAAP.
  • Reconciliation of Cash between book side and bank side.
  • Clear open items for CitiFinancial branches accurately and timely.
  • Request all class changes of items which have wrongly uploaded by financial systems team.
  • Resolve all missing departments for write-offs.
  • Identify and resolve pools that are out of balance.
  • Reporting of possible internal and external frauds to compliance.
  • Maintaining MIS for all aging items and call logs.
  • Passing journal entries in peoplesoft if offset is identified in Citifinancial general ledger.
  • Providing explanation to SME for the write offs to be done in a particular month.
  • Providing the SME with the details of ageing for depository account handled on a weekly basis.

Achievements

  • Received Galaxy of thanks from the line of business.
  • Won the Star of the Month award in Dec 2010.
  • Received a Zero Defect award in Apr 2010.
  • Won appreciation from leadership team for completing 3 years of excellent service.

BA CONTINUUM SOLUTIONS PVT LTD, GURGAON FEB 2007-JUNE 2008

DESIGNATION : TEAM MEMBER

REPORTING LINE: TEAM LEADER

ABOUT COMPANY:BA Continuum is a nonbank subsidiary of Bank of America, part of our Global Delivery Center of Expertise in the bank. Our employees help our customers and clients at every stage of their financial lives, helping them connect to what matters most. This purpose defines and unites us. Every day, we are focused on delivering value, convenience, expertise and innovation for the individuals, businesses and institutional investors we serve worldwide.

BA Continuum India Pvt. Ltd., supports business process, information technology and knowledge process across Consumer Banking, including Card and Home Loans, Legacy Asset Servicing, Global Banking and Markets, and Global Wealth and Investment Management lines of business at Bank of America.

RESPONSIBILITIES

  • As a research associate was responsible for booking losses on overdrawn customer accounts.
  • Identified primary causes for the losses on overdrawn accounts and assigned appropriate loss codes providing inputs to Bank of America to change policies related to banking centre and cost centre operations.
  • Processed all accounts within turnaround times and generated daily MIS on the accounts processed.

EDUCATION

DEGREE / YEAR / SCHOOL/COLLEGE / BOARD/UNIVERSITY / SPECILIZATION
MASTER OF BUSINESS ECONOMICS / 2008 / New Delhi Institute of Management, New Delhi / Guru Nanak Dev University, Amritsar / Econometrics and Finance
B.Com (Honours) / 2004 / St Xavier’s College, Ranchi / Ranchi University, Ranchi / Accountancy
XIIth / 2001 / DAV Public School, Sawang / C.B.S.E / Commerce
Xth / 1999 / DAV Public School, Sawang / C.B.S.E / NA

PERSONAL PARTICULARS

MARITAL STATUS: Unmarried

LANGUAGES KNOWN: English, Hindi, Bengali

INTEREST & HOBBIES: Listening to music , Travelling, Shopping, Cooking

REFERENCES : Available on request

ADDRESS :Arihant Arden Plot No GH07A Tower A Flat No 1603 Bisrakh Road Sector 1 Noida ExtensionUttar Pradesh India Zip code 201301

PLACE:

DATE :