Sofía Wang Email & Phone Number

United States

New York, NY, US

Conduct comprehensive analyses of user behavior across diverse global regions, employing Python and SQL. Identify and communicate deviations or discrepancies in expected user conduct to stakeholders. Establish key performance indicators (KPIs) and set benchmarks, applying robust statistical methodologies. Convey insights to Product Managers and Leadership.

Ventura, CA, US

Collaborated closely with vital stakeholders including Finance, Sales, and Data Partnerships. Tracked product performance and distilled critical business needs. Crafted and implemented tools generating actionable insights and enhancing operational efficiency. Utilized SQL and Tableau to automate repetitive tasks, improving productivity. Presented key.

New York, NY, US

Perform predictive modeling to forecast "Home" claim losses based on 20+ years worth of dataImproved potential customer profiling using regression-based methodsDeveloped and own end-to-end data processes for Auto and Umbrella, and sustain data cost-efficiency for all other linesStreamlined Private Client Group P&L + risk data pipeline for all products.

New York, NY, US

Designed and implemented Excess Liability quote reportWrote R programs to automate reconciliation tasks and raise flags when anomalies are detectedDeveloped SQL procedures and functions to automate processes used to collect, analyze, shape and summarize data across different schemasAutomated end-to-end reporting process for the auto sector

New York, NY, US

Developed and maintained Oracle SQL procedures that aggregate data across all products, and coverages, totaling 80 million rowsMaintained, and debugged existing processes used to prepare indications, inforce, and quote conversion reports, and developed workarounds for ad hoc requests in times of scarce data

Menlo Park, California, US

• Website: www.pinpinman.com Lead the entire front-end development, maintenance, and improvement:
• Implementing the prototype with HTML, CSS, and AngularJS
• Collaborating with the back end using Loopback, and Node JS
• Sustain the responsiveness of the website in all devices
• Working with the engineering, design, and marketing team
• Improving the current version

La Jolla, California, US

• Website: www.myecfo.comSupport the Investment Team with Product Development and Operations
• Design prototypes using HTML5, Javascript, and Bootstrap and work with team to implement them live
• Manage investment dashboards and tools built on PHP, MYSQL, JQuery, and various Javascript Charting Libraries
• Manage projects with overseas developers and virtual assistants
• Perform basic research on investment products, such as ETFs and Mutual Funds
• Work with Quickbooks Online to reconcile profit / loss statements and balance sheet

Los Gatos, CA, US

• Conduct product test, to identify bugs. Collaborate with product team to escalate software anomalies
• Translate reports from Supply Chain department into user interface designs for product team
• Work with Product Manager and development team to design new product features and improve user experience
• Proactively suggested improvements that drive better calculations and efficiencies
• Interpret data for other teams; create user-friendly graphs and charts, based on raw data

Los Gatos, CA, US

• Identified optimization opportunities worth ~2-4% of clients’ transportation costs
• Compiled, modeled, and analyzed large sets of financial data. Prepared reports and recommendations based on analysis

San Jose, CA, US

• Source, filter, and coordinate ~50 industry experts to serve as “mentors” for portfolio companies
• Lead the organization of “demo days”, with an audience of ~150 people, including investors, community supporters, corporate sponsors and entrepreneurs
• Interface in a weekly basis with portfolio companies, to track feedback, progress, and operational priorities

Fremont, CA, US

• Worked with management team to brainstorm about guerilla marketing strategies
• Utilized SQL to input and organize data
• Responsible for evaluating and tracking month-to-month transactions

Bachelor’S Degree, Applied Mathematics

Education record