SUMMARY

• 5 years of overall professional IT experience with Salesforce development life cycle including analysis, application design patterns, testing and deployment planning.
• Involved through the Software Development Life Cycle (SDLC), Agile / Scrum from initial planning through implementation of the projects.
• Experience on web studio, email studio, Automation studio, Journey builder and audience builder.
• Worked on data extensions which used in different SQL queries to store the data and as well as pull the data.
• Worked on AMP scripting in Marketing Cloud, with creating Data filters, SQL queries, and building segments.
• Experience in creating Dynamic content for emails, designing cloud pages using AMP Script and segmentation of data with SQL Query.
• Extensive Experience in wide range of languages and technologies such as HTML, CSS, Bootstrap, JavaScript, jQuery, and Amp Scripts.
• Proficient in Guided Template language, Server - side Java Script, Rest API, SOAP API and Json.
• Designed and configured journeys using the activities within the Journey Builder based on the requirement.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Capable of handling responsibilities independently as well as a proactive team member.
• Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
• Worked on building Emails for different journeys with AMP Script functionalities for advanced functions in the emails.
• Involved in creating dynamic and responsive emails, landing pages, profile centers, and SQL queries.
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution Plans,andIndexes.
• Managed Email Marketing campaigns which include Requirement’s discussion, execution approach, DE creation, data filters, queries, and measures.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.

PROFESSIONAL EXPERIENCE

Confidential

Salesforce Marketing Cloud Consultant

Responsibilities:

• Designed and configured journeys using activities within the Journey Builder and deployed them in production after thorough testing.
• Worked on creating business units, assigning roles to users, and performed whole Admin setup for the Marketing cloud Account.
• Assigned permissions to Shared data and Content across the Enterprise and Business units.
• Used Email Studio to quickly build and send personalized email from basic newsletters to the most complex campaigns.
• UsedJourney builderin running more than 70 different campaigns along withAutomation Studioand Contact Builder.
• Developed and implemented end-to-end cross-channel customer journeys based on requirements from CRM Program Managers.
• Conducted QA and testing process for marketing campaigns and customer journeys, identifying and troubleshooting any issues.
• Created and published API integrated Trigger sends for Transactional communication messaging.
• Responsible for technical coordination including emailQAinhtml, writingSQLquery andAmp Scriptlogic, and leveraging assets to build and deploy email campaigns.
• Collaborated with members of the project team and business owners to design, develop, unit test, and provide post-release support.
• Worked in an agile environment with a focus on iterative and test-driven design methods.
• Developed different Email templates for implementation of dynamic email marketing program using AMP Script, HTML and CSS.
• Automated Script activities to create data extensions during runtime and populate them using JavaScript.
• Synchronized data from Salesforce CRM to Marketing Cloud using marketing cloud connect.
• Implemented Marketing Cloud apps such as Email Studio, Content Builder, Audience Builder, Journey Builder, and Automation Studio.
• Created Lists, Groups, Data Filters, Data Extensions using API.
• Worked on building SQL Queries for large volumes of data in Marketing Cloud.
• Performed A/B testing through Email Studio and Journey Builder.
• Designed, developed & tune data products, applications, and integrations on large-scale data platforms.
• Analyzed the business needs, profile large data sets and build custom data models and applications to drive the business decision-making and customer experience.

Environment: Journey Builder, Audience Builder, Email Campaigns, HTML, Java Script, CSS, Triggers, SQL, Web Services, Reports, Teradata, Email Services, Tracking, Data Import/Export, Marketing Cloud Marketing Cloud Admin, Microsoft Visual studio.

Confidential, Kansas

Salesforce Marketing Cloud Consultant

Responsibilities:

• Responsible for supporting day to day SFMC operations and cross-channel digital marketing campaigns including email and SMS
• REST API Integrations to different internal systems for seamless data flow to Confidential
• Created outbound API triggered SMS leveraging Sales Cloud data to send dynamic SMS
• Assisting internal teams in setting up and conducting A/B and multi-variant testing based on criteria such as segmentation, offer, offer presentation and creative.
• Measure and report performance of all digital marketing campaigns, and assess against goals.
• To monitor the campaignpost-deploymentto validate completion.
• To develop robust campaigndocumentation, including customer specific work instructions.
• UsedHTML,CSS,AMPScript,SSJS, and other technologies to build customized solutions that support critical business functions.
• Build out Marketing Confidential in Journey Builder and Email & SMS campaigns
• Working on HTML, CSS, and Amp Script to update HTML based emails and landing pages.
• Constructing engaging user interfaces to ensure the highest success with email promotions

Environment: Journey Builder, Audience Builder, Email Campaigns, HTML, Java Script, CSS, Triggers, SQL, Web Services, Reports, AppExchange, Email Services, Tracking, Data Import/Export, Microsoft Visual studio.

Confidential, New Jersey

Salesforce Marketing Cloud Technologist

Responsibilities:

• Worked with business process owners to understand their requirements for Salesforce Marketing Cloud application.
• Automated the import, extract, and Query activities in Automation Studio.
• Captured relevant technical and business requirements, analyzed inputs, and created Salesforce Marketing Cloud solution recommendations.
• Used AMP Scripts while creating the Email templates and while using data from data extensions.
• Managed Email Marketing campaigns that include Business Requirements Document Discussion, creation of blueprints.
• Monitored deliverability reputation across email clients.
• Design, develop, code, and test software systems (full life cycle) or applications for software enhancements and new products; revise and refine as required.
• Recommend modifications to processes and procedures.
• Created data extensions, data filters, queries, and measures. Contributed towards building and validating HTML codes.
• Managing subscriber data, import and segmentation using a combination of Salesforce Confidential tools and database queries.
• Improved the performance of the application by rewriting theSQL queries.
• Extensive use of GIT hub for version controlling and source code management.
• Responsible for technical coordination including emailQAinhtml, writingSQLquery andAmp Scriptlogic, and leveraging assets to build and deploy email campaigns.
• Evaluated team and individual performance by analyzing data, reviewing cases, and monitoring customer interactions.
• Assisted in resolution of escalated situations initiated by Marketing Cloud, clients, and partners.
• Managed Escalations on behalf of the client and/or Marketing Cloud.
• Ensured adherence to client service level agreements and timely case resolution.
• Maintained positive relationships with Marketing Cloud teams, clients, and partners.
• Worked closely with the development team to provide support for database objects (stored procedures/triggers/views) and performing code review.

Environment: Automation Studio, HTML, Java Script, CSS, Triggers, SQL, Web Services, Reports, AppExchange, Email Services, Tracking, Data Import/Export, Marketing Cloud Marketing Cloud Admin, Marketing Cloud Integration

Confidential, New Jersey

SQL Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, TestingandImplementation.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Created and maintained DB Change Log to track the state of the DB in each environment (Dev, Test, UAT, and Pre-Prod).
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Conducted System Testing and functionality after virtualization.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign keyconstraints in data conversions.

Environment: SQL Server 2005, MS Access, Excel, InfoPath 2003/2007, SQL*Plus, PL/SQL.