Portfolio

Shraya
Rajkarnikar

Data Analyst with a background in SQL, Python, Power BI, and GIS — building pipelines, dashboards, and models that turn messy data into clear decisions. B.S. Information Technology (Cybersecurity Track), UNC Pembroke, May 2026.

GPA 3.67 Chancellor's List Ready to Relocate
01

Projects

Jan – May 2026

Capstone · Full-Stack · Financial Analytics · Data Validation

SpendGuard — Financial Audit Platform

Full-stack financial auditing platform that automatically detects duplicate payments, identifies recurring subscriptions via date-gap analysis, and performs contract compliance comparisons across uploaded PDFs. Built complete MySQL schema with referential integrity, full data validation layer, audit-ready report generation, My Files management, and Mark Resolved workflow. Designed for enterprise audit use cases with a focus on data integrity and compliance reporting.

Node.jsExpressMySQLPDF.jsHTML/CSS/JSETLData Validation
HackUNCP 2026 · Built in <24 hours

Hackathon · AI · Chrome Extension · Data Pipeline

CanvasInsight — AI-Powered Chrome Extension

Chrome extension built at HackUNCP 2026 that ingests Canvas LMS discussion posts via REST API and DOM scraping, processes them through Claude AI, and delivers structured per-student comprehension reports in ~30 seconds — replacing 1–3 hours of manual reading. Full data pipeline: ingest → clean → structure → analyze → render scored dashboard. Solved Manifest V3 CORS restrictions, custom Canvas domain compatibility, and chrome.storage race conditions. 1,572 lines of vanilla JavaScript — zero dependencies, zero backend servers.

JavaScriptChrome Extension APICanvas REST APIClaude AIHTML/CSSData PipelinePrompt Engineering
Mar 2025 – Present

Research · GIS · Environmental Analytics · Statistical Modeling

Robeson County Groundwater Monitoring Program

Research project analyzing groundwater and precipitation correlation across 13 monitoring sites in Robeson County, NC. Built automated Python ETL pipelines processing 5+ years of sensor data, cutting prep time ~60%. Applied Pearson correlation and predictive modeling to identify environmental drivers. Developed ArcGIS Pro spatial dashboards and LULC maps. Key finding: Bethel Hill's anomalous behavior caused by the Black Creek Confining Unit — presented to 50+ stakeholders at PURC Symposium 2026.

PythonArcGIS ProExcelETLPearson CorrelationStatistical ModelingGIS
Aug – Dec 2024

Full-Stack · Personal Finance · Dashboard Development

Penny Tracker — Personal Finance Dashboard

Full-stack personal budgeting application for tracking income, expenses, and savings goals. Designed PostgreSQL schema with referential integrity for multi-category transaction histories. Built Node.js/Express REST API with dynamic filtering and React dashboards visualizing spending trends, budget progress, and savings goals with real-time updates.

ReactNode.jsPostgreSQLREST APIDashboardData Viz
Aug – Dec 2023

Machine Learning · Predictive Analytics · Geospatial

Crime Prediction Model

Predictive analytics project using 5 years of Nebraska crime data to identify high-risk geographic and temporal patterns. Trained Random Forest and Logistic Regression models, evaluated with cross-validation and confusion matrices, and visualized outputs as geospatial heat maps and summary reports for public safety decision-making.

PythonScikit-learnPandasRandom ForestStatistical ModelingGeospatial
Jan – Apr 2026

IoT · Embedded Systems · Real-Time Data Pipeline

Decentralized Wireless IoT Greenhouse Ecosystem

Full-stack IoT monitoring system progressed from wired prototype to decentralized wireless network using ESP-NOW peer-to-peer communication and Deep Sleep power management. Built Python/Streamlit real-time analytics dashboard with signal processing for noise reduction. Designed 6 parametric CAD components in FreeCAD for moisture-resistant field deployment. Investigated Federated Learning feasibility for on-device ESP32 model training.

PythonStreamlitESP32ESP-NOWC++MySQLFreeCAD
02

Skills

Languages & Query

  • SQL (MySQL)
  • Python
  • JavaScript
  • HTML / CSS
  • PHP
  • Java

Analytics & Libraries

  • Pandas, NumPy
  • Matplotlib, Streamlit
  • Scikit-learn
  • Statistical Modeling
  • Google Analytics
  • Excel (Advanced)

BI & Visualization

  • Power BI
  • Tableau (in progress)
  • ArcGIS Pro
  • Dashboard Development
  • Canva

Engineering & Tools

  • ETL Pipelines
  • Git / GitHub
  • MySQL Workbench
  • Node.js / Express
  • React
  • Arduino / ESP32
  • FreeCAD
03

Experience

Mar 2025 – Present

UNC Pembroke

Research Assistant — Groundwater & Precipitation Correlation Project

Built automated Python ETL pipelines processing 5+ years of sensor data, cutting prep time ~60%. Developed ArcGIS Pro spatial dashboards and presented at PURC Symposium 2026 to 100+ stakeholders. Applied statistical correlation and predictive modeling to identify environmental patterns across Robeson County.

PythonArcGISETLStatistical Modeling

Jan 2024 – Aug 2025

Metapillar · Remote

Data Analyst Intern

Built SQL/Python ETL pipelines consolidating data from 3+ enterprise systems, reducing manual processing ~40%. Developed executive dashboards and ad-hoc reports translating complex datasets into strategic recommendations. Conducted GAP analysis and data quality checks with full process documentation.

SQLPythonETLPower BIGAP Analysis

Jan 2023 – Dec 2024

Australia ma Nepali · Remote

Data & Business Analyst

Managed SQL databases housing student resources, job listings, and visa data with daily quality audits. Built Power BI dashboards visualizing traffic and content performance. Analyzed Google Analytics data and delivered monthly engagement reports. Automated news aggregation and data cleaning with Python scripts. Served as liaison between content team and developers.

SQLPower BIGoogle AnalyticsPythonPandas

Mar – May 2025

UNC Pembroke

Student Peer Mentor

Developed instructional materials translating complex database and programming concepts for 20+ students. Led guidance sessions on academic strategy, time management, and campus resources.

InstructionCommunication
04

Education

Expected May 2026

Pembroke, NC

B.S. Information Technology — Cybersecurity Track

University of North Carolina at Pembroke

GPA: 3.67 / 4.00  ·  Chancellor's List  ·  Honor's List  ·  IT Excellence Award (2024–2025)  ·  Pembroke Scholar

Coursework: Probability & Statistics, Predictive Modeling, DBMS, Data Structures, OOP (Python/Java), Web Development

2021 – 2023

Kearney, NE

B.S. Information Technology (Transfer)

University of Nebraska at Kearney

Dean's List — 3 semesters

05

Contact

Location

Raleigh, NC  ·  Open to Relocate