Summary
Overview
Work History
Education
Skills
Timeline
Generic
Amanda Ma

Amanda Ma

Port Washington,NY

Summary

Knowledgeable Data Scientist with strong foundation in data analysis, and statistical modeling. Successfully developed predictive models and data-driven solutions to optimize business performance. Demonstrated proficiency in Python and SQL, leveraging data visualization tools to communicate insights effectively.

Overview

5
5
years of professional experience

Work History

Data Scientist

SY Collections Inc.
05.2024 - 02.2025
  • Defined custom KPIs and built 5 interactive, user-friendly dashboards in visualization tools (Superset & Looker Studio) to monitor and analyze sales and production trends; provided strategic analyses to business teams.
  • Integrated data from 4 disparate sources into the centralized data warehouse by developing and implementing ETL (Extract, Transform, Load) processes using Go scripting language and SQL queries.
  • Enabled real-time strategic analytics and monitoring for product sales and marketing campaigns through advanced MySQL and PostgreSQL queries to creatively aggregate and transform data from various sources and build data models.
  • Reduced errors and improving overall reporting reliability by ensuring data accuracy and integrity through continuous data validation, troubleshooting, and optimization of the data pipeline.

Production Manager

SY Collections Inc.
07.2023 - 04.2024
  • Conducted market research to assess new product trends and identified strategic procurement partnership opportunities to increase the profitability of popular products. Cut cost for a top-selling keepsakes product by 30% and added 3 new SKUs to the product category.
  • Collaborated with the design team to plan and execute product development cycles and assisted in evaluating materials, production technique, and feasibility for new product launches. Ensured smooth transition from prototype to mass production.
  • Managed bulk order reordering to maintain optimal inventory levels, preventing stockouts and overstock; coordinated with logistics and suppliers and monitored shipment schedules to align shipment timelines with Sales & Marketing to maximize sales opportunities.

Digital Marketing Analyst

Epoch Media Group
10.2021 - 03.2023
  • Mined client data analytics logics to enable business intelligence and created business dashboards from end-to-end on key metrics for the subscription team to enable timely reporting, feedback and operations anomalies monitoring.
  • Conducted in-depth email growth analysis and conducted A/B testing to increase conversion rate among 1 million unpaid subscribers; monitored email performance and adjusted campaign strategy based on key metrics.

Associate Manager

Verisk Financial, Argus Advisory (now part of Transunion)
09.2019 - 09.2021
  • Analyzed large datasets to extract insights for 5 major U.S. and Canadian issuers on their credit card and deposits portfolio performances and compared KPIs including profit, growth, and risk performance across all product lines and segments against the industry benchmark to provide strategic recommendations to the management team on the client side.
  • Conducted extensive portfolio analysis to support one of the top regional banks’ post-merger and acquisition evaluation to help client understand the acquired bank’s profitability and revenue drivers.

Associate

Verisk Financial, Argus Advisory (now part of Transunion)
04.2019 - 09.2021
  • Supported 4 weekly refreshes and quarterly client portfolio studies using Excel and PowerPoint. Provided summaries on key findings and delivered insights to the client via professional email writing.
  • Conducted bespoke analyses (cohort analysis, customer segmentation, and profiling) by writing advanced custom SQL queries to extract, analyze and visualize data insights to help client identify potential cross-sell segments for their upcoming marketing campaigns with a reach of millions of members.

Supply Chain Operations Analyst

Columbia Sportswear Company
10.2017 - 08.2018
  • Monitored order flow for 3000+ online orders daily to reduce hold-ups by tracking key metrics such as order fulfillment rate and on-time delivery using SQL query and advanced Excel functions.
  • Managed 80+ outlet retail accounts in SAP and acted as liaison across multiple departments to facilitate accurate and timely bulk ordering and ensure smooth supply chain operations in support of sales growth.

Education

Master of Science - Commerce, Business Analytics Concentration

University of Virginia, McIntire School of Commerce
Charlottesville, VA
01.2019

Bachelor of Science - Psychology

Linfield College
McMinnville, OR
01.2017

Skills

  • Statistical analysis
  • SQL databases (SQL Server, MySQL, Postgresql)
  • Anomaly detection
  • Data mining
  • Data wrangling
  • Data visualization (Looker Studio, Tableau, Power BI, Superset)
  • Data warehousing

Timeline

Data Scientist

SY Collections Inc.
05.2024 - 02.2025

Production Manager

SY Collections Inc.
07.2023 - 04.2024

Digital Marketing Analyst

Epoch Media Group
10.2021 - 03.2023

Associate Manager

Verisk Financial, Argus Advisory (now part of Transunion)
09.2019 - 09.2021

Associate

Verisk Financial, Argus Advisory (now part of Transunion)
04.2019 - 09.2021

Supply Chain Operations Analyst

Columbia Sportswear Company
10.2017 - 08.2018

Bachelor of Science - Psychology

Linfield College

Master of Science - Commerce, Business Analytics Concentration

University of Virginia, McIntire School of Commerce

Similar Profiles

CREATE PROFILE