Rounak Kumar Gupta, AVP finance projects

Rounak Kumar Gupta

AVP finance projects

Barclays Shared Services

البلد
الهند - New Delhi
التعليم
ماجستير, Administration And Finance
الخبرة
18 سنة, 9 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :18 سنة, 9 أشهر

AVP finance projects في Barclays Shared Services
  • الهند - تشيناي
  • أشغل هذه الوظيفة منذ يونيو 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 في Royal Bank of Scotland
  • الهند - جورجاون
  • مايو 2012 إلى يونيو 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 في Provana India Private Limited
  • الهند - دلهي
  • يونيو 2011 إلى يناير 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 في HSBC Data Processing India Pvt Ltd
  • الهند - دلهي
  • مارس 2009 إلى مايو 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 في Hewitt Associates
  • الهند - دلهي
  • ديسمبر 2007 إلى مارس 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 في American Express Bank
  • الهند - دلهي
  • مارس 2007 إلى نوفمبر 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 في Genpact
  • الهند - دلهي
  • أغسطس 2005 إلى مارس 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.

الخلفية التعليمية

ماجستير, Administration And Finance
  • في Symbiosis
  • أغسطس 2012
بكالوريوس, Financial Management
  • في Shaheed Bhagat Singh College
  • أغسطس 2005

Specialties & Skills

Financial Management
Management
Finance
operations
MS Excel

اللغات

الانجليزية
متمرّس

التدريب و الشهادات

LEAN COMPETENCY AWARENESS (الشهادة)
تاريخ الدورة:
May 2013
Scrum Basics (تدريب)
معهد التدريب:
LinkedIn
تاريخ الدورة:
July 2021
المدة:
3 ساعات