Mohi Agarwal

AI-driven Data Analyst and Assistant Professor with strong expertise in Excel-based analytics, AI automation, and education-sector data operations. Experienced in managing and analyzing large-scale student enrollment, academic performance, and placement datasets for 500+ students. Skilled in leveraging AI tools, prompt engineering, and data visualization to automate reporting, uncover trends, and support data-informed decision-making.

Proven track record of reducing manual reporting time by 40% and improving student–job matching efficiency by 25% through AI-enabled workflows and interactive dashboards.

Assistant Professor & Placement Coordinator (AI Data Analytics Focus) - Rajshree Institute of Management & Technology - Bareilly, India

(2024-01)

• Managed, cleaned, and maintained comprehensive datasets covering student enrollment, academic results, and placement information for 500+ students.
• Developed automated Excel and Google Sheets reporting templates to track corporate recruitment drives, student eligibility, and shortlisting status.
• Analyzed historical placement trends to identify top hiring industries, frequently requested skills, and seasonal demand patterns to optimize student training programs.
• Designed and implemented AI-assisted workflows using ChatGPT and Be10x AI to automate report generation, official documentation, and complex data summaries.
• Reduced manual data processing and report generation time by approximately 40% through automated spreadsheets and integrated AI tools.
• Improved student-to-job matching efficiency by 25% by building structured eligibility matrices and data-driven shortlisting processes.

Assistant Professor & Placement Coordinator - Shri Siddhi Vinayak Group of Institute - Bareilly, India

(2022-01 - 2024-12)

• Coordinated placement-related data pipelines, tracking student profiles, recruiter requirements, and multi-stage selection outcomes to ensure friction-free campus drives.
• Prepared weekly MIS reports, student performance summaries, and historical placement statistics for high-level institutional stakeholders.
• Supported the structural design of student development programs by analyzing training mock-test performance patterns and feedback data.

Assistant Professor — Environmental Science (D.Pharm) - Rakshpal Bahadur College of Pharmacy - Bareilly, India

(2021-01 - 2022-12)

• Managed systematic academic records, continuous internal assessments, and mandatory attendance metrics for multiple student cohorts.
• Utilized advanced Excel formulas to analyze student performance metrics and identify at-risk students for targeted remedial support.

Lecturer - Suraj Bhan School - Bareilly, India

(2017-01 - 2021-12)

• Instructed science curricula while maintaining error-free student evaluation profiles, grade archives, and cumulative exam data tracking sheets.

Teaching Assistant - Hindustan Institute of Paramedical Science - Bareilly, India

(2016-01 - 2017-12)

• Compiled student academic evaluation datasets and prepared performance summary matrices for faculty review.

M.Sc - Forensic Science - Allahabad Agricultural Institute Deemed University

Bachelor of Science - B.Sc - M.J.P Rohilkhand University (2004-01 - 2007-12)

PGDCA - Computer Apps - Springdale College of Management Studies (2007-01 - 2008-12)