Oracle Project

Oracle Apps Techno Functional Consultant/ Lead Resume

Title

Oracle Apps Techno Functional Consultant/ Lead

Primary Skills

Oracle E-Business Suite 11i/R12, RICE, OBIEE, P2P, O2C, OAF, BPEL, CRM, Distributions, Financials, Oracle 8i/9i/10G,

Location

US-MA-Natick (will consider relocating)

Posted

Nov-09-09

RESUME DETAILS

PROFESSIONAL SUMMARY

• Have 13 years of total IT experience in software applications/development including 7 years of experience on Oracle E-Business Suite 11i/R12 as Oracle APPS Consultant plus good project management/team management

• Good team player as PM/Lead/Consultant/Programmer Analyst/Developer.

• Good experience in study/audit of existing business process and preparation issue logs, collection of functional/technical requirements, client/user interaction, GAP Analysis, technical data mapping analysis and design of technical/functional data process flow charts.

• Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization of forms using CUSTOM.pll, reports using Report builder 6i, XML Publisher and exposure to WF, Oracle Discoverer, OAF using JDeveloper 9i and development of business reports using OBIEE.

• Areas of expertise include technical developments in GL, AP, AR, INV, OM, PO, BOM, TCA, Service Contracts (OKS) ERP modules.

• Good functional knowledge in O2C and P2P cycles, GL, INV, CRM Foundation, Deport Repair and Service Contracts.

• Have 5 full cycle end-to-end implementation and one support project(s) experience.

• Rich experience in registration/migration of Forms, Reports, OAF UI pages, PLSQL programs, Oracle Discoverer and XML Publisher Reports

• Good at sysadmin and AOL activities including creation of KFFs, DFFs, users, responsibilities, menus, concurrent programs, request sets, request groups, value sets.

• Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs.

• Migration of legacy data to oracle using SQL*Loader and UTL_FILE utilities

• Knowledge of underlying table structure of oracle applications modules for development of enhanced functionalities.

• Participate in CRP meetings for gap analysis

• Implementation experience using AIM Methodology

• Setup of GL chart of accounts and set of books.

• Setup of master items using item templates.

• Good experience in development of functional/technical design documents.

• Support and involvement in risks identifications and risk mitigations

• Good communication skills, inter personal skill and problem solving ability.

EDUCATION

• Bachelor of Technology (Mechanical Engineering).

TRAINING & CERTIFICATION

• Development and testing activities on Financial, Manufacturing, Sysadmin/AOL and CRM modules of Oracle Applications EBS 11i/R12.

• In-house training on BPEL on JDeveloper 9i and OBIEE from trainer of Oracle University.

• Attended 35 hours of class room training program on Project Management -- Book of Knowledge (PMBOK)

TECHNICAL SKILLS

ERP Applications: Oracle EBS 11i/R12 -- Financials - GL, AP, AR, FA, Distributions -- OM, Shipping, Supply Chain -- INV, PO, BOM CRM -- CRM Foundation, TCA, Service Contracts (OKS), Depot Repair, Install Base

Methodology: Application Implementation Methodology (AIM)

Languages: SQL, PL/SQL, C, C++, Java

Tools: SQL * Loader, TOAD, Data Loader

Databases: Oracle 8i/9i/10G, DB2, Ms Access

Operating Systems: Windows 2000/NT/XP, AIX 5.0, HPUX- 2.0

GUI: Forms 6i, OAF using JDeveloper 9i/10g

Reporting Tools: Reports 6i, XML Publisher, OBIEE, Oracle Discoverer

Web Technologies: J2EE, HTML, XML, JavaScript, Applets, Servlets, JSPs

Utilities: IE 5.0/5.5, Netscape 4.7/6.0, Mozilla, Putty, WinSCP

Integration Tools: BPEL using JDeveloper 9i

PROFESSIONAL EXPERIENCE

Beckman Coulter - DSL, LA Oct '08 to Till Date

Project: Oracle E-Biz Suite Implementation (11.5.10.2)

Solutions: Distribution, Financials, CRM

Role: Tech Lead

Responsibilities:

• Functional / Technical analysis of existing business process flow.

• Technical analysis of existing functionality/code of CUSTOM.pll to add radioactive license functionality.

• Developed a PL/SQL package procedure to validate the radioactive license for ship-to location of a customer during the process of sales order entry thru shipment.

• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs

• Preparation of technical specifications and testing scenarios based on functional design.

• Migration of code to different instances using KINTANA

• Development of reports using OBIEE (using Administration, Publisher. Answers and Presentation Services)

• Preparation of technical design document MD070, installation document MD120 and technical process/data flow chart.

Environment: Oracle Applications 11i -- INV, OKS, OM, CUSTOM.pll, OBIEE, Oracle 9i SQL, PL/SQL, Developer 2000 Forms 6i, TOAD.

SMART Technologies, Chicago IL Mar '08 -- Sep '08

Project: Oracle E-Biz Suite R12 Implementation

Solutions: Financials, Inventory, Distributions

Role: Senior Consultant

Responsibilities:

• Responsible for managing the RICE development team at offshore

• Create business process flows and implementing Purchasing, Payables, Inventory and Receivables Modules on Oracle EBS

• Lead for all RICE components

• Involved in gathering client requirements

• Provide estimates for all technical components

• Preparation of data Conversion Strategy from legacy to oracle database as per the client standards

• Involved in negotiation of project estimates

• Responsible for conversion of AR Invoices, INV Items and Item Costs using oracle PL/SQL

• Development and update of technical design/migration documents MD070s and MD120s, CV060s.

Environment: Oracle Applications R12 - PO, AR, INV, Oracle 9i SQL and PLSQL, Toad

REDDOT Corp, Seattle WA Sep '07- Feb '08

Project: Oracle E-Biz Suite 11i (11.5.10.2) Implementation

Solutions: Inventory, Distributions, Purchasing

Role: Senior Consultant

Responsibilities:

• Contributed as a tech lead for development team at offshore

• Responsible to track the development of all the RICE components with the team on daily basis

• Involved in the business meetings with client/users at all stages of implementation i.e. CRPs, UAT and Go-live.

• Requirement gathering from functional/client implementation team

• Interaction with users on specific BRs and CRs.

• Involved in CRP and UAT meetings

• Involved in negotiations on estimates for CRs and additional technical developments.

• Resolving of technical / functional issues at client place and communicating/coordinating on the issues with the offshore team.

• Technical analysis of existing business process flow based on the functional designs.

• Design and development of technical data flow charts and offloading the same to development team at offshore

• Responsible for development and delivery of Conversion/Interface programs for Items, Item Costs, BOMs and POs including SQL and XML publisher reports

• Development and update of technical design and migration documents (MD070 and MD120)

Environment: Oracle Applications 11i - INV, BOM, PO, Oracle 9i SQL and PL/SQL, Reports/Forms 6i, SQL and XML Publisher reports, TOAD.

Ritchie Bros Auctioneers (RBA), CANADA Sep '06 -- Aug '07

Project: Oracle E-Biz Suite 11i (11.5.10.2) Implementation

Solutions: Payables, Receivables, Projects, TCA, BPEL using Jdeveloper 9i

Role: Senior Consultant

Responsibilities:

• Involved in the project meetings to define/direct project goals and objectives

• Day to day status track of project RICE components with offshore development team

• Resolving of technical/functional issues within the development team

• Development of customer interface using Oracle standard TCA APIs including DQM rules

• Responsible for development of AP--AR Netting Interface, de-activation of Parties and Customer Accounts in AR/TCA

• Customization of existing interfaces which interfaces with AR, Projects and iSeries (legacy instance).

• Development of BPEL Processes to integrate with legacy systems to Oracle using BPEL Process Manager and Oracle JDeveloper 9i

• Development of technical design and migration documents

Environment: Oracle Applications 11.5.10.2 -- AR, AP, Oracle Projects, TCA, Oracle SQL and PL/SQL, TOAD, BPEL and OAF using JDeveloper 9i

FARES, CA Sep '05 -- Aug '06

Project: Oracle E-Biz Suite 11i Implementation

Solutions: Receivables, Service Contracts, Quotes, Work Flow

Role: Senior Consultant

Responsibilities:

• Involved as an onsite coordinator

• Responsible for development and delivery of RICEFW components at offshore team

• Negotiated and managed for development of iStore components by resources from engineering team at offshore

• Involved in setup and implementation of Service Contracts depending on functional setup changes/enhancements.

• Documentation of High level Technical/Functional designs i.e. MD050s and MD070s

• Managed offshore development team successfully to meet the project milestones as per project management plan including quality and schedules.

• Day to day status track of development progress at offshore

• Responsible for the development of conversions/interface programs - Barter Tax interface, Conversion of service contracts from quotes

• Development of QA validation rules

• Registration of process definitions to validate the service contracts created from quotes.

• Development and testing of Quotes created from Service Contracts which is known as Super Quotes using oracle standard APIs

• Involved in code review, code migration and code test.

• Responsible for review of functional designs

• Responsible for development of technical process flow charts.

• Preparation of test scenarios/cases for all technical components bases on functional designs

• Involved in the documentation of technical designs -- MD070s and installation scripts.

Environment: Oracle Applications 11i - Service Contracts, AR, Quotes, WF, Oracle SQL and PL/SQL, Reports/Forms 6i, TOAD.

Cobalt Group Inc., Seattle WA May '05 -- Aug '05

Project: Oracle E-Biz Suite 11i (11.5.8) Implementation

Solutions: Receivables, Service Contracts, OM, WF

Role: Senior Consultant

Responsibilities:

• Responsible for analysis/development of functionality integrating Oracle Order Management and Service Contracts.

• Designed and developed the OM-SC integration technical process flow charts

• Ensured the dependencies of Service contracts with pre-existing modules.

• Involved in collection of business requirements

• Preparation of estimations for project execution

• Responsible for development and delivery of integration and conversion programs

• Delivery of solutions with high quality as per the project schedules

• Day to day status track of issue logs.

• Development of technical design and installation documents

• Developed data extraction programs using UTL_FILE packages

• Functional testing of OM-SC integration process

• Responsible for development of service contacts conversion program

Environment: Oracle Applications 11.5.8 -- Service Contracts, AR, OM, WF, Oracle SQL and PL/SQL, Reports/Forms 6i, TOAD.

Zensar Technologies Ltd., ZenApps, INDIA Feb '04 to Apr '05

Project: Oracle E-Biz Suite 11i Implementation

Solutions: GL, Payables

Role: Consultant

Responsibilities:

• Involved in the post implementation support activities

• Responsible for new development and change requests

• Technical analysis of existing RICE components

• Design, code, Test and code re

©2003-2012 Dev Bistro

Contact this candidate