Perkins & Marie Callenders IncFunctional/Technical Analyst and Programmer
Jan. 2006 - Aug. 2015• Provided EDI Support for the three manufacturing facilities for ordering, shipping, and inventory.
• Project lead for integrating EDI functionality into ERP system. This includes transactions 810, 832, 846, 850, 855, 856, 940, 997. Worked with EDI software vendor for mapping needs. • Wrote ETL code to facilitate data load from EDI to Sage X3. • Advanced SQL programming to resolve data issues and provide custom reporting.
• Quality Assurance advisor assisting with User Acceptance Testing (UAT), test cases, selecting of test team, and documentation prior to go-live period.
• Quality Assurance tester solely responsible for feedback on applications developed by third-party vendor as well as internal staff requiring test plans, documentation of issues and recommendations for resolution.
• Project lead for installation of warehouse barcode scanners collaborating closely with third-party vendor.
• Troubleshoot user and system issues, data problems and supported the users as related to ERP.
• Wrote BRD, FRD and Change Request Management (CRM) for new system development.
• Collaborated with users to determine how they interact with A/R to automate new accounts receivable module.
• ERP System administrator including daily maintenance and package upgrades.
• Systems Analyst on multiple project initiatives including interfacing GL and AP Accounting systems.
• Redesigned and converted VB 6 legacy programs to VB.net.
• Researched and presented new software solutions to Senior Management where appropriate.
• Project lead for two major version ERP upgrades • Liaison between users and software vendors for troubleshooting, custom application enhancements and user training
• Troubleshoot reconciliation issues between stock management and General Ledger.
• Crystal Reports utilizing SQL 2003/2005 for data verification and user requests.
• VB.NET Application development using Visual Studio 2010 and Crystal Reports