SUMMARY

• 10 years of experience as an Oracle Applications EBS Technical Consultant
• Experienced in Oracle E - business suite 11i/R12 - Order Management (OM), Inventory (INV), Purchasing (PO), iProcurement, Account Receivables (AR), Account Receivables (AP), General Ledger (GL), IExpense, CRM (Customer Support, Service Contracts and Install base) and AOL modules.
• Part Functional within the Order-to-Cash (O2C) & Procure-to-Pay (P2P) business flows.
• Multiple project experiences in working directly with the business to gather functional requirements and developing the MD70.
• Project experiences include full life cycle implementations, upgrades, maintenance and support.
• Extensive Experience in RICE-W: Design, Development, Conversion, Customization, Interfacing and Implementation of Oracle Applications using Oracle SQL/PLSQL, Oracle Application Framework (OAF), Oracle Reports and Oracle XML BI Publisher.
• Extensive experience in working with PL/SQL Stored procedures, triggers, packages using Oracle 8i/9i database. Experience in Development and Customization of Reports/XML Publisher/Form Personalization.
• Experience in developing RTF and E-text templates by using XML publisher.
• Hands on experience in developing custom web pages by using Application Development Framework (ADF).
• Modified IExpense workflow for terminated employees to process the customer transactions
• Expertise in creating BC4J objects (EO, VO and AM) by using OAF and ADF.
• Expertise in Personalizing and Customizing Self-Service Pages by using OAF.
• Experience in Customization of Oracle workflows.
• Experience in creating custom JSP pages.
• Experience in writing SHELL Scripts for deploying the OAF pages.
• Experience in leading & managing teams and also working as an on-site coordinator.
• Experienced in writing AIM (Application Implementation Methodology) Documents - Technical design documents, unit testing documents and Installation Document’s (CCL, MD70, CV60, UTC and MD120).
• Strong programming, debugging and problem solving skills with the ability to translate customer requirements into technical solutions by utilizing business insights. Ability to learn and adapt to new technologies and strong analytical skills.

TECHNICAL SKILLS

Tools: & Technologies: Jdeveloper9i&10g, Reports 6i, Workflow 2.6.3.5, XML Publisher 5.6.3, Forms 6i.

ERP: Oracle E-Business Suite11i & R12.

Platforms: Windows, Linux

Languages: C, SQL, PL/SQL, Basic UNIX Commands and Java.

Oracle Tools: SQL*PLUS, SQL*Loader, TOAD.

Migration Tools: Kintana and Shell Script.

Version Control: Perforce, SVN and IBM Rational ClearCase.

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Senior Oracle Applications (EBS) Technical Consultant

Responsibilities:

• Developed XML Publisher Report for printing claim details. This is utilized by the users to share the previous weeks’ approved claim details to the suppliers (one email for the supplier).
• Converted 25 html reports to XML Publisher reports which are span into multiple modules like OM,AR and INV.
• Developed OAF for tracking the Order interface information and drilling down to part and Subpart level.
• Used XDO Imported for migrating the Objects to Test and Prod instances.
• Creation of CCL, UTC, MD070 and Requirement Analysis documents etc.

Environment: Oracle E-Business Suite R12 - Inventory (INV), Order Management (OM), Oracle Receivables (AR), Oracle Application Framework (OAF), SQL, PL/SQL, UNIX, XML Publisher, Winscp, Toad.

Confidential, Keene NH

Senior Oracle Applications (EBS) Technical Consultant

Responsibilities:

• Developed a custom RMA cogs reversal interface for reversing the journals for the RMA transactions.
• Developed FIFO report for reporting the inventory on hand balances on daily basis.
• Developed Customer interface for capturing the changes (new /updates) to customer information including Attributes stored in extensible attributes in Oracle will be extracted and sent to different systems using middle layer.
• Developed Rollforward report for providing the high level inventory and value by location, Product line. Also reports the transaction type level quantity and values for the given date.
• Created a custom OAF page for capturing the PO deals and stored then in a custom table.
• Worked on performance issues, used global temp tables whenever required to improve the performance.
• Created Host concurrent program for transferring the files form one directory to another directory.
• Provided solution for the complex problem and executed successfully.
• Created Custom Tables, synonym’s and lookup’s as per the requirement.
• Creation of CCL, UTC, MD070 and Requirement Analysis documents etc.

Environment: Oracle E-Business Suite R12 - iProcurement, Inventory (INV), Order Management (OM), Oracle Receivables (AR), Purchasing(PO), Oracle Application Framework (OAF), SQL, PL/SQL, UNIX, XML Publisher, Winscp, Toad, SVN.

Confidential, Sunnyvale CA

Lead Oracle Applications (EBS) Technical Consultant

Responsibilities:

• Developed RTF templates for printing Invoice Details, Purchase Orders and Barcode reports.
• Developed E-Text template for sending metadata information as .CSV files to ECM from ERP for Invoice, Packing Slip and Sales Order reports.
• Consolidated the Optio template while converting to XML Publisher templates to reduce the maintenance activity.
• Created 3 custom OAF pages for consolidating output templates for dynamically displaying the hard coded strings and labels in the XML Publisher template outputs for different country templates (including non - English templates)
• Created integration from ERP to ECM for archiving the customer facing documents.
• Created Host concurrent program for transferring CSV and PDF files from ERP to ECM server.
• Worked on Conversion for migrating metadata and PDF files from eCOM to ECM.
• Created Custom Tables, synonym’s and lookup’s as per the requirement.
• Modified the Pasta.cfg file to include the fit-to-page option to a particular printer to adjust the paper size in the printer while printing.
• Created printer styles as per the client requirement.
• Creation of CCL, UTC, MD070 and Requirement Analysis documents etc.
• Interacted with business and client manager to gather the requirements.
• Communicating the requirements to the offshore and upon completing reviewing the development and passing the same to client.

Environment: Oracle E-Business Suite R12 - iProcurement, Inventory (INV), Order Management (OM), Oracle Receivables (AR), Purchasing(PO), Oracle Application Framework (OAF), SQL, PL/SQL, UNIX, Reports 6i, XML Publisher, Winscp, Toad, Perforce.

Confidential, San Jose CA

Senior Oracle Applications (EBS) Technical Consultant

Responsibilities:

• Developed interface for creating or updating Party, Party Site and Address.
• Created Integration between ERP, SFDC and CDH. Whenever Party, Party Site and Address created or updated in ERP or SDFC same data will be sent to CDH.
• Developed conversion for migrating Party, Party Site and Address.
• Extended Party Site view object (VO) for adding the new field in Party Site page.
• Personalized Party site page for adding new field.
• Customization of Controller (CO) as per client requirement.
• Creation of UTC and Technical design documents.

Environment: Oracle E-Business Suite R12 - CDH, Oracle Application Framework (OAF), SQL, PL/SQL, UNIX, Winscp, Toad, Clearcase.

Confidential, Atlanta GA

Lead Oracle Applications (EBS) Technical Consultant

Responsibilities:

• Developed custom OAF page for entering the Job completing details in the Manufacturing plant.
• Called stored procedure in OAFramework for updating the Job completing details in the Oracle tables.
• Developed interface to users to review the status of Orders in manufacturing plant and update the status as and when required.
• Developed custom PLSQL procedure for updating the job details in the oracle tables.
• Registering Self-service pages in AOL.
• Created custom JSP pages to show the dashboard in the work station for displaying the JOB’s progress with refresh interval of 1 min.
• Registered Custom JSP pages as standalone application.
• Creation of CCL, UTC, MD070 and Requirement Analysis documents etc.

Environment: Oracle E-Business Suite 11i - Inventory (INV), Order Management (OM), Purchasing (PO), Oracle Application Framework (OAF), SQL, PL/SQL, UNIX, JSP, Winscp, Toad, SQL Loader.

Confidential, Charlotte NC

Senior Oracle Applications (EBS) Technical Consultant

Responsibilities:

• Customized EAM (Enterprise Asset Management) OAF screens for including custom OAF pages.
• Developed custom OAF pages for capturing additional information while creating work orders.
• Calling custom OAF pages in Standard pages flow as per client requirement.
• Extended the Asset View Object (VO) for including new fields.
• Registering Self-service pages in AOL.
• Customized EAM Work Order Page as per client requirement.
• Customization of Work Order page Controller for including new fields in the page.
• Modified custom XML publisher Report for including new fields in the PDF output.
• Creation of CCL, UTC, MD070 and Requirement Analysis documents etc.

Environment: Oracle E-Business Suite R12 - iProcurement, EMA(Enterprise Asset Management), Inventory (INV), Order Management (OM), Oracle Application Framework (OAF), SQL, PL/SQL, UNIX, Reports 6i, XML Publisher, Winscp, Toad.

Confidential, Sanjose CA

Oracle Applications (EBS) Technical Consultant

Responsibilities:

• Developed New Application called “My Support” by using OAFramework which will help the customers to check their serial numbers warranty status and raise service request.
• Developed OAF page for the customer to track and review and item location and contract information.
• Customized the install base JSP page as per the requirements.
• Configured the Attribute Fields in the install bas screen as per the requirements.
• Developed custom OAF pages which will help the customers to renew their Items support.
• Developed Custom OAF page for uploading the data from the excel file and inserting the data into custom tables.
• Developed PLSQL procedure for validating the Point of sale data and inserting into custom tables.
• Provide Support to all the IExpense, OM, Inventory and Finance Issues
• Customized the Install base address screen for filtering the Address field.
• Customized standard JSP pages in the installed base screen.
• Registering Self-service pages in AOL.
• Customization of CO and VO as per client requirement.
• Involved in integrating XMLPublisher reports with OAF Pages.
• Created Custom webpages by using ADF as per client requirement. Created Warranty renewal request page in ADF for the items.
• Creating views in clear case tool and uploading into kintana tool thereby allowing the client side consultants to upload the same into production. Customizing the reports as per the client requirements.
• Development of technical components as and when a footprint is raised. Creation of CCL, UTC, MD070 and Requirement Analysis documents etc.
• Created an interface to the users by using OAFramework for validating and processing the data which they receive from the different customers.
• Interacting with onsite coordinator and client manager to gather the requirements and work on it in both functional and technical aspects.
• Identifying the components and segregating them to go either into Support footprints pool or Request for enhancements and likewise updating the project tracker.

Environment: Oracle E-Business Suite 11i - iProcurement, Inventory (INV), IExpense, Order Management (OM), Oracle Receivables (AR), Purchasing(PO), CRM(Customer Support, Service Contracts and Install base), Oracle Application Framework (OAF), SQL, PL/SQL, UNIX, Reports 6i, XML Publisher, Forms6i, Workflow, Application Development Framework(ADF), Winscp, Toad, Clearcase, SQL Loader.

Confidential, WI

Oracle Applications (EBS) Technical Consultant

Responsibilities:

• Worked on Items conversion program.
• Personalized Iprocurement page for displaying new fields.
• Preparing deployment scripts.
• Customization of Workflow as per requirement.
• Preparation of Technical specifications like CV60, MD70.

Environment: Oracle E-Business Suite 11i - iProcurement, Inventory (INV), Oracle Application Framework (OAF), SQL, PL/SQL, UNIX, Workflow, Winscp, Toad.

Confidential, Milpitas CA

Oracle Applications (EBS) Technical Consultant

Responsibilities:

• Custom report on order details with shipped date more than X days.
• Personalized sales order entry form.
• Worked in Supplier conversion.
• Preparing Unit testing documents.
• Preparation of Technical specifications like CV60, MD70.

Environment: Oracle E-Business Suite 11i - iProcurement, Inventory (INV), Order Management (OM), SQL, PL/SQL, UNIX, Reports 6i, Forms 6i, Toad.