|
||||||
| My Resume |
| Kevin L. Snyder |  |
| www.kevin-snyder.com | |
 |
|
 |
|
| Microsoft is a registered trademark of Microsoft Corporation |
| Mr. Snyder has 7 years of professional experience. He has performed as a Programmer Analyst, Manufacturing Controls Engineer, Production Engine Test Cell Engineer, and Supplier Quality Engineer. His responsibilities have included programming, database query & analysis, machine electrical design (NFPA 79, SAE HS-1738, AutoCAD), upgrading, troubleshooting, maintenance support, managing quality issues of supplied parts, supplier process audits to QS-9000, supplier part certification, onsite review of over 30 suppliers' manufacturing processes, PPAP, FMEA, and SPC. |
| He has covered automotive gasoline engine and heavy-duty diesel engine assembly lines, engine head and block transfer machining lines, and production engine dynamometer test cells. He has a track record of going beyond his job scope to research and implement new programs (MPTS System Monitor, FIS pilot system, and PPM defective supplier tracking) at his employers. His annual employee development reviews for the last 2 years at Detroit Diesel (new rating system for last 2 years), consistently rank his Customer Service and Initiative/Continuous Improvement as his top two characteristics. |
| CERTIFICATIONS | ||
| IBM Certified Specialist - AIX 4.3 System Administration | ||
| MCP+I (Microsoft Certified Professional + Internet) | ||
| MCSE (Microsoft Certified Systems Engineer) | ||
| Exams Passed: | Networking Essentials, NT 4 Workstation, NT 4 Server, NT 4 Server Enterprise, Internetworking with TCP/IP on NT 4, IIS 4 | |
| CQT (Certified Quality Technician) through ASQ (American Society for Quality) | ||
| FE/EIT Intern NCEES (National Council of Examiners for Engineering and Surveying) FE exam administered in Tennessee | ||
| PROFESSIONAL TRAINING | |
| IBM AIX 4.3 System Administration I | IBM AIX 4.3 Basics |
| IBM AIX 4.3 System Administration II | IBM AIX 4.3 Korn Shell Programming |
| IBM AIX 4.3 System Administration III | Reliance GV3000 VFD |
| Accelerated Microsoft NT 4.0 | Cooper Tools (ITD) - Servo Fastening Machine |
| - Admin & Core Technologies | Atlas-Copco (AFS) - Servo Fastening Machine |
| Accelerated Microsoft SQL Server 7.0 | Allen Bradley PLC 5 Troubleshooting |
| - Admin & Implementing a Database | Allen Bradley PLC 5 Programming |
| Microsoft Access Beginning | Allen Bradley PLC 5 Advanced Programming |
| Microsoft Access Intermediate | Indramat Trans01 Servo |
| Microsoft Access Advanced | Indramat Trans01D Servo |
| PC Troubleshooting and Upgrading | Indramat MT-CNC |
| Intellution iFIX | Intergraph Microstation 4 |
| Wonderware InSQL | Infinity SPC Software |
| LANGUAGES | ||
| Korn Shell Script | HTML | IEC-1131 |
| SQL | ASP | SFC & RLL |
| BASIC | VBA * | STRUCTURED TEXT |
| FORTRAN (SCHOOL) | VISUAL BASIC * | PASCAL (SCHOOL) |
| ASSEMBLY (SCHOOL) | JAVA * | C (SCHOOL) * |
| OPERATING SYSTEMS | ||
| NT 3.51,4 WORKSTATION | WINDOWS ME,98,95,3.1 | UNIX - AIX,LINUX |
| NT 4.0 SERVER | MAC OS | MS DOS |
| WIN 2000 PROFESSIONAL | WIN 2000 SERVER | |
| DATABASES | |
| MS SQL SERVER 6.5,7 | DB2/UDB 6,7 |
| MS ACCESS 97,2000 | ORACLE 7 (SELECT QUERY ONLY) |
| HARDWARE & NETWORK | ||
| INDUSTRIAL PC | A-B PLC 5 | MODICON 984 |
| SoftPLC® | A-B PLC 2 | MODBUS |
| HP & COMPAQ SERVERS | A-B DH+ | MODBUS PLUS |
| ETHERNET | A-B REMOTE IO | MODICON PANELMATE+(HMI) |
| RS-232 | INDRAMAT MT-CNC | TCP QUICK PNL JR(HMI) |
| INTERBUS-S | INDRAMAT TRANS-01 | TELE PREMIUM PLC |
| AFS SERVO FASTENERS | INDRAMAT TRANS-01D | FIPWAY |
| ITD SERVO FASTENERS | LVDT COLUMN GAUGE | RELIANCE VFD |
| SOFTWARE | ||
| MS IIS 4.0 WEB SERVER | ASAP ASIC PC CTRL IEC-1131 | TELE PL7 PRO |
| MS INTERNET EXPLORER | INTELLUTION iFIX (SCADA) | MODSOFT |
| NETSCAPE COMMUNICATOR | VIEWPOINT (HMI/SCADA) | RS LOGIX 5 |
| ORACLE DATA QUERY | ALERT ICM (HMI/SCADA) | A-B 6200 |
| WW INSQL | WW INTOUCH (HMI/SCADA) | TOPDOC SoftPLC® |
| RSSQL | RSVIEW (HMI/SCADA) | TOPDOC PLC 5 |
| AUTOCAD R14 | TOPDOC 2to5 Convert Tool | TOPDOC PLC 2 |
| AUTOCAD LT 98, 97 | MS WORD & EXCEL | MS PROJECT 98 |
| MQSERIES 5 (NT,AIX) | HUMMINGBIRD EXCEED | XFREE86 |
PROFESSIONAL EXPERIENCE
CDI Corp. - IT Services Division
On assignment at Daimler Chrysler Technology Center, Auburn Hills, MI
Sr. Programmer Analyst, July 2000 to Present
Detroit Diesel Corp.
Manufacturer of Heavy Duty Diesel Engines, Detroit, MI
Manufacturing Controls Engineer, March 1997 to July 2000
Supplier Quality Engineer, October 1994 to March 1997
Bechtel National, Inc.
Engineering Design and Construction, Oak Ridge (Knoxville Area), TN
Intern, 1990 and 1991
Manufacturing Parts Tracking System (MPTS) Project, July 2000 to Present. Part of a three-person team brought in to implement Phase 2 of MPTS, find and fix bugs from Phase 1 install, and train users on system.
- Provided support as first line of defense during numerous system hiccups and crashes. Evaluated current Phase 1 system functionality by writing and executing queries against system database to find what was working and what was not. Wrote and executed shell scripts to automate repetitive database queries during test and debug of Phase 1 fixes and Phase 2 implementations. Used PLC programming to create, change, and debug data transmition subroutines in PLC's that controlled engine assembly stations and others that functioned as data concentrators on the PLC network. Used CAD software to update network and device changes. Initiated and developed shell scripts to automaticallycreate and update a system health and data collection status monitor web site for2 MPTS installations.
- Wrote SQL queries and Korn Shell scripts for DB2/UDB 6 and AIX 4.3.3 on IBM RS/6000 Unix servers (F50's & H50's), used PL7 Pro on laptop for Telemechanique Premium PLC's and Fipway PLC network, AutoCAD R14.
- Introduced three tools to our controls group that had not been utilized: relational databases (automatically inserted data), automated email on event, and active content web pages showing real time production information. Evaluated software packages to collect real time data from PLC's and insert into a relational database for intranet web publication and email to alphanumeric pager on machine fault or lack of production. Wrote web pages showing real time production counts and machine status that automatically updated to function as a department monitoring screen. Added links to department page to query database for recent history of a particular machine status or fault history and also showed the results graphically in Pareto charts. Added user flexibility in querying to select a subset of faults, dates, or number of records returned. Trained three shifts of supervisors (engine block transfer machining line) on alphanumeric paging system operation.
- Evaluated Intellution iFIX, Wonderware InTouch and InSQL, and Rockwell Software RSView and RSSQL. Decided on iFIX with Microsoft SQL Server 6.5/7.0 and IIS 4.0 web server on NT Server 4.0 OS and HP E60 Netserver hardware. Collected data over A-B DH+ from A-B PLC 2/30's and 5/40's with a KTX card in the HP E60. Wrote ASP (Active Server Pages) web pages with VB scripting, SQL in iFIX for data inserts and updates, and SQL in the ASP's to query database.
- Performed as Lead Controls Engineer in team. Planned and directed construction of electrical hardware in new location to ensure a rapid relocation over a 9 day shutdown window in the beginning of March. Acted on opportunity to redesign the hardware (main panel, junction boxes, field wiring, new set of prints) on 1 (Assembly Line Controller) of the 2 major controls systems in place to fix problems and realistically allow for changes and expansions of the system. Directed 1 or more (up to 4) concurrent teams of electricians (2 electricians per team) during the months of preparation construction and during the actual 9 day relocation and debug of equipment.
- Created a bill of material on MS Excel, tracked expenditures, created a new set of electrical schematics with AutoCAD LT 98, modified Assembly Line Controller (ASAP ASIC 200 PC based control IEC-1131) for new equipment layout. Debugged machine builder's revised Modsoft programs for the revised layout of the powered pallet and floor conveyance system (2 Modicon Compact 984 with MB+ network tied into the Assembly Line Controller).
- Converted PLC program logic (1200+ rungs each), translated BCD data table values to integer, modified tag addresses in HMI.
- Utilized TopDoc 2to5 translator program for bulk of logic, rewrote logic from scratch on 100+ rungs of BCD math (now about 20 rungs), fixed occasional translator errors (mostly in areas that dealt with files).
- Debugged and enhanced previous programmers' code, integrated multiple electronic devices over 3 different communication networks, trained supervisors and operators in system operation.
- Debugged and programmed ASIC-200 in IEC-1131 on a Compaq Dual Pentium Server running NT Server 4.0, finished integrating 2 Modicon Compact 984 PLC's over Modbus+, 28 Interbus-S Discrete IO Modules (that interlocked with 3 ITD fastening machines, 3 leak testers, oil fill, and 9 Valenite LVDT column gauges), 2 barcode scanners over Interbus-S, and RS-232 serial communication to 1 column gauge.
- Provided 1 month of support on day shift and 2 months on afternoon shift (basic electrical controls construction, troubleshooting, and repair).
- PowerTek engine dynamometer test cells running LynxOS (UNIX) on HP VXI mainframe for control and custom HMI on Windows NT 3.51 PC for operator interface.
- Worked with machine builder on final design issues, directed electricians integrating additional control equipment into existing operation (following updated prints from machine builder). Debugged the machine builder's additional logic to existing program, set servo profile (speeds and depths), modified several and created 2 new HMI screens.
- Used AutoCAD LT 97 to do minor work with prints, Trans01 Servo system on both stations, TopDoc 2 to program A-B PLC 2/30, and AlertICM for HMI work.
- Created new prints and new stand alone conveyance logic with interlocks to separated machining operation. Directed electricians in reworking a discarded 2 door control panel to new prints, reworking an operator interface panel, integrating the reworked panel, and relabeling all field wiring to new prints and IO addresses. Started up and debugged the new hardware and logic.
- Used AutoCAD LT 97 for creating all the new electrical prints and TopDoc 2 for programming the PLC 2/17 logic. Panel rework required removal of 2 existing reversing A-B NEMA motor starters, overloads, and fuses to fit 7 Telemechanique Integral motor starters (2 were reversing) with built in overloads and circuit breakers.
- Legacy system only tracked percent accepted of parts received. Initiated and developed a system to track PPM defective of supplier shipments. Wrote, executed, and analyzed queries on PPM and other ratios on company's ERP database. Developed system was absorbed into company's new CCVI multi-characteristic supplier rating system to continue PPM defect tracking.
- Oracle Data Query used on Oracle 7.3 relation database, MS Excel used for organizing query results and summary reporting, analyzing and comparing suppliers relative to each other.