- Managed and worked with a team of Data analysts and data engineers to build a customer focused event structure by creating data models, designing data lake architecture analyzing Front Store data in Databricks using Python, PySpark, SQL, Scala to drive customer analytics.
- Developed, implemented and automated data-engineering processes that aggregates and prepares data that drives development of key financial metrics dashboard to be reviewed by senior leadership, and supports implementation of personalized couponing strategy.
- Automated a data-driven pipeline that loads incremental data in the Data Lake and triggers Databricks notebooks, ensuring that processes are run on a scheduled cadence, improving performance, reducing required man-hours by 70% and saving cost of approximately $100K per year
- Implemented a data-engineering pipeline that generates customer impressions, sales, promotions data etc. against spend across different media channels on a weekly basis over past 3 years, to drive development of Media-mix models and measure the impact of marketing campaigns
- Strategized, designed, developed and maintained a data asset that creates a historical view of the customer behavior and sales, that helps other teams to identify trends, patterns, gaps in customer behavior and drive predictive analytics, marketing analytics, reporting, dashboarding efforts.