Unix SAS Developer

Document Sample
Unix SAS Developer Powered By Docstoc
					                                       Unix SAS Developer

I.     DESCRIPTION OF SERVICES
       The Department of Information Resources (DIR) requires the services of one Unix SAS Developer, hereafter
       referred to as Worker(s), who meets the general qualifications of ITSAC Developer 2 Category, Core Technology
       Type and the specifications outlined in this document for the Texas Education Agency (TEA).

       All work products resulting from the project shall be considered “works made for hire” and are the property of the
       TEA. TEA may include pre-selection requirements that potential Vendors (and their Workers) submit to and
       satisfy criminal background checks as authorized by the Texas law. TEA will pay no fees for interviews or
       discussions, which occur during the process of selecting a Worker(s).

       The project work involves migrating the Summary of Finance (SOF) mainframe SAS application and data files to
       run in a UNIX and or PC SAS environment. Day to day work assignments will be directed by the School Finance
       SAS team manager but must coordinated with the Information Technology Services (ITS) project manager. Work
       includes planning work to be completed by defined deadlines, updating and or rewriting SAS programs, making
       suggestions for program efficiency, developing test plans and testing to validate code and data results are correct
       and accurate, documentation of the new system, and other tasks assigned.

II.    WORKER SKILLS AND QUALIFICATIONS

       Minimum Requirements:
            Years           Skills/Experience
           4               Experience in analysis, design and development of SAS programs in a UNIX
                           environment. Work involves migrating MVS SAS to a UNIX environment. Work
                           will involve extensive modifications to update program data sources.
           4               Experience with SAS/base, SAS/Macros, SAS/SQL.
           4               Work experience and knowledge of Oracle (10g) and SQL Server databases,
                           schemas, tables, and elements and able to write simple to complex SQL code.
           4               Experience developing test plans and test to validate their own or other
                           developers SAS program results
           4               Work experience in updating or creating documentation of code and high level
                           systems documentation.
           4               Strong analytical, problem-identification and analysis skills with the ability to
                           envision a solution.
           Strong          Excellent communication skills both orally and in writing.
           Strong          Works well independently and as part of a team.


       Preferences:
            Years           Skills/Experience
           2+              Experience in migrating mainframe (MVS) systems to UNIX or PC SAS.
           2+              Basic and or Advanced SAS Certification Preferred
           2               Experience working with an automation tester to validate a large SAS processes'
                           results
           2               Experience with mainframe SAS and JCL

III.   TERM OF SERVICE
       Services expect to start approximately December 15, 2009 and are to be completed by May 31, 2010. Total
       estimated Worker hours shall not exceed 950 hours. This service may be amended, renewed, and/or extended
       providing both parties agree to do so in writing.
IV.   WORK HOURS AND LOCATION
      A. Services shall be provided during normal business hours unless otherwise coordinated through the TEA.
         Normal business hours are Monday through Friday from 9:00 AM through 5:00 PM, excluding State holidays
         when the agency is closed.
      B. The primary work location(s) will be at 1701 North Congress Avenue, Austin, Texas 78701. Any and all
         travel, per diem, parking, and/or living expenses shall be at the Worker’s and/or Vendor’s expense.
      C. TEA will provide pre-approved, written authorization for travel for any services to be performed away from
         the primary work location(s). Pre-approved travel expenses are limited to the rates and comply with the rules
         prescribed by the State of Texas for travel by its classified employees, including any requirement for original
         receipts.