Job Description :
PeopleSoft Functional Multi-Currency resource
Location
NYC, NY
Job Type
Contract Job
Contract Duration
6+ Months (Possibility of getting extended)
Please Note:
A face to face interview is required after phone / Skype interview
Resumes must clearly address how the job seeker meets the requirements of this position (and plus factors, if any
Resumes must clearly indicate the name of the end-client, not employer (If applicable) for which all work indicated on the resume was performed, and the dates the job seeker performed the work.
Deliverables for Peoplesoft Functional Multi-Currency Resource:
1. Communication of best practice for end to end roll out with minimal disruption and assessing risk to the current reporting/control environment for Multi-currency functionality through Financial statement reporting.
2. Gather from various Business areas detail multi-currency requirements and get sign-off from Business and Technical teams. Requirements should be collected with a growth strategy in mind and not simply for today's situation.
a. Requirement traceability matrix (RTM
b. Functional requirement specification (FRS)/ Functional Specification Document (FSD
c. System requirement specification (SRS)/ System Requirement Document (SRD
d. Gather agreement and understanding prior to finalizing.
e. Perform end to end Demo of functionality
3. Prepare Design Documentation and get sign-off from various Business and Technical teams.
4. Configure/Build and update all PeopleSoft process integration points impacted by invoking Multi Currency functionality: List should be inclusive and to be provided by DXC but to start with - see below:
GL:
a. Ledgers and Ledger Groups.
b. New Business Units including elimination Business Units.
c. Chart-fields (i.e. new Accounts Modify and customize chart-field labels as needed.
d. New Journal Source/s.
e. Chartfield Maintenance.
f. Combination edits.
g. Closing rules.
h. GL Journal entry processing and approval workflow.
i. Reversing re-valuation journals
j. Allocations including Inter-Unit Allocations
k. Multi-currency specific processes:
Revaluation
l. Revalue the base currency of the balance sheet accounts
m. Timing and dependencies
n. Translation adjs
o. Timing and dependencies
p. Currency Precision Rounding
q. Maintenance of foreign exchange rates
r. Timing and Source
s. Rates for a currency pair quoted directly vs indirectly
t. Excel based spreadsheet upload template
u. SAS99 and other audit extract impact (potentially no impact if no change to Actuals ledger)
v. GL consolidations and equitizations with multiple book codes
w. Control Reports
x. Inter-Co out of Balance
Epro/AP:
1. Vendor categories and withholding codes (1099)
2. AP Voucher approval workflow.
3. Revaluation - At sub-system level- re-measurement of gains/losses at ledger, customer and vendor levels
Treasury:
1. ACH layout, payment source and pay-cycle steps.
2. Payment handling codes and payment term timing codes.
3. ACH and check payments with Bank.
Asset Management:
a. TBD
Technical:
All integration points
1. Bank Feeds
2. Other Interfaces (i.e. Wings)
3. Essbase
4. Assess appropriate access levels and permission lists.
Accounting / Reporting:
a. Assist Change Management effort for Accounting and Reporting changes
1. Work with other Corporate Finance/ Business areas to determine risk assessment of implementing Multi-currency functionality / reporting and meeting their reporting/regulatory requirements
Group Finance
client India Finance team
Accounting Policy
Financial Rptg (GAAP)
Financial Rptg (STAT)
Federal Tax
State Tax
Investment Accounting
Legal
2. Solicit buy in with external auditors - PwC
b. Assist in identifying impact on month-end and quarter-end close processes
1. Create and modify as needed CORE Reports - nVision Balance Sheet, Income Statements, Trial Balances and Cash flow statements for existing Business Units
2. Modify other existing reports i.e., PS queries, nVision, crystal
3. Update Essbase reports/retrieves
4. Blue Book Reporting
5. Financial Statement presentation
6. Integrate delivered reports into the financial close process or build new control reports for gaps
7. Currency Controls
8. BU level vs journal source level
5. Testing
a. Perform end to end demo/ POC of end to end process
b. Prepare test scripts and test functionality prior to releasing to Business areas
c. Clear testing comments from the Business areas
6. Training
a. Prepare training documentation
b. Perform training to end users