Jun Chai Email & Phone Number

West Covina, Ca, Us

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.• Develop and conduct training sessions and materials for end-users on software implementations.

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• Reduce manual workload leading to cost-savings equivalent to 7 full-time employees with implementation of EDI BlackBox• Create and update PowerBI reports showing production KPI that help identify recurring production issues• Develop and maintain standard operations procedure and user documentation for IT

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