Oracle EBS Technical Consultant Resume Title

SIVA REDDY YERUVA Email id: *******************@*****.***

Mobile No.: 832-***-****

EBS Technical Consultant

4.0 years of professional experience in Oracle Applications R12 as Technical Consultant/Fusion Consultant Responsible for understanding, analyzing, Designing, Developing and troubleshooting RICE components

Extensive experience in Oracle and other utilities such as TOAD, and SQL*Loader, and discover reports

Involved in creation of Value sets, Concurrent Programs and Request sets using proper naming conventions in Oracle Application Projects

Experienced in writing Program using PL/SQL, and good knowledge on Forms and Report builder10g

Involved in Design and Development of Report Layouts in Oracle applications as per client requirements using Report builder 10g

Experience in designing and development of Conversion Programs to load data from Legacy system to Oracle Applications with effective validation logic and Error handling mechanism

Worked on Inbound and Outbound Interfaces to load the data from legacy system to Release R12 using PL/SQL and SQL* Loader and UTL_FILE package

Good interpersonal and communication skills, dedicated, result oriented with enthusiasm to learn new technologies and Capable of working independently and as well as a part of a team

Personalized Oracle Application forms as per the client requirement using Forms personalization functionality in Oracle Applications

Worked on BIP Reports

Worked on OTBI Reports

Worked on FBDI

Qualification : B.Sc

College : SV DEGREE COLLEGE (RAYALASEMA UNIVERSITY) in 2021

Working as Technical Consultant with LANCE SOFT ENGINEERING PVT LTD, Hyderabad from Sep 2021 to till date

Oracle apps

E-Business Suite R12

Foundation

Sys admin, AOL

Oracle Financials

GL, AP, AR

SCM

INV, OM, PO

Oracle Product Set

Oracle Ver.10g/11g, Developer 2000(Forms 10g Reports 10g), SQL Loader

Languages

SQL, PLSQL, Unix Shell Scripts

Major Projects:

Project3

Client : AK Steel Holdings Corporation

Role : Technical Consultant

Environment : R12, SQL, PL/SQL, D2K 10g, BI Publisher, Workflow, BIP, OTBI

Modules : PO, AP, OM, AR

Duration : Sep’2024 to till date

Project Description :

AK Steel Holdings Corporation was an American steelmaking company headquartered in West Chester Township, Ohio. The company, whose name was derived from the initials of Armco, its predecessor company, and Kawasaki Steel Corporation, was acquired by Cleveland-Cliffs in 2020. AK Steel operated eight steel plants and two tube manufacturing plants in Ashland, Kentucky; Butler, Pennsylvania; Coshocton, Ohio; Dearborn, Michigan; Mansfield, Ohio; Middletown, Ohio; Rockport, Indiana;, and Zanesville, Ohio.

Responsibilities:

Developing Interfaces for Inventory and AP modules

Working on XML Publisher reports

Developed Material voucher report for PO module

Developed Customer interface

Developed AP Invoice outbound interface to extract the data from the Oracle Apps Tables to the Flat file

Customized AR Invoice Report

Developed Items categories Interface through API to assign item categories to the items

Developed Customer conversion to create Customers in AR module

Preparation of MD70 (Technical design document) and MD120 (Migration Document)

Creation of PL/SQL procedures, Functions and Packages.

Creating Database Objects like tables, views, sequences, Indexes.

Writing SQL queries according to customer requirement.

Worked on shell script

Worked on BIP Reports

Worked on OTBI Reports

Worked on FBDI

Project2

Client : PPG Industries, Inc

Role : Technical Consultant

Environment : R12, SQL, PL/SQL, D2K 10g, BI Publisher, Workflow

Modules : PO, AP, OM, AR

Duration : Sep’2023 to Aug’2024

Project Description :

PPG Industries, Inc. is an American Fortune 500 company and global supplier of paints, coatings, and specialty materials. With headquarters in Pittsburgh, Pennsylvania, PPG operates in more than 70 countries around the globe. By revenue it is the second largest coatings company in the world behind Sherwin-Williams. It is headquartered in PPG Place, an office and retail complex in downtown Pittsburgh, and is known for its glass facade designed by Postmodern architect Philip Johnson.

Responsibilities:

Concurrent program definitions and Executable

Involved in Unit testing of RICE Components

Creating database Triggers

Writing SQL queries according to customer requirement

Understanding customer issues

Analyzing logs and providing remedy to customers

Preparing Unit test

Developing Forms and Reports

Coding of Forms and functional testing

Writing custom packages and using API’s to develop the interface Programs

Developing Custom Reports in Oracle Applications

Preparation of installation Documents

Deployment to other test environments

Post Production support

Preparation of MD070 and MD120 installation documents

Define value sets, lookups and concurrent programs

Project1

Client : JSW Steel Ltd

Role : Technical Consultant

Environment : R12, SQL, PL/SQL, D2K 10g, BI Publisher, Workflow

Modules : PO, AP, OM, AR

Duration : Sep’2021 to Aug’2022

Project Description :

JSW Steel Ltd. is an Indian steel company owned by the JSW Group based in Mumbai, Maharashtra, India. JSW Steel is among India's largest steel producers, with a capacity of 14.3 Million Tons per annum as of 2013. As part of the US$16 billion O. P. Jindal Group, JSW Group has diversified interests in steel, energy, minerals and mining, aluminum, infrastructure and logistics, cement and information technology

Responsibilities:

Technical consultant for interfaces designs.

Suggesting the optimized solutions to the customer for their requirements as per As-Is processes

Preparation of MD120 doc for Code migration

Monitoring the deliverables during each phase of project

Attending the weekly status calls and weekly reporting

Writing SQL queries according to customer requirement

Understanding customer issues.

Define value sets

Design, Development and Customization of RICE components

Doing feasibility analysis and preparing technical design documents MD-070

Coding and Development of RICE as per Naming and Coding Conventions

Define Concurrent program, Request Sets and Executable

Performing Unit testing and Code review for developed RICE Components

Summary of Experience:

Educational Qualification:

Professional Experience

Professional Experience

Contact this candidate