Ofir Aviram

FLOA | Independent

• Own the whole cycle of each project: requirements, system and data design, UX and development. Generative AI, mainly Claude, is the main development tool. Responsibility for quality control, testing and release
• Once, a social mobile app for Android and iOS (React Native, Expo, TypeScript, Supabase, PostgreSQL, Edge Functions): location-based matching and detection of nearby users, real-time communication, chat, groups, a credit system, and a permission model enforced in the database with Row Level Security. Submission to the app stores
• Participants management system for several businesses, each isolated at the database level (multi-tenant, Row Level Security): participants, sessions, payments and subscriptions, an admin interface, a personal area for participants, email and WhatsApp communication, and a public API with keys and signed webhooks for external websites
• A chords and songs app: song index, a page per song and an editor, Google sign-in, reading songs from images with the Claude API, and pre-built song pages for organic search
• Conversion-focused websites and landing pages integrated with paid advertising on Meta and Google Ads: sign-up forms, lead creation, source tracking and campaign measurement

Tidhar Group | Israel | Hybrid

• Responsible for the technical solution and delivery of cross-system business processes and automations across Priority ERP, Salesforce and Workato, from the business requirement through to production
• Designed the integrations between the core systems: data mapping, business logic, validations, interfaces and APIs, with data models and scheduled SQL and ETL processes
• Worked on the TQA quality management system, in an Azure SQL environment and in workflows that spanned enterprise systems and development tools
• Worked with business owners, IT teams, developers and vendors through specification, testing and implementation

Brillix | Israel | Remote

• Responsible for the solution design and implementation of Web-based core Identity Management systems at Clalit Health Services, Migdal, Ayalon and LivePerson
• Designed the solution end to end: identity processes, the interfaces and data transformations between the portal and the core systems, data structures and ETL and synchronization processes
• Led delivery from requirements to implementation across cybersecurity, DevOps, DBA, infrastructure, IT and business teams, through acceptance testing and production support

Tel Aviv-Yafo Municipality

• Led the design of a Web solution connecting municipal departments and automating cross-organizational processes, with user journeys, UX and UI flows and the data structures behind them
• Designed SQL and SSIS interfaces and worked with users, development, DBA and QA through acceptance testing

Amdocs | Israel

• Specified the organization's core Identity Management systems, from business and information-security requirements through to processes, interfaces and integrations
• Designed system processes, data flows and data structures, and guided a Java and JSP Web development team through implementation and production delivery

ProLink Identity Management Architects | Israel

• Owned the application-layer design and implementation of the Aveksa IAM and Identity Governance platform at Harel, Migdal, Phoenix and Amdocs
• Built business logic, workflows, approval processes, data mappings and synchronization processes, and the integrations to enterprise systems, databases and directory services

Varonis | Israel

• Specified and developed a core enterprise billing system on Microsoft SQL Server, Microsoft Access and VBA
• Turned business questions into SQL queries, reports and automations, working directly with finance and operations