Expertise in Oracle Applications for various project types as Implementations, Upgrade and Production Support of Financials Accounting Hub, GL R12 version of Oracle E - Business Suite.
Strong knowledge in SQL and PLSQL, SQL Loader
Performance tuning
Worked on both RDF and XML Publisher Reports
Worked on GL reports extensively
Worked on GL to Subledger drilldown and reconciliation extensively (Must know the tables and relations of source to subledger and subledger to GL)
Extensive experience to integrate external applications with Oracle GL through Oracle FAH
Converting source data into Oracle FAH source tables and views
Validating source data based on the accounting needs
Knowledge on Custom Sources Creation
Extensive experience on Subledger APIs (Event API, SLA Journal API etc)
Knowledge on Event Model, Process Categories, Journal Line types, Account Derivation Rules and Application Accounting Definitions.