SUMMARY:

• 7 years’ business Data analyst experiences in planning and forecasting and reporting.
• 10+ years experiences both in T - SQL and in PL-SQL.
• Strong analytical, problem solving and computer skills.
• Cross-functional experience in international manufacturers and trading company.
• Exceptional ability to quickly master new concepts.
• Capable of working in-group as well as independently with good communication skills (both in Chinese and in English).
• Willing to learn and share own experiences and knowledge with colleagues.
• Self-motivated, self-disciplined and completely dependable.

TECHNICAL SKILLS:

ERP system Knowledge: JDE, SAP MM, PP, SD modules; Retail Link, PowerCerv.

Software Knowledge: MS Office Suite (Expert in Access, Excel and Word), SQL server, Oracle Java, VB, ASP, JSP, XML, HTML, MiniTab, Agile.

Quality system standards: ISO 9000, ISO 9001, ISO14001.

Operating System Knowledge: windows XP/Vista/7 /8, Window server 2003, Unix, DOS, Novell-Netware.

PROFESSIONAL EXPERIENCE:

Global Inventory Data Analyst

Confidential, Houston, TX

Responsibilities:

• As only technical support from client, worked with a team of consultants to initialize min max setup for millions of items cross regions and product families;
• Designed and developed min max refresh project, saved millions of consultant fee;
• Study 12 statistical forecast methods in JDE; optimized process and parameters;
• Completed and improved inventory reserve (slow moving / E&O) project;
• Found and correct critical error for ATO project in JDE;
• Implement and improve demand planning and forecasting strategies, coordinator inventory control and purchasing process cross regions and business units.
• Design and develop metrics reports to measure and monitor region performance globally.
• Extract, manipulate, validate and upload data between various application and database.
• Build data models to analyze and forecast demand, calculate min max and re-order point.
• Work with internal and external auditors to improve business process.
• Integrate information from various environments and develop queries or reporting solutions to meet business needs.
• Monitor procedures in JDE and solve system error and support business operations.
• Build and test reports in Oracle OBIEE.
• Document business requirements for IT department and compose instructions and manuals to train end users.

Business Analyst

Confidential, Houston, TX

Responsibilities:

• Help to design and develop company’s own ERP system.
• Improve replenishment and delivery strategies. Monitor system health and take corrective action before problems occur.
• Work with oversea team for troubleshooting, capacity planning, and problem analysis and resolution. Train and support end users during new features implement.
• Monitor inventory levels and replenishment for five distribution centers national wide.
• Analyze history data to forecast high seasons and low seasons of different customers, such as Confidential.
• Work on container consolidation plans to ensure optimum inventory level, low freight cost, and compliance of company’s supplier relationship strategies.
• Create various reports to expeditor idle items selling and to help company developing cost-efficient and market-competitive strategy.
• Track PO system, solve discrepancies; lead first time order procedures and communicate with oversea teams to guarantee proper quality, accurate quantity and on-time delivery.

SAP Data Support Analyst

Confidential, Houston, TX

Responsibilities:

• Load and maintain material master, BOMs (Bills of material), vendors and pricing data in SAP and PowerCerv systems; conduct RFQs, set up info records, and quota arrangements in SAP.
• Create PRs, and POs based on MRP. Control ECN workflow; generate shortage report, production reports and quality reports daily.
• Troubleshoot and analyze SAP system problems. Use MS office and Visio to prepare documents for ISO 9001.
• Develop JAVA, Visual Basic programs to expedite PO flow and material planning, receiving and distribution.
• Install Operating system, email system, and other software for new employees.
• Be a help desk for more than 100 users. Develop a web site for procurement, direct ship and production departments.
• Maintain Oracle database & SQL Server for production Lines.
• Assist shop floor control system development.