Wayne Amundson Email & Phone Number

Lakeville, Mn

Business Intelligence Specialist that designs, develops and test reports for the entire organization. Provides strategic leadership for implementation for new technologies and improve user experience.Environment: Windows Server 2008, IBM iSeries, Linux, IBM DB2 10.5 (Blu Acceleration), IBM Cognos version 10.2

Mounds View, Minnesota

• Performed complex business analysis projects using TSQL, Excel, and Crystal Reports. Interacted with management and users to increase productivity, increase sales, and reduce costs.• Planned, implemented, and managed Business Intelligence solutions at Midwest Medical Holdings. Created and maintained a SQL Server Data Warehouse, supporting all reporting and analysis tools surrounding it. Designed and created reports using Crystal Reports.• Maintained and supported multiple ERP systems for Midwest Medical Holdings, Brightree for DME (durable medical equipment) and QS1 for Pharmacy. Investigated and resolved software issues and defects reported by business users.• Coached users on effective use of systems and applications such as MS Excel, MS Word, Brightree, and QS1.• Integrated Digital Shipper (a shipping system) with Midwest’s ERP systems (Brightree and QS1). Shipping notification is an automated and near real-time process, increasing efficiency in order confirmation and billings.• Implemented Brightree, a SaaS DME ERP system for Midwest Medical. Converted data from Solution 1, their previous ERP. Identified opportunities for workflow/process improvements and worked with functional areas to jointly develop ways to enhance productivity, efficiency, and effectiveness through Brightree.Environment: Windows Server 2003/2008, MS SQL Server 2005/2008, Crystal Reports

Osceola, Wisconsin And Minneapolis, Minnesota

• Consolidated Quayside’s four standalone ERP systems, to a single, integrated ERP system. This resulted in increased productivity and enhanced Quayside’s reporting and analysis capabilities.• Planned and implemented integration of Quayside’s ERP system with RR Donnelly, Quayside’s 3rd party warehouse. • Coordinated the move and built system infrastructure for Quayside Publishing to downtown Minneapolis, 400 Wyman Building.• Planned, implemented, and managed the technology to support MBI’s electronic commerce initiative. • Implemented Qsolution (now Firebrand Technologies), a product which manages bibliographic information and images. This information is now being transmitted to our trading partners via ONIX, which resulted in a 27% sales increase at Amazon.com during 2006. • Designed and implemented the new systems and telecommunication infrastructure for MBI’s second site at Galtier Plaza, St. Paul MN. • Managed the initial Business Intelligence solution at MBI. Designed and created reports using Crystal Reports. Interacted with management and users to increase productivity, increase sales, and reduce costs.• Planned and implemented a publishing based ERP system (CIS.PUB), without any breaks in service. Supervised up to 10 consultants for the ERP installation.• Planned and implemented a comprehensive upgrade of MBI’s aging system infrastructure.Environment: IBM AIX, Universe, Windows Server 2003/2008, MS SQL Server 2005/2008, Crystal Reports

St. Paul, Minnesota

• Coordinated the move of 3M Printing SBC systems to One Imation Place.• Project leader of Sales Force Automation within 3M’s Printing SBC.• Defined, analyzed, designed and implemented Sales Value Improvement, a tool for the sales force to manage the cost of Sales and Marketing programs. The project received 3M’s Pyramid of Excellence Award.• Project leader for the implementation of EDI (End User Reporting) for 3M’s Printing SBC, leading a cross-functional team of over 40 individuals plus 15 contract programmers. End User Reporting was used for input to rebate programs and gave better visibility of actual usage of sales into 3M’s Printing customers. • Supervised up to 10 people, in the sales statistics, rebate, reporting, and programming/analysis areas.• Responsible for the disbursement of $30+ million in rebate payments to 3M customers and distributors.Environment: IBM MVS, IMS, COBOL, DEC VAX, 1032, Ingres

Wausau, Wisconsin Area

• Supported policy and claim processing systems.Environment: IBM MVS, IMS, CICS, COBOL