James Bartlett Email & Phone Number

London, Gb

London, Gb

Sprint Management: Revolutionised the Financial Audit Data Analytic team’s sprint process to empower 10-15 members of staff to contribute, increasing the number of implemented suggestions from 12% to 75%.Strategic Planning: Co-ordinated with 3 teams across the office to create the office’s Data Analytics roadmap for the next 2 years. Cloud Platform Projects: Managed the project to establish the office’s first ETL platform hosted in the cloud, used to digest general ledger data and processed over 100 million rows of data across over 350 clients.Stakeholder Engagement: Developed an automated report to share with senior stakeholders, providing a progress update for the 15+ ongoing projects planned over the year.Performance Coaching: Coached 4 junior colleagues to improve skills and achieve promotion.Project Management: Scheduled 5 projects simultaneously, allocating resources and adopting an agile methodology to ensure success.Team Management: Directed 10 colleagues in project allocation, using personal development as a factor in determining best approaches.App Development: Influenced the Development lead in managing customer expectations for 5 projects, managing stakeholder communication and assisted in implementing an effective system of project governance.Delivering Training: Hosted a suite of training sessions to the whole Financial Audit Service line (approximately 600 members of staff) to prepare auditors for the new data analytic tools released.Financial Planning: Proposed and monitored spend against six annual budgets for the team for three consecutive years.Machine Learning: Established and led the office’s first Machine Learning working group to identify opportunities for Machine Learning in Financial Audit using existing tech stack.

London, Gb

Starting as an Assistant Auditor as part of the NAO's graduate accountancy scheme working to gain the ACA qualification. As my experience has developed over the years, my portfolio has expanded culminating in leading two significant audits with complex risks.Some of my main achievements include presenting the NAO awards, an internal event where we celebrate the colleagues’ successes across the office.Main Responsibilities:To assist in the planning on a public body's interim and final auditTo assist in multiple public bodies' interim and final auditTo assist in the creation and development of Value for Money (VFM) studies on public bodies.

Main Responsibilities:To decide what product ranges to be added onto the website, based on statistical trends from Google Analytics.To decide which products and ranges to promote on the Homepage, such as special offers, product launches or current trends.To manage the SEO campaign for the website, including meta-tags, meta-descriptions and meta-keywords to improve the website’s ranking on Google searches.To create and manage E-mail marketing campaigns for both Toys-UK and John Sanders to send to customers highlighting seasonal promotions and special offers.To monitor Google Analytics data to identify behavioural trends and metrics such as acquisitions, geographical locations and devices.To organise the website’s layout to make the customer’s journey as simple as possible.To organise and generate both Toys-UK’s and John Sanders’s Social Media presence on Facebook and Twitter.To manage day to day IT requirements for John Sanders.To maintain Amazon Product Listings and ensure upload processes are kept up to date.To maintain for all media content for John Sanders & Toys-UK for promotional events.To ensure a consistent look when generating email, web and social media content.Main AchievementsCo-Organised a High Street Wide Event to encourage customers to return to the High Street after extensive roadworksPlanning the social media campaign to keep customers up to date with the latest High Street Event NewsEstablished a social media platform for Toys UK and John Sanders to publicise the latest offers and eventsEstablished and managed the selling of products on Amazon through its Merchant Seller Central system, integrating the new systems with the existing website ordering operation.Oversaw the implementation of upgraded EPOS tills in September 2015

Jp

My Responsibilities included:Refreshing a series of reports created by macros in Microsoft Excel by downloading data from the CRM Software database.Updating Excel spreadsheets to manage and track COB invoices from the factory to match customer activity.Updating Balance Sheets to reflect monthly adjustments for Strategic Accounts and Professional Services.Preparing and posting journals for the Strategic Accounts, Major Accounts and Professional Services Business Areas.Preparing and submitting the Demand Planner forecast - a rolling four month forecast to be submitted to the factory.Preparing and submitting the Global Account figures (Revenue, Cost and Margin) to HQ on a monthly basis.Preparing the Consolidated Actuals file - a file that collates the months results by Month, Customer, Product Category and ProductCreating Profit and Loss Accounts on a monthly basis for the multiple departments including Professional Services, Approved Service Provider and Service Plus. Main AchievementsWrote macros for different colleagues to:Automatically send out 200 emails to resellers whilst attaching the reseller specific attachmentReduce the file size of the COB from 200MB to 5MB whilst maintaining the quality of data.Re-organise Excel Pivot table to allow easier extract of data into other reports.Create an Excel Reporting file for the Programmed Managed Accounts team to independently look up their current sales figures.Led a project to update the financial reporting software (EBIS), ensuring all financial reports used by the finance team continued to be used uninterrupted over the 2 week transition period.Redesigned the reporting files used for the Managed Services department at month end to improve efficiency by using formulae and pivot tables whilst maintaining the breakdown by cost centre, customer and product category.

Responsible for training new staff members and assisting in the day-to-day account operations.Training Responsibilities included:Fire Tours, Health and Safety, Retail Regulations, Cash Handling Systems, Department and Store Systems, Delivery Procedure and Telephone Systems.Adding and changing information on the Back Office such as including products, suppliers, staff members, discount schemes and adjusting stock quantities based upon goods delivered.Retrieving Store sales figures for past or present days takings in order to assist with any queries that may have arisen.Advising other members of staff regarding problems that occurred such as part payments, malfunctioning software, refunds and exchanges.Main Achievements:Undertook a project in the summer of 2012 to work on the stores toy website (www.toys-uk.co.uk) using Search Engine Optimisation (SEO), increasing the flow of traffic from 1,329 visits to 10,377 visits per month over a three month period.

My workload increased as I had more time available during A-Level Studies, and was trained to use Sage MMS to assist the finance team.Day-to-Day Accounting Responsibilities included:Input of Weekly Sales and ExpensesInputting Invoices and Credit Notes from SuppliersAllocating expenses to departmentsPaying Suppliers to meet credit terms or receive settlement discounts

Sales Assistant Responsibilities included:Goods in procedure, including the pricing and merchandising of the itemsCash Handling systems including till floats, change and collections for the tillsCustomer Service for both Sales and Refunds and any other adjustments or requirements

Aca, Accounting

Bachelor Of Science (Bsc), Business Management (Accounting) With Placement Year

Education record