SUMMARY:

• Information Technology Professional offering a unique combination of business, technical, and analytical skills with a 12+ year demonstrated success record in:
• Project Planning, Design, and ManagementMicrosoft SQL Server and Visual Studio
• SDLC and System IntegrationSQL Data ETL and Tools (SSIS/DTS)
• Oracle 10g/11g ERP ImplementationMicrosoft T - SQL and VBA Macros
• Business Intelligence DevelopmentASP and ASP.NET Reporting
• Leadership, Business Strategy, and Object-Oriented Programming

WORK EXPERIENCE:

Confidential, Upper Saddle River, NJ

Information Technology Manager

Responsibilities:

• Lead 5-person department supporting a manufacturing campus of 5 facilities and 220 associates, mentoring network administrator and desktop support engineers
• Develop and assist with the requisite policies, best practices, documentation, and procedures for the ISO 9001:2008 and ISO 13485:2003-compliant, FDA-registered medical environment
• Coordinate organizational strategy with management and leadership team to develop and support employee growth of over 155% and revenue growth of over 105% over a 7-year period
• Oversee projects for MS Exchange upgrade, SonicWALL firewall/spam/network security, Cisco Meraki wireless network, VDI thin-clients for new center, and MS Lync 2013
• Budgeting with CFO to allocate $100,000 annual budgets and mid-year reviews
• Manage ProfitKey Rapid Response Manufacturing system with administrative functions of patch installations, Oracle cold/hot backups, SQL data cleansing, new module rollouts, process re-engineering to streamline business functions, and work instruction/ plan creation
• Provide day-to-day support for 50 system users involving process and financial (AR/AP/GL) troubleshooting, ad-hoc SQL queries, and reporting through ODBC and SSIS/DTS packages
• Crystal Report design for quality documents including travelers for Device History Record (DHR) retention to FileMaker-based Document Management System, Device Master Record (DMR) generation of bills-of-material and shop-floor routings, and electronically-signed limit-controlled orders
• Perform data ETL with MS Visual Studio 2008 and SQL Server Management Studio on SQL Server 2005 and 2008 R2 platforms using SSIS/DTS packages and Excel lookups/charts/pivot tables for Key Performance Indicators (KPIs), Lean Manufacturing initiatives (5S, Kaizen blitzes, Kamishibai), and various BI projects to achieve consistent 95+% On-Time Delivery and 97+% Acceptance Rates
• Collaborate across company to develop SQL back-end/ASP and ASP.NET front-end interfaces, including a Quality Inspection Log for inspections and customer/vendor failure logging, Shop Floor Measurement Logs to quantify operations and efficiency, an HR Job Requisition System, and a small-scale ASP/SQL-based Learning Management System (LMS)
• Member of LMS team (SumTotal system) for vendor selection, configuration workshops, learning activity design, user acceptance testing (UAT), validation through IQ/OQ/PQ, and go-live
• Design and supervise IT infrastructure for new facilities (9,000 square-foot medical building in 2009, 6,000 square-foot commercial building/warehouse in 2012, 35,000 square-foot medical implant building in 2013) including quoting, vendor management, hands-on implementation
• Research and implement add-on Toshiba VoIP solution to existing PBX for 170 desktop handsets and Polycom conference phones with inter-building connectivity and Valcom paging
• Upgraded datacenter of 8 physical servers to VMware virtual environment of 20 virtual servers and a Dell Equalogic/Compellent SAN with Veeam backups and full disaster recovery plan
• Support and install manufacturing engineering packages (PTC ProEngineer/Wildfire, Mastercam, Solidworks, Delcam PartMaker, SpaceClaim, VoluMill), Cribmaster and MSC manufacturing tool storage and management software, and GAGEtrak gage tracking and calibration software
• Network management of CNC machines (Hardinge, Haas, Makino, Citizen, Tsugami) running machine controls (Haas, Fanuc, Mitsubishi, Mori) with Dostek DNC software, Moxa-based wireless transfer network, and custom CNC program and fixture database
• Deployment, quality validation, and troubleshooting of production equipment including Trumpf Laser Markers, PC-DMIS and Zeiss CMMs, Agie/Mitsubishi Wire EDMs, and a Fortus 3-D Printer

Confidential, Hoboken, NJ

ERP Manager

Responsibilities:

• Prepared and implemented 9-month upgrade from 15-user, green-screen, IBM AIX-based version to GUI, Oracle 10g-based version (now 11g) with over 50 current users
• Audited ERP-related job roles and set up cross-functional teams to evaluate business processes, redesign/refine/re-implement as necessary, forge user relationships, and establish consistent communication lines for daily production and long-term projects and initiatives
• Filtered and cleansed data with the Oracle SQL Plus worksheet, SQL queries, Excel, and manual editing to ensure data standardization, consistency, and error-free conversion
• Customized and created Crystal Reports with Crystal Report Designer XI, including standard system reports, converted custom reports, and new reports with enhanced system functionality
• Converted existing Intranet HTML, ASP, and ASP.NET pages to connect to new Oracle instances under Oracle SQL syntax and designed new summary and drill-down reports
• Established demo database for testing existing functions and running concurrent processes to validate data consistency, and provide a stage environment for user

Confidential, Chicago Area, IL

Director, IT & Purchasing

Responsibilities:

• Implemented VAI’s S2K system, including vendor evaluation, data cleansing/conversion, chart of accounts and general ledger setup, re-engineering of key business processes, creation of structured programs, data analysis for custom reports, and programming modifications
• Supervised IT and technical areas of company consolidation from three warehouses to single new central location, including purchase of new IBM I-Series AS/400 Server, lease of T1 IVAD circuit, negotiation of all hardware contracts, setup of data network and phone system, rollout of office workstations, and development of bin location and inventory plan with warehouse manager
• Utilized inventory analysis/control, resource planning, EOQ, and vendor performance monitors of local and overseas (Taiwan, China, Korea) suppliers to increase inventory turns from 1.6 in 2002 to a steady 2.2 turns in 2007 of a $2.6 million dollar inventory
• Took charge of PBE (paint, body, and equipment) division and created monthly promotions leading to an increase in body shop supplies sales from $36,762 in 2,375 in 2007
• Handled company health insurance plan, Simple IRA retirement plan, ISO 9001:2000 pre-audit process, and 2007 State of Illinois audit