Job Description :
Serenity Infotech Direct Client is Seeking for, 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.
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.

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.
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