Sumanta Das Email & Phone Number

Vadodara, Gujarat, India

• Leading Analytics Projects: Spearheading cross-functional teams in the execution of Analytics projects, orchestrating collaborative efforts to attain project objectives.• Machine Learning Model Development: Orchestrating the development of advanced machine learning models to enable the accurate prediction of critical process parameters, contributing to informed decision-making.• Python Robotic Process Automation (RPA) Implementation: Deploying Python Robotic Process Automation (RPA)… Show more • Leading Analytics Projects: Spearheading cross-functional teams in the execution of Analytics projects, orchestrating collaborative efforts to attain project objectives.• Machine Learning Model Development: Orchestrating the development of advanced machine learning models to enable the accurate prediction of critical process parameters, contributing to informed decision-making.• Python Robotic Process Automation (RPA) Implementation: Deploying Python Robotic Process Automation (RPA) Bots with precision, optimizing data extraction from intricate SQL databases, and orchestrating the systematic archival of files within dedicated server repositories.• Python-based Graphical User Interface (GUI) Design: Devising and executing Python-based Graphical User Interfaces (GUI) to elevate user interaction and experience, fostering intuitive and efficient engagement.• Automated Solutions for Excel-centric Workflows: Innovating automated solutions for intricate Excel-centric workflows, leveraging a harmonious blend of Excel VBA macros and Python scripting to enhance operational efficiency.• Backend Logic and Algorithmic Frameworks: Architecting foundational backend logic and algorithmic frameworks to tackle novel project assignments, underpinning the realization of innovative solutions.• Streamlined Algorithms for Complex SQL Code: Distilling and simplifying complex SQL code, culminating in the design of streamlined algorithms engineered to significantly reduce processing timelines.• Comprehensive Intelligent Dashboards using Microsoft Power BI: Crafting comprehensive Intelligent Dashboards utilizing the robust capabilities of Microsoft Power BI, providing insightful visualizations for data-driven decision-making. Show less

Vadodara, Gujarat, India

Fertilizernagar, Vadodara

 Analysis of current market price trend for the fertilizer market. Working with the sales and marketing team to drive sales forward. Mentoring and training up junior and new staff. Implementing new initiatives. Updating daily sales dashboard and publishing the report for Top Management. Monthly update of sales dashboard and presenting to Top Management. Training of Regional and Area Managers on Tableau Dashboard usage.Achievements: Building Machine… Show more  Analysis of current market price trend for the fertilizer market. Working with the sales and marketing team to drive sales forward. Mentoring and training up junior and new staff. Implementing new initiatives. Updating daily sales dashboard and publishing the report for Top Management. Monthly update of sales dashboard and presenting to Top Management. Training of Regional and Area Managers on Tableau Dashboard usage.Achievements: Building Machine Learning algorithm for predicting the sales efficiency of the sales people using Decision Tree Regression modelling in Scikit-Learn.  Successfully developed Python based executables for data extraction from SAP platform. Successfully created a Python Selenium based web-scrapping tool from scratch for fetching data from web for Fertilizer sales for all districts of India. It reduces the time from 560 days to 14 days. Created live dashboards using RShiny for the team, which will give the sales and rank status on daily, monthly and yearly for a current and previous financial year. Successfully established connection between Python/R and SAP ECC 6.0 Production Server through RFC connection. This helps in faster data pull. With this connection created RShiny dashboard for management showing live sales performance. Created Sales Forecasting RShiny dashboard that helps in future planning and goal setting. Created custom dashboards in Tableau for top management that helps in decision-making. Show less

Vadodara Area, India

Worked with Market Mix Modelling Team. Here we are using the weekly sales volume data to evaluate the impact of advertising, promotional and channel mix. Also doing the detailed analysis of effectiveness of various media and performing the Return on Investment (ROI) analysis.

New Delhi Area, India

To forecast the price of printer cartridges for future months, using methods like Regression Analysis and Time Series Techniques such as Autoregressive Integrated Moving Average (ARIMA) approach.

• Responsible for solving queries of clients related to different statistical analyses.• To provide technical support to clients.• Made many presentations and conducted training programs on different Statistical Analyses using Statistica in various academic, research intensive organizations and also different Government Departments.

Post Graduate Diploma In Management, Operations Management

Business Studies

Msc, Statistics

Bachelor Of Science (Bsc), Statistics

Science, Science