Hi, my name is Ayush Gupta, and I am an Information Technology student at York University with hands-on co-op experience in data analytics, database development, and enterprise systems. I am currently working as a Business Analyst – Data & Analytics (Co-op) with the Ontario Public Service, where I analyzed and validated 500,000+ records during a large-scale Curam system migration using SQL-based data validation. I also managed QA and UAT test cases and built Tableau dashboards to support data quality, reporting accuracy, and stakeholder decision-making. Previously, I worked as a Database Developer (Co-op) at Richardson Wealth, where I developed optimized SQL queries, automated ETL workflows, and created Power BI and SSRS reports to improve operational efficiency and business insights. In this role, I collaborated closely with cross-functional teams to translate business requirements into scalable, data-driven solutions across public and financial services environments. In addition to my professional experience, I have built several end-to-end data projects, including a real-time cryptocurrency data pipeline using Python, Apache Airflow, Docker, and Microsoft SQL Server, with interactive Power BI dashboards for live market analysis. I also developed a ChatGPT efficiency evaluation platform using Node.js, Express, MongoDB, WebSockets, and Chart.js to assess large language model accuracy and performance across structured datasets. My interests lie at the intersection of business analysis, data engineering, and analytics, with a strong focus on data quality, automation, cloud platforms, and scalable data solutions. I am motivated to work on projects that turn complex data into actionable insights and deliver measurable business impact.

Ayush Gupta

Hi, my name is Ayush Gupta, and I am an Information Technology student at York University with hands-on co-op experience in data analytics, database development, and enterprise systems. I am currently working as a Business Analyst – Data & Analytics (Co-op) with the Ontario Public Service, where I analyzed and validated 500,000+ records during a large-scale Curam system migration using SQL-based data validation. I also managed QA and UAT test cases and built Tableau dashboards to support data quality, reporting accuracy, and stakeholder decision-making. Previously, I worked as a Database Developer (Co-op) at Richardson Wealth, where I developed optimized SQL queries, automated ETL workflows, and created Power BI and SSRS reports to improve operational efficiency and business insights. In this role, I collaborated closely with cross-functional teams to translate business requirements into scalable, data-driven solutions across public and financial services environments. In addition to my professional experience, I have built several end-to-end data projects, including a real-time cryptocurrency data pipeline using Python, Apache Airflow, Docker, and Microsoft SQL Server, with interactive Power BI dashboards for live market analysis. I also developed a ChatGPT efficiency evaluation platform using Node.js, Express, MongoDB, WebSockets, and Chart.js to assess large language model accuracy and performance across structured datasets. My interests lie at the intersection of business analysis, data engineering, and analytics, with a strong focus on data quality, automation, cloud platforms, and scalable data solutions. I am motivated to work on projects that turn complex data into actionable insights and deliver measurable business impact.

Available to hire

Hi, my name is Ayush Gupta, and I am an Information Technology student at York University with hands-on co-op experience in data analytics, database development, and enterprise systems. I am currently working as a Business Analyst – Data & Analytics (Co-op) with the Ontario Public Service, where I analyzed and validated 500,000+ records during a large-scale Curam system migration using SQL-based data validation. I also managed QA and UAT test cases and built Tableau dashboards to support data quality, reporting accuracy, and stakeholder decision-making.

Previously, I worked as a Database Developer (Co-op) at Richardson Wealth, where I developed optimized SQL queries, automated ETL workflows, and created Power BI and SSRS reports to improve operational efficiency and business insights. In this role, I collaborated closely with cross-functional teams to translate business requirements into scalable, data-driven solutions across public and financial services environments.

In addition to my professional experience, I have built several end-to-end data projects, including a real-time cryptocurrency data pipeline using Python, Apache Airflow, Docker, and Microsoft SQL Server, with interactive Power BI dashboards for live market analysis. I also developed a ChatGPT efficiency evaluation platform using Node.js, Express, MongoDB, WebSockets, and Chart.js to assess large language model accuracy and performance across structured datasets.

My interests lie at the intersection of business analysis, data engineering, and analytics, with a strong focus on data quality, automation, cloud platforms, and scalable data solutions. I am motivated to work on projects that turn complex data into actionable insights and deliver measurable business impact.

See more

Experience Level

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

Language

English
Fluent

Work Experience

Business Analyst – Data & Analytics (Co-op) at Ontario Public Service – Ministry of Public and Business Service Delivery
September 1, 2025 - Present
Analyzed and validated 500K+ records during the Curam v7 to v8 migration using SQL-based data validation, ensuring reporting accuracy and data integrity. Developed 50+ SQL queries to verify migration, improving validation efficiency by 30%. Managed 100+ data validation and QA test cases in Azure DevOps, tracking defects and reporting analytics readiness to stakeholders. Built Tableau dashboards to monitor migration metrics, enhancing decision-making by 35%. Collaborated with cross-functional teams to map ETL processes and resolve data issues, improving data consistency by 15%.
Database Developer (Co-op) at Richardson Wealth Ltd.
September 1, 2024 - April 1, 2025
Developed optimized SQL queries and automated ETL workflows, reducing data processing time by 25%. Created 25+ Power BI and SSRS reports, boosting operational efficiency by 20% and improving business insights. Applied machine learning techniques for predictive and trend analysis, contributing to increased company revenue. Collaborated with cross-functional teams to translate business requirements into effective data-driven solutions.

Education

Bachelor in Information Technology at York University
January 11, 2030 - April 1, 2027
Diploma in Business Management and Information Systems at Centennial College
January 1, 2018 - December 1, 2019

Qualifications

Add your qualifications or awards here.

Industry Experience

Government, Financial Services, Education, Professional Services, Software & Internet