Manager Financial

Flat No. ***, River Builders,

Raj Bagh, Near Rajnigandha Aptt.,

Sahibabad, Ghaziabad.

Phone: +91-981*******

Email:******************@*****.***

CA. SWATI BANSAL

Objective

To be a useful resource to an organization by aiming at perfection, adding value to work & processes performed in it in a given time frame and seeking professional growth. Computer literacy, working in a fully computerized environment having proficiency in various softwares, personality working with composure to meet deadlines. Leadership and team spirit qualities, curious about new ideas, and believe the task-oriented nature of the work in an organization will keep my interest and motivation high.

Work Experience: Total experience 9.2 years

ROYAL BANK OF SCOTLAND

Duration: January 01st, 2013 to till date.

Position: Manager, Statutory Reporting

Successfully transitioned a new role of Process and control from Edinburgh to India in June 2015 which includes planning the timetable for financial statements for next year cycle along with control the activities performed by the team and helping senior management in delivering the data packs regarding the progress of the team.

Successfully transitioned whole Central Statutory reporting process end to end from UK (Edinburgh) to India and executed the same at BU level in the time period of 7 weeks.

Work Profile:

Involved in work on preparing the financial statements for the various divisions within RBS by extracting the trial balances from the division’s database and then prepare the financial statements as per the applicable accounting standards.

Making Detailed Foot Note Analysis to ensure that the financial statements are complying with the applicable standards & laws.

Execute the work assigned in a dedicated manner to meet the timelines.

Reviewed the work of junior team members to ensure quality and documentation standards are adhered to.

Analyze and audit the line items in the financial statements and substantiate them with the back ups provided by the onshore divisions.

Prepare the adjustments entries which need to be posted by the divisions for the current year and ensure the compliance of the standards.

Follow up & resolve the queries raised by the divisional heads or the tax departments within RBS.

Involved in the assisting external auditors for their audit procedures and provide them the data required. Resolve their queries and make adjustments in the financial statements as per their guidance.

Follow up with the Group Secretariat for the final approval of the financials and resolve their queries if any.

Actively engaged in building the financial statements templates for various type of entities as per FRS 101 and other applicable standards and assist Group Chief Accountants in conversion of the statements from IFRS to FRS 101.

Also involved in the work for the XBRL, developing an open source tool to convert XBRL filings and taxonomies, and for rendering them to XHTML.

Analyzing the financial statements of all the entities of RBS group and mapping the lines and columns of financial statement to the appropriate UK-GAAP & IFRS taxonomy elements.

Making final review of statements prepared in XBRL formats done by other divisions before they are shipped out to Group Tax and assist group tax by identifying inconsistencies and inaccuracies for successful submission to HMRC.

Creating customized tags for line items found within financial statements and notes that do not have proper US-GAAP & IFRS tags in the current taxonomies & give feedback to various divisions.

Compare efficiency of XBRL report generation procedures performed across different divisions and suggest ideas for improvement.

Maintained quality in all XBRL work by reviewing work submitted by divisions to ensure negative comments are minimized from the UK/ Group Tax .

Maintained pro-active engagement with key stakeholders GCA, Group Tax, Group Secretariat, the Divisions, external audit (Deloitte) and software suppliers (KPMG) on timely basis and when required.

Assist Group Chief Accountant’s in preparing model financial statements for different categories of entities on the basis of their nature of activities.

Key assignments handled:

All 350 entities of RBS Group

KPMG

Duration: April 25th, 2011 to December 28th, 2012

Position: Senior (Team Leader), Assurance and Advisory Business Services

“Auditing for the entities registered in Netherlands”

Performed & lead the road shows at various offices of KPMG within Netherlands to promote KPMG India with the Senior manager and successful in contributing to bring new work & Clients from KPMG Netherlands which had increased the volume of work from 50% to 150%.

Work Profile:

oPlan scope and timing of audit work (Substantive Procedures and Control testing) to be carried out by the team.

oExecute the work assigned in a dedicated manner to meet the timelines.

oReviewed the work of junior team members to ensure KPMG quality and documentation standards are adhered to.

oCompare efficiency of audit procedures performed across different clients and suggest ideas for improvement.

“XBRL Department (4 months)”

Work Profile:

Analyzing the financial statements of publicly listed companies of Netherlands and mapping the lines and columns of financial statement to the appropriate UK-GAAP & IFRS taxonomy elements.

Making Detailed Foot Note Analysis and tagging each concept found within the notes with appropriate UK-GAAP & IFRS taxonomy elements.

Execute the work assigned in a dedicated manner to meet the timelines.

Reviewed the work of junior team members to ensure KPMG quality and documentation standards are adhered to.

Prepare work papers for the respective sections in the financial statements and substantiate the same with proper back ups provided by the onshore team

Involved in work on XBRL, developing an open source tool to convert XBRL filings and taxonomies, and for rendering them to XHTML.

Creating XBRL for the financial statements and note disclosures.

Making final review of statements prepared in XBRL formats done by other staffs before they are shipped out to clients.

Creating customized tags for line items found within financial statements and notes that do not have proper US-GAAP & IFRS tags in the current taxonomies.

Compare efficiency of XBRL report generation procedures performed across different clients and suggest ideas for improvement.

Key assignments handled:

KPMG clients i.e. UK based companies adopting both UK GAAP & IFRS as their accounting package like Astrazeneca Plc, Bank of London, Santander Plc, Deutsch UK group etc.

Ernst & Young (India)

Duration: September 21, 2009 till April 2011

Position: Executive, Assurance and Advisory Business Services

Work Profile:

oPlan scope and timing of audit work (Susbstantive Procedures and Control testing) to be carried out by the team.

oExecute the work assigned in a dedicated manner to meet the timelines.

oReviewed the work of junior team members to ensure EY quality and documentation standards are adhered to.

oCompare efficiency of audit procedures performed across different clients and suggest ideas for improvement.

Key assignments handled:

Centum Learning Limited: IFRS assignment: First time adoption of IFRS

oHandled the assignment of IFRS conversion for the first time by the company.

oIdentified the gaps between the policy adopted by the company as per Indian GAP’s and policy should be followed as

per IFRS as per the EY checklist and methodology.

oAnalysed the GAPS and then with the discussion with the management, prepare action plan to change and adopt the

policies to comply with IFRS and thus convert their balance sheet from IGAAP to IFRS.

HCL Technologies Limited: Initial Audit Procedures & Limited Review for Qtr ended Sep09 & Dec09 (as per IGAAP & UGAAP both)

oPart of the audit & Limited Review for Software Division & BPO Division of HCL Technologies Limited.

o

oInvolved in the process of initializing the audit for the first time of HCL Technologies by understanding the various

business process of the client and assist in drafting the CAS (Client Assessment Schedule) accordingly to meet our

audit requirements along with Client’s requirement within the timeline given.

oPerformed detailed initial audit procedures,including reviewing transactions, documents, records, reports, and

policies and procedures, business processes for accuracy and effectiveness of the Balances as on Sep 09 and balances as

on December 2009.

oAnalysed the OAR (Overall Analytical Review) of Qtr ended December 2009 and examined the reason for variances between

between the figures of Qtr ended Dec 09 & Qtr ended Sep 09 of the Balance Sheet Items.

oPerformed various Walkthroughs to gain understanding on various business processes of the client like Banking

oWalkthrough, investment walkthrough, prepaid expense walkthrough etc.

oAssessed the deficiencies and material weaknesses and prepared the issue report and remediation plan.

Wire & Wireless India Limited: Statutory Audit for FY 2009-10 & Limited Review for Quarter ended Sep09 & Dec09.

Area Handled: Opex Cost (operational cost), Selling & Distribution Cost, Other Income, Cash & Bank

oPerformed detailed audit procedures for FY 09-10, on Operational Cost, Selling & Distribution & Other Income

oExamined the reasons for variances between the figures of Year to date March 2010 & March 2009.

o

Virgin Media Plc, Bombardier Transportation UK Ltd, Universal Music Plc, Hewlett- Packard Ltd etc.

oAnalysed the OAR (Overall Analytical Review) and examined the reason for variances in both Qtr for Limited Review.

I Services India Private Limited, Global Infonet Distribution Private Limited etc.

oPrepared Audit Planning Memorandum.

oPerformed detailed audit procedures to finalise & freeze the balances till Dec 2009 for Stat Audit 2009-10.

oPrepared Summary Review Memorandum and discussed various Issue with Clients

Ajay Rattan & Co. (Chartered Accountants)

Duration: February 10, 2006 to September 20, 2009 (Pursued articleship with M/S Ajay Rattan & Co. since February, 2006 based at New Delhi. And continue further from May 2008 till September, 2009 as a Senior Executive).

Position: Senior Executive

Work Profile:

oExecuted detailed audit procedures, including reviewing transactions, documents, records, reports, and policies and procedures, business processes for accuracy and effectiveness.

oEnsuring Compliance with the Legal provisions, Accounting Standards, ASI’s, guidance notes issued by the ICAI and other legal pronouncements.

oHandled statutory audits & Tax Audits.

oFinalization of financial statements and their analysis.

oHandled Corporate and individual taxation.

oAssisted in assessment proceedings under section 143 of Income Tax Act,1961

oPrepared Income Tax replies required for assessment proceedings under section 143 of Income Tax Act,1961

oIdentification of internal checks and control system for various processes of the client’s organization and scope of improvements therein

Key assignments handled:

STATUTORY AND TAX AUDITS

oMinda Industries Limited (Designer & Manufacturer of switches & batteries for 2/3/4 wheelers and off-road vehicles).

oCanny Overseas Private Limited (Engaged in importing agricultural commodities like peas and pulses and exporting

sesame seeds).

oTusker Dye Chem Private Limited (Trader of Dye Chemicals).

oRashtriya Andh Kanya Vidhalay Charitable Trust (Trust)

oSearch Software Private Limited (Manpower Consultancy).

oCountry Buildwell Private Limited (Contractors/Builders)

oDR Donalds Private Limited (Engaged in production of films, serials etc.)

oMine Chemicals Private Limited

oDaksharth Agencies (Partnership Firm), etc.

OTHER SPECIFIC WORK

oIncome Tax Returns: Preparing income tax computations of the individuals & filing the same.

oCorporate Returns: Preparing income tax computations of the corporate & filing the same through e-filing.

oROC Filings: Filing annual returns (Form 20B, 23AC, 23ACA etc.)

Professional achievements

Managed and handled assignments independently during articleship period, gaining appreciation from client and superiors.

Was made responsible for direct interactions with clients at an early stage.

Professional qualifications

Qualification

Year of Passing

Remarks

Marks

CA FINAL

May 2008

Both Groups in First Attempt

56.25%

CA PE-II

November 2005

Both Groups in First Attempt

61.33%

CA Foundation

May 2004

In First Attempt

64%

Academic qualifications

Qualification

School/College/ University

Course/Board

Year of Passing

Marks

Graduation

Hindu College, Delhi University

B.Com. (Honours)

2006

70.85%

XII

G.G. Senior Secondary School

CBSE

2003

90.25%

X

G.G. Senior Secondary School

CBSE

2001

80%

Academic Achievements

Received an award on account of the Best Lady Candidate in Northern India and securing First Position in Northern India in the CA Final Examination, May 2008.

Received an award on account of the K.V. CHANDRAMOULI MEMORIAL PRIZE for the best paper on Mathematics (Paper 2 –Section A) in the PE I Examination, May 2004.

Received an INDIRA GANDHI AWARD for getting the highest marks in the EAST DELHI in the 12th class Examination, May 2003.

Topper of the commerce stream in class XII in whole East Delhi.

Computer literacy

Working in a fully computerized environment having proficiency in various softwares.

Personality

Working with composure to meet deadlines.

Leadership and team spirit qualities

Curious about new ideas, and believe the task-oriented nature of the work in an organization will keep my interest and motivation high.

Innovative and design oriented

Personal Details

Sex:

Nationality:

Date of birth:

Marital status:

Female

Indian

June 02, 1986

Married

(Swati Bansal)

Contact this candidate