Job Description :
DirectClient: Texas Department of Health and Human Services Commission (HHSC)
Solicitation2077
Title: Peoplesoft Financials Developer
Location: Austin TX
Duration: Until 8/31/2017 with possible 1 year extension

Job Description:
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 Financials Data Warehouse (FDW) System Analyst 2.

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.

This individual will perform data warehouse analysis, modifications, and development services; specifically updates to FDW tables, views, stored procedures, queries, reports, scripts, ETL’s (Export/Transfer/Load), FTP’s (File Transfer Protocol), and interfaces.

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, and preferred knowledge of Strategic Sourcing and Supplier Contract Management modules.

Duties for this position will include:
Responsible for working with the Enterprise Services Financials Data Warehouse Team, DBA’s, and Business users on requirements gathering, analysis, design, testing and coordination of UAT (User Acceptance Testing);
Evaluating FDW related objects that use PeopleSoft 8.8 and creating or recreating these using PeopleSoft 9.2;
Responsible for identification, documentation, and reporting of any related project risks and issues to Project Manager and Project Team for resolution;
Possesses Expertise in SQL and testing;
Strong abilities in query analysis, troubleshooting, re-design, conversion, indexing, 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 the capabilities 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.
o Work Hours will vary according to the tasks at hand, as directed by the Senior Project Manager, but will include core working hours of 8:00 a.m. until 5:00 p.m.
o The System Analyst must be available on-site as required to assure successful completion of the project.
o Paid parking in a State of Texas parking garage will be available to contractor staff who presents the requisite documentation to the Texas Department of Public Safety to obtain a permit.

II. WORKER SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Skills/Experience
7 Experience with a data warehouse environment.
7 Experience in designing, creating, and overseeing stored procedures for large complex high availability Financial Systems.
7 Experience developing and migrating stored procedures and scripts during System Test, Integration Test, and User Acceptance Test.
7 Experience in SQL
7 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, and PO.

Preferences:
Years Skills/Experience
7 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

Client : Texas Department of Health and Human Services Commission (HHSC)