Jonathan Laks Email & Phone Number

San Francisco, CA, US

San Francisco Bay Area

San Francisco Bay Area

Working with Square's Hardware Data Science and Data Engineering teams-Analyzing product telemetry data to assess Square's product performance, rebuilding and adapting legacy dashboards to comply with current performance metrics-Building, maintaining, and optimizing ETL pipelines for data-users across multiple teams-Ensuring high-standards of data quality.

San Francisco, California, United States

San Francisco, California, United States

• Data and Visualization Consultant supporting BI/Marketing/Executive teams
• Developed in Looker's LookML to build scalable and performant dashboards for end-users (utilizing complex Looker capabilities, such as Liquid language)
• Created an Executive Dashboard displaying funnel metrics with YoY comparison and dynamic date functions. Solved for executive and finance teams' requirements to create an institutive, easy-to-use, and informative.
• Created a scalable dashboard for A/B testing. Automated processes and reduced manual effort used by marketing teamsTechnologies: Snowflake, Looker, Liquid

San Francisco Bay Area

• Senior programmer, helped design project specifications, developed data pipelines, and implementedstatistical analyses to support a federal health agency’s healthcare models
• Analyzed quantitative research studies, created tables, graphs, and presentations to communicate results directly with non-technical clients
• Coached and mentored junior analysts by leading SAS programming training lessonsProject Experiences:
• Part D Modernization Model: developed data pipeline code for scalable quarterly reports with SQL/SAS. Aggregated drug, disease, and health enrollment data to analyze descriptive statistics and to predict reinsurance.
• Innovation Support Platform – Supported back-end data science applications in Databricks, validatedhealth metrics using PySpark, used for Looker dashboards accessed Medicare providers/beneficiaries

San Francisco Bay Area

San Francisco Bay Area

• Created R–scripts to automate data manipulation and cleaning processes
• Utilized conjoint regression analysis to calculate consumer demand prices with Sawtooth Software for class action cases
• Designed and analyzed market research surveys with survey experts for litigation reports on class action, false advertising, trademark/trade dress infringement cases

Round Rock, Texas

• Managed MSFT’s royalty violations; created macros to automate and enhance data reporting/analysis
• Led global team in investigating, identifying, and preventing MSFT violations, saving over $900,000 in violation costs during Q3 FY17
• Initiated geo-expansion efforts to expand team’s third-party software business; facilitated phone meetings with LATAM sales managers, discussed strategic relationship development, resulted in 8-month high attach rate.

Cambridge, MA

• Collaborated on client projects within tech industries on consumer mobility and healthcare; used pivot tables and modeling skills in Excel for global MDMs and other high-tech companies
• Researched and reported on the mobile device accessibility market for CEO’s expert witness report used in critical patent dispute case
• Extensively researched healthcare industry and technology trends to deliver visuals and strategic advice for a major device manufacturer

Boston

• Analyzed John Hancock’s economic surprise and wave indices, which track major economies and assesses their future growth based on economic indicators
• Compiled and formatted international economic metrics using VBA macros for a bi-monthly presentation
• Utilized Bloomberg and FactSet database terminals, functions and formulas to analyze various metrics

Shanghai City, China

• Created marketing report, based on online research and field work conducted in Mandarin, relating to Chinese smartphone market
• Developed presentation including worldwide/local trends and SWOT analyses, used by senior leaders for company-wide strategic planning

Bachelor Of Science (B.S.), Economics And Political Science/ Minor In Chinese, 3.92

Education record