Jun Yan Email & Phone Number

Michigan, United States

Designed and developed BI solution for customers from a variety of industries. Optimized data processing and created data visualization for internal and external users. Supported business operation by trouble shooting data issue, ETL issue and reporting issue.

Pennsylvania, United States

• Supported integrated business planning by data exaction, data importing, and data validation in RR and triangle analyzing data between SAP S4 and RR system.
• Developed reports to assist supply planning launch in Kinaxis RapidResponse, including data integration report, close loop report, KPI report, and scenario comparison report.
• Configured demand planning functionalities in Kinaxis RapidResponse to improve corporate demand planning forecast.

Michigan, United States

• Analyzed NA/AP SPP (Sales Product Program) data from legacy system, designed BI solution to ETL the data into SQL data warehouse. Developed reports/dashboard to support senior management meetings.
• Collaborated with regional business users and IT department to finalize Financial Planning Volume (FPV) into Global Capacity Requirement System (GCRS).
• Converted contribution margin data into GCRS and calculated corporate product allocation with contribution margin data to support Corporate Business Programs Review (BPR) meetings.
• Customized Kinaxis RepidResponse built-in analytics and data model to contribute to the successful launch of FPV project in RR platform.
• Statistically analyzed a large set of data and created data visualization, data flow and data automation to support region/global better business plan, what-if scenarios, profit forecasting and optimized corporate.