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

● 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