Job Description :
Hi
Position Title: PeopleSoft Functional GL/Multi-Currency
Location: NYC, NY
Duration: 5+ Months
Deliverables for 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
Reversing re-valuation journals
i. Allocations including Inter-Unit Allocations
j. Multi-currency specific processes:
Revaluation
Revalue the base currency of the balance sheet accounts
Timing and dependencies
Translation adjs
Timing and dependencies
Currency Precision Rounding
Maintenance of foreign exchange rates
Timing and Source
Rates for a currency pair quoted directly vs indirectly
k. Excel based spreadsheet upload template
l. SAS99 and other audit extract impact (potentially no impact if no change to Actuals ledger)
m. GL consolidations and equitizations with multiple book codes
Control Reports
Inter-Co out of Balance
Epro/AP:
a. Vendor categories and withholding codes (1099)
b. AP Voucher approval workflow.
c. Revaluation - At sub-system level- re-measurement of gains/losses at ledger, customer and vendor levels
Treasury:
a. ACH layout, payment source and pay-cycle steps.
b. Payment handling codes and payment term timing codes.
c. 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
a. 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
Guardian 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
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
Suresh
Osair Technologies Inc