SUMMARY

• 14 years of IT experience with more than 12 years of experience in Oracle ERP/CRM and 10+ full life cycle developments.
• Extensive client liaison involving Strategy, Design, Requirements & Gap Analysis, Functional and Technical Specifications, Test plans and supporting documentation.
• Broad experience in writing business requirements and related documentations. Set - up and configuration of Oracle EBS module in a multi-org and multi-business group environment.
• Functional expertise in design, customization and implementation of Oracle11i/R12 versions of Order Management, Shipping, Advance Pricing, Purchasing, Inventory
• Oracle Product Data Hub (PDH), Master Data Management (MDM including CDH), TCA, Service Contract, Installed Base, Oracle Assets, WMS, MSCA, BOM, WIP, Engineering, Fixed Assets and Financials(AP & AR).
• Rich experience in Procure to Pay and Quote/Order to Cash process cycles.
• Well versed in gathering requirement for, interfaces, conversions, extensions, forms, reports, mobile Web Applications (MWA) used in MSCA/WMS, Discoverer EUL and Business objects.
• Excellent business analysis, interpersonal and organizational skills.

TECHNICAL SKILLS

ORACLE Applications: Oracle 12i/11i/11.03/10.7, Oracle Alerts, Workflow, Application Object Library (AOL), System Administration, EDI/E-commerce Gateway, AIM, TCA.

Oracle ERP: Order Management, Shipping, ASCP, configurator, Advance Pricing, Inventory, BOM, Purchasing, Sourcing, WMS, MSCA, Engineering, BOM, Master Data Management (MDM), Product & Customer Data Hub (PDH, PIM, CDH), and Data Quality.

Oracle Financial: Cash Management, Payables, Receivables, Fixed Assets, and iExpense.

Oracle CRM: Contracts, Service Contracts, Install Base and Telesales.

Programming Languages: Oracle 10g/9i/8i/7.x SQL, PL/SQL, Java, C, C++, Fortran, Perl, Shell scripts.

Tools: Microsoft Project, Toad, Discoverer 3i/4i/9i/10g, Workflow Builder 2.6/2.x, JDeveloper, Oracle Forms 9i/6i, Oracle Reports 9i/6i and SQL*loader

PROFESSIONAL EXPERIENCE

Confidential, TX

Functional consultant (Oracle R12.1)

Responsibilities:

• Analyzed and prepared business requirements (BR35), functional design (MD50), configuration (BR100), test plans (TE20/40) and conversions (CV40) documents for MDM PIM, INV and BOM.
• Created Functional Design for inbound and outbound interfaces b/w PIM and spoke systems.
• Addressed issues with data migration from legacy systems for conversions including data profiling, validation, clean-up and remediation of INV and BOM data.
• Created Functional Design document for Approval workflow and notifications workflows, custom extensions, reports and conversions for MDM CDH, INV and BOM modules.
• Prepared Test scripts for CRP/UAT, provided technical and functional support to the Business users during development, testing, and post production of business solutions.

Confidential, GA

Functional consultant (Oracle R12.1)

Responsibilities:

• Analyzed and prepared business requirements (BR35), functional design (MD50), configuration (BR100), test plans (TE20/40) and conversions (CV40) documents for MDM CDH, INV, BOM and PO
• Participated in workshops to design to-be process flows, and design customizations for MDM CDH, INV, BOM and PO modules.
• Created detailed Functional Design for orchestrating Customers b/w Oracle MDM CDH and Sales force, Clarity, Solomon, LMS and Client experience portal.
• Addressed issues of master data definition, metadata acquisition and data migration including data profiling, validation, clean-up and remediation for huge volume of customer data.
• Created Functional Design document for PO approval and PO create document workflows, custom extensions for MDM CDH, INV and BOM modules, and oracle MDM CDH integration to ACD.
• Provide technical and functional support to the Business users during development, testing, and post production of business solutions.

Confidential, KY

Functional consultant (Oracle R12.1)

Responsibilities:

• Analyzed and prepared business requirements, functional design, configuration, test plans and implementation documentation for MDM CDH (TCA), PO and INV modules.
• Prepared business requirements for data integration and reporting/analytics.
• Prepared functional design documents for PO, INV and TCA extensions forms and reports.
• Addressed issues of master data definition, metadata acquisition and data migration including data profiling, validation, clean-up and remediation. .
• Preformed functional and integration testing for oracle B2B EDI transactions, custom extensions, workflows, reports etc for Procure to Pay cycle.
• Standardized Data validation, de-duplication rules and defined merging rules for MDM CDH.

Confidential, OR

Functional Consultant (Oracle R12.1)

Responsibilities:

• Performed gap analysis to determine the EBS configuration and development changes for INV, PO and AP modules EMEA localization.
• Prepared meeting minutes and created As-Is and To- Be Process Mapping Documentation for business processes and interfaces.
• Architected the solution for migrating the customers developed (home grown) module functionalities to Oracle ERP modules.
• Created Functional Design Documentation for PO, INV and AP modules extensions, interfaces and data conversions.
• Documented solution analysis for the Statement Reconciliation process in AP for EMEA countries.
• Developed and maintained test scenarios, performed functional and regression testing and documented test results.
• Set up the Oracle Purchasing and Inventory module and defined the required system profile options.
• Conducted CRP and UAT sessions. Prepared Test scripts, and post production support to the business users.

Confidential, CA

Functional Consultant (Oracle R12.1)

Responsibilities:

• Created Business Requirements, System Configuration, Functional Design, Test Plans and Test Cases Documentation.
• Implemented strategies around MDM Product Data Hub and making PDH as a single source of truth. Developed Item Master roadmap.
• Gathered requirements to capture all the product attributes and relationships in a rich and extensible data model.
• Implemented Product Data governance and change control, product catalog management
• Standardized Data validation and description-generation rules, key product data attributes step-by-step new item definition and approval workflow.
• Created Detailed Functional Design Documentation for orchestrating inventory b/w Oracle PDH and Oracle EBS, Digital River, Seibel, Business Intelligence, Work Bench and Keystone.

Confidential, CA

Functional Consultant (Oracle 11i/12i)

Responsibilities:

• Architected several complex Oracle Extensions and integrations between Oracle EBS and other legacy systems in a multi-org and multi-business group environment.
• Gathered requirements for new/customized oracle workflows, forms, alerts, reports, label printing, Discoverer business areas, reports, and security.
• Conducted defect analysis, triage and validated fixes during CRP, UAT and post production.

Confidential, TX

Techno-Functional Consultant (Oracle 11i/12i)

Responsibilities:

• Customized MSCA for enabling Smart Scanning and out-of-order Scanning, which handles various types of barcodes and auto fills the Data Field Identifiers in MSCA forms.
• Designed New/Customized Oracle WMS forms for LPN Consolidation, Picking, Shipping, miscellaneous Receipts and Issue forms.
• Customized Oracle WMS forms for receiving by LPN for multiple requisitions with different projects and tasks.
• And keep track of the status of ordered item history from ‘Release to Warehouse’ to ‘Stage/Pick/Confirm’
• Integrated Confidential application’s Gemini with clippership for ship confirms, to automate freight charges and add new fields dimension calculation.
• Configured, Designed New/Customized oracle forms and reports for PO, INV, WSH and WMS modules.