Operations Research Analyst

Apply knowledge of business data analysis and operations management to collect, review, purify, and analyze business data, and based on the data interpretation, formulate proper business operation models, regarding the logistics, supply chain, warehousing management, ecommerce, and other special service lines of the corporation.
Employ knowledge of Microsoft Excel, QuickBooks, Microsoft SQL Server (Package SQL), Activate, managerial economics and planning and business process management to collect, review and analyze data, prepare various financial reports on a routine basis, and draw charts and graphs to illustrate technical reports.
Utilize principles of finance, and knowledge of accounting for management, Microsoft Excel and Golden Budget System Software to forecast yearly budget by department, based on sales and expenses trend, make financial adjustments, and compare actuates with budget.
Establish a cash flow model to project next year cash activities and ensure cash reserve for the stable business operation.
Apply knowledge of corporate finance, investment analysis, and instance and financial risk management to evaluate the corporates new project in acquisition of new branch warehouse, develop project budget and calculate the costs in all aspects on new projects, as well as the expected profits to advise management with the best locations, method of acquisition, and future operation process of new branch; interpret budget analysis result and provide possible alternatives by using scenario analysis and provide corporate management with risk and strategy recommendations.
Employ knowledge of Amazon FBA SQL, logistics and operations management, supply chain management, and business process management to review and analyze inventory turn by product categories and vendor lead times to determine the optimal inventory on hand and reordering intervals.
Utilize knowledge of SAP customer database, statistic, data management, mathematics, data analytics using R, strategic management, organizational behavior and change management to collect and analyze data regarding climate changes, customer behavior, buying preferences, delivery condition, and other relevant factors to assist management in developing strategic and tactical marketing and financial plans.
Apply knowledge of Microsoft Visual Basic for Applications VBA, Power BI, database development and administration, analysis, modeling and design to construct financial models to evaluate potential growth opportunities by analyzing sales and demographic data using Power BI and VBA.
Employ knowledge of various software, such as Power BI, Microsoft Visual Basic for Application VBA and SAP, and information systems management to periodically generate and maintain individual reports for marketing team and managements reference, and also update performance dashboard by Power BI.

Need to travel to employers headquarters in Ontario, California about 5 to 6 times a year.
Masters degree in Information Systems, Information Technology, or Business Administration with focus on Information Systems is required.
Please copy and paste your resume in the email body (do not send attachments, we cannot open them) and email it to candidates at (link removed) with reference in the subject line.

Thank you.