Amy Mcivor Email and Phone Number

-Work with team of two for daily troubleshooting support of over 600 P21 users at over 55 locations across the western United States from Alaska to North Dakota.-Transitioned all users from desktop version to web in after 9 months of testing and upgrades in under 4 months.-Implement integrations for Epicor and non-Epicor products to improve efficiencies in the company in multiple departments including accounting and purchasing.-Work with internal users to make incremental improvements based on user feedback through helpless, surveys and other feedback methods

Work to develop improvements to Prophet 21 system through implementation of new modules, integrations and Dynachange products. Work with users and management to analyze system and develop improvements through Dynachange Business Rules. Administer Prophet 21 system and database. Manage reporting systems including use of RubberTree products incluing WebQuery,ExecuKeys and Rubber Tree CRM. Train users on standard operating procedures and develop training materials for new implementations.

IT Application Specialist for Enterprise Resource Planning (ERP) system Epicor P21. Provided system administration and technical support for ERP for 13 locations and approximately 150 employees. Create reports using SQL, MITS and Crystal Reports. Work with connected technologies to support linked applications such as invoicing and specialize in supported applications.

Worked on a variety of IT related processes including website development, some marketing related tasks, and supporting ERP Prophet 21 through system upgrades, data maintenance and supporting support cases.

Worked with Agency contact to gather system requirementsUsing Viso created Entity-Relationships, Class, and Sequence DiagramsManaged project using agile methodology and used JIRA to track progress. Upgraded Access database to SQL Server database with new User Interface through Windows forms and reporting through TableauCreated SQL Server Database, Tables, Views, Stored Procedures using T-SQL. Migrated data from Access database to SQL database using ETL. Created Windows Form for User to Interface with BI Solution using MS Visual Studio, C#, SQL.