Oracle Apps Technical Consultant
Location : Jaipur, India
Experience : 8 Year
Rate: $18 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
Dwarakanath – 7+ Years - Oracle Apps Technical Consultant
Experience Summary
7+ years of hands on experience in Oracle Applications E-Business Suite, Release 11i/R12.
Proficient in Developing, Customizing and Implementing Oracle application modules such as PO, INV, AP, AR, OM, PA .
Extensive experience in writing PL/SQL Packages, Functions, Stored Procedures and RICEW Components.
Worked on PL/SQL integration package for exposing as a JSON inbound and Outbound.
Experience in developing XML Publisher reports, Oracle Reports (.Rdf).
Prepared Documents like MD070,CV060,TE020 and MD0120 for customizations
and conversions using AIM documentation methodology.
Experience includes exposure to all the phases of Software Development Life
Cycle including Analysis, Design, Development, Testing, Implementation,
Production Support and Maintenance.
Strong work Experience in developing Interfaces (Inbound and Outbound) and
Conversions.
Capable of learn & research and expand the new leading technologies.
Having knowledge in OTBI, BIP Fusion reports.
Experience
Working as a Senoir Technical Consultant from Aug 2022 to Tilldate.
Worked as a Senoir Technical Consultant from Jun 2020 to Jul 2022.
Worked as a Technical Consultant from July 2016 to May 2020.
Technical Summary
ERP Modules : Finance, SCM, and Core HRMS
Databases : Oracle 9i/10g/11g/12c
Tools : SQL* Loader, Toad, Oracle SQL Developer
GUI : Oracle Forms 6i, Reports 6i/10g, XML Publisher
Languages : SQL, PL/SQL
Project Summary:
Project #1
Project : Emerson
Client : Emerson
Migration : The NineHertz, Jaipur, Rajasthan
Role : Senior Technical Consultant
Tool Used : Putty, WinSCP, Sql Developer, and SVN.
Database : Oracle 11g
Duration : Aug-2022 to Tilldate.
Responsibilities:
Worked on the modules like AP, INV and PO.
Developed conversions using APIs and Interface tables.
Developed and enhancement of Packages, Procedures, Functions.
Development of AOL objects and Registering Custom Programs in R12 defining
Executables, Concurrent Programs, and Request Groups.
Extracting data from 11i application and exported into Custom tables.
Analysed data from source and involved in discussion with client.
Transform 11i data into R12 data using the transformation rules.
Validate the data and generate the Flat files.
Involved in business meeting to get the transformation rules.
Preparing the status report to individual objects to analyse the data and Recon
Queries and Test cases after loading data.
Project #2
Project : Source to Contract (Integrations)
Client : Citi Bank
Development : Virtusa Consulting Services Pvt.Ltd, Hyderabad.
Role : Senior Technical Consultant
Tool Used : Putty, Winscp, Sql Developer, and RLM.
Database : Oracle 19c
Duration : Jun 2020 – Jul 2022
Responsibilities:
Mainly worked with modules like AP, AR, PO and OM.
Involved in the day to day activities of production support.
Development of integrations by consuming Json as inbound and outbound to
transferring data from source to target systems.
Preparation of documents MD050, MD070, CV040, CV060, MD120 and TE20.
Developed conversions using public APIs and Interface tables.
Designed and Developed/enhancement reports as per Business Requirement.
Developed and enhancement of Packages, Procedures, Functions...etc
Development of concurrent programs using Oracle PL/SQL Stored Procedures,
Reports (Reports6i and XML Publisher).
Project #3
Project : Wood Group PLC (Implementation/ Enhancement)
Client : Wood Group, UK
Implementing : Eappsys Info Solutions India Pvt.Ltd, Hyderabad
Role : Technical Consultant
Tool Used : SQL * Plus, Putty, WinSCP, SQL Developer.
Database : Oracle 11g.
Duration : Oct-2019 to May 2020.
Responsibilities:
Extracting data from 11i application and exported into Custom tables.
Developed Packages to extract the data from base tables into flat files by using
UTL_FILE package for Outbound interfaces.
Involved in Developing new Xml Reports using Xml Publisher
Involved in the creation of Technical Designs (MD70), Installation Instructions
(MD120) and Unit Test Cases (TE.020)
Transform 11i data into R12 data using the transformation rules.