Oracle EBS consultant

Renaldi Satty

E-Mail Id : *******.****@*****.***

Mobile : +1-217-***-****

Professional Summary:

●Having 17+ Years of experience in Oracle Applications 11i and R12 as Oracle Apps Techno-Functional expert.

●Worked extensively on Oracle Applications SCM modules (iProcurement, Purchasing, Inventory and Order Management), Oracle Receivables, oracle Payables and CRM Modules ( Depot Repair, Install Base, Service Contracts, Field Service).

●Involved in development, upgrade Projects, Rollouts, enhancements and support projects of Oracle EBS Application .

●Good work experience on Oracle Application Framework, SQL,PL/sql, Oracle Forms and Reports, XML/BI Publisher Reports, Oracle Workflows, Unix, Core Java .

●Involved in Solution design based on the customer requirements and providing optimized and quality deliverables. Involved in regular client interactions to gather requirements, providing updates, Co-ordination with consultants and resolving issues.

●Planning and delegating work to team and mentoring the team members to ensure quality and timely deliverables.

●Creating and maintaining Oracle recommended documentations during various phases of project.

●Good leadership, communication, and interpersonal skills and comfortable working as a team as well as individually.

Technical Expertise:

●MS Office packages: Microsoft Word, Excel, Access

●ERP: Oracle Applications 11i/R12, Oracle Application Framework,

Oracle reports,Forms, plsql, sql, XML publisher, workflow, AOL.

●ERP Modules: iProcurement, Inventory, Purchasing, Order Managemet,

AP, AR, Depot Repair, Install Base, service Contracts, Field service.

●Database: Oracle 10g/11g/12c

●Programming Languages: SQL, PLSQL, Core Java

●Tools: Toad, Putty, SQL Developer, Winscp, Jdeveloper 10g, BI Publisher, PVCS, Workflow builder.

Experience:

Client : General Electric

Duration : Nov 2017 to Till Date

Organization : Genpact India Pvt Ltd

Responsibilities:

●Involved in development of additional functionalities such as ERP validations, Compliance specific Pages,Gears and comply works in GE SSS.

●Involved in development of OAF pages and packages for enhancements of existing process and bug fixes of production issues .

●Actively involved in R12 upgrade project from version R12.1.3 to R12.2.3 in retrofitting SSS Customizations in requisition creation page and ensuring functionalities work as expected.

●Preparation of code deplolyment scripts, UTC’s, MD200 and other documentation.

●Involved in quick resolution of post Go-Live Issues. Gateway Interfaces,Customizations as part of 19C database upgrade.

Client : Macquarie

Duration : Dec 2016 to Nov 2017

Organization : Genpact India Pvt Ltd

Responsibilities:

●Involved in R12 upgrade in OLFM Module. Remediated OAF pages, Discoverer reports and PLSQL components.

●Debugging the issues raised during UAT Phase.

Client : Telkomsel

Duration : May 2015 to Dec 2015

Organization : OSI consulting

Responsibilities:

●New custom OAF pages development for custom functionality of Telkomsel related to Budget Planning and Execution.

●Resolution of issues during UAT Phase.

●Purchase requisition enhancements with OAF pages in Iprocurement module such as defaulting of accounts, to restrict creation of PR with items from different GBPA’s in IProcurement module.

●Worked with PLSQL package to handle purchase requisition validations in Iprocurement

●Worked with the Workflow Notifications to add attachments to be displayed as link, new custom fields in Workflows CreatePO (PO Create Documents) and enhancements in POAPPRV (PO Approval Workflow).

●Testing the components, preparation of MD70, MD120, TE20 migration scripts.

Client : Jacobs Engineering

Duration : Aug 2014 to Jan2015

Organization : OSI consulting

Responsibilities:

●Developed custom OAF pages for entering timesheets, to create Bulk service contracts for a party.Fixing of OAF Issues related to Lov conditions, performance of oaf pages.

●Development of plsql Triggers to populate tables of custom applications at various points, to automatically close service requests.

●Modifying packages related to business events to default the task status.

●Form personalizations to handle various requirements such as buttons to be enabled for certain users and other changes

●Analyzing production issues and providing resolution.

● Preparation of migration scripts and migrating to test instances.

● Client calls, Status reporting, Issues Monitoring.

Client : PPG Reimplementation

Duration : Feb2014 to Apr 2014

Organization : Hitachi consulting

Responsibilities:

●Development of Sales Order Acknowledgement report for PPG client using xml publisher and Oracle Reports.

●Testing of order management reports.

●Handling calls with onsite for technical discussion of components.

● Preparing MD70, MD120, TE20 documents and review checklist documents, migration documents.

Client : CHP R12 upgrade

Duration : Mar2013 to Dec 2013

Organization : Hitachi consulting

Responsibilities:

●Upgrading CEMLI objects such as procedures, functions, forms, reports, OAF personalization’s etc. from 11i to R12 (HRMS Module).

●Testing in 11i and R12 instances

●Prepare technical and unit testing documents for the CEMLI’s.

●Development of custom OAF pages to bulk load customers to database.

●Development of new custom form to add customers individually.

●Form personalizations to restrict access of responsibilities.

●Resolution of issues such as restrict email to selected customers when adding to cart in istore

Client : Actuant (Hydratight)

Duration : Oct 11 to Jan 13

Organization : Hitachi consulting

Responsibilities:

●Development of various Order Management reports such as Sales Order Acknowledgement report, Bill of Lading, Packslip reports.

●Rollout of above OM reports and PO reports for different countries which includes org specific changes and validations.

●Fixing of Language, Data Issues and Display (alignment) Issues with XML publisher reports based on specifications of each region/country.

●Understanding the business requirements and developing excel output based reports as per customer specifications.

●Preparation of Technical Documents such as MD70, Test Case Documents etc for developed components.

Client : Tyco International

Duration : June10 to Oct11

Organization : Wipro Technologies

Responsibilities:

●Development of custom OAF Pages in Sales Module.

●Forms Personalization in SR form to include custom validations during submit order etc.

●Development of Packages and procedures.

Client : Emerson

Duration : Sep09 to June10

Organization : Wipro Technologies

Responsibilities:

●Understanding the requirements, design and development of Reports and Unix shell scripts. Preparing Functional, Technical requirement specification documents.

●Understand, provide analysis and implement on upgrading components from 11.5.9 to 11.5.10 instance.

●Registration of forms, report Unit testing report and log the test results.

●Preparation of functional and technical documents for Unix shell scripts and migrating to single instance of test plans and test cases.

Client : Teliasonera

Duration : Jan 07 to Aug 09

Organization : Wipro Technologies

Responsibilities:

●Understand the highly customized process between Oracle EBS and Client’s legacy System.

●Resolving issues related to Billing such as wrong billing amount, partial billing, etc maintaining the tickets through Remedy tool

●Understanding Integrations between oracle EBS and billing system of Teliasonera.

●Resolving the issues with Sales Orders stuck in workflow by fixing the data and resubmitting Order Workflows to ensure smooth flow to billing system.

●Daily monitoring by performing health checks up of the system through running set of queries to understand any issues. To schedule custom concurrent programs

●Worked on Change requests, Extensive patch testing in test and development environments in service contracts and testing of developed code. Development of Oracle Reports such as Service request technician report for service request and Repair Management modules.

●Development of Procedures and packages, value sets and concurrent programs to run the reports

Employment History:

Company Name

Designation

Duration

Genpact India Pvt Ltd

Technical Lead

Dec 2016 to Till Date

OSI Consulting

Technical Lead

July 2014 to Dec 2015.

Hitachi Consulting

Senior consultant

Oct 2011 to June 2014

Wipro Technologies

Technical Consultant

Sep 2006 to Oct 2011

Education:

Qualification

University

Year

Master of Computer Applications

Osmania University, Hyderabad, India

May 2003-June 2006

Bachelor of Computer Applications

Osmania University

Hyderabad, India

Apr 1999- Apr 2002

Contact this candidate