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
ChandigarhSkills
Tableau, Microsoft Excel, Microsoft Power BI,Microsoft Power Apps
Tools: TFSNow, AzureDevOps, SA360, Red hat, Kroger & Criteo retail
SQL, PL/SQL, Shell scripting
Framework: DevOps, Apache, Visual studio 2015Others: Application & Web Development, IITL ProcessJava/ J2EE OOPs, C#, Python
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