Data Analyst
CurrentSupported a leading automotive parts retailer operating over 6,400 stores across North America, with 50 distribution centers and over 323,000 SKUs generating $11Bn in annual sales (~$25Mn daily sales, ~800K daily transactions)• Analyzed sales and promotional campaigns data using clustering techniques to identify customer segments, revenue driving factors to support decisions resulting in net sales increase by 1.3% to $3.4Bn. Implemented machine learnings models leveraging marketing and non-marketing data across web, search, social, email to identify customer buying behavior and improve conversion rates, user experiences on ecommerce sites. • Leveraged multiple analytical tools & data pipelines to extract, model and analyze billions of SKU records of inventory, sales, customer data and extract key business insights. Built high visibility intra-day reports to present findings primarily referred by c-suite and other functional leaders. Optimized snowflake SQL query execution with stored procedures allowing Power BI reports to achieve sub-one minute response time with data query• Leveraged time series and historical sales data to perform feature extraction and pattern recognition to build regression models with seasonality and demand forecasting to predict future demand & support pricing strategies. Built dashboards to track seasonality of product category to support business & promotional planning• Developed workflows to identify duplicate records and clean sales data across various databases. Collected, cleansed, supported modelling and analyses of structured & unstructured data used for major business initiatives.