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
Data Visualization & BI
Machine Learning & AI
Databases & Data Modeling
ETL & Data Processing
Tools & Frameworks
Cloud Platforms
Statistical 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.
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%
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.
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
Professional Experience
A track record of delivering impactful data solutions across academic and industry settings.
Teaching Assistant
Concordia University
- 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
Data Analyst
Vinrox Technologies
- 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
Data Analyst
Barodaweb
- 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
Certifications
Continuous learning through industry-recognized certifications and courses.
The Complete SQL
Udemy
Power BI for Business Intelligence
Udemy
Node.js, Express, MongoDB & More: The Complete Bootcamp
Udemy
PL-300: Microsoft Power BI Data Analyst
Microsoft (Exam Preparation)
AZ-900: Microsoft Azure Fundamentals
Microsoft
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!