Previous Job
Developer Analyst 3
Ref No.: 16-00541
Location: Austin, Texas
Client:  Texas Health and Human Services Commission (HHSC) Enterprise.
Location: Austin,TX
Duration: 3+ Months

Limit two (2) candidate resumes per vendor for this job.
Responses are due May 12, 2016 by 5:00 PM (CT). 

Services shall commence as soon as possible and shall be completed by August 31, 2016; 520 hours per worker (position to extend possibly 16 months up through 10/31/17).   This service may be amended, renewed and/or extended providing HHSC and Vendor agree in writing to do so.
The Department of Information Resources (DIR) requires the services of one Developer Analyst, hereafter referred to as Worker(s), who meets the general qualifications of ITSAC Developer Analyst 3 Category, Emerging Technology Type and the specifications outlined in this document for the Texas Health and Human Services Commission (HHSC) Enterprise.
All work products resulting from the project shall be considered "works made for hire” and are the property of the HHSC.  HHSC may include pre-selection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. HHSC will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s).

The Texas Health and Human Services (HHS) Enterprise is composed of the following five agencies:
Department of Aging and Disability Services (DADS)
Department of Assistive and Rehabilitative Services (DARS)
Department of Family and Protective Services (DFPS)
Department of State Health Services (DSHS)
Health and Human Services Commission (HHSC)
The HHSC Enterprise Applications IT area is preparing for a re-implementation of PeopleSoft Financials version 9.2 with a go-live on September 1, 2017 and is posting this position for PeopleSoft report developers. 
Currently, HHS has Accounts Payable, General Ledger, Purchasing and Asset Management from PeopleSoft Financials version 8.8 implemented. The project will move HHS to a PeopleSoft 9.2 version delivered by the Texas Comptroller of Public Accounts (CPA). House Bill 200 has mandated the consolidation of the current five (5) HHS Departments into three (3). The project will be a reimplementation of CAPPS Financials version 9.2 rather than an upgrade. 
The report developer position will perform PeopleSoft/Oracle technical report development services; specifically query and report development and performance tuning.  The worker must have extensive knowledge of what is required to convert PeopleSoft Crystal reports to PeopleSoft BI Publisher based reports. The worker must also have extensive knowledge of nVision, SQR and complex SQL. This position requires multi-tasking, exercising initiative and independent judgment.
The worker should have extensive experience with SQL/PSQL, index, optimization, and performance tuning on Oracle database version 11.x. Knowledge of PeopleSoft integrated functionality, data structure and transactional relationships between the General Ledger, Accounts Payable, Purchasing, Asset Management, Commitment Control, Strategic Sourcing and Supplier Contract Management modules.
    Duties for this position will include:
  • Responsible for working with the Functional and Technical Teams, DBAs, Internal Reporting Team and business users on report requirements gathering,analysis, design, testing and implementation within PeopleSoft 9.2;
  • Evaluating existing reports in 8.8 and creating or recreating those reports deemed business critical in PeopleSoft 9.2;
  • Responsible for identification, documentation, and reporting of any reporting related project risks and issues to Project Manager and Project Team for resolution;
  • Possesses Expertise in Structured Query Report (SQR), Crystal version 2008, nVision and PeopleSoft Query (PeopleTools 8.52), BI Publisher and testing;
  • Strong abilities in report/query analysis, troubleshooting, re-design, conversion, indexing, and SQL query optimization and performance tuning;
  • Practical application of the development life cycle, requirements, design, development, unit and integration testing, and acceptance testing;
  • Strong skills and experience in PeopleSoft version 9.2 Financial public sector product suite;
  • Must have strong communication skills to interact with staff, users and management; as well as having the ability to be a technical driving force within the development group.
  • Must have strong organizational, planning and documentation skills. This position will need to possess an in-depth understanding of technical design and be capable of serving as a technical quality assurance programmer/consultant.
  • Completes tasks in an efficient and timely manner while keeping project stakeholders informed;
  • Provides various administrative services and reports necessary to maintain the project status, schedule and quality.
Other Special Requirements: All entities replying to this request must be able to attest -- in writing -- that they are complying with Executive Order RP 80, signed 12/03/2014. In addition, because of the nature of the information in the system that will be upgraded, all entities must sign a Data Use Agreement as a condition of employment. Face-to-face interview preferred, but will accept phone interview.
Terms and Conditions: This position is subject to funding.
The Developer Analyst must be available on-site as required to assure successful completion of the project

 Minimum Requirements:
8 Experience as a PeopleSoft Reporting Writer for multiple large PeopleSoft projects.
8 Experience in designing, creating, and overseeing reporting for large complex high availability PeopleSoft Financial Systems.
8 Experience developing and migrating PeopleSoft reports during System Test, Integration Test, and User Acceptance Test.
8 Experience in SQR, Crystal, XML/BI Publisher, nVision and PS Query
8 Proven project team building skills
4 Experience writing and reviewing detailed test scripts for System, Integration, and User Acceptance Test Phases.
Strong Communication, analytical and interpersonal skills at all levels of an organization.
Strong Experience with the PeopleSoft 9.2 Modules G/L, A/P, AM, PO, eProcurement, Strategic Sourcing, Supplier Contract Management
Years Skills/Experience
8 Understanding of computer related tools, methods, platforms and operating systems.
4 Public sector experience (Federal, State or Local Government).
2 Experience with HHSAS Financials
1 Experience with the CAPPS State of Texas Baseline PeopleSoft 9.2 Modules G/L, A/P, AM, PO, eProcurement, Strategic Sourcing, Supplier Contract Management
Strong Ability to set and meet functional team deadlines while maintaining an even disposition
Strong Good teamwork skills, ability to collaborate with other functional and technical staff on the project.
Strong Strong interpersonal skills and the ability to collaborate effectively on diverse teams