REALTOR

• Feb 2019 - Present

Senior Business Systems Analyst - contractor

• Sep 2002 - Present

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).

Senior Programmer / Analyst - contractor

• Jan 1999 - Present

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)

Business Owner

• Apr 1997 - Present

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. 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.

Senior Programmer / Analyst – contractor

• Nov 2016 - Mar 2018

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). 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).

Authorized independent contractor

• May 2016 - May 2017

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) 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)

Senior Programmer / Analyst - contractor

• Nov 2011 - Dec 2012

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). 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).

Senior Programmer / Analyst - contractor

• Sep 2009 - Jun 2011

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 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

Senior Programmer / Analyst - contractor

• Sep 2009 - Jun 2010

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 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

Senior Programmer / Analyst - contractor

• Jan 2009 - May 2009

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 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

Senior Programmer / Analyst - contractor

• Jan 2009 - Apr 2009

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 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

Programmer/Analyst - contractor

• Oct 2008 - Feb 2009

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) 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)

Senior Programmer / Analyst - contractor

• Jun 2006 - Jul 2007

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 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

Senior Programmer / Analyst - contractor

• Nov 2002 - Dec 2005

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 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

Senior Programmer / Analyst - contractor

• Apr 1999 - Jul 2002

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.

IT Consultant - contractor

• Feb 2000 - May 2000

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 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

Senior Programmer / Analyst - contractor

• Feb 1997 - Dec 1998

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

Business Systems Manager

• Nov 1993 - Feb 1997

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.

Senior Programmer / Analyst - contractor

• Mar 1995 - Sep 1995

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

Senior Programmer / Analyst - contractor

• Jun 1994 - Mar 1995

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

Senior Programmer / Analyst

• Dec 1992 - Nov 1993

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 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.

Programmer - contractor

• Nov 1992 - Jan 1993

Developed DataBasic programs in Primac for sales reporting applications. Developed DataBasic programs in Primac for sales reporting applications.

Programmer / Analyst

• Feb 1989 - May 1989

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

Programmer / Analyst

• Jan 1985 - Feb 1989

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. 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.