TECHNICAL SKILLS:

Special skills/software : JobScope, SAP, Infor M3, Microsoft Office Suite, Tableau, SPSS, Minitab, Matlab, Mathcad, AutoCad, Lingo, Arena, PC - Miler, Crystal Ball, HP-UX, Crystal Reports, SQL, Coupa

Hardware: PC, HP9000, HP3000

PROFESSIONAL EXPERIENCE:

Confidential, Kennesaw, GA

Project manager/Supply chain analyst

Responsibilities:

• Configured M3 Maintenance, manufacturing, purchasing and accounting modules.
• Held meetings with stakeholders to discuss M3 projects, modifications and reporting.
• Coordinated developer recourses for needed enahncements to the M3 system.
• Assisted with mass data loads into M3(suppliers, items, etc.)
• Mentored junior business analysts.
• Trained the AP and purchasing personnel on how to create requisitions and purchase orders, receive goods, and process invoices; as well as troubleshooting invoicing issues when they arose.
• Created Ad - Hoc reports within M3 as well as SQL reports via M3 database utilizing a query tool.
• Created a branch score-card report for the VP, CFO and CIO that gathered purchasing metrics on how each branch was performing and if they were adhering to purchasing policy and guidelines.
• Provided 3rd tier support for all M3 issues that came through our support hotline.
• Created project plans and testing scripts for M3 development work.
• Created detailed documentation outlining M3 configuration and process flows.
• Provided support, troubleshooting and configuration for M3 IPA purchase order approval process.

Confidential, Westlake Village, CA

ERP consultant

Responsibilities:

• Provided support for the Coupa and Ariba e-procurement application in the US, CN and Latin America.
• Administered Perforce document storage and change control software to retrieve documents and manage document versions.
• Worked with our KPMG partners in design and implementation strategies.
• Configured Coupa according to business requirements.
• Performed daily JDE and Coupa administration duties.
• Managed data integrations from Coupa to JDE.
• Performed extensive analysis and troubleshooting of invoicing, purchasing, receiving, integration and CXML issues.
• Utilized R statistical software to extract purchasing related data, clean the data and then perform statistical analysis of the data; gathered statistics of purchase orders, invoices, receipts and supplier metrics for decision making.
• Conducted extensive training sessions for Coupa application users via Webex and on location.
• Performed reporting duties through the use of coupa reporting and SQL queries to extract purchasing related data; created accrual reports for accounts payable.
• Configured vendors such as Staples and Grainger for CXML in order to process purchase requisitions through punch-out websites.
• Managed vendor contracts.
• Acted as the lead and provided guidance for junior Coupa administrators.
• Managed all Coupa upgrades; and created test scripts to determine success or failure of the upgrade process.
• Collaborated with Coupa support to report and apply fixes to Coupa instabilities.

Confidential, CA

ERP/Data consultant

Responsibilities:

• Configured and managed JobScope ERP system for a make-to-order/make-to-stock design and manufacturing environment.
• Oversaw daily supply chain operations.
• Validated the BOM cost roll-up to ensure that all costs associated to material and outside processing were captured in order to reflect the true cost of manufacturing a single production unit.
• Made modifications to JobScope Crystal Reports according to company guidelines and user requirements.
• Created complex T-SQL scripts in order to extract data from the database and import into Crystal Reports in order to create reports for upper management; as well as T-SQL scripts to mass upload data and mass update data in the database.
• Created metrics on supplier performance: On-time delivery, paperwork, receiving inspection, detailed inspection.
• Worked with engineering to establish guidelines for the ECO process and implemented engineering change control in JobScope.
• Created monthly financial reports with data extracted from JOBSCOPE and analyzed in Tableau and/or Crystal Reports.
• Utilized Tableau to create dashboard metrics for the purchasing and quality departments.
• Solved all ERP related issues pertaining to purchasing, manufacturing, production, quality, and finance.
• Performed database administration duties as it pertained to MSSQL Server 2014.
• Setup database alerts, auditing and backups.
• Trained operations staff on all modules of the JobScope ERP system.
• Researched and analyzed different ways to improve efficiency in JobScope with implementation.
• Worked in tandem with the engineering and document control staff to make sure parts lists (BOM) were entered correctly into JobScope.
• Worked with the inventory department to perform cycle counting of all ASC inventory and made adjustments accordingly in JobScope.
• Met with end-users to determine their needs and provide solutions as it related to ERP.
• Created process flowcharts and SOP documentation.

Confidential, La palma, CA

M3 supply chain business analyst

Responsibilities:

• Supported Royal 4(ERP system) for all users across multiple divisions both on-site and remotely.
• Responsible for approving access to various Royal 4 functionalities and SharePoint.
• Liaison between end-users and technology department to analyze Royal4 issues, develop a strategy and solution plan, and have the technical staff perform the implementation.
• Assisted in the implementation of Lawson M3 ERP system that eventually would replace Royal 4 at all divisions.
• Trained end-users in the procurement, quality assurance, and sales modules of Lawson M3.
• Created training documentation and test cases for the Lawson M3 ERP system.
• Traveled to various Confidential facilities to provide on-site support and troubleshooting as it related to the new M3 ERP system.
• Managed the product support portal and 8130s (FAA documents) for all items returned due to various quality issues.
• Created business reports in Excel and Crystal Reports for upper management.
• Manipulated raw data from Royal 4 in Excel pivot tables to provide analysis from different perspectives.
• Created a maintenance trouble ticketing system in SharePoint for the facilities department.
• Worked with the production scheduling department to develop mathematical linear models to provide production line scheduling scenarios.
• Solved complex issues related to work orders, sales orders and purchase orders and the interaction among the three.
• Worked with the purchasing staff to develop strategies to improve vendor relations and gather vendor metrics for analysis; as well as provide various methods to reduce purchasing expenditures.
• Managed engineering drawing and parts list revision and access control; as well as troubleshooting issues related to engineering parts lists.

Confidential, CA

Supply chain analyst/Purchasing analyst

Responsibilities:

• Project lead for establishing GSA certification in order to sell products to the Federal government.
• Responsible for determining effective pricing in order to maximize profit and competitiveness for Mission Linen.
• Established policies and guidelines for procurement and sales staff to follow.
• Developed a “Purchasing” SharePoint web presence for our internal staff.
• Created a fully searchable Microsoft Access vendor information database for account representatives to gather current vendor and pricing information.
• Optimized truck routing schedules between various plant locations to reduce operating costs.
• Utilized SAP for the creation of purchase requisitions, purchase orders and inventory analysis.
• Negotiated best pricing with vendors in order to achieve an equitable arrangement for both parties.
• Wrote business letters for upper management.
• Performed contract review and modification. Added addendums and amendments as required.
• Performed detailed analysis of prospective vendors based on financial ratios and quality characteristics.
• Trained new procurement staff on SAP.
• Utilized the Internet as a resource to scout for new products and to research prospective vendors.
• Conducted new employee orientation training as it applied to purchasing operations.
• Assisted account representatives with their pursuit of county bids.
• Utilized my programming background along with ABAP to update product pricing information in SAP.
• Created Excel macro and VBA scripts to automate repetitive functions.
• Ensured purchase requisitions were processed efficiently and accurately.
• Researched and responded to both supplier and customer complaints as necessary.
• Utilized Excel solver in accordance with exponential smooth methods to minimize the errors associated with regression equations by changing alpha, beta and gamma values as applied to inventory and sales analysis.
• Utilized data analysis software to project inventory demand utilizing historical data.
• Set up new vendor accounts in SAP to coordinate payment through purchase orders.
• Created RFPs in order to help choose the most appropriate vendors for their core goods.
• Installed, setup and utilized Google Analytics to gather statistics on how customers were utilizing the various areas of the company web site and web store so as to make improvements to marketing efforts and increase revenue.
• Analyzed the quality of garments to ensure a product that would survive an industrial laundry process for the rental side of the business.
• Ensured that Mission Linen’s laundry processing plants received parts and goods within their respective lead times so as to not slow or halt production.
• Prepared sales territory performance of Mission Linen account representatives using multiple linear regression to determine which sales people were underperforming according to benchmarks.
• Helped to nurture a strategic alliance between one of our core vendors to supply a major long term client with high volume purchases of medical scrubs for their medical center staff. Freight, lead time, quality, service, and price were the leading factors.
• Prepared PowerPoint presentations to explain my data analysis results to upper management, as well as offering a Q&A brainstorming session for areas such as freight cost reduction and stocking levels.
• Created a supplier questionnaire with pertinent questions concerning supplier operations and practices, in which the results were stored in an online supplier profile database.

Confidential, Rosemead, CA

Supply chain analyst internship

Responsibilities:

• Processed purchase requisitions via SAP for the creation of purchase orders.
• Extracted daily purchase requisition data from SAP, created an excel report which was emailed to the buying staff for purchase requisition processing.
• Created complex SQL statements to extract data from SAP for reporting purposes.
• Reviewed contracts and agreements for appropriate language and made changes as necessary.
• Worked with vendors to secure pricing agreements and certificates of insurance.
• Researched and help to solve problems regarding purchase requisitions and purchase orders.
• Acted as a medium between SCE buyers and vendors to ensure the correct equipment was ordered.
• Tracked supplier on-time delivery statistics to determine the level of risk associated with delivery objectives.
• Ensured that departments followed company policy when requesting equipment and supplies.
• Created a database to store certificates of insurance to be used by procurement agents as part of the purchase order process.
• Responsible for negotiating contract terms and conditions with suppliers for goods and services.
• Performed QDA (quantity discount analysis) and fixed/variable cost analysis to determine the reasonableness of quantity discounts as well as cost breakdown in order to work with the vendor in lowering prices based on my analysis.
• Researched financial and operational viability of prospective vendors.
• Created financial spreadsheets in excel.
• Utilized Crystal Reports to create attractive reports from SAP, Excel and Access Databases.

Confidential

Independent Technical Consultant/Purchasing Analyst

Responsibilities:

• Traveled to various client sites around the country to provide technical support and training.
• Provided 24/7 technical support for clients as it applied to email and network related issues.
• Integral part of design team involved in converting Pac-Bell's SMTP email platform to Confidential ’ SIMS platform.
• Performed full scale installations of high-end HP and SUN servers for various clients throughout the U.S.
• Analyzed system performance and made recommendations.
• Oracle database installation, setup, and performance tuning.
• Performed project management duties to ensure that goals were met in a specified time frame.
• System and network administration on large-scale HP and Sun servers.
• Developed a wide-scale OS upgrade for 1000+ HP-UX client workstations.
• Created disaster recovery plans and conducted disaster recovery drills.
• Created technical documentation and drawings to fully explain processes and procedures.
• Negotiated best pricing for network hardware and software for clients.
• Collaborated with upper management and technical staff to determine requirements for server and network expansion for efficient end-user functionality.
• Worked with vendors to secure significant cost savings on server, networking and backup hardware while still meeting quality objectives and functionality.