Ilan Lotvin Email & Phone Number

Israel

Oracle Eloqua – Email Marketing Operations | Carrefour Loyalty Club#Technical consultant and a subject matter expert in marketing automation projects.#Ownership of workflow logic design, implementation, optimization and monitoring#Manage process configuration (e.g. SFTP), oversee system performance metrics & data integrity validations.#Leveraged platform capabilities to structure and transform data, enabling advanced data-driven operations.#Cross-Team Collaboration, including marketing, IT and external providers, to meet marketing goals.Salesforce Marketing Cloud Implementation | Histadrut Leumit#Analyzed business processes; designed unsubscribe mechanisms, black dates, domain branding & warm-up.#Delivered technical training sessions to client teams.#Utilized SFMC Ampscript language for advanced dynamic processes and improved system functionality.#Participated in CRM integration planning, analyzing workflows for seamless synchronization.#Adapted landing pages using HTML and CSS during system migration, including features like data validation.#Designed personalized customer journeys, incorporating interactive emails to enhance engagement.Other Project:Oracle Responsys implementation and system consultationSalesforce Ecommerce

Israel

Lead the data analytics and marketing automation operations for clients in various industries’ (global B2B SAAS companies, Ecommerce, mobile, online publishers etc.).Being an instrumental part in development of marketing strategies (medium, touch-points, content, studio)

# Experienced Data analyst, develop & maintain reports to drive leadership decisions.# Experienced with various Data Analytics and BI tools:* Google Analytics* Power BI* Tableau# Experienced in writing advanced SQL queries utilizing window functions and multiple joins for data analysis and manipulation# Advanced proficiency with Marketing automation, CRM & API integration tools:* Eloqua, (Oracle)* Responsys (Oracle)* Hubspot* ActiveCampaign* InforU* Woodpecker* CoolaData (Medallia) - big data behavioral analytics platform for online web and mobile applications.* Engati - AI chatbots and engage in real time conversations** Software, configurations, such as (Data management )^^ Creating Properties^^ Integrations^^ Managing Users and teams^^ Objects and Custom Objects, Events^^ Tracking & Analytics - tracking Code/UTM, Attribution, Goals^^ Communication with Support helpdesk# Develop, optimize and Monitor campaign performance, define logic, triggers, UTM, audience segmentation based on user behavior, AB testings, and troubleshoot errors.# HTML - editing & Implementing personalization/dynamic content (text,/images).# Collaborating and maintaining solid relationships with cross-functional teams: marketing operations, studio, development, stakeholders, and top-level management.# Familiar with media management & Ad-tech tools(IDX, Ad manager).# Data transitions between CRM/MA tools- including updating/amending data types and data structures to adapt to new data rules

Cayman Islands

Developed Macro applications to automate and accelerate business processes such as:# Excel Add-ins# Excel to PDF Customized "Printer" Macro # Excel interaction with PDF/Word/PowerPoint application# UserForms and ActiveX controls# Financial modeling automation toolExperienced Tax Professional in Big 4 accounting firms, analyzing multi-million dollar companies’ financial reports to determine their compliance with U.S. tax authorities.* Analyzed financial reports* Led successfully a team of professionals to timely deliver tax returns and other projects of the firm's biggest multinational and multi-tier entity client* Designed the data infrastructure to maximize process efficiency of internal financial modeling and reports* Data Research (Bloomberg BNA, CCH etc)- Performed tax and coding research by implementation of advanced research tools (such as operators and punctuation)* Federal & State tax returns - review and preparation* Experience with international taxation such as PFICs, CFCs, and foreign information reporting (Forms 926, 8865, 8621, 5471, etc.)

Cayman Islands

Experienced US tax professional * Federal | state | International taxation* Hedge fund | Private equity | Funds of funds | corporations, etc.* Experienced Excel user | advanced Excel tools and formulas.

Data Analyst Program

Activities and Societies:6-month intensive online program designed to train talents to be successful Data Analysts. Acquired skills.

Cpa (Israel), Accounting And Business/Management