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.

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 Confidential 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 Confidential 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

MDM 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:

• As a functional consultant, responsible for studying the business process, Review and scope new requirements. Functional Design, AS-Is, To-Be Process and Functional Documentations for OM, QP, WSH, ASCP, INV, PO, MDM, PDH, CDH, BOM, ECO, WMS etc, modules.
• Architected several complex Oracle Extensions and integrations between Oracle EBS and other legacy systems in a multi-org and multi-business group environment.
• Analyzed and prepared Functional Design Documentation to a) Synchronize inventory b/w EBS and Essbase. b) Synchronize TCA, leads, orders, b/w EBS and Sales force. c) Synchronize customers, vendors, orders, quotes, price list, inventory b/w Oracle and Web legacy systems. d) Orchestrate items, BOM, engineering, item categories from Agile to Oracle. e) Interfaces and conversions of OM, Quotes, Advance Pricing, PO, INV, BOM, Engineering, TCA, AP and AR modules. f) Complex De-Duplication, Merging rules. g) Import and Party Maintenance architecture and customer/party purge program. h) Oracle Extensions, Workflows, Forms, Reports, and Alerts etc...
• Ensured ERP data and transaction system dimensions for a) Automatic reservations for the serial number and shortage reservations during receiving. b) Synchronizing inventory items, item history, and item categories with 3pl system. c) OPM PO receipts, Inventory Stock adjustments, quantity synchronizing, work order completion, OPM Allocations, and RCV transactions. d) New/Change/Closed PO’s, RMA’s, inter-org transfer and PO receiving for 3pl and wms system. e) Synchronizing New/Change/Closed’s PO for EDI, PKMS and vendornet system. f) Customer information from RR Donnelly. g) Open Invoice and credit cards Interface. h) Mass price list create and update. J) Data Conversion for OM, QP, INV, BOM, AR, PO, AP and TCA modules.
• 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:

• Prepared Functional design (MD50), Technical Specifications (MD70), configuration (BR100) and test scripts (TE20/40) WSH, WMS and MSCA modules including Critical and Go live issue support.
• 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.

Confidential, CA

Techno-Functional Consultant (Oracle 11.5.9)

Responsibilities:

• Confidential is the worldwide leader in embedded software and services. This project involved upgrade of oracle apps from 10.7 to 11.5.9 Supply chain, CRM and financial modules. . As Techno- Functional prepared functional design (MD50) for oracle reports, discoverer EUL, business folders and reports for OM, WHS, INV, Install Base, Service Contracts modules including Build & Testing, Pre-& Post Go Live phases of implementation. Setting up the discoverer users and administered their privileges, permissions and security.

Confidential, CA

Techno- Functional Consultant (Oracle 11.5.9)

Responsibilities:

• This project involved upgrade of oracle apps from 10.7 to 11.5.9 Supply chain, Service and CRM modules. As Techno- Functional prepared functional design (MD50) for oracle reports, discoverer reports and conversions (CV40) documents for OM, INV, Install Base, Service Contracts modules including Build & Testing, Pre-& Post Go Live phases of implementation.

Confidential, MO

Research Assistant

Responsibilities:

• Confidential engineering lab implemented a biologically inspired hybrid intelligent agent for online data mining for Business Intelligence thereby helping the analyst and decision makers in arriving at a decision quickly. Designed and deployed Business Intelligent Agents in real-time environment in data mining using Oracle Advanced Analytics. Designed database objects to retrieve information in different forms, collaborative filtering, data mining, machine learning and other analysis techniques.

Confidential

Business Analyst

Responsibilities:

• Confidential is one the largest supplier of mobile systems in the world and supports all major standards for wireless communication. Confidential worldwide users use Confidential for analyzing the behavior of Confidential and Confidential networks.
• Performed gap analysis, Requirement gathering, Design of the datamarts, Technical Specifications, Re-engineering and Enhancements for new Confidential product of Confidential versions R8.1, R9, R9-NAED, & R9.1 and for Confidential R1.5 and R2. Lead worked on Statistical Datamart and Business Objects implementations, including date warehouse scooping, BO deployments, complex universe and reports developments using BO/WebI.