CareerWise

The Challenge Imagine a smart AI assistant that helps employees make informed career moves by turning complex payroll and market data into actionable insights. Your task is to build an AI-powered system that answers tough career questions, identifies earning potential, and visualizes future growth—all through natural conversations.

Very Important Features

1. Microsoft Copilot Studio bot
2. Human Capital Management bot for Human resource
3. Connect to data sources from websites like Glassdoor,adp,reddit, for salary information, career doubts etc
4. Connected own excel and documents for accessing employee details and company details,
5. identify earning potential etc Using the data sources provided generate insights has a natural conversation
6. Gives Personalized Career Roadmaps
7. Change of incorrect data in database request form as provided and registered in excel, message prompted in teams too
8. Integrated with teams, azure application insights,
9. Deployed on our own website
10. Provide multilingual support for global workforces.
11. Export visualizations or action plans as PDF/PPT for mentorship discussions.
12. Connect employees with mentors based on goals.
13. Analytics tab in copilot bot too
14. Made flow using Power Automate
15. Adaptive card made for collecting employee data if they want to change anything in the data, connected with Microsoft teams
16. Multiple languages
17. Authenticated with Microsoft -

Knowledge:

1. ADP, Glassdoor, Reddit,
2. Employee data csv, Employee FAQ, HR datacsv.

Topic Triggers Implementation:

• Employee Analytics - trigger is employee details connects to employee data csv to answer

  • Employee Lookup & Verification - Can you confirm if Gina Cook is still employed here?
  • Payroll & Compensation - I am Sheila Holmes, Can you show me my latest bonus details?
  • Attendance & Leave Management - Can I check my overtime hours for this week?
  • Career Growth - I am Kevin Potter, How can I explore career growth opportunities in my department?

• Employee FAQ - Trigger is Employee Specific connects to EmployeeFAQ to answer

  • For New Users - Account Setup - “How do I create my ADP account?"
  • For Current Employees - "How do I update my tax withholdings?"
  • For Exiting Employees - "What happens to my 401(k) when I quit?"

• HR Analytics - Trigger is HR connects to HR_data.csv Employee Compensation Analysis - Can you compare the net pay of employees across different departments? Department and Role Insights - Which department has the highest average base salary? Employee-Specific Queries - Can you show a detailed compensation breakdown for Employee_427? General Insights and Trends - Is there a relationship between overtime hours and overtime pay across departments? Budget and Finance - Can you recommend strategies for managing overtime costs in departments with high overtime pay?

• Languages: JSON

• Frameworks: Microsoft Power Platform, Adaptive Cards

• Platforms: Microsoft Copilot Studio, Microsoft Teams

• Cloud Services: Azure Application Insights

• Databases: Excel, CSV Files

• APIs: Glassdoor API, ADP API, Reddit API

• Automation: Power Automate

• Authentication: Microsoft Azure AD