SUMMARY

• Over 9+ years of extensive experience as Oracle Application Technical Consultant in implementation, upgrade, and customization of Oracle e - Business Suite Applications (R12,11i) and Oracle Fusion Applications Suite.
• Good knowledge in SQL, PL/SQL, and Oracle EBS.
• Strong knowledge in creation of Oracle Packages, Procedures, Functions, Views
• Extensive Experience in implementation, customization, Production, and support of various modules like Purchasing (PO), Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), I Expenses, IProcurement, Order Management (OM) modules of Oracle Applications.
• Technically proficient in RICEW components (Reports, Interfaces, Conversion, Extensions, Workflows)
• Good Working experience end to end flow on Procure to pay (P2P) and Order to Cash (O2C).
• Excellent Experience in RDF Reports with Paper Layout format
• Strong in the Reports using BI Publisher.
• Good knowledge on developing Interfaces using PL/SQL, SQL*Loader.
• Expertise on designing and implementingOracle AlertsandLookups.
• Very Good Experience in the customizing workflows like PO approval Process, user notification based on the business requirement.
• Strong Experience in Patch Analysis.
• Good in performance Tuning using tools like SQL TRACE, TKPROF.
• Experience in the customizing Oracle Forms with Forms personalization using Custom.pll
• Experienced in customizing existing OAF.
• Very Strong knowledge on retro fitment as part of Oracle R12 Upgrade.
• Excellent experience in creation of new user, responsibilities, menus etc. and the corresponding actions.
• Experience in importing data from legacy systems to Oracle Applications usingOracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
• Expert in developing Technical design documents, Technical Test documents
• Troubleshoot issues, including creation/follow-up ofOracle service requests (SRs).
• Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
• Experience in OTBI reports.
• Very Good Team Player with excellent communication skills, interpersonal skills, keen analytical skills and Good Organizational skills.

TECHNICAL SKILLS

Oracle Modules: AP, PO, GL, AR, iExpenses, IProcurement, OM

Language Programming: C, SQL, PL/SQL.

Operating System: Windows XP, UNIX

Tools: PL/SQL, SQL Developer, Report Builder, SQL*Plus, TOAD, Oracle BI Publisher, OTBI Report, Report 10g, Form 10g, Putty

PROFESSIONAL EXPERIENCE

Oracle Apps Senior Technical Consultant (EBS)

Confidential, San Bruno, CA

Responsibilities:

• Planning, monitoring, and completing assigned project or enhancement tasks to meet the customers’ need-by dates. The tasks include requirements gathering, solutions design & User Acceptance Testing coordination
• Experience implementing and (or) supporting Oracle EBS R12 Oracle Payables Applications, Receivables, Purchasing.
• Participate in all phases of managing the Application Lifecycle Management: requirements analysis, development, testing, and implementation
• Participate in technical logic and design discussions
• Developed a new report to get users who havePurchase orderandrequisitionopen and are out of the company.
• Designed and developedpayablesinterfaceimport program and interface tables to loadinvoicesfrom thelegacysystems into the oracle payables base tables.
• Strong Knowledge in Development and Customization of Forms/Reports with sound understanding ofApplication Object Library (AOL).
• Developed and Documented OTBI Reports
• Customization of Workflow for sending second level verification and notification.
• Performed POC for Watermark in the RTF layout for BI Publisher Report.
• Ability to handle user defined errors by developingError-Handling Packageusing PL/SQL.

Oracle Apps Senior Technical Consultant

Confidential

Responsibilities:

• Performed the customization of Requisition Approval and PO Approval workflows.
• Customized the procedures, functions and packages for the changes in the tax calculation.
• Customized the Reports using BI Publisher
• Created new users and setting the profiles in all the phases like development, testing and production
• Created new Responsibilities and also assigned to the specific users
• Involved in the creation of new functions and providing function security
• Designedmenus and responsibilitiesto different level of users in the organization.
• Performed imposing the limits on what users can access through menus, security profiles and responsibilities.
• Defined concurrent managers and Report sets.
• Involved in defining the formats of currency for displaying amounts.

Oracle EBS Developer

Confidential

Responsibilities:

• Oracle Apps Technical Consultant for Implémentation,upgradeandsupportProject.
• Involved in the day to day activities of production support of Oracle applications environment inAP, PO, GL, AR, iExpenses, IProcurement, OM.
• 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.
• Created the new Reports using BI Publisher
• Prepared Unit Test cases and MD 70 documents for newly created Reports and other retro fitment objects
• Customization of interfaces.
• Customized the existing RDF reports with Paper layout format for Income tax and Balance sheet Reports.
• Involved in Hyper-Care Support
• Involved in Patch Analysis and Prepared Patch Analysis Document
• Performed OAF personalization
• Customized formsusingcustom.pllto change the functionally of the standard forms.
• DevelopedAlerts for sending mail notificationin many Modules.
• Involved in retro fitment of SQL & PL/SQL packages, procedures, functions and views, Oracle Reports
• Prepared Impact Analysis Documents for the retro fitted objects.