Services

Our Services

Every service is backed by hands-on delivery experience, not just theoretical knowledge. We write the code, design the architecture, and deliver production results.

SAS Development & Architecture

Deep expertise across the full SAS platform

Viking Consulting delivers hands-on SAS development and architecture services across the full SAS platform — from Base SAS and SAS Macros to Enterprise Guide, DI Studio, SAS Studio, and Visual Analytics. With 12+ years of continuous SAS development experience across enterprise environments, we bring deep platform knowledge to every engagement.

Our SAS work spans the full development lifecycle: requirements analysis, data modelling, ETL design, code development, testing, and production deployment. We specialise in complex SAS Macro frameworks, stored process development, and SAS/SQL hybrid solutions that leverage the strengths of both languages.

We have extensive experience with SAS platform administration, including SAS 9.4 installation and configuration on Linux and Windows Server, metadata server management, and performance tuning. At Curtin University, we managed the complete SAS 9.4 platform lifecycle on VMware ESXi infrastructure.

Technologies

SAS 9.4SAS ViyaSAS StudioEnterprise GuideBase SASSAS MacrosDI StudioVisual AnalyticsStored Processes

Key Results

  • SAS Certified Data Integration Developer
  • 12+ years SAS development
  • Platform installation and tuning experience

SAS 9.4 to Viya Migration

The flagship service — proven end-to-end delivery

Organizations running SAS 9.4 face a hard deadline: migrate to SAS Viya or lose support. Most discover the migration is far harder than SAS marketing suggests — import tools break on complex Enterprise Guide projects, scheduling does not work as expected, and the expertise gap is enormous.

At PreZero Netherlands, we led the complete SAS 9.4 to Viya migration over three years. This encompassed Enterprise Guide projects, stored procedures, Visual Analytics dashboards, SQL Server databases, file systems, and SAP BW/DS integrations.

Post-migration, we architected the modernised environment: dev/prod separation with collaboration workflows, a PostgreSQL data warehouse with Change Data Capture for SAP delta processing, and cross-platform performance optimisation.

We offer migration assessment, planning, execution, custom tooling development, and post-migration modernisation as a complete service or as individual phases.

Technologies

SAS 9.4SAS ViyaEnterprise GuideVisual AnalyticsDI StudioCustom Migration ToolingApache AirflowPostgreSQL

Key Results

  • Full SAS 9.4 to Viya migration delivered end-to-end (PreZero Netherlands)
  • Custom EG import tool overcoming critical Viya platform bugs
  • Custom bespoke batch scheduler on SAS Viya
  • Production batch environment on SAS Viya with Apache Airflow

ETL & Data Integration

Pipeline design and batch optimisation with proven results

ETL is the backbone of enterprise data operations. Viking Consulting designs and builds data integration pipelines that are reliable, maintainable, and fast.

Our ETL work includes pipeline design from source profiling through staging, transformation, and presentation layers. We specialise in batch optimisation — identifying and eliminating bottlenecks in mission-critical processing chains. At Federale Verzekering, we reduced the daily ETL batch runtime by 60%.

We also deliver batch scheduling solutions, transitioning organisations from legacy scheduling to modern orchestration platforms like Apache Airflow.

Technologies

DI StudioApache AirflowSAS MacrosBase SASLSFDataFluxData ProfilingBatch Scheduling

Key Results

  • 60% reduction in daily ETL batch runtime (Federale Verzekering)
  • Production batch orchestration with Apache Airflow
  • End-to-end pipeline design and optimisation

Data Warehousing

Architecture design and implementation at scale

Viking Consulting designs and builds enterprise data warehouses using proven methodologies. We have deep experience with Kimball dimensional modelling and Data Vault architectures.

At Sanoma Media Netherlands, we extended the conformed data warehouse using both Kimball and Data Vault methodologies. At HBF Health Insurance, we led ETL development for the core enterprise data warehouse.

Our data warehouse work includes Change Data Capture (CDC) implementations, Slowly Changing Dimensions (SCD Type 1, 2, and 3), and data quality management using DataFlux.

Technologies

KimballData VaultChange Data CapturePostgreSQLOracleDB2SQL ServerGreenplumDataFlux

Key Results

  • PostgreSQL data warehouse with CDC for SAP delta processing
  • Conformed data warehouse across multiple media brands
  • Custom SCD transformations reducing manual coding effort

Business Intelligence

Analytics designed for business users

Business intelligence should serve the business, not just the technical team. Viking Consulting builds analytics solutions designed for business users to consume and interact with directly.

Our BI work includes Visual Analytics dashboard development, OLAP cube design, Information Maps for self-service reporting, and governed sandbox environments.

At HBF Health Insurance, we piloted Self Service Analytics implementing Gartner best practices for governed self-service BI.

Technologies

SAS Visual AnalyticsOLAP Cube StudioInformation Map StudioWeb Report StudioTableauSAS BI ServerSelf-Service Analytics

Key Results

  • Visual Analytics dashboard migration (SAS 9.4 to Viya)
  • Governed self-service analytics pilot (HBF Health Insurance)
  • OLAP cubes and Information Maps for business reporting

AI-Assisted App Development

Production web applications built with modern tools

Viking Consulting builds production web applications using AI-assisted development practices. We leverage 12+ years of enterprise engineering discipline to ship modern web applications.

Current and recent projects include a real-time scheduling platform, business dashboards, a drag-and-drop AI app builder, and community platforms. These are production applications deployed and serving users.

AI-assisted development does not replace experience — it multiplies it. The enterprise discipline of ETL development translates directly to building reliable web applications.

Technologies

Next.jsReactTypeScriptTailwind CSSConvexNode.jsVercelCursorClaude

Key Results

  • Production web applications deployed
  • Real-time scheduling platform built and launched
  • Enterprise engineering discipline applied to modern web stack

Need help with a specific challenge?

Every engagement starts with understanding your situation. Let's talk.

Get in Touch