SUMMARY

• Having 12+ years of IT experience in designing, developing, implementing of Oracle Applications R12/11i/11.5.10.Good exposure on Oracle Application maintenance projects.
• Hands - on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work around, interfaces, user training.
• Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
• Experience in development and support of Reports Interfaces Conversions and Extensions and Workflow (RICEW) and Supply Chain (PO, INV and OM AND Service Contracts, Install Base).
• Experience in database programming using Oracle 8i/9i/10g databases.
• Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.
• Experience in various development tools like SQL Developer, SQL*Loader, Oracle Developer 10g/9i, Forms 10g/6i, Reports 10g/6i.
• Experience in developing UNIX Shell scripts for loading data into staging tables.
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc.
• Excellent communication skills, adapt in client interaction and understanding business applications.
• Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support.
• Customized Workflow Order routing process and Notification process based on the approval Hierarchies to notify the stake holders.
• Requisition approval process and order routing process validation logic has been customized using the custom functions at activity nodes on the standard workflow processes.
• Created and customized reports using XML Publisher in OM, AR, AP and INV.
• Upgrade of 11i Custom objects from Release 11i (11.5.10) to 12.2.4 in all modules.
• Developed Sales order conversion using standard API.
• Developed Purchase order conversion using standard interface.
• Extensive Experience in OM API's like order creation, order updation and pricing.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Developed Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
• Developed item conversion and un hand quantity conversion.
• Developed the BOM conversion code to convert the data from legacy to oracle system and registered as a Concurrent Program.
• Worked on creating the pricelists based on the customer requirement.
• Developed Sales by Customer Ship-To Location report that shows the sales information with corresponding order number, invoice number, Item number, and PO and customer ship-to location.
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.
• Trouble shoot issues with run time performance of the reports and use lexical parameters and bind variables wherever required to improve the performance.
• Involved in requirements gathering, analysis, development, QA and post-production support.

TECHNICAL SKILLS

ERP: Oracle Order management and SCM 11.5.10 -12.2.4 {GL, Payables, Receivables, Purchasing, Inventory, Order Management and AOL}, CRM(Service Contracts,Install Base)

Reporting tools: Reports 10g/6i,Forms 10g/6i,SQL plus,TOAD,XML Publisher,winscp3,Putty,FTP,Workflow,SQL Loader,Data Loader,REMEDY Quality Control,Version Control(PVCS )

Database: Oracle 11g/10g/9i/8i

Languages: SQL, PL SQL,Shell

Operating System: Windows 95/98/2000/XP, Windows NT, UNIX.

Database Tool: TOAD, SQL Plus 10.x/ 9.x/ 8.x.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior oracle apps developer

Responsibilities:

• Design, develop and implement systems and process solutions for business initiatives, process improvements and enhancements for Oracle EBS 11i/R12 in OM and SCM modules and focusing on integration with business partner application systems.
• Design, develop and test various business EBS functions using Oracle and related technologies (e.g. Oracle Forms, Reports, SQL, PL/SQL, Workflow, XML publisher)
• Ability to understand functional requirements and develop technical design document and code and Involve in functional discussions.
• Participate in, and adhere to, the code management process, including use of source-code control utilities and facilitation of migration of code across multiple Oracle instances.
• Used all oracle standard tables and API’s in PO, INV, Service Contracts, SCM module and inventory module.
• Worked on ASL conversion and Item import conversions.
• Modified custom views and tested in multiple instances and deployed to PROD.
• Remediated PO and INVENTORY objects and deployed to R12.2.4 in UPGRADE process.
• Create and update purchase order lines and shipments after validations.
• Item creation and updates on categories and catalogs and item cost and defined ASL setups for items using oracle inventory API’s.
• Tested R12.2.4 application after migrating 11i objects and prepared test results document.
• Supporting functional testing and user testing in multiple environments and providing detailed analysis within SLA.
• Environment of project: Oracle Apps R12.2.4 Modules: OM,PO,INV,AP PL-SQL, XML Publisher, Workflow builder, Forms 10g/9i, Reports 10g/9i, Putty, WinSCP3, Windows XP and UNIX.

Confidential, Cincinnati, Ohio

Technical Lead

Responsibilities:

• Developed AR invoice interface and AR Customers forms
• Imported Legacy Journals data into GL using Journal import interface
• Wrote PL/SQL packages for different validations, for processing data in order to create Valid POs and Receipts and for populating the PO interface tables and called the Seeded import programs to populate the base tables.
• Designed and Developed and Outbound Interface to send the Order details for a given customer
• Developed Receivables queries to compare summary information of the standard and custom reports
• Working with business team to get requirements and converting into technical design document.
• Participating in weekly status call with client.
• Coordinating with offshore team and helping in development objects.
• Working with cross functional team and solution team if required any solution help.
• Participating in unit testing and UAT.
• Working with QA team and providing solution to defects.
• Working in production deployment and SIT.
• Working in post-production support and hand over to production support team.
• Participating in code review process.
• Environment of project: Oracle Apps R12.1.3 in Modules: OM,AP, AR, GL,PO, PL-SQL, XML Publisher, Workflow builder, Forms 10g/9i, Reports 10g/9i, Putty, WinSCP 3, Windows XP and UNIX.

Confidential

Technical Lead

Responsibilities:

• Handling the priority Cases.
• Performing the RCA (Root Cause Analysis) for the issues.
• Maintain, Develop & Deploy the Bug Fixes.
• Proposing LTF (Long Term Fix) for issues.
• Monitoring Production Environment.
• Participating the Application Change Management
• Proactive analysis & Tuning of applications working towards case Reduction.
• Conducting Production Readiness Transition.
• Supporting Business Integrations
• Co-Ordination with the off shore team.