Mandip Nijor
Group Data & Systems Analyst at SSP Group plc- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
-
Punjabi -
-
Hindi -
Topline Score
Bio
Sagun Malla RNutr
Mandip is always keen to share his knowledge and teach, he has helped me with understanding Power BI and is always willing to help. He has great problem solving skills and I can approach him with any issues.
Owen Smith
Mandip is one of the best in class when it comes to data analysis and actionable insights. His attention to detail is next to none and the data provided by Mandip often influences business decisions that will drive profit and success. His knowledge of SQL, Power BI and ability to investigate numerous data sources with a positive attitude is what makes him stand out and essential to any team.
Sagun Malla RNutr
Mandip is always keen to share his knowledge and teach, he has helped me with understanding Power BI and is always willing to help. He has great problem solving skills and I can approach him with any issues.
Owen Smith
Mandip is one of the best in class when it comes to data analysis and actionable insights. His attention to detail is next to none and the data provided by Mandip often influences business decisions that will drive profit and success. His knowledge of SQL, Power BI and ability to investigate numerous data sources with a positive attitude is what makes him stand out and essential to any team.
Sagun Malla RNutr
Mandip is always keen to share his knowledge and teach, he has helped me with understanding Power BI and is always willing to help. He has great problem solving skills and I can approach him with any issues.
Owen Smith
Mandip is one of the best in class when it comes to data analysis and actionable insights. His attention to detail is next to none and the data provided by Mandip often influences business decisions that will drive profit and success. His knowledge of SQL, Power BI and ability to investigate numerous data sources with a positive attitude is what makes him stand out and essential to any team.
Sagun Malla RNutr
Mandip is always keen to share his knowledge and teach, he has helped me with understanding Power BI and is always willing to help. He has great problem solving skills and I can approach him with any issues.
Owen Smith
Mandip is one of the best in class when it comes to data analysis and actionable insights. His attention to detail is next to none and the data provided by Mandip often influences business decisions that will drive profit and success. His knowledge of SQL, Power BI and ability to investigate numerous data sources with a positive attitude is what makes him stand out and essential to any team.
Credentials
-
UK Skills 16-Week Front End Web Development
Trilogy Skills Bootcamp in Front-End Web DevelopmentMar, 2023- Nov, 2024 -
Certified Internet Webmaster
CIW
Experience
-
SSP Group plc
-
United Kingdom
-
Food and Beverage Services
-
700 & Above Employee
-
Group Data & Systems Analyst
-
Apr 2023 - Present
Creating a new strategic analytics platform; firstly by gaining a full understanding of the business processes and stakeholder requirements, followed by identifying cutting-edge technologies and building a high performing team. Working with colleagues in over 36 countries and over 550 brands, to manage both local and global reporting, as well as ad-hoc business-critical requirements. Also responsible for the data governance and data quality across the group. Creating a new strategic analytics platform; firstly by gaining a full understanding of the business processes and stakeholder requirements, followed by identifying cutting-edge technologies and building a high performing team. Working with colleagues in over 36 countries and over 550 brands, to manage both local and global reporting, as well as ad-hoc business-critical requirements. Also responsible for the data governance and data quality across the group.
-
-
-
Marks and Spencer
-
United Kingdom
-
Retail
-
700 & Above Employee
-
Technical Compliance Analyst
-
Apr 2022 - Apr 2023
Developing a new systematic approach to how M&S sources its food products from around the world and manages the key due-diligence information. Collaborating with internal and external stakeholders at all levels to ensure the new processes are in line with the business requirements, cost effective and sustainable. Creating API’s to ingest the data in-house as well as taking ownership of the Power BI reporting. Creating new reports and dashboards by sourcing both new and existing data from various platforms which brings new insight into the business with clear actions. Show less
-
-
Commercial Reporting Analyst
-
Jun 2021 - Apr 2022
As part of the ‘Digital and Data’ transformation programme, creating robust and accurate reporting across the Clothing and Home business. Investigating business problems and providing insight as well as telling stories through the data. Making recommendations to the stakeholders to improve business performance. Operating in a fast paced and agile environment. Tools used: Power BI, DAX code, DAX Studio, M Code, Power Apps, Power Automate, SQL (Impala, db2, T-SQL), Aqua Data Studio, Hue, Azure Data Studio, Synapse, Starburst, Databricks, Business Objects (SAP), SQL Server Management Studio, Python, R, and more. Show less
-
-
-
Sainsbury's
-
United Kingdom
-
Retail
-
700 & Above Employee
-
Reporting Analyst
-
Oct 2020 - Jun 2021
Across Sainsbury’s group; responsible for capturing, standardisation and storage of technical data, as well as creation of valuable dashboards and insights. Variety of systems, processes and data visualisation tools used including; Cloud data storage, Power BI, MicroStrategy and Advanced Excel. Integration of data and visualisations into virtual tools, such as MS Teams to share with teams across the group.
-
-
Data Lead - Food
-
Dec 2019 - Oct 2020
Creating and delivering systems and processes to ensure all stakeholders (both internal and external) receive the required data with actionable insights, in order to carry out the operational needs of the business. Weekly, periodic, quarterly, and annual KPI packs for the category teams. Integration of systems, processes, and data feeds across all Sainsbury’s businesses in order to drive better insights and maximise sales opportunity, ensuring all safe and legal requirements being met. Continuously working on several projects to enhance data feeds and drive better insights, in order to streamline operations to become the multi-channel destination retailer. Show less
-
-
Fresh and VAF Business Unit - TA
-
Mar 2017 - Dec 2019
Supporting the Fresh and Value-added foods business units to maximise sales and profit, whilst ensuring the end customer receives the best quality possible product which is safe and legal. Set-up of systems, processes and reports for the cross-functional teams. Led and implemented the digital display handset trial in stores project with retail, central and technology teams to replace the printed specifications with the digital versions, potential saving circa £210,000 per annum. Supported the logistics project to streamline transit trials which resulted in cost savings of circa £50,000 per annum. Show less
-
-
Product Owner
-
Aug 2018 - Jun 2019
Worked on the multi-million-pound revenue project, in order to implement a new CRM system as well as improving the process flow. Daily scrum meetings, sprint reviews and planning sessions. Created and updated user stories in the JIRA system. Identified the issue of missing data and worked with the team to implement the solutions in order to ensure correct data flow to all stakeholders. Worked through the backlog to continuously improve the outputs from the system, whilst gathering inputs from all internal and external stakeholders. Phase 1 of the project completed on time and within budget with phase 2 starting in early 2020. Phase 1 of the project has added circa £1.6 million to the bottom line as well as improving the visibility of the data to the relevant stakeholders. Show less
-
-
Fresh Produce - TA
-
Aug 2009 - Mar 2017
Project lead for circa £1 million per annum Sainsbury’s Brand quality assessment system and phased delivery of this system into different categories. Designed and developed customer complaints trending database for the head of business unit. Worked alongside Product Technologists, Technical Managers and Product Quality Inspectors to agree product specifications with suppliers to ensure customers get the best quality products all year round. Planning and successfully executing 3 annual international supplier conferences. Colleague Council representative. Show less
-
-
Business Analyst – Digital & Technology
-
Aug 2014 - Sep 2015
Gathered and prioritised business and stakeholder requirements in order to improve existing as well as implement new processes and systems. Both agile and waterfall methodologies used depending on the scope of the project. Adherence to the MOSCOW model in order to prioritise functional and non-functional requirements for online delivery pass. Various other NDA projects completed on time and within budget.
-
-
Product Quality Inspector
-
Jan 2007 - Aug 2009
Designed and developed an electronic database to store all quality inspection reports across the team to ensure data consistency and ease of reporting. Designed an intranet portal to upload specifications to share with field-based teams saving circa £25,000 per annum. Ensured only fresh quality, safe and legal products are delivered to stores by rejecting the non-conforming products. Trained and mentored 2 new colleagues as well as 8 graduates. 3-month secondment in Holborn store support centre in order to implement a product reports database. Promoted to higher grade. Show less
-
-
-
London Organising Committee of the Olympic and Paralympic Games
-
Olympic Park - London
-
London 2012 Paralympic Games Maker
-
Aug 2012 - Sep 2012
Represented Sainsbury’s at Paralympics 2012 as an official Games Maker. Volunteered in the Basketball Arena ensuring the swift running of the players transport in order for them to arrive in the arena in time for games as well as arranging their transport back to their accommodation. Personally recognised by Prime minister at the time David Cameron and Sainsbury's CEO at the time Justin King for my service. Represented Sainsbury’s at Paralympics 2012 as an official Games Maker. Volunteered in the Basketball Arena ensuring the swift running of the players transport in order for them to arrive in the arena in time for games as well as arranging their transport back to their accommodation. Personally recognised by Prime minister at the time David Cameron and Sainsbury's CEO at the time Justin King for my service.
-
-
-
CHINGFORD FRUIT LIMITED
-
1 - 100 Employee
-
Quality Control Officer
-
Feb 2004 - Dec 2006
Responsible for the quality and legality of Sainsbury’s and Somerfield fresh produce products. Correct logging of QA reports and ensuring correct specifications are available for inspections. Working with cross-functional teams to out-perform business targets. Designed the blue-print for digital QA system which was later implemented and integrated with Sainsbury’s systems. Responsible for the quality and legality of Sainsbury’s and Somerfield fresh produce products. Correct logging of QA reports and ensuring correct specifications are available for inspections. Working with cross-functional teams to out-perform business targets. Designed the blue-print for digital QA system which was later implemented and integrated with Sainsbury’s systems.
-
-
-
Asda
-
Retail
-
700 & Above Employee
-
Customer Sales Assistant
-
Jun 1998 - Feb 2004
Part-time role whilst studying. Day-to-day running of the beers, wines and spirits department as well as assisting in other areas of the store as and when required. Product availability and sales targets met each period. Acquired extensive training and skills resulting in long-term passion for meeting as well as exceeding customer expectations. Part-time role whilst studying. Day-to-day running of the beers, wines and spirits department as well as assisting in other areas of the store as and when required. Product availability and sales targets met each period. Acquired extensive training and skills resulting in long-term passion for meeting as well as exceeding customer expectations.
-
-
-
BRITISH BAKERIES LIMITED
-
1 - 100 Employee
-
Operations Assistant
-
Jun 1996 - Jun 1998
Part-time role whilst studying. Worked in operations team carrying out numerous duties including: production, quality assurance and despatch. Part-time role whilst studying. Worked in operations team carrying out numerous duties including: production, quality assurance and despatch.
-
-
-
Wimpy International Ltd
-
Restaurants
-
100 - 200 Employee
-
Restaurant Assistant
-
Aug 1995 - Jun 1996
Part-time role whilst studying. General duties around the Wimpy restaurant, including coordinating customer orders, serving and hygiene. Part-time role whilst studying. General duties around the Wimpy restaurant, including coordinating customer orders, serving and hygiene.
-
-
Education
-
London Metropolitan University
BSc Hons, Computing and Information Systems -
North Highland
Business Analyst (BA) Skills Requirements Management, Business Analysis -
WINS - Practical Negotiations
WINS - Practical Negotiations, Business Management -
Top Choice Computing Careers
Postgraduate Diploma, Web/Multimedia Management and Webmaster -
Bexley College
City & Guilds Advanced Diploma in Computing, Computer Science