SQL • DATA ANALYSIS • DATA QUALITY

Nikka Roldan

Data Analyst

I transform messy datasets into reliable insights through SQL automation, data quality auditing, and analytics.

Skills

Tools Behind The Analysis

Spreadsheets

MS Excel, Google Sheets

SQL

MySQL, PostgreSQL, BigQuery

Data Visualization

Power BI, Looker Studio, Metabase

Programming Languages

SQL, C, JavaScript, Python, HTML, CSS

Projects

Understanding Data, One Query At A Time

A macro-enabled Excel workbook for personal budget tracking with automated calculations, category summaries, and monthly trend visualizations.

Excel VBA Macros

Personal Budget Tracker

Excel • VBA • Data Modeling

Automated monthly summaries & category tracking with zero manual input

A client feedback and service information system for PUP's Office of the University Registrar — built with PHP MVC, MySQL, RBAC, and analytics dashboards.

PHP MySQL

Client Feedback System (CFSIS)

PHP • MySQL • MVC Architecture

Full-stack feedback platform with RBAC, analytics dashboards & audit trails

A fully-featured Snake game built in Java with OOP principles — includes bonus food, customizable themes, collision detection, and a game engine loop.

Java OOP

Snake Game

Java • OOP • Game Development

Java OOP concepts reimplemented in the browser with live leaderboard

Play Now

A multi-stage SQL audit pipeline that detects customers assigned to conflicting loyalty segments and auto-categorizes each conflict by business rule — reducing manual review queues by 83%.

PostgreSQL CRM Analytics

Customer Segment Audit

SQL • CTE Pipelines • Data Quality

Validated 30,000+ UPCs across hierarchy, brand & coverage checks

Experience

Building Better Data Workflows

SPINS, LLC

Dec 2025 – Present

Data Activation & Delivery Analyst

  • Built and maintained data mappings, source priority configurations, and attribute schemas supporting enterprise product data pipelines.
  • Developed mapping files, backcoded datasets, and configuration builds for large-scale product attribute enhancements across multiple CPG categories.
  • Validated 30,000+ UPCs through hierarchy, brand, and coverage audits while improving QA workflows and deployment readiness.

SPINS, LLC

Jun 2023 – Dec 2025

Product Research Analyst

  • Classified and attributed 23,000+ retail products across diverse CPG categories.
  • Automated SQL-based audits and workflow improvements, reducing manual review effort by up to 81%.
  • Developed QC rules, SOPs, and documentation to improve product data quality and standardize research processes.

Department of Agriculture

Jan - Jun 2023

Science Research Technician III

  • Applied statistical and sensory analysis to support food product research and innovation.
  • Automated reporting workflows using Google Sheets, reducing report preparation from days to hours.
  • Monitored project budgets and produced analytical reports to support data-driven decision making.
View Career Journey

Credentials

Academic & Professional Certifications

Google Data Analytics Courses

Coursera

Excel Data Analysis

LinkedIn Learning

Python Programming Essentials

DICT

Experimental Design & Data Analysis

DICT

View Academic Background & All Credentials

Contact Me

Contact Me

Interested in collaborating or learning more about my work? Send me a message and I'll get back to you.

Work With Me!

I'm currently open to opportunities in data analytics, reporting, and data quality automation. If you're looking for someone experienced in SQL, large dataset analysis, and workflow optimization, feel free to reach out through the contact form.

Open to opportunities
Replies in 24–48 hours