Avijit Roy

Experience

I bridge data, security, and applied AI to build impactful, real-world systems in education and public service. My focus is clear: combine research-grade rigor with scalable engineering to solve hard problems—whether streamlining multi-campus data workflows, safeguarding sensitive intel, or mentoring the next generation of engineers. I believe technology should not just function; it should empower. My work reflects that.

Adjunct Lecturer (Aug 2025 – Present)

CUNY John Jay College of Criminal Justice • New York, NY

As an Instructor for Object Oriented Programming and Introduction to Computer Programming, I design and deliver coursework that helps students move beyond syntax and into real software reasoning. I teach object-oriented problem solving through hands-on programming, guiding students in understanding memory models, abstraction, and clean program structure.

  • Develop learning modules covering memory layout, pointer/reference semantics, RAII, class design, inheritance, and polymorphism.
  • Lead multi-file programming projects requiring separation of interface and implementation, compilation workflows, and operator overloading.
  • Coach students in diagnosing segmentation faults, memory leaks, copy‐vs‐move behavior, and undefined behavior using structured debugging techniques.
  • Standardize Git workflows (branching, merge resolution, commit structure) to prepare students for collaborative software engineering environments.

Data Analyst (Jul 2024 – Present)

The City University of New York (CUNY)

I analyze multi-campus student enrollment and immigration-related records to ensure data accuracy and regulatory compliance across the CUNY system. My work focuses on building reconciliation workflows, automating validation pipelines, and generating dashboards that support data-driven decision-making.

  • Analyze 10,000+ student records each term (with 60+ data attributes per record) using SQL and Python to support SEVIS reporting, enrollment planning, and regulatory compliance.
  • Build automated reconciliation and anomaly-detection workflows that reduce manual data correction efforts and improve cross-campus data reliability.
  • Develop Tableau and Excel dashboards that visualize enrollment movement and compliance indicators across 26 campuses, enabling faster administrative decision-making.
  • Document standardized data governance procedures to ensure repeatable audit readiness and consistent reporting across distributed administrative units.

AI Research Assistant (Jun 2025 – Aug 2025)

The Research Foundation of the City University of New York (RFCUNY)

As an AI Research Assistant at the Research Foundation of CUNY, I contributed to the development of a writing proficiency assessment system aligned with ACTFL standards. My work focused on preparing structured text corpora, fine-tuning transformer models, and evaluating model performance to ensure linguistic accuracy and interpretability.

  • Prepared labeled text corpora and evaluation datasets for ACTFL-aligned writing proficiency assessment.
  • Fine-tuned transformer-based models and evaluated performance through confusion matrices, threshold sweeps, and linguistic error clustering.
  • Built an interactive Gradio-based interface to enable explainable model inspection for instructors and researchers.
  • Authored reproducible training and evaluation pipelines to ensure traceable and repeatable research experimentation.

Research Mentor — Software Development & Applied Computing (Jun 2025 – Aug 2025)

CUNY John Jay College of Criminal Justice • New York, NY

As a Research Mentor in the Department of Mathematics & Computer Science, I guided undergraduate researchers in designing secure, production-aligned web systems. I led students through full-stack workflows, emphasizing authentication, session integrity, and software reliability.

  • Designed a concurrency-safe session enforcement architecture using Django middleware and PostgreSQL-backed session state tracking.
  • Guided students through schema design, token invalidation logic, and device-aware session lifecycle management.
  • Conducted code reviews emphasizing deterministic control flow, separation of concerns, and idempotent design.
  • Structured the final implementation as a reproducible research artifact with deployment documentation and test coverage.

Graduate Research Assistant (Jan 2025 – May 2025)

CUNY John Jay College of Criminal Justice • New York, NY (Hybrid)

As a Graduate Research Assistant, I architected a secure real-time intelligence platform supporting human-trafficking investigations. I built live map dashboards and analytics workflows while integrating security controls such as OAuth2, RBAC, encryption-at-rest, and audit logging to safeguard sensitive PII.

  • Developed a .NET Core / API backend and React-style admin interface enabling structured tip reporting, data retrieval, and investigative workflow support.
  • Implemented real-time mapping features using Google Maps API, SignalR, and Hangfire to support live geospatial updates, asynchronous case processing and event notifications.
  • Enforced security and compliance controls including OAuth2 authentication via Azure AD, TLS encryption in transit, field-level encryption at rest, RBAC to safeguard sensitive PII, and auditable access patterns.
  • Designed comprehensive audit-logging, anomaly-detection, and data-integrity routines to identify suspicious access, tampering attempts, and unusual behavioral trends.
  • Designed modular Razor/Bootstrap dashboard views enabling investigators to filter, drill down, and export demographic, vehicle, and behavioral data for law enforcement and policy decision-making.

University Student Records Coordinator (Jun 2023 – May 2024)

The City University of New York (CUNY)

I oversaw the management, validation, and reconciliation of university-wide student records, implementing processes that improved data reliability across multiple campus systems. I developed automated comparison tools, reduced manual verification, and ensured alignment with institutional and regulatory requirements.

  • Built a C#/.NET application to automate cross-file student record comparison, reducing manual verification time by ~30%.
  • Implemented unique-identifier matching and discrepancy indexing for reliable data alignment across systems.
  • Automated reporting with Excel/VBA macros to generate audit-ready exception summaries.
  • Collaborated with Registrar and ISSS teams to translate regulatory rules into deterministic validation constraints.

IT Specialist & Data Analyst (Oct 2019 – Jun 2023)

The City University of New York (CUNY)

I managed data workflows across multiple student information systems, performed large-scale data cleansing, and developed query and visualization tooling to support enrollment analysis. My work improved reporting consistency, reduced manual processing, and informed administrative planning across academic units.

  • Wrote SQL queries and stored procedures to reconcile and analyze 10,000+ student records across RDBMS platforms.
  • Performed predictive enrollment and retention analysis using cohort-level trend indexing.
  • Developed standardized Tableau and Excel reporting templates, increasing reporting efficiency by ~80% across offices.
  • Implemented structured data quality checks enabling faster resolution of discrepancies.