|
|
Juan Juarez 312.446.8551 |
|
|
PROFESSIONAL AND BUSINESS EXPERIENCE |
Functional and Technical Consulting experience working with clients to install, implement, and administer ERP software systems on multiple platforms in multiple technical environments. · Experience implementing full life cycle implementations of ERP systems including QAD’s MfgPro. · Experience providing business process analysis and recommend best practice cost savings solutions. · Experience managing and leading technical projects including project planning and technical supervision of project personnel. · Experience performing system design and programming per client requirements including specification and development of sub/legacy system interfaces, Progress source code modifications, additions, and forms / reports changes. · Experience designing and implementing data warehouses with web access. |
|
|
|
|
|
|
PROFESSIONAL AND BUSINESS HISTORY |
Logan Consulting - Project Manager: 2003 - Present
Ingersoll-Rand Corp.: 1998 – 2003 IT Manager: 2001 – 2003 Business Systems Analyst: 1998 - 2000
Nissan Forklift Corp. – Industrial Engineer: 1997 - 1998
Briskin Manufacturing Co. – Industrial Engineer: 1996 – 1997
Thomson Consumer Electronics – Competitive Product Analyst: 1995
|
|
|
|
B.S. – Industrial Engineering Purdue University – West Lafayette, Indiana
|
|
|
TECHNICAL CAPABILITIES (Software) |
QAD (MFG/Pro 8.x – eB2) Progress 4GL / RDBMS Oracle 8i, 9i, 10g RDBMS Procon Configurator GL Report Writer Web Server Technologies Unix Operating Systems Linux Operating Systems(Redhat/Fedora Core) Multiple Bar Code Printing Packages Merlin Magix (Phone System-PBX) Smart Connect (Call Center and Phone Monitoring Software) HTML Perl DBD/DBI PHP SQL Microsoft Suite Various mainframe systems and PC Business Software Packages Oracle 8i and 9i database |
|
|
TECHNICAL CAPABILITIES (Hardware) |
UNIX based systems (HP, IBM etc). Bar Code Devices PC’s using Windows Remote Controllers Various Networks Cisco Catalyst Switches Compaq Proliant AS/400 Personal Computers Modems |
|
|
|
|
|
|
APPLICATIONS |
General Ledger Purchasing / Receiving Accounts Receivable Sales Order Processing Accounts Payable Shipping Items Bill of Materials Routings Scheduling Work Orders Service and Support Configurations Export Requirements & Documentation
|
|
|
MAJOR CLIENT ENGAGEMENTS |
Autocar, Culligan, Gyrus, Ingersoll-Rand, Superior Essex |
|
|
|
|
|
|
PROFESSIONAL AND BUSINESS SKILLS |
Analysis Data Conversion Requirements Definition User Training Process Reengineering System Prototyping Procedure Development System Implementation Issue Management System Testing Technical Architecture & Design Report Design Technical & Program Documentation Disaster Planning
|
|
|
PROFESSIONAL AND BUSINESS ENGAGEMENTS |
Lead Technical Consultant at multiple manufacturing clients. Responsibilities include, Progress & MFG/Pro planning and installation. Planning and executing data conversion, planning disaster recovery procedures. Lead technical system re-engineering consultant, activities included designing, testing, programming, and documenting, MFG/Pro system changes and customizations. Designing and implementing subsystems that include advanced sales analysis, customer invoice deduction tracking, and variable sales order pricing. Provide Progress and MFG/Pro technical training. |
|
|
PROFESSIONAL AND BUSINESS ENGAGEMENTS (continued) |
Lead Functional Consultant at a major water and salt distributor with over 70 company owned dealer divisions. Defined and documented financial/business processes and transaction flows with a multi-entity configuration. Provided training and support for the management team, end user community and technical staff. Utilized: · Call Management · Installed Base Item tracking · Rental Contract Management including Deferred Income. · Sales Order · Inventory Management · Custom Delivery Module Also, developed custom progress applications integrated with QAD for this organization’s unique processes surrounding route and delivery management requirements. |
|
|
PROFESSIONAL AND BUSINESS ENGAGEMENTS (continued) |
Served as Project Manager for design and deployment of an order fulfillment process for a custom make-to-order automatic door manufacturer. · Implemented QAD’s MfgPro version 8.6 on an HP/UX platform. QAD modules included all Distribution, Manufacturing, and Financial Modules. · Procured and implemented a rules-based product configurator, TRW’s Procon. This configurator was integrated into MfgPro and served as the foundation linking front- and back-office activities. · This fulfillment process allowed for quick and accurate costing of products and also demonstrated configurations that were not possible to manufacture. Also, allowed customer service representatives and branch managers to track sales orders from receipt of order to shipment. |
|
|
|
Held position as an Information Technology Manager providing strategic leadership and technical direction. Concurrently was responsible for managing order entry, master scheduling, and material planning departments. Developed planning parts and bills of material providing material planners with a forecast needed to conduct business simulations. This program eliminated part shortages throughout the business. |
|
|
|
Designed and deployed a data warehouse with web access. Red Hat Linux 6.2 operating system with an Oracle database. Web development in the following languages: HTML, Perl DBD/DBI, PHP and SQL. |
|
|
|
Served as Project Manager to procure and install a Call Center environment for Customer Service and Technical Product Support personnel. · Coordinated efforts to upgrade phone system to Merlin Magix hardware and software platform. · Installed Smart Connect Call Center Environment. This allowed for call queuing and auto-attendants. This system was used to create performance metrics of telephone support personnel resulting in improved customer satisfaction.
|
|
