Pfizer logoPfizer Externship via Extern
Ishitha Singh Kanoj portrait

Aspiring Data Analyst with a Passion for SQL

I am committed to building a solid foundation in Data Analytics and enhancing my resume for future opportunities.

🟢 Open to work

Work samples

Dive into my portfolio showcasing my work in Data Analytics, SQL, and Database Architecture. Each project reflects my commitment to learning and growth.

  • SQL & Database Architecture Externship with Breaking Games
    SQL & Database Architecture Externship with Breaking Games
    Breaking Games logo

    Breaking Games · Sep 2026 · ✅ Verified by Extern

    SQL & Database Architecture Externship with Breaking Games

    Turn six messy CSVs into an analytics database and a Q4 dashboard that drives real business decisions. SQL + Claude.

    Analytics Database DesignData AnalysisSQL FundamentalsData Storytelling
  • Statistical Analysis Portfolio
    Statistical Analysis Portfolio

    Applied permutation tests, t-tests, and chi-square tests to conduct statistical analysis and validate hypotheses across domains including EV performance and behavioral psychology. Built and compared linear regression models to identify Airbnb price drivers, evaluating statistical model performance w

    RRStudioStatistical TestingRegression Modeling

About me

I am committed to building a solid foundation in Data Analytics and enhancing my resume for future opportunities.

I am a senior at Rutgers University working towards a Bachelor's Degree in Computer Science. With some work experience, I am excited to start my career in Data Analytics and improve my skills in Python and Database Architecture.

Externships

Pfizer Advanced: AI-Powered Document Insights & Data Extraction Externship

In progress

Experience

Orientation Leader

New Student and Family Program · May 2024 - Aug 2026

Education

Rutgers University

BS Computer Science · Class of 2027

Skills

Data AnalyticsSQLDatabase ArchitectureComputer ScienceA/B TestingPythonJavaClaudeChatGPTVisuRPerplexity

✅ Verified by Extern

SQL & Database Architecture Externship with Breaking Games

Turn six messy CSVs into an analytics database and a Q4 dashboard that drives real business decisions. SQL + Claude.

Analytics Database DesignData AnalysisSQL FundamentalsData Storytelling

Overview

The work ingested six disparate data sources into a working SQLite analytics database, inventoried raw files, and ran SQL to measure product and revenue metrics. It defined a dim_product table, joined sales and event tables, and aggregated revenue and units to produce a ranked product performance table. The work also cleaned 421 referral strings, calculated CTR/CPC/ROI per Meta campaign, and

SQL & Database Architecture Externship with Breaking Games
Google Drive
Access

What I've accomplished

I loaded six data sources into SQLite, built a dim_product table with keys and joins to event and sales tables, aggregated product revenue and units into a ranked reorder table, and cleaned referral data to calculate campaign CTR/CPC/ROI and a Q4 ad allocation plan.

Project breakdown

View all work

Statistical Analysis Portfolio

Applied permutation tests, t-tests, and chi-square tests to conduct statistical analysis and validate hypotheses across domains including EV performance and behavioral psychology. Built and compared linear regression models to identify Airbnb price drivers, evaluating statistical model performance w

RRStudioStatistical TestingRegression Modeling
View all work

Algorithmic Bias Audit – COMPAS Dataset

Performed end-to-end data manipulation on a 60,000-row recidivism dataset using Python, Pandas, and NumPy; engineered features by parsing dates, calculating ages, and encoding categorical variables. Resolved one-to-many relational data integrity issues by grouping patient identifiers and segmented d

PythonPandasNumPyJupyter Notebook
View all work

Full-Stack Web Application | CodePath Capstone

Designed and built a responsive full-stack web application as the capstone for a 10-week intensive CodePath software engineering program. Engineered a dynamic front-end using HTML, CSS, and JavaScript; implemented a back-end with Node.js and Express.js to handle HTTP requests and RESTful API routes.

HTMLCSSJavaScriptNode.jsExpress.jsGit

Overview

Full-Stack Web Application | CodePath Capstone
View all work

✅ Verified by Extern · ⏱️ In progress

Pfizer Advanced: AI-Powered Document Insights & Data Extraction Externship

Prototype AI-powered document intelligence with Pfizer—using OCR, LLMs, and RAG to automate real enterprise PDF workflows and build a standout portfolio project.

AI & MLPythonDocument IntelligencePresentation Skills

Overview

The work prototyped an AI-driven document intelligence pipeline combining OCR, language models, and retrieval techniques to process enterprise PDFs. The project researched LLM behavior, designed extraction and indexing steps, and assembled components into a reproducible prototype.

Pfizer Advanced: AI-Powered Document Insights & Data Extraction Externship

What I've accomplished

I researched and documented the fundamentals of large language models to ground the prototype's design decisions and implementation.

Project breakdown

View all work