PROFESSIONAL SUMMARY:

• Over 7 years of experience in Analysis, Design, Development, Testing and Implementing Oracle EBS applications.
• Expertise in ORACLE 11g/10g/9i, SQL, PL/SQL, Forms10g/ 6i, Reports 10g/ 6i.
• Extensive experience in Designing, Implementing, Migrating, Customizing of Account Receivables AR ,Account Payables AP , General Ledger GL , Order Management OM , Inventory INV , Oracle Purchasing PO , Cash Management CM , Fixed Assets FA , Application Object Library AOL .
• Experience in Implementation, which includes full-cycle implementation. As well provided support during go live critical times and post-production maintenance phase to different clients.
• Experience in Reports, Interfaces, Conversions and Extensions RICE .
• Experience in Procure to Pay P2P , Order to Cash O2C and Supply Chain business flows.
• Expertise in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher BI Publisher .
• Experienced in Customizing Oracle Forms with Forms Personalization, Custom.pll on Forms 10g/6i.
• Proficient in customizing Oracle Workflow.
• Expertise in SYSADMIN and Oracle Applications activities like managing Application User Setup, Defining Responsibilities, Value Sets, Descriptive Flex Fields, Registering Menus, Concurrent Programs, providing support to apps user for any functional issues.
• Involved in upgrade implementation of Oracle Applications from 11i to R12.
• Well versed with client server environment and tools like SQL PLUS, SQL Loader, SQL Developer and TOAD.
• Expert in preparing Technical specifications MD070 , Functional Specification MD050 , Migration Documents MD120 , user training manuals, test procedures document preparation.
• Adept in PL/SQL Procedures, Functions, Packages, Data Base Triggers and UNIX shell scripts.
• Excellent analytical skills, strong verbal and written communication skills.
• Self-motivated and results-oriented with solid work ethic. Experienced in working in a team environment.

TECHNICAL SKILLS:

• ERP : Oracle Applications e business suite 11i, R12
• Modules : GL, AP, AR, PO, OM, INV, SLA, FA, CM, AOL and Alert manager
• Operating Systems : Windows/98/NT/00, Linux/UNIX
• GUI : XML Publisher, Oracle Forms 6i/10g, Oracle Reports 6i/10g, Forms Personalization,
• Workflows, Discoverer, OAF
• Database : Oracle 9i, 10g, 11g
• Languages : C, SQL, XML, XSL-FO, PL/SQL, UNIX Shell Scripting
• Tools : SQL Loader, Toad, SQL developer, SQL Tools, SQL Plus, WinSCP, Putty

PROFESSIONAL EXPERIENCE:

Role: Oracle Technical Consultant

Confidential

Roles Responsibilities:

• Developed an interface program to load the budgets into Oracle general Ledger.
• Modified the Payables invoice interface process and tested successfully
• Modified the Receivable invoice interface process and tested successfully
• Developed the XML reports, as per the business requirement in Inventory, related to items.
• Worked on the customization's on the PO approval workflow.
• Developed alerts to send an email when new accounts or mass allocation journals are created.
• Implemented according to SOX and audit compliance.
• Followed AIM methodology for implementation and documentation.
• Developed test plans and test scripts. Performed testing coordination, migration, and user training.
• Performed and documented SIT, Regression Testing and UAT. Coordinated migration between instances.
• Developed MD070s for the technical objects created as part of the business functionality.
• Worked directly with the users to gather the new process oriented requirements
• Created LDTs to migrate the developed code from one instance to other
• Supporting the production environment 24/7 by fixing all the raised issues and bugs.

Environment: Oracle applications 12.1.3 GL, AP, PO, FA, OM and Alert Manager , PL/SQL, Reports 10g, XML Publisher, Workflow, TOAD, UNIX, JDeveloper, OA Framework and HP kintana.

Role: Oracle Technical Consultant

Confidential

Roles Responsibilities:

• Developed a system integration and interfaces to activate or deactivate the phones using web services and PL/SQL.
• Developed a multi window oracle form with parent child relation to enter the purchase order forecast data.
• Developed an outbound interface to extract the PO related information using UTL File.
• Developed a PL/SQL package to submit all the reports from an OAF page.
• Developed custom APIs to validate the returns against Accessories and Serialized items and allowed to call these APIs from iStore portal.
• Developed a package and concurrent program to load the return details in bulk and email the success output to the respective user loaded.
• Developed a process to create the salesrep in AR by loading the data file or by entering the parameter values.
• Developed an interface to load the payable invoices into oracle using PL/SQL package.
• Developed an XML publisher report with the excel output which will automatically send an email to the user with the output as an attachment.
• Developed custom reports in iStore using Reports builder and XML publisher.
• Developed an UNIX shell script to email the output of the concurrent program.
• Developed the AD Application Design UTPs for the developed objects.
• Developed migration documents and created LDT files where necessary.

Environment: Oracle applications 12.1.1 PO, OM, INV, AP, AR, iStore, Quoting and AOL , PL/SQL, Reports 10g, XML Publisher, Forms 10g, TOAD, UNIX, OA Framework, SVN, Kintana, QC-HP application.

Role: Oracle Apps Technical Consultant

Confidential

Roles Responsibilities:

• Developed a Customer Conversion in AR. Created PL/SQL Procedures and functions necessary for Customer record validations before loading the data into customer interface table.
• Developed a conversion program to load the sales orders into oracle using SQL Loader and PL/SQL package.
• Developed, implemented and tested Vendor interface to import vendor information from legacy system into Oracle Application tables. This involved importing data from legacy system into staging tables using SQL Loader and using the PL/SQL procedure validating the data and inserting into vendor interface tables.
• Involved in customization of Sales Tax report.
• Involved in development of new reports and customized existing reports as per of requirements formatting, addition/deletion of columns, formulas etc
• Created and modified packages, procedures and functions
• Developed technical specification documents based on the functional specification documents
• Customization of Sales Order Acknowledgement reports.
• Developed SQL Loader Scripts to populate the legacy data from flat files to temporary tables.
• Involved in performing unit tests, integration tests and user acceptance testing UAT

Environment: Oracle Applications 11.5.10.2 OM, AP, PO, GL, and INV , PL/SQL Editor, SQL Plus, PL/SQL, Reports 10g, Forms 10g, Oracle Workflow Builder 2.6 and TOAD

Role: Oracle Apps Technical Consultant

Confidential

Roles Responsibilities:

• Designed and developed AR Receipts interface Cash receipts, Miscellaneous receipts and Reversal receipts using Receipt APIs.
• Designed and developed AR open invoices conversion to load open invoices into oracle receivables.
• Developed packages to load the suppliers and open Payable invoices into Oracle payables.
• Developed a conversion program to load the bank information of suppliers into oracle payables.
• Developed an Extension in PA, to end date the task to be no later than 180 days after the actual-in-service date for the assets defined on the tasks using update task API.
• Developed shell scripts for interfaces to load the data from legacy to staging tables and to schedule the interface programs.
• Developed custom Federal and Non-Federal invoice reports using Reports 6i.
• Worked on AR reconciliation, to match the total invoice amount by running the reconciliation reports.
• Developed technical documents MD-70 for every developed object.
• Created installation documents for every developed object, to migrate from one instance to another.

Environment: Oracle applications 11.5.10.2 GL, AP, AR, PO, PA, Treasury and Alert Manager , PL/SQL, Reports 6i, XML Publisher, Workflow, TOAD, UNIX, Discoverer 10g, Mercury Quality Center Test director and Clear case.

Role: Oracle Analyst

Confidential

Roles Responsibilities:

• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Prepared design document test scripts for the applications.
• Developed Control scripts and loaded existing data using SQL Loader.
• Developed Forms /Reports using Forms 6i and Reports 6i
• Developed stored procedure using PL/SQL to update payment info into Bills.
• Developed Database Triggers to enforce security.
• Generate reports, day-to-day administration jobs.

Environment: Oracle 9i RDBMS, UNIX, PL/SQL, SQL Plus, Oracle Developer 2000 Oracle Forms 6i, Oracle Reports 6i.