Learn Data Skills
Beta
Ravi Jethwa

Ravi Jethwa

Data Manager

Ralph Lauren

Technologies

My Portfolio Highlights

My New Project

Analyzing Students' Mental Health

My New Course

Introduction to SQL

Champion of data integrity, ensuring accuracy in the age of information overload.

My Work

Take a look at my latest work.

project

Analyzing Students' Mental Health

course

Introduction to SQL

course

Intermediate SQL

course

Introduction to Snowflake

Snowflake

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Microsoft Power Bi Data Analyst PL-300

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Ralph Lauren | Feb 2023 - Present

Data & Insight Senior Manager (EU)

- Lead, develop & manage a team of analysts - Working directly with senior leadership team & introducing them to new data insights - Defining & delivering a data strategy - Building a centralised data repository to enable better reporting - Partnering with BI & Data Science teams to create the foundations of future reporting
Show More

Ralph Lauren | Jul 2021 - Feb 2023

Data & Insight Manager

- Working with key stakeholders to create a reporting suite for corporate & stores - Extracting data from internal data warehouses - Building dashboarding tools for analytics - Automation of manual reporting, enhancing output & giving back time to teams - Working with IT & BI teams to create new metrics within the back end system which can be used by the whole business for reporting - Expanding the team with new analysts to provide insights to a wider audience - Training new team members

Marks and Spencer | Feb 2017 - Jun 2021

Insight & Analytics

Working as part of the Insight & Analytics team to provide data in a new & refreshing style. - Redifining logistics KPI's for teams - Analysing old reports within logistics to define new reports - Developing reports within Spotfire and Power BI - Extracting core data for users & working with them to provide actionable data Applications used: • MS Office (Word, Powerpoint, Excel, Access) • VBA • SQL Oracle Developer • Hadoop • Impala • SAP BPM • SAP • Business Objects • Spotfire • EdiTrack • Hive

Marks and Spencer | Sep 2015 - Feb 2017

Data Manager

-TariffTel Implementation Project – Project Manager Cost saving project of £250,000 per annum Past errors in classification codes led to M&S making approx. £3.5M in underpayments of duty to HMRC & approx. £5M overpayments in duty over the following few years. TariffTel was successfully introduced to remove the manual error process & use a system based externally to run product classification -SAP BPM P&D 3 – Project Manager New flow of data through multiple systems to allow for a smooth flowing of product from factory to warehouse to customer. Developing a successful reporting system & scorecard for accurate information overlay post deployment -SAP BPM P&D 4 – Project Manager New updates to SAP BPM interface New user manual created for all worldwide suppliers Responsible for UAT & implementation -Extraction & reporting of data to be used by the regional compliance managers to amend any potential errors made by suppliers in SAP BPM -Extraction & reporting of KPI’s for warehouse audit checks, supplier compliance reporting & supplier league table. Applications used: • MS Office (Word, Powerpoint, Excel, Access) • EdiTrack • SQL Oracle Developer • BPM • Business Objects • Spotfire • VBA

Marks and Spencer | Aug 2014 - Sep 2015

Logistics Analyst

FSV to FOB Conversion Project Supplier System Update Project • Working in unison with the team to produce reports for the company helping to change suppliers from Free Service Vendor (FSV) to Free on Board vendors (FOB). • Creating and updating reports looking into the current production of stock in supplier factories. • Working with suppliers creating rundown plans of stock in the supplier warehouse that needs to be allocated out before the warehouse closure. • Working with the merchandising, buying and allocation teams to order all stock before factory closure. • Working with regional offices to train suppliers in the new systems they will be using (BPM, Pack Spec) • Training all UK suppliers in compliance related systems • Tracking worldwide supplier training updates/ presenting updates to regional teams • Validating data for suppliers before switching suppliers • Creating debit notes for suppliers who have failed compliance measures • Dealing with supplier query’s relating to past debit notes Applications used: • MS Office • Sales and Stock (SAS) • MAS • EdiTrack • Business Objects • BPM • SAP

Debenhams | Mar 2011 - Dec 2013

Allocator

• Handles stock distribution for a department of china across 150 UK stores and around 52 international stores which is more then million pounds business. • Analyzing sales, trends and performance of the business vs last year and plan using reports made through business objectives. • Reporting to the merchandiser and finance team for the intake and sales analysis. • Reporting sales, stock intake and gross profit margin to finance team on weekly basis. • Forecasting of sales and analyzing how much stock will be required for fulfilment of the stores seasonally. • Make sure stock allocation process is right and it is being allocated where its need the most. • Analyzing store performances and stock holding, assign grading to stores on seasonal basis. • Creating budgets for the new season lines and forecasting sales for the quarter through past sales histories and store analysis. • Strategies for the key running lines to be performing weekly. • Raising supplier orders and invoice checking. • Analyzing the stock turnover and lead times from the supplier. • Checking reports for total stock received in dc against the allocation to the stores and taking actions. • Discontinuing old lines which are not performing to protect profit margins. • Compiling weekly sales report. • Reviewing stock files and reconciling stock data at month end.

My Education

Take a look at my formal education

BS, Mechanical EngineeringQueen Mary University of London | 2010
A-levels, PhysicsRegents College | 2007

About Me

Ravi Jethwa

Here to refresh old skills and learn new skill sets

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free