I have over three years of experience in Data Analytics within the e-commerce domain, with strong proficiency in SQL, Power BI, and Excel. My expertise includes data cleaning, transformation, and visualization to support data-driven decision-making. Over the years, I’ve developed and optimized dashboards, written complex SQL queries, and delivered actionable insights to improve business performance.

Foram Pandya

I have over three years of experience in Data Analytics within the e-commerce domain, with strong proficiency in SQL, Power BI, and Excel. My expertise includes data cleaning, transformation, and visualization to support data-driven decision-making. Over the years, I’ve developed and optimized dashboards, written complex SQL queries, and delivered actionable insights to improve business performance.

Available to hire

I have over three years of experience in Data Analytics within the e-commerce domain, with strong proficiency in SQL, Power BI, and Excel. My expertise includes data cleaning, transformation, and visualization to support data-driven decision-making. Over the years, I’ve developed and optimized dashboards, written complex SQL queries, and delivered actionable insights to improve business performance.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert

Language

English
Fluent

Work Experience

Data Quality Analyst at Cleanaway Waste Management
May 1, 2025 - November 8, 2025
Verified data integrity by reconciling information across VRP, Oracle JDE, and Salesforce; identified and corrected discrepancies through pre-migration checks. Used SQL to extract and analyze data from Master Data Management systems, supporting validation and quality assurance initiatives. Led initial Azure DevOps configuration (project teams, workflows, sprints, area hierarchies) to optimize task management and coordination. Positioned AMCS as a centralized data hub to enable consistent, insight-based decision-making after system migration.
Data Engineer at Liases Foras
January 31, 2025 - January 31, 2025
Developed web scrapers using Requests and Beautiful Soup to extract data from websites. Preprocessed and cleaned scraped data for consistency and usability. Stored data in MongoDB for unstructured data and MySQL for structured data. Optimized data storage and performance in both databases.
E-commerce Data Analyst at Hoverboards
April 1, 2025 - April 1, 2025
Engineered interactive Power BI dashboards using DAX to visualize SEO and e-commerce KPIs, contributing to a 15% increase in organic traffic. Created a centralized data model in Power BI by extracting, gathering, cleaning, and preparing SEO, sales, and customer data from SQL Server, enabling faster reporting and a 40% reduction in reporting time. Leveraged Power Query for ETL to clean and integrate data from multiple sources, improving data quality by 30%. Extracted and analyzed SEO data from Shopify, SEMrush, and Ahrefs to support keyword and traffic analysis and improve reporting accuracy by 20%.
Digital Analyst at Webgyor Technologies
October 31, 2019 - October 31, 2019
Performed keyword research to identify high-value keywords and developed on-page SEO strategies. Conducted comprehensive SEO audits using Google Search Console, SEMrush, and Ahrefs to identify technical issues and optimize performance. Built and maintained SEO dashboards in Power BI to track KPIs such as impressions, clicks, CTR, bounce rate, and keyword rankings.

Education

Master's in Business Analytics, Accounting and Finance at Deakin University
March 1, 2008 - November 1, 2011

Qualifications

Microsoft Certified: Azure Fundamentals (AZ-900)
January 11, 2030 - November 8, 2025
CodeBasics Bootcamp: Data Analytics (Excel | Power BI | SQL)
January 11, 2030 - November 8, 2025
HackerRank SQL: Intermediate / Basic
January 11, 2030 - November 8, 2025

Industry Experience

Software & Internet, Retail, Professional Services, Media & Entertainment