Mitesh Nagar Email and Phone Number

Working in the information team within the commercial department to provide UK wide reporting, analysis and work with key stakeholders to gather requirements and produce reporting in new areas using innovative solutions especially in Power BI and SAP Business Objects. Key parts of the role include producing the monthly period reporting, assisting with tender exercises with analytical support & pricing, managing projects for new reporting including building datasets, reports & dashboards in Power BI and dealing with FOI & ad-hoc requests.Refined processes of period reporting, creating & updating process documents to ensure key reporting is produced to a consistent standard with transparency.Analysed HR staffing data as part of a tender exercise, identifying trends & data quality issues, raising queries and feeding back to the business.Automated reports in SAP Business Objects to allow for future scheduling.Replaced manual Excel processes with a click & refresh process in Power BI saving on FTE/resource for Board Papers.Created and managed Microsoft Teams Groups and Channels to allow for the exchange of information throughout the business at different security levels.

Reporting to the Sales & Marketing Director, my role was comparable to that of an analyst in the following areas: data, reporting, commercial, insight and financial. Heavily focused on improving current reporting methods & internal processes, providing new reporting solutions and managing data coming in from various sources to provide the national account managers and marketing team with a greater insight on how products are performing, identifying trends and advising on how performance could be improved. A key part of the role was also to analyse sales data of our portfolio of products and the wider market (using IRI) to provide a greater insight of how certain categories are performing and understand the key areas of growth to push the business forward.Built an Excel based dashboard, within a month of starting, that utilised invoice data, from Sage, to provide a greater insight of how the business was performing vs budget for all brands for key accounts.Managed costing models for the business and improved by thoroughly checking each component of the model and correcting any historical errors.Created new and updated existing reports/templates that are widely used by the business to provide a greater insight as to how our products perform in different types of stores, across selectable time periods for major customers. Also added macros to current reporting to reduce time spent on producing reports by 85%.Created datasets which were suitable to be imported into Power BI and created various reports including a map of where we have our greatest sales and more importantly, where we have little or no sales.Updated, improved & managed various internal processes including raising Purchase Orders, Forecasting and Planning. Also managed sales and marketing budgets (including P&L and building budgets bottom up) whilst providing simpler, more useful financial reporting to external clients.

Essentially provided accurate management information across the business through interrogating the data warehouse using MicroStrategy; business intelligence software that allows users to create & automate reports, documents and dashboards. Role involved producing and running reports on an ad hoc & month end basis, updating & creating dashboards, resolving queries and updating & distributing monthly packs whilst also scoping potential projects to provide reporting requirements in new areas of the business. Completed MicroStrategy based training courses in Overview of Enterprise Analytics, Reporting & Visualizations, Advanced Documents & Reports and Advanced Analytics.Redesigned and automated an Excel based dashboard, which was updated monthly and distributed across the business including senior management and directors.

Worked in the Data Management department within Data Commercial whilst also forming under the Continuous Improvement category; my role involved producing various daily, weekly and monthly reports, using a wide array of transactions and tables in SAP; which is then extracted from SAP into Microsoft Excel to allow for the data to be manipulated. Once I quality assured the data, using techniques such as sorting, filtering, de-duping and formatting, errors would then be sent to the relevant departments to be rectified. An on-going part of the role was to maintain the integrity of the data in SAP and ensure any errors are corrected.• Participated in a six month project in relation to the Government Buying Standards (GBS), by which the entire database of products had to be validated by suppliers to ensure that specific information about each product was populated in SAP.

Supported buyers heavily through administration and managing suppliers in addition to communicating with supply chain and marketing. Role involved maintaining suppliers, setting up new products, maintaining products (delisting & relisting), dealing with price changes and making products available for promotion primarily using Microsoft Excel, Production G.O.L.D and PASS. The role combined the duties of a trading services administrator, trading managers assistant and the promotions team to allow me to be responsible for my own set of products from supplier through to what Budgens and Londis receive in their shops.Communicated with supply chain, buyers, marketing and suppliers to set up deals that appear in the weekly promotional leaflets.Kept CRM queries to a minimum by resolving them quickly and to the best possible standard to meet targets using Microsoft Dynamics CRM.Completed a variety of important tasks including: Raising credits, building promotions, proof reading leaflets and pulling daily VERA and weekly PLCL reports to ensure the spirits category was well managed and pricing for my products were keyed correctly with any errors rectified.Improved time management skills by prioritising workload given the wide array of tasks and deadlines.

Worked in the promotions team within the trading services department and used Microsoft Excel and Production G.O.L.D, extensively, to create promotion plans; which consist of inputting product codes and linking them to the relevant suppliers whilst also updating the discounts, wholesale, standard and retail sales prices for each product for Londis and Budgens. Role also required amending promotions which included removing, updating and adding products to promotion plans whilst raising queries when the pricing for products was incorrect and communicating within the trading department to resolve these queriesSuccessfully completed promotion plans for Londis Ambient and assisted in the completion of the other five promotion plans for six promotional periods.Improved attention to detail skills by inputting vast quantities of data into the system and subsequently reducing the amount of errors that appear on the validation report.

Ensured the store remained as profitable and busy as ever by providing excellent customer service, ensuring stock is displayed correctly and displaying point of sale (POS) products adequately to maximise sales.Increased the amount of positive customer feedbacks received for the store and subsequently increased customer satisfaction for the store from 43% to 67% by providing a high level of customer service, making customers feel welcome and helping customers with any queries that they had.Showed an eagerness to learn and develop by taking on additional tasks and responsibility. Filed away daily/weekly reports related to cash management and price increases for the store and also learnt how to reduce the price of products and return magazines using a personal digital assistant (PDA).Successfully completed training for age restricted sales, fire safety, food safety and hygiene and specific rules and procedures which ensure a safe working environment.Assisted in the training of new staff, in relation to procedures and ways of working, to provide an insight to the standards of which to complete tasks and manage time effectively to complete tasks within tight timescales.

Assisted the sorting centre in many departments to help keep up with the demands of parcels and letters delivered.Maintained 100% accuracy for sorting letters for various postcodes and also achieved 100% accuracy for sorting parcels for different postcodes.Demonstrated an eagerness to learn and excellent flexibility within a fast paced environment by working in a wide array of departments within the sorting centre including warehouse, letters, parcels, IMP and PPI.

Assisted the mail sorting centre during the Christmas period to help deal with the surge in letters and parcels being delivered during that time of year.Achieved 100% accuracy of sorting letters for HA, NW, UB and SL postcodes on a daily basis whilst gradually increasing speed rate of sorting mail.Remained focussed throughout repetitive tasks for long periods of time, developed communication skills by working with other people in a fast paced environment and enhanced attention to detail skills through sorting vast amounts of mail by postcode.

Provided support to work colleagues when needed. Tasks included inputting invoices in the business’ accounting system, filing documents away and sorting mail.