Sumanta Das

Experience

• 

  Cadbury Ind Limited

  Aug 2013 - Dec 2014

  Assistant Inventory manager

  Sales report & Stock report analysis,Shrinkage Control,Team Management,& Billing Also. Data Entry, Data processing, Data Preparing, Data Clearing and also visualize, Sales report, Stock report & All type reports,Sales planning & P&L statement,Customer service,Shrinkage Control,Inward,Outward, Inventory Management,Plan for future inventory management.E-way bill managementOperations.

• 

  Haldiram Snacks Pvt.Ltd.

  Jan 2015 - Dec 2016

  Inventory Manager

  Data modelling, Data Clearing and also visualize, Sales report, Stock report & All type reports,Sales planning & P&L statement,Customer service,Shrinkage Control,Inward,Outward, Inventory Management,Plan for future inventory management.E-way bill managementOperations.

• 

  Reliance Retail

  Feb 2017 - Feb 2019

  Assistant Store Manager

  Raw data collecting from SAP and same data modifing and cleaning.Operating SAP MM,SAP WM, P2P,INWARD, OPERATION,SALES ACHIEVE, NEW STAFF TRAINING, SHRINK CONTROL, ALL REPORTS,DS REPORTS, REIMS, FFLINK, SERVICE DESK, NEW STOCK ALLOCATION, GRN PROCESS, SALES, E-MAILING, STORE VISUAL SETTINGS, OFFER REFLECTING,ETC.

• 

  PROJECT EVE

  Feb 2019 - Mar 2022

  Senior Inventory Manager/MIS Analyst

  1 - Besically I worked with Big Data, SAP MM and P2P. Data Collecting, Data modelling and also data visualisation.2 -AJIO new order processing and AJIO return processing, manifest and all type reports and data analysis.3 -Store stock allocation, Operation & sales.4- Material Management, Warehouse Management and P2P.5- Sales Order,Purchase and Stock Transfer Order Creation. 6- Good in Excel (Power Query, Power Pivot, VLookup, Hlookup, pivot table, pivot chat, Etc.)7- Material STO Creation,Pay In Slip Creation.Inward Management (DSD & DC),Outward Management (RTV, IST & GRDC),E-way Bill Creation.8- Inventory Management and Vendor Management.Warehouse related Safety Knowledge.9- Ecommerce/ Retail warehouse Operations.Store Operations, DSS Report, All type Report & Shrinkage Control.10- Responsible for training & coaching of staff.Analysis of stocks, fast moving and slow moving stocks for taking necessary correction.11- Posting and keeping track of Defective product & Keeping track of shrinkage, taking necessary correction and managing stock loss.12- Managing consumables for store use and Manage Store consumables. 13- Brief team leaders on a daily basis ànd Oversee the planned maintenance of vehicles, machinery and equipment and also Plan future capacity requirements Show less

• 

  Reliance Retail

  Apr 2022 - Sept 2024

  MIS Analyst

  -Analyze Sales data, claims data, and market trends, to uncover growth opportunities and operational efficiencies.-Develop and maintain reports and dashboards using AdvanceExcel, Power BI, SQL and Python to track key performance indicators (KPIs) and provide actionable insights. Continuously monitor key performance indicators (KPIs) and provide recommendations for optimization.-Ensure data integrity within our databases and data warehouses, managing and optimizing data storage and retrieval processes.-Analyze e-commerce data to identify trends and opportunities for growth and optimization.-Utilize dbt (data build tool) to manage and transform data in our analytics workflows.-Designs develops, optimizes, and maintains data architecture and pipelines that adhere to ELT principles and business goals.-Solve complex data problems to deliver insights that help businesses achieve their goals.-Collaborate with various partners to understand their data needs and requirements.-Translate business questions into analytical solutions and deliver valuable insights.-Develop predictive and prescriptive models to support decision making.-Communicate findings and insights effectively to both technical and non-technical stakeholders.-Gather and analyze sales data from various sources to identify trends, patterns, and opportunities for growth.-Develop and design interactive, well-presented reports, dashboards, and data visualizations and forecasts to provide actionable insights to the sales team and management.-Support the sales team in creating sales presentations and proposals by providing data-driven insights. Stay up-to-date with industry trends and best practices in sales analysis and reporting.-Build a predictive P&L Dashboard summarizing actuals & forecast assisting the CBO & BU heads to make decisions.-Publish weekly Commit v/s Actuals of New orders, Billing etc. -thereby predicting fiscal quarter & year exits by revenues & profitability. Show less

• 

  Jupiter

  Sept 2024 - now

  MIS Manager

  * Create reports, charts at daily, weekly, monthly, quarterly level using Advanced Excel.* Gather data from various sources, both internal and external, and ensure its accuracy and integrity. Analyse the data to identify trends, patterns, and insights that can assist in making informed business decisions.* Prepare regular reports and dashboards that provide relevant and timely information to key stakeholders, such as senior management, department heads, or other teams. These reports may cover financial performance, operational metrics, sales figures, and other key performance indicators (KPIs).* Identify opportunities to streamline data collection and reporting processes. Implement efficient systems and automation to reduce manual work and enhance accuracy.* Respond to ad hoc data requests from management or other teams. Perform on-the-spot analysis and deliver actionable insights promptly.* Ensure data compliance with relevant regulations and internal policies. Protect sensitive data and implement data governance best practices.* Work closely with different departments, such as Finance, Marketing, Operations, and Human Resources, to understand their reporting needs and provide valuable insights.* Keep track of industry trends and best practices related to MIS and reporting. Continuously improve your knowledge and skills in data analysis and reporting techniques.* Manage 1000s of Google spreadsheets .* Manage Sales Operations flow by sharing accurate data with respective teams. Show less