A. Brief Description of Work The primary focus of this assignment will be working with DIT and MDOT to re-architect the Local Agencies Payment Management System (LAPMS) and the Design Plan Evaluation (DPE) PowerBuilder / Enterprise Application (EA) systems to the Microsoft .NET / C# architecture. B. Background on the work requested The DIT and MDOT requires the services of a senior programmer-analyst and programmer analyst to assist the Operations Systems Section (OSS) with the TEAM project. The applications involved with this ITB are critical to the MDOT Design Division and are becoming increasingly unstable as changes to the configuration occur. Re-architecting these applications to a contemporary and maintainable architecture is a high priority for the MDOT. Additionally, maintenance and operational support of the department’s .NET systems will be required on an on-going basis. C. Objectives Listed below are specific projects expected to be accomplished within this contract. Amendments may be made as needs change throughout the realm of the contract :
- Re-architect LAPMS and DPE to the
- Mentor OSS personnel in the construction and maintenance of the re-architected systems
- Provide on-going maintenance and operations support for .NET applications as directed by the OSS Manager D. Agency technical environment for the work The department’s computing standards and policies can be viewed at : E. Description of the requested work, including deliverables and knowledge transfer The scope of work associated with this project follows the DIT SUITE and OSS Maintenance and Operations Methodologies. This covers the entire software life cycle to include initiation, requirements, analysis, design, construction, test, implementation, and closeout. This project will not include governance or management. TASKS : Technical support is required to assist with the following tasks (In a development, QA and production environments) :
- Requirements Elicitation
- Requirements Dependency Analysis and Estimation
- Business and Technical Modeling
- Business and Technical Design
- Architecture Configuration
- Application and Server Code Development
- QA / Testing
- Release Implementation
- In-Stage and Peer Reviews
- Maintenance and Operations Support DELIVERABLES : Deliverables will not be considered complete until the Agency Project Manager has formally accepted them. Deliverables for this project include :
- Task Analysis and Effort Estimates
- Business Use Case Documents
- Feasibility Statements
- Requirements Traceability Matrix
- Unified Modeling Language Diagrams
- Business and Technical Architecture Models
- Functional and Systems Design Documents
- System Impact Document
- Application and Server Code
- Data Conversion Matrix
- Usability, Unit, Security, Integration, System, and Acceptance Test Plans
- Test Case Scripts
- Release Notes
- User, Training, Systems Administration and Maintenance Guides
- Installation Checklist
- Issue Log Entries F. Any specific regulations, requirements or expertise applicable, including specific background / security checks required. All prospective contractors will be required to pass background and security clearance prior to the start date of this contract. G. Reports Required The Contractor must submit written bi-weekly summaries or progress reports that outline work accomplished during the reporting period, work to be accomplished during the subsequent reporting period, if known; problems, real or anticipated, which should be brought to the attention of the MDIT Project Manager and notification of any significant deviation from the previously agreed upon work plans. All areas of decision making that pertain to this contract must be reviewed in detail with the MDIT Project Manager and Bureau Automation Manager (BAM) prior to any final decision. H. Location where the work is to be performed : Work is to be performed in the Van Wagoner Building, Lansing, MI 48909. Meetings / work may take place at other Lansing and Detroit Metro area office locations. I. Hours Monday through Friday; 8 : 00 : 00 J. State’s contract / project manager for the work W. Steve Wensko Department of Information Technology Agency Services / MDOT Operations Systems Van Wagoner Building / 1st Floor 425 W. Ottawa Street Lansing, MI 48909 517.335.2401 Office phone wenskos@ K. The number of personnel by skill set One (1) Programmer – Analyst Senior (not to exceed rate $85.00) Programmer-Analyst capabilities with 8 or more years of experience, relies on experience and judgment to plan and accomplish goals, performs a variety of complicated tasks, may lead and direct the work of others, may report directly to a project lead or manager, a wide degree of creativity and latitude is expected. 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 system, 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. Reads manuals, periodicals, and technical reports to learn ways to develop programs that meet user requirements. Formulates plan outlining steps required to develop program, using structured analysis and design. Submits plans to user for approval. Prepares flowcharts and diagrams to illustrate sequence of steps program must follow and to describe logical operations involved. Designs computer terminal screen displays to accomplish goals of user request. Converts project specifications, using flowcharts and diagrams, 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, such as flowchart design and code generation, 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. Additional Requirements (highly desirable and high priority). Please document these requirements in the work experience sections of the resume. Preference will be given to actual work experience and not bulleted summaries.
- Documented 8 years (in experiential section of resume, not “summary area”) experience developing complex computer systems using Microsoft Visual Studio.
- Documented 3 years (in experiential section of resume, not “summary area”) experience architecting Microsoft .NET solutions.
- Documented 3 years (in experiential section of resume, not “summary area”) experience programming in Microsoft .NET / C#.
- Documented 5 years (in experiential section of resume, not “summary area”) experience programming in SQL and / or PL / SQ against an Oracle back-end.
- Documented 5 years (in experiential section of resume, not “summary area”) participating as a programmer / analyst in projects using CMM / CMMI Level 3 methods and practices One (1) Programmer – Analyst (not to exceed rate $55.00) 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 system, 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. Reads manuals, periodicals, and technical reports to learn ways to develop programs that meet user requirements. Formulates plan outlining steps required to develop program, using structured analysis and design. Submits plans to user for approval. Prepares flowcharts and diagrams to illustrate sequence of steps program must follow and to describe logical operations involved. Designs computer terminal screen displays to accomplish goals of user request. Converts project specifications, using flowcharts and diagrams, 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, such as flowchart design and code generation, 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. Programmer-Analyst capabilities with 1-7 years of experience, relies on experience and judgment to plan and accomplish goals, performs a variety of complicated tasks, may lead and direct the work of others, may report directly to a project lead or manager, a wide degree of creativity and latitude is expected. Additional Requirements (highly desirable and high priority). Please document these requirements in the work experience sections of the resume. Preference will be given to actual work experience and not bulleted summaries.
- Documented 5 years (in experiential section of resume, not “summary area”) experience developing complex computer systems using Microsoft Visual Studio.
- Documented 3 years (in experiential section of resume, not “summary area”) experience programming in Microsoft .NET / C#.
- Documented 3 years (in experiential section of resume, not “summary area”) experience programming in SQL and / or PL / SQ against an Oracle back-end. L. Start and End Dates for the Work : September 4, 2007 through September 30, 2010