Simmy Mathew Email & Phone Number

Bentonville, Arkansas, Us

Bentonville, Arkansas, Us

Bentonville, Arkansas, Us

• Designed and implemented a Weather Driven Demand dashboard highlighting forecasted and historic weather impact on sales for 1200+ categories; product was leveraged by Merch Ops leads to efficiently budget and forecast weather impacts; replacement for third party subscription-based product saving $1 million yearly.• Developed a controlled experiment to capture the sole impact of weather on category sales using Alteryx, ultimately leading to new visibility for the organization.• Performed regression analysis using Python to quantify the impact of temperature, rainfall, and snow on sales quantity, enabling category level insight which aided replenishment processes.• Conducted hypothesis test on the regression coefficients to eliminate categories not impacted by weather at 0.05 level of statistical significance.• Leveraged statistical techniques for differentiating extreme and normal weather conditions using 13 years of WeatherBell weather data.

Bentonville, Arkansas, Us

• Extracted data from various systems, cleansed using Alteryx and published on Tableau for the U.S. Weekly Compliance Dashboard; used by divisional and regional managers to track external audit ratings for all 4500+ US stores.• Leveraged data-driven insights to address concerns raised by Region/Market/Store managers on compliance scores across the U.S market enabling them to act against the non-compliant stores.• Designed the Alteryx workflow to incorporate FY20 Financial Service metrics in the U.S. Weekly Compliance Dashboard providing visibility to fraudulent transactional cases in stores.• Built the International Ethics & Compliance Scorecard and was involved in the complete development and deployment for high level overview of international market performance.• Collaborated closely with SMEs to identify and analyze CI enhancements on Cognos reports for International markets.• Developed complex SQL queries to pull data from the Data Lake, facilitating and providing insights on training completion in the U.S market.• Generated ad-hoc reports to help business partners identify critical KPIs and facilitate strategic planning in the organization.• Created the Food Safety Recall Report, providing insights on top and bottom performing Regions/Markets/Stores.• Collaborated with the ISD team to develop a new, automated version of the U.S. Weekly Compliance Dashboard.

Bangalore, Karnataka, In

Master'S Degree, Management Information Systems, General

Bachelor Of Technology (B.Tech.), Computer Science