Amlan Prusty
Data Analyst
About
Data Analyst with hands-on experience using Python (Pandas, NumPy) and SQL to clean, structure, and analyze large, messy, and unstructured datasets, and to uncover patterns that support business decisions. Experienced in customer segmentation, cohort-style ranking, and KPI/conversion analysis across retail, healthcare, and customer behaviour datasets, with dashboards built in Power BI and Advanced Excel.
Skills & Expertise (33)
Work Experience
Lecturer in Computer Science
Centurion University
Mar 2025 - Present
Taught Python and SQL, translating complex programming and data concepts into practical, hands-on learning experiences. Analyzed student performance data for 300+ learners using ERP software/SQL to support curriculum planning and workload decisions — applied structured problem-solving and reporting on real datasets. As MIS Executive, managed and maintained student data, marksheets, and result records, ensuring accuracy and consistency across academic records. Performed attendance analysis and built Excel-based reports and dashboards to track student performance and attendance trends, enabling data-driven academic decisions.
Faculty in Computer Science
Capital Engineering College
Aug 2024 - Feb 2025
Taught SQL and Python to 60+ final-year students, supporting project completion and placement readiness. Streamlined NBA accreditation documentation using Excel-based data cleaning, cutting manual preparation time significantly.
Guest Lecturer
Computer Application Centre
Jan 2020 - Jul 2024
Trained 100+ students in Excel, Word, and PowerPoint for real-world data organization, analysis, and documentation tasks.
Education
Master of Computer Applications (MCA) - Gandhi Institute for Technology, Bhubaneswar
2018 - 2020 · Afghanistan
Certifications
Data Analytics using Generative AI
Coding Ninjas · 2026
SQL (Intermediate)
HackerRank · 2025
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (33)
Click a skill to find developers with the same skill
