Post Job Free

Resume

Sign in

Oracle Apps Lead Consultant

Location:
Vasant Nagar, Karnataka, India
Posted:
August 19, 2021

Contact this candidate

Resume:

Pappu Bharadwaj Nagendra Kumar

Mobile Number: +91-996******* Email Id: adn9re@r.postjobfree.com

Career Objective:

A challenging career that will enable me to exhibit my knowledge and capabilities which helps me to work towards the success and growth of organization.

Professional Summary:

•Having 10+ years of experience in Implementation, Up-gradation Projects of Oracle Applications R12 & 11i.

•Have experience in Oracle REST APIs and SSRS reports.

•Having good experience on Quote to Order, O2C and P2P Cycle and in OTL module.

•Responsible for understanding the Functional Specifications and prepared the Technical Specification Documents like MD070.

•Have experience in creating Alerts, Form Personalization and Concurrent programs.

•Strong experience in designing and developing technical solutions for Oracle Applications including Conversions, Interfaces, Custom APIs and Workflows development and customizations.

•Have knowledge on Interfaces and all the other RICE components.

•Experience with oracle and other utilities: Sql developer, Sql*Plus, Oracle Workflow builder.

•Experience in writing stored procedures, functions, packages using Sql and Pl/Sql as part of workflow customizations.

•Coordinating and supporting Onshore-offshore model of working.

•Self-motivated, good team player with good communication and interpersonal skills Experience:

•Working with Apps Associates (I) Pvt. Ltd. As Senior consultant from Aug 2016 to Till Date

•Worked with Arrow Electronics as a Senior Developer from May 2016 to Aug 2016.

•Worked as a Senior Software Engineer for IGate Global Solutions from Aug 2014 – May 2016.

•Worked as Technical Associate for GENPACT India from Jul 2011 to Jul 2014.

Recognitions:

•Bronze Cheers Award by Genpact for my contribution in my Project GE Transportation.

•Received Pat on the Back Awards as a Team Player in GTE Project.

•Best Team Performer of the Quarter in AppsAssociates for the Current Project.

Technical Skills:

Programming Languages : SQL, PL/SQL.

Tools : SQL*Plus, SQL Developer, Report Builder 6i,10g

Workflow Builder.

Project Summary:

1. Project Name: Pearson Publications Apr 2020 to Till Date

Client: Fadel Inc

Role: Lead Consultant

Description: FADEL is an innovator in digital rights management software and royalty accounting software. Pearson Publications is one of the clients of Fadel Inc. Pearson is most popular industry in books manufacturing for all kinds of education and most of the authors have various deals with Pearson in publishing books.

This project is to put all the Rights, Deals and agreements between Pearson and individual authors and to automate the Royalties paid by Pearson to respective Authors based on various types of deals agreed up on.

As a part of this project, all the above process is brought to automation using standard Oracle O2C process and customizing most of the outside O2C process like generating/calculating various payments based on different types of deals and summarizing all payments from Pearson to Author, verifying if there is any recoupable amount being raised by Author and making adjustments before paying invoice amounts to Authors.

Responsibilities:

•Created multiple interfaces between 3rd party systems to RSS with various sources.

•Created Suspense Validation Program to validate all the data that is received by RSS (Royalty Sales Staging) and to push it to IPM (Intellectual Property Management)

•Worked with the Oracle support team as a part of applying Patches to resolve the issues.

Features Used:

•Stored Procedures and Packages

•Custom Tables

•Custom Interfaces

2. Project Name: GTE – Global Time Entry Aug 2016 to Mar 2020

Client: CapGemini Pvt Ltd

Role: Senior Consultant

Description: GTE is the tool to capture Time Card details of all CapGemini employees, globally. It is architected on Oracle’s Oracle Time and Labor (OTL) application, Rel

12.6. After full implementation, GTE is expected to cater to 140,000 employees of CapGemini. GTE is designed and architected to – Cater to the entire enterprise Time Card requirements

Capture and use detailed employee time card information to address the complex billing and compensation needs of each of the global operating units

The design leverages OTL’s comprehensive functionality and Oracle Apps integration capabilities – through ISG

The application is offered both in desktop and mobile platforms with complex integration using REST APIs

Responsibilities:

•Created multiple REST APIs for implementing OTL as a separate web application

•Customized OTL workflow(HXCEMP) to meet complex approval requirements – Default/PM/Time Approver capabilities. This eases time card approval process for large project environments

•Created functionality to enable timely actions – Auto-Approval, Auto-Submission of time cards

•Worked with the Oracle support team as a part of applying Patches to resolve the issues.

Features Used:

•Stored Procedures and Packages

•Standard Tables

•REST APIs and Standard APIs

Project Summary: Sep2015 to May 2016

2. Project Name: AMPS – PPTS Project Client: GE-Aviation

Role: Senior Software Developer Responsibilities:

•Created multiple Form Personalization’s and Processing Constraints

•Worked with the Oracle support team as a part of applying Patches to resolve the issues.

•Worked on APIs to apply and release holds in both Item level and order level.

•Working on Interfaces as a part of implementation.

Features Used:

•Stored Procedures and Packages

•Standard Tables

•APIs

Description: Modified the existing migration components as a part of support team and have worked in an Onsite-Offshore field of work to provide 24hrs support for US client. This project consists of solving tickets raised by the client when a particular R12 component doesn’t work as expected as the R12 environment tables are different from the 11i tables and hence we have to check which table is to be replaced with what table of R12.

Project Summary: July 2011 to June-2015

3. Project Name: ICS (Intelligent Controlling System) US Q1- 14 (Enhancements)

Client: GET (GE-Transportation)

Role: Developer

Responsibilities:

•Backend Programming using Oracle Sql Developer, Modifying the existing Custom report.

•Took end to end responsibility for code migration activities from the period(SIT to GOLIVE) .

Features Used:

•Stored Procedures and Packages

•Standard Tables

Description: Designed a custom PL/SQL report for updating the status of the Repair orders.

Usually the status of a particular order is updated manually based on the status of the Sales order and work order lines linked to that order.

With this custom report the status of the Repair Orders is being updated on the daily basis for a particular organization.

4. Project Name: GET Australia Deployment

Client: GE Transportation

Role: Developer

Responsibilities:

•Customized the workflows using the Workflow Builder 2.6.3.5/2.6.3.0.

•Took end to end responsibility for code migration activities from the period(SIT to GOLIVE).

Features Used:

•Stored Procedures and Packages

•Standard Tables

Description: Customized the COGS (Cost of Goods Sold) accounting Work Flow

ICS-UK& IT has different types of contract projects. These projects differ from each other in their accounting requirements and hence the same transaction might be accounted in different accounts depending on the project type.

For COGS accounting also, business has different accounting requirements depending on the project type. As standard COGS account generator cannot build COGS account segment values depending on the logic, it has to be customized to derive account segment values from different sources. As per ICS-US business requirements, COGS account segment values can be derived from following sources:

•Standard Product – As per existing logic derived from Item

•Project – Order Type and Project

Personal Profile/Education:

•Bachelor of Engineering (Information Technology) from JNT University, Kakinada, Andhra Pradesh

•Passport Number: J3955563



Contact this candidate