Description
keyboard_arrow_downMain Skills
keyboard_arrow_downOther Skills
keyboard_arrow_down Sage
FTP
Big data
SAP
Oracle
User acceptance testing
Work & Experience
keyboard_arrow_down 01.05.2017 — 31.07.2017
Business Analyst -IFRS9 /Big Data Reporting Provide support on the achievement of the strategic vision of the project.
Validation of data point attributes populated in FTP and sample tie back to source product system to ensure definitions are valid
Gap analysis of reporting requirements against current populated data points in FTP and Big Data
Review and updated Business requirements by liaising with different stakeholders across the business.
Update and review project RAID with a view to resolving issues promptly.
Manage the preparation of test plans, coordinating with end users and IT to facilitate effective testing
Ensure that all products and their attributes have been properly classified and accounted for.
Review of Financial statement attributes comparing balances in IAS39 to IFRS9
Identification of issues in source data and engaging with the relevant reporting teams and development teams to drive the remediation of such issues.
Define and test report mappings in FTP / Big Data to populate IFRS supplementary reporting requirements
Automation of manual reporting processes including the reduction in manual journals, reduction in the utilization of EUCs and sourcing of data from Big Data where the current source in manual in nature.
Migrate and embed new reporting onto FTP / Big data platforms
Process redesign and validation.
Work closely with the transformation teams who are leading the overall design and implementation of new reporting architecture to ensure that user requirements / interests are being met.
Liaise with different stakeholders such as Legal, IT and front office for validation and alignment of attributes.
Work with BAU teams to streamline reporting and, where possible, implement automated reporting solutions that are aligned to Group-wide generally accepted practices.
Review, testing and validation of ring fenced bank and non-ring fenced bank split of data. 01.12.2013 — 31.08.2016
Manages and completes strategic end to end ad hoc projects for the team and across the business such as migration from the existing Traders mandate to TM2, Book Migration, FINREP and IFRS9.
Gathered business requirements and reviewed it in line with project requirements
GAP analysis and business requirement documentation across the business.
Assisted in the input and planning for detailed stakeholder briefings on the analysis and delivery of the business services standards, developments issues and status updates.
Liaising with Structuring team to resolve accounting issues and queries related to identified structured transactions.
Worked with different stakeholders to ensure that the work of the program, including the scope of each project, covers the necessary aspects required.
Managed the project of off shoring of some activities to Chennai, India including review and testing of procedures and processes as well as training of new staff.
Liaise with different stakeholders for data gathering, gap analysis and process testing for effectiveness as well as User acceptance testing.
Provide business partnering with different stakeholders across the business
Provide analysis of the business unit to build a base for effective first level review.
Ensure that key control policies are in place and adhered to through daily monitoring and update of various policy requirements.
Analysis of business, financial and operational risk associated with new business and transactions
Liaise with colleagues in New York, Hong Kong, Luxembourg and Singapore for information exchange and intercompany transactions.
Ensure that there is adequate control in place to identity any non-compliance and take appropriate measures to redress the situation.
Review Product schematic to incorporate reporting requirement.
Participated in the new Structural reform analysis and discussion and the heat -map.
Worked with various stakeholders to ensure that the framework developed meets the requirements of all control functions as appropriate.
Produced appropriate control documentation such as policies, Standards and business procedures gaining appropriate signoff as applicable.
Managed project tracker and performance level for effective monitoring of the project.
Preparation and monitoring of Budget and Forecast for each project comparing budget with actual to identify project performance and cost
Provide business partnering with different stakeholders across the business.
Manage the preparation and review of Statutory accounts in line with various regulatory requirements as applicable as well as liaise with external auditors.
Manage the preparation of monthly Front office-Back office (FOBO) report and flash formalisation.
. 01.05.2011 — 31.12.2013
Royal Bank of Scotland (RBS) Business Analyst - Financial Control (Strategic Projects) Divestment Projects (Ring Fencing and structural Reform)
Project Rainbow
Played active role in Divestment, Segregation and Separation activities of the divested business.
Managed a team of 4 to ensure Successful delivery of the project that introduced changes to the structure of the business and ensure that they are aligned to Ring Fence and divestment strategic design.
Manage the production of required documentation and reports to agreed quality and standards.
Involved in Project planning and governance in determining Target operating module and the road map to ensure that the structural adjustment and ring fenced project
Part of the team that defined requirement, impact assessments, documenting current state of functions and liaised with functional work streams leads and program managers to obtain and validate information.
Investigated business needs, risks, opportunities and proffer business solution in line with continuous improvements.
Identified and developed appropriate control framework to embed business services and standards across the bank in line with Group risk and Control requirements.
Worked with different stakeholders to ensure that the framework developed meet the requirement of all control functions as appropriate.
Ensure that the project is compliant with the project governance requirements as stipulated in the business Transformation Framework (BTF)
Provided detailed input to the project risk management cycle in line with target operating module.
Engaged with respective Businesses and functions to put in place a delivery plan, and tracked the delivery against plan ,managing risk, issues and interdependence with the functions across the business
Assisted in the input and planning for detailed stakeholder briefings on the analysis and delivery of the business services standards, developments issues and status updates.
Prepared progress report in accordance with agreed project and central change governance to ensure project progress is tracked and visible to stakeholders
Investigate business needs, risks, problems, and opportunities, and proffer effective business solutions in line with continuous improvements.
Implemented a governance structure to ensure that all risk and issues are escalated efficiently.
Attended project governance and review meetings in both London and Edinburgh
Preparation and adjusting monthly financial statement through flash reporting model
Review balance sheet reconciliations for Operational Accounting owned accounts, ensuring consistency of accounting standards through the testing and implementation activities
Provide Balance sheet substantiation, reasonable enquiry and high level analysis of financial, liquidity and risk issues
Delivery of accurate and timely management information for specific business units whilst ensuring all outputs are validated and delivered in accordance with SLAs
Cross functional working relationship and business partnership with other teams within the Business, to drive best practice and improve both results and the control environment for the financial statement.
Preparation and adjusting monthly financial statement through flash reporting model.
Investigate various internal and external queries in line with project requirement ,audit and SOX requirement
Ensure successful segregation of the project financials from the group wide financial statements in line with the Project agreement and life cycle
Preparation of Monthly FD Pack and Flash reports which includes Balance sheet and p&l accounts.
Carried out monthly divestment Carved out and SPA 2 process to ring-fence the divested business.
Provide support and guidance on technical queries/issues as a subject matter expert.
Detailed analysis of P&L and Balance sheet segregation process, providing necessary commentaries to the project team.
Review balance sheet reconciliations for Operational Accounting owned accounts, ensuring consistency of accounting standards through the testing and implementation activities.
Provide quality assurance on reporting system and data integrity 01.11.2010 — 28.02.2011
Commercial First Mortgages Ltd Group Reporting Accountant Manage the production and review of statutory accounts for all individual UK subsidiaries under both UK GAAP and IFRS and liaise with auditors.
Preparation of the consolidated accounts and group accounts.
Month end closing of the company books
Ensure that all Revenue and expenditure were captured in P&l accounts
Manage the production and review of statutory accounts for the consolidated financial statements of the Group.
Managed the preparation of statutory returns such as VAT, Corporation tax etc.
Reconciliation of accruals and prepayment schedules.
Reconciliation and analysis of Balance sheet and P&l items and key performance indicators
Ensuring all deliverables are prepared and reviewed within tight reporting deadlines through management of month and quarterly closing processes.
Management of all month / year end reconciliation and analysis for the Financial Controller/ Finance Director
Ensuring the integrity and consistency of all financial information
Taking Responsibility for reporting on the more complex areas of the Group's Annual Report and Accounts
Map/tag the current Case Ware pro-forma chart of accounts to the published HMRC Taxonomy on XME and IXBRL
Ensuring financial report complied with relevant legislation, IFRS and best accounting practice
Liaison with external Auditors
Developing effective working relationships internally within the Business and externally with key business partners
Managing the implementation of new accounting requirements under International Financial Reporting Standards (IFRS) 01.01.2010 — 31.07.2010
Preparation of Monthly financial statements and commentaries
Monitor all expenditure and undertake month end closing procedures, ensuring the integrity and accuracy of data at all times and that the finance systems and processes operate effectively and efficiently
Preparation of Interim and Final consolidated accounts.
Monitor budgets on a monthly basis and complete appropriate returns to the Senior Finance Manager and Management.
Along with the Senior Finance Manager, prepare and distribute monthly budget holder's reports to all key budget holders; answer queries from budget holders and interpret the reports when requested.
Develop and promote good financial practices, budgetary disciplines, regulations, accounting requirements and performance standards.
Manage the integrity of all information entered and maintained on the general ledger, ensuring that appropriate controls are in place and adhered to at all times.
Liaise with both internal and external Auditors and attended various audit wash-up meetings.
Ensure that Auditors' recommendations are implemented
Ensure that Service level agreement are implemented and value for money policy is followed
Participated in the Conversion of Financial statements from UK GAAP to IFRS
Liaise with various regulatory authorities and ensure timely returns
Provide timely and accurate financial information and advice to support management /business decision. 01.08.2009 — 31.12.2009
Preparation of monthly financial statements and analysis
Reconciliation of key balance sheet items and other control accounts
Investigating the validity of Fixed Assets policies, procedures and controls within the project and making sure it within relevant accounting standard.
Participated in the preparation of 2010/11 budgets and forecasts
Responsible for review and improvement of existing finance procedures to make it more robust and effective
Implementation of query resolution management process between the company and other stakeholders
Collation and analysis of Expenditure against budgets and forecast
Ensure that policies and procedures on expenses are adequately followed.
Involve in cost saving and due diligence in expenditure management.
Other Accounting and Reporting Roles 01.05.1998 — 29.02.2008
Head of Operations/Reporting Accountant Preparation of the annual and semi-annual financial statements.
Preparation of the subsidiaries annual accounts and Consolidated accounts
Monthly financial statements and ad hoc monthly client reporting.
Treasury and money market management
Review and reconciliation of month end journals, prepayments and accruals.
KYC and money laundering reporting Officer.
Review of Billing process and Calculation of Fees and Commission
Analysis and report on monthly expenditure in variance with operating and capital budgets
Review of financial statements and regulatory filings.
Review Liquidity position and stress testing and report to appropriate authorities.
Reviewing and adjusting expense accruals and total expenditure ratio
Reporting monthly position to the Financial Regulator and other regulatory authorities
Liaising with other departments regarding information for financial reporting and audit
Liaised with various Account Managers on Client Management and service Delivery.
Preparation of statutory returns such as VAT, PAYE and Withholding tax to Inland Revenue.
Review and adjust expense accruals and total expenditure ratio
Calculation of net cash position, analysis of bank activity and assessment of investing/borrowing activityEnsure deadlines for clients and improved procedures and controls within the group
As part of a team, handle budget preparation and management for the organization
Provide timely and accurate financial information and advice to support management/business decisions 01.01.1994 — 30.04.1998
Planning, controlling and coordinating the audit of accounts of a portfolio of clients -small and medium size companies, financial institutions and non profit making organizations.
Prepare interim and final management and financial accounts for clients
Set-up Financial, internal control, cost and management accounting systems and train client's staff. Coordinate due diligence and specialized audit/investigation into financial affairs of clients on request
Prepare feasibility studies and cash flow statements for clients Business Analyst -IFRS9 /Big Data Reporting Provide support on the achievement of the strategic vision of the project.
Validation of data point attributes populated in FTP and sample tie back to source product system to ensure definitions are valid
Gap analysis of reporting requirements against current populated data points in FTP and Big Data
Review and updated Business requirements by liaising with different stakeholders across the business.
Update and review project RAID with a view to resolving issues promptly.
Manage the preparation of test plans, coordinating with end users and IT to facilitate effective testing
Ensure that all products and their attributes have been properly classified and accounted for.
Review of Financial statement attributes comparing balances in IAS39 to IFRS9
Identification of issues in source data and engaging with the relevant reporting teams and development teams to drive the remediation of such issues.
Define and test report mappings in FTP / Big Data to populate IFRS supplementary reporting requirements
Automation of manual reporting processes including the reduction in manual journals, reduction in the utilization of EUCs and sourcing of data from Big Data where the current source in manual in nature.
Migrate and embed new reporting onto FTP / Big data platforms
Process redesign and validation.
Work closely with the transformation teams who are leading the overall design and implementation of new reporting architecture to ensure that user requirements / interests are being met.
Liaise with different stakeholders such as Legal, IT and front office for validation and alignment of attributes.
Work with BAU teams to streamline reporting and, where possible, implement automated reporting solutions that are aligned to Group-wide generally accepted practices.
Review, testing and validation of ring fenced bank and non-ring fenced bank split of data. Manages and completes strategic end to end ad hoc projects for the team and across the business such as migration from the existing Traders mandate to TM2, Book Migration, FINREP and IFRS9.
Gathered business requirements and reviewed it in line with project requirements
GAP analysis and business requirement documentation across the business.
Assisted in the input and planning for detailed stakeholder briefings on the analysis and delivery of the business services standards, developments issues and status updates.
Liaising with Structuring team to resolve accounting issues and queries related to identified structured transactions.
Worked with different stakeholders to ensure that the work of the program, including the scope of each project, covers the necessary aspects required.
Managed the project of off shoring of some activities to Chennai, India including review and testing of procedures and processes as well as training of new staff.
Liaise with different stakeholders for data gathering, gap analysis and process testing for effectiveness as well as User acceptance testing.
Provide business partnering with different stakeholders across the business
Provide analysis of the business unit to build a base for effective first level review.
Ensure that key control policies are in place and adhered to through daily monitoring and update of various policy requirements.
Analysis of business, financial and operational risk associated with new business and transactions
Liaise with colleagues in New York, Hong Kong, Luxembourg and Singapore for information exchange and intercompany transactions.
Ensure that there is adequate control in place to identity any non-compliance and take appropriate measures to redress the situation.
Review Product schematic to incorporate reporting requirement.
Participated in the new Structural reform analysis and discussion and the heat -map.
Worked with various stakeholders to ensure that the framework developed meets the requirements of all control functions as appropriate.
Produced appropriate control documentation such as policies, Standards and business procedures gaining appropriate signoff as applicable.
Managed project tracker and performance level for effective monitoring of the project.
Preparation and monitoring of Budget and Forecast for each project comparing budget with actual to identify project performance and cost
Provide business partnering with different stakeholders across the business.
Manage the preparation and review of Statutory accounts in line with various regulatory requirements as applicable as well as liaise with external auditors.
Manage the preparation of monthly Front office-Back office (FOBO) report and flash formalisation.
. Royal Bank of Scotland (RBS) Business Analyst - Financial Control (Strategic Projects) Divestment Projects (Ring Fencing and structural Reform)
Project Rainbow
Played active role in Divestment, Segregation and Separation activities of the divested business.
Managed a team of 4 to ensure Successful delivery of the project that introduced changes to the structure of the business and ensure that they are aligned to Ring Fence and divestment strategic design.
Manage the production of required documentation and reports to agreed quality and standards.
Involved in Project planning and governance in determining Target operating module and the road map to ensure that the structural adjustment and ring fenced project
Part of the team that defined requirement, impact assessments, documenting current state of functions and liaised with functional work streams leads and program managers to obtain and validate information.
Investigated business needs, risks, opportunities and proffer business solution in line with continuous improvements.
Identified and developed appropriate control framework to embed business services and standards across the bank in line with Group risk and Control requirements.
Worked with different stakeholders to ensure that the framework developed meet the requirement of all control functions as appropriate.
Ensure that the project is compliant with the project governance requirements as stipulated in the business Transformation Framework (BTF)
Provided detailed input to the project risk management cycle in line with target operating module.
Engaged with respective Businesses and functions to put in place a delivery plan, and tracked the delivery against plan ,managing risk, issues and interdependence with the functions across the business
Assisted in the input and planning for detailed stakeholder briefings on the analysis and delivery of the business services standards, developments issues and status updates.
Prepared progress report in accordance with agreed project and central change governance to ensure project progress is tracked and visible to stakeholders
Investigate business needs, risks, problems, and opportunities, and proffer effective business solutions in line with continuous improvements.
Implemented a governance structure to ensure that all risk and issues are escalated efficiently.
Attended project governance and review meetings in both London and Edinburgh
Preparation and adjusting monthly financial statement through flash reporting model
Review balance sheet reconciliations for Operational Accounting owned accounts, ensuring consistency of accounting standards through the testing and implementation activities
Provide Balance sheet substantiation, reasonable enquiry and high level analysis of financial, liquidity and risk issues
Delivery of accurate and timely management information for specific business units whilst ensuring all outputs are validated and delivered in accordance with SLAs
Cross functional working relationship and business partnership with other teams within the Business, to drive best practice and improve both results and the control environment for the financial statement.
Preparation and adjusting monthly financial statement through flash reporting model.
Investigate various internal and external queries in line with project requirement ,audit and SOX requirement
Ensure successful segregation of the project financials from the group wide financial statements in line with the Project agreement and life cycle
Preparation of Monthly FD Pack and Flash reports which includes Balance sheet and p&l accounts.
Carried out monthly divestment Carved out and SPA 2 process to ring-fence the divested business.
Provide support and guidance on technical queries/issues as a subject matter expert.
Detailed analysis of P&L and Balance sheet segregation process, providing necessary commentaries to the project team.
Review balance sheet reconciliations for Operational Accounting owned accounts, ensuring consistency of accounting standards through the testing and implementation activities.
Provide quality assurance on reporting system and data integrity Commercial First Mortgages Ltd Group Reporting Accountant Manage the production and review of statutory accounts for all individual UK subsidiaries under both UK GAAP and IFRS and liaise with auditors.
Preparation of the consolidated accounts and group accounts.
Month end closing of the company books
Ensure that all Revenue and expenditure were captured in P&l accounts
Manage the production and review of statutory accounts for the consolidated financial statements of the Group.
Managed the preparation of statutory returns such as VAT, Corporation tax etc.
Reconciliation of accruals and prepayment schedules.
Reconciliation and analysis of Balance sheet and P&l items and key performance indicators
Ensuring all deliverables are prepared and reviewed within tight reporting deadlines through management of month and quarterly closing processes.
Management of all month / year end reconciliation and analysis for the Financial Controller/ Finance Director
Ensuring the integrity and consistency of all financial information
Taking Responsibility for reporting on the more complex areas of the Group's Annual Report and Accounts
Map/tag the current Case Ware pro-forma chart of accounts to the published HMRC Taxonomy on XME and IXBRL
Ensuring financial report complied with relevant legislation, IFRS and best accounting practice
Liaison with external Auditors
Developing effective working relationships internally within the Business and externally with key business partners
Managing the implementation of new accounting requirements under International Financial Reporting Standards (IFRS) Preparation of Monthly financial statements and commentaries
Monitor all expenditure and undertake month end closing procedures, ensuring the integrity and accuracy of data at all times and that the finance systems and processes operate effectively and efficiently
Preparation of Interim and Final consolidated accounts.
Monitor budgets on a monthly basis and complete appropriate returns to the Senior Finance Manager and Management.
Along with the Senior Finance Manager, prepare and distribute monthly budget holder's reports to all key budget holders; answer queries from budget holders and interpret the reports when requested.
Develop and promote good financial practices, budgetary disciplines, regulations, accounting requirements and performance standards.
Manage the integrity of all information entered and maintained on the general ledger, ensuring that appropriate controls are in place and adhered to at all times.
Liaise with both internal and external Auditors and attended various audit wash-up meetings.
Ensure that Auditors' recommendations are implemented
Ensure that Service level agreement are implemented and value for money policy is followed
Participated in the Conversion of Financial statements from UK GAAP to IFRS
Liaise with various regulatory authorities and ensure timely returns
Provide timely and accurate financial information and advice to support management /business decision. Preparation of monthly financial statements and analysis
Reconciliation of key balance sheet items and other control accounts
Investigating the validity of Fixed Assets policies, procedures and controls within the project and making sure it within relevant accounting standard.
Participated in the preparation of 2010/11 budgets and forecasts
Responsible for review and improvement of existing finance procedures to make it more robust and effective
Implementation of query resolution management process between the company and other stakeholders
Collation and analysis of Expenditure against budgets and forecast
Ensure that policies and procedures on expenses are adequately followed.
Involve in cost saving and due diligence in expenditure management.
Other Accounting and Reporting Roles Head of Operations/Reporting Accountant Preparation of the annual and semi-annual financial statements.
Preparation of the subsidiaries annual accounts and Consolidated accounts
Monthly financial statements and ad hoc monthly client reporting.
Treasury and money market management
Review and reconciliation of month end journals, prepayments and accruals.
KYC and money laundering reporting Officer.
Review of Billing process and Calculation of Fees and Commission
Analysis and report on monthly expenditure in variance with operating and capital budgets
Review of financial statements and regulatory filings.
Review Liquidity position and stress testing and report to appropriate authorities.
Reviewing and adjusting expense accruals and total expenditure ratio
Reporting monthly position to the Financial Regulator and other regulatory authorities
Liaising with other departments regarding information for financial reporting and audit
Liaised with various Account Managers on Client Management and service Delivery.
Preparation of statutory returns such as VAT, PAYE and Withholding tax to Inland Revenue.
Review and adjust expense accruals and total expenditure ratio
Calculation of net cash position, analysis of bank activity and assessment of investing/borrowing activityEnsure deadlines for clients and improved procedures and controls within the group
As part of a team, handle budget preparation and management for the organization
Provide timely and accurate financial information and advice to support management/business decisions Planning, controlling and coordinating the audit of accounts of a portfolio of clients -small and medium size companies, financial institutions and non profit making organizations.
Prepare interim and final management and financial accounts for clients
Set-up Financial, internal control, cost and management accounting systems and train client's staff. Coordinate due diligence and specialized audit/investigation into financial affairs of clients on request
Prepare feasibility studies and cash flow statements for clients Attachments
keyboard_arrow_down
