Sr Oracle apps developer BPEL / SOA Resume




Title
Sr Oracle apps developer BPEL / SOA

Primary Skills
Oracle apps SCM/CRM modules, BPEL process Manger,reports,forms,TOAD

Location
US-CT-South Windsor (will consider relocating)

Posted
Dec-19-08

RESUME DETAILS
PROFESSIONAL HIGHLIGHTS

• Over 6 Years of IT experience in Design, Development and Implementation of software projects.
• 5+ years of experience in implementation and customization of Service Contracts, Install base, OM, INV, PO, AR, OA Framework, TCA and SCM/CRM modules of Oracle Applications ERP/E-Business Suite (EBS).
• Expertise in working with BPELProcessManager(Part of SOA suite10g).
• Experience in developing and modifying reports using Oracle Reports 6i, Discoverer 4i/9i/10g.
• Experience in Application Implementation/Enhancement, Unit testing, Integration Testing, Production Support and Maintenance of RICE Components.
• Experience working with Interfaces and conversions.
• Proficient in writing stored procedures, packages, functions & triggers using PL/SQL.
• Well versed with client server environment and tools like Developer/2000,SQL*Loader, Jdeveloper and TOAD.
• Familiar with AIM Methodology in Implementing Oracle Applications.
• Experienced with business process/requirements analysis, module set up and configuration, documentation, ability to spec customizations and reports, and knowledge transfer experience.
• Capable to work on multiple tasks and also to work independently with minimum supervision with people from all levels of corporate management.


SKILLS SUMMARY

Oracle Applications Oracle Applications 11i/12 (INV, OM, PO, Oracle Shipping,
Advance Pricing, Install Base, Service Contracts, AR and CRM (TCA))
Operating Systems UNIX, Sun Solaris 5.8, WINDOWS NT/XP
Languages C, SQL, PL/SQL
RDBMS Oracle 9i/8.x
Tools SQL*PLUS, SQL*Loader, Toad, JDeveloper 9i
GUI Tools Developer 2000, Oracle Reports6i, Discoverer 4i/9i/10g


EDUCATION
Bachelor of Technology, INDIA


PROJECT EXPERIENCE


Herbalife, Torrance, CA Jul 2008 to Present
Oracle Applications Developer

Responsibilities:
• Design and developed middle ware solution for interfaces using BPEL Process Manager and JDeveloper.
• Developed technical specifications for inventory item import, sub inventory locations import and transactions import for item costs and on hand quantity.
• Design and Develop complex error reporting interface with systematic notification across Enterprise and legacy applications using pl/sql, xsu, BPEL process and BAM.
• Define WSDL for BPEL process, partner links, BPEL process templates and developed process logic definition.
• Design and Developed ESB processes, configure database, file adapters and tuned BPEL and ESB processes.
• Designed several facturas in order to generate NTS(notification to shipment).
• Involved in capturing the Brazilian distributor name on the shipping information region using a DFF.
• Created various new forms and integrated them to the existing GOC in order to capture distributor details and all.
• Responsible for developing and customizing complex reports like Daily Inventory report, Transaction Historical Summary report, PO Report, Invoice report, etc.
• Developed various Discoverer reports such as
o Material Issuance Per Period
o Sales Order Browse Report
o Vendor Payment terms Report

Environment: Oracle Applications 11i, Jdeveloper 9i, Discoverer,BPEL/SOA,OM, AR, TCA ,OAFRAMEWORK


Sun Micro Systems, Santa Clara, CA APR 2008 to JUN 2008
Oracle Applications Developer

Responsibilities:

? Involved in developing 3 new Interfaces in Service Contracts
o Evs Asset Entitlement Interface
o Get accounts by using CWP id
o Sun Inventory Outbound Interface
? Involved in modules such as Install Base, TCA.
? Over 20 large BPEL processes developed.
? Leading the BPEL development work in WPS, as well as mentoring client programming staff on the tooling.
? Developed technical modeling and BPEL implementation best practices relevant to the client's environment and experience level.
? Developed a suite of utility services (Java components, Web Services, REST Web Services, code-instantiated and invoked BPEL utility processes.
? Also responsible for handling and maintaining Bugster such as giving daily updates regarding daily issues and all.
? Developed MD120's and QA checklists for the above interfaces.

Environment: Oracle Applications 11i, Discoverer, Toad, BPEL
Modules: OM, Service Contracts, Install Base, Inventory, TCA ,OAframework

Océ Imagistics, Trumbull, CT Jan 2007 to Feb 2008
Oracle Applications Techno functional Consultant

Responsibilities:

• Responsible for Analysis, design, development, customizing, interfacing, testing and integration of OM, AR, Service Contracts and Install Base.
• Worked on Order-to-Cash and Procure-to-Pay process flows.
• Design and Develop complex error reporting interface with systematic notification across Enterprise and legacy applications using pl/sql, xsu, BPEL process and BAM.
• Designed and customized reports using Oracle Reports Builder 6i in OM and Service Contracts: Sales Order Report with Contract Details/Holds Release Report/Product Transaction Listing by Product
• Developed custom PL/SQL to facilitate conversion of invoices, credit memos and debit memos from legacy systems into Oracle Receivables using the Receivables open interface Auto Invoice program.
• Experienced in working with order management interfaces like Order Import interface and also in using other interfaces like Customer-conversion interfaces etc.
• Also involved in handling different public API's in Service contracts
? OKS_ENTITLEMENTS_PUB,
? OKS_CON_COVERAGE_PUB,
? OKS_OMINT_PUB
• Involved in functional setup like defining Pick slip Grouping Rules, Release sequence Rules and defining Document Sets.
• Developed OM Extract for the Daily, Weekly, Monthly analysis for the Order Status in Discoverer.
• Developed an IB Outbound package for Oce Automated Sales Information System which helps the sales force to monitor and forecast the Service item information.
Environment: Oracle Applications 11i/12 Oracle 9i, UNIX, BPEL,Oracle Reports 6i, Toad, Discoverer
Modules: Oracle Order Management, AR, Install Base, Service Contracts, TCA.


ADVO, Windsor, CT July 2006 to Nov 2006
Oracle Applications Techno functional Consultant

Responsibilities:

? Involved in functional setups like Item Categories, Catalogs and item Templates in inventory.
? Developed PL/SQL program to perform validations and to relate customers with addresses, contacts, banks and profiles and move the data from staging table to interface tables.
? Developed technical modeling and BPEL implementation best practices relevant to the client's environment and experience level.
? Designed and developed various reports in modules like OM, AR and Service Contracts using Discoverer 9i and Oracle report builder..
? Used Customer Interface standard program to load customer details in Oracle Receivables
? Involved in handling several APIs in service contracts such as using different packages of service contracts (OKS).

Environment: Oracle Applications 11i/12 Oracle 9i, BPELUNIX, Oracle Reports 6i, PL/SQL 9.x, Toad
Modules: Oracle Order Management, TCA, AR, Install Base and Service Contracts.


Philips Services, Houston, Texas May 2005 to April 2006
Oracle Applications Technical Consultant

Responsibilities:
• Developed a conversion program to get the data of Items On Hand Balances from legacy system to Oracle. Developed validation programs to validate the data before loading into interface tables.
• Designed Reports using Discoverer 4i/9i in modules like PO, AP and AR
? Active Vendors Report
? Supplier Payment History Report
• Customized reports using Oracle Reports Builder 6i in OM modules as per user requirements
? Orders Summary Report
? Hold Release Report
• Designed and developed the item update program to change the item status based on the given conditions using the item update API.
• Involved in defining and creating customer relationships and profiles using customers online with TCA.
• Involved in Quotes, and Notes conversion into Oracle Standard Application Schema Using Standard API's.

Environment: Oracle Apps 11.5.10, Oracle 9i, UNIX, Reports 6i, SQL*Loader, Toad 8.0
Modules: OM, Oracle Purchasing, CRM (TCA, Sales Online), Oracle Account Payables.


Handleman Company, Troy, MI Jan 2004 to Mar 2005
Oracle Applications Consultant

Responsibilities:
• Involved in development of inbound interface package to validate and import order details into Oracle Applications (OM order interface tables) from external system.
• Interpreted the end-user business requirements to design and develop complex Discoverer 9i reports.
• Created parameterized reports using Discoverer Plus in modules like OM
? Product Transaction Listing by Customer Report
• Defined custom Menus, Value Sets, Responsibilities and Concurrent Programs.
• Responsible for developing custom reports using Oracle Builder 6i.
• Used Customer Interface standard program to load customer details in Oracle Receivables
• Responsible for Item Master set up and loading using Item Master Open Interface.
• Extensively worked on Format Triggers, Formula Columns, Summary Columns and Placeholder Columns for developing the reports and prepared complex Data Model and Data Layout in Oracle Reports 6i.
• Worked as a System Administrator in creating the responsibilities, menus and maintaining the user logins.

Environment: HP-UNIX 11, Oracle Applications 11i, Oracle Account Receivables, Oracle Purchasing, Oracle Order Management, Reports 6i, TOAD, UNIX.


AP RAYONS LTD, Hyderabad, India Feb 2002 to Nov 2003
Oracle Applications Developer

Responsibilities:
• Responsible for customization of reports according to client requirement in key indicator report and Distribution detail report like Account Status Report, Transaction Detail Report, etc.
• Loaded data into oracle tables using SQL*Loader and dbms_utility package.
• Responsible for developing and customizing complex Reports (6i) as per the client requirements in INV and OM modules.
• Performed SQL tuning using Explain plan and tuning database with appropriate indexes.
• Creating users & modifying the privileges for users. Creating appropriate roles and assigning it to users.

Environment: Oracle Applications 11.0, Oracle Inventory, Oracle Purchasing, Oracle Order Management, Accounts Receivables, UNIX, Shipping, Oracle 8, PL/SQL.

Certifications
See above

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »


Resumes in South Windsor, CT | Resumes in Connecticut

View other Sr Oracle apps developer BPEL / SOA resumes, System / Network Administrator resumes