• Gurgaon, India¬†

Atul Gupta

Head of Reporting - Royal Bank of Scotland

Work History

Work History

Trainee

Virmani & Associates
Trainee-, New Delhi, India(Chartered Accountant Firm) 3 years Audited clients in manufacturing & hospitality industry ACADEMIC ACHIEVEMENTS

Head of Reporting-Commercial & Private Banking Division

Apr 2012 - Present
RBS Global Financial Services(GFS)
Gurgaon, India Head of reporting-Commercial & Private Banking Division Preparation & review of monthly/quarterly/yearly financial results along with providing analytical support on business performance to Finance Directors & other sub-divisional Finance Directors in London Leading GFS offshore decision support Finance team(20 people) and maintain permanent vacancy levels at manageable levels, whilst maintaining performance of staff at a high level Supporting the development and delivery of the GFS strategic objectives, including accommodating future transitions, creating centers of excellence, and embedding the Lean continuous improvement culture Create collaborative working partnerships with key stakeholders, across geographically diverse locations, and support the principles of extended team working Build and maintain a network of colleagues and contacts across the group to ensure a relevant flow of information Lead and support major restructuring currently happening within the organization and align operating model as per revised structure Lead by example, mentor the staff, recruit for vacancies and conduct performance appraisals for the team members twice a year Visit London office periodically to gather business requirements, discuss projects progress and relationship building

Manager-Financial

Aug 2009 - Mar 2012
The World Bank
Chennai, India Manager-Financial Analysis & Reporting Analyzing IBRD & IDA's financial statements and balances under USGAAP for statutory reporting. Analysis & preparation of MD&A: Support to the main financial statements Preparing internal & external financial reports for IBRD & IDA as part of the HQ business unit teams Developing and applying computer assisted analytical methodologies to test and explain changes in financial trends and results.(Key system tools used: SAP, Excel, Crystal Reports, Data Warehouse etc) Analyzing capital and preparing ad-hoc reports & simulations for senior management Handling special projects on an ongoing basis in the areas of system(SAP) enhancements, process improvements by closely coordinating with counterparts in Washington DC Preparing presentations on key business areas and special projects

Manager-Corporate Finance

Sep 2007 - Jul 2009
Hindustan Times Media Ltd
Gurgaon, India (One of the biggest print media company in India with annual revenue of approx. $300Mn) Manager-Corporate Finance Preparation and analysis of Annual Business Plan(Budgets) of the company across all the locations Analysis and reporting of Cost & Revenue Variances(along with possible saving opportunities) Monthly MIS closing and reporting Preparation of monthly/quarterly P&L Outlook for the company Analysis/presentation on top line performance, EBITDA and various growth drivers Fixation of revenue targets, incentive schemes across India for the Marketing team on a quarterly basis Formulation of pricing strategy, preparation of sales scheme & volume deals Exploring new business opportunities

Assistant Manager-Business Assurance and Advisory

Feb 2005 - Aug 2007
Deloitte Haskins & Sells
New Delhi, India Assistant Manager-Business Assurance and Advisory services Statutory and tax audits involving, leading the audit teams, preparing financial statements, reporting under Indian and international GAAP and liasioning with overseas Deloitte offices. Long list of clients audited includes Aricent, Hughes, LG & CSC USGAAP review & consolidation assignments including finalization of report IFRS audit assignments including finalization of report Sarbanes-Oxley audit involving the assessment of internal control over financial reporting(ICFR) and providing an assertion on the effectiveness of ICFR OVERSEAS WORK EXPERIENCE

Manager

Jan 2007 - Mar 2007
Deloitte & Touche LLP, Canada(Deputation) Deloitte Haskins & Sells
Manager- Audited clients in manufacturing industry and not for profit organizations Major clients worked on include, University of Calgary, Coal Valley Resources Inc. and Canadian Treads Corporation(subsidiary of Tirecraft Group)

Education

Education

B.Com

2001 - 2015
University of Punjab