Systems Analyst
North Side Foods
Arnold, Pa
-Author and maintain complex SQL queries, DTS Packages & Crystal Reports-Design, implement & support a Sales Reporting Portal in SSRS-Provide Technical and Functional Support for user base across two plants-Implement and support IT applications to improve company business process-Work with all internal departments, outside consultants, & vendors to ensure project success-Compile end user procedures and internal IT documentation -Manage Label Printing & Application environment, including: label design, software, & hardware Key Achievements:-Technical Lead on upgrade of Adage ERP system from version 3.0 to version 5.0, including the conversion of 200 related Crystal Reports & SQL views.-Instrumental in testing, implementation, and troubleshooting of a custom label printing solution, using Teklynx Labelview’s backend functionality.Instrumental in the design, testing, implementation and troubleshooting of collagen casing conversion to barcode tracking with Coolearth’s Whistle WMS.-Lead the design, testing, implementation and troubleshooting of spice conversion to barcode tracking with Coolearth’s Whistle WMS.Redesigned and automated manual financial data collection processes using a collection of SQL views, DTS packages and jobs.-Instrumental in the design, testing, implementation, and troubleshooting, of a central palletizing solution that provided inventory tracking down to the box level without user intervention.