Shikhar Singh

Shikhar Singh

Data Analyst
India
Hindi, English

About Me

Aspiring Data Analyst with over 2 years of experience in digital marketing analytics. Proficient in tracking
performance metrics, data cleaning, and visualization creation using Datorama. Successfully delivered
comprehen…

Experience

Associate Analyst

Annalect · Gurgaon, India
Mar 2023 - Dec 2024 · 1 year 8 months

Worked on the regular tracking and enhancement of key performance metrics in the digital marketing industry,including impressions, clicks, media cost, CPM, and CPC.Analyzed patterns and trends in visualizations, delivering comprehensive reports to stakeholders to facilitateoptimal business solutions.Maintained and enhanced dashboards on Datorama / Marketing Cloud Intelligence for media data andmarketing data.Performed data cleaning, quality assurance, and streamlined report delivery processes.Created taxonomy dashboards to identify mismatching data at a granular level.Documented procedures and developed standard operating procedures (SOPs) for routine/ repetitive tasks.

Associate

Annalect
Apr 2023 - Dec 2024 · 1 year 8 months

Worked on regular tracking and improvement of key performance metrics in digital marketing industry (e.g., Impressions, Clicks, Media Cost, CPM, CPC etc.), analysing patterns/trends in visualizations and providing final reports to stakeholders to help achieve optimal business solutions.
Responsible for creating and transforming dashboards on Datorama / Marketing Cloud Intelligence for Media Data or Marketing Data, to help stakeholders derive valuable insights.
Performed the data cleaning, QA and final report delivery processes as well as regular checks on details such as minute changes in key dimensions/measurements, created taxonomy dashboards to identify mismatching data at granular level.
Worked on documentation and creating SOP’s of routine/ repetitive work and ad-hoc tasks to achieve streamlining of processes and ease of use in data analysis for end users.

Junior Associate

Annalect · Gurgaon, India
Jun 2022 - Mar 2023 · 9 months

Responsible for data extraction, validation, quality assurance processes, and produced final reports.Enhanced the quality assurance and maintenance of reports by refining the interpretation of raw data.Analyzed historical data and tracked changes in data patterns through key performance indicators (KPIs).

Junior Associate

Annalect
Jul 2022 - Mar 2023 · 8 months

Responsible for Data extraction, Data validation, QA process and generating Final reports to offshore team to help gather insights on campaign performance.
Worked on the Quality Assurance and maintenance of reports through refining the interpretation of raw data, task-assignment trackers, QA reports etc.
Analyzed historical data, kept track on changes in data patterns through KPI’s and improved data accuracy to provide more stabilized and static data to offshore team.

Graduate Trainee

Annalect
Mar 2022 - Jun 2022 · 3 months

Hands on training on the basics of Digital Marketing and a Final Project on Marketing Science.
Award - Ace of Academy Award

Graduate Trainee

Annalect · Gurgaon, India
Feb 2022 - May 2022 · 3 months

Engaged in hands-on training on the fundamentals of digital marketing.Worked on a final project on marketing science.Received the Ace of Academy Award for outstanding performance.

Certifications

Google Data Analytics Professional Certificate

Coursera · Lucknow, India · 2021

Skills

Microsoft Excel Problem Solving Data Analysis Communication Data Cleansing Data Extraction Data Validation MSSQL Salesforce Marketing Cloud Data Visualization Tableau SQL Datorama / Marketing Cloud Intelligence Excel Tableau (Basics) DV360 Facebook CM360 TTD Google Ads
Report this Profile?