SUMMARY

• Over 4+ years of extensive experience as Oracle Application Technical Developer in implementation, upgrade and customization of Oracle e - Business Suite Applications(R12, 11i).dis includes system study, design, development, post implementation maintenance and support ofOracle EBS.
• Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications wif major focus in Order Management(OM),Inventory(INV),General Ledger(GL),Accounts Receivable(AR),Accounts Payables(AP),Purchasing (PO), BOM, Warehouse Management System (WMS), IProcurement.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces wifin several modules in Oracle Applications.
• Technically proficient inRICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Experience inProcure to Pay(P2P),Order to cash(O2C) life cycles and Supply Chain business flows.
• Proficient in development ofinterfacesandconversionprograms to integrate Oracle Applications modules to import data from various sources into Oracle Applications usingPL/SQL, SQL*Loader.
• Expertise on designing and implementingOracle AlertsandLookups.
• Well versed wif client server environment and tools likeSQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow, Discovererand modified the formats using XML publisher for customizations as per client specification.
• Experience in importing data from legacy systems to Oracle Applications usingOracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
• Expertise in requirement analysis, system design,Data Flow Designs, support, development, testing, documentation and design reviews.
• Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
• Experience incustomizing oracle workflowssuch as the PO approval process, Order/Line Flow to send user notifications based on the business requirement.
• Strong inPerformance Tuning, UNIX shell scripting.
• Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up ofOracle service requests (SRs).
• Ability to quickly adapt to the emerging new technologies
• Good communication, language and analytical skills

PROFESSIONAL EXPERIENCE

Confidential

Oracle Applications Technical Consultant

Environment: Oracle Apps EBS R12, GL, AR, AP, PO, INV, BOM, OM, SQLPL/SQL, Oracle Reports 10g, UNIX, TOAD

Responsibilities:

• Developed a Concurrent Program for Equalization SAM, by creating a scheduling program using PLSQL.
• Worked on Data Migrations such as Customer Interface, Fixed Assets.
• Worked on creation of Installation documents, Technical Documents.
• DevelopedPL/SQLprocedures, functions, packages, triggersto validate the data and insert the validate data into Oracle Standard interface tables.
• Developed validation packages to Load data tointerface tables(OE HEADERS IFACE ALL, OE LINES IFACE ALL, OE CUSTOMER INFO IFACE ALL)
• CustomizedSales Order formto add customer fax, email and phone number contacts.
• Worked on developingtechnical documents (MD70).
• Worked onSQL tuning, troubleshooting, debuggingand fixing the code and made the changes according to the new business requirements.

Confidential

Oracle Applications Technical Consultant

Environment: Oracle Apps 11.5.10.2,Oracle 10g, Forms 10g, Reports 10g, SQL*LoaderPL/SQL, TOAD,WINDOWS XP, UNIX.

Responsibilities:

• Analyzed the existing reports and made necessary modifications in Reports Re-Structuring.
• Developed many custom reports on various modules like PO, WIP, GL, INV, Depot Repair.
• Worked on Alerts and Conversions.
• Worked on additional requests in creating concurrent programs and creating Migration Documents.
• Used Custom PL/SQL API’S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices,and Open Purchase Ordersfromlegacy system to Oracle Applications.
• Worked onItem Conversionin theINVModule.
• Customized theSalesOrderInvoiceDetail Report in Order Management.

Confidential

Oracle Applications Technical Consultant

Environment: Oracle Apps R12

Responsibilities:

• Involved in theanalysisof the assignedsupportticketsincluding replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket wif the appropriate information
• To provided resolution to the issues which are mostly related to order management.
• Always Meeting deliverables assigned.
• To work closely wif Functional team to gain the functional noledge on various modules.
• Worked on several ad-hoc enhancements and documenting the corresponding changes accordingly.
• Closely worked wif ‘Oracle on Demand’ and support teams to fix any production bugs.
• Monitoring ASCP programs in day-to-day production environment.
• Worked on the complete Order Management cycle, right from creating an order till invoicing.
• Possesses good noledge on Auto invoice issues and MRP issues.

Confidential

Technical Consultant

Environment: Oracle Apps 11.5.10

Responsibilities:

• Developed Alerts in HRMS Module for Israel.
• Worked on both the Inbound and Outbound Interfaces and conversions for AR and PO modules.
• Worked and developed OPTIO reports.

Confidential

Oracle Apps Associate Consultant Trainee

Responsibilities:

• Handled the development and support activities at Offshore.
• Worked on both the Inbound and Outbound Interfaces and conversions for AR and PO modules.
• Developed complex Shell programs.
• Worked on Setup Configurations including defining Flex Field Values & Value Sets and Workflows.
• Coordinated activities wif implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines.
• Responsibilities also included understanding other financial module setups and workflows including Oracle Payables, Receivables, GL etc., Preparation of Migration Documents (MD), and creation of Custom Business Areas/Folders.
• Creating table scripts, UNIX shell programs and PL/SQL procedures as per the requirement.