Data analytics consultant @ Smollan | Data Operations, Data Transformation




Bachelor of Business Administration - BBA, Business Administration and Management, General
Vikram University

High school
GEMS Education
Join Samiya and 10k+ other professionals on
Tal is the app where bosses meet engineers & builders directly, without middlemen
Download Tal BossData analytics consultant @ Smollan | Data Operations, Data Transformation
Data Analytics Consultant with hands-on experience in data analysis and business insights. Currently supporting Google Pixel at Smollan within the US Promotions team. Responsible in managing SQL and Google Cloud datasets, automating reporting workflows, and integrating AI-driven logic to improve competitor analysis and retail insights.
Greater Indore Area
Data analytics Consultant at Smollan, Oct 2025 - Present · 8 mos, Client - Google Worked on data collection, validation, cleaning, and insertion using SQL and BigQuery for reporting and analysis Supported recurring (daily/weekly/yearly) KPI reporting and stakeholder reports using Google Sheets and Looker Performed data validation and reconciliation to ensure reporting accuracy and consistency across datasets. Performed data preparation and basic ETL to combine multi-source datasets for structured analysis and reporting Handled ad-hoc reporting requests and supported stakeholders with data queries and reporting-related clarifications Developed a Python-based automation to track banner positions and extract promotional data, reducing manual effort by ~40%
Data Analyst Intern at Smollan, Jul 2024 - Oct 2025 · 1 yr 4 mos, Managed and validated U.S. Google Pixel promotional data using SQL and Google Cloud datasets to ensure accuracy. Collected, cleaned, and integrated multi-source promotional data using Python for reporting and analysis. Built Python and Google Sheets based automations to reduce manual reporting and improve operational efficiency. Independently developed automations to track retail banner changes and support competitor analysis. Supported seniors with ad-hoc analyses, including competitor benchmarking, NEP comparisons, and promotion tracking. Resolved data discrepancies, troubleshot reporting issues, and supported time-sensitive business requests.
Sales Intern at Skillarena, Mar 2024 - Apr 2024 · 2 mos, Assisted with lead generation and follow-ups through cold calling to support customer acquisition. Gained hands-on exposure to client communication, persuasion techniques, and basic sales operations.
Bachelor of Business Administration - BBA, Business Administration and Management, General, Vikram University
High school, GEMS Education
github: https://github.com/Samiya234