PROFESSIONAL SUMMARY:

• Total 16+ years of experience in IT and Over 10+ yearsof extensive experience asOracle Developerand implementation, customization ofOracle e - Business Suite ApplicationsR12.This includes system study, design, development, post implementation maintenance and support ofOracle EBS . Remaining 5+ Years of experienceIn Oracle ERP development like Forms,Report and PL/SQL(D2k Developers).
• Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Order Management(OM),Inventory(INV),General Ledger(GL),Accounts Receivable(AR),Accounts Payables(AP),Purchasing (PO), BOM.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Technically proficient inRICE components (Reports, Interfaces, Conversions, Extensions).
• 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.
• Strong Knowledge of Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
• Expertise on designing and implementingOracle AlertsandLookups.
• Performed User and Administration responsibilities inDiscoverer.
• Experienced in Customizing Oracle Forms withForms PersonalizationusingCustom.pll.
• Excellent in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g andXML Publisher(BI Publisher).
• Developed new Concurrent Programs, Custom Forms, Reports andFlex Field Customizations.
• Extensively usedTCA(Trading Community Architecture) to create customers in AR.
• Well versed with client server environment and tools likeSQL*Plus, PL/SQL, SQL*Loader, Toad, OAF,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.
• 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 handle user defined errors by developingError-Handling Packageusing PL/SQL.
• Interacted with users, fixed the bugs, developed test plans and provides daily production support.

TECHNICAL SKILLS:

OS: - Windows XP

Languages: - SQL, PL/SQL

Databases: - Oracle 9i/10g,12c

Frontend Tools: - D2K Forms (6i/10g), Reports (6i/10g), XML Publisher,OAF

ERP: - Oracle Applications R12/11i

Tools: - Toad, SQL*Loader, SQL*PlusProfessional Experience

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Development and Customization of Forms, Reports as per the client requirement.
• Worked on XML Publisher reports using RDF and Data Template.
• Defining Concurrent Programs, Executables and Value sets.
• Preparation of SQL Loader scripts Pl/Sql programs for inbound interface.
• Developed outbound interface to transfer the data from base tables to external System.

Confidential

Responsibilities:

• Development and Customization of Forms, Reports as per the client requirement.
• Worked on XML Publisher reports using RDF and Data Template.
• Defining Concurrent Programs, Executables and Value sets.
• Preparation of SQL Loader scripts Pl/Sql programs for inbound interface.
• Developed outbound interface to transfer the data from base tables to external System.
• Workflow customization, OAF page personalization and customization.
• Worked on Fast Formula and Function in HRMS.
• Worked on UTL FILE packages to copy data in directory.

Confidential

Responsibilities:

• Development and Customization of Forms, Reports as per the client requirement.
• Worked on XML Publisher reports using RDF and Data Template.
• Defining Concurrent Programs, Executables and Value sets.
• Preparation of SQL Loader scripts Pl/Sql programs for inbound interface.
• Developed outbound interface to transfer the data from base tables to external System.
• Creating PL/SQL Packages, Procedures, Functions for data population and updation as per project requirements.

Confidential

Responsibilities:

• Development and Customization of Forms, Reports as per the client requirement.
• Worked on XML Publisher reports using RDF and Data Template.
• Defining Concurrent Programs, Executables and Value sets.
• Preparation of SQL Loader scripts Pl/Sql programs for inbound interface.
• Developed outbound interface to transfer the data from base tables to external System.
• Creating PL/SQL Packages, Procedures, Functions for data population and updation as per project requirements.

Confidential

Responsibilities:

• Lead the team and provide the guideline to resolve issue.
• Development and Customization of Forms, Reports as per the client requirement.
• Preparation of SQL Loader scripts Pl/Sql programs for inbound interface.
• Developed API to add responsibility to user
• Defined value sets, concurrent programs, registering reports and PL/SQL procedures and functions.
• Creating PL/SQL Packages, Procedures, Functions for data population and updation as per project requirements.
• Writing queries based on specifications.
• Created Workbooks based on the custom Folders with parameters, cascading parameters, conditions, calculations usingDiscoverer Plus and Discoverer Desktop.

Confidential

Responsibilities:

• Involved in the day to day activities of production support of Oracle applications environment inAP, PO, OM, INV, ARandGL.
• Involved in theanalysisof the assignedsupportticketsincluding replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
• Work on the development activities as part ofissueresolution. Perform Unit Testing, Migrate to next environments, assistusertestingand closing thetickets.
• Closely worked with users to understand business needs and objectives.
• Personalized Oraclestandard and custom Forms using oracle forms builderas per the Client requirements.
• Imported new, changed and completed sales orders from legacy system to oracle usingorder import (order management open interface).
• Customized formsusingcustom.pllto change the functionally of the standard forms.
• CustomizedSales Order formto add customer fax, email and phone number contacts.
• Customized the existing forms with descriptiveflex fields.
• Developed variousCustom reports, Customized existing reports(PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications usingReports 10g and XML publisher.

Confidential

Responsibilities:

• Development and Customization of Forms, Reports as per the client requirement.
• Creating PL/SQL Packages, Procedures, Functions for data population and updation as per project requirements.
• Writing queries based on specifications.
• Development and Customization of Forms, Reports as per the client requirement.
• Creating PL/SQL Packages, Procedures, Functions for data population and updation as per project requirements.
• Writing queries based on specifications

Confidential

Responsibilities:

• Development and Customization of Forms, Reports as per the client requirement.
• Creating PL/SQL Packages, Procedures, Functions for data population and updation as per project requirements.
• Writing queries based on specifications