Vikrant Singh Bisen

Project: Internal Project (FSC Internal Demo/Dev Org) to show marketing cloud end to end functionality and get data from Financial Service Cloud.

• Created Credit Union console- Infinite dashboard in FSC side.
• Established end to end integration using Manage package to connect with FSC and bring objects into SFMC.
• Using Marketing cloud app in FSC to send emails to reports and campaigns and tracking reports functionality enabled in FSC side.
• Created Html and template based emails in content builder.
• Created Journey to send email to FSC campaign members.
• Creating and updating leads and application in FSC side using marketing cloud.
• Implemented simple SQL query to segment data from synchronized to Target DE.

Project: RLDatix (SFDC- CRM)

• Worked on SFDC side and have got good knowledge in SFDC.
• Worked on de-duplication for segmenting the data in sales side.
• Worked on creating custom objects.
• Worked on Lead conversion and created Account, contact and opportunity.
• Worked on reports and dashboard.

Project: Black Opal

(US based credit card issuer)

• Worked in end to end Integration, connected SFMC with FSC (Financial Service Cloud).
• Setup the Account management of black opal account like sender and delivery profile, RMM, FTP, User creation and roles.
• Register the domain and verified.
• Setup the Auto suppression configuration.
• Migration of emails and assert from classic to content builder.
• Worked on Ampscript and html to personalize customer details, credit card application details and build dynamic content for emails based on customer attributes and geographic location.
• Worked on Automation to automate query activity to capture real time data from FSC to salesforce DE.
• Build webpages to handle customer data into Data extension with Ampscript and created user initiated sends, triggered sends to send emails.
• Worked on journey builder to send real time emails to lead, contact and opportunity.
• Experience in SQL query to segment the data into DE.
• Worked on creating individual emails performance report through sql and Data views.
• Worked on to implement Email sends in FSC to send emails to reports and campaign and tracked the email performance in FSC side.
• Worked on creating the process of extracting daily report and send in to SFTP.
• Good knowledge in SSJS (with WS-Proxy), SOAP, REST API to fetch/post data into SFMC.
• Build a custom preference center pages to handle unsubscribe request, opt in preference of campaigns and updating salesforce objects from SFMC cloud pages.
• Providing support to QA team in performing migration.
• Worked on Publish, Engage and Analyze on Social Studio.

Project: Verve

(US based credit union)

• Worked on different-2 campaign, those already was running.
• Fixed the data using SQL query for all running campaigns. Like Annual meetings campaign, General Audience campaign, Reward first audience, Rate first audience, Western Audience etc.
• All data fixed in both staging and Prod structured folder.
• Worked in Automations for all running campaign and stored real time updated data into Target DE.

Project: CanCapital

US based loan company

• Methodologies: Email Studio, Data Extension, Dynamic Content, Send Classification, Journey Builder, Social Studio and CRM Data Migration
• Worked as BA as well to get project into the organization.
• Worked on RFP and RFI.
• Email Studio helps created highly personalized emails with drag-and-drop ease.
• Integrated online and offline data to trigger personalized email messages across the customer journey.
• CAN Capital used the email studio to send mails to Merchants and broker for promotion or transaction.
• Email will be sent for new loan offer; renewal offer or concurrent loan offer.
• Email generation will be based on following business scenarios and which can generate from either Salesforce or marketing cloud.
• Writing SQL queries and fixing data related issues in a source CRM system.
• Created dynamic content for the emails.
• Maintained Sender Profile and Delivery Profile for Email Sends.
• Using automation receiving records into DE and Automate the journey.
• Using journey builder we set behavior based goals, and Planned multiple individualized interactions, all within the same planning tool.

Project: Watchbox

US based company, pre-owned luxury watches. Buy, Sell or Trade the most popular watch brands including Rolex, Patek Philippe, Audemars Piguet.

• Methodologies: Email Studio, Data Extension, Dynamic Content, Send Classification and CRM Data Migration
• Debugging, Bug fixing and enhancement in CRM data migration tool.
• Providing support to QA team in performing migration.
• Writing SQL queries and fixing data related issues in a source CRM system.
• Created templates and emails under content builder and maintained portfolio.
• Created dynamic content for the emails.
• Maintained Sender Profile and Delivery Profile for Email Sends.

Project: Shure Project

SHURE (US based Audio system company)

Process : Implementing an end-to-end campaign setup (Inclusive of setting up in all three environments [SFDC, SFMC, Pardot] from scratch till production) for B2C by integrating sales force CRM to Salesforce Marketing cloud and Social Studio. Implementing same setup for B2B by Integrating Salesforce to Pardot.

Roles and Responsibility:

Marketing cloud:

• Played the Role of lead developer and helped clients on understanding the entire Functionality of Marketing cloud.
• Created business unit, users, & roles and performed whole Admin setup for the Marketing Cloud Account.
• Performed Single Sign on setup for marketing cloud.
• Created list, Data extension and segmented audience using filters and SQL queries. Suppressed audience using Auto suppression list.
• Created templates and emails under content builder and maintained portfolio. Created dynamic content for the emails.
• Built the entire set up of FTP and automated FTP imports & Exports.
• Created SQL Automation and User Initiated Emails Automation.
• Built and automated Journeys to update Salesforce leads and contacts.
• Implemented Cloud Connector for integrating Salesforce (SFDC) with Marketing Cloud

Social Studio:

• Performed the entire setup on Social studio from creating users till generating reports for all social media forums.
• Proficient in all three tabs (Publish, Engage, Analyze) of social studio.
• Created Topic profile, macros, engage templates.
• Integrated Social studio with Salesforce and worked on lead/case generation from social post.

Project: Virgin Project

Virgin Voyages (US based Cruise Company)

Process : To make the client understand the process of capturing leads from web form and storing in data extension, Journeys, Creating Emails from the assets brought into Content builder through integration.

Roles and Responsibility:

• Created Dynamic Content Emails using new content builder.
• Created Facebook ads using Advertising studio and captured the lead from Ads into Data extension through Amp scripts.
• Created Web Form using Cloud pages and stored the customer info from the web page into Data extension.
• Created and automated many journeys under Journey builder for responsive campaigns.