Title - Application/Software Engineer - Level 3 (Application Software Eng Reporting Specialist)
Location - Lansing MI
Duration - 12 months
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:
- 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.
- 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.
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.
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
QualificationsEducation 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 InformationIf you have any queries regarding the requirement contact sathish balla @ 734-357-8988 or drop a email sathish dot balla at tekwissen .com
Skills Required
- Bachelor's Degree in Computer Science, Information Systems, or related field
- 8+ years application software design and development experience (medium-to-large scale applications)
- Experience with Dynamics CRM (CRM Dynamics) for reports and integration packages
- Experience developing, testing, debugging SSRS reports and SSIS packages
- 5+ years programming experience in SQL and/or Transact-SQL, including complex stored procedures
- 5+ years unit testing and performing peer code reviews
- Ability to execute and validate test plans for reports
- Familiarity and adherence to State of Michigan development methodologies (SUITE, SEM, PMM)
- Excellent written and oral communication skills
- Expert-level skills in MS Project, MS Excel, MS Word, MS PowerPoint
- Experience programming client/server applications (8 years mentioned)
- Expert skills with Visual Studio 2012
- Expert in writing complex queries and stored procedures in T-SQL
- Expert in writing reports with SSRS
- Experience managing source code via Team Foundation Server
- Microsoft Certified DBA 2008 or higher / Microsoft Certified Database Developer 2008 or higher
What We Do
STEM Xpert is a consulting engineering firm recognized in the engineering industry for its commitment to client service and passion for excellence. The firm provides specialized professional consulting services in the fields of science, technology, engineering, and mathematics (STEM).
