Sandy Wang Email & Phone Number

San Jose, California, United States

. Response for analyzing work centers, available materials, and capacity availability.· In charge for timely creation of production orders to meet customer demand for assigned materials utilizing MRP and a detailed capacity plan for multiple work centers.· Responsible for consolidating customer orders, material status, procurement plan, process, capacity and lead time to mid/long term forecast as well as the operations plan.· Verifies component availability before releasing manufacturing orders to the production floor.· Bridge of manufacturing and sales/PM. Provides prelim shipment plan.· Expedites operations that delay schedules, then alters schedules to meet unforeseen conditions.· Continuously communicates and coordinates with various functional groups such as purchasing, production, PM, warehouse to develop the executable manufacturing plan.· Provides clear manufacturing plan and follows up for the progress.· Working knowledge of MRP and computerized inventory control system.

San Francisco Bay Area

▪ProMatch is a member-run career resource center for professionals who are seeking work in the greater San Francisco Bay Area.

San Jose, California, United States

Taiwan

▪Regularly doing financial data analysis using VBA for Excel, HTML, SQL Query for risk assessment. ▪Use the tools above to connect with database/ big data and generate risk exposure reports for executive and board members▪Reviewed / analyzed the incident reports and made strategies/ plans through risk assessment.▪Reviewed / analyzed risk exposure reports for compliance and fraud prevention.▪Constructed periodic surveys and inspections to comply with all regulatory committees.

Taipei City, Taiwan

▪Developed/designed Informatica mappings by translating the business requirements.▪Extensive SQL querying for Data Analysis and wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling. ▪Extracted business rule and implemented business logic to extract and load SQL server using SQL.▪Analyzed the source system and involved in designing the ETL data load.▪Developed/designed Informatica mappings by translating the business requirements.▪Extracted the data from Oracle, DB2, CSV and Flat files▪Consult with users, management, vendors, and technicians to assess computing needs and system requirements.▪Analyze information to determine, recommend, and plan the installation of a new system or modification of an existing system.▪Direct software programming and development of documentation.▪Developed solutions by preparing and evaluating alternative workflow options.▪Expanded systems with new features and structural components.▪Assisted with post-implementation troubleshooting of new applications and application upgrades.▪Tested newly installed programs and applications to validate operability.▪Integrated new technologies to meet area requirements.▪Trained end-users in best practices to minimize errors and protect key data.▪Troubleshot and resolved problems with programs and systems.▪Performed cost-benefit analysis on potential system upgrades to support purchase decisions.▪Performed data mapping and data logic for the trading project

Taipei City, Taiwan

▪Converting the mortgage project from AS400 RPG into the JAVA system, this system can help the bank dynamic design meet the market. ▪The development tools used are Java, Oracle DB.▪Managed test areas, systems test data, and methods prior to initiating Home Lending systems.▪Conducted project reviews based on organizational principles, policies, and practices.▪Assisted IT and information system planning, execution, and management to improve operational effectiveness.▪Developed and managed project plans while providing status updates to management.▪Troubleshot and resolved problems with programs and systems.