John K. Email & Phone Number

Farmingdale, New York, United States

Customize and support Infor Visual Manufacturing by combining advanced skills in SQL Server, VBScripting, VBA, VB.NET, Command line scripting, MS Access, and many other IT Tools.

Westbury, New York, United States

Enhanced and Maintained Company ERP Systems, Infor Visual Manufacturing 7.0, Visual Quality, Visual Time and Attendance, Vendor Portal.Created Customizations in MS SQL Server (Queries, Views, Triggers, Stored Procedures, Functions, Jobs, Schedules, Tables)Created Reports using Crystal Reports, Report Writer, Excel, MS Query, MS AccessCreated and scheduled SQL JobsMaintained SQL Backups

LAN/WAN network implementations and support (Ethernet, DSL, Cable Broadband Circuit Connections) including wireless (802.11 A/B/G/N)Setup and troubleshooting of Windows Servers including MS Exchange and external e-mail systems, Backup software installation and maintenance, RAID setup, Security setup, Enterprise Antivirus setup and maintenance,Recommend, purchase, setup and configure Routers, Firewalls, Switches, Hubs, Access PointsEthernet Cabling Installation (10/100/1000 base T)PC setup / diagnostics & troubleshooting, hardware and software installation, ODBC setup, e-mail client setup and configuration, disk partitioning, driver installation, scripting for scheduled maintenance (defrag, disk check, reboot, antivirus scan, file share security reset…)Printer, fax and scanner setup and maintenanceApplication Setup and Support / Help DeskDatabase Design / Reporting and Queries using MS Access, SQL, MS Excel / Query to create custom reporting tools, to manipulate data and import data into client database systemHardware and software platforms include Windows NT, 2000,2003 Servers, DOS, Windows 95, 98, XP Workstations, MS Exchange, Symantec Backup Exec / Antivirus / Mail Security for Exchange, GFI Faxmaker, Winfax Pro, MS Outlook, Word, Excel, Power Point, Access, LexisNexis HotDocs, Quickbooks.

Managed a team of 6 software developers. Duties included: performance reviews, compensation, promotions, work assignments, training, vendor / consultant management, departmental priorities and coordination with other business leaders.Developed custom programs and scripts to support enterprise wide business objectives in a variety of environments: Unix, DOS, Windows, SQLServer, Oracle.Successfully managed several projects utilizing Waterfall Software Development Modeling Methodology. Projects included Manufacturing Planning and Tracking, Automated Clearing House (ACH / EDI) Banking, Timesheet Tracking, Customer Relationship Management, and Accounting / General Ledger systemsGlovia International v7.1 – Responsible for implementation of new ERP system. Provided user support and user training. Analyzed Business Processes and developed detailed specifications based on the needs of the organization. Managed organizations use of Microsoft Office Live Meeting Web Conferencing, and other company wide tools.

ERP implementation and support(QAD MFG-Pro v 9.0 / Progress Database). Converted legacy data for CIM Load into new ERP system. Created new applications and customized existing MFG-Pro programs for Finance, Order Administration, Shipping, Manufacturing, Operations, Sales & Marketing, and Payroll Departments. Responsible for implementation of new HR / Payroll system. Migrated legacy data into new platform (Software Plus – Geneva v 2.1). Developed and maintained various interfaces between Geneva, ADP and the MFG-Pro Financial module. Hardware platforms include HP – Unix Servers, NT Servers, NCR Servers, PC Workstations, and Thin Client Workstations operating in a Windows NT Terminal Server Environment. Designed and installed firms network based fax solution. Supported various desktop applications: MFG-Pro, Geneva, MS Office, Symantec ACT, Outlook / Outlook Express, ADP Payroll for Windows.

Developed and maintained production and test software using MS Visual Basic, MS Quick Basic, Assembly code, and Batch file programming.Designed test fixtures (RS422 / IEEE 488 / RS232 / direct measurement). Created and maintained databases using MS Access, Dbase IV, Escort (Unisys System 80), MS Excel, and Lotus 123. Designed and implemented Computer Automated Monitor and Control hardware and software for Satellite / Earth Station Communication Systems. Obtained Intelsat approvals for Standard G Earth Stations, and Parabolic Antennas. Wrote Technical Manuals and trained users in the use of Satellite Communications Equipment (Audio / Video / Voice / Data / Spread Spectrum Baseband Equipment, Satellite Converters, LNA’s LNB’s, Satellite Acquisition) Satellite frequencies included L, C, and Ku bands. Trained users in standard MS Windows Applications. Created all course materials. Designed Microprocessor Circuits for production equipment. Customer Correspondence and preparation of Technical Proposals ($100K – $1M)

Qualification tested production Software. Approved drawing documentation, purchase requisitions and assembly operation sheets. Performed internal audits of all departmentsCommercial and Government Customer Presentations. Performed statistical process control management for manufacturing. Customer Correspondence.