Summary
Overview
Work History
Education
Skills
Timeline
Generic

HARDIK MEHTA

Senior Analyst - Marketing Insights
Pathankot

Summary

2+ years of experience in Marketing domain to provide insights and perform band deep dives

4+ years of experience as an Analyst and a Team Lead handling multiple Google/Bing Campaigns.

Proven skills in Stake.

Overview

8
8
years of professional experience

Work History

Senior Data Analyst

PUBLICIS SAPIENT
07.2022 - Current
  • Brought in $120K worth of business as projects by pitching Brand-tracking report and dashboards to different markets which led to team expansion.
  • As lead was responsible for SPOC between client and team
  • Providing essential KPI's through report generation through Power Bi
  • Identifying product gaps and provided insights in market growth opportunities by preparing Brand deep dive.
  • Leading a team of 7 to drive multiple projects along with stakeholder management .
  • Performed Indexing, tuning ,optimization of queries.
  • Good understanding of ITIL (Incident Management, Problem Management, change management) Managed clients globally and resolving technical issue

Data Analyst

WEBLIQUIDS
08.2018 - 06.2022
  • Brought an approximate savings of $50K per year by delivering monthly Brand book as part of Holistic Brand Guidance system.
  • Reduced manual intervention by 35% by automating reports and insights through Power BI/Tableau
  • Accessed new probable competitors based on demographic factors and trends.
  • Designed plans to improve operations and suggested changes to systems for overall organization.
  • Created interactive reports for clients using BI for better understanding for KPI's.
  • Worked on Budget Pacing Optimization, Implementation and Report generation of multiple accounts on daily basis
  • Preparing daily, weekly, monthly reports as per client requirements
  • Pulling automated reports that will help clients make better judgments for implementations of changes that can benefit them to achieve desired target

SYSTEM ENGINEER

INFOSYS LTD.
07.2016 - 07.2018
  • Involved in Client interaction for gathering information and providing IT solutions.
  • Production support project for handling server files and memory management
  • Data recovery, monitoring production server and schedule jobs
  • Monitoring Incidents by using TFSNow/Service now
  • Achieved 40% efficiency gain by optimizing deployment time.
  • Daily application health checkup by using predefined script and creating scripts
  • Working and creating Stored Procedures.
  • Resolving end user raised Ticket (Incident) within SLA
  • Attend Weakly Client Meeting and Daily Operational Meeting on Bridge call
  • Good understanding of ITIL (Incident Management, Problem Management, Change management

Education

Bachelor of Engineering - Computer Science

Chitkara University
Chandigarh

Skills

    Tableau, Microsoft Excel, Microsoft Power BI,Microsoft Power Apps

undefined

Timeline

Senior Data Analyst

PUBLICIS SAPIENT
07.2022 - Current

Data Analyst

WEBLIQUIDS
08.2018 - 06.2022

SYSTEM ENGINEER

INFOSYS LTD.
07.2016 - 07.2018

Bachelor of Engineering - Computer Science

Chitkara University
HARDIK MEHTASenior Analyst - Marketing Insights