PRERNA SAXENA's IT expertise

 

Professional Profile and Achievement Briefing: Dr. Prerna Saxena

Executive Summary

This briefing document synthesizes the professional credentials, academic background, and major recognitions of Dr. Prerna Saxena. A multifaceted professional, Dr. Saxena is recognized as an IT Woman Scientist, AI research author, and global educational leader. Her career is characterized by high-level certifications from industry leaders such as Google and Amazon, as well as significant contributions to technology in education, women’s empowerment, and life coaching. Notable achievements include the Rabindranath Tagore Lifetime Achievement Award and a near-perfect aggregate score in AI Research and Education Technology assessments.

--------------------------------------------------------------------------------

Professional Designations and Core Expertise

Dr. Prerna Saxena maintains a diverse professional portfolio spanning technology, academia, and social empowerment. She is formally recognized under several key titles:

• IT Woman Scientist: Specifically recognized for contributions to AI research and education technology.
• IT Author and Publisher: An established author central to both Amazon and Google, sharing content on complex technical subjects since 2011.
• Google for Education Certified Trainer: Qualified to empower educators through high-quality training on Google for Education tools and classroom technology.
• Academic Research Writer: Focused on technical and global innovation content.
• Startup India Mentor: Engaged in supporting the entrepreneurial ecosystem.

--------------------------------------------------------------------------------

Academic and Technical Qualifications

The source context outlines a rigorous educational trajectory and a series of specialized technical certifications.

Formal Education

• B.Sc. in Computer Science: Obtained through Appliccional Vocational Training at Hindu Girls College, Jagadhri, Kurukshetra University.
• Higher Diploma: Earned from NIIT in "Newnologhi" (New Technologies).
• Diploma in Java Technologies: A 246-hour course completed at NIIT, New Delhi, on July 2, 2012.

Specialized Certifications

• AI Research & Education Technology: Achieved a "Formal Google Recognition" with a 98% aggregate score on a final AI-based assessment (October 26, 2023).
• Google for Education Certified Trainer: Granted on December 9, 2025, for demonstrating skills in classroom technology integration.
• Certified Therapeutic Art Life Coach: Advanced life coaching training endorsed by the Transformation Academy (December 16, 2025).

--------------------------------------------------------------------------------

Major Awards and International Recognition

Dr. Saxena has received several prestigious accolades for her performance and societal contributions:

Award Title	Issuing Body	Key Recognition
Rabindranath Tagore Lifetime Achievement Award	Welred Foundation	Outstanding performance and achievements in Women Empowerment.
International Icon Award Gold Medalist	Combined Accomplishments	Exceptional performance in global leadership.
Global Educational Leader	Combined Accomplishments	Recognition of leadership in the educational sector.
Certificate of Recognition	MY Bharat / Ministry of Youth Affairs and Sports	Contributions toward the "Viksit Bharat" initiative.

--------------------------------------------------------------------------------

Institutional Affiliations and Endorsements

Google and Amazon Collaborations

Official documentation from the Google Education and Research Development Team, signed by Dr. Anya Sharma (Dean of Relations), provides a strong endorsement of Dr. Saxena’s "dedicational prowess" and ability to "communicate complex ideas."

• Google: Active as a Certified Trainer and Innovator.
• Amazon: Recognized as an author central with publications that assist individuals with complex technical subjects.

Non-Profit and Governmental Engagement

• Welred Foundation: A Section 8 Non-Profit Organisation registered under the Ministry of Corporate Affairs, Govt. of India. The foundation cites Dr. Saxena as an "inspiration" for her commitment to excellence and women's empowerment.
• Ministry of Youth Affairs and Sports: Dr. Saxena is registered with the MY Bharat platform, supporting national development goals.

--------------------------------------------------------------------------------

Key Testimonials and Quotes

The sources include several commendations regarding Dr. Saxena’s professional impact:

• On Technical Expertise: "Prena’s expertise extends to successful career as IT Amazon with Authon, with publications meeting helpline to countlats indioduals on comples counplex technical subjects." (Google Official Letter)
• On Educational Impact: Recognized for "demonstrating the knowledge and skills required to empower educators to use technology in the classroom." (Google for Education Certificate)
• On Leadership and Character: "Your hard work, perseverance, and commitment to excellence have genuinely paid off. You have set a high standard of achievement for everyone." (Welred Foundation)
• On Social Contribution: The Rabindranath Tagore Award "confirms your performance and highlights your achievements in Women Empowerment." (Welred Foundation)
  
  
  

Google Search and Blogger Study Guide by DR.PRERNA SAXENA,THE EDUCATIONIST AND IT WOMAN SCIENTIST AND ARTIST FROM INDIA.

 

Google Search and Blogger Study Guide

This study guide provides a comprehensive review of Google Search techniques, advanced search operators, and the foundational steps for creating and managing a blog via Blogger.com. It is designed to assist learners in mastering information retrieval and digital content creation using Google’s suite of tools.

--------------------------------------------------------------------------------

Part 1: Short-Answer Quiz

Instructions: Answer the following ten questions based on the provided source materials. Each answer should be approximately 2–3 sentences.

1. When starting a search on Google, what is the most effective way to phrase an initial query?
2. How can a user ensure that Google searches for an exact phrase rather than individual keywords?
3. What is the function of the minus sign (-) in a search query, and when is it useful?
4. Explain how the "OR" operator changes the results of a search for two different terms.
5. What advanced operator allows a user to restrict search results to a single specific website?
6. How can a researcher find specific file formats, such as PDFs or PowerPoints, using Google?
7. Describe the method for searching for results within a specific range of numbers, such as dates or prices.
8. What is a reverse image search, and how can a user perform one?
9. Briefly explain the underlying process Google uses to find and index web pages.
10. What are the primary steps required to establish a new blog on Blogger.com?

--------------------------------------------------------------------------------

Part 2: Answer Key

1. Effective Query Phrasing: Users should start with simple, important keywords rather than long sentences, as Google is designed to understand context. For example, instead of asking "What is the fastest land animal?", one should simply type "fastest land animal."
2. Exact Phrase Searching: To find results containing a specific phrase, the query must be enclosed in double quotation marks. This technique is particularly helpful for locating specific names, song lyrics, or famous quotes like "a life is like a box of chocolates."
3. The Minus Sign (-): Placing a hyphen or minus sign immediately before a word excludes that term from the search results. This is useful for clarifying ambiguous terms, such as searching "mustang -car" to find information about horses rather than the vehicle.
4. The OR Operator: Using the OR command (in all caps) between two terms instructs Google to provide results that include either one of the terms or both. For instance, searching "vacation London OR Paris" will return content relevant to either destination.
5. The site: Operator: The site: operator limits a search to a single specified website address. An example of this is "site:nasa.gov space exploration," which ensures all results come specifically from the NASA website.
6. The filetype: Operator: To find specific file formats, a user should use the filetype: operator followed by the desired extension. This allows for targeted searches like "climate change filetype:pdf" to locate professional documents or reports.
7. Number Range Search: A user can search within a range of numbers by placing two periods (..) between the two numerical values. This is effective for narrowing down results to specific years or price points, such as "best movies 2022..2025."
8. Reverse Image Search: This feature allows users to search using an image rather than text by clicking the camera icon in Google Images. Users can then upload a file or paste an image URL to find visually similar images and related information.
9. Crawling and Indexing: Google Search is fully automated and uses software known as "web crawlers" to explore the internet regularly. These crawlers find new or updated pages and add them to Google's index to be ranked based on hundreds of factors.
10. Creating a Blogger Blog: To start, visit Blogger.com and sign in with a Google account before clicking "Create Your Blog." The user must then provide a blog title and a unique URL (address) ending in .blogspot.com before saving to finalize the creation.

--------------------------------------------------------------------------------

Part 3: Essay Questions

Instructions: Use the provided source context to develop comprehensive responses to the following prompts.

1. Advanced Research Strategies: Compare the utility of basic keyword searching with the use of advanced operators like related:, site:, and filetype:. How do these tools specifically enhance the efficiency of academic or professional research?
2. The Mechanics of Search: Discuss the relationship between web crawlers, indexing, and ranking factors. How do these three elements work together to deliver relevant results to a user’s search query?
3. Beyond Text-Based Queries: Analyze the various "non-traditional" ways to interact with Google Search, including voice search, reverse image search, and direct tools like calculations and conversions. How do these features accommodate different user needs?
4. Blogger Dashboard and Customization: Once a blog is created on Blogger.com, what tools are available to the creator to manage and personalize their site? Consider the roles of "New Post," "Settings," "Themes," and monetization options like AdSense.
5. Search Refinement and Troubleshooting: Evaluate the steps a user should take if their initial search query does not yield the desired results. Include a discussion on refining keywords, using the Advanced Search page, and utilizing different result tabs (News, Videos, Shopping).

--------------------------------------------------------------------------------

Part 4: Glossary of Key Terms

Term	Definition
AdSense	A Google tool used by blog creators to monetize their content by displaying advertisements.
Advanced Search Page	A dedicated form (google.com/advanced_search) that allows users to apply various filters without manually typing operators.
Blogger.com	Google's free weblog publishing tool used for sharing text, photos, and videos via a personalized blog.
Define: Operator	A command used in the search bar to find the instant definition of a specific word (e.g., define:serendipity).
Filetype: Operator	An operator used to restrict search results to specific file formats like PDF, PPT, or DOC.
Indexing	The process by which Google organizes the web pages found by its crawlers into a massive database to be retrieved during searches.
Keywords	Simple, important terms used in a search query that capture the core context of what a user is looking for.
OR Operator	A command used between two search terms to find results containing either or both of those terms.
Quotation Marks (" ")	Used to surround a search query to force Google to find that exact phrase in that specific order.
Related: Operator	An operator used followed by a website address to find other websites with similar content.
Reverse Image Search	A search method where a user uploads an image or image URL to find its source or similar visual content.
Search Console	A tool for website owners to measure search traffic, monitor performance, and fix issues related to how their site appears in results.
Site: Operator	A command that limits search results to a specific domain or website.
URL (Uniform Resource Locator)	The unique web address of a site; on Blogger, these typically end in .blogspot.com unless a custom domain is used.
Web Crawlers	Automated software that explores the web regularly to discover new pages for Google’s index.

Sankalp se SIDDHI BHARAT FOUNDATION ADVENTURES ISLAND of education at GOOGLE

DR PRERNA SAXENA BIOGRAPHY

v

DR PRERNA SAXENA BIOGRAPHY.YOUTUBE LINK.

https://youtu.be/uA0z63DM2XM?si=_bWclYIYT0UDWtcc

 

HRMS HUMAN RESOURCE MANAGEMENT BUILDING DATABASE EXPLAINED.

https://youtu.be/serN5CiEEeQ 

RDBMS : HRMS: AN EBOOK ON DATABASE EXPLAINED IN SUMMARY.

 

HRMS Data Dictionary and Database Operations Reference Manual

1. Conceptual Framework of Human Resource Management Systems (HRMS)

A Human Resource Management System (HRMS), also referred to as a Human Resource Information System (HRIS), serves as the foundational schema architecture for an organization’s most vital assets: its personnel. From a Systems Architect’s perspective, these systems have undergone a strategic evolution from siloed administrative tools to modern, integrated human capital management cloud solutions. This shift ensures that critical data is no longer locked in back-office silos but is positioned at the forefront of organizational decision-making.

The core of this system lies in the transformation of data—raw facts and figures—into information. In our architecture, "information" is defined as an organized form of repository data. For HR professionals, this organized state is what facilitates the effective management of a modern workforce, ensuring that disparate data points are synthesized into actionable intelligence regarding payroll, talent management, and departmental alignment.

To explain the Database Management System (DBMS) to non-technical stakeholders, we utilize the "drawer" analogy. A database functions like a series of drawers, each containing systematically organized files. In technical terms, the DBMS provides the infrastructure to store and retrieve user data with maximum efficiency and referential integrity, while applying appropriate security measures to sensitive employee records. Because this conceptual storage requires clearly defined containers to be realized in a live environment, we must first establish the specific variables that constitute the HRMS schema.

2. Core Employee Data Variables and Attribute Definitions

Standardized variable naming is a prerequisite for database interoperability and payroll accuracy. In an Oracle environment, these variables represent the specific attributes required to maintain a normalized dataset. Defining these containers correctly is the first step in ensuring that the HRMS acts as a reliable source of truth.

The following catalog identifies the essential Oracle variables required for the schema:

Variable Name	Source System	Description
first_name	Oracle Database	The employee’s legal given name.
last_name	Oracle Database	The employee’s legal surname; critical for identification and payroll.
email	Oracle Database	Primary electronic contact address for internal and external communications.
phone_no	Oracle Database	Registered contact number for the employee.
hire_date	Oracle Database	The official commencement date of the employment contract.
job_id	Oracle Database	Unique identifier linking the employee to a specific role.
commission_pct	Oracle Database	The percentage rate used for performance-based variable compensation.
manager_id	Oracle Database	Identification number of the employee's direct supervisor.
department_id	Oracle Database	Numeric code identifying the employee's specific business unit.

These variables are more than mere strings; they are the functional foundation for talent and financial management. For example, hire_date is the primary key for calculating seniority-based benefits  while commission_pct provides the logic for variable compensation structures. Furthermore, our talent management data extends to qualitative attributes. The repository can track specific employee talents, such as "dancing or singing," which might be showcased at corporate venues like "Pantaloons, Lucknow" or "Balaji Agora Mall, Ahmedabad." Tracking these variables allows the organization to manage the workforce holistically. This structured data, however, remains static without the active database operations required to manipulate it.

3. Database Operations and Transactional Integrity

To maintain a "source of truth," administrators must master Data Manipulation Language (DML) and Transaction Control Language (TCL). These operations ensure that employee records are updated with precision while maintaining the integrity of the global schema.

Functional Command Reference

• Data Modification (DML):
  • INSERT: Adds a new row of employee data to a table.
  • UPDATE: Modifies existing records, such as adjusting a salary or job title.
  • DELETE: Removes specific existing rows from a table.
  • TRUNCATE: A high-speed operation that removes all rows from a table, clearing the repository while preserving the table structure.
• Transaction Control (TCL):
  • COMMIT: Finalizes all pending data changes, making them permanent in the database.
  • SAVEPOINT: Establishes a marker within a transaction, allowing for partial rollbacks.
  • ROLLBACK: Discards all pending changes, reverting the records to their last committed state.
• Concurrency Control:
  • FOR UPDATE: A clause used within a SELECT statement to lock identified rows, preventing other users from making concurrent changes until the current transaction is finalized.

The implementation of COMMIT and ROLLBACK commands is essential for data reliability. In an HCM environment, where an error in salary or tenure can lead to significant liability, these commands act as a fail-safe. They allow a DBA to verify transactional accuracy before making changes permanent, ensuring that the HR record remains uncorrupted. These logical operations are put into practice through the specific syntax of the Oracle environment.

4. Technical Implementation and Oracle XE Environment

For the Senior DBA and developer, Oracle Database Express Edition (XE) provides an enterprise-grade engine in a manageable, redistributable package. It is the ideal environment for deploying HRMS solutions because it offers the same power relied upon by global corporations while remaining free to use.

Setup and Installation Guide To establish the environment, first download the latest Oracle XE software from the official Oracle technology portal. Once downloaded, execute the setup file 11g XE.exe from your local drive. In this context, "11g" refers to the database version, "exe" is the executable file format, and "XE" stands for Express Edition.

Schema Creation and Data Entry Syntax Once the instance is running, use the following syntax to initialize and manage the HRMS tables. Note that keywords are capitalized for clarity:

• Creating a Table: To establish a repository for tracking employee seniority, use a structured CREATE TABLE statement. Correct syntax for the hire dates table is: CREATE TABLE hire_dates (id NUMBER(8), hire_date DATE DEFAULT SYSDATE);
• Inserting Data: To populate a department table, use the INSERT INTO command: INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (70, 'Public Relations', 100, 1700);
• Updating Records: To adjust compensation records based on specific criteria, such as a last name: UPDATE employees SET Salary = 70000 WHERE last_name = 'Grant';

Following these technical protocols ensures that the underlying database structure remains stable and capable of supporting complex HR operations.

5. Conclusion: The Future of HRMS and Organizational Success

Innovative HRMS systems are the engines that drive modern organizational success. By utilizing advanced technology to manage and care for employees, organizations empower their workforce to provide a higher level of care and service to their customers.

The 21st-century economy is a landscape defined by emerging technologies. In this environment, successful organizations are those that leverage robust data dictionaries and precise database management to maintain a competitive edge. The role of the developer and the DBA is to build and maintain this technical framework, ensuring that raw human capital data is always transformed into the strategic information necessary for organizational growth.