Oracle Ar Developer Resume
Sunnyvale, CA
PROFESSIONAL SUMMARY:
- More than 12 years of Techno Functional expertise on Oracle E Business Suite 11i/R12 Financials,Accounting in multiple lead roles with excellent technical, project and task management skills.
- Good insight into the functionality of the following Oracle Financials modules:
- Account Receivables (AR),Oracle Payments (IBY), Subledger Accounting (SLA), Cash Management (CE), Oracle General Ledger (GL), Trading Community Architecture (TCA),Order Management(OM),Account Payables(AP).
- Very good expertise in implementing SLA (Subledger Accounting) setups according to customer accounting requirements.
- Ownership of development lifecycle and being responsible for managing technical, quality, deliverable/resource/schedule/risks throughout project, working extensively under onsite - offshore model using AIM Methodology and Agile.
- Extensive experience in maintaining development plan, tasks allocation, task monitoring, establishing/monitoring quality process, study/audit of existing business process and preparation of issue logs, requirement gathering, user interaction, gap analysis, technical data mapping and analysis.
- Hands on experience in development and extensions, RICE components within quality standards using SQL and PL/SQL, and exposure to Oracle workflow debugging and resolving issues.
- Worked extensively in development of interface and conversion programs using PLSQL and Oracle Standard API s. (Example: Master Data Load such as Customers, Transactional Data load such as open Invoices, Receipts, GL interfaces, Order interface etc.).
- Expertise in IT project support and involvement in risks identifications and risk mitigation.
- Worked extensively in design and implementation of R12 Multi Funded Accounting upgrade enhancements for MFAR customers. Involved in Designing of data model for in Oracle s Financials product in creating new business functionality for MFAR customers.
- Worked in R12 concepts like Subledger Accounting (SLA) and Multi-Org Access Control (MOAC). Was instrumental in design of SLA in R12.
- Experience of working closely with Customers to identify and address critical issues in Financial modules. Worked extensively in period closure activities and reconciliation.Worked extensively on Revenue Recognition.
- Involved in planning, estimation and development of migration solutions using Oracle Data Integrator.
- Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operational costs.
- Automation of Business processes for faster resolution of tasks and to reduce manual intervention.
- Activity involved post-production support of Oracle Applications
TECHNICAL SKILLS:
Programming Languages: SQL, PL/SQL
Oracle Apps: Oracle E-business Suite (11.5.10 and R12)
Databases: Oracle 9i/10g/11g.
Operating Systems: Windows NT/2000, 95/98/XP, Windows 7, UNIX, and Linux.
Tools: JDeveloper, SQL Developer,Oracle Developer Suite (Forms 6i, 10g & Reports 6i, 10g),TOAD, PL/SQL Developer,,ETL Tool INFORMATICA, Cognos, Business Objects.
Methodologies: Software Development Lifecycle (SDLC), Application Implementation Methodology(AIM)
Job Functions: Design, Development, Testing, Documentation, Maintenance, Application Support
PROFESSIONAL EXPERIENCE:
Confidential, Sunnyvale, CA
Oracle AR Developer
Responsibilities:
- Involved in Customization of Oracle Financials Account Receivables Features such as Auto Invoice, Lockbox, Transaction Workbench and Receipt Workbench in order for users to implement the above provided features in an efficient manner.
- Work extensively in AR Revenue recognition for recognition of revenue for the invoices and receipt applications.
- Created various custom concurrent programs in recognition of revenue, receipt write offs.
- Built various custom AR to GL Reconciliation reports, AR Reconciliation reports, Aging reports in order to reconcile the posted data in order to close the books.Involved extensively in AR period closure activities. Worked on Subledger accounting for accounting the data from AR to GL.
- Created various custom JLT s in order to account the data using Custom Accounting. Integrated four financial source systems - Order Management, Account Receivables, Subledger Accounting, General Ledger from which revenue is recognized in Oracle Financials.
- Worked extensively on Revenue Recognition in order to recognize revenue for Invoicing rules
Confidential, Palo Alto, CA
Oracle Consultant
Responsibilities:
- Customization of Auto Invoice program to add Custom Accounting in order to import Orders and derivation of accounting rules information for the order lines based on attribute values.
- Defined for the orders and import them to AR and account to SLA and GL usage of iReceivables in order to create Credit memos by defining various approval limits for the user
- Developed interfaces to extract the data from upstream applications using PL/SQL, developed the setup and the transactional pages using API’s.
- Integrated four financial source systems - Order Management, Account Receivables, Subledger Accounting from which revenue is recognized in Oracle Financials .
Confidential
Project Lead, Development
Responsibilities:
- Designed logical and physical data model of in Account Receivables. Enhanced the Data model for R12 Multi Funded Accounting upgrade enhancements for MFAR customers.
- Worked extensively in AutoInvoice to import invoices and Auto Lock Box in order to import receipts into AR from various sources and apply them to invoices using various line grouping rules.
- Used import LockBox concurrent program to populate the data in interface table AR PAYMENTS INTERFACE ALL and VALIDATE the data to insert into INTERIM tables and run POST QUICKCASH TO insert into AR tables extensively .
- Worked Extensively in Importing Receipts through Automatic Receipts and auto apply them to invoices using receipt method definition.
- Was involved in usage of Receipts being applied to invoice with Payment method -> Credit card and its integration to IBY (Payments) in order to Authorize Credit card Payments.
- Developed interfaces to extract the data from upstream applications using PL/SQL, developed the setup and the transactional pages using API’s.
- Integrated four financial source systems - Order Management, Service Contracts, Account Receivables, Subledger Accounting,General Ledger from which revenue is recognized in Oracle Financials .
- Involved in Design and Implementation of R12 Multi Funded Accounting upgrade enhancements for MFAR customers.
- Involved in Designing of data model for Receivables module of Oracle Financials product in creating new business functionality for MFAR.
- Involved in development of Oracle Financials Account Receivables enhancement Features in Release 12 such as Reconciliation Tool to determine the AR to GL for the customers in order to help them to close the books.
- Worked extensively on developing Custom Interfaces to import the data into AR for Auto Invoice and Lock Box Concurrent program.
- Worked as part of AR-XLA integration stabilization includes preparing the XLA source extracts, sources, events and setups.
- Execution of proactive scripts on daily basis to identify the corruptions upfront and analyze, fix the same.
- Work on different reports required for the business and worked extensively in AR period closure activity and AR-GL Reconcillation.
Confidential
Programmer Analyst
Responsibilities:
- The process was automated using ETL tool Informatica in which the different data Sources could be integrated and automated which could run on a daily basis to extract the historical data from OLAP systems and refine the data as needed and load it to DATA WARE HOUSE.
- The Data warehouse was created in oracle database using the concepts of data modeling.
- This would be followed by generation of reports using the reporting tool Business Objects which could reflect the changes.