Task 1:

Prepare system documentation to include

• Relational Schema (Database diagram)
• Entity-Relationship Schema (Database dependency diagram)
• Written documentation, in an MS Word format, on each of the 368 tables and the 698 stored procedures describing:
  • The exact table structure
  • What the stored procedures are doing to the data
  • How and in what order these stored procedures are called to perform a specific application function by the web pages

• Documentation of all 255 web pages, including their function and the stored procedures and other functions that they call and their purpose.

Task 2:

Provide an electronic copy of all the system documentation outlined in Task #1 into the provided shared drive on the Network, as well as a 3-hole punched hard copy of the same.

Task 3:

Participate in a 4-hour review session with the current developer and the IT Lead to review the documentation for accuracy and knowledge transfer. Required knowledge, skills and abilities:

• Experience in development using C# and Experience in development using C# and ASP.NET (with a SQL Server 2012 backend).
• Experience in building and documenting Relational Schemas (Database diagram)
• Experience in building and documenting Entity-Relationship Schemas (Database dependency diagram)
• Knowledge of and ability to develop and test code, document, and resolve problems.
• Ability to design and program web-based data entry and results reporting applications.
• Knowledge of VB 6.0, VBA, Knowledge of VB 6.0, VBA, VB.net, JAVA/JavaScript, ASP.Net, ASP, or Transaction Server.
• Database design and implementation skills and experience (SQL/T – SQL).
• Knowledge of data security systems and protocols.
• Experience with software tools such as Excel 2003, Access 2000, Access 2003, and Visual
• Basic to create data entry screens and to build data sets.

Deliverables and Milestones:

Create task summary report showing hours worked. The task summary report shall contain the following:

• Brief description of requirements for that month.
• Brief summary of accomplishments and delays during the reporting period and significant events.
• Any current or anticipated problems and possible solutions.

If you do not find interest in this opportunity but know of someone who may, we kindly ask that you refer the individual to RWD Consulting, LLC by forwarding this job posting.