Hi! I'm Ray Nawara.

I specialize in AI-powered analytics and enterprise data warehouses.
Currently building multi-persona AI systems that transform raw dealership data into actionable insights.

My Portfolio

Enterprise data systems, AI-powered analytics, and full-stack web applications built with Rails 8.1, PostgreSQL 18, and modern JavaScript.

Automotive Analytics Platform

AI-Powered Data Warehouse

AI-Powered Automotive Data Warehouse

Sole architect and implementor of an enterprise-scale PostgreSQL 18 data warehouse for a national automotive digital marketing company. Integrates data from VinSolutions, Drive Centric, Agile CRM, vAuto, CallRail, GA4, Google Ads, and Facebook Ads.

AI Personas: Designed and built a multi-persona AI analysis system featuring Sales Performance, Digital Marketing, BDC Operations, Inventory & Merchandising analysts, plus synthesis summarization. Going to Beta for nationwide dealership rollout.

Tech: Rails 8.1, Ruby 4.0, PostgreSQL 18, Hotwire, Kamal, Solid Queue, BigQuery, Google Cloud, Azure

Paid Advertising & Analytics

Google Ads, Facebook Ads & GA4

Google Ads, Facebook Ads & GA4 Integration

Built comprehensive paid media and analytics data extraction systems integrated into the data warehouse. All data feeds into AI Personas for analysis by dealership ownership and management.

Automation: Developed Puppeteer scripts to automatically download and process Google Ads scheduled email reports from the Google Ads UI. Built Supermetrics integration for extracting Google Ads and Facebook Ads KPIs. Integrated GA4 data via BigQuery export.

Features: Campaign performance tracking, budget pacing, click share calculations, cost-per-lead analysis, cross-platform attribution, and AI-powered performance insights.

Tech: Puppeteer, Supermetrics, Google Ads API, Facebook Marketing API, GA4 BigQuery Export, Rails 8.1, PostgreSQL

ETL Pipeline System

Multi-Source Data Integration

Enterprise ETL Pipelines

Architected and built comprehensive ETL systems handling millions of records from multiple automotive industry data sources.

CRM Automation: Created Google Apps Script systems that automatically process daily CRM emails from VinSolutions and Drive Centric, converting Excel/CSV attachments into SQL databases. Scripts handle email parsing, file extraction, data transformation, and database population.

Features: Automated daily syncs, error monitoring with email alerts, incremental processing, data validation, and audit logging.

Tech: Google Apps Script, Rails 8.1, Node.js, PostgreSQL, BigQuery, SFTP automation, Solid Queue

CallRail Integration

Phone Call Analytics & Attribution

CallRail Phone Analytics

Built comprehensive phone call tracking and lead attribution system integrated with dealership CRM data.

Features: Call-to-lead matching, sales attribution, call recording integration, and phone performance analytics by source.

Tech: CallRail API, Rails 8.1, PostgreSQL, automated matching algorithms

Looker Studio Automation

Automated Report Generation

Looker Studio Report Automation

Built automated systems to generate and distribute Looker Studio reports for dealership clients.

Features: Automated data source creation, scheduled report generation, dynamic date ranges, and multi-dealer report management.

Tech: Node.js, Looker Studio API, Google Cloud, Puppeteer automation

Collectibles Authentication Platform

Trading Card Grading & Certification

National Authentication Company Website

Multi-year development and maintenance for a premier trading card authentication and grading company. The platform supports card grading, certification services, and digital review capabilities for collectors nationwide.

About Me

Ray Nawara

I'm Ray Nawara, a full-time AI & Data Warehouse Architect specializing in building AI-assisted intelligent analytics systems.

At a national automotive digital marketing company, I identified that their greatest untapped asset was a massive repository of automobile dealer data. I proposed the solution to the CEO and became the sole architect and implementor of a comprehensive PostgreSQL 18 data warehouse that integrates data from multiple industry platforms including VinSolutions, Drive Centric, Agile CRM, vAuto, CallRail, GA4, Google Ads, and Facebook Ads.

What sets this system apart is the AI layer. I designed and built a multi-persona AI analysis system that doesn't just answer questions like "How many leads did we get this week?" but provides complete performance analysis through specialized AI personas: Sales Performance Analyst, Digital Marketing Analyst, BDC Operations Analyst, Inventory & Merchandising Analyst, and a Synthesis Summarization Analyst that ties it all together. This system is going to Beta and will be offered to automobile dealerships nationwide.

Current Tech Stack: Rails 8.1, Ruby 4.0, PostgreSQL 18, Hotwire (Turbo/Stimulus), Kamal deployment, Solid Queue/Cache/Cable, Node.js for ETL, Google Cloud (BigQuery), Microsoft Azure. I work with AI/LLM integration daily, building customizable prompt systems with hierarchical inheritance for dealer-specific customization.

Background: After 25+ years as a software company CEO managing 30+ offices, I returned to my first love: building software. I combine decades of executive-level business experience with hands-on technical expertise - I understand both the code and the business value it creates. Former Database Administrator, AWS Certified Cloud Practitioner. I work remotely and maintain a powerful local AI development environment for experimentation.

Certificates

Contact

I'm currently employed full-time building AI-powered data warehouse systems for the automotive industry. While I'm happy in my current role, I'm always open to discussing interesting opportunities in AI, data engineering, or Rails development.

Feel free to reach out!