SUMMARY

• 13 years of IT Experience, 11 years of experience in as Oracle Techno Functional Consultant in system analysis, development, customization, implementation, upgrades, rollouts, production support, and integration of Oracle EBS Application 10.3, 11i (11.5.9, 11.5.10) and R12(12.1.3, 12.2.3).
• Full life cycle implementation experience in Oracle Applications SCM & Manufacturing modules (PO, INV, PIM BOM, WIP, MDS, MPS, MRP, Oracle Service Contract, Warehouse Management System, ASCP, MSCA, OM, Advance Pricing, Costing, Quality), Finance modules (GL, AP, AR,, I - supplier, I-sourcing, I-procurement, I-store, Fixed Asset, CM) and Project Accounting.
• Extensive pre and production support experience in managing client issues, and provide quick around solutions, On-site/Offshore co-ordination, people management and project management.
• Extensive experience in business meetings with business users to gather requirements, to create design document and perform impact analysis for Oracle EBS functionalities.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, reports using Report builder 6i, BI Publisher, Workflow, Oracle Discoverer, OAF Developer (9i /10g).
• Good exposure on procure to pay, assemble to order, pick to order, order to cash, quote to order business cycles.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL, and built-in APIs.
• Sound knowledge in costing, receipt accounting, SLA from SCM modules to GL.
• Good exposure in month end activities in PO, OM, INV, WIP, AP, AR modules.
• Having lead experience with 15-20 team size, for requirement gather from business users and provide technical design document to technical team.
• And, guide technical team in development of reports, conversions, interfaces, and extensions for Oracle Applications.
• Having experience in design documents (BR100), and functional design documents (MD050), and technical design document (MD070).
• Well versed with Oracle standards and AIM methodology.
• Rich experience in environments requiring direct customer interaction during specifications, documentation, design and development and implementation phases
• Strong analytical and diagnostic skills and ability to work in a fast-paced and team-oriented environment.
• Conducted System Integration Testing (SIT), and User Acceptance Testing with business users.
• Expertise in functional setups for SCM & Manufacture modules (PO, OM, INV, BOM, WIP, MDS, MPS, MRP, Advance Pricing).
• Having solid experience in P2P, O2C, and Assemble to Order, Pick to Order, and Quote to Order.
• Worked extensively with AIM documents like MD50, MD70, MD120, CV40, CV60, and CV80

TECHNICAL SKILLS

Oracle Applications Modules: INV, BOM, WIP, PO, OM, I-supplier, I-sourcing, I-procurement, Costing, Quality Advance Pricing, Warehouse, MSCA, GL, AP, AR, CM, PIM, Service Contract

Oracle Applications Releases: 10.7, 11i (11.5.9, 11.5.10), R12 (12.1.3, 12.2.3).

O.S & RDBMS: LINUX, HP UNIX, SUN Solaris, and WINDOWS NT/2000/XP, Oracle 8i, Oracle9i/10g/11g, MYSQL, MS Access

Languages: SQL, PL/SQL, Shell Script, Dev6i, HTML, XML, and Java

Tools: & Utilities: Oracle SOA, OAF, Developer, SQL *Plus, SQL *Loader, Workflow Builder 2.6, Dev 6i/2000, Discoverer 4i, XML Publisher, Developer, Demantra

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Analysis of current business processes and definition of new processes within Oracle Application.
• Actively involved in POC to understand the existing system functionality and documented business gaps.
• Provided business solutions in supplier, procurement modules and documented business gaps.
• Provided business solutions in Warehouse Management System and Mobile Supply Chain Application.
• Business requirements gathering, mapping, gap identification and workarounds.
• Business processes definitions to be implemented within new environment.
• Business demand using through the MDS, MPS, MRP, ASCP modules.
• Involved in the Costing and Quality process within business.
• BR100 and MP050 documentation.
• Worked on item conversions and prepared conversion documents (CV10, CV.040).
• Developed conversion and interfaces in PO, OM modules.
• Customized and developed workflow components in PIM module.
• Customized PIM user interface screens using OAF technology.
• Developed conversions/interfaces in Order Management, Pricing, PIM, and TCA modules.
• Developed workflow components in Order management module using Workflow builder.
• Designed and developed Open Interface to load Advance pricing price lists, qualifiers, modifiers, and legacy sales orders.
• Designed and developed Pricing business rules and integrated with Oracle Order Management to get price and Tax.
• Customized various reports (e.g., Packing List Report, Delivery Note, Shipping Label, Customs Invoice Report, Commercial Invoice, etc.) in OM, INV, and Shipping according to customer requirements using Oracle Reports and XML Publisher.
• Worked on the tuning for the application report queries and other SQL queries to improve the performance.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Customized Dashboard reports using drill-down capabilities.
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Developed conversion in INV module for material transactions, on hand quantities, customer items.
• Document MD 050, MD070 Technical Specifications and Test Case documents for all the development work done.

Environment: Oracle EBS 12.1.3, Oracle EBS 12.2.3, HP UNIX, Oracle 11g, TOAD, jDev 11g and Dev 10g

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Development of RICEW objects in AR, AP and CM modules.
• Supporting users in project accounting related issues.
• Extensively involved for development customer invoice and different kind of receipts.
• Developed the Household and Commercial Invoice program.
• Developed the Credit Memo for use to return the payment to the customer.
• As team lead to provide technical design documents to technical team, and guided tables, APS’s to technical team.
• Code optimization & code review of fellow team members.
• Coordinating meetings with Business team and functional team for technical specification based on functional document.

Confidential, NY

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Designed and delivered various customizations and interfaces to meet client’s specific business requirements and restrictions.
• Involved in CEMLI Review, CEMLI Scorecard and present CEMLI review result to stakeholders to avoid unnecessary customizations.
• Prepared Set-up documents & Solution documents for the entire solution Implemented.
• Build various customizations and interfaces, OM, Shipping, INV, and PO.
• Build and configured XML bursting files for PO reports, and vendor payments.
• Issue tracking, analysis and resolution during the entire tenure of project.
• Involved in Unit Testing, System Testing, System Integration Testing, User Acceptance Testing and Operational Acceptance Testing.
• Integration responsibility of different CEMLI.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Responsible for End-to-End implementation of Inventory, PO, OM, I-store, I-procurement and I-supplier implementation.
• Configuration of position hierarchy in the PO.
• Designed and delivered various customizations and interfaces to meet client’s specific business requirements and restrictions.
• Involved inCEMLI Review, CEMLI Scorecard and present CEMLI review result to stakeholders to avoid unnecessary customizations.
• Prepared Set-up documents & Solution documents for the entire solution Implemented.
• Issue tracking, analysis and resolution during the entire tenure of project.
• Involved inUnit Testing, System Testing, System Integration Testing, User Acceptance Testing and Operational Acceptance Testing.
• Integration responsibility of different CEMLI
• Build plan and check list.
• Pack preparation & release the pack.
• Service Delivery Manager and responsible for client relationship.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Design and development of inbound/outbound interfaces.
• Designed and developed RDF and Discoverer reports.
• Managing technical team with 7 technical consultants.
• Technical guidance and support to the team.
• Implemented Form personalization and Alerts.
• Identify root cause for the support SRs and providing fix.
• Allocation of SR to team based on priority, expertise of the resource.
• Service Delivery Manager and responsible for client relationship.
• POC for the support contract.
• Providing the status update to the client and oracle project management.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• OM functional setups
• Workflow components development in OM module.
• Developed RICEW components in SCM modules.
• Strong experience Oracle API’s for conversions and interface.
• Developed 15 reports using Oracle reports and XML Publisher.
• Designed and developed custom Workflow components using Oracle Workflow builder to fulfill client business rules to process sales order.
• Involved in debugging various Pricing, OM, Pricing module related Functional Issues.
• Debugged various workflow related issues related to OM module.
• Involved in debugging various PIM related issues.
• Developed various new custom reports in AP and PO Modules.
• Developed various Extensions and Personalization’s in OM.
• Prepared Module Design technical documentation MD070.
• Created custom Shell scripts to handle the loading the data file into the custom tables and archiving of the data file.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in supporting customization in Oracle payables, Oracle Purchasing, Project Accounting.
• Analyzing the existing customization and re-modeling the existing customization to support efficiently.
• Client Communications for solving different issues.
• Code Reviews and preparation of the technical design documents for new developments.
• Reporting the Production support metrics.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Review the TAR Status of all open service request.
• Providing technical mentoring to team member to fix the issue in quick timeline.
• Check whether TARs in WIP Status are updated.
• Check the SR resolution Sheet. Ensure all entries are there.
• Monitor whether the SLAs are adhered too.
• Conduct / arrange weekly team meeting.

Confidential

Application Developer

Responsibilities:

• Involved in the support phase of various oracle Apps customizations.
• Develop many PL/SQL program.

Confidential

Application Developer

Responsibilities:

• Involved in the development of the various form and reports.
• Develop many PL/SQL program.