PROFESSIONAL SUMMARY:

• 7+ years of IT experience in digital marketing, analytics, reporting, SharePoint services, ETL and database design areas solving many complex business problems.
• 4+ years of digital marketing engineering and PM experience in email, in - product messaging, mobile push, web and social platforms.
• Senior Technical lead/manager for the entire Email Marketing program, handling 3-4 projects, providing technical and functional email marketing solutions, working closely with creative agencies, clients and data teams for on-time deployments, run email analytics and participate in creative reviews.
• Hands-on experience in marketing automation platforms like Salesforce Marketing Cloud SFMC (ExactTarget), Marketo, MailChimp, Movable Ink, Zembula, Persado, Braze, PlayFab and other Confidential proprietary tools.
• Strong email development skills using HTML, CSS and AmpScripting. Developed highly dynamic emails using AmpScript to deploy via. SFMC platform.
• Subscriber data management experience in terms of tracking the sends, open rate, click through rate, bounces, and unsubscribes.
• Created campaigns in Iris, write SCOPE script for segmentation, experimentation and create outcomes in the Confidential marketing automation platforms.

SKILL:

Marketing automation platforms: Salesforce Marketing cloud (SFMC), Marketo, MailChimp, Dynamics CRM 365, AutoPilot HQ

Web analytics tools’: Omniture, WebTrends, WEDCS

Email Optimization tools: Movable Ink, Zembula, Persado, AudiencePoint

Other Marketing automation tools: Braze (AppBoy), Iris Studio, PlayFab

BI Tools: Power BI, SQL Server Reporting Services (SSRS), MS Excel (PowerPivot)

Programming Languages: AmpScript, HTML, CSS, SQL, C#.net and XML

Databases: MS SQL Server 2012/2008R2/2005, Azure DB

WORK HISTORY:

Confidential, Redmond, WA

Sr. Technical Lead, BI data analyst

Tools: Salesforce Marketing cloud (SFMC), Power BI, Movable Ink, Marketo.

Responsibilities:

• Technical lead/manager for HCL Email Marketing program, handling 3-4 projects, providing technical email marketing solutions, working closely with creative agencies and clients for on-time deployments and track the customer KPI’s in both technical and functional aspect.
• Develop highly dynamic and personalized emails with responsive and mobile optimized techniques.
• Import subscriber data into Salesforce Marketing Cloud platform on a weekly basis and run queries to segment the data by using automation. Generate reports and dashboards in Power BI.
• Use Journey builder to define customer journeys for automated email sends based on certain user actions.
• Optimize emails using Movable Ink (say include a Timer), Zembula, Persado, AudiencePoint, etc. by creating code snippets and hook them up with SFMC emails for better open rates and click through rates.
• Increase user engagement and revenue through A/B testing and campaign optimization
• Create campaigns, perform experimentation, segmentation, outcomes, reporting, etc. in Iris to run email marketing campaigns.
• Engage with upstream data scientists to update the segmentation strategies from time to time.

Confidential, Redmond-WA

Project Lead & BI Data Analyst

Responsibilities:

• Configure data-driven/segmentation-based campaigns using Salesforce Marketing cloud to deploy emails, social messaging (twitter/Facebook feed) and in-product messaging.
• Analyzing subscriber’s activity based on their email actions and target the upcoming campaigns using segmentation strategies.
• Extract data insights from the subscriber activity using PowerPivot and occasionally PowerMap.
• Run ETL on the daily feeds from SFMC email interchange and transform data to bulk insert into reporting database tables.
• Deploying emails/newsletters to millions of subscribers or customers across the globe from Salesforce Marketing cloud (SFMC) and collect the data related to those deployments.

Confidential, Redmond, WA

Project Lead

Responsibilities:

• Capturing migration data in a SQL azure database using ETL feeds
• Load data into on premise sql servers using SSIS packages using ‘Lookup’/SCD transform
• Create Views/Dim. Tables to get the data in an intended format
• Load data and perform data transformations/modeling in Power BI designer
• Group the report elements in a dashboard through pinning and arrange in a meaningful manner
• Teamed up with Confidential Power BI User Experience team to ensure there were no data issues.

Confidential, Redmond

BI Developer, Reporting (SSRS)/Data Migration Consultant

Responsibilities:

• Manage Content Data Warehouse which is a centralized repository for all the O365 business data
• Query a separate set of data that corresponds to Page Views, Downloads, Click-Through-Rate (CTR) and Search hits of each article
• Estimate the business impact on an average with the total number of PVs, Visits and other form of BI trends recorded daily.
• Responsible to publish the BI data on a customized dashboard called BITI (Business Intelligence for Templates & Images)
• Configured SSIS package for data loads that runs on a timely basis to load the data from OLAP cubes to local environment with more of a de-normalized form