Midcontinent Communications (A ComCast company)
Sioux Falls, SD (USA)
2007 – 2013
Dynamics GP Functional/Technical Lead
Upgrade and Conversion
Upgrade from GP 8 to GP 10 and GP 10 to GP 2010
Data migration from obsolete 3rd party modules to new modules; including data mapping, test plans, and creation of user manuals.
Dexterity customizations to GP’s payables and financial modules to integrate 3rd party billings and to integrate GP with the AS400 Cable Billing System.
Customer Reports include:
- Inventory turns versus on hand
- Custom trial balances
- Custom balance sheet – P&L
- Income statements in Excel,
- PO’s overdue
- HR reports on statistics and user activity
Microsoft CRM 4.0 with Scribe integrations to GP for marketing and customer service tools for business development , TV advertisers and sales reps.
Led the implementation of Acellos bar-code software to change from a manual picking, packing, and receiving process to an automated process, saving an estimated seven staff persons or about $210,000 per annum with process re-engineering.
Custom programming using Modifier, VBA, VB.NET, T-SQL, SRSS and Crystal Reports to customize GP 10 to enforce business rules, create applications or enhance the experience.
Manage SQL Server 2008, including database backups, admin, upgrades, service packs as well as create Stored Procedures in T-SQL, views, tables and SQL Reports.
Daily functional technical support for a 90-user community in all modules (listed at right margin). Troubleshoot and problem solving of general errors, financial misbalancing problems, inventory issues and more.
Support Doclink document imaging and workflow system, integrated to the payables module.
Created requirements and functional specifications documents for custom software development work within GP.
Reporting and Management
Projects include constructing a capital reporting workflow, expense reporting tool for all departments and financial / inventory and sales analysis reports.
Development of Full life-Cycle GP processes from year-end closings, fiscal year-end closings, setup of all modules listed, and maintenance of the system with service packs and hotfixes.
Implementation of bar-code software and wireless terminals for inventory management and serialization to increase order fulfillment and receiving accuracy and speed.
Customer Reports include: inventory turns versus on hand, custom trial balances, custom balance sheet, and P&L, income statements in Excel, PO’s overdue, HR reports on statistics and user activity.