Badges
Certifications
mansi_chandresha has not earned any certificates yet.
Work Experience
Data Analyst Intern
Hallmark• March 2021 - Present
Business Analyst
Vertiv• January 2017 - December 2019
• Price Optimization: Built an ML model using regression and ARIMA time series prediction in python to optimize product prices using historic sales data and selling trends of similar products resulted in an increase in quarterly profit by 8%. • Product Segmentation: Used ETL scripting to get a large amount of data and segmented on three levels of hierarchy namely Line of Business (LOB), Industry, and Product using SQL, and R to increase monthly sales by 5.7%. • Failure Prediction: Built a Logistic Regression Model in Jupyter Notebook to predict the failure rate of UPS and customer re-order probability that helped in optimizing expenditures on marketing strategies by 21%. • Product Categorization: Clustered products based on different features and customer demand using k-means and hierarchical clustering, analyzed the model, and recommended a new product strategy that increased sales by 16%. • KPI Dashboards: Designed Orders vs Forecast, Open Order Management, and Daily Order Gap dashboards in Tableau to track all open orders for a year on a rolling basis and reduced number of open orders by 20%.
Quality Assurance Analyst
Vertiv• July 2015 - December 2016
• Agile Management: Led cross-functional teams to understand the impact of the operational cost of a product, revised KPI dashboards in Tableau to analyze commodities with the highest cost impact and reduced basic product cost by 7%. • A/B Testing: Analyzed the performance of new communication features using A/B Testing and suggested new strategy to stakeholders that boosted product sales in market by 19%. • Cost Optimization: Wrote complex SQL queries involving joins and correlated subqueries and rebuilt dashboards in Advanced Excel to reduce the material cost by 4%. • Product Configurator: Automated a VBA based product configurator for simplifying the generation of BOM (Bill of Material) and standardizing sales quotations and approval process to reduce daily man-hour by 50%.
Education
University of Texas at Dallas, Richardson
Data Science, MS• January 2020 - Present
NIT, Surat (Sardar Vallabhbhai National Institute of Technology)
Electrical Engineering, B.Tech• July 2011 - May 2015
Links
Skills
mansi_chandresha has not updated skills details yet.