Hello, I'm Mehdi Yazdanian, a data scientist with 15 years of engineering and analytics experience, specializing in generative AI, prompt engineering, and automation of repeatable workflows. I translate human text into actionable Pandas and SQL code, build RAG-enabled systems and generative-AI pipelines, and leverage AWS (EC2, Bedrock) for model development and data processing. I've delivered analytics pipelines and automated insights that drive measurable outcomes, including a 15% cost reduction in feed optimization. I am prepared to architect modular, maintainable AI-driven automation and LLM/agent integrations for content production, lead management, and analytics workflows.

Mehdi Yazdanian

Hello, I'm Mehdi Yazdanian, a data scientist with 15 years of engineering and analytics experience, specializing in generative AI, prompt engineering, and automation of repeatable workflows. I translate human text into actionable Pandas and SQL code, build RAG-enabled systems and generative-AI pipelines, and leverage AWS (EC2, Bedrock) for model development and data processing. I've delivered analytics pipelines and automated insights that drive measurable outcomes, including a 15% cost reduction in feed optimization. I am prepared to architect modular, maintainable AI-driven automation and LLM/agent integrations for content production, lead management, and analytics workflows.

Available to hire

Hello, I’m Mehdi Yazdanian, a data scientist with 15 years of engineering and analytics experience, specializing in generative AI, prompt engineering, and automation of repeatable workflows. I translate human text into actionable Pandas and SQL code, build RAG-enabled systems and generative-AI pipelines, and leverage AWS (EC2, Bedrock) for model development and data processing.

I’ve delivered analytics pipelines and automated insights that drive measurable outcomes, including a 15% cost reduction in feed optimization. I am prepared to architect modular, maintainable AI-driven automation and LLM/agent integrations for content production, lead management, and analytics workflows.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
See more

Language

English
Fluent
Afar
Advanced

Work Experience

Data Scientist / Analyst at Arona-Chemie Co
January 1, 2020 - Present
Conducted in-depth data analysis on livestock feed consumption and nutritional outcomes; built predictive models to forecast growth and feed requirements; applied advanced statistical methods to evaluate treatment effects; developed generative AI models and applied prompt engineering and RAG techniques to create automated insights and tailored recommendations; designed ETL workflows and automated data-processing pipelines; leveraged AWS (EC2, Bedrock) for scalable data processing and deployment-ready solutions.
Data Science / Analyst at Kajeh Art Institute
January 1, 2022 - January 1, 2024
Designed and implemented a comprehensive database for historical films and directors; cleaned and structured large film-archive datasets; developed a metadata framework to tag films by genre, era, and director to improve searchability and accessibility for content teams.
College Instructor at Conestoga College – ON
September 1, 2019 - December 1, 2024
Taught Microsoft Applications (PowerPoint, Word, Excel, Sway) to over 1,500 students; developed course materials and lesson plans; built a customized Excel exam system using VBA tied to student IDs to automate assessments; provided mentoring and participated in workshops to improve outcomes.
Pipe Stress Analyst at SNC-Lavalin & Worley Parsons
May 1, 2012 - December 1, 2016
Led a piping design team for mining projects; performed stress calculations and simulations to evaluate load impacts; coordinated with multidisciplinary teams; provided technical guidance during installation and commissioning; prepared technical reports and presentations for management and clients.
Data Scientist / Analyst at Kajeh Art Institute
January 1, 2022 - January 1, 2024
Designed and implemented a comprehensive database for historical films and directors, integrating archival records with modern analytics tools. Cleaned and structured large film-archive datasets using R and SQL to ensure data quality and consistency for downstream use. Developed a metadata framework to tag films by genre, era, and director, enabling improved searchability and accessibility for content teams.
Pipe Stress Analyst at SNC LAVALIN & WORLEY PARSONS
May 1, 2012 - December 1, 2016
Led a piping design team for mining projects, ensuring structural compliance and process flow integrity. Coordinated with multidisciplinary teams to develop detailed engineering designs that met industry standards and regulatory requirements. Performed stress calculations and simulations to evaluate load impacts and inform safe design choices. Worked cross-functionally to optimize pipe support and material selection, balancing technical and economic considerations. Provided technical guidance during installation and commissioning phases to ensure design intent was realized. Prepared technical reports and presentations to communicate project status and findings to senior management and clients.
Data Science | Analyst at Arona-Chemie Co
January 1, 2020 - Present
Conducted in-depth data analysis on livestock feed consumption and nutritional outcomes, identifying trends that improved feed formulation and optimized livestock health. Built predictive models in Python and R to forecast livestock growth and feed requirements, producing a 15% reduction in feed expenses. Applied advanced statistical methods (ANOVA, regression) to evaluate treatment effects and support data-driven operational decisions. Developed generative AI models and applied prompt engineering and RAG techniques to create automated insights and tailored recommendations for farm managers. Designed ETL workflows and automated data-processing pipelines to support routine reporting and analytics. Leveraged AWS technologies (EC2, Bedrock) for model development and scalable data processing in support of deployment-ready solutions. Collaborated with veterinarians, agronomists, and AI specialists to convert model outputs into actionable operational guidance.
Data Science | Analyst at Kajeh Art Institute
January 1, 2022 - January 1, 2024
Designed and implemented a comprehensive database for historical films and directors, integrating archival records with modern analytics tools. Cleaned and structured large film-archive datasets using R and SQL to ensure data quality and consistency for downstream use. Developed a metadata framework to tag films by genre, era, and director, enabling improved searchability and accessibility for content teams.
Data Scientist | Analyst at Arona-Chemie Co
January 1, 2020 - Present
Conducted in-depth data analysis on livestock feed consumption and nutritional outcomes; built predictive models in Python and R to forecast livestock growth and feed requirements; reduced feed expenses by 15% through data-driven optimization; developed generative AI models with prompt engineering and RAG techniques to produce automated insights and tailored recommendations for farm managers; designed ETL workflows and AWS-based processing to support scalable analytics and deployment.
Data Scientist | Analyst at Kajeh Art Institute
January 1, 2022 - January 1, 2024
Designed and implemented a comprehensive database for historical films and directors, integrated archival records with modern analytics tools; cleaned and structured large film-archive datasets using R and SQL; developed a metadata framework to tag films by genre, era, and director, enabling improved searchability and accessibility for content teams.
Data Science Analyst at Arona-Chemie Co
January 1, 2020 - Present
Conducted in-depth data analysis on livestock feed consumption and nutritional outcomes, identifying trends that improved feed formulation and optimized livestock health. Built predictive models in Python and R to forecast livestock growth and feed requirements, producing a 15% reduction in feed expenses. Applied advanced statistical methods (ANOVA, regression) to evaluate treatment effects and support data-driven operational decisions. Developed generative AI models and applied prompt engineering and RAG techniques to create automated insights and tailored recommendations for farm managers. Designed ETL workflows and automated data-processing pipelines to support routine reporting and analytics. Leveraged AWS technologies (EC2, Bedrock) for model development and scalable data processing in support of deployment-ready solutions. Collaborated with veterinarians, agronomists, and AI specialists to convert model outputs into actionable operational guidance.
Data Science Analyst at Kajeh Art Institute
January 1, 2022 - January 1, 2024
Designed and implemented a comprehensive database for historical films and directors, integrating archival records with modern analytics tools. Cleaned and structured large film-archive datasets using R and SQL to ensure data quality and consistency for downstream use. Developed a metadata framework to tag films by genre, era, and director, enabling improved searchability and accessibility for content teams.
College Instructor at Conestoga College – Ontario
September 1, 2019 - December 1, 2024
Taught Microsoft Applications (PowerPoint, Word, Excel, Sway) to over 1,500 students, emphasizing practical, job-ready skills. Developed course materials and lesson plans that simplified complex technical concepts for diverse learners. Built a customized Excel exam system using VBA tied to individual student IDs, demonstrating scripting and automation for assessment workflows.

Education

M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
Bachelor of Science at Brock University
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
M.A.Sc. at York University
January 11, 2030 - December 9, 2025
M.Sc. at University of Windsor
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
MBA at BSU
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
Bachelor's degree at Brock University
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
Bachelor's degree at Brock University
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
Bachelor's degree at Brock University
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
Bachelor's degree at Brock University
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering at York University
January 11, 2030 - December 9, 2025
M.Sc. in Physics at University of Windsor
January 11, 2030 - December 9, 2025

Qualifications

Generative AI for Data Scientists (Certificate)
January 11, 2030 - December 9, 2025
Generative AI for Data Scientists
January 11, 2030 - December 9, 2025
MBA
January 11, 2030 - December 9, 2025
M.A.Sc. in Engineering, Applied Engineering
January 11, 2030 - December 9, 2025
M.Sc. in Physics
January 11, 2030 - December 9, 2025
Bachelor's degree
January 11, 2030 - December 9, 2025
Generative AI for Data Scientists
January 11, 2030 - December 9, 2025

Industry Experience

Agriculture & Mining, Education, Manufacturing, Professional Services, Software & Internet, Media & Entertainment