Summary
Quote
Link to my latest project - GA4 Tracking
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
What they say:
Reference
Generic
Kedar Bedekar

Kedar Bedekar

Greater Toronto Area,ON

Summary

Dynamic and self-motivated Analyst with 5 years of blended professional experience in delivering accurate reports and creating insights through data visualization to aid decision-making. Experienced with Salesforce CRM and Marketing Cloud. Experienced with B2B SaaS and B2C marketing, maintaining Salesforce CRM data hygiene, and having experience in SEO strategies for which relevant certification is acquired. Demonstrated ability to understand complex data requirements and provide actionable insights.

Quote

"Work not what you are paid for, but what you are made for."
Suresh Nambiar, NIQ

Link to my latest project - GA4 Tracking

GA 4 and SEO Project - https://kedarbedekar.github.io/E-comm-Website-GA4/ 

MySQL Learning Repository - https://github.com/kedarbedekar/MySQL_StrataScratch

Side Quest - Salesforce Admin Certification preparation

Overview

5
5
years of professional experience
6
6
Certificate

Work History

Marketing Data Analyst

Principal Financial Group
Canada, Remote
07.2023 - 09.2024
  • Creation of Campaigns in Salesforce CRM for email projects and maintaining the accuracy of the CRM data.
  • Building custom SQL queries for audience build for targeted email sends.
  • Owned and built a new data schema for the Salesforce Marketing Cloud instance.
  • Performed QA and validation of audience criteria, campaigns, and current data structures in Salesforce CRM and Marketing Cloud.
  • Data Analysis and validation of Marketing Cloud and Salesforce Data Cloud (CDP) data for transition projects to ensure data accuracy.
  • Worked on multiple marketing projects for KPI tracking, data accuracy, and data enrichment.
  • Increased Event Campaign Management Process efficiency by 85%.
  • Recommended new event process for pre- and post-campaign analysis.
  • Successfully troubleshooting and rewriting 'Product Table Query' during automation failure.
  • Cross-functional collaboration with teams to resolve process issues, helped in SQL query creation, and troubleshoot query resolution.
  • Serviced over 1000 tickets related to QA, SQL query build, Salesforce, and Power BI Reports, Data Enrichment, and Data research within a span of 6 months.
  • Ensured email project quality by routine quality checks to maintain data quality and accuracy.
  • Recommendation and Consultation with SMEs to restructure and update current SQL queries to cater to Marketers' requirements.
  • Serviced 82 ad hoc tickets with 100% quality and on-time delivery of reports to the stakeholders.
  • Initiated process change to shift focus of marketers from campaign-based sends to audience criteria-based sends.
  • Visualized email metrics using Power BI to better understand email engagement and performance.

Associate - Data Analyst, Marketing

Netsurion
India, Remote
08.2022 - 11.2022
  • Created Salesforce Dashboards and Reports for Marketing Health Check along with maintaining the CRM database for 5 marketing campaigns
  • Analyzing campaign effectiveness by excel analysis for 2 pivotal campaigns released by Netsurion
  • Experienced with creating audiences and orchestrations on ABM Tools and linking the same with CRM to generate dashboards and reports
  • Implemented 3 ABM orchestrations
  • Created metrics from ABM campaigns to measure the effectiveness and gather intent accounts that can be added to the CRM (Salesforce)
  • Developed process documents for 3 key processes viz
  • Marketing analysis, data enrichment process and New lead import from ZoomInfo.

Data Processing Specialist

NielsenIQ
India, Hybrid
11.2020 - 07.2022
  • Worked on multiple projects and multiple clients ranging from SC Johnson, Nestle, Japan Tobacco International, Kimberly-Clark, Energizer, Coca-Cola and Reckitt Benckiser under OAC CoE (Operations Acceleration Centre). Total clients worked with: 8.
  • Conducted category analysis and item level analysis through MS Excel of consumer data for FMCG brands like SC Johnson, Nestle, Japan Tobacco International, P&G, Unilever, etc.
  • Before time delivery (before the commitment date) for the OQK(Oman, Qatar, Kuwait) GTC Project. 117% efficiency attained and improved speed of delivering the project through automation ideas.
  • Created Transition Reports for Migration project comparing Legacy Data and New platform data by providing explanation for every deviation above +/- 0.3%.
  • Ensured the deviation was within the limits prescribed by each client by creating accurate rules in Nielsen's in-house platform that created client databases.
  • Designed and built MBR (Monthly Business Review) for OAC, with constant brainstorming and feedback from key stakeholders by going above and beyond my usual job responsibilities.
  • Conducted behavioral workshop on 'Quality Consciousness' for 50+ employees, to impart knowledge about the quality standards at workplace and improve quality in the operations team through behavioral workshops.
  • Requested timely data by collaborating with various departments and ensuring timely delivery of databases to the client.

Assistant Professor

Mervin Classes
Vadodara, Gujarat
01.2019 - 11.2020
  • Created lesson plans and developed instructional materials covering required topics and learning objectives.
  • Developed custom course syllabus outlining standards, material, grading and progression for students.
  • Maintained student engagement through creative subject delivery and learning activities.
  • Administered and graded tests and assignments to evaluate student performance and monitor progress.
  • Created video lectures during the time of Covid to help students attain their educational goals.
  • Helped the institution in building an online admission form during COVID to facilitate a touchless admission process.

Line Chef

East Side Marios
Hamilton, Ontario
05.2023 - 07.2023

Line Chef/Pizza Chef Assistant

Industria Pizzeria
Hamilton, Ontario
05.2023 - 07.2023

Machine Operator

Maple Leaf Foods
Hamilton, Ontario
02.2023 - 04.2023

Education

Business Analysis Graduate Certificate -

Mohawk College
Canada
10-2023

Masters of Commerce - Banking And Insurance

The Maharaja Sayajirao University of Baroda
India
04-2020

Bachelors of Commerce - Accounting And Financial Management

The Maharaja Sayajirao University of Baroda
India
04-2017

Skills

Salesforce CRM

Salesforce Service Cloud

Salesforce Marketing Cloud

Lead generation management

Campaign Management

Strong Communication - written and oral

SQL

Python

Microsoft Excel - Data Analysis

ZoomInfo

Triblio - ABM Tool

Tableau

Power BI

ERP System

Process Creation

Microsoft PowerPoint

Microsoft Word

Google Analytics

Process Documentation

VBA

Data Enrichment and Hygiene

Syndicated Data – NielsenIQ(CPG)

Certification

  • Statistics for Data Science and Business Analysis - Udemy
  • SQL - MySQL for Data Analytics and BI - Udemy
  • Power BI Essentials - LinkedIn Learning
  • Tableau Data Analyst/Specialist Desktop Certification - Udemy
  • IBM Business Intelligence Analyst - Foundation
  • IBM Practitioner Badge - Enterprise Design Thinking
  • Intermediate Python for Non-Programmers – LinkedIn
  • Google Tag Manager – LinkedIn
  • Google Analytics 4 – LinkedIn
  • SEO – Keyword Strategy – LinkedIn

Accomplishments

  • Represented the University at the All India Level (National Level) in the All India University Cricket Tournament.
  • Best Performer (Star Award) as a Data Processing Specialist for delivering high-quality projects with 117% efficiency.
  • Created process documentation at Netsurion (now Lumify), related to 'Lead Import Process', 'Salesforce Import Process' and 'Triblio Intent Data import process'.

Timeline

Marketing Data Analyst

Principal Financial Group
07.2023 - 09.2024

Line Chef

East Side Marios
05.2023 - 07.2023

Line Chef/Pizza Chef Assistant

Industria Pizzeria
05.2023 - 07.2023

Machine Operator

Maple Leaf Foods
02.2023 - 04.2023

Associate - Data Analyst, Marketing

Netsurion
08.2022 - 11.2022

Data Processing Specialist

NielsenIQ
11.2020 - 07.2022

Assistant Professor

Mervin Classes
01.2019 - 11.2020

Business Analysis Graduate Certificate -

Mohawk College

Masters of Commerce - Banking And Insurance

The Maharaja Sayajirao University of Baroda

Bachelors of Commerce - Accounting And Financial Management

The Maharaja Sayajirao University of Baroda
  • Statistics for Data Science and Business Analysis - Udemy
  • SQL - MySQL for Data Analytics and BI - Udemy
  • Power BI Essentials - LinkedIn Learning
  • Tableau Data Analyst/Specialist Desktop Certification - Udemy
  • IBM Business Intelligence Analyst - Foundation
  • IBM Practitioner Badge - Enterprise Design Thinking

What they say:

  • Kedar Bedekar joined our team as a Marketing Data Analyst at Principal Financial Group. I've had the pleasure of working closely with him during this time. He has demonstrated exceptional analytical skills that transforms complex data into actionable insights.
    He is able to clearly break down findings to both technical and non-technical stakeholders, ensuring that everyone involved understands the implications and recommended next steps. He works across various levels of our organization and consistently receives positive feedback for his willingness to collaborate and proactive nature. He would be a wonderful asset to any organization! - Sriyah Bissoon, Director Marketing Automation, Principal Financial Group
  • I had the pleasure of working alongside Kedar, and his expertise as a data analyst is truly remarkable. Kedar possesses immense knowledge about building effective workflows and ensuring data accuracy. His meticulous attention to detail and commitment to maintaining high data standards have been invaluable to our team. Kedar's ability to streamline processes and deliver accurate insights showcases his dedication to excellence. I wholeheartedly recommend Kedar for his exceptional skills in data analysis and workflow optimization. - Yagnesh Shinoy, Marketing Manager, Netsurion
  • Kedar was a big help in keeping our Martech engine running smoothly. He learned the nuances of our market/message/audience quickly, understood the tech stack and the data in place, and made an impact right away in ensuring reliable CRM data, implementing efficient procedures, and producing insightful/actionable reports. Thank you Kedar! - Aaron Branson, Senior Vice President of Marketing, Netsurion

Reference

Sriyah Bissoon Director - Marketing Automation Principal Financial Group

711 High St Des Moines, IA 50392 USA

bissoon.sriyah@principal.com

Yagnesh Shenoy - Marketing Manager Netsurion Technologies

2nd Floor, Indiqube, Penta # 51, Richmond Rd, Shanthala Nagar, Ashok Nagar, Bengaluru, Karnataka 560025, India

yagneshshenoy.y@gmail.com

Kedar Bedekar