Yogesh Raut Email and Phone Number

• Preparation of Sales Dashboard using MS-Excel• Preparation of Customer wise and Product wise Daily and Monthly Sales reports using Medica ERP system• Maintaining and updating secondary sales data, used for insights and forecast of region wise sales• Evaluating and predicting sales trends, develop methods and strategies to determine trends.• Researching current market changes and trends.• Providing actionable insights to guide the sales and marketing team.• Contributing… Show more • Preparation of Sales Dashboard using MS-Excel• Preparation of Customer wise and Product wise Daily and Monthly Sales reports using Medica ERP system• Maintaining and updating secondary sales data, used for insights and forecast of region wise sales• Evaluating and predicting sales trends, develop methods and strategies to determine trends.• Researching current market changes and trends.• Providing actionable insights to guide the sales and marketing team.• Contributing to the development of sales plans and objectives.• Prepared and automated all types of Sales related data sheets, results in more accuracy and time savings.• Develop and automated Inventory data sheets using VBA macros.• Analyzing historical sales data for preparation of Dashboards.• Filter, clean and transform data using Power Query by reviewing all sales related reports and consolidating secondary sales data to find trends and patterns.• Preparation and presentation of all sales related insights to management.• Handling SANeForce e-reporting system for all medical representatives as Administrator.• Creation of users and authorizing/restricting access of modules to users of SANeForce e-reporting app.• Preparing monthly region wise Visit analysis reports of all Medical Representatives and Sales Managers.• Preparing presentations for Sales meetings.• Working on modules of Medica ERP system for sales, purchase, customer, vendors master data setups.• Creating users of Medica ERP and authorizing/restricting modules access. Show less