Shreshtha Gupta

Leading a team of 8-10 members to execute global CRM campaigns across Email and Push channels using Salesforce Marketing Cloud (SFMC). Delivered end-to-end personalized voucher campaigns for ecommerce brand: planning, segmentation, targeting, launch, and performance analysis. Built and validated customer segments leveraging SQL and data sources to optimize targeting and campaign effectiveness. Developed advanced automations and audience segmentations using SQL, AMPscript and Intelligence Builder. Served as SFMC Site Reliability Engineer and content change team lead: managed incidents, ensured platform uptime, and optimized performance and keeping the content up to date with marketing team. Scaled campaigns to billions of emails globally during peak periods; implemented alerting systems and streamlined automations. Collaborated with clients on campaign strategy, SFMC consulting, and platform enhancements; facilitated cross-functional coordination between Salesforce and business teams.

Creation of CRM end-to-end campaigns across email and Push channels using Salesforce Marketing Cloud (SFMC). Designed Data Model Objects (DMOs) and managed Data Lake Objects (DLOs) aligned to Salesforce Customer 360 standards, ensuring governed and analytics-ready data structures. Executed data transformations and harmonization using Data Cloud capabilities and SQL in Query Studio, preparing unified data for identity resolution and downstream use cases. Built audience segments and configured Activation Targets to activate audiences to Salesforce Marketing Cloud, enabling personalized campaigns and reliable downstream execution for email and SMS both segments. Creation of manual reports from data views using SQL queries. Worked on many automations to create and send alert emails using SQL and SSJS. Creating and monitoring automation via automation studio for effortless activity in many campaigns. Used FTP to upload and download files. Accountable for acting and managing the workflow of email and push campaigns. Hands on experience in Data extension, lists, publication list, sender profile setup, data filters, content builder, automation studio, journey builder, file transfer, SQL query, all subscriber lists. Working on different campaigns Real time transactional, Marketing and batch promotional campaigns for targeting maximum subscribers, mass email send programs. Good working experience in SQL. Data management and data pulling by using SQL queries.

Responsible for building new rewards system using COBOL/CICS and DB2. Working on small enhancement and new service request. Analysis and resolution of incidents raised by Customer, Loyalty business user, Local IT from Canada and US. Deployment activities for new release or any personalization changes in the system. Collaboration with 3rd party vendors to fix issues with certain applications. Communication with local IT from above-mentioned countries over email/phone for RCA of application issues. Competency development for new associates on Stores and Loyalty applications.

Analyzing and providing the fixes within SLA for the production job failures. Mentoring and training the team with the knowledge required for production support. Review of the code changes and the design documents for code enhancements before production implementations. Scheduling the new jobs and the yearly scheduling of all jobs in the scheduler. Construction and review of the code as per CLOAS system standards. Technical Document preparation and configuration management. Preparation and Review of implementation and backup plan for the projects before its implementation in production.

Learn fundamentals of Dot Net, SQL. Operating System Windows. Languages Dot Net, HTML, CSS, SQL.