Oracle SCM Functional Consultant

Ashish Sahay

Oracle SCM Functional Consultant

PROFESSIONAL SYNOPSIS

About 8 years of work experience as a Functional Consultant in Oracle SCM ERP Module.

Presently working as Lead Consultant in Birlasoft Limited, Bangalore

Worked as Senior Functional Consultant in KPIT, Pune

Have been responsible for regresstion testing of end to end cycle, running reports post DBA upgrade to 12C and make sure that all transactions are working as expected before GO LIVE for NOV Pole Upgrade Project.

Handled a gamut of functions with demonstrated abilities in gathering and translating the functional requirement, mapping to Oracle EBS and identifying customization needs and working with the technical team to fulfil customer requirement.

Technical expertise to provide Functional Consultancy on Support, Set-ups, Integration and Functionality of PO, INV, OM, AP, AR, Advanced Pricing and India Localization in Oracle applications.

I also have exposure to some of Oracle Distribution modules like PO, OM, INV and India Localization (GST).

An effective communicator well experienced in communicating and coordinating with the end Users, Application Specialists, Network Consultants, Functional Consultants, Developers and Senior Management.

Capability to think out of the box. Ability and willingness to learn new technology and acclimatize to any work culture

Currently supporting a huge client base involving nearly 30 operating units and more than 5000 users.

Can write simple queries in the database to check data and identify data fix needs.

Responsible for providing Level-1 Support to the client and managing the Ticket Queue. At the same time I am making sure the no of open tickets do not exceed the desired threshold level. Also working on the fresh implementation of the sites that are not yet live.

Experienced in creating, following up and escalating SRs with oracle leading the resolution of the issues.

Sending weekly and monthly status reports with metrics and tracking is one of my key responsibilities.

Hands on experience on PO, INV, Order Management and Advance Pricing modules.

Having Good Knowledge on P2P and O2C Life Cycles.

Having good Knowledge on concept of AIM Documentation.

As a Functional Consultant, has been involved in interacting with various clients, and development groups in understanding client business processes.

Distribution modules and performing functionality testing on various modules of Oracle application.

Understanding and updated the specifications document (RD20)

Interacting with user, super user and functional owner to understanding the issues.

Worked on up-gradation from 11i to R12.2.3.

Prepared User training manuals for distribution modules.

Positive outlook, highly result oriented & good team player

TECHNICAL SKILLS

ERP : Oracle Apps 11i, R12.

Modules : INV, OM, PO, AP, AR, Advanced Pricing, India Localization (GST), iProcurement

Technologies Used : SQL, PL/SQL

Databases : Oracle 8.x/ 9i /10g

Tools : TOAD, SQL Developer, ITG Tool, RICE Dev track tool

Operating Systems : Windows 7

Education

B.E. in Mechanical from University of Pune in 2012.

ORGANISATIONAL SCAN

Organization

Designation

Duration

Birlasoft Limited, Bangalore

Lead Consultant

Jan 2019 till date

KPIT Technologies Limited, Pune

Oracle SCM Sr. Functional Consultant

May 2018 till Dec 2018

HCL Technologies, Mumbai

Oracle SCM Sr. Functional Consultant

Aug 2016 to May 2018

Object Win Technology India Pvt. Ltd, Bangalore

Functional Consultant

Aug 2014 to Aug 2016

E-apps Mantra Software Solutions Pvt. Ltd, Bangalore

Associate Functional Consultant

Aug 2012 to Jul 2014

Professional Experience:

Project name: McLane Oracle EBS Implementation

Client Name : McLane Company

Client Industry : Supply Chain and Logistics

Company Name : Birlasoft Limited.

Project Type : Implementation

Application version : Oracle Apps R12.2.7

Technologies Used : SQL, PL/SQL, Oracle Reports 10

Role : Functional Support Analyst

Modules : PO, Inventory

Database : Oracle 10g

Tools : SQL Developer

Location : Bangalore-offshore

Team size : 10

Duration : Jan’ 19 till Present

Responsibilities:

Involved in customization and configuration purchasing and Inventory modules in various instances using MD50 as per company’s specific requirement.

Analyzing and Resolving issue during UAT and before GO-LIVE

Tracking all issues logged by end user and provides functional solutions.

Reproducing end user reported defects.

Project name: NOV CAPS - Pole Upgrade

Client Name : National Oilwell Varco

Client Industry : Manufacturing and Sales Company Name : KPIT Technologies Limited Project Type : NOV Pole Upgradation

Application version : Oracle Apps R12.2.3

Technologies Used : SQL, PL/SQL, Oracle Reports 10

Role : Functional Support Analyst

Modules : OM, Inventory, Advance Pricing, PO, AP, AR

Database : Oracle 10g

Tools : SQL Developer

Location : Bangalore

Team size : 10

Duration : Aug’ 18 till Dec’2018

Responsibilities:

Responsible for regresstion testing of end to end cycle, running reports post DBA upgrade to 12C

Analyzing and Resolving issue before and post GO-LIVE

Tracking all issues logged by end user and provides functional solutions.

Reproducing end user reported defects.

Project name: Anchor

Client Name : Anchor Electricals Pvt. Ltd

Client Industry : Manufacturing and Sales

Company Name : HCL Technologies

Project Type : Support

Application version : Oracle Apps R12.2.3

Technologies Used : SQL, PL/SQL, Oracle Reports 10g

Role : Functional Support Analyst

Modules : OM, Inventory, Advance Pricing, PO, AP, AR, India Localization (GST)

Database : Oracle 10g

Tools : SQL Developer

Location : On site - Mumbai

Team size : 10

Duration : Aug’ 16 to May’ 18

Responsibilities:

Analyzing and Resolving issue related to Advanced Pricing, India Local Tax issues, Intercompany setups for IR/ISO, Standard SO, Drop Ship Orders, Customer Invoice issue, Purchasing and Inventory

Resolving End users regular day-to-day problems in the Oracle SCM Modules

(Order Management, Advance Pricing, India Localization, Purchasing and Inventory).

Tracking all issues logged by end user and provides functional solutions.

Reproducing end user reported defects.

Interacting with Technical consultants discussing on Developments and providing Functional Requirements

Project name: ALCOA (R12.1.3).

Client Name : Oracle India Pvt. Ltd

Client Industry : Manufacturing

Company Name : Object Win Technology India Pvt. Ltd, Bangalore

Project Type : Support

Application version : Oracle Apps R12.1.3

Technologies Used : SQL, PL/SQL, TOAD

Role : Support Analyst

Modules : PO, AP, iProcurement

Database : Oracle 10g

Tools : SQL Developer, TOAD

Location : Onsite, Bangalore

Team size : 15

Duration : Aug’ 14 to Aug’ 16

Responsibilities:

Responsible for providing Level-1 support to the client and managing the ticket queue in Remedy tool. At the same time I am making sure the numbers of open tickets do not exceed the desired threshold level.

Working on the fresh implementation of the sites that are not yet live.

Gathering and translating the functional requirement, mapping to Oracle EBS and identifying customization needs and working with the technical team to fulfil customer requirement.

Weekly and monthly status reports with metrics and tracking is one of my key responsibilities.

Providing value additional to the customer on repeating issues.

Working with Business Users on a daily basis, providing functional support as well as technical troubleshooting assistance to ensure the successful flow of Business processes.

Testing the setup steps, giving offshore support to the Client and providing functional support to the Users.

Attending weekly status meeting with the team and updating status of the Issues.

Supporting End users in solving their regular day-to-day problems in the Oracle SCM Modules (Purchasing, Inventory and Order Management).

Tracking all issues logged by end user and provides functional solutions.

Reproducing client reported defect.

Interacting with DBA Team to upload the requested Diagnostics and debug files as requested by Oracle and applying the patches on all instances including Production.

Interacting with Technical consultants discussing on Developments and providing Functional Requirements.

Project name: MIT Upgrade Project (R12.1.3).

Client Name : Mobily Infotech India Pvt. Ltd. Bangalore

Client Industry : Telecom IT service

Company Name : E-apps Mantra Software Solutions Pvt. Ltd, Bangalore

Project Type : R12 Upgrade, Development

Application version : Oracle Apps 11i and R12.1.3

Technologies Used : SQL, PL/SQL

Role : Team member

Modules : Inv, PO, AP and OM

Database : Oracle 10g

Tools : SQL Developer

Location : Off-shore - Bangalore

Team size : 10

Duration : Jul’ 13 to Jul’ 14

Responsibilities:

Responsible for setting up Product Lifecycles, Item Catalogs, Attributes and Attribute Groups.

Prepared the requirement setup document (BR100) for the INV and PO modules.

Responsible for developing and maintaining BR100, and TE-040 for all RICE components affected.

Involved in configuration of various instances using MD50

Defined Item attributes and Item categories, UOM and UOM classes.

Conducted technical discussion and review sessions with technical development team to communicate requirements and change requests on custom programs from the business.

Tracking all issues logged by end user and provides functional solutions.

Writing Test cases and Executing Test cases.

Reproducing client reported defect.

Finalization of Set-Up parameters and profiles.

Created Responsibilities and User menus.

Project name: KCRM

Client Name : Kuwait Cement Ready Mix Company

Client Industry : Process Manufacturing

Company Name : E-apps Mantra Software Solutions Pvt. Ltd, Bangalore

Project Type : R12 upgrade and Development

Application version : Oracle Apps 11i, R12 upgrade

Technologies Used : SQL, PL/SQL

Role : Team member

Modules : PO, AP, Inv

Database : Oracle 10g

Tools : SQL Developer

Location : Off-shore - Bangalore

Team size : 10

Duration : Aug’12 to Jul’13

Responsibilities:

Prepared functional specification documents using Application Implementation Methodology (AIM).

Involved in setups for Distribution Modules as per company’s specific requirement.

Prepared (BR100) to configure the setups

Involved in configuration of various instances using MD50

Prepared TE40 and executed the key test scenarios which include both inbound and outbound interfaces with external systems.

Prepared User Manuals

Working with Business Users on a daily basis, providing functional support as well as technical troubleshooting assistance to ensure the successful flow of Business processes.

Tracking all issues logged by end user and provides functional solutions.

User Interaction and getting the information to understand the issue.

Making the technical consultant understand the customizations and the corresponding functionalities.

Involved in loading the functional data in to Pre-Production Instance.

Developed various business flows for user training sessions.

QUALIFICATION

B.E. (Mechanical) from University of Pune

12th from State board

10th from C.B.S.E

PERSONAL DETAILS:

Date of Birth : 20.03.1983

Nationality : Indian

Marital Status : Married

Address : DLF Westend Heights Akshaya Nagar Bangalore-560068 (Karnataka)

Mobile :+91-916*******

Yours Sincerely,

Ashish Sahay

Contact this candidate