Esther Rothman Email & Phone Number

Jerusalem District, Israel

West Jerusalem, Jerusalem District, Israel

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

Jerusalem Area, Israel

Greater Boston Area

• 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.
• 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.
• 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.
• 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.

• 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.

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