Rounak Kumar Gupta, AVP finance projects

Rounak Kumar Gupta

AVP finance projects

Barclays Shared Services

Location
India - New Delhi
Education
Master's degree, Administration And Finance
Experience
18 years, 9 months

Share My Profile

Block User


Work Experience

Total years of experience :18 years, 9 months

AVP finance projects at Barclays Shared Services
  • India - Chennai
  • My current job since June 2019

Leading the Innovation Forum bringing in innovative change in the existing process by including automation using Advanced Excel(macros), Hypercube (SQL based programming), Alteryx, Power Query & Power Pivots.
Conducting routine meeting & brainstorming session with various Finance Control team to gather inputs around scope on automating processes and resolve DQ issues
Training /Coaching /Supporting teams to develop automation using Alteryx/Advance Excel/Power Query/Power Pivots
Providing Key metrics for the Management towards the Accelerated Close and Disclosure

AVP Ledger Control & Assurance at Royal Bank of Scotland
  • India - Gurgaon
  • May 2012 to June 2019

AVP- Financial Control at Royal Bank of Scotland
June'16 - June'19 (3 years)
 Delivery of IFRS9 Numbers to the Group & Financial / Legal Entity Controllers
 Monitoring the accelerated Ledger Close and mitigate any delays
 Ensuring that the key inputs are timely delivered and raise Risks & Issues
 Managing expectations from Credit Risk & aligning the Ledger to Credit Risk Reporting
 Monitoring the finance checks and Write off process (Wholesale)
 Ensuring the right first time input is received at Credit Committee for Finance Inputs
 Co-ordinating with various Financial Control team to ensure correct Ledger and
Management Reporting

Manager- Retail Financial Control at Royal Bank of Scotland
May'12 - June'16 (2 years 1 month)
• First Level Review of monthly P&L & Balance Sheet along with Other Reporting
• Responsibility for accuracy & Timeliness of monthly financial information
• Review and extensive analysis of the P&L, Reporting & Supplementary Data Packs
• Ensuring Substantiation & monitoring of Risks & Issues raised.
• Provide and support input into the end to end control and ownership of divisional and legal entity balance Sheets for the division supported.

Projects Undertaken :
o IFRS9 Remediation & Atlas Automation
o IFRS9 Implementation (Impairment Specific)
o Ledger Transformation Project
o Journal Elimination
o FINREP Implementations
o HFM Implementations

Assistant Manager -Finance Operations at Provana India Private Limited
  • India - Delhi
  • June 2011 to January 2012

To provide the client, assistance in closing the Month-end as well as provide sufficient data which help them in making decisions for managing the portfolio efficiently. The Team also provides operational support to deal with the Collections Agency and Law firms for the Client.

Finance Executive at HSBC Data Processing India Pvt Ltd
  • India - Delhi
  • March 2009 to May 2011

Designation: Project Manager

WORK PROFILE - Account Ownership Support - (Assure Net Project Implementation)
HSBC is implementing a certification tool (Trintech’s Assure Net) for signoff of the reconciled balances for its entire global business.
• Project Manager for implementation.
• Associated with the project implementation for the entire Asia Pacific Region & Middle East- Africa Sites.
• Involved in planning the roll outs in the different sites and/or countries
• Coordinating with the different Site Finance Team for the implementation of the application
• Getting the compliance documents signed off and ensuring the documentation for outsourcing is complete
• Ensuring that the MI Reports is sent to the country head & Regional head of reconciliation & SOX Compliance
• Setting up of a team in India which would provide the Helpdesk Support (Admin Support) for the different sites within Asia Pacific, America, Latin America and Europe
WORK PROFILE - Hyperion System Expert (Non Technical) till Dec’09
• Business administrator - Hyperion 9.1 & Hyperion 3.5
• Providing guidance to the Retrieve functions (Excel based function)
• Providing Classroom training to the users
• Consolidation, month/quarter adjustments, data load, data demotion, Percentage Consolidation (PCON), opening of period (process management), loading of exchange rates, closing of period (process management and locking), retrieve, process management, creation/ amendment/ deletion of users validation issues - advice to user, dispensation or escalation to change management, data entry form issues, communication of system availability/ performance issues, resetting of passwords, reports issues & 6 monthly security rights review
• Performance Awards- June 2009, Q2 2009 & Q2 2010

Financial Analyst at Hewitt Associates
  • India - Delhi
  • December 2007 to March 2009

Designation: Financial Analyst

WORK PROFILE
• Revenue Contract Analyst
• Subject Matter Expertise (SME) for the fee review of India Team
• Auditing the work done by the Client Financial Analyst (CFA)
• Ensuring that revenue recognition is per SOX compliance
• Contract and fees review
• Ongoing training & support to the peers and the new joiners
• Preparing & analyzing monthly variance reports such as Client Agreement System Revenue exceeding, Performance Pay Method Variance which is reported to the CFO
• Coordination and regular conversation with Project Managers & CFAs on topics that effect audit work
• Scheduling weekly team hurdles & preparing fee reports

Team Member at American Express Bank
  • India - Delhi
  • March 2007 to November 2007

Designation: Research Analyst

WORK PROFILE
• TCPS (Travelers Cheque and Prepaid services) Department
• Researching and reconciling the Inventory with the Selling Partners
• Processing the Sales for the Travellers Cheques
• Providing assistance to selling partners in case of any discrepancies.

Process Associate at Genpact
  • India - Delhi
  • August 2005 to March 2007

WORK PROFILE: Pfizer (August ’06-Mar 2007)
• Creating new items in Oracle.
• Validating the Cash Applied as well as the items created.
• Planning & Implementing Process improvements
• Dashboard preparation and Billing data reporting.
• Active participant in weekly call with the client.
• Providing training.
• HR Single Point of Contact(SPOC)
• Business Continuity Planning SPOC
• Achievement- Gold Award.








WORK PROFILE: GE Corporate Treasury (August ’05-August’ 06)
• Cash Accounting & Reconciliation for GE Corporate Treasury.
• Preparing Monthly and Quarterly Reconciliation Report
• Maintaining Inventory for the open Items
• Performing Research as to why the open items appeared
• Assuring the Reconciliation is done as per US GAAP & SOX.

Education

Master's degree, Administration And Finance
  • at Symbiosis
  • August 2012
Bachelor's degree, Financial Management
  • at Shaheed Bhagat Singh College
  • August 2005

Specialties & Skills

Financial Management
Management
Finance
operations
MS Excel

Languages

English
Expert

Training and Certifications

LEAN COMPETENCY AWARENESS (Certificate)
Date Attended:
May 2013
Scrum Basics (Training)
Training Institute:
LinkedIn
Date Attended:
July 2021
Duration:
3 hours