We provide IT Staff Augmentation Services!

Global Inventory Data Analyst Resume

Houston, TX

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.

Hire Now