Ronen Sengupta Email & Phone Number

Michigan, United States

Boston, Massachusetts, United States

Bengaluru, Karnataka, India

• Identified opportunities for improvement in the existing database framework by analyzing and manipulating the database with 20 years of data using SQL and Excel for diverse business requirements
• Developed a script to collect, transform and load data into a centralized relational database, in turn, reduced manual effort by 98%, designed and built a database to reduce data redundancy of excel database for report.
• Conducted Exploratory Data Analysis on large datasets using Python, SQL, and Tableau and designed dashboards to visualize customer activities and market trends to better understand business objectives and provide.
• Managed inventory of products and performed POS and inventory data analysis to provide insights into category growth, highlighting top components and increasing sales by 20%
• Collaborated with the data science team to increase forecast accuracy of new components by implementing a decision tree classification model which lead to a reduction in mean absolute error by 8%
• Utilized Power BI to provide real-time data to enable data-driven decision-making and reduced decision-making time by 40% and established success metrics or benchmarks to better evaluate financial performance based on.

Pune, Maharashtra, India

• Conducted deep dive analysis and designed KPIs to help guide business decisions and measure success and performed ad-hoc analysis as needed to answer key questions from stakeholders using internal and external data sets
• Performed data transformation by identifying the trends on a complex dataset with efficiency and applying advanced analytical methods
• Supported cross-functional teams of scientists and engineers in R&D and manufacturing by providing essential statistical data
• Gathered and documented requirements, including process analysis, and collaborated with internal clients and stakeholders to understand business requirements and create highly visual and interactive dashboards via.

Pune, Maharashtra, India

• Responsible for the development of qualitative and quantitative data layers that were utilized in strategic analytics to increase operational efficiency and identified business process improvement opportunities
• Improved work quality of projects by 70% by creating interactive pivot tables and charts for root cause analysis of project performance
• Performed inventory planning and analysis to balance customer need with optimal utilization of financial resources and designed procedures to implement purchasing and scheduling resulting in an increase in uptime by 11%
• Analyzed statistical data to generate reports and dashboards in Power BI for suppliers and customers to ascertain trends in performance, resulting in effective and efficient use of logistic resources

Master'S Degree, Engineering, 3.89

Mechanical Engineering, Mechanical Engineering

Activities and Societies: Training and Placement Coordinator BAHA TRASMISSION MEMBER