Rajash Gupta
Southall,EAL
Summary
FCCA qualified accountant with extensive experience in accounting & financial matters for a variety of industries. Highly numerate with strong management accounts & analytical experience. Previous roles include systems accountant & senior financial accountant. Confident self-starter with transferable skills. In recognition of proficient IT skills, supplemented with a strong finance background, seconded on many business critical projects. Successful in delivering projects on time & within budget. Ability to manage projects simultaneously. Developed soft skills to confidently business partner throughout the organisation.
Overview
15
15
years of professional experience
6005
6005
years of post-secondary education
Work History
Finance Business Partner
THINVENTORY LTD
03.2022 - 01.2026
- Preparation & reporting of month end pack
- System administrator of SAP Analytics Cloud including administration, creation & editing of stories, maintaining dimensions & members, creating hierarchies to aide reporting requirements
- Monthly departmental OPEX spend analyses with commentary
- Preparation of budget & forecasts packs
- Extensive coverage of OPEX with departmental heads during preparation of budgets & forecasts
- Preparation & submission of weekly temporary staff timesheets to recruitment agencies
- Ad hoc reporting for Private Equity owners & external auditors
- Standardised month end pack reporting
- Process improvements using ByD & SAP Analytics Cloud excel add-ins to reduce month end reporting from 7 to 4 days
- Extensive development of SAP Analytics Cloud including optimising stories & conversation of models from account based to measure based to future proof system
Senior Financial Planning & Reporting Analyst
NORGINE LTD
04.2019 - 09.2021
- Preparation & reporting of monthly sales & P&L presentation packs
- OPEX spend analyses
- Preparation of budget & quarterly forecasts packs
- Maintaining COA & COGS mapping tables in TM1
- Seconded to commercial department to provide standardised reporting
- Monthly & quarterly royalties submissions
- Ad hoc reporting for external institutions e.g. BoE Decision Maker Panel Survey
- Standardised reporting of PowerPoint packs & back up Excel working files
- Automating reporting processes where applicable
- Improved monthly & quarterly reporting of financials to SMT
Finance Analyst
G4S UK PLC
09.2018 - 12.2018
- Finance lead for a division responsible for all financials, reporting to SMT, budgeting, forecasting & audit deliverables
- Working to tight deadlines to deliver results in a timely manner
- Simplification of month end schedules creating efficiencies & greater transparency
- Dynamic business review reporting pack created using EPM
Financial Planning & Reporting Analyst
NORGINE LTD
08.2018 - 09.2018
- Creating standardised reporting suite using TM1, Excel & PowerPoint supporting analysis of KPIs
- Assist issuance of global monthly sales & P& L reporting pack with analyses & commentary
- Developed standardised reporting templates for management detailing analysis of sales with budget, forecast & prior year comparatives
- Interactive schedules with multiple selection criteria
Data Migration Analyst
KASPERSKY LABS UK LTD
12.2017 - 01.2018
- Part of Data Migration team in Microsoft Dynamics AX 2012 implementation team
- Primary focus data cleansing of Navision master vendor data & fixed asset cards for migration
- Successful cleansing of vendor data (c.28000 records) & fixed asset data (c.7300 records) within timelines
- Contributed to Go-Live on schedule
Commercial Analyst
SDL PLC
03.2017 - 08.2017
- EMEA month end reporting for 9 cost centres
- Budgeting & forecasting in multi-currency environment including spot forecasts
- 38 Language Offices month end management packs & External Cost of Sales Analysis
- Gross margin & utilisation analysis
- KPI reporting
- Improvement in ECOS analysis process using Access resulting in 3 man days saving
- EMEA forecast reporting improved using macros
- Intensive & successful handover of Language Office analytical duties to ensure business continuity
- Documenting process improvements
Data Migration Analyst
SMITH & NEPHEW PLC
07.2016 - 02.2017
- Part of HFM upgrade project team, restructuring chart of accounts & reporting, from a management to a statutory basis
- Responsible for checking & verifying migrated accounting data & reporting schedules
- Resolution of queries through regular contact with local entity financial controllers & the technical project team
- Reviewing accounts in web-based HFM for old & new structure
- HFM UAT webform script testing
- Creation of interactive SmartView templates to aide reconciliation at entity level
- Successful migration & merging of accounting information from 275 entities in the old structure to 138 entities in the new structure
- Successful migration of 13 periods & forecast data, within project timelines
- Verification & successful transfer of all journals
- All documentation verified & approved, providing a source of future reference to Group Finance
Financial Accountant
HUTCHISON 3G
09.2010 - 12.2015
- Ownership & administration of financing initiative
- Responsible for the creation, accounting & reconciliation of the unbilled debtor accounts
- Ad hoc analysis & reports for senior management including due diligence assistance for merger with O2
- Complete ownership of reporting to all internal & external shareholders on the unbilled debtor & handset receivables sales program
- Quarterly forecast & budget planning for impact of unbilled debtor & handset receivables cash flow
- Ownership of SOP Revenue invoicing & accounting
- Delegated authorisation of Content Settlement POs & advised on streamlining processing
- Delegated authorisation of SOP AR commission requests & AP approvals
- Ownership of Prepay & Post pay Revenue - month end tasks & improvements to the process
- Finance lead for new propositions
- Error management & ensuring billing correctly interfaced into Oracle R12 & all data marts updated
- Creation of a database in Access in excess of 2 million records to aide creation of handset debtor & automating the process in Excel to improve efficiency
- Provide improved reporting solutions to senior management to make informed planning decisions
- Mentored junior staff in advanced Excel techniques
- Successfully implemented financing with approximately £250m cash benefit
- Co-ordinated the successful transition of reporting for the unbilled debtor from Excel to SAS due to capacity constraints of Excel
- Vast improvement in the quality, timeliness & relevance of the reporting suite to all shareholders
- Improved cash flow forecasting of handset receivables sale to reduce monthly variances
- Process flow documentation of billing process
Education
FCCA -
ACCA Member -
BA (Hons) - Accounting & Finance
3 GCE "A" Levels -
11 GCE "O" Levels -
Skills
- Month end closure
- Process improvements
- Reporting
- Year end audits
- Internal audits
- Bank audits
- SAP ByD
- SAP Analytics Cloud
- Oracle
- EPM
- Navision
- Axapta
- Great Plains
- TM1
- SmartList
- Microsoft Office
- HFM
- SmartView
- Essbase
- ProFinance
- ALFA
- Quick Books
References
True
Non Work Periods
- 10/01/21, 02/01/22
- 01/01/19, 04/01/19
- 02/01/18, 07/01/18
- 09/01/17, 11/01/17
- 01/01/16, 06/01/16
Timeline
Finance Business Partner
THINVENTORY LTD
03.2022 - 01.2026
Senior Financial Planning & Reporting Analyst
NORGINE LTD
04.2019 - 09.2021
Finance Analyst
G4S UK PLC
09.2018 - 12.2018
Financial Planning & Reporting Analyst
NORGINE LTD
08.2018 - 09.2018
Data Migration Analyst
KASPERSKY LABS UK LTD
12.2017 - 01.2018
Commercial Analyst
SDL PLC
03.2017 - 08.2017
Data Migration Analyst
SMITH & NEPHEW PLC
07.2016 - 02.2017
Financial Accountant
HUTCHISON 3G
09.2010 - 12.2015