Global Inventory Data Analyst Resume Houston, TX - Hire IT People

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.