Ofir Aviram

Solution Architect | Senior Systems Analyst

Enterprise Applications, Integrations and End-to-End Product

Professional Summary

Solution Architect and Senior Systems Analyst with 15+ years of experience designing end-to-end solutions for enterprise applications, system integrations and IAM and IDM systems.

Translating a business need into a solution architecture: business logic, system interfaces, data model and data flows, and carrying it through to production.

Alongside that, end-to-end ownership of a product, from an idea to a release in both app stores, with Node.js, TypeScript, Supabase and AI-assisted development tools.

Core Expertise

Solution Architecture: End-to-End Solution Design, Enterprise Applications, Integration Architecture, Business Logic, System Interfaces, Data Flows

Analysis and Specification: Requirements Gathering, Functional and Technical Specifications, High-Level Design (HLD), Detailed Design (DD), Business Process Modeling, UAT

Platforms and Integration: Salesforce, Priority ERP, Workato, Aveksa, IAM, IDM, IGA, REST APIs, ETL, SSIS

Data and Development: SQL, Microsoft SQL Server, PostgreSQL, Node.js, TypeScript, JavaScript, Supabase, Edge Functions, RPC Functions, Java, JSP, Git

Product and Delivery: End-to-End Product Ownership, Claude, ChatGPT, AI-Assisted Development, Agile, Jira, Production Deployment

Selected Product Experience

Product Owner & AI-Powered Full-Stack Developer

2026 - Present

Once | Self-Employed

  • Full ownership of Once from concept to a production mobile product: product definition, UX, architecture, development, testing and the releases
  • Designed the architecture behind it: the data model, the business logic, the backend workflows, the permission model and the real-time processes
  • Built authentication, location services, matching, real-time chat, credit mechanisms, social Circles and notifications with Node.js, TypeScript, Supabase, PostgreSQL, Edge Functions, RPC functions and APIs
  • Used Claude and ChatGPT for prototyping, coding, debugging, refactoring and test-data generation, and prepared and submitted the production releases for Google Play and the Apple App Store

Product demo: https://once-lake.vercel.app/

Professional Experience

Senior Systems Analyst | Integration & Solution Design

2025 - 2026

Tidhar Group | Israel | Hybrid

  • Responsible for the design and delivery of cross-system business processes, automations and integrations across Salesforce, Priority ERP and Workato, from the business requirement through to production
  • Designed the integration architecture: data mappings, business logic, integration flows, system interfaces and SQL and ETL processes
  • Translated business requirements into functional and technical specifications, and coordinated business stakeholders, IT teams and vendors through testing and implementation

Senior Systems Analyst | IDM Solution Design

2021 - 2025

Brillix | Israel | Remote

  • Responsible for the design and implementation of enterprise Identity Management solutions at Clalit Health Services, Migdal, Ayalon and LivePerson
  • Designed the solution end to end: identity processes, interfaces, data transformations, data mappings and ETL processes, alongside the functional and technical specifications for them
  • Led delivery across cybersecurity, DBA, DevOps, infrastructure, IT and business teams

Systems Analyst | Web Solutions & Process Automation

2020 - 2021

Tel Aviv-Yafo Municipality

  • Led the analysis and design of a Web solution connecting municipal departments and automating cross-organizational workflows
  • Modeled the processes, the data structures and the user journeys, and designed the SQL and SSIS integrations through to acceptance testing

Identity Management Systems Analyst & Technical Lead

2017 - 2020

Amdocs | Israel

  • Designed the organization's identity management solution, from business and security requirements through to processes, business logic, interfaces and integrations
  • Designed system workflows and data flows, and guided a Java and JSP development team through to production delivery

IDM Implementation Consultant & Solution Developer

2014 - 2017

ProLink Identity Management Architects | Israel

  • Owned the solution design and implementation at application level, excluding infrastructure, of the Aveksa IAM and Identity Governance platform at Harel, Migdal, Phoenix and Amdocs
  • Built business logic, workflows, rules, approval processes, data mappings and synchronization processes, and the integrations with enterprise systems, databases and directories

Software Developer | Enterprise Billing Systems

2008 - 2014

Varonis | Israel

  • Developed and maintained an enterprise billing platform using Microsoft SQL Server, Microsoft Access and VBA
  • Turned business requirements into database queries, reports, automations and system enhancements, working directly with finance and operational stakeholders

Education and Service

PRODUCT MANAGEMENT PROGRAM

Product Experts | 2021

B.SC. INDUSTRIAL ENGINEERING AND MANAGEMENT

Information Systems Specialization

Ben-Gurion University of the Negev | 2004 - 2008

COMBAT SOLDIER AND COMMANDER

Combat Engineering Corps | 1999 - 2002

Download PDF עברית