Ofir Aviram | Solution Architect and Senior Systems Analyst

Professional Summary

Solution Architect and Senior Systems Analyst with 15+ years of experience designing enterprise applications, system integrations, IAM and IDM solutions and business-process automation.

Strong in requirements analysis, functional and technical specifications, business logic, data flows, SQL, ETL, APIs and end-to-end production delivery.

Combines extensive enterprise systems experience with hands-on product development using Node.js, TypeScript, Supabase and AI-assisted development tools.

Core Expertise

End-to-End Full-Stack Product Development: Turning an idea or business requirement into a working product, including product definition, analysis, UX, architecture, data modeling, business logic, integrations, development, testing and production deployment

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

Systems Analysis: Requirements Gathering, Functional and Technical Specifications, Business Process Modeling, Data Modeling, UAT

Delivery: Stakeholder Management, Cross-Functional Leadership, Testing, Troubleshooting, Production Deployment, Agile Delivery

Selected Product Experience

Product Owner & AI-Powered Full-Stack Developer

2026 - Present

Once | Self-Employed

Took Once from concept to a production-ready mobile product, owning product definition, UX, architecture, development, testing and release
Designed the database model, business logic, backend workflows, permissions and real-time processes
Built authentication, location services, matching, real-time chat, credit mechanisms, social Circles and notifications
Developed with Node.js, TypeScript, Supabase, PostgreSQL, Edge Functions, RPC functions and APIs
Used Claude and ChatGPT for prototyping, coding, debugging, refactoring, problem-solving and test-data generation
Prepared and submitted 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

Led the analysis and delivery of enterprise processes, automations and integrations across Salesforce, Priority ERP and Workato
Translated business requirements into functional and technical specifications
Designed data mappings, business logic, integration flows, system interfaces and SQL and ETL processes
Coordinated business stakeholders, IT teams, vendors, testing and production deployment

Senior Systems Analyst | IDM Solution Design

2021 - 2025

Brillix | Israel | Remote

Designed and implemented enterprise Identity Management solutions for Clalit Health Services, Migdal, Ayalon and LivePerson
Created functional and technical specifications for identity processes, interfaces, data transformations and integrations
Designed business logic, data mappings, ETL processes and system interfaces
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 business processes, data structures, user journeys and UX and UI flows
Designed SQL and SSIS integrations and coordinated users, development, DBA, QA and UAT

Identity Management Systems Analyst & Technical Lead

2017 - 2020

Amdocs | Israel

Translated business and security requirements into technical processes, business logic, interfaces and integrations
Designed system workflows and data flows and guided a Java and JSP development team
Coordinated development, cybersecurity, infrastructure, DBA, DevOps, testing and production delivery

IDM Implementation Consultant & Solution Developer

2014 - 2017

ProLink Identity Management Architects | Israel

Independently customized and implemented the Aveksa IAM and Identity Governance platform for Harel, Migdal, Phoenix and Amdocs
Owned the application-level solution design and implementation, excluding infrastructure
Designed business logic, workflows, rules, approval processes, data mappings and synchronization processes
Built integrations with enterprise systems, databases and directories and led testing, deployment and production support

Software Developer | Enterprise Billing Systems

2008 - 2014

Varonis | Israel

Developed and maintained an enterprise billing platform using Microsoft SQL Server, Microsoft Access and VBA
Translated business requirements into database queries, reports, automations and system enhancements
Investigated production issues and worked directly with finance and operational stakeholders

Technical Skills

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, Microsoft Access, VBA

AI and Delivery: Claude, ChatGPT, AI-Assisted Development, Rapid Prototyping, Jira, Agile, UAT

Education

PRODUCT MANAGEMENT PROGRAM

Product Experts | 2021

B.SC. INDUSTRIAL ENGINEERING AND MANAGEMENT

Information Systems Specialization

Ben-Gurion University of the Negev | 2004 - 2008

Military Service

COMBAT SOLDIER AND COMMANDER

Combat Engineering Corps | 1999 - 2002