Jason Ye Email & Phone Number

Capitalized on technical skills in formulating and launching the following:- Internal business analytical tool - Workforce Analytics Machine (WAM) for automating Affordable Care Act (ACA) monthly report creation.https://www.businesswire.com/news/home/20210428005916/en/Trusaic-Announces-Issuance-of-Two-U.S.-Patents-Covering-Its-Application-of-AI-Powered-Data-Processing-to-Workforce-Analytics– Self-serve business-to-business (B2B) product for clients to free e-file with Internal Revenue Service (IRS);– Data transformation tool for DC state filing as well as CA pay data reporting using Alteryx and Python.– 200 custom data cleansing recipes which enabled the Analyst team to achieve data cleansing and transformation by one click using Alteryx and R;– Freemium ACA penalty risk assessment excel report that increased sales conversion on ACA filing using Python; and– Freemium pay gap risk analysis PDF report, resulting in high sales conversation on pay parity product using Python

Los Angeles, California

- Developed R scripts to automate data cleaning process for around 150 ACA clients- Assisted with the development of web pages by using R Shiny.-Assisted with the development and maintenance of Alteryx workflow.- Perform timely and accurate data aggregation, consolidation and validation of sensitive information sets, including but not limited to: HR and employee census data, payroll data, time & attendance, leave of absence data, and employee health benefits data.- Interpret relevant legislation and regulations pertaining to the Affordable Care Act and Equal Pay Act. Consult clients on the complexities of these legislations to help mitigate risk and keep organizations in compliance

West Hollywood, California

• Evaluated laundry industry data, combined qualitative information, and composed well-structured advanced Excel graphics to prepare pitch books for prospective investors.• Identified opportunities for super value investments by forecasting revenue, cost, and ROI.• Determined customers’ preference by composing surveys and using Tableau to visualize data.

Shanghai City, China

• Used SQL to extract data from database and used Excel to analyze reoccurring data and calculations. Presented weekly report on behalf of intern team to senior manager. • Offered recommendations to the director by collecting and analyzing sales data from all the market departments in China. Used PowerBI to generate visualized report for the weekly team meetings.• Allocated monthly procurement for manufacturing in China by analyzing sales performance.

Shanghai City, China

● Audited accounting entries for Dacheng Poultry Co., Ltd by verifying account accuracy, performing 3-way matching to accomplish pre-IPO clearance.● Used accounting related knowledge, financial forecasting, and statistical methods, probability theory, to analyze operation result and predict future revenues and state of operation with team leader, improving the satisfaction of results by around 20%.

Shanghai City, China

● Applied EXCEL functions to collate dail company cost with zero error and prepared cost projections.● Used EXCEL Pivot Table to reorganize data, so large volumes data could be easily read, and aided in managerial decision making, improving working efficiency.

Master'S Degree, Applied Analytics, 3.482

Activities and Societies: Organizations: Member of Digital Innovation and Information Systems Club

Bachelor'S Degree, Accounting