Jun Chai Email & Phone Number

West Covina, CA, US

Brea, CA, US

Ontario, California, US

• Streamline Active Directory update by integrating Paycom Employee ID to align user accounts in AD and created a more efficient, periodic schedule update process cutting manual update time by 50%.
• Elicit requirements with decision makers, systems owners, and internal users to define business/system requirements, and to help resolve systems issues.
• Collaborate with the PMO Director on the development of a centralized project management system by leveraging Smartsheet to aggregate IT projects into schedules, risks, issues, and budgets.
• Initialize IT vendor management software centralizes vendor information in Smartsheet which streamlines communication and reporting by creating system notifications for upcoming payments and contract deadlines.
• Extract, Transform and load SQL data with DAX and Power Query to create custom dashboards in PowerBI
• Design and implement automated workflows to parse and store new hire contracts in a SharePoint list, seamlessly integrated with Power Apps for user-friendly updates and access.

Monrovia, CA, US

• Conduct requirements gathering and project scoping sessions with related business users, and senior level Analysts and executives to discover and define business reporting needs.
• Use MySQL queries to analyze data and create reports on work order and sales order information
• Evaluate IT KPI to monitor department weekly drive-by and help desk ticket completion
• Lead end-to-end development and deployment of projects by creating project roadmaps and milestones
• Participate in Continuous Improvement Kaizen event to improve and document internal duplication order issues by creating new system flags that reduced duplicate orders by 50%
• Work closely with Senior managers and development team on EDI implementation for HomeDepot by grooming product backlog based on feedback

Inglewood, California, US

• Analyzing data across buyer behavior base on location to set product trend reports base on stores and location
• Evaluate promotion methods with A/B testing to compare effectiveness of strategies design and offers
• closely with CEO during launch of company’s child brand with more focus to online businesses such as DoorDash, UberEats and more
• Visit store opening events to interact with stores and store managers as well as employees to set up event details
• Perform daily QA of brand presence and marketing materials of Whole Foods locations across SoCal