Job Seekers, Please send resumes to resumes@hireitpeople.com System Specialist needed to help develop interface conversions from other systems at the City of Columbus Auditor's office to the Microsoft Dynamics AX format.

The City of Columbus Auditor's office is seeking a System Specialist econsultant to assisting in  developing interface conversions from other city systems such as Payroll, Tax, Water to Microsoft Dynamics AX format.   The consultant will be assisting the Auditor's office to analyze, format, and develop the processes for Microsoft Dynamics 2012 AX.    There is a framework for converting the values in place. Sources are flat text files, EXCEL and Oracle. Conversion objects are in Oracle PL/SQL and we are planning on using toolsets like Monarch Desktop/Modeler which can combine,  lookup, and merge/transform disparate data sources.     We may also use  SQL Server and potentially use SQL Server Integration Services move, link and or import them into DB and convert them.

The successful candidate will have the following skill sets:
T-SQL
SQL Server
SQL Server Integration Services (SSIS)
Visual Studio
C#
VB.NET
Monarch
Oracle PL/SQL
SSRS
Management Reporter

We are also seeking desired skill sets of :
Inbound/outbound Dynamics AX Integration frameworks are AIEF & DIEF and are specific to the Dynamics AX ERP system
Language used in Dynamics AX is X++ (it is a lot like C#)
SSRS & Management Reporter reports would need to know Dynamics AX 2012 table structures

System Specialist
The System Specialist is knowledgeable on the usage and support of a collection of development platforms or technical architectures, and products that run on those platforms. The primary responsibility of a System Specialist is to ensure the availability and facilitate the productive use of a development platform or a test environment for Application Teams or end users. The System Specialist may support one or several instances of a platform/environment, applying their skills directly to a platform/environment and/or leveraging their skills across multiple platforms/environment. The System Specialist may, especially for usage and support of a platform, be part of an Application Team using the architecture. The System Specialist requires experience and skills in the environment supported and in the operations and in common usage of products for the environment The System Specialist are responsible for collaborating with Technical Architecture Specialist, Functional Architects, Programmers and vendors to coordinate and enhance the use of the platform and facilitate migration to new versions of the platform.

5 plus years in desired environment
4 year college degree or technical equivalent
All roles specified in SS3 and the following are the skills tab



Required / Desired SkillsSkillRequired / DesiredAmountof Experienceall roles and responsibilities as outlined in SS3 plus the following Required6YearsFour year college degree or equivalent technical study Required4YearsExperience with developing interface conversions from other systems Required5YearsExperience with developing scripts for conversion in C# and/or VB.NetRequired4YearsExperience with T-SQL, SQL server Required5YearsExperience with VB.Net /and or SQL for DB queries Required4YearsExperience with Oracle PL/SQL Required5YearsExperience with SQL Service Integration Services (SSIS) Required4YearsExperience with Visual Studio Required4YearsExperience with Monarch desktop/Modeler Required2YearsExperience with Management Reporter Highly desired2YearsExperience with MS Dynamics AX 2012 table structuresHighly desired2YearsExperience with core MS Dynamics development tools including X ++ Highly desired1YearsExperience with inbound/outbound Dynamics AX integration frameworks ; AIEF & DIEFHighly desired1YearsExperiennce with Dynamics AX ERP systems Highly desired1YearsExperience in City Government financial systems; payroll, tax , water etc Highly desired1YearsAble to work independently /and /or with a team Required4YearsExcellent communication skillsRequired