PROFESSIONAL SUMMARY:

• Over 8 years 5 months of experience in Oracle Applications R12 (R12.2.4, R12.1.3)/11i (11.5.10, 11.5.9) as an Oracle Applications Senior Developer/Lead in Implementation, Enhancement, Upgrade and Support projects.
• Strong experience in Oracle Finance and Supply Chain modules: Account Payables(AP), Account Receivables(AR), General Ledger(GL), iSupplier, iProcurement, iExpense, Order Management (OM), TCA architecture, Purchasing(PO), Inventory(INV), Install Base(IB), Service Contracts(OKS), Oracle Sourcing(PON) with exposure to Bill Of Material(BOM), Work In Progress(WIP) and Fixed Assets(FA) modules.
• Good experience in Procure - to-Pay, Quote-Cash, Oracle Receipts/Payables, iSupplier, Shipping, Advanced Pricing, Inventory, Install Base, Service Contracts and Sourcing business process flows.
• Oracle Certified Associate (OCA), Oracle SOA Suite 11g Certified and Oracle Order Management Certified.
• Worked on Applications Object Library (AOL) features like Descriptive Flex Fields, Value Sets, Concurrent Programs, Responsibilities, Request Sets, Profile Options, Functions, Menus and Printers.
• Comprehensive technical experience in Oracle Applications tools like Oracle Forms, Oracle Reports, Oracle Workflow Builder, Oracle XML/BI Publisher, Oracle JDeveloper and Oracle Discoverer.
• Extensive experience in RICE components (Reports, Interfaces, Conversions, Extensions) and APIs.
• Proficient in customizing the workflows, developing custom Reports/Forms and customizing Standard Forms using Forms Personalization and CUSTOM.LL
• Experience in Oracle Applications Framework.
• Proficient in writing SQL*Loader scripts, UTL FILE packages and UNIX shell scripts.
• Expertise in creating Packages, Procedures, Functions, Views, Materialized Views, Triggers, Indexes and other database objects using Oracle SQL and PL/SQL
• Worked on Advanced PL/SQL Concepts like PL/SQL Tables, Records and Collections.
• Experience in tuning SQL statements using EXPLAIN PLAN, AUTOTRACE, SQLTRACE and TKPROF.
• Good experience in Oracle R12.2.4 online patching coding standards and Edition Based Redefinition feature.
• Exposure to Service Oriented Architecture (SOA)/BPEL.
• Well versed with PVCS (Version Control Systems), ITG/HP KINTANA (Migration tool) and JIRA (Issue tracking tool).
• Leading a team of 7 members a team in Supply Chain Management and Financial modules.

TECHNICAL SKILLS:

Oracle Applications: Oracle E-Business Suite R12(R12.2.4, R12.1.3)/11i (11.5.10,11.5.9)

Modules: Account Payables, Account Receivables, General Ledger, Fixed Assets, Order Management, Advanced Pricing, Shipping, Purchasing, Inventory, Oracle Sourcing, iSupplier, iProcurement, Install Base, Service Contract Bill of Materials, Work In Progress

OAF, SOA: BPEL, Web Services, Business Rules, Mediators, Adapters

Languages: SQL, PL/SQL, UNIX Shell Scripting, XML, JAVA, HTML, C

Development Tools: Oracle Workflow Builder, Oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i, Oracle Discoverer, Oracle XML publisher, JDeveloper,, Logical Apps

Database Tools/Utilities:PL/SQL Developer, SQL*Plus, SQL* Loader, TOAD, FTP, PUTTY, WINSCP

Database: Oracle 11g/10g9i/8i, MS Access, SQL Server 2000, MYSQL

Migration Tools: PVCS, KINTANA/PPM, JIRA, Share Point

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Sr.Developer

Responsibilities:

• Application support/development of various modules like General Ledger, Accounts Payable, Account Receivables, Order Management, iSupplier, iProcurement, iExpense, E-Business Tax, Purchasing and Fixed Assets.
• Worked on FX Rate implementation for Microsoft integration.
• Worked on customer master to build entities using APIs(TCA) - customer inbound into Oracle.
• Worked on TCA architecture and involved in creating customer, organization, sites and other entities.
• Worked on Invoice and Receipts import custom programs.
• Working on all the phases of a requirements cycle including Analysis, Detail Design, Coding, Testing and Deployment.
• Preparing technical design documents based on the functional specifications.
• Development, maintenance, enhancement and customization of Oracle Reports, Oracle Forms, XML publisher and Workflows.
• Development, enhancement and customization of complex Inbound and Outbound data interface programs.
• Worked on Oracle Application Framework personalization and customizations. Modified several OA Framework pages, VO’s, controllers, EO’s etc. using JDeveloper.
• Providing production technical support on day to day issues.
• Modifying/Developing concurrent programs using PL/SQL and Unix Shell Scripting.
• Creating/monitoring of service requests and follow up with the oracle team to fix the issue.
• Constant interaction with the offshore development team with regards to the development requirement changes and discussing the feasibilities.

Confidential

Oracle EBS Sr.Developer

Responsibilities:

• Lead for Oracle R12.2.4 upgrade project with a team of 7 members responsible for mentoring the team and project deliverables.
• Very good knowledge on Oracle E-Business suit R12.2.4 and database 12c architecture.
• Recommending/preparing technical solutions, components estimation efforts, identification of priorities and timelines.
• Used PANAYA tool/Assay tool to identify the objects to retrofit from 11i to R12.2.4 and performed code retrofit of the objects.
• Analyzing and suggesting the solutions to business to fill the gap between R12 features and business process.
• Used Online Patching readiness Reports to identify issues in custom data base objects which needs manual fix.
• Identify and fix custom code to comply with online patching standards.
• Involved in Price lists, Items, Customers, Suppliers and Buyers setups.
• R12 Retrofit of custom packages, reports, forms, workflows, alerts and concurrent programs.
• Worked on monthly Vertex tax updates and Import process.
• Worked on Check printing - Payment Format Programs, mainly used for check printing.
• Worked on AP Inbound Interface Program to create AP invoices through flat file.
• Involved in the design and development of AR Invoice Print, AR receipt creation and AR Invoice Global Delivery programs.
• Designed and developed below conversions for the XRS merger project.
• Price List Conversion, Install Base Conversion, Service Contracts and Subscription
• Contracts Conversion, Item Conversion, On-Hand Quantity Conversion, Sales Order
• Conversion, PO Conversion, Customer Conversion, Supplier Conversion, Fixed Asset
• Conversion, AR Auto Invoice Conversion.
• Worked on CUSTOM.PLL and Form Personalization..
• Worked on OAF customizations.
• Coordinate with the Oracle production support team by providing solutions to business issues in oracle application, fixes and enhancements to custom components.
• Preparing technical specification documents, setup documents, test cases and test result documents.
• Worked on fixing the issues that are created in JIRA issue tracking tool.
• Migration of components to TST/PRD environment by coordinating with Infra database team.
• Created Service Requests (SR’s) and prioritized as SEV1 and SEV2 and conducted Web Conference calls with Oracle support to resolve the issues.
• Leading a team and reviewing all offshore team deliverables and provide training.

Confidential

Oracle EBS Technical Lead/Developer

Responsibilities:

• Involved in business process analysis, requirement analysis, handled full life cycle testing going through Development (DEV), Conference Room Pilot (CRP), Customer Acceptance Test (CAT),
• User training, Go-live and Post Production support in Multi-Org Environment.
• Worked on implementation of Oracle 11i SCM/Finance modules for the QES division in a new environment for the purpose of allowing QES to operate as an independent business from Confidential .
• New process enhancements analysis on the modules Order management, Purchasing, iProcurement, Install Base, Service Contracts and Account receivables/Payables.
• Converted QES data elements from the corporate instance writing the conversion programs
• Open Sales Orders, OM Price Lists, Active customers, Suppliers, Open AR Transactions, On hand inventory, Fixed Assets and Employees.
• Worked on Order to Cash and Procure to Pay cycles.
• Worked on major customization in Service Contract Module. Developed a program to automate the service contract creation to Auto approval stage. Included all the service contracts APIs to create contract, contract line and sub line.
• Worked on RMA (return material authorization) customizations and service contracts.
• Worked on OAF personalization and customizations.
• Worked on Open Interfaces, APIs, CUSTOM.PLL, workflows, forms, xml publisher and reports.
• Creation of new responsibilities using the existing Menu and Menu Exclusions, Request Group, Data Group and Profile Options.
• Worked on registering concurrent programs, executable, creation of request groups, menus, value sets, request Sets, Flex fields in System Administration.
• Defined new periodic and event based Oracle alerts to send emails based on business requirements.
• Writing Functional design, Technical design and Test Script documents.
• Responsible for preparing the Rollout Plans.
• Worked on PVCS tool for version control, KINTANA for code migrations and HP PPM for logging the requests for requirements.
• Preparation of weekly status report to ensure the delivery of components on time.
• CO-ordination with the offshore development team with regards to the development requirement changes and change requests .

Confidential

Oracle EBS Techno-Functional Lead

Responsibilities:

• Responsible for leading the complete Requirements Gathering, Analysis, Design, Development, Functional Testing, Unit Testing and System Integration Testing.
• Worked on Purchasing, Inventory, Sourcing and iSupplier business flows, setups and functionality.
• Worked on creating Purchasing Orders, Blanket Purchase Agreements, defining Items, defining Sub inventory locations, creating Suppliers and creating Buyers.
• Involved in the setup of new module Global Sourcing.
• Involved in implementation of a new Operating Unit and a new Inventory Organization.
• Worked on major customizations like Custom program to auto create BPA in Taiwan OU, Custom BPA release creation for Taiwan, Price change to all the BPA released, BPA release create/Top Up/Drop Down/Close, OA custom Trigger, BPA Non Editable Personalization.
• Worked on Item category mass upload, Sourcing Rule mass upload, BPA mass upload and assign in ASL.
• Customized approval hierarchy level and PO requisition workflows in Purchasing as per the business requirements.
• Worked on a new Custom form for Mass Approval.
• Worked on OAF personalization and customizations, customized iProcurement, Sourcing pages as per the requirements using JDeveloper.
• Designed and developed purchase order import interface program to import standard purchase orders.
• Worked on Requisitions Import Interface program to upload purchase requisitions data to Oracle Purchasing.
• Designed and developed Vendor conversion program to import vendors from one operating to another operating unit.
• Designed and developed Item Conversion Program.
• Worked on Common BOM process program.
• Designed and implemented Forecast upload program from various demand sourcing - Demand from APS Financial measure demand, Taiwan (T60-Buy) demand from MRP.
• Worked on registering concurrent programs, executables, creation of Responsibilities, request groups, menus, value sets, request Sets, Flex fields in System Administration.
• Worked on Open Interfaces, APIs and CUSTOM.PLL.
• Preparing test plans and unit testing of the components developed.
• Coordination with offshore team and code reviews.

Confidential

Senior Technical Developer

Responsibilities:

• Involved in the development of major project ‘NOKIA’ inter org transfer process.
• Worked on Order management Advanced Pricing project. Involved in complete design and development of this project.
• Worked on Order Management R12 upgrade project.
• Worked on Quote to Cash, Procure to Pay and Inventory process flows.
• Involved in Price lists, Items, Customers, Suppliers and Buyers setups.
• Worked on Vendor Managed Inventory, Inter org transfer interfaces, Item conversion and Purchase orders conversion programs.
• Worked on Business Events and Processing Constraints.
• Customized OE Order header and OE Order line Workflows as per the business requirement.
• Involved in CUSTOM.PLL and Form Personalization.
• Extensively worked on OM API's like order creation, order updation and pricing.
• Worked on Order Import Interface and Purchase order import interface.
• Design, Development and Customization of Oracle Reports, Oracle Forms, Oracle Alerts and Oracle Workflows in modules like Order Management, Purchasing, Inventory, Account Receivables, Account Payables, Bills Of Material.
• Modified custom programs using APIs to create new contacts, address and phone numbers for every new customer in the Trading Community Architecture (TCA).
• Batch Data loads and data fixes using open interfaces and APIs.
• Developed and customized reports using XML Publisher in OM, PO, BOM, AR, AP and INV.
• Implemented Bursting logic for many XML Publisher reports to e-mail the output to particular list of users each time a report is ran.
• Development of components like interfaces, conversions and extensions.
• Imported data from legacy system to Oracle tables using SQL*Loader and validate them using PL/SQL procedures.
• Created AR reports like Aging Seven Buckets Report, Invoice Register Report using Oracle Reports.
• Developed various reports like PO Print Report, Invoice Printing, Attachment report and Credit Memo Report using Reports 6i.
• Worked on the issues of Orders with Pick Release and Ship Confirm processes.
• Developed various Custom Reports XML Publisher for Order Dispatches, Slow Moving Inventory and Order booked but not scheduled/dispatched, Cancelled Sales Orders.
• Migrating the code using kintana tool.
• Responsible for preparing functional designs documents, technical design documents and test case documents.
• Co-ordination with offshore team, code reviews and preparing the weekly status reports.

Confidential

Technical Developer

Responsibilities:

• Worked on MFG simulation project (Demand/Supply and Planning, Forecasting).
• Defined Concurrent programs, responsibilities, profile options, functions, menus, alerts, request sets and value sets.
• Created PL/SQL packages, procedures, functions, triggers, views and other PL/SQL objects.
• Worked on OEOH and OEOL workflows changes.
• Worked on ITG cases involving various Confidential processes like
• Confidential Packs and Pallet Customization, Trade Export System Outbound Interface
• Collection Letter Print Program, RMA Receipting, Validation and Defaulting Rules
• QCT Service Contracts Expiration Report, Ability to Email the Collection Letter
• Remap Repair line type logic for Repair Billing.
• Development and enhancement of Oracle reports and XML Publisher reports (PO print program).
• Development of PO Email Notification program for Purchase Orders.
• Worked on Inventory Outbound Interface Program to extract data from base tables to flat file using UTL FILE package.
• Extensively worked on Format Triggers, Formula/Summary/Placeholder Columns and Ref Cursor Query for developing the reports and prepared complex Data Model/ Data Layout in Oracle Reports 6i.
• Extensively worked on report attributes like Report Triggers, Program Units, Attached Libraries and Built-in Packages that involve complex PL/SQL codes.
• Worked on discoverer reports.
• Batch Data loads and data fixes using Open Interfaces and APIs.
• Development, Maintenance, Enhancement and Customization of Oracle Reports, Oracle Forms, Oracle Alerts and Workflows.
• Responsible for creation of technical design documents and test case documents.
• Unit testing and system integration testing for the components developed.
• Migration of components to TST environment by coordinating with quantum infra core team.