SUMMARY

• Having around 12 years of Experience in Oracle Developer & ERP including Developing, Customizing, and Designing, Testing and Implementation of SCM, Distribution and Finance modules and Advanced Pricing and 3+ years of OAF expertise in internet (i) Modules.
• Worked extensively on Oracle Applications R12.2.5/R12.2.3/R12.1.3 (SCM, Distributions, Finance Module) and 11i (11.5.9, 11.5.10) Oracle Application Frame work (OAF), Oracle Workflow, Oracle Forms, Reports, XML Publisher and strong in SQL and PL/SQL. Possess good analytical skills, has resolved issues at the earliest. Stood always supportive to complete the tasks within timelines and has achieved proficiency in completing the work assigned.
• Expert in Oracle Development Tools, Technologies and Oracle E - Business Suite (Oracle Applications) RICE ranging the different versions of oracle applications from version 11.5.8 to 11.5.10 and R12 (12.1.3) to (12.2.5)
• Having experience in Oracle Lease Management and Financial (OLFM),INV, PO, OM, GL, AP, AR, FAH, Install Base, Service Contract, Depot Repair, Fixed Asset, BOM, WIP modules
• Proficient in functional knowledge of GL, Inventory and Financial business processes with order to cash (O2C), procure-to-pay (P2P) and END-END cycles of Oracle with respect to Techno Functional.
• Having 2+ years Working Experience on OAF forms customization & Form Personalization’s.
• Having Working Experience in Work Flow and XML Publisher Reports.
• Expertise in developing packages, procedures, functions, database triggers, interfaces and data Conversion using PL/ SQL, SQL * Plus and SQL* Loader.
• Having good Experience in EBS Forms and Form Personalization.
• Worked extensively on preparing AIM documents like MD020, MD060, MD070 and CV040s. Coordinated with the Development Team to identify product gaps by creating SRs and ERs to resolve various issues and well experienced in working.
• Good Experience and Worked on System integration testing with business in UAT..
• Extensively used TCA (Trading Community Architecture) to create customers in Oracle Receivables.
• Excellent interpersonal, communication skills and understanding of Business applications. Willing to take up challenging assignments and interested to work in different kinds of modules and emerging technologies.
• Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.
• Developed UNIX Shell scripts to FTP the flat file from External Server to Oracle UNIX Server location. Automated the process of encrypting and archiving.
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Worked on Version Control software like Tortoise SVN and GITHUB to check-in codes for file migration. Used FND-LOAD to migrate Concurrent programs, Request sets, forms menus and Personalization, by downloading the LDT files.
• Used Bulk Collect, Bulk Bind & Advanced collections feature to improve performance in Coding.
• Development of PL/SQL programs, procedures, functions, and packages.
• Good knowledge of media content, rights management through all media, territory, language and format
• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
• Extensive experience in PL/SQL stored procedures in Oracle 11g using Toad SQL Developer
• Experience in performance tuning, DB scripts.

Areas of Expertise

• OAF (Oracle Application Framework)
• Oracle Applications ERP
• Oracle Workflows
• Oracle Forms
• Oracle Reports
• XML Publisher
• EBS Forms and Form Personalization.
• Interfaces
• Conversions.
• SQL/PLSQL (11g/10g/9i/8i).
• Discover Reports.

TECHNICAL SKILLS

• Windows 95, 98, 2000
• Window -7 & 8
• Professional
• XP
• SQL
• PL/SQL
• Oracle 8i/9i
• Oracle 10g
• Oracle Forms
• Oracle Reports
• Oracle Discoverer Reports
• XML Publisher
• SSH Secure Shell Client
• Putty & WINSCP
• Oracle WEB ADI
• OAF
• Jdeveloper
• Oracle Workflow
• Edit plus
• Toad
• Oracle - SCM
• Distribution Modules
• Finance Modules
• STAT 5.7
• GITHUB

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Senior Oracle EBS Technical Consultant

Responsibilities:

• Worked extensively on module Oracle Lease management and Financial (OLFM) and Oracle Account Receivable, Inventory and fixed asset.
• Involved in Client calls gathering requirements, design review and solution provision.
• Analysis of the specifications provided by the client.
• Worked on SOAP Rest Web services.
• Worked on Oracle Workflow Business Event to transport information to legacy system.
• Worked on Custom OAF Page Payment Receipt Search Page.
• Custom page is helping user to get all the applied Receipt and unapplied receipt information at one place instead of navigating to different oracle forms.
• In this OAF page, Receipt information was shown at header level and invoices information for which receipt is being applied along with applied amount, applied date and Original Invoice Amount was shown at child level.
• Worked on Custom OAF Page Multi Lien Functionality. In 12.2.5 Oracle is having Multi lien screen where user can enter the lien information at OLFM Contract level as well as asset level but user cannot enter lien information more than one with different purposes for one asset.
• Custom page was facilitating the user to enter more than one lien information for a particular asset where user can simply search with contract number if any lien information exists, it was shown up on screen else user can create new lien information with the help of Create Lien page. Multi Lien Functionality is having different OAF pages Create Lien/Update Lien and Search Lien page.
• Worked on Custom OAF page Direct Debit OAF page. It was a user interface where user can see the extracted invoices and Verify and update the extracted invoices before creating the receipts batch.
• User was able to exclude the invoices from the batch and also updates the invoice amount i.e adjustment for the invoice.
• Worked on XML publisher report for printing the Germany documents in PDF format.
• Involved the Production bug fix and worked on high priority.
• Worked on EBS Form Personalization’s.
• Analysis of gap documents and preparation of Technical Design Documents.
• Worked on STAT tool for code migration and GITHUB tool used as code repository to track the changes in code.

Environment: Module: Oracle SCM, Account Receivable, Oracle Applications R12.2.5, SQL, PL/SQL, Oracle 9i/10g, Reports, TOAD, Oracle Forms, Windows 2000 Professional

Confidential, Louisville, KY

Project Lead Oracle EBS Technical Consultant

Responsibilities:

• Involved in Client calls gathering requirements, design review and solution provision.
• Analysis of the specifications provided by the client.
• Implemented Standard Purchase Order Open Interface Import Program which was integrated with Legacy system SSS (Synchronization of PO between SSS and EBS system).
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.
• Worked on EBS Outbound like AP Check feed file to Confidential Gannet system for Check Printing.
• Responsible for Journal Imports from all other modules like Accounts Payables (AP) and Account Receivables (AR) into General Ledger (GL).
• Implemented several custom logics for Form Personalization.
• Worked on order management, Fixed Asset, I-Supplier, I-Receivables, and I-Procurement modules as well. Preparation of Test case documents.
• Analysis of gap documents and preparation of Technical Design Documents.
• Worked OAF 10 + CO Customizations & 20+VO Extensions and Form Personalization’s in Internet Modules in iReceivables, iProcurement, iSupplier Modules.
• Developed two OAF pages from scratch “BCN Workbench” and “Progress Payment” OAF pages using OAF Frame work and integrated those pages in EBS using form personalization.
• Worked on interfacing material transaction by using Inventory Interface table.
• Involved the Production bug fix and worked on high priority.
• Involved end to end project implementation and good interaction with clients to sort the requirement.
• Developed xml reports in fixed assets which were very critical as per business perspective.
• Analyzing the solution, capturing CR060, MD02060 and CM010 and handling Design document.
• Involved end to end project Support and good interaction with clients to sort the requirement.
• Worked on EBS Form Personalization’s.
• Worked on XML Publisher Report Enhancements and bug fixes.
• Worked on Outbound Interfaces as well.
• Created Shell Scripts for Host Concurrent programs and migration scripts for code deployment.
• Good Experience and Worked on System integration testing with business in UAT.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
• Created Workbooks based on the custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop.
• Worked on Custom Reports using Oracle Discoverer 10g.
• Extensive experience in PL/SQL stored procedures in Oracle 11g using Toad SQL Developer
• Experience in performance tuning, DB scripts.

Environment: Module: OM, Install Base, Service Contract, Oracle Applications R12, SQL, PL/SQL, Oracle 9i/10g,Oracle Workflow, Reports, TOAD, Oracle Forms, Oracle WEB ADIO/S: Windows 2000 Professional, NT

Confidential, San Jose, CA

Senior Oracle Apps Technical Consultant

Responsibilities:

• Perform Production support activities.
• Worked extensively on Discoverer Reports.
• Developed discoverer reports for Module OM, INV, install base and Service Contract.
• Customized Oracle Reports.
• Developed Price List Updation program
• Worked on form personalization.
• Familiar with Process of ATO model sales order processing in case if it is MAKE or BUY Item.
• Developed script for Deletion of BOM from Oracle BOM database.
• Commoning of BOM from One inventory Organization to other.
• Prepared Technical Documents.
• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
• Extensive experience in PL/SQL stored procedures in Oracle 11g using Toad SQL Developer
• Experience in performance tuning, DB scripts.

Environment: Module: INV, BOM, Oracle Applications R12, SQL, PL/SQL, Oracle 9i/10g, Oracle Workflow, Reports, TOAD, Oracle Forms, Oracle WEB ADIO/S: Windows 2000 Professional, NT

Confidential, San Jose, CA

Senior Oracle Apps Technical Consultant

Responsibilities:

• Registration of Concurrent Programs. Good Experience to Oracle Application Object library (AOL).
• Imported orders by loading data from flat file into interface tables and then populated them into the base tables by Order Import program.
• Developed Item Conversion Program by using Interface.
• Developed BOM Conversion Program by using API.
• Developed Routing Conversion Program by using API.
• Developed Stock Locator Conversion by using API and ON Hand Quantity Migration Program.
• Worked on Oracle Open Transaction for Sales Order and WIP JOB.
• Perform Production support activities for Oracle 11i Applications.
• Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
• Developed discoverer reports for Module OM, INV, install base and Service Contract.
• Developed Sales Order to Purchase Order Re-Link Solution for ATO type BUY Items by using custom form, Form Personalization and PL/SQL.
• Prepared Technical Documents.
• Designed and developed numerous packages and procedures to load data from staging tables into Oracle base tables.
• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
• Extensive experience in PL/SQL stored procedures in Oracle 11g using Toad SQL Developer
• Experience in performance tuning, DB scripts.

Environment: SOA (Service Oriented Architecture)

Confidential, San Jose, CA

Senior Oracle Apps Technical Consultant

Responsibilities:

• Supported SOA team in documentation as well in Web service Configuration.
• Worked on Web Service, Database, File and Oracle Apps adapters. Setup and configured them.
• Implemented Database, File and Oracle Apps adapters and integrated with BPEL process.
• Involved in design and development of BPEL processes that contain Flow, Receive, Switch, Wait and Transform Activity.
• Technical Documentation.

Environment: Module: OM, Install Base and Service Contract, Depot Repair Oracle Applications R12, SQL, PL/SQL, Oracle 9i/10g, Oracle Workflow, Reports, TOAD, Oracle Forms, Oracle WEB ADIO/S: Windows 2000 Professional, NT

Confidential, Redwood City, CA

Senior Oracle Apps Technical Consultant

Responsibilities:

• Developed Item Attribute update interface program (INV).
• Developed Install base conversion program using interface (IB).
• Developed Update Oracle Install Base integration program using API (IB).
• Worked on shipping and receiving automation program (OM).
• Worked on discoverer reports for RMA Order Process and IB and SC reporting purpose.
• Developed Oracle Alerts for RMA Order process.
• Developed shell scripts for Oracle Install Base integration.
• Unit Testing.

Environment: Module: OM, Install Base and Service Contract, Depot Repair Oracle Applications R12, SQL, PL/SQL, Oracle 9i/10g, Oracle Workflow, Reports, TOAD, Oracle Forms, Oracle WEB ADIO/S: Windows 2000 Professional, NT

Confidential, San Francisco, CA

Oracle Apps Technical Consultant

Responsibilities:

• Discoverer Reports development on Financials, Order management, Service Contract, Install Base using Discoverer 10g
• Developed MD 70 and MD 120 document of discoverer reports.
• Migrated Discoverer reports on production instance.
• Enhanced OO-OM Interface - Interface between 3rd party Online ordering tool and Oracle Order Management involving creation of customers and sales orders using oracle APIs.
• Development of Concurrent Programs on AR, OM and Service Contract.
• Worked on Form Personalization of Service Contract, AR, OM, PO forms.
• Developed PL/SQL for Automation of Oracle service Contract functionality.
• Cascade service contract Start and End date from header level to line level and to sub line level and
• Populate accounting rule name based on contract start and end date, compute the price at billing stream Form of service contract.
• Developed shell scripts for mailing email quote of service contract.
• Worked on Custom Oracle Form of AR.
• Prepared document MD 70, MD 120.
• Perform Production support activities for Oracle 11i Applications.
• Unit Testing

Environment: Module: AR, OM and Service Contract, Install base Oracle Applications R12, SQL, PL/SQL, Oracle 9i/10g, Oracle Workflow, Reports, TOAD, Oracle Forms, Oracle WEB ADIO/S: Windows 2000 Professional, NT

Confidential, San Francisco, CA

Oracle Apps Technical Consultant

Responsibilities:

• Development on Financials, Order management, Service Contract, Install Base using Discoverer 10g
• Development of Concurrent Programs on AR, OM and Service Contract.
• Worked on Form Personalization.
• Prepared document MD 70, MD 120.
• Unit Testing

Confidential

Electronics Engineer

Responsibilities:

• Perform Network Administration Task.
• Perform Production support activities.
• Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
• Worked extensively on Discoverer Reports.
• Worked on Oracle reports and Oracle Forms.
• Worked through all phases of Requirement Analysis, Designing technical specification documents, developing code, implementing, support, enhancement and bug fixing
• Setting up Layouts for reports
• As a team member was responsible for Migrating Forms from Version 4.5 and Reports Version 2.5 to Forms/Reports 10g.
• Prepared Technical documents.