Previous Job
Previous
DTMB-IT- Customer Service
Ref No.: 15-00413
Location: Lansing, Michigan
DTMB
6 Months Approx.
Lansing, MI
Position Description The Application Software Engineer (ASE) will perform analytical programming assignments pertaining to the development, enhancement and maintenance of reports and integration packages and procedures in a CRM Dynamic environment. The position also involves the utilization of project management and systems design in a technical development environment. The ASE will need to be familiar with SQL, SSRS and SSIS languages. The ASE will need to understand the strategic direction of the Michigan Department of Corrections (MDOC) and the supporting IT systems and architectures. The ASE is responsible for adhering to state of Michigan standard development methodologies - the State Unified Information Technology Environment (SUITE), Systems Engineering Methodology (SEM), and Project Management Methodology (PMM). The position also involves the utilization of project management and systems design in a technical development environment.  
Skills Required Skills Required The Application Software Engineer must have the following skills and expertise: 1. Application Software Engineer with 8 or more years of demonstrable working experience in application software design, development, and implementing of medium-to-large scale applications. 2. The ability to work with a technical team and business experts in: a. analysis and design of reports and integration packages in a CRM Dynamics environment, b. The ability to translate complex business into complex queries and stored procedures in T-SQL, c. Experience with Microsoft Azure and Service Bus for Windows, d. Development, testing, debugging and SSRS reports and SSIS packages, e. Experience integrating two disparate systems e. Ability to execute and validate test plans for reports, f. Use programming knowledge to design and develop complex stored procedures and reports, g. Excellent written and oral communication skills.  
Skills Preferred Skills Preferred The Application/Software Engineer is preferred to have the following skills and expertise: a) Expert Skills Visual Studio 2012 b) Expert in writing complex queries and stored procedures in T-SQL c) Expert in writing reports with SSRS. d) Experience managing source code via Team Foundation Server e) Experience with Microsoft Azure and Service Bus for Windows.  
Experience Required Experience Required The Application Software Engineer must have the following experience: a) Application Software Engineer with 8 or more years of demonstrable working experience in application software design, development, with SSRS and SSIS experience. b) Eight years' experience programming in client/server applications c) Five years' experience analyzing business requirements, generating project specifications and in turn developing code, and applying knowledge of computer programming techniques and computer languages d) Five years unit testing and performing peer reviews of developed code to insure conformity to standards and design best practices. e) Five years' experience programming in SQL and/or Transact-SQL. f) Five years' experience with SSRS and or SSIS. g) Two years' experience with Azure and Service Bus h) Three years creating reports for Microsoft Dynamics i) Expert level skills in MS Project, MS Excel, MS Word, MS PowerPoint  
Experience Preferred Experience Preferred The Application Software Engineer is preferred to have the following experience and expertise: a) Minimum five years' experience, developing stored procedures using SQL, in an enterprise environment. b) Minimum five years' experience developing SSRS reports and SSIS packages. c) 3 years' experience writing reports in a CRM or like type environment.  
Education Required Education Required This position requires a Bachelor's Degree in Computer Science, Information Systems, or other related field.  
Education Preferred Education Preferred Microsoft Certified DBA 2008 or higher Microsoft Certified Database develop 2008 or higher  
Additional Information Database Server Hardware and Software Server: Physical server – Dell Poweredge R620, 2 processors, 8 cores, 2.4 Ghz, 256GB RAM Operating System: Windows 2008 R2 Database: SQL Server 2012 Network Protocol configurations include TCP/IP using Windows 2003 and Windows 2008 R2 servers. Desktop Workstations PCs using Windows XP, Windows 7 and Windows 8 Locations Approximately 10,000 workstations distributed at approximately 200 locations across Michigan. Development Tools Dynamic CRM 2013 SQL Server 2012 Visual Studio 2012 SSRS SSIS Scribe InRule Browser Internet Explorer 9.0


Skills:
Bachelor Degree
Design, Dev, Implement med-large scale applications: 8 years
translating info into transact sql: 2 years
Analysis & Design of reports in CRM Dynamics: 2 years
Dev, Testing, Debugging, SSRS reports & SSIS packages: 2 years
Microsoft Azure: 1 year
Microsoft service bus: 1 year