Saimeghana Sangawar

Data Analyst

Results-driven Data Analyst with expertise in data pipelines, ETL workflows, catalog analytics, and dashboard reporting. Experienced in transforming complex datasets into actionable business insights across retail and e-commerce domains.

Follow me:

5 Years of experience

Saimeghana

About Me

Data Analyst with strong expertise in building scalable data pipelines, performing catalog analytics, and delivering AI-driven insights. Experienced in ETL automation, SQL optimization, KPI monitoring, and dashboard development using Power BI and Tableau. Proven ability to improve data quality, enhance operational efficiency, and support data-driven decision-making across large-scale retail and e-commerce platforms.

My expert
areas

Specialized in data engineering, ETL automation, catalog analytics, dashboard reporting, SQL optimization, and AI-enabled data solutions for scalable retail and e-commerce operations.

Skills

Python & Data Pipelines

SQL Optimization (MySQL, PostgreSQL)

Power BI & Tableau Dashboards

ETL Workflow Automation

Data Quality & Validation

Marketing & KPI Analytics (GA4)

5
Years of Experience
100
Vendor Records Processed (in Thousands)
1000
SKUs Managed & Analyzed
40
Team Members Trained

Education

Post Graduate Diploma in Computer Software and Database Development

Loyalist College

Markham

January 2024 – August 2025

Bachelor’s in Computer Science

Guru Nanak Institute of Technology

India

March 2014 – March 2018

Experience

Insight Forge BI

Data Quality Associate | Nov 2025 – Present | Vancouver, BC

Examined 50+ transactional and product data records to identify patterns and insights.
Conducted quality validation by comparing datasets against fact sheets using Excel.
Identified anomalies and inconsistencies to ensure data integrity.
Prepared weekly performance reports and visual dashboards in Tableau.

Reliance Retail

Sr. Data Analyst | January 2022 – August 2023

Built Python and R scraping pipelines with YAML configurations to process 100k+ vendor records.
Developed ETL workflows improving data consistency by 42%.
Optimized SQL queries using CTEs and window functions, increasing throughput by 35%.
Led catalog analytics pilot detecting pricing gaps across 500+ SKUs.
Designed KPI dashboards integrating SQL and R outputs ensuring 100% reporting accuracy.

Amazon

Catalog Manager | August 2018 – January 2023

Managed 1000+ SKUs using SQL, ERP, and Alteryx tools.
Improved catalog accuracy by 18% using Power BI and Databricks SQL.
Applied Python for data cleaning and predictive analysis improving efficiency 15%.
Trained 40+ associates and standardized catalog workflows.
Implemented SQL monitoring dashboards reducing manual errors by 30%.

Projects

Fin’Answer’

Personal Project

Team Lead / Data Analyst

Skills Used

Python, SQL, ETL Pipelines, MongoDB, Groq AI, Google Embeddings, KPI Reporting

Key Roles

Developed full-stack application integrating Groq AI, Google Embeddings, and MongoDB achieving 100% query coverage.
Built automated ETL pipelines for multi-source financial data improving efficiency by 45% with sentiment tagging.
Designed structured data pipelines for trading bot signals with fine-tuned sentiment models ensuring 100% accuracy.
Implemented real-time SQL reporting and KPI monitoring improving reporting accuracy by 30%.

Freelance – E-commerce Sales Analytics

Freelance Project

Data Analyst

Skills Used

Power BI, Python (Pandas), Excel, A/B Testing, Data Cleaning, Sales Analytics

Key Roles

Analyzed 100+ transaction records to identify sales trends, seasonal patterns, and customer behavior insights.
Built interactive dashboards in Power BI visualizing sales by product, region, and time period.
Cleaned and transformed raw datasets using Excel and Python (Pandas), reducing data inconsistencies by 25%.
Conducted A/B analysis on promotional campaigns, identifying strategies that increased conversion by 12%.