Hello, I'm

Ayush Patel

Data Analyst

I transform raw data into actionable insights. Recently graduated with a Master's in Applied Computer Science from Concordia University, I specialize in data analysis, machine learning, and building data-driven solutions.

About Me

I'm a passionate data analyst with a strong foundation in computer science and a keen interest in transforming complex datasets into meaningful insights. My journey in data began during my undergraduate studies and intensified through my Master's program at Concordia University.

I specialize in statistical analysis, machine learning, and data visualization. I enjoy working with large datasets and finding patterns that drive business decisions. My technical background allows me to not only analyze data but also build scalable solutions and automate data pipelines.

When I'm not diving into data, you can find me exploring new technologies, contributing to open-source projects, or writing about data science on my blog.

Education

Master's in Applied Computer Science

Concordia University

Canada

2023 - 2025

Bachelor's in Computer Science

Gujarat Technological University

India

2019 - 2023

Skills & Technologies

Programming Languages

PythonSQLJavaRDAX

Data Visualization & BI

Power BITableauMatplotlibSeabornPlotlyExcel

Machine Learning & AI

TensorFlowCNNOpenCVLangChainNLPScikit-learn

Databases & Data Modeling

PostgreSQLMySQLFAISSRDBMSSchema DesignQuery Optimization

ETL & Data Processing

PandasNumPyData CleaningETL PipelinesData WranglingAzure Data Factory

Tools & Frameworks

JupyterGitFastAPIMavenJUnitVS Code

Cloud Platforms

Microsoft AzureAzure Data FactoryAWS Basics

Statistical Analysis

Regression AnalysisHypothesis TestingA/B TestingDescriptive StatisticsKPI Analysis

Projects

Adaptive Multi-Agent Chatbot System

Engineered a modular multi-agent system with specialized agents (General, AI, and Admissions) using dynamic routing to assign queries based on context. Implemented Q-learning algorithm that optimizes response parameters (temperature, top-p, max tokens) in real-time based on user feedback. Integrated LangChain's ConversationBufferMemory for multi-turn dialogue and FAISS vector store for past interaction retrieval. Augmented responses with Wikipedia API integration for factual data. Features a self-correcting feedback loop that penalizes generic answers and rewards high-quality outputs.

PythonOllamaLangChainFastAPIFAISSMistral

Bank Loan Performance Analysis

Developed a comprehensive suite of 3 dashboards (Summary, Overview, Details) tracking loan portfolio performance for a major financial institution. Engineered complex SQL queries and Power BI DAX measures for real-time KPI monitoring. Achieved clear visibility into 'Good' vs 'Bad' loan segmentation by DTI ratios, interest rates, and employment length. Implemented geospatial mapping and monthly trend forecasting to identify high-growth lending regions.

Total Applications

38.6K

Funded Amount

$435.8M

Avg Interest Rate

12.0%

Avg DTI

13.3%

SQLPower BIExcelData ModelingDAX

Facial Expression Recognition

Developed a Convolutional Neural Network (CNN) to classify facial images into four emotional categories: Angry, Neutral, Bored, and Focused. Combined FER2013 dataset with 1,500+ scraped images. Implemented HAAR classifiers for face detection and Unsharp Masking for image enhancement. Achieved 70% accuracy using Adam optimizer with early stopping across 100 epochs.

PythonCNNOpenCVMatplotlibTensorFlow

Warzone: Multi-Agent Strategy Game Engine

Built a 10,000+ line-of-code game engine in Java utilizing MVC pattern and SOLID principles for modularity. Engineered 4 distinct AI player modes (Aggressive, Benevolent, Random, Cheater) using the Strategy Pattern. Achieved high system stability through JUnit 5 testing suites with automated tournament modes and map validation logic. Integrated Java Serialization for state management and a custom Map Editor for .map file parsing.

System Architecture

ControllerModelViewStrategyObserverBuilder
JavaMavenJUnit 5Java SwingDesign Patterns

Professional Experience

A track record of delivering impactful data solutions across academic and industry settings.

Academic

Teaching Assistant

Concordia University

Jan 2024 - Aug 2025
Canada
  • Enhanced student technical proficiency in RDBMS and Python for a cohort of 50+ students
  • Simplified complex concepts including SQL query optimization, regression analysis, and schema normalization
  • Guided students through final project delivery with hands-on mentoring and code reviews
  • Created supplementary learning materials and conducted tutorial sessions
SQLPythonRDBMSData Analysis
Industry

Data Analyst

Vinrox Technologies

Jun 2022 - Jul 2023
India
  • Reduced manual reporting cycles by approximately 30% through dashboard automation
  • Engineered interactive KPI dashboards in Power BI and Tableau for stakeholder decision-making
  • Automated ETL workflows via Azure Data Factory and SQL stored procedures
  • Collaborated with cross-functional teams to identify key metrics and reporting requirements
Power BITableauAzureSQLETL
Industry

Data Analyst

Barodaweb

Jan 2022 - May 2022
India
  • Developed and deployed a centralized Employee Record Management System
  • Achieved significant reduction in record-retrieval time improving organizational efficiency
  • Designed and implemented database schema with optimized indexing strategies
  • Built CRUD operations with data validation and error handling mechanisms
SQLPythonDatabase DesignCRUD

Certifications

Continuous learning through industry-recognized certifications and courses.

The Complete SQL

Udemy

Completed
View Credential

Power BI for Business Intelligence

Udemy

Completed
View Credential

Node.js, Express, MongoDB & More: The Complete Bootcamp

Udemy

Completed

PL-300: Microsoft Power BI Data Analyst

Microsoft (Exam Preparation)

Completed

AZ-900: Microsoft Azure Fundamentals

Microsoft

In Progress

What's Next?

Get In Touch

I'm currently looking for full-time opportunities as a Data Analyst. Whether you have a question, a potential opportunity, or just want to connect, feel free to reach out. I'll do my best to get back to you!

Canada