Dipan P.

DATA SCIENTIST

265 euro

Mon expérience

Voir plus

Cox Automotive, MelbourneDecember 2019 - March 2020

With more than 40,000 auto dealer clients across five continents, Cox Automotive is a global automotive business, including within its subsidiaries Kelley Blue Book, Xtime, Autotrader.com and Manheim.
Responsibilities:
• Managed the Group’s Financial Risks & Opportunities during year-end close involving business partnering with senior stakeholders.
• Was a point of contact for the year end statutory accounts, including management of adhering to IFRS 16.
• Reconciled and cleared year-end GLs for, debtors, fixed assets and others.
• Spearheaded year-end inventory valuation and reconciliation process
Voir plus

The Royal Victorian Eye and Ear HospitalApril 2019 - October 2019

The Royal Victorian Eye and Ear Hospital is a specialist public teaching hospital in East Melbourne, Australia. It is the only hospital in Australia which specialises in both ophthalmology and otolaryngology.
Responsibilities:
• Business partnering with senior budget managers to agree the budget for 2019/20.
•Uploading the budget for 2019/20 onto Great Plains and power budget.
• Posting month end journals and providing commentary for the month end board pack
Voir plus

Britbet Racing LtdNovember 2018 - February 2019

Britbet is a partnership of 55 British racecourses, delivering an improved pool betting experience to racegoers and operating a number of on-course betting shops.
Responsibilities:
• Ownership of management accounts including the Profit & Loss with variance analysis and Balance Sheet, calculations and reconciliations for Accruals, Prepayments, Fixed Assets and Revenue Recognition including commentary.
• Managed 2 Accounts Assistants, including recruitment.
• Posted the sales journals for all sites and races.
My Achievements
• I set up the process in order to produce the Income Statement for 55 racecourses across the UK.
• I set up processes for the Balance Sheet, this included reconciliation, investigation and ation.
Voir plus

Equilibrium Financial ManagementJuly 2018 - November 2018

Provided financial consultation to the following companies:
Bull and Dagger , The UK's First Genderqueer Fashion Label. Queer, androgynous, trans, non-binary, gender free, fluid, neutral & non-conforming. http://www.bullanddagger.com
iTechSupport , Itech Support is an experienced team of IT Specialists, dedicated to making YOUR IT work for YOU. We provide nationwide support services against agreed service levels to ensure all your needs are met.
Voir plus

Antenna International LtdNovember 2017 - June 2018

Antenna Audio are international innovative story-makers and creative technologists devoted to visitor-first experiences. They make and retail audio tours, mobile apps, multimedia guides, podcasts, interactive and superior story-driven content for the museum, cultural and travel sectors. In partnership with these clients, Antenna delivers an immersive, indelible experience to more than 80 million people across the globe each year.
Responsibilities:
• Ownership of management accounts including the Profit & Loss with variance analysis and Balance Sheet, calculations and reconciliations for Accruals, Prepayments, Intercompany recharges, Fixed Assets and Revenue Recognition including commentary.
•Management of Work In Progress and Transfer Pricing to accurately recognize the cost and asset value of work done by the technology teams.
•Capitalisation of technology expenses including work in progress calculations using timesheets and salary rates.
• Provided guidance and information in the year-end audit regarding EMEA Financial Information.
• Revenue recognition business partnering with Account Managers and Commercial Director to commentate and analyse on variances against budget and ensure revenue accuracy, compliant with IFRS 15.
My Achievements
• I made process improvements for Revenue recognition by Business Partnering with Commercial Director and Area Managers across the UK and using Salesforce I learnt how to check headcounts against take up rates to check what the revenue should be based on the information. I then compared the revenue as entered by the Finance Analyst against my Calculations using Salesforce and discussed my findings with the Area Managers. This process then ensures Revenue accuracy and Commentary for any Variances which occurred against Budgets and Actuals.
• I set up the Balance Sheet reconciliation process which was not done previously, this involved having to look over balance sheet transactions including prepayments, fixed assets, accruals, payroll and VAT for several years and investigate them in order to identify the transactions and what needed to be cleared, moved and written off.
Voir plus

Pascall + Watson LtdApril 2017 - November 2017

An international architectural professional services firm, ranked 30th in size by the AJ100 and regarded as one of the largest aviation architectural practices in the world. The company has 6 offices around the world.
My responsibilities:
• Manager of the international finance function, managing the finances for UK, Ireland, Abu Dhabi and Doha. Including hiring, management and mentoring of team.
• Produced and sent out electronically the monthly financial pack and annual reports with KPI’s to identify results, trends, and financial forecasts within tight time deadlines.
• Participated in the monthly board meeting to discuss financial performance and position and improved the information by liaising with directors and meeting reporting requirements.
• Managed management accounts including the Profit & Loss, Balance Sheet and Cash Flow with calculations and reconciliations for Work In Progress, Accruals, Prepayments, Journals, Intercompany, Fixed Assets and Revenue and Cost Recognition.
• Business Partnering throughout the company with a variety of senior stakeholders in financial duties, such as costing for Heathrow Airport. To do this effectively I built good professional relationships with directors and other colleagues.
• Managed the financial plan and budgeting process for 2018, forecasted monthly by liaising with senior stakeholders.
• Improved the management accounting and other processes in order to report more accurately and time effectively.
• VAT returns for UK and Ireland offices.
• Produced ad hoc reports and financial information for the managing director and other colleagues when needed including PAYE and Office for National Statistics returns.
My achievements
• Originally the board received the Monthly Management Accounts Pack on the day of the board meeting. I felt this was not productive as it gave no one time to the Senior Stakeholders to analyse the Financial Information prior to the meeting. Using my Excel knowledge I interlinked the graphs with the P&L, Balances Sheet and Cash Flow Statement saving time. I also informed the team of my expectations and gave them clear and defined goals in advance and explained why the change was needed. I also started finalising the pack in PDF format in order to send out the packs electronically. After getting the Management Accounts Pack ready on a monthly basis I would review the figures with the Managing Director and once everything was confirmed I would send out the pack to everyone who was attending the Board Meeting and other Stakeholders. Together as a team we saved 2 working days off the time taken to produce the pack.
Voir plus

BPI (British Recorded Music Industry) Ltd & BRIT Awards LimitedDecember 2016 - April 2017

Contract Role                                                                 
BPI res the UK’s recorded music industry, which is one of the most exciting and thriving music sectors in the world. The Brit Awards are the British Phonographic Industry's annual pop music awards
My responsibilities:
• Second in line in finance function supervising two Management Accountants for BPI Ltd through the year-end audit process and producing the Statutory Financial Statements.
• Liaising with auditors to ensure annual monitoring is carried out.
• Business Partnering throughout the company in financial duties.
• Producing Management Accounts and Balance Sheet Reconciliations for several companies.
My Achievements:
• My biggest project was to reconcile the VAT for the last 3 years as there were discrepancies when comparing the GL to what was submitted to HMRC. I downloaded a current transaction listing and searched for and compared this with VAT transactions in previous returns. This was then used to discuss with HMRC the difference and pay the difference in order to be VAT compliant. The underpayment over the last 3 years amounted to around 20k and interest.
Voir plus

ABTA LtdAugust 2016 - November 2016

Contract Role                                   
ABTA is the UK’s largest travel association, reing travel agents and tour operators that sell £32 billion of holidays and other travel arrangements each year. A trusted travel brand for more than 65 years, offering advice and guidance to the travelling public, as well as leading the travel industry in supporting high service standards, working with our Members on health and safety, and promoting responsible tourism at home and abroad. The group included Lifeline, a charity.
My responsibilities:
• Managing the Finance function with two Assistant Accountants for ABTA Ltd through the year-end audit process and producing the Statutory Financial Statements.
• Liaising with auditors to manage the annual audit is carried out and produced the statutory accounts at year end for 2 companies.
• Partnering with HR managing the outsourced payroll function and posting the monthly payroll journal.
Voir plus

Leicht Contracts UK Ltd and Enclosure Interiors LtdJanuary 2015 - July 2016

Leicht Contracts UK Ltd is a new subsidiary (established 2014) of the German number 1 selling premium kitchen furniture manufacturer. Enclosure Interiors specialize in promoting and designing LEICHT, who have been manufacturing kitchen furniture for over 80 years from their factories in Southern Germany.
Turnover £10M, Permanent Position
• Manager of the Accounting Function for two companies Leicht Contracts UK Ltd and Enclosure Interiors Ltd which includes managing the Accounts Payable and Receivables including credit control departments including the hiring and managing of accounting employees.
• Responsibility for Cost of goods sold, inventory and margin control.
• Meeting with the Managing Director and Commercial manager to provide and interpret financial information, discuss the profitability of the two companies as well as each individual project and forecasting the profit and loss for the future based on the financial period and each project.
• Strategic planning to ensure the company can sustain the significant growth it is undertaking, Liaising with the sales and operations department to obtain information regarding the status of projects to ensure invoices and payments are done efficiently and effectively.
• Weekly cash flow forecasting for receivables and payables in order to ensure payments to suppliers can be done on time and to find areas which would cause cash flow difficulties.
• Business partnering duties with customers and suppliers in order to maintain a competitive advantage in a fast growing company. Developed systems and procedures to ensure correct data information exchange, including analysis and identification of information requirements and coordination of activities.
• Responsible for all HMRC requirements consisting of tax matters, statutory records and VAT compliance.
• Assistance with legal and HR matters on an ad hoc basis.
My Achievements
• Systems and Process implementation on SAGE 200 for all accounting processes for both Leicht Contracts and Enclosure Interiors including Accounts Payable, Receivables and month end reporting which includes VAT analysis, Management Accounting, Budgets, Forecasting, Fixed Assets, Intercompany transactions, Stock, Prepayments and Accruals.
• Strategic suggestion that fitters should not be paid a day rate and instead receive a quote per kitchen fitted saving and controlling the costs for kitchen fitting significantly
• Strategic suggestion to include within the initial agreement with customers that payment should be made on the original timeframe of the projects accepted at commencement which significantly improved cash flow.
• I business partnered and liaised with the sales, procurement and project managers within the company for several reasons including cash flow forecasting, profitability forecasting and obtaining accurate valuations to send to customers for payment.

Royal Veterinary CollegeJune 2014 - January 2015

Canon IncDecember 2012 - December 2012

Hyundai Motors New ZealandMay 2012 - September 2012

Voir plus

Orygen Youth HealthOctober 2011 - January 2012

Orygen Youth Health (OYH) is a world class facility for the comprehensive treatment of young people experiencing a first episode crisis in mental health. Reporting directly to the Chief Financial Officer I undertook the following duties:
• Prepared project reports for several projects.
• Oversaw the Petty Cash and Cash Advance for the company, this included allocating money to various parties within the organisation based on general petty cash expenses, payments for Neurapro main and Trauma which are certain projects within Orygen,
• Managed the Prepayments for the company, this included allocating expenses to the correct months by creating an excel spread sheet to assist in allocation and posting journals on great plains allocating the expenses to the correct months,
• Assisted in preparing the board reports for the quarter, this included calculating and entering onto the board report excel spread sheet the opening balances, closing balances, sales and expenses based on infrastructure and other expenses.
• I entered data onto the income schedule for all projects which included expected incomes and revenues, the commencement and closing dates of projects, the type of projects based on committed and un-committed.
• I undertook the fixed assets reconciliation which included entering onto a excel spread sheet the assets cost, opening balances and depreciation by month.
Voir plus

Gilead SciencesApril 2011 - October 2011

Turnover $24B, Temporary Contract
Gilead Sciences is a leading biopharmaceutical. Reporting to the Finance Director for Gilead Sciences Australia and New Zealand I undertook the following duties:
• Prepared balance sheet reconciliations for several accounts this included reconciling on excel  and downloading data from JD Edwards for the GST Payables, accounts receivables and payables, fixed assets, this also involved calculating the depreciation for fixed assets to be recorded as an expense in the income statement,
• Oversaw the prepayments for the company, including keeping a track of all new prepayments on Excel and  allocating expenses to the correct months by posting a journal on JD Edwards,
•Managed the intercompany cross charges, creating and sending regular invoices to other subsidiaries in US and Ireland,
• Calculated the Fringe Benefit Tax for each employee on an excel spreadsheet for my manager to lodge a return and pay the FBT payable to the ATO.
• Weekly bank reconciliations for the Australian and New Zealand subsidiary and cash flow statement which was done on Excel showing the cash flow for payable, receivables,  for both the Australian and New Zealand subsidiary and sent out to the International main subsidiary in Ireland,
• Processed Personal Expenses for employees, which included ensuring the expense thresholds were met and all receipts were uploaded correctly to the STAR system, this also included correct allocation of GST amounts.

Euro Car PartsJune 2010 - February 2011

Camden Primary Care Trust, St Pancras HospitalSeptember 2009 - February 2010

Motor Fuel Group PlcSeptember 2008 - September 2009

Mes compétences

TensorFlow, SQL, Scikit-Learn, SAP, Salesforce, SAGE, Python, PyCharm, Pandas, MS Office, Microsoft Excel, Matplotlib, Keras, Jupyter, GitHub, Financial Management, Financial Accounting, CRM