Project Manager Supply Chain

Isrrael Mendoza

*** * *****, ******, ** ***** 951-***-**** acy5j4@r.postjobfree.com

EXPERIENCE

South Bay International Systems Administrator Fontana, CA 5/16 - Current

Serve as DBA. SQL Server 2012 administration, optimization, T-SQL (create, modify and troubleshoot), capacity planning and performance monitoring. Responsible to develop and maintain databases or organization. Design the schemes, permissions and tables. Design automated systems for reporting.

Serve as ERP admin. Reviewed ERP software specifications and tested process configurations. Created end-user documentation and support for all customizations. Configure underlying DB per requirements. Assisted the transition from implementation to support/enhancement of ERP system related to all major business processes (sales to cash, procure to pay, inventory management, period end closing, bank reconciliation, etc.)

Serve as Wordpress admin. Monitored performance of website and conducted all backups, plugin activation, and SEO packages. Converted ideas and designs into technical specifications and implementations.

Served as project manager for all major EDI implementations with trading partners. Included but not limited to; collaboration, joint solution/application development, BPMN and AS-IS analysis.

Collaborated with Finance to develop better cash flow forecasting models. Developed executive dashboards in SSRS to drive business decisions.

James Hardie Building Products Supply Chain Coordinator Fontana, CA 05/15 –5/16

Utilized quantitative skills to create and analyze reports and build business tools. Accomplished by querying data by utilizing ERP software, sophistication with JDA TMS and a passion for data mining.

Power user in the supply chain department for IT to streamline SAP BO processes and SAP-JDA testing in sandbox environment.

Provided TMS/WMS support, guidance and mentorship for shipping managers and plant level associates. Streamlined communication with carriers to develop new strategies for transportation efficiency.

Maximized capacity utilization for LTL shipments, TL shipments, rail shipments and intermodal transport. Contributing to 1.5 million YOY in freight reduction costs based on price to market ratio.

Involved in pivotal EDI projects that measurement utilization and accuracy. This was based on orders processed with zero errors. Bench marked vs customer orders submitted via email or fax.

Effectively segmented which customers would fully adopt new EDI initiatives.

Snak King Demand Planning Intern City of Industry, CA 03/15 - 05/15

Maintained demand plan across facilities at the commodity level, analyzed reservation levels.

Developed and cross-referenced forecasts and improved accuracy through statistical analysis for the product portfolio. Developed proficiency with Cognos BI software.

Implemented data analysis in PIA reports and managed MRP systems.

EDUCATION

University of California Irvine, Irvine, CA

Embedded Systems Engineering; Current

University of California Riverside, Riverside, CA

Professional Project Management Certification, 2016

California State Polytechnic University, Pomona, CA

B.S Technology & Operations; 2015

Skills

Technical: Python, ERP (Sage, SAP),TSQL, SSIS, SSRS, RDBMs, EDI implementation, AS2, TCP/IP, FTP, API, WMS, Visio, SLDC, Project Analysis, ODBC, JavaScript, Wordpress, ASP.NET, MVC.

Soft Skills: Fluent in English and Spanish; interpersonal skills and excellent negotiating capacity. Understanding of accounting and financial systems. Strong organizational skills to communicate with multiple facets of business.

Contact this candidate