Daniel Sias

Projects

A collection of my work, showcasing technical problem-solving and business impact.

Nexus: Analytics Command Center

Pearson Online Learning Services

Built from the ground up to solve our data bottleneck, Nexus transformed how we handled marketing analytics. By connecting React and Node.js with BigQuery, we turned a multi-day reporting marathon into a streamlined process that took hours. The platform now actively monitors over $25M in marketing investments, giving teams instant access to their KPIs and enabling rapid, data-driven campaign adjustments.

Technologies: React.js • Node.js • BigQuery • Salesforce • Express.js

Challenges: Handling massive datasets efficiently while ensuring real-time updates across marketing and executive dashboards.

Impact: Reduced weekly reporting efforts by 20+ hours and increased marketing efficiency through actionable insights.

Well Prompted: AI-Powered Developer Prompt Tool

Personal Project

Developed a tool to help engineers generate high-quality AI prompts for code generation, debugging, and documentation, streamlining the workflow for software development teams.

Technologies: React.js • Node.js • Prisma • Supabase • TailwindCSS

Challenges: Designing an intuitive UI/UX for structuring and chaining AI-powered prompts in a meaningful way.

Impact: Provided an efficient way for developers to leverage AI in coding workflows, reducing debugging time and increasing productivity.

SparkStack: Full-Stack Boilerplate

Personal Project

Built a highly configurable boilerplate to streamline full-stack web application development, featuring authentication, database integration, and best practices for modern web projects.

Technologies: React.js • Node.js • Express • TypeScript • Supabase • Prisma • TailwindCSS

Challenges: Designing a flexible, scalable architecture that balances performance, maintainability, and ease of use for developers.

Impact: Accelerated project setup time for developers, enabling rapid prototyping and reducing boilerplate overhead.

Executive Insights Dashboard

Pearson Online Learning Services

What started as a request for "better visibility" evolved into leadership's daily compass for decision-making. This interactive dashboard brings together department performance, annual targets, and emerging challenges in one clear view. The real game-changer? Department heads can now spot issues and coordinate solutions directly through the platform, cutting through traditional communication barriers.

Technologies: React.js • Node.js • BigQuery • PostgreSQL • Chart.js • Google Cloud Functions

Challenges: Consolidating data across multiple departments into a single, easily digestible interface while ensuring real-time accuracy and actionable insights.

Impact: Provided executive leadership with a centralized source for monitoring performance, improving communication, and aligning departments with strategic goals.

Email Marketing Performance Tracker

Pearson Online Learning Services

Developed an analytics dashboard to centralize email marketing performance data, allowing teams to track open rates, click-through rates, and conversions across campaigns while enabling A/B test comparisons.

Technologies: React.js • Node.js • Salesforce Marketing Cloud API • Google Analytics API • BigQuery

Challenges: Aggregating data from multiple sources while ensuring real-time accuracy and usability for non-technical marketing teams.

Impact: Provided marketing teams with a unified view of email performance, improving decision-making speed and increasing email engagement through data-driven optimizations.

SEO Performance Tracker with Ahrefs API

Pearson Online Learning Services

Built a custom dashboard using the Ahrefs API to track keyword rankings, site health, backlink profiles, competitor analysis, and site audits, providing the SEO team with data-driven insights to improve search visibility.

Technologies: Node.js • React.js • Ahrefs API • PostgreSQL • Express.js • Chart.js

Challenges: Integrating large-scale SEO data from Ahrefs while ensuring real-time updates and meaningful visualizations for the marketing team.

Impact: Enabled the SEO team to monitor ranking progression, assess competitor performance, and optimize technical SEO, leading to increased organic traffic and improved search rankings.

Marketing Budget & Forecast Hub

Pearson Online Learning Services

Tackled the chaos of spreadsheet-based planning by creating a centralized system that marketing teams actually enjoy using. This web-based platform streamlined our entire budget cycle - from initial forecasts to final approvals. Channel owners can now update projections, get sign-off, and collaborate with their teams all in one place, turning what was once a monthly headache into a smooth, continuous process.

Technologies: React.js • Node.js • Express.js • PostgreSQL • TailwindCSS • Google Sheets API

Challenges: Ensuring data accuracy while transitioning from spreadsheet-based workflows to a centralized system with multi-user input and approval tracking.

Impact: Streamlined forecasting, improved collaboration between marketing and leadership, and enhanced financial planning transparency, reducing manual errors and approval delays.

Salesforce Migration & Data Warehouse Setup

Pearson Online Learning Services

Collaborated on migrating internal data from legacy systems and an MS SQL Server database to Salesforce and BigQuery, ensuring data integrity, seamless reporting, and minimal business disruption.

Technologies: Salesforce • BigQuery • MS SQL Server • ETL Pipelines • Python • Google Cloud Functions

Challenges: Ensuring complete and accurate data transfer while maintaining reporting continuity and minimizing downtime.

Impact: Successfully transitioned critical business data to modern cloud-based infrastructure, preserving historical insights and enabling scalable, real-time reporting.

Recruitment Agent Activity Tracking

Pearson Online Learning Services

Integrated the Nice inContact API to pull agent activity and time logs, enabling managers to monitor daily performance, compare efforts to targets, and track lead progression through the recruitment funnel.

Technologies: Node.js • React.js • Nice inContact API • PostgreSQL • BigQuery • Chart.js

Challenges: Aggregating real-time agent data while ensuring accuracy in performance tracking and lead attribution.

Impact: Provided managers with real-time insights into agent productivity, improving operational efficiency and optimizing recruitment workflows.

Let’s Work Together

Interested in working together or have a question? Reach out and let’s talk!