Provided development and administrative support to Dataflo ERP system and Microsoft Dynamics CRM 2015 systems. Recently migrated majority of business units to Salesforce.com. Developed data warehouse and PowerBI for reporting and analytics. Utilized add-on products for Dynamics CRM (AutoNumber, Documents Core Pack, Import Tool, and Parature). Worked with data providers to segment customer base and develop prospects for marketing campaigns. Created ad-hoc SQL queries. Utilized SSIS to build integrations between systems. Worked on team to upgrade to Dynamics CRM 2015. (Epicor Dataflo v5.9.5, Unidata database, HP-UX rx2660 hardware, Microsoft Dynamics 2015 (on-premise), Salesforce.com (Enterprise), SQL Server 2014, Dynamics CRM 2011, Epicor Clientele CRM, iConnect).

Developed Unidata programs to support the manufacturing, engineering, sales, planning, and accounting applications for the high pressure pump business. Created interfaces to feed purchased software packages (Demand Solutions, Clippership, Trakstar carousel system, StoreFront / Web Portal / Redback, purchasing cards, web-based expense reporting, AWForms, AWMail, and Intermec barcode equipment). Performed database administration and scheduled cron processes. Upgraded heavily customized ERP system software. Migrated majority of custom code to new versions. Converted acquired companies' databases to Dataflo. Wrote routines to capture transaction data for L262 reporting compliance. (Epicor DataFlo v5.11.4 on Unidata/HP-UX rx2800 hardware)

Founded consulting company and incorporated in State of Minnesota. Pursued new consulting opportunities. Provided application programming and technical support to client base. Attended user conferences and vendor exhibits. Actively improved and developed relevant skills.

Produced software solutions to support the manufacturing and distribution of medical products for the leading fertility and women’s health company. Responded to user requests and production issues. Performed software changes and complied with Sarbanes Oxley procedures. Worked from a Service Now ticket queue. All changes require peer review and UAT. Used MasterControl and Smartsheets for change control and release documentation. Modified integrations with software packages (Vertex tax, Clippership, Web StoreFront, AWForms, AWMail, positive pay). Many changes required for compliance with requirements and regulations. Multiple instances of Dataflo to support all business units.(Epicor DataFlo v5.8.5 on Universe database/HP-UX/RX2600 hardware converted to Redhat Linux server).

Provided software programming for industry leader in tarp systems for the transportation industry. Helped troubleshoot highly customized product configurator software. Worked on implementation of advanced shipping and field service modules. Gathered requirements for freight quoting. Resolved issues from large request backlog and daily production problems. Used third party software packages (AWForms, AWMail, Kore KFC). Automated reports and scheduled cron processes. Supported users in multiple plants.(Epicor DataFlo v5.12.7 on Unidata database/HP RP3200 hardware).

Provided technical support to legacy system while company begins new ERP system (SAP) implementation. Completed large backlog of production support requests. Assisted with master data cleansing for conversion. (Epicor Dataflo v5.9.6, Universe V11.2.3 database, HP RX3600 Itanium hardware).

Developed custom software solutions for JobBOSS customers located in US. Developed proposals for customer requests and upon acceptance, developed and delivered the solutions. Provided monthly billing, project tracking, and revenue forecast to development lead for CRM system. (JobBOSS 11.12, Crystal Reports 2016, SQL Server database, Synergy CRM, VBScript, HTML)

SICK, Inc.Implemented custom changes, performed administration tasks, responded to user tickets, and provided support to large international multiplant ERP system. Supported system integrations with MS Dynamics CRM, SmartZone Premier FTZ, Optio forms, and Clippership. (Epicor Dataflo v5.9.6, Universe database 10.2.11, HP Itanium rx3600 server).

Supported legacy system while working with business teams to prepare data for migration to Oracle R12. Performed system administration tasks, resolved production problems, completed software change requests in Sarbanes-Oxley environment. Supported interfaces to EDI, Accellos WMS, AWWebStore, AWForms, and AWMail systems. Work remote and onsite. (Epicor Dataflo v5.9.6, Universe database, Windows server).

Worked on requests from multiple plant locations. Projects included data extracts, reports, triggers, web service support, financial audits, and application software modifications. Provided production support and system administration. (Primac rev10B on Unidata/IBM RS6000, Java

Performed work on a project basis. Created utilities to automate manual processes. Worked with users to reproduce legacy reports and functionality. (Storis 8.6 on Unidata/IBM RS6000

Wrote applications on large Unidata system to support IT needs of external clients. Developed web maintenance screens with interfaces to Unidata programs, import routines to process external data, produced formatted rebate information for external print vendor. Utilized SDLC for all projects. (mvInternet, HTML, Unidata 6.0/IBM RS6000

Assisted with report modifications in preparation for a system conversion from Dataflo to Vantage. Utilized Crystal Reports, XML, BAQ, and Report Data Definitions and Report Styles (Crystal Reports 11, Epicor Vantage 8.0.3

Performed work on a project basis. Created utilities to rebuild bill of operations. Minor system administration. All work done remotely. (Dataflo 5.8.5 on Unidata/HP-UX HP9000)

Migrated this spinoff company to their own server and Dataflo software hosted remotely by a third party. Performed system administration and developed custom applications specific to their business needs. Interfaced Dataflo with the UPS Worldship application. (Dataflo 5.8.5, Unidata, HP9000 hardware

Provided technical instruction to IT staff on the use of the Epicor Dataflo software tools and system administration. Completed user change requests (Epicor Dataflo software v5.4, Unidata database, HP9000 hardware

Developed interfaces between Lotus Notes Domino application and ERP system to automatically create sales order and shipments for field service. Provided technical assistance to identify source of report data. Helped resolve yearend costing issues on the system. (Dataworks v4.3, mvEnterprise, Compaq hardware

Wrote Infoflo and System Builder applications to support the distribution, sales, returns, requirements planning, and accounting programs for the business (Epicor Infoflo v7.0, SB+, Unidata/HP9000). Developed processes to extract specific data fields from Unidata database and format the data into flat files with header, trailer, and detail records. Data was written to Unix directories where ftp would transfer data to user destination. Utilized project life cycle, release delivery management procedures, and PVCS. Majority of project work and communications performed remotely with travel to client site as necessary.

Designed systems to support the inventory, operations, job costing, accounting, forecasting, and distribution modules for the printing business (Primac rev10B on Unidata/DataGeneral- Aviion). Migrated new divisions to system through data conversion and developed custom reports and applications to support their unique processes.

Produced an executive document summarizing the state of the information systems. Identified gaps and provided recommendations for improvement. Surveys and interviews were conducted with all areas of management and key employees (Revelation

Converted PICK applications from Sequoia (Pick/OA) machine to RS6000 (AIX/mvEnterprise) machine. Created an automated electronic chargeback process. The conforming transactions were automatically applied to the accounts. The exceptions populated a queuing system for the user to process individually. Developed a merchandise return restocking fee application generating $1M annually. Converted 9-track tape processes to FTP applications for external vendors. Worked on multiple teams to develop client-server applications (PowerBuilder, Oracle, Informix, and PICK

Converted the 1000+ user Comtec HMO system from Amdahl hardware with Ultimate operating system to IBM RS6000/AIX with Unidata database. Modified software applications for optimum performance on new operating system. Relocated application development department from Dallas to Minneapolis. Provided remote/onsite business and technical support to 18 HMOs nationwide (Unidata/Universe/Comtec MHC software). Converted HMO membership and claim data to flat files for COBOL system when US Healthcare acquired Aetna Health Plans. Accurately estimated and applied resources to projects and managed team efforts to ensure timely implementation of enhancements. Managed a staff of 16 full-time and contract employees. Created software release delivery and defect management procedures.

Developed programs and performed maintenance on applications for mail order catalog business (System Builder/ Unidata / RS6000 / AIX

Designed and coded Unidata programs for mail order fulfillment applications (Unidata/ HP9000

Worked on a team to convert a COBOL database to the client PICK system (Sequoia/PickOA

Developed PICK DataBasic programs to support the manufacturing, engineering, material requirements planning, and accounting applications for the railroad division (DataWorks on NCR). Eliminated a large backlog of programming requests. Created Unix scripts and NFS interfaces between MRP and CAD systems to share vital data. Automated the monthend accounting batch processes.

Developed DataBasic programs in Primac for sales reporting applications.

Managed computer operations and hardware support. Wrote PICK programs to support applications for the mail order catalog company (TOPS on General Automation, Stratus/VOS, Sequoia/PickOA). Participated in vendor selection for new hardware/software purchases. Upgraded the hardware and software numerous times to keep pace with rapid growth of business. Worked with vendor (Fair Isaac) to design the necessary file layouts and processes required to populate a customer-modeling database for predicting consumer behavior and sales potential. Data was extracted from Pick machine and formatted into flat files. Database was located at vendor facility on IBM mainframe and used to produce customer lists for catalog mailings. Performed address standardization and customer de-dup using Group 1 software. Created automated PC download applications to feed marketing database with catalog and sales data using Smarterm.

Developed COBOL programs for legacy agri-business (Harvest States) applications. Used TSO, Xpeditor, and Panvalet tools.

Developed PICK Basic / Pick RPL programs for (Hoffman) manufacturing applications (SMI software, Ultimate O/S, Honeywell DPS6, Intermec / IRL). Converted Pick MRP system to Cullinet MRP software on IBM 3090 MVS/ESA with IDMS/R database using TSO, COBOL, ADSO, and Culprit; Data was transferred to new platform by mapping the Pick data to a flat file format and writing data to 9-track tape.