Esther Rothman

Esther rothman

bookmark on deepenrich
location of Esther RothmanJerusalem District, Israel
Phone number of Esther Rothman+91 xxxx xxxxx
Followers of Esther Rothman597 followers
  • Timeline

    Oct 2002 - Jun 2004

    Outside Sales Executive

    Mansfield Paper Company
    Sept 2009 - Feb 2010

    Inside Account Manager

    WhipTail Technologies, Inc.
    Mar 2010 - Dec 2011

    Database Manager

    Orthodox Union
    Jan 2012 - Jul 2018

    Technical Consultant, Technical Account Lead

    QuickPivot
    Current Company
    Jan 2019 - now

    BI & Analytics Manager

    Freightos
    West Jerusalem, Jerusalem District, Israel
  • About me

    BI & Data Analytics Manager at Freightos

  • Education

    • Hampshire college

      1995 - 1999
      Bachelor of arts physics & choreography
  • Experience

    • Mansfield paper company

      Oct 2002 - Jun 2004
      Outside sales executive
    • Whiptail technologies, inc.

      Sept 2009 - Feb 2010
      Inside account manager

      ● Multiplied inside sales quarterly pipeline by 350%.● Increased website traffic by 250% by marketing rebranding and redesign. ● Salesforce CRM administration

    • Orthodox union

      Mar 2010 - Dec 2011
      Database manager

      ● Restored stalled CRM implementation to on-time, on-target venture as project and technology lead. ● Renovated presentation of data analysis through data visualization using pivot tables/charts; dashboards. ● Converted a reactive ad-hoc reporting scenario to a proactive, automated process. ● Achieved significant improvements in interdepartmental data congruency by developing data auditing process and establishing high goals for data accuracy.● Acted as CRM administrator and SME for data cleansing, QA enhancements, issue resolution, user security/set-up; communicating and tracking tickets on JIRA. ● Transformed unskilled new hires into proficient technicians of CRM and MS Office. Show less

    • Quickpivot

      Jan 2012 - Jul 2018
      Technical consultant, technical account lead

      ● Accounts Supportedo Merrill Lynch, Largest Brokerage Worldwideo BottomLine Inc., Publisher of Wellness and Wealth Adviceo WEX Inc., Provider of Payment Processing and Information Management Services to Commercial and Government Vehicle Fleet Industry. ● Optimized, debugged and maintained production database and processes. On call production support, monitor/resolve issues with daily and weekend cycle, file load and data aggregation, data deduplication/merge-purge/address verification, multi-channel campaign generation, marketing attribute calculation, API integration, task scheduling. Database performance tuning, file archival, and version control. ● Developed, maintained, and tuned BI/ETL for >15 sources and destinations. ● Designed and implemented complex database processes such as multi-channel campaign/response and client management streams spanning multiple servers, databases, SFTP, and API integrations using several technologies and languages (SQL, SSIS, SSRS, batch, etc.). Support integration with Siebel, Eloqua, Salesforce, and variety of DM vendors. Constructed and executed thorough test plans and result reporting. ● Presented actionable metrics/KPIs to business partners via analysis of large data sets. Discovered gaps, trends, inconsistencies and presented design solutions.● Created and automated reporting and file extracts for affiliate vendors (SAS, list rentals, suppressions) or internal auditing.● Documented data architecture for complex information systems. Built training for faster onboarding and issue resolution. ● Provided technical and analytical support as wells as mentorship to business analysts and developers. Assisted clients in refinement of project goals and requirements.● Managed projects, defined internal business processes, and assigned cases for teams up to 10 with throughput of 100-200 cases/month. ● Collaborated with offshore teams. Show less

    • Freightos

      Jan 2019 - now

      Manages team of 5 data analysts and engineers supporting strategic analysis and data infrastructure for multiple business units and departments within the corporation.

      • BI & Analytics Manager

        Jan 2022 - now
      • BI & Data Analytics Team Lead

        Jan 2021 - Jan 2022
      • Sr. BI Engineer

        Mar 2020 - Jan 2021
      • BI Engineer

        Jan 2019 - Sept 2020
  • Licenses & Certifications

    • Code of conduct essentials v4.1

      Traliant
      Jun 2023
    • Preventing discrimination & harassment: global manager v4.01

      Traliant
      Sept 2023