Portfolio Category: Process Design and Implementation

State Government

State of Arkansas (Department of Workforce Services)                          

Little Rock, AR (USA)

Feb. 2010 – Aug. 2010

System Migration

Business Analysis – ERP Implementation (GP 2010)   

Migration ERP systems from COBOL, AS400, Excel and Access into a new GP 2010 install using VB.NET and SQL Server 2008

Business Analysis Processes

Business analysis processes to understand current systems and business processes and translate to a fit-gap / requirements document and assisted with the procurement and implementation of GP 10 and other 3rd party add-in modules.

Customization of GP 2010 using VB.NET, dexterity, E-connect and SQL Reports (SRSS)

Wireless and Telecom

Deliverables and Services Provided

Ask me for a sample of project deliverables to major Wireless Corporation in the Midwest United States.

Upgrade and Custom Integrations

Support and upgrade Wennsoft (TimeTrack, Job Cost), Replicon and all 3rd party GP products

Support and upgrade GP 2013

Integrations to cloud-based time management software and other systems integration, including complex report designs using SRS and .net integrations to GP.

Create custom SQL integrations to load project / job data into Wennsoft from AT&T /Verizon systems. SQL development to stage and integrate data from various host systems to and from Great Plains (GP).

Design new SRS reports using GP and Wennsoft tables. Understand all Dynamics and Wennsoft table structures (1500+ tables) in detail including fields and purpose.

Scribe and Smart Connect integration work, EDI from cloud solutions and mainframe into GP database.

Customize GP using VB to change functions of the various windows, create complex routines to split labor data from one job to many jobs based on algorithms required by the client.

Customization and integration work using smart connect, VBA, .net with cloud based applications to integrate payroll to job cost, project accounting and other modules.

SQL 2012 development of custom stored procedures for automating user tasks, processes and reporting.

GP 2010 to GP 2015 upgrade. Planning for AX conversion after Nokia acquisition. Data conversion and mappings to AX from GP.

Finance and Accounting

Auto-reconciliation tools built for AR/AP/Accrued Purchase/Inventory to reconcile the GL balance sheet accounts to related A/R modules to improve month-end close processing time.

Custom financial reporting for month-end, percent of completion reports, and other finance-related reporting.

Manufacturing and project accounting for construction projects. MRP for planning materials and lead times, custom .net application written to replace the MRP module for the highly customized need.