Paul Dettorre
Automation Developer
Durham,NC
Summary
As a Principal IT Software Developer at SAS for over 20 years, I have contributed to building and maintaining advanced data warehousing and management solutions. My expertise in artificial intelligence, Minitab, and data warehousing has supported the development of systems that align with organizational goals and foster operational efficiency. Through a collaborative and detail-oriented approach, I have partnered with teams to create impactful strategies that empower data-driven decision-making. Committed to delivering value through robust technical solutions, I aim to enable innovation and support organizational growth.
Overview
35
35
years of professional experience
1
1
Certification
Work History
Principal IT Software Developer
SAS
Cary, NC
10.2014 - Current
- Led enterprise automation and microservices modernization initiatives, specializing in N8N workflow automation and TypeScript-based cloud architecture.
- Deployed N8N automation platform company-wide, building 50+ workflows that eliminated 40+ hours of manual work weekly.
- Developed 12 custom TypeScript N8N nodes for SAS Viya API integrations, streamlining previously manual data operations.
- Created an AI-powered GitHub error analysis agent using Azure OpenAI, reducing debugging time from 2 hours to 15 minutes per incident.
- Automated SAS Viya audit log analysis, cutting monthly manual review time by 60% and generating daily compliance reports.
- Architected scalable platform of 200+ microservices using Azure, DAPR, and TypeScript/Node.js, supporting 500+ concurrent environments.
- Reduced deployment time from 4 hours to 15 minutes through automated orchestration.
- Migrated 3 legacy monolithic applications (300K+ LOC) to AKS microservices, improving uptime from 95% to 99.5%.
- Built a Backend-for-Frontend (BFF) system with NATS, Kafka, and Azure Service Bus, reducing API round-trip times by 55% and improving load times by 2.3 seconds.
- Wrote microservices using GoLang, TypeScript, and Azure Service Bus to speed up distribution of application status enhancing the ability to pinpoint errors with automation scripts.
- Created Zod schema abstraction framework, reducing validation code complexity by 60% across 50+ services.
- Cut schema-related bugs by 80% and reduced new service onboarding from 3 days to 4 hours.
- Built a proof of concept low-code solution similar to N8N, before deciding to use N8N as an automation tool.
- Key Technologies: Azure OpenAI, TypeScript, Node.js, N8N, Azure Kubernetes Service, Microservice Architecture. Event Messaging (NATS, Kafka, Azure Service Bus)
Senior Software Developer - Cognitive Analytics R & D
SAS
Cambridge, United States
01.2011 - 10.2014
- Led social media analytics and data engineering initiatives for SAS's Social Media Application, building scalable data pipelines and sentiment analysis capabilities.
- Architected and deployed NodeJS-based connector framework for SAS Social Media Application, enabling real-time data ingestion from Twitter, Facebook, Google+, and Instagram.
- Built data mining application using GNIP (Twitter) streaming connector, processing 10M+ tweets daily, providing enterprise clients with real-time social sentiment monitoring.
- Developed Facebook and Instagram API integrations that aggregated 500K+ posts per day for brand analysis and customer insights.
- Designed Python and JavaScript ETL pipelines that standardized multiplatform social data into unified JSON/XML formats, reducing data processing time by 65%.
- Implemented dual-database architecture using MySQL (normalized data) and MongoDB (raw data), supporting OLAP queries across 50TB+ of social media content.
- Created a data normalization framework that handled 15+ distinct social media schemas, enabling consistent cross-platform analytics.
- Built Python-based web listeners for Twitter/GNIP streaming API, enabling live sentiment tracking and historical replay analysis for enterprise dashboards.
- Developed sentiment analysis models in Python that processed and classified 2M+ social posts daily with 85%+ accuracy.
- Delivered metrics framework tracking engagement, reach, and sentiment trends across multiple platforms, powering executive reporting for Fortune 500 clients.
Senior Solutions Developer - Retail Practice
SAS
Middleton, United States
08.2005 - 01.2011
- Led retail analytics platform development and data engineering initiatives, specializing in SAS, OLAP architecture, and enterprise data management solutions.
- Developed an integrated Merchandise Planning solution using SAS, enabling retail clients to optimize inventory allocation across 1,000+ store locations.
- Co-authored a Metadata Manager tool for Retail Intelligence Platform using C# and SQL Server, providing centralized governance for 200+ data assets and reducing metadata conflicts by 75%.
- Established enterprise-wide quality control framework for data loads and extracts, achieving 99.8% data accuracy across 50+ daily ETL processes.
- Built complex SAS and SQL Server data processing pipelines handling 100GB+ of raw client data monthly, reducing processing time from 12 hours to 3 hours.
- Engineered Python and SAS extraction tools for proprietary MDDB multidimensional structures, unlocking legacy data for modern analytics platforms.
- Designed and implemented SAS OLAP cubes using PROC OLAP and PROC INFOMAP, serving 100+ concurrent users with sub-second query response times.
- Migrated 40+ critical reports from database table extraction to MDX-based OLAP Cube queries via Report Services, improving report generation speed by 85%.
- Created MDX validation framework using SAS jobs, ensuring dimensional integrity across 25+ production cubes.
- Developed custom SAS Integration Technologies (Java) solution for Oracle data extraction, automating previously manual processes and eliminating 20+ hours of weekly ETL work.
- Built a SAS macro library utilizing hash table structures for database lookups, accelerating join operations by 90% and becoming standard practice across the development team.
Lead SAS Developer
Ingenix
Waltham, United States
08.2004 - 08.2005
Software Manager - SAS Solutions
CNS Inc
11.2003 - 08.2004
Director Of Technology - Database Development
Epsilon
Wakefield, United States
01.2003 - 11.2003
Senior SAS Developer
Adheris, Inc
Woburn, United States
11.1999 - 01.2003
Consultant
Harvard Pilgrim Health Care
Waltham, United States
08.1996 - 11.1999
Consultant
Tessera Enterprise Systems
Wakefield, Massachusetts
01.1996 - 02.1997
Programming Analyst
Epsilon
Burlington, United States
08.1991 - 01.1996
Education
Artificial Intelligence Engineering -
Penn State University
12.2027
Statistics -
Texas A&M University
01.2013
BS - Computer Science
Salem State University
01.1990
Websites
Certification
- Microsoft Certified: Azure Fundamentals
- EMS Instructor/Coordinator
Languages
English, Native or Bilingual
Timeline
Principal IT Software Developer
SAS
10.2014 - Current
Senior Software Developer - Cognitive Analytics R & D
SAS
01.2011 - 10.2014
Senior Solutions Developer - Retail Practice
SAS
08.2005 - 01.2011
Lead SAS Developer
Ingenix
08.2004 - 08.2005
Software Manager - SAS Solutions
CNS Inc
11.2003 - 08.2004
Director Of Technology - Database Development
Epsilon
01.2003 - 11.2003
Senior SAS Developer
Adheris, Inc
11.1999 - 01.2003
Consultant
Harvard Pilgrim Health Care
08.1996 - 11.1999
Consultant
Tessera Enterprise Systems
01.1996 - 02.1997
Programming Analyst
Epsilon
08.1991 - 01.1996
Artificial Intelligence Engineering -
Penn State University
Statistics -
Texas A&M University
BS - Computer Science
Salem State University