Merwin Prosper

Oracle Consultant/Analyst with 8 years of overall implementation and support experience in procurement, inventory , maintenance and field service cloud applications.

PROFESSIONAL EXPERIENCE         

Functional Analyst |Enbridge Inc., Toronto (Remote) · Contract

Aug 2021 – Present · 1 yr 8 mos

Domain: Procure to Pay (P2P)

• Working on Implementation of Oracle Cloud ERP for the company’s end to end business process.
• Active participant in conceptualization, design, and deployment of Oracle Cloud Procurement modules.
• Collaborated with business users, SMEs, and cross functional teams such as Inventory, Work Management(external) and Accounts Payable to map the business requirements to Oracle Cloud, closing gaps.
• Created functional design and corresponding test scripts to ensure the requirements are met.
• Conducted workshops with users, providing materials and training to help them transition from the current (SAP, EBS) to future state of application (Oracle Cloud).
• Worked on conversion activities to prepare mapping, transcoding and cross reference files for conversion.
• Led a team of developers to build the FBDI templates for Purchase Order and Supplier Interfaces. 
• Verified converted data in Cloud. Also engaged business users in the data validation activities.
• Work closely with supply chain team to plan and support SIT, UAT, Dress Rehearsal and Go-live activities.
• Also providing post implementation support, leveraging Service Now to track the incidents logged.

Senior Analyst |Cloudworks (Now acquired by Accenture), Toronto (Remote)· Full-time

Jan 2021 – Aug 2021 · 8 mos                                                     

Client: Electric Vehicle Manufacturer based out of California, USA
Domain: Procurement and Inventory

• Functioned as a Business Analyst for the project team undertaking remediation of an Oracle Cloud implementation.
• Gathered end-user requests and conducted additional requirement gathering sessions to finalize the future state of Oracle Cloud application. Leveraged JIRA to track all these requests.
• My major job responsibilities were triaging incidents, analyzing, and providing resolution/root-cause, managing work prioritization, and allocating approved change requests to the offshore resources.
• Worked closely with the business users to implement process improvements, fixing gaps and problems identified and conducted end-user training.
• Supervised the UAT cycles, provided job aids and created several supporting documentations.

Oracle Consultant |Badger Daylighting Inc., Calgary · Contract

Sep 2019 – Apr 2020 · 7 mos

Project:  Implementation and support of Oracle ERP Cloud R13 and Field Service applications.

Domain: Procurement, Maintenance, Sales and Field Service

• Collaborated and functioned as a bridge between the business users, SMEs, and system integrator.
• Streamlined the supply chain business process to follow standard procurement and inventory functions like Internal Requisitions, Purchase Orders, Transfer Orders and Work Orders. Defined standard operations and work order types best suited for the truck assembly and maintenance activities.
• Gathered user requirements and modified configurations to cater to business needs.
• Executed data conversion with mock cut-over phase, data validation, cut over plan and batch scheduling.
• Created test data, test scenarios and test scripts in JIRA application.
• Executed functional unit testingand supported UAT. Provided manuals for user training.
• Supported multiple Integrations built between Cloud and Field Service applications using OIC.
• Monitored scheduled workflows using Orchestration UI.
• Provided support for Lead-to-Cash process in Oracle CX Sales (CRM) application which constitute creation of lead, prospect, customer, opportunity, job and tickets.
• Identified root cause and resolved incidents reported by business users using Service Now.
• Corrected data from integration run using Oracle Database Adapter by executing SQL queries/stored statements.
• Worked on developing reports in OTBI, OAC and BIP.

Oracle Consultant |Deloitte. · Full-time

Mar 2017 – June 2019 · 2 yr 4 mos

Client:   Largest alcohol distributor in the U.S.

Project:  Implementation and support of Oracle ERP E-Business Suite R12

• Acted as a liaison between developers, business owners and the stakeholders of the project.
• Gathered and documented (BR-100) user requirements through working sessions and interviews.
• Drafted ‘as-is’ and ‘to-be’ state of the oracle application.
• Performed fit-gap analysis and identified RICEW objects.
• Developed custom process flows, documented functional specifications (MD-50).
• Configured Purchasing, Inventory, Landed Cost Management, Order Management & Advanced Pricing modules.
• Supported data conversion from applications: Manhattan, TIBCO and MARS to Oracle with conditioning and cleansing of legacy data extracts.
• Defined standard operating procedures (SOP) for procure to pay and order to cash business process.
• Integrated Manhattan WMS into Oracle for receiving, shipping and inventory functions using SOA middleware.
• Developed a custom interface to synchronize item master data between TIBCO, Oracle and WMS. 
• Designed and developed an exclusive process for reserving & allocating Inventory stock using Oracle Application Express (APEX) and WEBADI.
• Facilitated daily scrum calls and involved in developing sprint backlog and release plans.
• Developed dashboards to display deliverable status across team members in the project.
• Led a team of developers on the Purchasing & Distribution track owning objects: Master Item, Categories, Item Cross Reference, Purchase Orders and Item Inbound-Outbound interfaces using SOA.
• Streamlined the inventory management process and reduced manual effort by 40%.
• Devised test plan and test cases for User Acceptance Testing (UAT).
• Provided application support: Change management, root cause analysis and incident resolution. 
• Supported development of reports and training materials. 

Assoc. Business Consultant | NTT DATA Services · Full-time

Aug 2014 – Mar 2017 · 2 yr 8 mos                                 

Client 1:   Largest medical device manufacturer in the United States.
Client 2:   Agricultural chemical company in the United States.

• Gathered requirements for integration, customization and enhancement requests.
• Optimized procure-to-payand order-to-cash business processes.
• Configured application modules: Purchasing (PO), Inventory (INV), Order Management (OM), Bill of Material (BOM), Work in Process (WIP), Engineering (ENG).
• Active participation in CRP/SIT/UAT sessions.
• Identified and resolved issues reported by business users.
• Defined and executed test scripts for end-to-end regression testing using HP ALM.
• Created user training manuals, coordinated training workshops, and suggested industry best practices.
• Logged, monitored, and closed Service Requests (SR) with Oracle Support.
• Executed initiatives for knowledge sharing across the team.
• Presented project dashboards to the leadership. 
• Created email alerts and reports for monitoring purposes.

EDUCATION

2012 - 2014         SRM University, India                                    

Master of Business Administration (MBA) in Operations Management                                              

2007 - 2011         PSG College of Technology, India               

Bachelor of Engineering (B.E.) in Instrumentation & Control