Aryan Rai

About

Detail-oriented B.Tech student specializing in Computer Science with a focus on Artificial Intelligence and Data Science. Proficient in Python, SQL, Excel, and Power BI for data cleaning, exploratory analysis, dashboard development, and business insight generation.

Education

• B.Tech
  IIMT College of Engineering · ASN SR SEC SCHOOL
  Computer Science (AI & Data Science) · 2023 – 2027

Skills

• SQL
• Git
• GitHub
• Data Analytics
• Python
• Jupyter Notebook
• Power BI
• Tableau
• MySQL
• VS Code
• Statistics
• SQLite
• Google Sheets
• HTML&CSS
• Microsoft Excel
• Excel
• Probability
• PowerBI

Projects

• Healthcare Data Analysis Dashboard
  Excel, Power BI, SQL

  Analyzed hospital and patient records to extract, clean, and aggregate data on admissions, treatment costs, and department-wise performance. Built interactive Power BI dashboards to track healthcare KPIs and delivered actionable insights for resource allocation and operational efficiency.

• PhonePe Transaction Data Analysis
  Python, SQL, excel, power BI

  Performed data cleaning, preprocessing, and exploratory data analysis on PhonePe transaction datasets to identify user payment behavior and growth trends. Created visualizations and generated insights on digital payment adoption and transaction trends.

• ola data analysis
  SQL, excel, power BI
• Ola Ride Data Analysis
  SQL, Excel, Power BI

  Analyzed Ola ride-booking data to extract, clean, and aggregate records on ride volume, cancellations, and ratings. Built interactive Power BI dashboards and used SQL and Excel to identify trends, high-cancellation zones, and service quality insights.

Courses & certifications

• Google Data Analytics Professional Certificate · Google / Coursera
• IBM Generative AI Certificate · IBM / Coursera
• Python for Data Science · Python Programming Certificate
• Microsoft Excel Certification · Skill Course
• JPMorgan Chase & Co. Data Analytics Virtual Experience Program · Forage

🏆 Achievements & awards

• Completed Google Data Analytics Professional Certificate

  Completed an industry-recognized 6-course program.

• Completed IBM Generative AI Certificate

  Gained hands-on exposure to generative AI concepts and tools.

• Built and deployed independent data analysis projects

  Successfully built and deployed projects including a healthcare analytics dashboard.

• Google Data Analytics Professional Certificate

  Completed an industry-recognized 6-course program.

• IBM Generative AI Certificate and JPMorgan Chase & Co. Data Analytics Virtual Experience Program

  Completed certification and virtual experience program.

• Microsoft Excel Certification

  Earned certification demonstrating proficiency in advanced spreadsheet and data-analysis tools.

🎯 Hobbies & interests

• script Writing
• Volleyball