SUMMARY

• 9+ Years of Experience in Design, Development, Implementation, Upgrade, Customization and Maintenance of Oracle EBS Applicationscovering Complete System Development Life Cycle in the role of Oracle Technical Developer.
• Strong Hands on expertise in Implementation and Support of Oracle ERP packages in the Technical& Functional areas of Financials (AP, AR, GL, SLA, FA), Manufacturing (INV, WIP, BOM), Supply Chain Management(PO, OM), TCA, Human Resources, Payroll, Advance Benefitsand Application Object Library (AOL).
• Good exposure to Order - to-Cash (O2C) and Procure-to-Pay (P2P) life cycles.
• Good exposure to Federal Financials Modules.
• Developed and customized RICE components like Reports, Forms, Interfaces, Conversions, Extensions and Workflows as per client requirements.
• Familiar with Oracle Applications Framework (OAF) technology and Jdeveloper especially with personalization of existing OA Framework pages.
• Hands-on experience in Data Conversion, Data Migration and Developing Interfaces, Extensions in various Oracle ERP modules.
• Expertise in Strong PL/SQL Development
• Worked on creating SQL*Loaderprograms, Control files,PL/SQL validation scripts for validating and importing legacy/transactional data from feeder systems to Oracle Applications.
• Strong programming experience in developing Procedures, Packages,APIs,Functions, Triggers, UNIX shell scripts and other database objects using SQL and PL/SQL.
• Experience in customizing standard Oracle forms with the use of CUSTOM.PLL and Form Personalization.
• Expertise in developingand customizing OAF web Pages.
• Experience in developing Reports using XML/BI Publisher, Oracle Reports, and Discoverer.
• Hands on experience in developing Technical Specification Documents, Gap Analysis, Application Design (MD, CV, BR) using AIM Methodology.
• Expertise in performing Data export, Import and various operations using TOAD/SQL Developer.
• Experience in development, customization and migration of OracleForms/Reports using Oracle 6i/9i.
• Expertise in troubleshooting and query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Good understanding of oracle Data Dictionary and Normalization Techniques.
• Experience in UNIX Shell ( Korn, C, BASH) Scripting.
• Experience inmaintaining source codes using SVN and PVCS.
• Experience working on Oracle Panaya tool to identify the CEMLI/remediation objects for Oracle upgrade..
• Excellent team player withGood Communication and Interpersonal skills. Technically sound and Result-Oriented with strong Problem solving skills.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

ERP: Applications (10.2, 11.5.10, 11.0.3), R12 (12.2.1, 12.2.3)

E-Business suite Modules: INV, OM, BOM, WIP, PO, AP, AR,SLA, GL, HR,FA,OAB,AOL,PAYROLL, SYSADMIN.

RDBMS: Oracle 11g, 10g, 9i, 7.x/8.x,Sql Server

Operating Systems: LINUX, Solaris, Unix, Windows 9X/2K/XP

Languages: SQL, PL/SQL, C, C++, Java

Tools: Forms10g/ 6i/4.5, Reports10g/ 6i/2.5, SQL*Loader,Jdeveloper, Oracle Workflow Builder, TOAD and SQL*Plus, XML/BI Publisher, OAF.

Hardware: HP 9000, Intel Pentium based PC’s

Documentation: AIM Documentation (MD50, MD70, MD120,CV60,CV40)

PROFESSIONAL EXPERIENCE

Confidential, Hanover, MD

Oracle Finance Techno Functional Consultant

Responsibilities:

• Worked on Upgrade Project from Oracle EBS 11.5.10 to Oracle EBS R12.2.4.
• Analyzed existing RICEW objects in Oracle11.5.10 baseline (Reports, Interfaces, Conversion, and Enhancements) and remediated them to retrofit to R12 upgrade environment.
• Extensively used Panaya tool for R12 Upgradation
• Analyze and create common objects by using PANAYA and R12 Oracle documentation to support R12 changes as part of the initial analyzation of the CEMLI.
• Retrofitted R12 schema and API changes to the AR/AP Cemli's.
• Developed the OAF Screen using Partial Page Rendering Concept
• Extensively used SPEL Concept for delete,update,create pages
• Created custom Oracle OAF search and display pages.
• Used session variables to pass parameter values when submit to next OAF Screen
• Experience with OAF Migration Process
• Customized the Costing Reports to run for multi-org functionality by using XML/BI Publisher.
• Customized the CST INVENTORY PUB API for multi-org functionality
• Customized the below standard reports for multi-org functionality using XML/BI Publisher
• Changed the API to include XLA table for accounting information
• Used Auto Invoice to import Standard Invoices into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import Program.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Create the Deployment templates/scripts/ deployment steps to migrate the CEMLI object from DEV to TEST, INT environment.
• Enhance/create SQL* Loader programs to load the interface files data into staging while processing the records by using Oracle standard API’s
• Re-compile and apply R12 Changes to CUSTOM Oracle FORMS and REPORTS
• Modify CUSTOM PLL’s and Forms Personalization as part of the R12 Upgrade.
• Customized forms using CUSTOM.PLL file to meet the specific requirements.
• Experience in System Administration activities like Managing Concurrent Programs and Responsibilities
• Wrote SQL queries in various modules for Data Analysis.
• Followed Model-View-Controller (MVC) architecture standards in creatingOAFpages
• Incorporated the R12 Changes to the custom objects with r12 table and column changes
• Followed MD50 functional documents and designed the MD70 technical specifications, provided support for end users and documented the modifications.

Environment: Oracle Applications R12.1.3, Oracle 10g, Forms 10g, Reports 10g,Discoverer10g, Workflow Builder 2.6.3.5, XML/BI Publisher, SQL,PL/SQL,TOAD, OAF, PANAYA and SQL* Loader.

Confidential

Oracle Finance Techno-Functional Consultant

Responsibilities:

• Worked on Upgrade Project from Oracle EBS 11.5.10 to Oracle EBS R12.2.3.
• Analyzed existing RICEW objects in Oracle11.5.10 baseline (Reports, Interfaces, Conversion, and Enhancements) and remediated them to retrofit to R12 upgrade environment.
• Extensively used Panaya tool for R12 Upgradation
• Analyze and create common objects by using PANAYA and R12 Oracle documentation to support R12 changes as part of the initial analyzation of the CEMLI.
• Implement R12 schema and API changes to the AR/AP/BE (budget Execution Interface programs).
• Created a common Object to validate and derive default TAS/BETC for all AR/AP interfaces as part of the R12 Federal mandate implemented.
• Create the Deployment templates/scripts/ deployment steps to migrate the CEMLI object from DEV to TEST, INT environment.
• Analyze the patches and request the OMCS to apply the patches, once the patches are applied test the functionality before move to DEV and TEST environments.
• In-cooperated the R12 Cemli Remediation to the API's which interact with e-Travel/CONCUR and PRISM Systems.
• Co-ordinate and fix the defects during functional testing process, Support Integration testing by OpDIV‘s (Operational Division).
• Enhance/create SQL* Loader programs to load the interface files data into staging while processing the records by using Oracle standard API’s
• Design and develop the GEH (Global Error Handling) table and package by using Autonomous transactions to record errors.
• Designed the custom program to calculate the USSGL(segment6) value based on the derivation of the GO-Live date for the Purchase Order Documents.
• Create and work with Oracle SR’s to resolve upgrade data issues, and API issue.
• Work with PRISIM team to integrate the PRISM API’s to support R12 Upgrade functionality
• Involved in end-to-end testing for the CONCUR functionality
• In-cooperated the R12 Cemli Remediation to the SF224 rdf Reports.
• Involved in the Cemli remediation for CAN Re-alignment Programs.
• Create and Enhance the RECON (Reconciliation Tool Kit) to reconcile monthly SL to GL.
• Re-compile and apply R12 Changes to CUSTOM Oracle FORMS and REPORTS
• Modify CUSTOM PLL’s and Forms Personalization as part of the R12 Upgrade.
• Customized forms using CUSTOM.PLL file to meet the specific requirements.
• Experience in System Administration activities like Managing Concurrent Programs and ResponsibilitiesWorked on PO Approval Workflow to automate the PO Approval Process for Specific Vendors.
• Wrote SQL queries in various modules for Data Analysis.
• Followed Model-View-Controller (MVC) architecture standards in creatingOAFpages
• Created and extended various AMs, VOs and EOs as per the requirement. Created Drop down lists PPRs.
• Worked on OAF VO Extension for the budget execution Module
• Created Entity Objects (EO), View Objects (VO), Application Module (AM) and Controller (CO).
• Worked on OAF Personalization in the following scenarios
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.
• Performed Unit Testing of various objects and performed defect analysis and FIX the issues.
• Involved in writing UNIX Shell Scripts for moving and copying files from server to client and from client to server.
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation
• Followed MD50 functional documents and designed the MD70 technical specifications, provided support for end users and documented the modifications.

Environment: Oracle Applications R12.1.3, Oracle 10g, Forms 10g, Reports 10g,Discoverer10g, Workflow Builder 2.6.3.5, XML/BI Publisher, SQL,PL/SQL,TOAD, OAF, PANAYA and SQL* Loader.

Confidential, MD

Oracle OAF Developer

Responsibilities:

• Created custom OracleOAFsearch and display pages.
• Following are the page components used in search page
• Two LOV regions (required fields)
• 5 Shuttle regions for multiple selection of parameters
• Start and End date fields
• In Controller part of display page, used session variables to pass parameter values to nextOAFpage.
• Validated date fields in controller for search page
• Followed Model-View-Controller (MVC) architecture standards in creatingOAFpages
• Created Entity Objects (EO), View Objects (VO), Application Module (AM) and Controller (CO)
• Created custom MaintenanceOAFpage which has Entity Objects (EO), View Objects (VO), External regions, Application Module (AM) and Controller (CO)
• Coded all validations in Application Module for Maintenance Page
• Performed Add, Delete and Update operations in Maintenance Page
• Used hash map, session variables for navigating from one page to anotherOAFpage
• Migrated allOAFcomponents from local machine to development instance
• Personalized a standardOAFpage by extending its view object
• Developed thebarcodefunctionalityfor the item tracking using Jdeveloper.
• Used Partial Page Rendering in the oaf page to trigger when user scans thebarcode.
• Developed lot of custom screens in the distributions module where user scans the items/shipping with scanner.
• Designed and developed Multiple Search Pages, Create Pages, Insert Pages, Update Pages and Delete Pages.
• Developed the OAF Screen Which calls the Package/Procedure/Function to do the database actions
• Developed the OAF screen which submits the Concurrent Jobs and render to standard view request html screen for that user.
• I have developed and extended lot of OAF Screens.
• Moving the jar files from one instance to another instance
• Modified the custom styles to color the current record when updated the VO Query Results.
• Used SPEL Functionality for update and insert screens.
• Used PPR for OAF Screens.
• Created the Functions, Menus to register the OAF webpage in to Oracle Applications
• Developed the various XML/BI Publisher reports by using BAR CODES/Font.
• Developed Custom Reports in Various Models using XML/BI Publisher

Environment: Oracle Applications R12, Oracle 10g, Forms 10g, Reports 10g,Discoverer10g, Workflow Builder 2.6.3.5, XML/BI Publisher, SQL,PL/SQL,TOAD,OAF,EDI and SQL* Loader.

Confidential, OH

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Worked as an Oracle Applications Consultant for Oracle Apps R12 suite including AP, AR, GL, PO, OM and INV as part of the customer requirement.
• Extensively used Panaya tool for R12 Upgrade
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Developed Customer Interface in Receivables worked with various HZ tables, Interfaced data from flat files into Interface tables of oracle receivables using SQL* Loader, validated and imported data into AR base tables using Oracle Standard Customer Import.
• Familiar with Desktop Integration Manager and Oracle Web ADI responsibilities inOracle R12.
• Loaded/Imported Invoices in AR using Oracle Web ADI, created the Oracle Web Applications Desktop Integrator (ADI) Integrator (form function is assigned), and defined the Oracle Web ADI interface (Backend Package), and designed the custom Oracle Web ADI layout to load the invoice into the custom table.
• Worked on Suppliers, Supplier Sites conversion and Invoices for the players using AP Invoice Interface.
• Developed packages to validate and to load data from staging table to interface tables related to Procure-to-Pay life cycle.
• Responsible for converting all the Historical Invoices using Payables Open Interface Import into Production.
• Developed PO Receipts Inbound interface reads the data from the custom table and performs PO inspection and creates Accept and Delivery transactions in Oracle Purchasing. On successful creation of Delivery transaction the interface will generate an email notification to business users.
• Developed custom interface for allocating number of cases per New Item Release per Territory.
• Developed many inbound/outbound interfaces using Oracle Standard APIs for Pricing Modules and Order Import Processes.
• Developed custom program to validate and load the Sales orders from a third party into Oracle Order Management interface table. Used Order Import Open Interface program to load the data into Oracle base tables.
• Developed custom layouts for user facing documents like invoice and receipt using XML Publisher and generated data definitions for these reports using report10g.
• Designed Oracle Web ADI process for loading Items into Oracle.
• Performed migration of lookup types, value sets, Descriptive Flex fields, Profiles, XML templates, concurrent programs, request sets, request groups, menus, responsibilities, and alerts between database instances.
• Used the System Administrator responsibility to create users, responsibilities, custom profiles, request groups, request sets and Value sets.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Developed Custom Customer View only responsibility using OAF.
• Used Oracle Applications Framework (OAF) Personalization tool & developed OA Extension using JDeveloper with OA Extension.
• Worked on the Payables Open Interface. Activities involved creation of Loader File, Importing Invoices into the AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables using SQL*Loader and then using Payables Open Interface to import data into the actual tables.

Environment: Oracle Applications R12, Oracle 10g, Forms 10g, Reports 10g,Discoverer10g, Workflow Builder 2.6.3.5, XML/BI Publisher, SQL,PL/SQL,TOAD and SQL* Loader.

Confidential, CA

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Developed Customization of Reports, Interfaces, and conversions as per client requirements.
• Involved in development of reports based on business requirements and registered them in Oracle applications.
• Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures, and Packages.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Developed AR Aging Extract Report in Oracle Receivables which will send data back to Billing Systems using XML/BI Publisher.
• Worked on the Payables Open Interface. Activities involved creation of Loader File, Importing Invoices into the AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables using SQL*Loader and then using Payables Open Interface to import data into the actual tables.
• Created and registered a new Form using TEMPLATE.FMB. Gateway File Business Process.
• Involved in the development of interfaces/Conversions to import the data from legacy system into Oracle application base tables.
• Created Item classes, Conditions and Joins using Discoverer Administrator.
• Created Business Areas, Folders, Workbooks and Reports using Discoverer 10g.
• Worked on UTL FILE Package and SQL*LOADER for the interfaces and conversions.
• Customized Oracle standard reports like AP and AR Reports changed the output format to XML and created new templates for XML Publisher to display in pdf.
• Developed the Custom Program which handles the company Sales and Services inter-Company Transactions to calculate the Cost-Plus Accounting.
• Developed the Custom Program to extract the Accounts and Departments from GL for Intercompany Accounting.
• Developed the Tax Finance Invoice Custom Program which sends the VAT information to the Specified User.
• Involved in the month-end support for the $U scheduled Programs.

Confidential, NJ

Oracle Technical Consultant

Responsibilities:

• As a technical consultant, responsible for Communicating to the end users, Gathering requirements, Requirement analysis, Understanding Functional Specification Documents, Designing Technical Specifications, Coding, Testing, Change Management and support of the Customizations and application extension. Developed concurrent programs using PL/SQL and SQL.Client implemented Oracle applications as a single platform for handling their Customer Master Data and Item Master Data as part of MDM.
• Developed PL/SQL Procedures for Customer interface using TCA in (R12) Accounts Receivables according to Client Requirements.
• Developed PO Conversion Program and Requisition Conversion Program in oracle purchasing.
• Imported invoice information using Auto Invoice Interface Program and journals into GL from legacy system using GL import interface Program.
• Involved in Loading Employee and Employee Assignments in Human Resource using API’s called HR EMPLOYEE API, UPDTAE EMP ASG CRITERIA and UPDATE EMP ASG API.
• Generated
• Customized OTL Missing Timecard Report and OTL Timesheet Review Report using XML/BI Publisher, Basically this report gives the information of Project Name, Task, and Expenditure etc.
• Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• Changed Purchase Order Approval Work flow for sending E-mail Notifications for group of people with respect to changed lines.
• Wrote shell scripts to ftp the files to the legacy systems and to send error message notifications to the user groups. Developed shell scripts to migrate objects from Development to Testing.
• Maintained all the work done using PVCS. Also documented the work by creating various manuals for by future testers and users.
• Created custom Oracle Alert to notify business users
• Developed many inbound/outbound interfaces using Oracle Standard APIs for Pricing Modules and Order Import Processes.
• Worked on Order to Cash Cycle, starting from enter order stage to move order stage followed by the ship confirm and updating the GL.
• Developed OM queries to Count Orders by Order Types, Order Source.
• Registered functions using Discoverer Administrator.Developed workbooks in various formats like Tabular, Page Detail Tabular, Cross-tab and Page Detail Cross-tab format using Discoverer Desktop and Plus.
• Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases. Involved in Functional, Performance and Regression testing.

Environment: Oracle Applications R12 (HR, Payroll, Benefits), Oracle 10g, Forms 10g, Reports 10g,Discoverer10g, Workflow Builder 2.6.3.5, XML/BI Publisher, SQL,PL/SQL,TOAD and SQL* Loader.

Confidential, OH

Oracle Technical Consultant

Responsibilities:

• Prepared functional, technical design documentation, UTP Installation documentation and Shell Scripts and created the test cases and involved in testing and reviewing the objects.
• Worked on the interfaces and data conversions for the upgrade and tested to the client satisfaction.
• Developed queries for summaries of AR Aging reports, AR to GL Reconciliation reports, Auto-invoice execution/validation report, Tax and Revenue reports, Receipt register reports, Un-posted Items Report, Adjustments etc. Developed database triggers on few tables to keep track of changes.
• Developed Data Audit System scripts to capture the data from "before" system and after systems.
• Designed and developed the Journal Import interface program to Import Journals into General Ledger using SQL*Loader, PL/SQL package and Journal Import Concurrent program..Preparing the Technical Specifications documents which explain the process and steps which are done to fix the user issue/ requirement.
• Assigned user privileges, created business areas, managed folders and scheduled workbooks in Discoverer 10g.
• Customized AP Invoice on Hold Report,
• Preparing Technical design and Test plans for the requirements based on Client interaction.
• Facilitate and conduct business review meetings to develop strategies of implementation, QA, System Testing, UAT planning and getting sign-offs for technical designs.
• Used Auto Invoice to import Standard Invoices into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import Program. Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Created and customized reports using XML Publisher/BI Publisher in various Modules.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.
• Customized many existing reports such as Transaction Register, AR Aging Report, and AR Dunning Letters using Oracle Reports 9i/10g.
• Modified several Customized Reports using Reports 10g like Credit/Debit Memo Report, Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports as per changing business needs.
• Customized standardGL reports like Journal Entry report, Account Analysis Report, Accounts Hierarchy Report as per business needs.
• Extensive experience in XML/BI Publisher, which included working on report development objects like data templates and RTF’s.
• Worked closely with offshore team and lead them during the Development, Testing and Implementation phases of the project.
• Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases. Involved in Functional, Performance and Regression testing

Environment: Oracle Applications 11i (11.5.10) (OM, INV, AP, PO, AR, CM, GL) Oracle 9i/10g, SLQ Plus, PL/SQL, Forms6i, Reports6i, SQL Loader, TOAD, UNIX, Informatica, ETL, Windows 98/2000/XP.