Experienced ERP and business systems analyst with a history of improving inefficient processes to maximize outcomes. Dedicated to automating labor-intensive reports to keep departments lean and accurately track performance indicators. ERP subject matter expert, adept at user acceptance testing, implementation, and training end users.
• Liaison between business users and developers to triage and resolve system errors for JD Edwards ERP and related systems. Provide role-specific training for ERP users.
• Coordinate operations and system improvements for users working remotely and in satellite offices across Florida. Create profiles for new users for multiple software platforms, monitor system security, and resolve related IT tickets.
• Convert SQL Server stored procedures from custom-built CRM to consume data from new CRM built on OutSystems platform. Utilize Visual Studio to revise and deploy converted SSRS reports to report server.
• Convert Power BI reports to Tableau.
• Direct operations and system improvements for 150 Quantum Enterprise Resource Planning (ERP) users across four physical locations. Create profiles for new users, monitor system security, and resolve related IT tickets.
• Redefined SharePoint system security. Gave relevant managers grant/deny access abilities, and created new information architecture for system to keep information secure while making general information more easily accessible.
• Eliminated input errors by creating an application that automatically entered scanned barcode data into Quantum ERP; the reduction in labor decreased processing time by 40%.
• Automated Pareto reporting process to more consistently identify the cumulative effects of process roadblocks.
• Developed Key Performance Indicators (KPIs) visible and actionable to supply chain management staff by leveraging Azure data warehouse in Microsoft Power BI.
• Managed the electronic health record system myEvolv for 100+ users. Trained doctors, nurses, and other staff on the system, and utilized feedback from users to tailor the system to meet the agency’s needs.
• Decreased agency-wide reporting time by several hundred hours per week by transferring reports out of Excel and into automatically delivered Crystal Reports.
• Reduced human data entry errors by leveraging SQL Server Integration Services (SSIS) to extract data from sources directly. Created SQL triggers to e-mail users of regarding major status changes, simplifying the adoption and age-out processes.
• Established standard operating procedure for Visual Manufacturing ERP and trained 25 users on best practices.
• Reduced shipping errors and late orders 40% by implementing new acknowledgement, purchase order, and invoice collection system. Digitized and automated forms, creating a searchable cloud-based backup database.
• Increased accuracy and speed of inventory valuation by integrating bar codes and SQL data into the process. Built in automatic system checks to verify alignment of the product, location, valuation, and ticket number.
Seth Kwitko — sethkwitko@gmail.com — 917-554-4961