SHIVA SHARMA
Gurugram
Summary
Results-driven data analyst with 5 years of experience, skilled in transforming complex data into strategic insights that drive business goals. Known for accuracy and efficiency, excelling in fast-paced environments while managing multiple priorities.
Overview
5
5
years of professional experience
Work History
Data Analyst
PIXL
11.2023 - Current
- Designed interactive marketing dashboards in Looker Studio, providing developers and brokers in the real estate sector with actionable insights.
- Developed an email marketing dashboard that consolidated leads and spend data from multiple platforms, streamlining campaign performance evaluations.
- Built and maintained HubSpot dashboards by integrating leads from various marketing campaigns, enabling detailed performance tracking and actionable insights.
- Managed and processed extensive datasets in Google Sheets, implementing segmentation strategies tailored to the MENA region for email campaigns.
- Conducted monthly data backups for leads and spend from Meta Ads, Google Ads, and TikTok Ads into BigQuery, ensuring accurate data management and retrieval.
- Created and maintained BigQuery tables, performing complex SQL queries to support marketing analytics and reporting.
Executive (Data & Analytics)
UM(Universal McCann)
09.2022 - 02.2023
- Developed and implemented comprehensive tracking tags for Meta, Snapchat, TikTok, and Google using Google Tag Manager, ensuring precision in multi-platform campaign tracking
- Leveraged Google Analytics for detailed funnel reporting and performance insights, enhancing data-driven decision-making for high-impact campaigns
- Built targeted audiences in Adjust to improve campaign tracking and engagement
- Created clear documentation for data layer setups on client websites, ensuring accurate data and better audience segmentation
Business Analyst
Axis Bank
04.2022 - 08.2022
- Executed SQL queries in SAS to extract precise data for business requirements, supporting cross-selling campaigns like gold loan promotions across email, SMS, and mobile banking
- Produced detailed reports to present findings, aiding stakeholders in strategic decision-making
Reporting Analyst
Publicis Media
03.2021 - 03.2022
- Gathered, cleansed, and validated data from CM360, DV360, and Google Ads Manager, integrating it into Datorama for analytics and reporting
- Worked with cross-departmental stakeholders to meet report requirements and prepared ad-hoc reports for senior management upon request
Process Associate
Cognizat Technical Services
09.2019 - 02.2021
- Resolved Google My Business (GMB) inquiries with a 98% error-free rate, ensuring customer satisfaction
- Supported customers in creating, verifying, and optimizing GMB listings to boost online visibility and business presence
Education
Bachelor of Science - Mathematics
Invertis University
Master of Science - Data Science
Liverpool John Moorse University
04.2022
Skills
SQL
Looker Studio or Google Data Studio
Spreadsheets and Advanced Excel
Tableau
Power BI
Python
Data Analysis
Statistics & SAS
Data Visualization and Presentation
Timeline
Data Analyst
PIXL
11.2023 - Current
Executive (Data & Analytics)
UM(Universal McCann)
09.2022 - 02.2023
Business Analyst
Axis Bank
04.2022 - 08.2022
Reporting Analyst
Publicis Media
03.2021 - 03.2022
Process Associate
Cognizat Technical Services
09.2019 - 02.2021
Bachelor of Science - Mathematics
Invertis University
Master of Science - Data Science
Liverpool John Moorse University
Similar Profiles
Waldemar TanjukjewitschWaldemar Tanjukjewitsch
3D Modeling Artist at PIXL VISN Media Arts Academy Cologne3D Modeling Artist at PIXL VISN Media Arts Academy Cologne
Naphtali JakerovNaphtali Jakerov
Character Animator at E-Pixl StudiosCharacter Animator at E-Pixl Studios
Joshua WegeJoshua Wege
3D Animator at PIXL VISN3D Animator at PIXL VISN