Job Description :
any visa/tax term

Microsoft Dynamics AX Consultant

Location: Remote/Telecommute

2 years+

Essential Duties and Responsibilities:

Leverage understanding of Microsoft Dynamics AX 2012 R3 to drive
functional improvements and identify areas for process development
Hands-on configuration experience of Dynamics AX Finance,
Order-to-Cash, Procure-to-Pay, production, transportation and advance
warehouse management modules

Develop work instructions and business process flows
Coordinate and facilitate system, integration and users acceptance
test
Troubleshoot, diagnose and repair issues with Microsoft Dynamics
AX, SharePoint and Microsoft SQL server

Monitor, manage and provide functional and technical support for AX help
desk requests, email requests, phone requests, etc.
Deal with any support issues raised by users. Can be relatively simple to
resolve, requiring just an email response, or very complex requiring
assistance from time to time from Blue Horseshoe with whom we have a
support agreement in place. Most relate to the processing of POs, sales
order or production orders where transaction issues cause the user to get
stuck. Can also involve printing issues, problems with data, etc. Users can
be questioning the data on a particular form/report which then needs to be
researched and verified. Under normal circumstances if a reported issue
requires programming modifications to resolve (AX/Cognos), I identify the
changes required and submit these for approval. I then make the mods in Dev
and promote to Test. Users will test and approve and project is then
scheduled for next deployment to Production.

Deployments to Production prep of AX Staging environment followed by
production installation. Typically occur on the weekend so as not to
disrupt the warehouse operations.

Refresh of AX Dev/Test environments and Cognos Test from Production.
Cognos budget upload this involves backing up the Cognos database,
prepping a series of SQL Insert statements for rows on budget spreadsheet
sent by users, removing the current budget entries, then executing these
Insert statements on SQL02 using a transaction template. Data is
validated against their spreadsheet.

Salesgroup reassignments from time to time the users request that an
account be reassigned from one salesgroup to another. When this occurs they
are responsible for updating the customer master and all open orders as
well as running any commission reports needed before the reassignment is
complete. Once that has occurred, then IT is responsible for reassigning
the sales history in both AX and Cognos, and the budget in Cognos to the
new salesgroup. The users provide the details (customer, from/to
salesgroup, budget year) and I construct a series of sql EXEC statements to
run a stored procedure over the database that will update the relevant
tables in AX and Cognos. It can vary from a few accounts to ouple of
hundred.

Sales pricing updates I generate an extract of active sales pricing using
a SQL query and distribute to the pricing team. They work through the data
and in return provide spreadsheets of trade agreements to a) expire and b)
create in a format required for upload through Atlas. We check the format
and data looks ok and then perform the upload. The journal created is then
validated and posted by the users. The expiry of TAs occurs first, followed
by the creation of the new TAs.

Ad-hoc SQL queries/reports requested by users generated using SQL queries.
Some are repeat requests e.g. Stone Brewing invoice reports, item min/max
coverage reports. Others are one-off requests e.g. journal reports
requested by auditors, specific customer sales data. The reports can range
from a straightforward simple query to more complex summaries that require
the use of temporary tables to retrieve and format the data required.
Waypoint extract on a monthly basis I run the Waypoint data extract (from
menu option on Sales & Marketing), place the resulting files on the
Waypoint FTP server and provide opy of the WPSalesInvoice file to Jena
Piscitelli.

Maintain the SXWSALES database and monitor the daily jobs. Investigate any
data queries raised by users.