TECHNICAL SUMMARY:

• Eight years of experience in Information Technology.
• Extensive experience in Oracle E-Business Suite Application (Release 12/11i/11.5.10/11.5.4-11.5.9) Financials, CRM and Manufacturing Modules.
• Extensive knowledge in all phases of Software Development Life Cycle (SDLC).
• Experienced in interaction with users, requirements gathering and drawing up Business Case Scenarios.
• Extensive knowledge and work experience in design and development of database/web applications in Client/Server environment using Oracle Developer tools Forms (6i & 9i), Reports (6i & 9i),JDeveloper 9i, Discoverer, PL/SQL Developer, Workflow Builder and TOAD.
• Expert in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
• Expert in requirement gathering, design and development of custom applications in Oracle Applications Framework (OAF) environment.
• Expert in JSP and JAVA object oriented related applications, customization and creation of JSP files and java classes.
• Extensive experience in development of procedures, functions, triggers, stored procedures, SQL scripts and packages using PL/SQL.
• Proficient in customization and development of reports using Oracle Reports versions 6i and 9i and Oracle Discoverer.
• Expertise in iProcurement, iExpense, iRecruitment, Purchasing (PO), Accounts Payables (AP), General Ledger (GL), Assets (FA), Human Resources (HR), Accounts Receivables (AR), Order Management (OM), Sales Online, Install Base (IB), Field Service.
• Proficient in ARIBA Supplier Network Application. Extensive experience in cXML, HTTP interfaces.
• Efficient in Workflow, UNIX Shell Scripting in UNIX Environment.
• Extensive Knowledge on XML Publisher, TCA Architecture, Web services and SOA.
• Good problem solving and trouble shooting skills, highly motivated and ability to work as an individual or as a dynamic member in a team.

EDUCATION & CERTIFICATIONS

• Masters in Computer Science, Confidential University .
• Bachelors of Engineering in Computer Science, Confidential University .
• Oracle SQL Certified.
• Oracle9i PL/SQL Developer Certified Associate (OCA)

PROFESSIONAL EXPERIENCE

Confidential, Ramsey, NJJun 2009 – Till Date
Oracle Applications 11i Techno-Functional Consultant/OAF Developer

• Performed application support in single and multi-Org environment for Oracle Financials (Purchasing (PO), Accounts Payables (AP), iExpense and iProcurement modules).
• Worked on Oracle Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Extended iExpense attachment upload page (FND_UPLOAD_PAGE) AkUploadCO.class to restrict the number of attachments.
• Personalized iExpense attachment upload page to include “Note” to the users at the organization level.
• Worked on iExpense related Oracle Service Request (SR) on incorrect Mileage rate after adjustment and mileage rounding to threshold value bugs.
• Worked on iExpense production fixes such as duplicate lines for AMEX transactions, incorrect mileage adjustment for second expense report for the same user in the same period.
• Worked on data fixes for invoice holds in Accounts Payables (AP).
• Worked on iProcurement (View Cart button) to fix errors due to data corruption.
• Worked with ARIBA on Procure-to-pay project. Designing tables for custom interface from and to ARIBA.
• Created Oracle Adapter using UTL_HTTP for cXML interface. The adapter includes HTTPS outbound and inbound transactions. Developed concurrent programs and scheduled for runs.
• Created Advanced Shipment Notice (ASN) interface for ARIBA. This involves data extraction and file creation for the interface from the custom interface table.
• Worked on Header Level Credit Memo interface from ARIBA. This involves parsing of cXML mime data file and loading into staging table.
• Worked on parsing multipart mime cXML documents to extract individual documents.
• Worked on deploying customizations from one system to another test system and to production.
• Worked on rounding customizations of dollar amount in iExpense using OAF. This involves customizing and extending controller CO and entity object EO.
• Worked on purchasing module (PO) to close Purchase Orders older than six months.
• Worked on patch analysis for different CPU patches for both single and multi-org environment.
• Worked on 11.5.10 minimum baseline patch upgrade to the internet Expense for Oracle Support.
• Worked on providing test scripts for Release R12 upgrade for module iExpense.
• Worked on identifying customizations for the R12 upgrade.
• Worked on R12 upgrade of iExpense Module, setting up JDeveloper environment to re-apply extensions in R12 instance.

Environment: Oracle Apps 11.5.10, Oracle10g, Jdeveloper 9i,10g, JAVA, OAFramework, SQL, PL/SQL, UNIX, PL/SQL Developer, MS-Office.

Confidential, Chicago, IL Aug 2007 – May 2009
Oracle Applications 11i Techno-Functional Consultant/OAF Developer
Responsibilities:

• Involved in Requirement Analysis, Design and Develop custom applications in OAF. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Worked on custom Password reset application on timeout issue in OA framework.
• Worked on requirement gathering, design and development of custom application Supervisor Information Management System (SIMS) in OA framework.
• SIMS application is used to create and monitor records for supervisors in service restoration actions.
• Worked on creating SIMS Entry page which is used to create route details entered by supervisors.
• SIMS entry page consists of OA components such as classic tables, show hide details, partial page rendering technique.
• Worked on SIMS Inquiry page which based on route details, displays the restoration action and provides the options to edit and export the records to excel.
• Worked on requirement gathering, design and development of custom application Service Management and Resolution Tracking (SMART) application in OA framework.
• SMART application is a tool used to track and manage service tickets such as enhancements and break fixes.
• Worked on SMART Entry page which creates service tickets and captures all detail information with respect to the ticket.
• Worked on setting up Jdeveloper environment for custom application.
• Worked on different framework components such as sub tab, partial page rendering, advanced table, export button in building the SMART application.
• Worked on framework reports page to create reports based on the service tickets entered.
• Created documents based on AIM methodology.
• Worked on personalization of oracle application home page, SIMS application and SMART application.
• Worked in iRecruitment module for validating external email id for external users.
• Created a java custom class CtaEmailValidation.class in Jdeveloper to validate the email address to the database and extended java CtaRegisterCO.class to call the custom class.
• Worked on creating ad-hoc SQL reports for SMART applications.
• Created PL/SQL packages for SIMS application to update records based on duration of event creation date.
• Worked on UNIX server to create custom directory structure in development instance.
• Created PL/SQL scripts to mask sensitive data in HR module in different instances.
• Worked on migrating personalization from test instances to production.
• Personalized User Management screen in User Management Responsibility.
• Worked on requirement gathering, design and development of custom application Deviation Code Maintenance in OA Framework.
• Deviation Code Maintenance application is used to create, update, delete and copy deviation codes based on the Job Schedule Number (JSN) from Human Resources (HR) module.
• Worked on attaching custom workflow process to the purchasing module.
• Created TARS for Employee Self-Service in HR module and System Administration responsibility.
• Created custom application based on Custom Development Method process.
• Worked on NOETIX views to generate SIMS reports.
• Support and troubleshoot ERP modules that include iRecruitment, Manager Self-Service (HR).
• Created migration packages to migrate into different environments by creating install UNIX shell script. Create and Update BR100 (Business Requirements) documents for all customizations.
• Defined concurrent jobs, schemas and created custom table structure for SIMS and SMART application.
• Worked on to create oracle reports for wage rate sheets created using mainframe systems.

Environment: Oracle Apps 11i, Oracle 9i/10g, Jdeveloper, JAVA, SQL, PL/SQL, UNIX, OA Framework, Toad, XML, MS-Excel.

Confidential, Rochester, NY Apr 2007 – July 2007
Oracle Applications 11i Techno-Functional Consultant/OAF Developer
Responsibilities:

• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Developed new Organization Hierarchy Page using Jdeveloper which interacts with Customer Overview Page (OrgViewPG.xml) of Sales Online Module.
• Worked on Hgrid in creating the Hierarchy tree for the Organization.
• Developed custom SQL query to include new attributes in the Organization Hierarchy page in which the user should be able to select the Organization based on the custom attribute.
• Worked on custom ‘Create Customer Page’ that includes Organization Region, Address Region and Contact Region.
• Customized page (OrgCreatePG.xml) to render and hide fields based on the ‘Show More Details’ button.
• Worked on PVO to render and hide fields based on the button event.
• Worked on validation of extended EO of Address region to include additional field’s values in the address region attributes.
• Worked on integrating the Contact region with the existing Customer Create page which has only Organization and Address Region.
• Imported/Exported different PG files using standard oracle import/export utility for modifications.
• Worked on different BC4J Components for customizations. Extended AM (Application Module), VO (View Objects) and modified the CO (Controllers).
• Worked on integrating newly created PG files with the existing PG files with handling back button.
• Worked on Unit/Functional Test of Customer Create page and Organization Hierarchy page while developing the customized pages.
• Worked on Application Developer for routing the Oracle Base function to redirect to custom PG files.
• Created migration packages to migrate into different environments by creating install UNIX shell script.

Environment: Oracle Application 11i, Oracle Sales, JAVA, Customer Online, OA framework, PL/SQL, SQL *PLUS, TOAD, Windows 2000, UNIX, Jdeveloper.

Confidential, Minneapolis, MN Nov 2006 – Feb 2007
Oracle Applications 11i Techno-Functional Consultant/OAF Developer
Responsibilities:

• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Worked on customizing iProcurement Requisition and Receiving pages.
• Customized iProcurement Requisition OA pages such as Requisition Home page, Requisition Search page (ExpSearchPG.xml). Customized different regions in Home page and Search page.
• Personalized iProcurement Preferences page, Requisition Summary display page and Requisition Checkout page.
• Created new LOV search fields in the Requisition Search Page. Modified the existing search criteria ExpSearchCO to incorporate the search with newly added LOV search fields.
• Worked on creating Accounts Payables (AP) module ad-hoc PL/SQL expense report (AP_EXPENSE_REPORT_ALL).
• Modified PORTCUSTB.pls file to default different fields in the Requisition Checkout page.
• Customized iProcurement Receiving OA pages such as Receiving Home page (IcxPorRcvHomePG.xml), Receiving Search Page (IcxPorRcvSrchPG.xml), Receipt Search Page (IcxPorVrcSrchPG.xml).
• Worked on Accounts Payables (AP) Holds report to find out information on hold records.
• Worked on implementing the iProcurement Requisition and Receiving customization using OA framework and java customization in order to suit different environments (Jdeveloper, development and production) for testing and debugging.
• Worked on Unit/Functional Test of iProcurement Requisition and Receiving pages while developing the customized pages. The pages involving functional test would be creating iProcurement Requisitions based on different test scripts scenarios.
• Worked on different BC4J Components for customizations. Extended AM (Application Module), VO (View Objects) and modified the CO (Controllers).
• Worked on integrating newly created PG files with the existing PG files.
• Worked on Application Developer for routing the Oracle Base function to redirect to custom PG files.
• Created migration packages to migrate into different environments by creating install shell script. Created documents based on AIM methodology.

Environment: Oracle Application 11i, Oracle iProcurement, JAVA, OA Framework, SQL *PLUS, TOAD, Citrix, Metaframe Desktop, UNIX, Jdeveloper.

Confidential, Rockland, MA July 2006 – Oct 2006
Oracle Applications 11i Techno-Functional Consultant/OAF Developer
Responsibilities:

• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Created CUSTOM JAVA_TOP on server for customized OAF pages.
• Worked on customizing iProcurement Requisition and Receiving pages.
• Customized iProcurement Receiving OA pages such as Receiving Home page (IcxPorRcvHomePG.xml), Receiving Search Page (IcxPorRcvSrchPG.xml), Receipt Information Page (IcxPorRcvInfoPG.xml), Receipt Creation Page (IcxPorRcvRvwPG.xml) and Receipt Confirmation Page (IcxPorRcvConfPG.xml).
• Customized iProcurement Requisition XML pages such as Shopping Cart Page(PORCARTF.xml), Notes to Approver Page (PORNOTES.xml), Requisition Approver page (PORAPPRV.xml), Express Checkout page (POREXCHK.xml) and Power Checkout page (PORPCHKF.xml).
• Worked on CreateReq.java and Requisition.java for iProcurement Requisition customization.
• Worked on different base java class files to identify the exact functions and the flow of the data in iProcurement requisition module for updating and validating functionality.
• Worked on implementing the iProcurement Requisition and Receiving customization using xml framework and java customization in order to suit different environments for testing and debugging.
• Worked on XML pages, java classes and OA pages along with BC4J components for validation and updated records based on the validation check such as supplier information.
• Worked on Unit/Functional Test of iProcurement Requisition and Receiving pages while developing the customized pages. The pages involving functional test would be creating iProcurement Requisitions based on different test scripts scenarios using Proceed to checkout, Express Checkout and Power Checkout, Creating iProcurement Receipts such as express receipts and normal receipts based on different test script scenarios.
• Worked on different BC4J Components for customizations. Extended AM (Application Module), VO (View Objects) and modified the CO (Controllers).
• Worked on integrating newly created PG files with the existing PG files.
• Worked on Application Developer for routing the Oracle Base function to redirect to custom PG files.

Environment: Oracle Application 11i, Oracle iProcurement, JAVA, OA framework, XML Framework, SQL *PLUS, TOAD, Windows 2000, UNIX, Jdeveloper.

Confidential, Rochester, NY Feb 2006 – July 2006
Oracle Applications 11i Techno-Functional Consultant/OAF Developer
Responsibilities:

• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Created CUSTOM JAVA_TOP on server for customized OAF pages.
• Created new CUSTOM Sales Online Responsibility, which includes defining functions, submenu, menu and responsibility. This responsibility contains CUSTOM OA pages.
• Developed customized Oracle Sales Online Application OA pagesby customizing different fields in Basic Information Region, Financial Information Region, and Profile Information Region inCustomer Overview Page (OrgViewPG.xml) of Sales Online module.
• Worked on PPR (Partial Page Rendering) on a popup list table (Business Activities) on Customer Overview (OrgViewPG.xml) Page.
• Imported/Exported different PG files using standard oracle import/export utility for modifications.
• Worked on Switcher functionality for update/remove button in custom created table.
• Added new custom Account Summary Page Link to the Shortcut Region of the Dashboard Page (DashboardPG.xml).
• Added two new Custom Regions on Dashboard Page below Shortcut Region in DashboardPG.xml.
• Modified existing jsp page in Sales Online module, to add an additional side bar menu options.
• Worked on expenses entry screen on iExpense module in changing field names.
• Worked on adding more fields in expenses review screen of iExpense module.
• Worked on Personalization of Sales Online Opportunity page to add Product details in Products tab, Contact Purpose on Customer Overview page.
• Created custom tab in the Update Opportunity page of Sales online module.
• Worked on different BC4J Components for customizations. Extended AM (Application Module), VO (View Objects) and modified the CO (Controllers).
• Worked on integrating newly created PG files with the existing PG files with handling back button and popup window option.
• Worked on Application Developer for routing the Oracle Base function to redirect to custom PG files.
• Created new OAF pages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data through EO (Entity Objects).

Environment: Oracle Application 11i, Oracle Sales, iExpense, JAVA, Customer Online, OA framework, PL/SQL, SQL *PLUS, TOAD, Windows 2000, UNIX, Jdeveloper.

Confidential, Westboro, MA Oct 2005 – Feb 2006
Oracle Applications 11i Techno-Functional Consultant
Responsibilities:

• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Developed customized pages using OA Framework. Modifying existing Field Service Technical Portal by customizing lov, button events, hiding regions, extending Application modules (AM) adding new view objects (VO) and customizing the controllers (CO) as per the functional specification.
• Importing/Exporting (PG) files from MDS using XMLImporter utility provided by Oracle. Exported PG files for development and modified the PG files such as CsfPoDashboardPG.xml, CsfPoUpdateTaskPG.xml, SRCreationPG.xml, SIDefaultPG.xml and CsfPoTaskSearchPG.xml.
• Created new BC4J Components and transferred to the associated directory structure in $JAVA_TOP. Modified the Controller Class and transferred to the associated directory.
• Worked in Application Developer to change the value of the HTML cell in Web HTML tab to call the customized pages.
• Tested in the local environment using jdeveloper, identified issues, and modified corresponding regions, tables, loves. Imported files back to MDS using XMLImporter utility.
• Worked on TCA architecture on identifying relationships and validation process in install base.
• Developed customized JSP pages for retrieving data in table structure, querying on fields and updating search fields and also used seeded java classes for additional requirements.
• Retrieved corresponding jsp pages along with the java classes from associated directory structure in $OA_HTML, modified and imported back to the server.
• Worked on base jsp and respective java beans for customization page and imported newly created jsp pages and java classes back to the server.
• Worked on providing security and validation in jsp pages in install base.
• Worked on Unit/Functional Test of CRM modules, Install Base, Field Service, while developing the customized pages. The pages involving functional test would be create item instances, creating sub item instances, parties’ page, owner’s page etc.
• Worked on Function Test for Field Service Technical Portal which includes Create Service request page, Service request item details page, debrief, labor, material page.
• Worked in Install base with identifying Top Level Model, Top Level Assembly (TLA), Serialized/Non-Serialized part, Related Items and different segments of the inventory item.
• Worked on different Install Base validations which include form level and server level validations. The Install Base validations were implemented in creating a new instance, adding new instance, creating sub instance and updating instance details.
• Worked on security features in Install Base. Identifying roles for the user such as (HTML, RESOURCE), mapping corresponding group.
• Worked on jdeveloper, configured associated directory structure, OA framework architecture.
• Worked on identifying base sql from the properties files.

Environment: Oracle Application 11i, Install Base, JSP, Field Service Technical Portal, OA framework, Inventory, PL/SQL, SQL *PLUS, TOAD, Windows 2000, UNIX.

Confidential- Norfolk VA Oct 2003 – Sep 2005 
Oracle Applications 11i Techno-Functional Consultant
Responsibilities:

• Gathering Business Requirements and setting up Business Processes within the Applications – General Ledger, Purchasing and Assets.
• Defining Descriptive Key Flex fields, Key Flex fields, Set of Books, Accounts, and Approval rules for Journal Entries, Reconciliation, Post Journals, Year End Closing and Period Closing in GL.
• Defining Supplier, Organization, Items, Purchasing Options and Buyers in purchasing implementation.
• Decide Approval Hierarchy Set-up and Maintenance for approving PO using Oracle Workflow.
• Set up iProcurement, Train, Troubleshoot and debug iProcurement Modules. Load Items, Set-up and Maintain Punch-out Sites.
• Worked on iExpense creating reports, sending reports to AP, converting reports to invoices.
• Good knowledge in iExpense report workflow process.
• Modified Workflow Account Generator according to the business needs. The client had 8 segments on the account segment field, customized using Oracle workflow attributes. Designed the Account Structure as per client requirements.
• Set-up steps based on Business Requirements for Purchasing. To mention a few Supplier, Organization, Items, Purchasing Options, Buyers etc.
• Imported items to iProcurement using Catalog Extract and Bulk Load Requests.
• Functional knowledge in Accounts Payables such as Auto-Create Invoices, Payment Schedule, Posting and Period closing, Return to Supplier Transactions.
• Assets implementation such as Implemented Mass Additions to add assets merge and split assets, Adding Assets Automatically from External Sources, in this case it is Accounts Payables and Bar Code Entry, Import data from Accounts Payables to Oracle Assets using "Create Mass Addition" request, Set up Physical Inventory, which involves setting up ADI, Assets Accounting was set up based on Set of Books of General Ledger.
• Expertise in trouble shooting in GL and Financial Applications.
• Expertise in generating reports using Oracle Reports (6i & 9i) meeting variety of Business needs including custom Reports.
• Proficient in generating Forms using Oracle Forms (6i & 9i) meeting variety of Business needs including custom Reports. Modifying Forms to accommodate new functionality like adding Buttons and Texts.
• Trouble Shoot, Debug and Train Users on GL and FA Modules.

Environment: Oracle Application 11.5.9 GL, PO, AP, AR, OA framework iProcurement, Oracle 9i, Reports 6i &9i, Forms 6i and 9i, PL/SQL, SQL *PLUS, Windows 2000, UNIX.