Project Oracle

RAVINDER MATTOO (***) *** – ****

*** – *** Cook Street, Victoria, BC V8V 3Z1 ***********@*****.**

OBJECTIVE

Business Analyst - Oracle EBS

SUMMARY OF ORACLE KEY SKILLS

• Comprehensive Production Support experience for Oracle 11i/R12 Application (ERP) in Oracle Purchasing, iProc, iSupplier, Purchasing Intelligence (DBI) and Online Expenses modules including upgrade from 11i to R12 upgrade

• Have worked cohesively in the environment of Oracle E-Business Suite Supply Chain Mgmt family of application viz. Oracle Inventory, Order Management, Financials (GL, AP, AR, FA), Projects, Purchasing, iSupplier, Procuement Contracts, Purchasing Intelligence Material Requirement Planning, Work In Progress and Bill Of Materials

• Adept in handling all sorts of Oracle User management (Security Matrix maintenance)

• Strong knowledge of Oracle Database 10g including tuning and security, Oracle Business Intelligence Discoverer 10g and Data Warehouse

SUMMARY OF PERSONAL ATTRIBUTES / KEY SKILLS

• Documented and translated Business Requirement into Functional Requirement

• Well versed with Six-Sigma and QS 9000 procedure

• Ability to understand complex business processes and prepared a detailed business processes from Procure-to-Pay and Order-To-Cash

• Strong communicating, documenting, presentation and listening skills with an ability to work with people and influence their decisions

• Strong organizational, time management and prioritizing skills

• Intuitive ability to identify problems and implement creative solutions

• Advanced capacity to learn new technologies and processes, and successfully apply them to projects and operations in Complex, distributed networks

• Thrives in independent and collaborative work environments

RELEVANT EMPLOYMENT

BC Ferries, Victoria, British Columbia Aug. 2008 – Present

Project : 11i (Ver.11.5.8) to R12 (Ver.12.0.6) upgrade Aug. 2008 – Aug. 2009

Role : Intermediate Application Analyst - Finance

Responsibilities :

• Carried-out seamless transition of PO module upgrade from 11i to R12

• Tested all purchasing (PO) and Cash Management (CE) transactions (Test Scripts) in R12 environment working successfully

• Raised and coordinated with My Oracle Support (Metalink) for the resolution of bug for PO and AP Module

• Carried-out pre and post implementations steps for PO (Purchasing) and PA (Project Accounting) module upgrade to R12 plus verification

• Created Purchasing and Cash Management UPK documents. It created consistent training and support materials for users. Users gained a well-rounded knowledge of software functionality and enabled users to learn by watching an animated demonstration of the steps for a task being performed in a simulated environment.

• Collabrated with developers to develop custom reports such as Purchase Order and Receipt Traveler

Project : R12 Sustainment and Enhancement Sep. 2009 – Present

Role : Intermediate Application Analyst - Finance

Responsibilities :

• Post-production support after Oracle Application upgraded to Oracle EBS-R12.

• Created and maintained Oracle Apps Verification document to ensure that after EBS-R12 outage that overall Oracle Application is working stable:

All concurrent processes are up

Network (performance test)

Workflow and eMail notification are working normal

iSupplier portal is working fine for vendor (External Node is up)

Widely used custom reports outputs are fine including printing from the EBS-R12

EBS-R12 interface with other application is working normal

• Carried-out iSupplier, Purchasing Intelligence (DBI) and Procurement configuration and production support

• Worked with developer and provided logic to resolve interface issue of Item Import for Category Code

• Initiated and completed mini-project of Finally Close purchase orders. All POs prior to R12 upgrade were Finally Closed.

• Created AP Month End Process document and presented to team

• Enhancement and/or fixed issues and promoted in production in line with in-house Release Management and/or Change Management processes

• Interfaces – Item category and Requisitions

Hewlett Packard (Canada) Co. May. 2007 – Jul. 2007

Project : Procter & Gamble

Role : R2P Consultant (Release to Production) as an intern

Responsibilities :

• Promoted and released of scripts and metadata from QA environment to Production environment for the customized application viz. CNOS, COPA, CFS

• Verified the changes in deployment instance. The deployment instance was to verify/test the changes before migrating the changes into production instance

• Obtained approval from CAB before migrating changes into production

GE Consumer & Industrial, India Innovation Centre, India Jan. 2002 – Jun. 2006

Project : India Implementation Project Jan. 2002 – May. 2005

Role : Business Analyst / Functional Consultant

Responsibilities :

• Prepared Functional Documents (MD-020) to capture Business Process Requirement using Visio prepared flow chart diagram of Business process viz. Procure-To-Pay, Order-To-Cash, BOM and Inventory

• Captured functional requirements of customized reports documented it, developed it thru the developers and performed testing

• Designed/developed movie type User Help Documents with live tutorial for users Oracle 11i version 11.5.7

• Implemented Oracle Quality Module

• Applied Six-Sigma methodologies in Security Matrix maintenance

• Created Responsibilities based on the level of access to be provided to the user

• Loaded data thru data loader

• Coordinated for Printer setup with the DNS entry team, Unix team and oracle apps team apart from testing of print-out

• Troubleshoot functional issues of Oracle purchasing and Inventory Modules

Project : SSS (Shared Sourcing & Servicing) Project Jun. 2005 – Jun. 2006

Role : Business Analyst / Functional Consultant

Responsibilities :

• Supported three operating units under one legal entity for purchasing and iproc modules viz. GE Consumer and Industrial USA, GE Consumer Plastics Mexico and GE Lighting Markham Canada

• New buyer set up along-with Employee Creation

• Tested RICO (Requestor Initiated Change Order) in Oracle version 11.5.9 Upgrade

• Troubleshoot functional issues of Oracle purchasing and iProc Modules

• Solving issues on day-to-day bases as per the issues listed on issue tracker

• Coordinated with the Hub Team for sending POs to suppliers as well as with corporate team for the creation of new user and assignment of responsibilities

Rai Prexim (India) Pvt. Ltd., India Aug. 1996 – Dec. 2001

Super user of Oracle Apps for PO, INV, BOM and WIP modules and trained the users

AWARDS / ACCOMPLISHMENTS

• IT Peer Recognition Award April 2006 for Oracle Shared Sourcing and Servicing Project (SSS Project)

• Special Recognition Award for valuable contribution in India Implementation Project July 2005

• Certificate of Excellence for contribution to GE Power Controls Oracle ERP implementation January 2005

• Qualified Six-Sigma Green Belt at GE India Innovation Center, Hyderabad, India

• Recipient of 2005 GE Service Award

EDUCATION

• Humber School Of Media Studies & Information Technology, Toronto, Ontario

Enterprise Software Development, Postgraduate Certificate (Oracle Solution) May 2008

• Jamia Millia Islamia University, New Delhi, India

Bachelor of Science (Hons.) Mathematics Mar.1988

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate