Kedar Bedekar
Marketing Data Analyst
Orangeville,ON
Summary
Dynamic Data Analyst with 5 years of blended experience in delivering accurate reports and creating insights through data visualization to support decision-making. Proficient in SQL queries and data analysis, with proven expertise in multiple domains, including Marketing, consumer research, and data analysis using ERP. Experienced with B2B and B2C market research. Demonstrated ability to understand complex data requirements and provide actionable insights. I am seeking a challenging opportunity to leverage my data analysis knowledge and business analyst mindset to drive organizational effectiveness.
Overview
5
5
years of professional experience
6
6
Certification
5
5
years of post-secondary education
Work History
Marketing Data Analyst
Principal Financial Group
Canada, Remote
07.2023 - Current
- 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.
Education
Post Graduate Certificate - Business Analysis
Mohawk College
01.2023 - 10.2023
Masters of Commerce - Banking And Insurance
The Maharaja Sayajirao University of Baroda
India 06.2018 - 04.2020
Bachelors of Commerce - Accounting And Financial Management
The Maharaja Sayajirao University of Baroda
06.2014 - 04.2017
Skills
- SQL
- Python
- Syndicated Data - Nielsen
- Microsoft Excel
- Marketing Analysis
- Data Visualization
- Lead generation management
- Tableau
- Power BI
- Statistics
- Salesforce Data Cloud - SFDC
- Salesforce Marketing Cloud
- ERP System
- Process Creation
- Microsoft PowerPoint
- Microsoft Word
- Data Models
- Process Documentation
- Communication
- Stakeholder Management
- Requirements Gathering
- VBA
- Data Enrichment
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
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'.
Work Preference
Work Type
Full TimeLocation Preference
On-SiteHybridRemoteImportant To Me
Work-life balanceCompany CultureWork from home optionQuote
"Work not what you are paid for, but what you are made for."
Suresh Nambiar, NIQ
Timeline
Marketing Data Analyst
Principal Financial Group
07.2023 - Current
Post Graduate Certificate - Business Analysis
Mohawk College
01.2023 - 10.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
Masters of Commerce - Banking And Insurance
The Maharaja Sayajirao University of Baroda
06.2018 - 04.2020
Bachelors of Commerce - Accounting And Financial Management
The Maharaja Sayajirao University of Baroda
06.2014 - 04.2017
Similar Profiles
Sarah HockettSarah Hockett
Product Manager 1 at Principal Financial Group, Elevate by PrincipalProduct Manager 1 at Principal Financial Group, Elevate by Principal
ERIC ANDREWSERIC ANDREWS
Client Service Representative at Principal Financial GroupClient Service Representative at Principal Financial Group
Brett StewartBrett Stewart
Director of Engineering at Principal Financial Group IncDirector of Engineering at Principal Financial Group Inc
Kimberly J. BridgesKimberly J. Bridges
Assistant Director - Benefits at Principal Financial GroupAssistant Director - Benefits at Principal Financial Group
Aldane HutchinsonAldane Hutchinson
Finish Carpenter at Linkay Inc.Finish Carpenter at Linkay Inc.