Harshal Rajguru

Client: Caterpillar (Sept 2024 - Present)

• Developed multi journey module to target different audience based on their engagement with our communications.
• Created complex SQL queries to calculate member statuses describing them as VIP customers based on their past 3 yrs activity and engagement.
• Created queries to extract tracking data from Data Views for business analysis.
• Created complex customized emails using AMP Script to increase engagement.
• Segmented audience to target individual groups based on their VIP status.
• Worked on report creation and presentation to the stake holders about the SFMC platform and its capabilities.

Client: Reckitt (March 2022 - May 2025)

• Improved Journey Performance and optimized automation queried to improve customer engagement by 5%.
• Developed automated journeys and created created personalized email templates reducing manual work and increased efficiency.
• Created customized reports showcasing overall org performance for stakeholders.
• Enhanced software performance by identifying and resolving technical issues for numerous clients.
• Managed multiple projects simultaneously, delivering quality results within deadline constraints.

Client: Dexcom (Jan 2022 - April 2024)

• Developed Emails in Marketing Cloud and created Email proofs for Client on Litmus
• Worked on AMP Script to Customize content in Marketing Cloud.
• Developed various Journeys in Journey Builder.
• Worked on multiple automation activities and created automation in Automation Studio
• Migrated Journeys, Emails and other content to Production.
• Played a crucial role in Development, Testing, Troubleshooting and Deployment of a 15 Journey Module which went live successfully in Nov 2022.
• Architected Journeys and updating existing architectures as per business requirements in Lucid Chart.
• Configured New BU's and implementing DOI process.
• Monitored, support and helped new onboarded QA and Dev team members.

Client: Texas Health Resources

• Manually tested newly created functionality.
• Updated existing Batch Jobs and created SOQL query.
• Extracted/Deleted/Updated bulk records using Apex Data Loader using SOQL query.
• Created and updated Apex Triggers, flows and apex codes.
• Designed and implemented Automations in Marketing Cloud Automation Studio.
• Created Automation Queries in Marketing Cloud.
• Created and Tested Marketing Cloud Journeys, Contents, Data Extensions, etc.
• Implemented, Tested and Deployed various functionalities to Production with utmost efficiency.
• Provided demo for various solutions to Clients and Vendors with more than 50 audience from different organizations.
• Managed multiple projects simultaneously while prioritizing deadlines effectively under pressure through meticulous organization skills and time management.

Client: Caterpillar

• Created workflow rules, validation rules and processes using process builder.
• Developed Apex code and Trigger as required.
• Managed admin configuration and enhancement of existing functionality.
• Created AURA components in developer console.
• Created UI components on LWC.
• Streamlined internal processes for improved project efficiency and timely delivery.

Company Overview: Perficient India Pvt. Ltd. is a leading digital transformation consulting firm that helps clients achieve their business goals through innovative technology solutions.

• As a highly motivated and detail-oriented individual, I joined Perficient as a intern and started my training on Salesforce platform to begin my journey in the IT industry.
• I gained my Salesforce certified Administrator certification and started supporting on projects as a shadow resource.

Harshal holds a bachelors degree in Information Technology from Manoharbhai Patel College of Engineering & Technology.

• Completed professional development in Information Technology