Designation: PAFA Lead Analyst
Qualification: B.Com/ MBA/ M.Com
Experience: 4 to 6 Years
Shift Timings: 6:00 PM to 3:00 AM
Working Days: 5 Dyas Working (Hybrid)
Job Description:
•Four-to-five-year experience using conversion scripts to populate data within Oracle Projects and Oracle Fixed Assets
•Create new depreciation categories and locations in Oracle
•Create projects in Oracle projects
•Create budgets both manually and via Oracle processes
•Upload project expenditures into Oracle projects via PA Web ADI uploads
•Manually create fixed asset in Oracle fixed assets
•Utilize conversion scripts to load both Oracle projects data and fixed asset data
•Upload fixed assets into Oracle fixed assets via Web ADI
•Experience using SQL scripts
•Experience in Oracle is must
•Experience with performing Oracle system implementations or data migrations for fixed assets and project accounting is must.
Job Responsibilities:
•Provide functional and technical support for Oracle Projects and Oracle Fixed Assets, covering.
•Capital project setup, expenditure processing, asset management, data conversion, and financial validation.
•Configure and maintain capital project records based on approved business requirements, ensuring the accuracy of project attributes, classifications, organizational assignments, dates, and accounting information.
•Create and maintain project budgets using manual entry and supported Oracle budgeting processes, validating budget values against business requirements.
•Process project expenditure transactions through PA Web ADI and monitor, upload results to ensure accurate transaction processing.
•Prepare and validate source data files, conversion templates, and mapping specifications for project expenditure and fixed asset migration.
•Develop and execute SQL scripts and conversion programs to load project and financial data during mock conversion cycles and production migration.
•Establish asset categories, depreciation categories, and asset locations in Oracle Fixed Assets in accordance with established accounting requirements.
•Create fixed asset records manually, validating asset descriptions, acquisition costs, categories, locations, depreciation details, and accounting distributions.
•Perform bulk fixed asset uploads through Oracle Web ADI and investigate rejected records, processing errors, and data inconsistencies.
•Execute conversion scripts to populate fixed asset master data and related transactional information within Oracle EBS.
•Conduct source-to-target validation using SQL queries to verify the completeness and accuracy of converted project, expenditure, and asset records.
•Develop SQL queries to identify duplicate assets, missing project records, invalid locations, incorrect asset classifications, and discrepancies in financial values.
•Reconcile project expenditures and fixed asset balances against source files, migration control totals, and Oracle transaction records.
•Troubleshot Web ADI upload failures and conversion script errors by analyzing rejected records, correcting data issues, and validating subsequent reloads.
•Support mock conversion cycles by preparing data, execute load processes, reviewing conversion results, and coordinating the resolution of identified defects.
•Validate project expenditure information to ensure its accuracy and availability for downstream capital asset processing.
•Verified converted fixed asset attributes, including asset numbers, descriptions, costs, depreciation information, locations, categories, and accounting details.
•Collaborate with Finance, Project Accounting, Fixed Assets, and technical teams to resolve conversion exceptions and functional processing issues.
•Prepare conversion status reports, exception logs, reconciliation summaries, and supporting documentation for business validation and sign-off.
•Support final migration activities and post-production validation to confirm data integrity across Oracle Projects and Oracle Fixed Assets.