Requests
0
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
LG ElectronicsStaff Software Engineer
Feb. 2020Lincolnshire, Illinois, United States
Handi-FoilIT Manager
Mar. 2017 - Oct. 2019Wheeling, ILManaged IT projects and technology improvements in the production environment for three plant locations. Developed proprietary custom Web/Mobile Dashboard to monitor Production equipment in real time as part of the continuing improvement initiative, using HTML5, CSS, JavaScript, C#, XML and Ajax. Designed for use on desktop and tablet interfaces. Developed custom reports using SSRS based on historical data gathered from production monitoring. These reports are used by Production Supervisors to identify areas of improvement. Provided technical training to all departments on advanced Excel techniques, developed curriculum, training materials, set up classrooms and delivered training. Used C#.net to create internal Web Services to read and write data to MS SQL Server for use with the Dashboards and EDI automation. Created automated processes using PowerShell and MS SQL Server to assist with EDI data transfers and reporting. Implemented data synchronization between Oracle and Demand Works Smoothie Desktop forecasting software using automated jobs and stored procedures in MS SQL Server. Maintained close relationship between IT and production team to identify opportunities to leverage technology solutions. Managed IT helpdesk processes and continuing improvement initiatives
The Plastics Group IncDirector of IT
Sep. 2014 - Mar. 2017Willowbrook, IllinoisManaged IT Infrastructure for two plant locations in Illinois and Ohio. This included managing team of consultants and full time personnel at each location to keep day-to-day computer troubleshooting issues taken care of. Updated existing Production Dashboard software to newer .Net platforms, utilizing VB.Net and C#.Net, implementing modifications requested by end users. Using C#.net, HTML5, CSS and JavaScript, created custom Web and Windows applications to retrieve SSRS Reports and view ERP data for internal and external use. Provided technical training in Excel and Access to end users. Planned improvements to existing network infrastructure, collaborated with Plant & Maintenance Engineers, included adding new Meraki Access Points, Meraki Smart Switches, Fiber for internal data, and installed EPAC Maintenance Software. Upgraded Syscon PlantStar MES software to latest version and installed on new Linux server to improve file retrieval speed and stability. Selected and implemented new email solution from pop3 server to new Office 365 solution for improved uptime and accessibility.
Precision Dialogue DirectIT Manager of Data Services and Digital Imaging
Sep. 2013 - Sep. 2014Chicago, Illinois● Managed team of 15 people in the Data Services Department. This team consisted of 4 Data Processors (Satori, MS SQL, FoxPro, Monticello), 1 Quality Control, 2 Logistics, 4 Variable Data Print Developers (GMC PrintNet T) and 1 Print Operations Leader
● Provided technical and leadership training to team
● Worked with Customer Service to plan and prioritize resource management of Data Services
● Created new processes to help streamline the Data Services team’s production workflow
● Create SQL Databases, custom SQL scripting and C# coding to provide automation support for Data Processing and overall awareness of job workflow
● Implemented new QA process to ensure data flows from the data processing team through final print production with fewer errors
● Planned and implemented changeover from older software (FoxPro) to newer, server based (SQL) solution to improve speed and accuracy of Data Processing Team.
Veritas Document SolutionsIT Manager - Digital Print Developement
May. 2011 - Sep. 2013Buffalo Grove, IL● Managed team of 10 people as part of the Variable Print Production Team. This team consisted of 3 Data Processors (MailManager, Access), 4 Prepress (InDesign, XMPie), 3 Variable Data Print Developers (PageFlex) and 1 Software Developer (C#.net, VB.net, MS SQL Server)
● Worked with Project Managers to plan and prioritize resource management of Variable Print Production Team
● Helped Veritas achieve USPS Full Service Certification to provide better postal solutions for clients
● Created new processes to help streamline the variable print development team’s production workflow
● Worked with management and infrastructure team to help develop hardware and software upgrade solutions for a more stable development and production environment ● Custom scripting and coding to provide automation support for print development software like PageFlex and XMPie
● Implemented new QA process to ensure data flows from the data processing team through final print production with fewer errors
Adesso Solutions, LLC.Senior Web Developer
Apr. 2009 - May. 2011Create new and maintain existing web-based applications for the Trade Marketing industry, utilizing C#.net, VB.net and classic ASP as well as SQL Server 2005 - 2008.
Manage remote hosting environment of 15+ web and database servers.
Backend MS SQL Server database design and programming for commercial and custom web-based applications to include tuning, indexing and optimizing Created custom reports using Report Services in SQL Server 2005 - 2008 Maintained multiple databases for web-based applications
Strata Marketing, Inc.Business Analyst
Jul. 2007 - Apr. 2009● Develop customizations of Microsoft CRM software for Time Warner Cable and Comcast Cable
● Create software and MS SQL database applications to retrieve and utilize Nielsen ratings information to accurately report cable viewing impressions when selling advertising spots. Optimize SQL databases, queries, stored procedures and DTS packages to handle large quantities of data processing (average table size = 100m records)
● Create and maintain web-based software to track demographic information within the cable advertising industry
● Backend MS SQL Server database design and programming for commercial and custom web-based applications to include tuning, indexing and optimizing
● Created custom reports using Report Services in SQL Server 2005
● Utilized Execution Plans and used knowledge of Lock Escalation to help optimize queries in SQL Server
Dorel Juvenile GroupWeb Applications Developer
Dec. 2003 - Jun. 2007Created and maintained internal web applications. Maintained web and database servers. Created and maintained MS SQL Server databases.
Onkyo America, Inc.Database Administrator
Sep. 1997 - Jan. 2002● Created and implemented barcode tracking system database for tracking internal inventory and maintaining inventory accuracy
● Administered Fourth Shift MRP system
● Created and maintained internal web-based applications that incorporated data from multiple sources and trained end-users on application use
● Developed company intranet site from scratch on internal network using ASP, then upgraded the site to Site Manager before finally moving it to SharePoint just before the plant closed
● Administered MS SQL server and assisted Network Administrator
Productivity Point InternationalTechnical Trainer
Jun. 1993 - Sep. 1997● Taught database programming classes and Relational Database design in MS SQL, Access, FoxPro, Paradox and dBase as Microsoft Certified Trainer
● Created and maintained internal database for tracking classes, students and instructors
● Assisted Network Administrator
Intch is a Professional Networking App for the Future of WorkSee more people like Troy on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
488114 people
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
18
Senior Software Engineer @ EarnIn
111437 people
42
Senior Mining Engineer @ Riot blockchain
16
CEO/Data Engineer and Consultant @ Propeltech Services LLC
24
Managing Manager @ INGENTA HIRING