Experience

Shannon Precision Fastener, LLC

• United States
• Automotive
• 1 - 100 Employee

• IT Manager

  • May 2017 - Present

  800 E. 14 Mile Road, Madison Hts, MI 48071



Computer Resource Consultants

• Owner

  • Jun 1996 - Present

  37541 Juniper Dr., Sterling Heights, MI Owner and operator of independent consulting firm. Systems analysis, design and coding for various organizations.



Martinrea Hot Stamping

• CMS/iSeries Consultant (Contract)

  • Jun 2013 - Present

  19200 Glendale, Detroit MI • Project Lead on MARS (Martinrea Automated Reporting System) rollout - coordinating integration of production PLC's, CMS, SQL Server and Touchscreen applications to automate production reporting and labeling, scrap labeling and inspection labeling • Project Lead on Infrastructure Buildout - coordinating specfications, bidding, project costing and management of infrastructure buildout at both original Detroit facility and new Warren facility • Implemented Role Based CMS/Solarsoft… Show more • Project Lead on MARS (Martinrea Automated Reporting System) rollout - coordinating integration of production PLC's, CMS, SQL Server and Touchscreen applications to automate production reporting and labeling, scrap labeling and inspection labeling • Project Lead on Infrastructure Buildout - coordinating specfications, bidding, project costing and management of infrastructure buildout at both original Detroit facility and new Warren facility • Implemented Role Based CMS/Solarsoft security • Implemented Scan To/From Quality Hold Stock Locations in CMS/Solarsoft at 2 physical locations • Wrote various utilities, user screens, report extracts, data management routines for CMS/Solarsoft database • Apply iSeries/AS400 system updates and PTFs • Document processes and training for Production Reporting, Scan to Quality Hold, Split and Combine labels. • Streamline nightly iSeries/AS400 backup and verification reporting Show less



Infoview Systems Inc.

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Application Development (Contract)

  • Nov 2007 - Present

  9424 Newburgh Road, Livonia, MI • Project Lead on numerous Waste Management Cases projects - custom workflow application for Customer Service, Dispatch, Accounting and Management. • Developed various API and in-house utilities for email and distribution list management from RPG applications. • Developed menu, application and screen control platform for securing custom applications. • Developed Esheatment processing program to run across multiple LPARs, automatically generate and post GL transactions and balancing… Show more • Project Lead on numerous Waste Management Cases projects - custom workflow application for Customer Service, Dispatch, Accounting and Management. • Developed various API and in-house utilities for email and distribution list management from RPG applications. • Developed menu, application and screen control platform for securing custom applications. • Developed Esheatment processing program to run across multiple LPARs, automatically generate and post GL transactions and balancing reports. • Developed FTP interface platform for use in multiple RPG applications. Show less



Export Corporation

• Application and Technical Support (Contract)

  • Sep 2004 - Present

  6060 Whitmore Lake Road, Brighton MI • Consolidated quoteing information from multiple customers to single Access DB. • Built customer release history tracking application, including reporting and review options. • XML order import program. • Update custom CMS programs for Kan Ban reporting • Utility program to generate report from CMS pending updates against customized source • Apply CMS system updates, including review and update of customized programs • Custom software development as needed



Shannon Precision Fasteners

• Application and Technical Support (Contract)

  • Jun 2011 - Present

  31600 Stephenson Highway, Madison Heights, MI • Technical and Application support, as needed.



Acument Global Technologies - North America

• United States
• Motor Vehicle Manufacturing
• 500 - 600 Employee

• Application Development (Contract)

  • Mar 2000 - Oct 2007

  840 West Long Lake, Troy, MI • Managed AS/400 Application Group for two years, including hiring/firing up to 6 programmers. • Designed bulk inventory tracking system, including interfaces to QAD/MFG Pro, custom purchase order system, fax/email to outside processors. • Consolidated multiple Purchase Order systems to single system. • Created Requisition Ordering system with email approval notification and interface with Purchase Order system. • Added interfaces between Receiving, Automotive Releasing, EDI and… Show more • Managed AS/400 Application Group for two years, including hiring/firing up to 6 programmers. • Designed bulk inventory tracking system, including interfaces to QAD/MFG Pro, custom purchase order system, fax/email to outside processors. • Consolidated multiple Purchase Order systems to single system. • Created Requisition Ordering system with email approval notification and interface with Purchase Order system. • Added interfaces between Receiving, Automotive Releasing, EDI and PO systems. • Created Backup Warehouse application in MS Access, including automated FTP transfer of AS/400 data to backup PCs in remote warehouse locations. • Installed and trained users in my Source Change Mangement system utilities. • Multiple programmer tools, including .CSV format report generator (output MS Excel readable spool file or physical file) • Multiple system tools using IBM APIs including System Monitoring, Job Schedule Downloads, Security Reports Show less



Davenport University

• Higher Education
• 700 & Above Employee

• Adjunct Professor

  • Sep 2000 - Jun 2002

  4801 Oakman Blvd, Dearborn, MI • CIS301, CIS302, CIS303 – RPG/400 Programming • Three semester class in RPG/400 programming, taking students through RPG cycle, structured coding techniques, interactive and batch programming • CIS487, CIS488, CIS499 – Systems Analysis and Design •Three semester class in how to analyze, define, design and manage a Systems Design project.



Vision Information Services

• Application Development (Contract)

  • Jun 1997 - Mar 2000

  302 S. Main, Royal Oak, MI • Project Lead for warehouse separation project. • Technical Lead for Y2K project. • Implemented biweekly Tech Briefings to review technical aspects of current software. • Designed, coded and implemented shipping package tracking system, integrating with RPS through EDI. • Created numerous API programs and modules for object analysis and synchronization across multiple AS/400’s.



City Management Corporation

• Application Development (Contract)

  • Jun 1996 - Dec 1997

  4300 W. Lafayette, Detroit, MI • Designed, coded and implemented hazardous waste tracking and disposal modules. • Converted S/36 databases and programs to integrate with JD Edwards financial packages. • Analysis of two Year 2000 conversion projects for older software.



North Oakland Medical Centers

• Application Development (Contract)

  • Jun 1996 - Dec 1996

  461 West Huron, Pontiac, MI • Designed, coded and implemented hospital budget system on PC using dBase III+.

• Senior Systems Analyst

  • Mar 1995 - Jun 1996

  461 West Huron, Pontiac, MI Responsible for analyzing and integrating complex systems across multiple platforms including Windows, Netware, AIX, OS/400 and VSE. Designing and writing programs in Cobol, RPG/400, Transact SQL, DOS Batch and O/S2 Batch.



Kmart

• United States
• Retail
• 700 & Above Employee

• Programmer Analyst III

  • Sep 1993 - Mar 1995

  3600 West Big Beaver Road, Troy, MI Responsible for analyzing complex systems, breaking them down into component tasks, estimating time and effort for completing task and tracking progress using Project Workbench for Windows, writing specifications for other programmers as well as coding, debugging and implementing new and updated systems.



AAA Travel Agency

• Financial Analyst/Computer Operations Analyst

  • Apr 1991 - Oct 1993

  17380 Laurel Park Dr., N., Livonia, MI Identifying and resolving problems with AS/400 and PC hardware, system software and applications. Working with internal departments and outside vendors to develop applications to assist in Travel Agency data processing and accounting Analyzing packaged software/hardware for integration into the Travel Agency MIS Training and supporting staff on Travel Agency systems.

• Financial Analyst

  • Nov 1987 - Apr 1991

  17380 Laurel Park Dr., N., Livonia, MI Analyzing, modeling and forecasting income, expenses and earnings Correlation studies Feasibility studies Design, implementation and administration of income statements for all Travel Agency branches, including regional and company consolidations. AS/400 Installation: Capacity planning for the computer and peripherals Physical planning for the installation Troubleshooting peripheral attachment and host communication setup System security setup Developed… Show more Analyzing, modeling and forecasting income, expenses and earnings Correlation studies Feasibility studies Design, implementation and administration of income statements for all Travel Agency branches, including regional and company consolidations. AS/400 Installation: Capacity planning for the computer and peripherals Physical planning for the installation Troubleshooting peripheral attachment and host communication setup System security setup Developed an AS/400 security manual for the organization.



K & R Engineering

• Office Manager/Accountant

  • Mar 1985 - Nov 1987

  5650 Jamestown Rd, Utica, MI Analyzing trends, forecasts, time schedules, unit cost and variances from budget Maintaining accounting system on microcomputer Generating and analyzing financial reports Generating payroll Hiring and managing a staff of 6 employees.