PROCESS OPTIMIZATION AND AUTOMATION IN E-COMMERCE BUSINESS OPERATION

Mister Sandman is an ecommerce start-up company located in the heart of Berlin, Germany. It is an online mattress & bedding company, selling products both on their own as well as 17 other marketplaces across Europe. I have successfully completed 6 months of my internship with the company. It was really an amazing experience here to work and learn. This journey has been very informative, interesting, and important on all scales. I was entrusted with various projects and tasks and actively worked on data collection, cleaning, manipulation, preprocessing, visualization, analysis, and automation of various tasks in the company's ecommerce platform and marketplaces. In the beginning, I was trained to understand the end to end working mechanism of day to day operations. My goals and areas of contribution were precisely put forward to me which empowered me with focus and clear vision. I then utilized my knowledge from the university and past experience of work at Amazon to support them in an efficient way. I made an analysis on Pricing, Rebate, Shipping, Ratings & Reviews, Inventories, Visibility, Orders & Sales and worked on to optimize and automate the process using various techniques of python skills. I also learnt and used other technical skills and languages to execute the tasks along with Python such as SQL, Macros, Tableau and Power BI tools depending on the requirements. I also make different reports for the orders & sales - weekly and monthly using various analysis and visualization tools and contributed to understand the development and improvement areas for the business to grow and continue serving our customers the best way.