Previous Job
Previous
Application Software Eng Reporting Specialist
Ref No.: 14-01536
Location: Lansing, Michigan
DTMB-IT- Customer Service
Lansing, MI
10 months
US Citizen Only


 
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 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. Development, testing, debugging and SSRS reports and SSIS packages. c. Ability to execute and validate test plans for reports, d. Use programming knowledge to design and develop complex stored procedures and reports. e. Excellent written and oral communication skills  
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  
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. h) Three years creating reports for Microsoft Dynamics g) Expert level skills in MS Project, MS Excel, MS Word, MS PowerPoint  
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 This position requires a Bachelor's Degree in Computer Science, Information Systems, or other related field.  
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
Application Design/Dev: 8 years
SRSS & SSIS exp: 5 years
exp in SQL and or Transact-SQL:5 years 
Creating reports for Microsoft Dynamics: 3 years
Bachelors Degree: Bach Deg in Comp Science, Info Systems