👨🏻‍💻

Ascendancy of Raj

The Presentation Keynotes (5 Minutes)

Speaker 1: Abid Shaikh

(Scene: Slide 1 - Introduction is on screen. The speaker is confident, poised, and makes eye
contact with ma’am or be present online.)
[Time: 0:00 - 1:00]
“Hello, judges. We are the team Oraclonauts. My name is Abid,I am the Team Lead and the Lead
Solutions Architect,
I was responsible for the high-level system design & I developed core pages across Student,
Faculty, Recruiter portals. I have engineered the APEX Workflows for skill validation that keep
our system synchronized.”

Abid:
Team Lead & Lead Solutions Architect
My Contribution: "As Team Lead, I guided our project strategy. As the Lead Solutions
Architect, I was responsible for the high-level design, and I developed the core pages across
the Student, Faculty, and Recruiter portals. I also engineered the critical APEX Workflows for
skill validation and the APEX Automations that keep our system's data synchronized."

Ascendancy of Raj 1
 Anas:
Lead UI/UX & AI Integration Specialist
My Contribution: "My focus was on creating an intelligent and empathetic user experience. I
designed the entire user interface, including the dynamic dashboard and the Skill Passport. To
power these features, I developed the REST API integrations that analyze the live job market
and fed that data into our custom AI engine."

Umar:
Lead APEX & Data Visualization Developer
My Contribution: "My role was to bring our data to life & connect the backend to the user. I
translated data into dynamic & interactive experience by building reports, dashboards using
cards, faceted search, charts & various types of regions to present data effectively while
empowering our application for easy use."

Fawaz:
Lead Backend & Database Developer
My Contribution: "I built the rock-solid foundation of Project Ascend. I designed and
implemented the entire database schema, engineered all the core PL/SQL logic, including the
candidate matching algorithm, and was responsible for ensuring the performance, security,
and data integrity of the entire backend system."

[Time: 1:00 - 2:00]

(Scene: The slide seamlessly transitions to Slide 2 - Abstract.)

"Our project, Ascend-APEX, was born from a simple question: How can we enhance and
optimize the incredible value that higher education provides?"
"The challenge is that traditional resumes can't capture a student's full range of practical skills,
creating a disconnect where talented students are overlooked. Our solution, Ascend-APEX,
directly bridges this gap. We transform a static transcript into a dynamic, faculty-validated
Skill Passport, using an AI engine to provide personalized readiness reports and well-being
insights."
"We chose this topic because the future workforce demands a holistic approach that combines
strong academics with verified skills, direct market alignment, and the emotional

Ascendancy of Raj 2
 resilience to succeed. Ascend-APEX is the platform built to empower every student and
institution to meet this new standard."

[Time: 2:00 - 3:15]

(Scene: The slide transitions to Slide 3 - Key Components. The speaker uses their hands to
gesture towards the different sections on the slide as they speak.)

"To build this, we utilized the full power of the Oracle APEX platform. As you can see from
the numbers, this is a comprehensive application."

"Our structure is robust, with _____ pages, _____ declarative regions, and over _____ items.
This is all powered by a sophisticated backend of _____ distinct processes."

"To make the data meaningful, we built _____ Interactive Reports and _____ Classic Reports,
giving recruiters and faculty unprecedented insight. This entire experience is built on a rich
foundation of APEX navigation, templates, and plugins, demonstrating our deep use of the
platform's capabilities."

[Time: 3:15 - 4:45]

(Scene: The slide transitions to Slide 4 - Our Growth Journey.)

"This platform is the result of a dedicated growth journey. Our team built its expertise on the
official 21-hour Oracle APEX Professional Learning Path race-to certification and countless
references to official Oracle documentation."

"We executed our vision using an agile, sprint-based methodology, guided by invaluable
industry mentorship that kept our solution grounded and relevant."

"Through this process, we had two major takeaways: First, the incredible speed and security
of APEX for building enterprise-grade solutions. And second, the importance of emphatic
design—engineering our platform not just for skills, but for the student's well-being."

"This journey prepared us to build the platform we're about to show you."

[Time: 4:45 - 5:00]

(The speaker takes a confident pause, signaling a transition.)

Ascendancy of Raj 3
 "enough with the presentation. Now let us witness the power of our platform “Ascend” in
action."

"Let us introduce you to a student named Raj, and show you how Ascend transforms his
academic journey into a confident career."

Ascendancy of Raj 4
 The Movie: "Ascendancy of Raj" (15 Minutes)

Act I: The Start (4.5 Minutes)

Narrator 1: Abid Shaikh

(Scene 1: 0:00 - 1:30 | Onboarding & The Human Element)

(ACTION: Pilot is on the main landing page . Clicks "Register". Fills out the registration
for "Raj Paravte" and lands on the Student Dashboard
We see the empty dashboard and initial 5% Readiness Score.)
Narrator 1:

"Good morning. Our story begins with a new student, Raj Paravte. He’s talented, but his
future feels uncertain. His friend “Shyam” recommends him to use Ascend. He registers
himself on Ascend and This is his Ascend Dashboard, the command center for his career. As
you can see, his journey is just beginning. His Career Readiness Score, calculated by our
platform, is at a baseline 5 percent."

"Our platform emphasizes more on the emotional/mental side of the student. Notice the mood
icons at the top. This is the gateway to our well-being module, Sentinel."

(ACTION: Pilot clicks on several of the mood icons, showing the confirmation pop-up each
time .)
Narrator 1:

"Every day, Raj can log his mood. These entries log in our database. Now, let's see how
sentinel uses this data to provide emphatic support."

(Scene 2: 1:30 - 3:00 | Sentinel & The AI Assistant)

(ACTION: Pilot navigates down the left menu to "Wellbeing & Settings" -> "Sentinel".
The Sentinel Mental Health Dashboard appears, showing the updated "Total Mood
Entries" and the charts populated with the data just entered.)
Narrator 1:

Ascendancy of Raj 5
 "This is the Sentinel Dashboard. It provides Raj with a personalized, visual analysis of his
emotional trends over time, helping him recognize patterns. But we take it a step further. Meet
our Sentinel AI-powered wellness companion."

(ACTION: Pilot clicks on the chatbot icon in the bottom right of the Sentinel page. The
"Sentinel AI Assistant" chat window opens)

Narrator 1:

"This is our Sentinel AI Assistant. We've configured it here as a wellness companion. It can
provide immediate support, suggest resources, or just be a place for “Raj” to voice his
concerns. This is a critical part of our commitment to student resilience."

(Scene 3: 3:00 - 4:30 | Taking Action: The Skill Passport & Validation)
(ACTION: Pilot navigates back to the main Student Dashboard. He clicks on "Verification
& Progress" -> "Skills & Project" . He quickly fills out the "Add Project" form for
"Campus Recruitment Portal" and clicks "Send for approval.")
Narrator 1:

"Raj is now motivated and ready to build his profile. He navigates to our Verification Hub.
He’s just completed a major project, so he enters the details here. When he clicks 'Send for
approval', the system initiates an APEX workflow, creating a formal, auditable request in his
domain-matched faculty’s queue."

(ACTION: Pilot clicks the "Add a Skill" tab, enters "Devops," and clicks "Take Test". He
completes the test successfully and clicks "Send for approval".)

Narrator 1:

"To add a skill, he first has to prove its relevant knowledge. Our integrated Skill
Check provides an objective baseline. After passing, this is also sent for final validation. Raj
has now submitted his work and proven his knowledge.

To see the crucial next step in this trust-building process, I’ll hand it over to our faculty"

Ascendancy of Raj 6
 Act II: The Mentor's Validation (3.5 Minutes)
Narrator 2: Fawaz Mulla

(Scene 4: 4:30 - 6:30 | The Faculty Workflow)

(ACTION: Pilot logs out and logs in as faculty member "Rohaan Khan")
Narrator 2:

"We are now logged in as Professor Khan. His dashboard is his central hub, designed for
efficiency. He can view reports and total number of contributions of his past validations."

(ACTION: Pilot navigates to the "Tasks" page from the side menu . We see the task for
Raj's project.)
Narrator 2:

"This is the APEX Verification Task inbox, our enterprise-grade workflow solution.

the task will be available to any faculty with whom the domain will match and if they’re
willing to evaluate they can claim the project/task and after claiming they can then accept or
reject the project.

It ensures every validation is tracked and auditable. Professor Khan sees the task for Raj's
project."

(ACTION: Pilot clicks the task, reviews the details in the drawer, and clicks "Approve")
Narrator 2:

"He reviews the details and approves the submission. A backend PL/SQL process immediately
updates the project's status to 'Validated' and links his faculty ID as the validator, creating an
immutable record of this endorsement."

(Scene 5: 6:30 - 8:00 | Efficient Skill Validation & Profile Management)

(ACTION: Pilot navigates to "Verifications" -> "Verify Skills" We see the card view of
pending skills.)

Ascendancy of Raj 7
 Narrator 2:

"Similarly, he’ll do the same for the skill validation."

(ACTION: Pilot clicks on Raj Paravte's card. The modal dialog appears . The Pilot changes
the status to "Validated" and clicks "Update Skill.")

Narrator 2:

"He finds Raj's 'Devops' submission, sees the successful test result, and validates it. This
action is the currency of our ecosystem. It transforms a student's claim into a verified,
bankable asset.

Professor Khan can also manage his entire professional identity here, from his work profile to
his achievements, ensuring his own credibility on the platform.

With the validation complete, Raj's profile is now ready for the job market. To see the result,
I'll pass you to our recruiter"

Ascendancy of Raj 8
 Act III: The Recruiter's Discovery (4 Minutes)
Narrator 3: Anas Nathani

(Scene 6: 8:00 - 9:30 | The Search for Talent)

(ACTION: Pilot logs out, logs in as recruiter "Mark Berk". The Recruiter Dashboard is
shown.)

Narrator 3:

"We're now Mark, a recruiter looking for proven talent. His dashboard immediately shows
him the top candidates for his latest job, ranked by our proprietary PL/SQL matching
algorithm."

Narrator 3:

(ACTION: Pilot navigates to "Job Management" -> "Applicant Responses". The page
shows applicant cards.)

"Mark wants to review all applicants for a specific role. This is the Applicant Response
Center. We've used a Faceted Search region to control a Cards region, a powerful combination
in APEX that allows for intuitive, dynamic filtering. He can filter by job title and instantly see
the relevant candidate pool."

(Scene 7: 9:30 - 10:45 | The Payoff: From Validation to Hire)

(ACTION: Pilot clicks on a candidate, "Abid Ashfaque Shaikh". The comprehensive modal
appears . Pilot clicks the "View Skill Passport" button . The dark UI of Abid's Skill
Passport is displayed)
Narrator 3:

"He selects a candidate and can immediately review their entire profile, from their application
notes to their education. But the most powerful tool is this: the Skill Passport. This
visualization, built with custom HTML and CSS in an APEX region, gives him an instant,
data-driven summary of the candidate's readiness. He sees the validated skills and projects,
giving him immediate confidence."

Ascendancy of Raj 9
 (ACTION: Pilot closes the passport. Back in the Applicant Response modal, Pilot uses the
action buttons at the bottom to "Shortlist" and "Accept" the candidate .)
Narrator 3:

"Impressed, Mark shortlists and accepts the candidate. These actions, powered by Dynamic
Actions and PL/SQL, update the application status across the entire platform in real-time."

(Scene 8: 10:45 - 12:00 | Closing the Loop)

(ACTION: Let's find our student Raj. Pilot navigates to "My Connections" -> "Browse
Students". He finds "Raj Paravte," clicks to open the info drawer, and then clicks the
"Message" button . The chat interface opens.)

Narrator 3:

"The platform closes the loop. Mark can now directly message Raj through our integrated
chat, built with a custom template and auto-refreshing regions. He's gone from a job posting
to a verified, high-potential candidate, and initiated contact—all within a few minutes. To see
how we manage this entire ecosystem, I'll hand it over to our admin."

Ascendancy of Raj 10
 Epilogue: The Architect's View (3 Minutes)
Narrator 4: Umar Ansari
(Scene 9: 12:00 - 13:45 | The Admin Panel: Control & Integrity)

(ACTION: Pilot logs out of the recruiter account and logs in as an Admin. The Admin
Dashboard appears, displaying the key metric cards: 9 Faculty, 15 Recruiters, 19 Students,
and etc etc the grievance chart.)
Narrator 4:

"now, who will ensure smooth operation of this entire ecosystem?

The answer is our Admin."

"So this is our admin control panel. From this central dashboard, an administrator has a
overall view of the entire platform. We're not just tracking users; we're monitoring the health
of the community. We've built this with declarative APEX cards to surface the most critical
metrics instantly."

(ACTION: Pilot navigates down the left menu to "User Management". The Interactive
Report showing all users appears.)

Narrator 4:

"A core admin function is User Management. This powerful APEX Interactive Report gives
the admin complete control over every account on the platform, allowing them to search,
filter, and manage users to maintain a secure environment."

(ACTION: Pilot navigates to the "Grievances" page (1:02). The rich Faceted Search report
for grievances is shown. The Pilot demonstrates the filtering capability by clicking on
"APPLICATION" and "PERSONAL" in the facets.)
Narrator 4:

Ascendancy of Raj 11
 "Crucially, we provide a structured and transparent process for issue resolution through
our Grievance Desk. We've built this using native Faceted Search component, which is a
perfect tool for this task. It allows the admin to instantly drill down and filter grievances by
type, user, or name, ensuring that no issue is ever lost or ignored."

(ACTION: Pilot clicks on a grievance card to open the details in a modal dialog. They type
a response and click "Apply Changes".)
Narrator 4:

"The admin can address concerns directly, and the entire interaction is logged. This isn't just a
feature; it's a commitment to the safety and well-being of our users."

(ACTION: Pilot navigates to "Student Data" (1:25). A Master-Detail page appears. The
Pilot clicks on a student, "Aarav," and the details, including skills and projects, are shown
.)
Narrator 4:

"Finally, the admin has ultimate oversight.

from a student's skills and projects

to a faculty member's domains

or a recruiter's job postings.

They can view and manage the complete record of any user on the platform Using a
native APEX Master-Detail page.

This ensures data quality and provides a final layer of support for the entire ecosystem."

(Scene 10: 13:45 - 15:00 | The Finale)

(ACTION: Pilot logs out and returns to the beautiful main landing page of the application.
The Pilot stops sharing.)
Narrator 4:

"What you've just seen is the complete journey of one student, transformed. Raj started with
anxiety and ended with an opportunity."

Ascendancy of Raj 12
 "This was made possible by an ecosystem built on Oracle APEX—an ecosystem that
creates Trust through faculty validation, Clarity through AI-driven insights, Support through
our Sentinel well-being module, and Connection through intelligent matching. All of it is
managed and secured through the central Admin hub you just saw."

"Ascend-APEX is not just a student portfolio system. It is a new standard for how universities
can prove their value, how students can build their confidence, and how employers can
discover the proven talent that will shape our future."

"Thank you, we are now done with presentation and demo of our project, feel free to ask
questions"

The 50 Q&A Questions & Answers

(The whole team should be ready to answer, but let the relevant "Lead" take the first pass.)

Technical & Architecture

1. Why did you choose Oracle APEX?

Answer: "We chose APEX for three key reasons: Speed, Security, and Scalability. Its
low-code, data-centric nature allowed our small team to build this complex, three-portal
application in a competition timeframe. APEX's built-in database security and user
management gave us enterprise-grade protection out-of-the-box. And because it runs
directly in the Oracle Database, we knew it was a platform that could scale to thousands
of users without performance degradation."

2. What was your biggest technical challenge?

Answer: "Our biggest challenge was designing the PL/SQL logic for the two scoring
algorithms—the student's Readiness Score and the Recruiter's Candidate Match Score.
Making them fast, accurate, and weighted correctly required significant iteration and
testing to ensure they felt intelligent and fair. We're very proud of the final engine."

3. How does your AI/API integration work?

Ascendancy of Raj 13
 Answer: "Our AI component is a two-part system. First, we use APEX's native REST
Data Source features to periodically call external job board APIs, pulling in real-world
job descriptions. Second, a backend PL/SQL process parses this text to identify and
weigh the most in-demand skills, which then powers the 'AI Recommended Actions' on
the student dashboard and provides data for the readiness score."

4. Can you explain your database schema design?

Answer: "Our schema is designed around a central USERS table, with three distinct
profile tables: AB_STUDENTS, AB_FACULTY, and AB_RECRUITER. The core of
the 'Skill Passport' revolves around the U_STUDENTS_SKILLS, _PROJECTS,
and _CERTIFICATIONS tables, which all include a status and validated_by column.
This creates a robust, normalized structure that ensures data integrity and is the
foundation of our validation workflow."

5. What APEX features are you most proud of?

Answer: "We're most proud of our heavy use of APEX Approvals and Human
Tasks for the validation workflows, which is a core feature. We're also proud of the
custom UI we built for the Skill Passport modal and the dynamic dashboard, which
combines Dynamic Actions and custom CSS to create an experience beyond the
standard templates."

6. How did you implement the chat feature?

Answer: "The chat feature is built using a custom schema

with CHAT_MESSAGES and CHAT_THREADS tables. The front-end uses a Classic
Report with a custom template, and it refreshes on a timer using a Dynamic Action to
poll for new messages, providing a near real-time experience."

7. What plugins did you use?

Answer: "We focused on maximizing native APEX functionality but used [mention 1-2
key plugins, e.g., a specific chart plugin or UI plugin] to enhance the user experience in
targeted areas, saving us development time while delivering a more polished result."

8. Is your application secure? How did you handle security?

Answer: "Security was a top priority. We rely on APEX's built-in Authentication

Schemes and defined three distinct Authorization Schemes—Student, Faculty, and
Recruiter. Every page and almost every region has an authorization scheme applied,
ensuring that no user can ever access data they aren't supposed to."

Ascendancy of Raj 14
 9. How scalable is your application?

Answer: "Extremely scalable. By leveraging the Oracle Database as our engine and
writing efficient PL/SQL, the application's performance is handled by the world's
leading database. The architecture would support a university of any size with minimal
infrastructure changes."

10. What is the 20% "supporting technology" in your project?

Answer: "Our 20% is the AI and API integration layer. This includes the external
REST calls to job boards and the custom PL/SQL engine that acts as our 'AI brain' to
parse that data, identify skill trends, and power our personalized recommendation and
scoring features."

Vision & Business

1. Who is your primary customer? The student or the university?

2. What is your business model? How would you make money?

3. How is this different from LinkedIn?

4. What is the biggest benefit for a university to adopt this?

5. What is the next feature you would build?

6. How do you ensure the job market data is accurate?

7. What's your plan for user adoption? How do you get students and faculty to use it?

8. What are the biggest risks to this project's success?

9. Have you considered data privacy regulations like GDPR or CCPA?

10. How does the "Ascend Score" (the trophy) actually benefit the student?

11. How do you prevent faculty from just validating everything for their students?

12. What happens when a student graduates? Do they lose access?

13. Could this be expanded to other fields outside of tech?

14. How much time would this save a corporate recruiter?

15. What are your key metrics for success? (KPIs)

Team & Process

Ascendancy of Raj 15
 1. How did you divide the work among the team?

2. What was your project management process? (Agile, Waterfall, etc.)

3. What was the biggest disagreement you had as a team, and how did you resolve it?

4. What was the most surprising thing you learned during this hackathon?

5. How did you collaborate while building? (Git, shared instance, etc.)

6. What was your mentor's most valuable piece of advice?

7. If you could start over, what would you do differently?

8. Which team member wrote the matching algorithm? Can they explain it?

9. Who was responsible for the UI design? What inspired it?

10. What part of the project are you personally most proud of?

Tough Questions
1. Your readiness score is arbitrary. How can you prove it's accurate?

2. The AI seems to be just a set of PL/SQL rules. Where is the machine learning?

3. This relies entirely on faculty participation. What if they don't want to do the extra
work?

4. Isn't a student's GitHub profile a better "Skill Passport" than this?

5. The job market changes daily. How do you ensure your recommendations aren't
instantly outdated?

6. You have a lot of features. Which ones are fully complete versus just mockups? (Use
our spreadsheet to answer this honestly).

7. The "Well-being" feature seems disconnected. How does it truly relate to career
readiness?

8. What stops a student from creating fake projects or listing skills they don't have?

9. How would you handle a dispute where a student disagrees with a faculty's rejection of
their skill?

10. Your student dashboard has a lot of information. Have you done any user testing to see
if it's overwhelming?

Ascendancy of Raj 16
 11. The chat feature could be a liability for moderation and inappropriate content. How
would you manage that?

12. The recruiter match score is a black box. Can they see why a student got a certain
score?

13. How do you handle different levels of proficiency in a skill (e.g., beginner vs. expert in
Python)?

14. This seems very focused on the Indian job market (based on rules). How would this
work globally?

15. What is the one, single most innovative part of your project that no one else has?

Our Killer Answer: "The single most innovative part is the closed-loop trust
ecosystem. Other platforms are just collections of self-proclaimed skills. We are the
only platform where a student's action (completing a project) directly triggers a
university-verified event (faculty validation) which then immediately translates into a
quantifiable business outcome (a higher, more accurate match score for a recruiter). It’s
this seamless, trusted, real-time flow of data between the student, the institution, and the
employer that truly sets Ascend-APEX apart."

Ascendancy of Raj 17