Summary
Overview
Work History
Education
Skills
Certification
Experience
Current residence
Page
Timeline
BusinessAnalyst
Vishal Sahni

Vishal Sahni

Oracle EBS and Cloud Technical consultant
PUNE

Summary

Experienced Oracle apps technical consultant with diverse experience in Oracle technologies. 16 years of IT experience. 13 Years of relevant experience in Oracle EBS. Worked extensively in Supply chain and EAM space and Oracle Projects. Expertise in development and enhancements of RICEW components. Good knowledge of O2C and P2P cycle. Adept in various phases of a Project Lifecycle including requirements gathering, development, testing, support and user training.

Overview

18
18
years of professional experience
4
4
years of post-secondary education
1
1
Certification

Work History

Senior Software Engineer

Project Partners LLC
8 2020 - Current
  • Working as Oracle techno functional consultant

Senior Consultant

Hitachi Consulting
04.2013 - 08.2020

Senior Software Engineer

Estuate Software Pvt Ltd
03.2010 - 01.2013

Associate Consultant

Oracle Solution Services India (OSSI)
01.2007 - 01.2010

Education

M.C.A (Master of Computer Applications) - Enterprise Resource Planning

University of Rajasthan
Jaipur, Rajasthan
01.2002 - 04.2006

Skills

Oracle EBS, Oracle PL/SQL, OAF, Workflow Oracle forms, reports 6i, 10g and Alerts, SQL Developer, Discoverer, XML Publisher, Form Builder, Report Builder, SQL

Certification

Oracle Data Warehousing 11g Essentials

Experience

Customers:   Burns and McDonalds, HDR,

AECOM,   Nutrien, Thales, NCH, SNC

Project Name:    Oracle Projects EBS

R12   Product Implementation, upgrade(for few of clients) and support.

Role: Senior Developer, Location: Offshore

Team Size: 6

Duration : Aug, 2020 – Present

Project   description: This project involves development   and customization of RICEW components for Oracle Projects module.

Roles & Responsibilities :

Gathering requirements   from the client. Development of code units for conversions/reports. Prepared   technical design documents.


Customer:   Potash/Nutrien, Canada.

Project Name:   Potash Implementation and support(Oracle apps R12 implementation)

Role: Senior Developer, Location: Offshore

Team   Size: 12

Duration :     Jan, 2015 – Aug, 2019

Skills     used: Oracle apps R12, Oracle SQL,

PL/SQL,OAF,Workflow

Project   description: This project involves

development   and customization of RICEW components for EAM, SCM and Finance modules.

Roles & Responsibilities :

Gathering requirements from the   client. Development of code units for conversions/reports. Prepared technical   design documents.


Customer: Brake Parts, USA

Project Name: Brake Parts(Oracle apps R12 implementation)

Role:   Senior Developer, Location: Offshore

Team Size:   5

Duration   : Mar, 2014 – Dec,2014

Project   description: This project involves development of conversion &   interfaces for Finance and SCM modules.

Roles   & Responsibilities :

Gathering requirements from the client. Development of code   units for conversions/reports.

Prepared   technical design documents.

Skills used: Oracle apps R12, Oracle SQL,   PL/SQL.


Customer: Fellowes, UK

Project   Name: Fellowes Project UNO(Oracle apps R12 implementation)

Role:   Senior Developer,   Location: Offshore

Team   Size: 10

Duration : May, 2013 – Jan,2014

Project   description: This project involves development of conversion &   interfaces for Finance and SCM modules.

Roles & Responsibilities :

Gathering requirements from the client. Development of code   units for conversions. Prepared technical design documents.

Skills   used: Oracle apps R12, Oracle SQL, PL/SQL.


Customer:   Stanford University, USA

Project   Name: EAM ITS

(Oracle apps R12 implementation)

Role:   Senior Developer, Location: Offshore

Team   Size: 5

Duration : Jul, 2012 – Jan 2013

Project   description: This project involves development of conversion &   interfaces for Oracle EAM(Enterprise Asset Management)

Roles   & Responsibilities :

Gathering requirements from the client. Development of   code units for conversions. Prepared technical design documents.

EAM   - Worked on EAM for all historical data upload. (EAM Assets, EAM Activities,   EAM Asset Routing, EAM Resource, EAM Asset Groups, EAM Asset activity   association, Work orders, Material Transactions, Operation Completion)

Skills used:   Oracle apps R12 , Oracle SQL, PL/SQL.


Customer:   Stanford University, USA

Project   Name: CADMS Phase 2B

Role:   Senior Developer Location: Offshore

Team   Size: 3

Duration   : Nov,2011 – June 2012

Project   description: This project involves developing reports for various   level of management in Stanford.

Roles &   Responsibilities : Gathering requirements from the   client.

Development   of reports.

Prepared   technical design documents.

Skills   used: Oracle Apps R12,XML publisher, Oracle SQL, PL/SQL.


Customer: IBM, USA

Project   Name: Performance Redesign for AR-module(Oracle EBS)

Role:   Senior Developer

Location:   Offshore

Team Size: 3

Duration   : March,2011 – Aug,2011

Project   description: This project involves performance redesign of   AR-Solution in data archive project.

Roles &   Responsibilities: To develop selection &   validation queries for AR module with customizations on existing packages for   the new solution.

Skills used:   Oracle Apps R12, Oracle SQL, PL/SQL.


Customer: Arbys, USA

Project Name: Wendy’s Arbys

Conversion

Role: Senior   Developer Location: Offshore

Team Size:   6

Duration : Aug,2010 – Jan,2011

Project   description:

A data migration project. It involved migration of   employee’s personal as well as payroll information from Ultipro (legacy)   system to Oracle Applications HRMS module. It also involves preparing custom   forms to view the migrated data in Oracle applications.

Roles &   Responsibilities:

Gathering requirements from the client on the customization

Created custom Forms for viewing migrated data.

Prepared Unit test cases & performed testing for the   objects developed.

Prepared technical design documents for the objects   developed.

Skills used:   Oracle Forms Development, PL/SQL

,SQL Loader, Oracle Apps R12


Customer: ThyssenKrupp Elevator, USA

Project Name:   TKE (ThyssenKrupp Elevator)

Role: Senior   Developer Location: Offshore

Team Size: 12

Duration : April,2010 – Aug ,2010

Project description:   This project involves Multi Language Support, in Dutch (NL) and French, to   custom CEMLIS originally supported in American English (US).

Roles & Responsibilities: Performed   MLS changes to forms, reports, packages and sql. Prepared documents for the   changes made as part of changes incorporated and the Installation script for   installing the changed objects (CEMLI).

Skills used: Oracle Forms Development, Oracle   Reports Development, PL/SQL Coding, Oracle

apps R12,documentation and Testing.

Current residence

Pune, Maharashtra

Page

1

Timeline

Senior Consultant

Hitachi Consulting
04.2013 - 08.2020

Senior Software Engineer

Estuate Software Pvt Ltd
03.2010 - 01.2013

Associate Consultant

Oracle Solution Services India (OSSI)
01.2007 - 01.2010

M.C.A (Master of Computer Applications) - Enterprise Resource Planning

University of Rajasthan
01.2002 - 04.2006

Senior Software Engineer

Project Partners LLC
8 2020 - Current
Vishal SahniOracle EBS and Cloud Technical consultant