RAHUL SHARMA
Digital Marketing Analyst Data & Analytics Reporting
Gwalior, Madhya Pradesh, India +91-810******* *********@*****.*** PROFESSIONAL SUMMARY
Data Analyst with 2+ years of experience collecting, cleaning, validating, and auditing data from multiple sources (API, FTP, URL, XML) to ensure accuracy, consistency, and reliability for client reporting. Skilled in SQL, Excel/Google Sheets (pivot tables, VLOOKUP), and BI tools (Power BI, Tableau) for building and maintaining dashboards and reports on key metrics such as performance, revenue, and trends. Experienced in running data audits and quality checks to catch errors, discrepancies, and duplicates before they reach stakeholders — a QA mindset directly transferable to tracking audits (GA4/GTM), tag validation, and cross-platform data reconciliation. Comfortable documenting data processes and SOPs, maintaining data privacy and compliance, and collaborating with cross-functional teams to turn raw data into clear, decision-ready insights. Currently building hands-on proficiency in GA4, Google Tag Manager, and Looker Studio to extend this analytical foundation into digital marketing analytics. CORE SKILLS
Data Analytics & Reporting: Data Collection & Validation, Data Cleaning & Organization, Data Audits & Quality Checks (Errors & Duplicates), Dashboard Development & Reporting, Trend & Pattern Analysis, Data Reconciliation, SQL Querying, KPI Reporting Digital Analytics (learning / transferable): GA4 fundamentals, Google Tag Manager (GTM) concepts, UTM parameters & campaign tagging, conversion tracking principles, Looker Studio (in progress) Process & Collaboration: Process Documentation & SOPs, Data Privacy, Security & Compliance, Cross-Functional Collaboration, Stakeholder Communication, Attention to Detail, Organizational Skills Tools & Technologies: Microsoft Excel (Advanced – Pivot Tables, VLOOKUP, Formulas), Google Sheets, SQL, MySQL, Power BI, Tableau, Python, MongoDB, AWS Cloud (CloudFormation), HTML, CSS, JavaScript, React.js, Node.js, C++ PROFESSIONAL EXPERIENCE
Business Analyst — Cube27/BigCommerce July 2024 – Present
● Collect, clean, organize, and validate product data from multiple sources (API, FTP, URL, XML) to ensure accuracy and consistency across client catalogs and reporting — mirrors data-source reconciliation work (GA4 vs. platform admin totals).
● Run data audits and QA checks to identify and correct errors, discrepancies, and duplicates, improving data accuracy across client accounts — directly applicable to GA4/GTM audit and dataLayer validation workflows.
● Write and run SQL queries to extract, sort, and manipulate large data sets, supporting accurate reporting and faster resolution of data issues.
● Maintain and update databases, spreadsheets, and internal data systems, and streamline recurring data pipelines to reduce manual processing time.
● Analyze trends and patterns in product and catalog data to support business and reporting decisions, similar to surfacing anomalies in weekly/monthly performance reports.
● Collaborate with cross-functional teams to gather data requirements and deliver clear, decision-ready insights to client and internal stakeholders.
● Document data processes, definitions, and SOPs to standardize recurring tasks — comparable to building audit checklists and reporting templates.
● Ensure data privacy, security, and compliance with company policy while handling client data across import/export workflows.
Data Analyst Intern — Contechub March 2024 – May 2024
● Collected and analyzed RERA (real estate) data sets in Excel to identify market trends and patterns, supporting data-driven business decisions.
● Performed data cleaning, validation, and quality checks using pivot tables and formulas to ensure accuracy, consistency, and reliability prior to analysis.
● Built and maintained interactive Power BI dashboards and reports on key metrics to communicate findings clearly to non- technical stakeholders — the same reporting muscle needed for Looker Studio/Tableau client dashboards. PROJECTS
Netflix Shows & Movies Data Analysis — SQL, Excel, Tableau Mar 2023 – May 2023
● Analyzed a data set of 82,000+ rows using SQL, Excel, and Tableau to uncover content trends and viewership insights.
● Cleaned and simplified raw data to build clear, interactive dashboards highlighting platform-wide patterns. Customer Relationship Management System — Full-Stack Mar 2022 – Apr 2022
● Developed a full-stack CRM application with Angular 8 and Bootstrap on the front end and Spring Boot (REST API) with Spring Security (JWT authentication) on the back end. EDUCATION
B.Tech, Information Technology — Institute of Technology and Management, Gwalior 2024 — 7.1 CGPA Class XII – Madhya Pradesh Board (2020) – 75% Class X – CBSE (2017) – 76% CERTIFICATIONS
● AWS Cloud Foundations
● AWS Cloud Architecting
ACHIEVEMENTS
● All-Rounder Award — B.Tech/B.E.
● All-Rounder Award — School