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

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

Associate

Annalect
Apr 2023 - Dec 2024 · 1 year 8 months

<p>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.<br>
Responsible for creating and transforming dashboards on Datorama / Marketing Cloud Intelligence for Media Data or Marketing Data, to help stakeholders derive valuable insights.<br>
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.<br>
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.</p>

Junior Associate

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

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

Junior Associate

Annalect
Jul 2022 - Mar 2023 · 8 months

<p>Responsible for Data extraction, Data validation, QA process and generating Final reports to offshore team to help gather insights on campaign performance.<br>
Worked on the Quality Assurance and maintenance of reports through refining the interpretation of raw data, task-assignment trackers, QA reports etc.<br>
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.</p>

Graduate Trainee

Annalect
Mar 2022 - Jun 2022 · 3 months

<p>Hands on training on the basics of Digital Marketing and a Final Project on Marketing Science.<br>
Award - Ace of Academy Award</p>

Graduate Trainee

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

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

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?