Pratik Asai

-

Customer Data Management

• Lead and deployed CDM analytics platform to collect 100+ data points of customers using user activity on site, order history, etc. for concise targeting of marketing emails to users.
• Developed Trigger email payload for Order Confirmation and Ship Confirmation emails etc.
• Developed Email and SMS performance data metrics pipeline ,CCPA and GDPR compliance pipeline and Loyalty bonus cash appeasement pipeline.
• AWS cost reduction achieved through optimization of Spark jobs by fine tuning it.
• Developed Data Quality enforcer and automated data ingestion processes to eliminate manual effort for migration.
• Created Feeds pipeline to partners for sharing Customer/ Email/ Transaction Feeds via SFTP.

Customer Recognition

• Integrated with 3rd party tool like Audience acuity and Alteryx to increase identification of customer on site by 40%
• Developed new emails payload to extend recognition emails arsenal like cross Abandon cart/Browse.
• Migration of system to iceberg hive metastore to enhance RW benchmarks.

Fan360

• Lead and developed Deduplication of customer accounts across sites using customer's email/FN/LN/Address for concise targeting.
• Collected data metrics at user level and shared across Fanatics entities using Snowflake.
• Enabled cross-sell pipeline between Commerce and Betting & Gaming vertical using above data collection for customer.

-

• Developed Learning Resource Management System analytics data pipeline to feed the dashboard
• Established event-driven system using Maxwell with in-house infrastructure to read CDC from binary logs of MySQL and writes row updates as JSON to Kafka.