Junyi Chen Email & Phone Number

Troy, MI, US

Ann Arbor, Michigan, United States

• Create ad hoc reports using Power BI and Excel for other business silos that presents inventory and demand trend indicators in an understandable format as well as recommend next steps, supporting the growth of our.
• Add features to and bug fix a complex Microsoft Access database critical to the division's processes that supported our Material Resource Planning (MRP) system; preventing over and under-ordering, saving $2M+ weekly.
• Communicate across different business silos to gather supply chain data for analysis; also keeping stakeholders aware of real time changes in the ERP process and across 200,000 unique parts.
• Conduct backend architecture changes and UAT testing of critical Access, Excel, and Power Bi reports to support the data warehouse transition for multiple divisions from SAP Hana to Snowflake over one year, resulting.

Dallas/Fort Worth Area

• Mine data using advanced Excel tools to predict impact of new bankruptcy rules and present findings to support managerial decisions and create risk mitigation measures

Romulus, MI

• Create custom inventory reports for SAP based programs to increase workflow efficiency
• Forecast 20 weeks of inventory each week by manipulating Excel data

Troy, Michigan

• Revise a start-up business plan to build a university and reduced costs from $2 million to $1 million
• Collaborate with Board of Directors to manage project goals and milestones
• Generate financial forecast announcement to attract over $2,200,000 of angel funding

Warren

• Went above and beyond my job function to program an automated data input bot program that was 30% more efficient than a human and save weeks of data input time per year.
• Managed over 65000 items of inventory pricing through regular quality checks of legacy databases
• Interact with all departments of the company to understand their needs and process pricing requests/changes according to company policy

East Lansing, MI

• Consult for local Lansing small businesses to foster economic growth and community support
• Conduct SWOT, positioning, and industry analysis for a natural health company and a tourism company to recommend changes in organizational and marketing strategies
• Collaborate with team members to present research results and recommendations

• Created surveys of home product categories gain insights into the customer purchase path from 2,000 customers
• Analyzed and reported 100 points of survey data to effect strategic change in marketing and branding of 10 product categories in the Home business unit
• Collaborated with decision makers to create a strategy to mirror their in-store stock with their online stock and change product section ratios due to learning new customer behavior patterns from analysis
• Successfully presented actionable findings and recommendations to the president, vice president, and key decision makers of the department to improve marketing strategy and product selection.

East Lansing

• Supported the creation of businesses out of faculty inventions to create value in the university
• Develop market reports to help interim CEOs to understand and effectively communicate with oil industry insiders
• Translate technical details of the oil and gas industry into practical business knowledge and used it to help decision makers schedule future project milestones
• Conducted analysis in the food and oil industries to reduce time to market

Lansing, Michigan Area

• Collaborated with CEO of local music lifestyle start-up to create strategies, mission, and direction
• Researched music topics for social media engagement
• Worked 10 hours per week while carrying full course load

• Researched and proof-read Flagstar’s mortgage database
• Monitored accuracy and helped ensure excellent customer service
• Spearheaded research utilizing Flagstar Bank’s specialized database systems and provided feedback for system improvement implementation

Master Of Science - Ms, Business Analytics

Bachelor Of Arts - Ba, Logistics, Materials, And Supply Chain Management

Activities and Societies: Multicultural Business Students (Member), MSU Graphic Novels Club (Co-founder, Vice-President); Activities.

Certificate, Front End Web Development

Education record