San Diego, California, United States
Senior Data analyst with project management experience in Supply Chain Operation in Data Cloud Computing and Pharmaceutical/Manufacturing industry. Passionate in creating automation with scripting to increase efficiency within complex data workflow.
Project – RSC (Right Stage Customization) @ Johnson&Johnson • Led and drove the design of the RSC Data Quality Test implementation within Tableau to ensure end-user will have a smooth and effective experience with the dashboards. • Wrote Python scripts to reduce csv files sizes resulting in an increase of efficiency by 50%. • Created SQL scripts to automate manual processes for ad-hoc data analysis on various data interface such as Hue Editor, MDM, Qlik reports, and pgAdmin. • Created Excel templates by using VBA/SQL queries to reduce analytic processing time by 50% • Designed and implemented process flows working instructions for RSC sustainability team. • Performed RSC error log test scripts on JIRA for Business Simulation/User Acceptance Testing. • Hosted daily standup meeting internally with 5 team members to keep track of all tasks in progress and make sure the RAID log is up to date.
Project – Accenture @ Google • Automated several processes between Google Sheet and Gmail using Apps Script (JavaScript based) to track certain KPI metrics/targets for data visualization. • Designed and implemented an automated Product Life Cycle Checklist with Google Sheets (using App Scripts) to reduce the processing time of manual tasks by over 80%. • Reverse engineered a couple of Plx/DataStudio dashboards and script using SQL to fix errors and improve efficiency. • Led the implementation of Resource Planning Tool using App Scripts to help forecast resources needed for Data Center’s NPI programs and to improve headcount management process and workflow. • Created dashboards in Google Plx that measure various KPIs such as delay frequency, distribution of slip reasons, individual/aggregate impact by phase of delay on different programs. • Engaged managers across functional teams in collecting data needed for important metrics. • Managed the entire data pipeline from data collecting, data wrangling, data analyzing, to data visualization for business operation stakeholders. • Created real-time dashboards in Google Data Studio with swap rate comparison view to help MFG field engineers with their swap analysis and spare parts demand/supply view to help Optical Engineers with inventory replenishment decisions. • Maintained different SQL scripts and workflows to improve and optimize dashboard user experience for business stakeholders.
- Created a monthly forecast using Pivot Table for Juice Plus based on customer’s demand and the availability of over 100+ raw materials - Constantly monitoring ERP system (BaaN IV) to make sure the system is reflecting the most up-to-date information - Created a machine capacity model using Excel to help calculate OEE (Overall Equipment Effectiveness) - Interface with multiple departments throughout the company, Client Services, Manufacturing, Engineering, Quality, Warehouse/Shipping, R&D to obtain company goals for customer service and quality. - Ensures minimal excess inventory of bulk and finished goods through monitoring of yields and coordinating with Client Services for customer approval to ship when excess product is produced.
-Worked with overseas (China, Korea, and Europe) and domestic suppliers to ensure purchase orders were placed properly; -Coordinated a molding rebate program with suppliers for DuChateau to provide a more efficient service for customers to order moldings; -Assisted in setting up the Purchasing and Inventory module in NetSuite; -Hosted and led weekly demand planning meetings for Sales, Finance, and Supply Chain Dept. -Built a demand planning process with Excel prior to NETSTOCK implementation; -Worked with 3rd logistics providers such as BNSF to make sure the import/export shipments were in full compliance with customs regulations; -Executed the procurement plan within the approved finance budget; -Reviewed and monitored the inventory polices (e.g. ordering policy, price breaks, and transportation modes).
- Prepared and managed weekly production schedules based on sales forecasts and production capacity; - Monitored shop floor to ensure production lines were aligned with the planned schedules; - Analyzed customer demand and communicated with Sales Dept, on any capacity limitation; - Led a team of 20+ operators to execute operation and performance qualification protocols for a newly installed packaging line; - Forecasted material shortage and reserved raw materials by coordinating with Purchasing Dept.; - Conducted trainings on Production SOP’s for machine operators and in-process QA staff; - Collaborated with various departments (Warehouse, Purchasing, Regulatory Affairs, and Quality Assurance) to formulate material handling policy to meet cGMP / FDA regulations; - Reviewed Master Batch Records to detect deviation or abnormal trending from specification; - Investigated deviations by using System Incident / Out of Trend Reports and applied failure mode analysis to determine the root cause.