Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Shagufta Pathan

New York

Summary

Results-driven Data Analyst with 9 years of industry experience, including 4 years specializing in data analysis, strategic planning, and process optimization. Strong technical expertise in data visualization, reporting, and predictive analytics, with a passion for turning complex datasets into meaningful narratives. Seeking a data analyst role where I can apply my experience and analytical skills to support organizational success.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Managing Head of Academic Medical Department

AESL
03.2023 - 08.2023

Implemented targeted strategies based on data-driven analysis, leading to a 10% increase in student retention and a 7% decrease in attrition, successfully meeting retention and engagement targets set by the directors.

Led the academic medical department, fostering a collaborative environment for a team of 16+ faculty and staff, promoting teamwork and individual accountability, which improved overall departmental productivity.

Worked closely with cross-functional teams to ensure data integrity and accuracy, applying critical thinking to analyze complex problems and deliver actionable insights, resulting in a 15% improvement in decision-making speed.

Conducted comprehensive analyses of student satisfaction and engagement, leading to a 12% increase in overall satisfaction scores and informing program improvements that contributed to a 20% increase in program enrollment.

Head of Zoology Department

AESL
04.2019 - 02.2023

Analyzed and clustered exam questions, segregating them by year to create standardized content, which was adopted by the organization and led to a 85% increase in customer engagement and knowledge retention.

Analyzed student satisfaction and engagement using Excel and Power BI, identifying key insights that helped develop strategies to increase student conversion rates by 90% annually.

Trained faculty members, enhancing their teaching effectiveness and performance, contributing to a 21% improvement in student exam scores and overall academic performance

Monitored and analyzed previous year’s data, identifying key gaps and successfully launching ANTHE services twice annually, which contributed to a 30% increase in customer admissions year-over-year.

Zoology Lecturer

AESL
07.2018 - 03.2019

Collaborated with publishers to curate high-quality learning materials, ensuring students had access to the latest research and industry-relevant content.

Provided subject matter expertise for academic content development, contributing to curriculum design, textbook reviews, and scientific publications.

Guided and mentored students, leading to successful selections in national-level medical, dental, and research entrance exams through structured coaching and academic support.

Biology Lecturer

Agasti Education
06.2016 - 04.2018

Prepared students for national-level medical entrance exams and mentored students in biological research, guiding them through experimental design, data analysis, and scientific writing, while also organizing and overseeing science fairs to foster innovation and critical thinking.

Biology Lecturer

P.P.Savani Internation School
06.2015 - 04.2016

Honored as the "Enthusiastic Employee of the Year" for exceptional dedication, innovative teaching methods, and commitment to student success.

Education

Master of Science - Microbiology

Maharaja Sayajirao University
Vadodara
05-2015

Bachelor of Science - Medical Technology

Veer Narmad South Gujarat University
Surat
04-2013

Skills

    Data Analysis & Processing

  • SQL (MySQL, PostgreSQL, SQL Server)
  • Python (Pandas, NumPy)
  • R (dplyr, ggplot2)
  • Advance Excel (Pivot Tables, VLOOKUP)
  • Data Visualization & Reporting

  • Power BI
  • Tableau
  • Python (Matplotlib, Seaborn, Plotly)
  • Google Data Studio
  • Database Management & ETL

  • SQL (Joins, CTEs, Window Functions)
  • Statistical & Predictive Analytics

  • Regression Analysis

    Machine Learning (Basic Level)

  • Scikit-learn
  • - Business Intelligence & Strategy

  • KPI Analysis
  • Business Performance Metrics
  • Revenue & Cost Optimization
  • Customer Segmentation
  • - Communication & Collaboration

  • Data Storytelling
  • Cross-functional Teamwork
  • Stakeholder Communication
  • Presenting Insights to Executives
  • Agile & Scrum Methodologies

Certification

  • Mental Health First Aid for Youth Certification – Agile Project Management
  • (Google, Mar 2025)
  • Data Analytics
  • (Google, Aug 2024)
  • Data Analysis with R Programming
  • (Google, Aug 2024)
  • Microsoft Power BI Data Analyst
  • (Microsoft, Aug 2024)
  • IBM Data Analyst
  • (IBM, Jul 2024)
  • Python for Data Science, AI & Development
  • (IBM, Jul 2024)
  • Generative AI : Data Analytics
  • (IBM, Jul 2024)
  • Data Visualization for Data Analysis and Analytics
  • (IIBA, May 2024)
  • SQL- Essential training
  • (NASBA, May 2024)
  • Excel- Managing and Analyzing Data
  • (PMI, May 2024)
  • Complete Tableau Bootcamp for Data Visualization
  • (Udemy, May 2024)

Timeline

Managing Head of Academic Medical Department

AESL
03.2023 - 08.2023

Head of Zoology Department

AESL
04.2019 - 02.2023

Zoology Lecturer

AESL
07.2018 - 03.2019

Biology Lecturer

Agasti Education
06.2016 - 04.2018

Biology Lecturer

P.P.Savani Internation School
06.2015 - 04.2016

Master of Science - Microbiology

Maharaja Sayajirao University

Bachelor of Science - Medical Technology

Veer Narmad South Gujarat University
Shagufta Pathan