Previous Job
Previous
Programmer Analyst 5
Ref No.: 16-00627
Location: Lansing, Michigan
Client: Michigan Department of Corrections
Location: Lansing,MI
Duration: 4+ Months
Agency Interview Type: In Person Only


Job Description:
Plans, develops, tests, and documents computer programs, applying knowledge of programming techniques and computer systems.
* There is a strong possibility that this position will be extended

Position Description
The Programmer Analyst 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 P/A will need to be familiar with SQL, SSRS and SSIS languages. The P/A 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.    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,
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)    Two years' Experience with CRM Dynamics utilizing SSIS
i)    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.  

Years of Experience:
Advanced experience in the IT industry and as a programmer analyst.

Job Description:
Includes descriptions detailed earlier as well as programmer analyst experience in specialized IT technologies which may not be widely used or are new to the industry.

•Plans, develops, tests, and documents computer programs, applying knowledge of programming techniques and computer systems. Evaluates user request for new or modified program, such as for financial or human resource management systems, clinical research trial results, statistical study of traffic patterns, or analyzing and developing specifications for bridge design, to determine feasibility, cost and time required, compatibility with current system, and computer capabilities. Consults with user to identify current operating procedures and clarify program objectives. Formulates plan outlining steps required to develop program, using methodologies such as structured analysis and design or object-oriented development.
•Work involves assisting in analyzing systems outlines to develop programs for computer applications, writing solution programs, documenting the methods and procedures used in program development, and testing and correcting programs. Works under moderate supervision with limited latitude for the use of initiative and independent judgment. Develops block diagrams and machine logic flowcharts to represent operations and data flow for applications.
•Captures requirements using industry standard development frameworks and tools. Designs reports, forms and letters along with computer terminal screen displays to accomplish goals of user request. Reviews screens, reports, forms and letters designs with users. Converts project specifications, using industry standard tools, such as object-oriented tools and code generation, into sequence of detailed instructions and logical steps for coding into language processable by computer, applying knowledge of computer programming techniques and computer languages.
•Enters program codes into computer system. Enters commands into computer to run and test program. Reads computer printouts or observes display screen to detect syntax or logic errors during program test, or uses diagnostic software to detect errors. Replaces, deletes, or modifies codes to correct errors. Analyzes, reviews and alters program to increase operating efficiency or adapt to new requirements. Writes documentation to describe program development, logic, coding, and corrections. Writes manual for users to describe installation and operating procedures. Assists users to solve operating problems. Recreates steps taken by user to locate source of problem and rewrites program to correct errors. May use computer-aided software tools in each stage of system development. May train users to use program. May oversee installation of hardware and software. May provide technical assistance to program users. May install and test program at user site. May monitor performance of program after implementation. May specialize in developing programs for business or technical applications.
 
Skill
Required / Desired
Amount
of Experience
 
8 or more years of demonstrable working experience in application software design, development, with SSRS and SSIS experience
Required
8
Years
Two years' Experience with CRM Dynamics utilizing SSIS
Required
2
Years
Five years' experience programming in SQL and/or Transact-SQL
Required
5
Years
Experience with Microsoft Azure and Service Bus for Windows
Required
1
Years
The ability to work with a technical team and business experts in Development, testing, debugging and SSRS reports and SSIS packages
Required
1
Years
Five years unit testing and performing peer reviews of developed code to insure conformity to standards and design best practices
Required
5
Years
Ability to execute and validate test plans for reports
Required
1
Years
Use programming knowledge to design and develop complex stored procedures and reports
Required
1
Years
Expert Skills Visual Studio 2012
Desired
1
Years
Expert in writing complex queries and stored procedures in T-SQL
Desired
1
Years
Expert in writing reports with SSRS
Desired
1
Years
This position requires a Bachelor's Degree in Computer Science, Information Systems, or other related field.
Required
 
 
 
 
Questions
 
 
Description
 
Question 1
Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2
Please list candidate's email address that will be used when submitting E-RTR.
Question 3
This position is located in downtown Lansing, MI. The selected candidate will be responsible for any and all costs associated with parking for this position. These costs will not be reimbursed by CAI or State of Michigan. Please confirm you have discussed this with your candidate and he/she accepts this requirement.
Question 4
The client plans to schedule interviews for this position May 31 or June 1. Please confirm your candidate will be available to interview any of those days if selected.