AVP finance projects
Barclays Shared Services
Total years of experience :18 years, 7 Months
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- 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
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.
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
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
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.
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.