Prompt search

Ask the system before the portfolio loads

>
Searching public portfolio graph
Reading BI, ETL, reporting, and AI automation systems
Matched profile: Data Analytics and AI Automation
Opening Vatsal Rakholiya portfolio
Vatsal Rakholiya

Data analytics and AI automation specialist building BI, ETL, and reporting systems.

Vatsal Rakholiya

Data Analyst focused on BI dashboards, ETL workflows, reporting automation, and AI-assisted insights.

Data Analyst with 3+ years of experience in SQL, Python, Power BI, Tableau, data analysis, reporting, ETL, and data quality. Skilled in developing dashboards, optimizing queries, automating reporting workflows, integrating data, and delivering actionable business insights. Experienced with AWS, Azure, Snowflake, SQL Server, PostgreSQL, Oracle, and Generative AI tools including ChatGPT and Microsoft Copilot.

Explore projectsContactLinkedInResume
Scarborough, Ontario, Canada
LinkedInGitHub

( The step aside )

Analytics should make operations clearer.

I turn scattered operational data into dashboards, automated reporting workflows, ETL pipelines, data quality checks, and AI-assisted insights teams can actually use.

Current focus

Data Analytics and AI Automation

50K+

business records analyzed monthly

20+

KPIs tracked across dashboards

10+

recurring management reports supported

10 hrs

monthly reporting effort automated

case files

Works

Good data systems communicate. Great models surprise.

Each project is framed like an operational model: inputs, decisions, outputs, and measurable business impact.

01

model system

Industrial Image Processing Color Separation Automation

Computer vision workflow for CMYK/TIFF prepress automation

Automated CMYK/TIFF artwork separation with channel extraction, tolerance-based mask generation, preview inspection, and production-focused image processing workflows.

PythonNumPyOpenCVTIFFFlaskReact
  • - Reduced manual prepress review from 24+ hours to minutes
  • - Vectorized pixel-level processing

02

model system

Housing Operations Hub

Operations workspace for housing program visibility

Designed an evidence workspace to organize housing-related operational data, documents, and case information in one centralized web application.

Next.jsTypeScriptDashboardsWorkflow DesignData Quality
  • - Centralized housing updates, notes, and status tracking
  • - Improved review visibility across operational records
  • - Designed reporting views for faster stakeholder decisions
  • - Added quality checks for incomplete or inconsistent inputs

03

model system

Cryptocurrency Market Intelligence & Prediction Platform

Forecasting and sentiment intelligence across digital assets

Architected an analytics platform tracking 16,000+ cryptocurrencies through market APIs and automated ingestion pipelines, with price forecasting and real-time news sentiment.

TensorFlowLSTMGradient Boosted TreesBERTMarket APIsDashboards
  • - 16,000+ assets tracked
  • - Weekly percentage movement forecasting
  • - Real-time sentiment signals

04

model system

Document Intelligence System

Semantic search, summarization, and QA over private documents

Built document summarization, semantic search, sentiment extraction, and question-answering workflows using transformer embeddings, FAISS indexing, a Streamlit interface, and FastAPI backend services.

PythonHugging FaceFAISSFastAPIStreamlitDocker
  • - Transformer embeddings
  • - Retrieval-augmented QA
  • - Dockerized backend services

research

Publications

01/10/2025

Adversarial Vulnerabilities in Machine Learning: Differential Analysis of Gradient and XGBoost-Based Attack Mechanisms

Paper ID: ICUIS-383

Compared gradient-based and XGBoost attack mechanisms and limitations of adversarial training for tree ensemble models.

capability map

Skills

Practical tools for machine learning, automation, analytics, and applied AI delivery.

01 / system

Data Analytics & BI

Data AnalysisExploratory Data AnalysisKPI ReportingDashboard DevelopmentBusiness IntelligenceAd Hoc AnalysisTrend AnalysisData VisualizationPower BITableauPower BI Report Builder

02 / system

Data Engineering & ETL

ETL/ELTData IntegrationData PipelinesData TransformationData CleaningData QualityData ValidationData ReconciliationWorkflow AutomationSSISAlteryxApache AirflowAWS Glue

03 / system

Data Modeling & Governance

Dimensional ModelingSemantic ModelingData WarehousingStar SchemaTransformation ModelsData LineageMetadata ManagementData GovernanceData Quality Management

04 / system

SQL & Databases

SQLAdvanced SQLQuery OptimizationStored ProceduresRelational DatabasesDatabase DesignSchema DevelopmentIndexingPerformance TuningSQL ServerPostgreSQLOracleMySQL

05 / system

Cloud & Data Platforms

AWSAmazon S3Amazon RedshiftAzureAzure Data LakeSnowflakeCloud Data PlatformsCloud Data Integration

06 / system

Programming, AI & Automation

PythonPandasNumPyPython AutomationScriptingREST API IntegrationGenerative AIAI-Assisted Data AnalysisPrompt EngineeringMicrosoft CopilotChatGPTAI-Assisted Reporting

credentials

Certifications

University of Michigan via Coursera

Understanding and Visualizing Data with Python

Used Python to summarize, visualize, and interpret univariate and multivariate data.

Coursera

AWS S3 Basics

Configured S3 buckets, object access, encryption, versioning, lifecycle rules, and static hosting basics.

Coursera

Machine Learning Pipelines with Azure ML Studio

Built and deployed an end-to-end predictive pipeline using Azure ML Studio workflows.

University of Pennsylvania via Coursera

Fundamentals of Quantitative Modeling

Studied model structure, assumptions, and quantitative reasoning for business and financial analysis.

Coursera

Business Analysis & Process Management

Practiced process mapping, stakeholder analysis, and workflow improvement for business operations.

Coursera

Agile Project: Product Prototype Touchpoint Analysis in Miro

Mapped product touchpoints in Miro to analyze user flow, feedback loops, and agile prototype decisions.

timeline

Experience

Nov 2025 - Present

Data Analyst

Loblaw Companies / Canada

  • - Analyze 50K+ business records monthly using Advanced SQL and Python to identify trends, anomalies, and performance patterns, supporting 10+ recurring management reports and business performance reviews.
  • - Develop and maintain 4+ Power BI and Tableau dashboards tracking 20+ KPIs, enabling stakeholders to monitor business performance, identify trends, and support data-driven decisions.
  • - Optimize SQL queries and stored procedures across relational databases, improving average query execution time by 15% and increasing the efficiency of recurring reporting processes.
  • - Automate 3+ recurring data preparation and reporting workflows using Python and ETL tools, saving approximately 10 hours per month in manual reporting effort.

Jul 2022 - Aug 2024

Junior Data Analyst

AIS Technolabs / Ahmedabad, Gujarat, India

  • - Performed data validation and quality checks on 10K+ records monthly, identifying missing values, duplicates, formatting issues, and inconsistencies to improve data accuracy.
  • - Prepared and transformed data across 10+ business datasets using SQL, Python, Pandas, and NumPy to support ad hoc analysis and operational reporting.
  • - Conducted exploratory data analysis on 8+ datasets, identifying outliers, patterns, correlations, and unusual data behavior to support business investigations.
  • - Supported 3+ ETL/ELT workflows using SSIS, Alteryx, AWS Glue, and Apache Airflow, assisting with data extraction, transformation, validation, and workflow monitoring.

Education

Sep 2025 - Apr 2026

Post Graduate Diploma - Financial Technology

Seneca Polytechnic, Ontario, Canada / GPA 3.5/4.0

Sep 2024 - Apr 2025

Post Graduate Diploma - Artificial Intelligence

Fleming College, Ontario, Canada / GPA 3.8/4.0

Aug 2020 - May 2023

Bachelor of Engineering - Information and Communication Technology

Gujarat Technological University, Gujarat, India / GPA 3.9/4.0

contact

Send a project signal

Reach out about data analytics roles, BI systems, ETL workflows, reporting automation, or AI-assisted analytics products.

vatsalrakholiya6@gmail.com