SUMMARY:

• Around 8 years of professional experience in Oracle Apps E - Business Suite as Oracle Apps Technical developer in Designing, Developing, Customizing, RICE implementations, Testing and Support of Oracle Application R12/11i in ERP domain - Projects Accounting PA(Costing and Billing), Finance(AP, AR, GL) modules, iExpenses, HRMS,PO.
• Experience in working with AIM methodology and is very proficient in working with MD050, MD070, MD120.
• Worked on OAF pages development from scratch.
• Worked on Oracle Apps customization and Extension using Oracle Application Framework (OAF), JDeveloper. Have knowledge of P2P and O2C cycles.
• Complete understanding and working experience of Oracle Workflows (Standard /Customized
• Involved in teh development of inbound and outbound interfaces using UTL FILE, open interface, oracle packaged APIs. Experience in PA, AP, AR, GL interfaces.
• Strong in Applications Object Library (Concurrent programs registration, Value Sets, Profiles, form registrations etc), System Admin tasks.
• Experience in Account Receivables (AR),Account Payables (AP), General Ledger (GL), Order Management (OM), Oracle Purchasing (PO),Projects (PA), iExpenses, Inventory (INV) Core HR(HRMS), System Administrator and Application Object Library (AOL)
• Expertise in developing Functional Specification (MD-50), Technical Specification (MD-70), Migration (MD-120), Testing (TE-20), BR-100 using AIM methodology.
• Extensive experience in writing SQL queries, PL/SQL-packages, stored procedures, pipeline functions, triggers, exception handlers, indexes, views, cursors, synonyms, sequences, PL/SQL records & tables.
• Support System testing, User Acceptance testing, Production Releases implementation of applications and troubleshooting issues for end users.

  Proficient in Handling and coordinating (Severity-1) Production issues and coordinating with Oracle team for SR (Service Request) management on 24*7 basis.

• Strong experience in debugging and tuning of system with tactical & strategic solutions in Oracle Apps components. Outstanding skills in analyzing business process and end-user needs, detail oriented and committed to delivering superior quality work.
• Worked on TCA Architecture(hz tables)

TECHNICAL SKILLS:

ERP Application: Oracle Financials Release 11i (11.5.9) / R12

GUI/Tool: JDeveloper9i(9.0.3) for OA Framework, Oracle Workflow Builder Oracle Forms/Reports Developer 10g/6i XML Publisher, Oracle SQL Developer (3.0.04), Forms Personalization, PL SQL Developer, Putty, Edit Plus.

Modules: Projects (Costing & Billing) module, Account Receivables (AR), Account Payables (AP), General ledger (GL),HRMS,iExpenses,PO

Configuration Management and versioning Tools: SVN for code versioning, Microsoft VSS 6.0,ClearCase

RDMS: Oracle11g/10g/9i.

Languages/Framework: SQL, PL/SQL XML Java OAF

Operating System: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Oracle Apps Technical Developer/OAF Consultant

Responsibilities:

• Implementation of Inbound Interface to automate teh addition of project bill and cost rates details . Acted as single point coordinator for OLB processes(Online Billing process).Developed Self Service Utility (OAF pages) for OLB process and customizations.
• Worked on Scramble routine of employee data in HRMS along with performance tuning.
• Developed OAF Page for Advanced Collections and form personalization for adding a new menu in tools ‘Consolidated Invoice Form’ which on click in turn invokes a request submission.
• Implemented AP Outbound Interface Program to extract teh Invoice data from base tables to flat file using UTL FILE package.
• Worked on Bulk enrollment notification in OLM(Oracle Learning Management) by using WEB ADI (BNE Tables) along with OA Framework(OAF).
• Worked on XML Publisher reports .
• Customization of PO Account Generator workflow logic .
• Involved in developing AP Bank Branch Interface.Worked on Dunning statements in AR to send email notifications to customers.
• Created a new approval workflow using oracle workflow builder.
• Customized PA project approval workflow, added one more level of approval while changing teh project status from submitted to active.
• Worked on Advanced PL/SQL - Tables, Record type, Bulk Collects and Bulk Binds.
• Proactively tuned SQL queries and views using indexes, explain plan and tkprof.
• Performed teh unit testing for teh code and migrated teh files through SVN tool.

JPMorgan Chase, US

Oracle Apps OAF Consultant

Responsibilities:

• Customized seeded Iexpense OAF pages to include business requirements .Implemented dialog pages.
• Developed Oracle Discoverer Reports - Invoice Register Reports.
• Worked on OAF Dialog pages in iExpenses module.Also customized seeded OAF Pages.
• Worked on purging of AP tables.Worked on Version Control software to check-in codes and used clearcase for file migration.
• Used FND-LOAD to migrate concurrent programs, request sets, forms menus and Personalization, by downloading teh LDT files.
• Fix defects encountered in any of teh testing phases .Ensure quality in coding and testing, conforming to Standard JPMC Protocol.
• Worked on Shell scripting to send mail and move files to backup folder and remove them after 6 months using CRONTAB.

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Project Costing: Importing raw costs as Expenditure items from other source systems, creation and adjustment of teh expenditure items in Projects. Defining Resource List, Cost Budget, Revenue Budget, Creation of Project templates, tasks with transaction control set ups.
• Project Billing: Defining Agreements, funding from agreements, from creation of Draft Invoice to making them accepted in Account Receivables. Interfacing Draft revenues to GL.
• Extensions: Done customizations on PA Client extensions, worked on form personalization and Custom.pll.
• Oracle Workflow: Creating custom Workflows and developing processes based on teh requirement. Worked on Notifications, Roles, calling Stored Programs into workflow.
• Oracle Application Framework(OAF): Designed/build screens that interact with database, extending seeded VO, CO and AM, performing Personalization, Partial page rendering, External LOV,switcher,dependent LOV,Validation View Objects. Created tab menus for OAF pages.
• Worked on Forms development 6i/Reports 6i.Worked on form development for error tracking and created oracle reports for AP Invoices.
• Created new OAF pages from scratch (self service utilities ) and custom oracle workflows.
• Conducted code reviews, performed unit testing, fixes, and requirement validations, accomplished database design, and modeling through data flow diagrams at conceptual, logical and physical levels.
• Responsible for tracking of high priority tickets and resolution of escalated support incidents.
• Answer technical support queries and implement fixes for application problems.
• Worked on cross-functional teams to proactively address support issues.