Job Seekers, Please send resumes to resumes@hireitpeople.comShort Description: Plans, develops, tests, and documents computer programs, applying knowledge of programming techniques and computer systems.
Complete Description: * 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 |
