Ryan X. Email & Phone Number

Los Angeles, Ca, Us

Ventura, Ca, Us

Directly support C-suite leadership decision making and strategizing meetingsWork in cloud based databases such as snowflakes and AWS to streamline data processing

Ventura, Ca, Us

- Collaborated closely with R&D senior engineering leadership to enhance organizational productivity, implementing sophisticated tracking mechanisms utilizing JIRA API. These efforts facilitated detailed insights into organizational workload, delivery timelines, and individual performance, leading to impactful one-on-one discussions in management. Contributed significantly to organizational growth, resulting in a substantial increase of 300 headcounts in 2024.- Fostered strategic partnerships with Engineering, Product, and Data Science teams to gain deep insights into internal AI usage, feature effectiveness, and campaign performance.- Crafted customized ad-hoc reports tailored to address critical business inquiries, providing actionable insights to various departments. These insights proved instrumental in overcoming advertising spend barriers for external customers.- Cultivated strong relationships with data partnership and product teams to facilitate seamless onboarding of new measurement products, platform-wide performance tracking, and strategic planning to achieve annual company data revenue targets.- Implemented optimization strategies for SQL queries, resulting in a remarkable 2X reduction in data refresh time for datasets exceeding 100 million rows.- Demonstrated ownership over end-to-end data ETL pipelines within the cloud-based solution Databricks, streamlining data warehousing processes in dynamic data engineering environments.

Tustin, Ca, Us

- Large data ETL using Power Query and SQL.- Use R to calculate KPIs and ultimately automate metric reports for further use.- Troubleshoot data related technical problems and generate ad-hoc reports to detect fraud/waste activities.- Work closely with Database team to establish data connections between both team.- Utilize Power BI to extract and visualize datasets from database.- Streamline current workflow and integrate reporting procedures.

Long Beach, California, Us

Long Beach, California, Us

Help to build the layout of 12000+ active businesses in the city of Long Beach.Build classification models to target small businesses who may need loans during COVID-19.Perform text mining on ReopenLB survey data on 5000+ responses to obtain residents’ opinions in reopening business.Use MS PowerBI to analyze “days to issue” in business license for all categories and help to upgrade the process.Map $4.55 million Small Business Grants awarded distribution in Tableau over Long Beach area and Census tract area in order to measure performance KPI for distributing to high need areas.

Pico Rivera, California, Us

Constructed sales facing reportsAutomated account reportsVisualized Sales and Promotion numbers Created promotion templates sheet and MAP price break tracking sheet

City Of Industry, California, Us

Compiled E-commerce data and generated sales reports.Used Excel VBA to automate data validations, product mapping and pivot tables.Visualized internal data with extracted external data to show sales distribution and customers purchase behaviors.Built statistical data model and provided detailed analysis on variables.Forecasted sales revenue with models and analyzed ads campaign performances.

Us

Helped one student at Foothill College with his statistic class on a weekly basis for the whole quarter.

Bachelor Of Science - Bs, Statistics

Master Of Science - Ms, Applied Statistics