Post Job Free

Resume

Sign in

Oracle Developer

Location:
Cypress, TX
Posted:
June 29, 2020

Contact this candidate

Resume:

Laxman.Erukulla

Phone: +1-704-***-****

Email:add7do@r.postjobfree.com

Summary

** **** ***** ** ********* experience in IT Industry as a Lead Consultant/Architect with experience in ERP Technologies like Oracle Applications (11.x.x/R12.x.x).

Having extensive experience developing objects on Oracle 12.2.9

Extensive experience in implementation, migration, customization, production and support of various modules including iProcurement, AP,AR, INV, GL,, PO, CM, and OM.

Proficient in RICEW components including Reports, Interfaces, Conversions, Extensions, Workflows.

Experience in P2P and O2C life cycles and Supply Chain business flows.

Proficient customizing existing OAF Screens, forms, and reports per business needs using OAF Substitutions.

Customized Oracle Reports and developed new XML Publisher reports.

Experience in extending self-service applications using OA Framework/ADF.

Excellent knowledge of Oracle 11G SOA suit

Excellent knowledge of web-based standards such as SOAP, UDDI, WSDL, XSD, XPath, XSLT and XML

Extensive technical experience in P2P Cycle with sound functional knowledge.

Extensive technical experience in iProcurement (OA Pages and Workflow Customization) with sound functional knowledge.

Extensive technical experience in AME (Approval Management Engine).

Co-ordinated various teams (Design, Development & Testing and Configuration teams) in various Oracle Application Implementation projects.

Extensive technical experience in writing stored procedures, Packages and functions using SQL & PL/SQL.

Extensive technical experience in PL/SQL Wrapper packages to call Standard API’s in Oracle EBS.

Extensive technical experience in workflow customizations of standard workflows.

Extensive technical experience in Writing Unix Scripts.

Extensive technical experience in create new oracle workflows.

Excellent communication, leadership, interpersonal skills. Dedicated and Motivated in accepting various challenges imposed on me and showing enthusiasm in group work assigned to the team.

Extensive technical experience in ADF creating of ADFBC and ADF Faces.

Extensive technical experience in Create and migrate AOL objects.

Monitor and co-ordinate with junior associates.

Work with managers and wit Sr Managers.

Meet the Business team with Sr functional team to gather the business inputs.

Involving functional discussion calls.

Prepare the technical design docs, Unit test docs and BR100 docs for AME changes

Technical Highlights

Extensive experience on Oracle Application Framework (OAF), SQL/PLSQL, XML Publisher and RDF Reports, Customization of Forms, Interfaces, Conversions using Standard Oracle APIs, Oracle Workflows, AME and Oracle Forms .

Having extensive experience on analyze and modify code to meet R12.2 coding standards.

Completed One project in 12.2.4 and currently working on 12.2.9 upgrade project.

Extensive experience on personalizing, extending and customizing standard Oracle pages using OA framework.

Extensive experience on creating and migrating OAF pages and components to server.

Extensive experience on creating and customizing oracle workflows and almost customized all workflows from P2P cycle.

Purchase Order Create Workflow

Requisition Create Workflow

AP Invoice Create workflow

PO Auto create Workflow

Supplier Registration and Management Workflow

Supplier PO Changes Workf low.

.

Extensive experience on Implementing/Customize AME for below modules.

Purchase Order Approval.

Requisition Approval.

Invoice Approval

Highly Customized OA Pages from iSupplier modules

Purchase Order Header Page.

Purchase Order Line/Details Page

All Purchase Requisition Pages.

Invoice Create Page for PO and NON-PO invoices.

Invoice Approval screen

Software Tools: SQL Loader, SVN, MS Visio, SQL* Plus, Toad, Oracle Forms 10g Oracle Reports 10g, XML BI Publisher, J Developer, IBM Clear Case and Clear Quest, Oracle Workflow builder and MS-Office.

Extensive functional knowledge on financial modules AP,AR,GL.

Education

Masters of Computers Applications from Osmania University India.

Professional Experience

Company: Nabors Industries Inc

Duration: March 2017 to Till Date

Role: Sr System Analyst

Description: Nabors has Procure to pay lifecycle, Inventory, Order to Cash and Financials in Oracle Applications with few other Home-Grown systems and ERPs, I am working as an Architect/Integration team lead.

Responsibilities:

Sr. System Analyst for Oracle Financial Applications and NSG system (Nabors Home Grown Application).

Designed a custom solution for Integrating Invoices Into oracle from other system..

Designed a custom solution for Tax calculating for non localized countries.

Customized AP Invoice creation pages.

Developed a custom functionality to send notifications including attachments for Oracle documents such as Purchase orders, Non PO invoices into NSG system.

Developed Purchasing and Payables integration from NSG to Oracle for Requisition, Purchase Orders and Invoices.

Created a custom OAF tax region in iSupplier page for vendor’s to enter the tax and created a custom package to create tax lines in oracle.

Created a custom functionality to create invoice item lines and tax lines using iSupplier page to bypass standard functionality to satisfy Nabors business.

Developed GL Interface for different end systems.

Worked on Item Interface and GL Balances Interface.

Highly Customizing, Personalizing and extension of the iProcurement and iSupplier OAF pages.

Highly Customizing, PO, PR, Invoice and Auto CreatePO Work Flows.

Build GL Balances Interface with different down systems.

Customized iSupplier Invoice pages.

Custom BC4Js (EOs, VOs, AM) and UIX (Cos, Pages, Regions) components for above OA Framework pages.

Customized AME for PR, PO and Invoice routing.

Interface to import the Oracle Purchasing Requisition and Oracle Purchase Orders

Customizing Invoice creation iSupplier Pages.

Working with Custom hook packages.

Customize Create PO document workflow

Customized Account Payables Invoice Pages

Implemented PO and PR Transfer functionality for PO and PR notifications

Implemented/Configured AME for PO, PR and AP invoice approvals

Created XML bursting reports

Created HTML body report

Worked on support tickets

Monitor the off-shore team

Having daily meeting schedule call with off-shore team

Created shell scripts to migrate OAF, workflow and PL/SQL objects

Customize workflow screen for AME approval notifications

Created PL/SQL API asper business requirement

Created PL/SQL API asper business requirement

Working with business team to get Support tickets

Take ownership for tickets and fix the tickets

Company: Infolob Solutions

Duration :APR 2016 – March 2017

Sr Oracle APPS/EBS Developer

Responsibilities:

Customized Ebs Login Page to display Company Logo.

Created Custom OAF pages for implementing iProcurement enhancements.

Created custom BC4Js(EOs, VOs, AM) and UIX(Cos, Pages, Regions) components for above OA Framework pages.

Created File Browse OA Page to import files Into Server to Process.

Worked With Oracle APPS APIs.

Working with SQL loader scripts.

Worked Warehouse inventory and quantity summary report

Register OA Page with Oracle Ebs.

Developed Item Import Conversion

Developed Item Revision Conversion

Developed Return and Repair Aging report

Worked on Supplier Conversion

Customized LPN and telnet screens using MWA framework

Worked on various Production support issues

Customized iExpenses review page

Company Name: IBM India Pvt Ltd

Duration: Aug 2013 To March 2016

Role: Oracle APPS/Ebs Developer

Client Name: Motorola Solutions

Responsibilities:

Creating Custom OAF pages as per MD-50 document.

Creating Custom OA pages in AP module.

Creating Supplier Site External Bank Search Page.

Creating Supplier Site External Bank, Disable External Bank Page as per Business requirement.

Developing various operations of custom workflows like bank create bank update and banks disable workflows.

Personalize Oracle Forms in Depot Repair Super User Responsibility (SVC Module).

Write PL/SQL Packages to call from Form Personalization’s.

Extended Java class for Invoice page to make attachment mandatory (OAF CO Extension).

Extended Purchase Order Page to make PO terms LOV disable based on users in Purchase Order Page (OAF CO Extension).

Customized Work Conformation Workflow as per business requirement.

Customize iExpenses CO and Personalized iExpenses Submit Page as business requirement.

Customized PO requisition Workflow and AME transaction Type.

Create Various Approval groups for PO Requisition AME.

Created couple utilities in OAF like to browse file to transfer server.

Preparing DOUS.

Preparing MD-70 and UTP documents.

Downloading and migrating all LDT files from UNIX terminal.

Chek-In and Chek-Out files from SVN.

Company Name: IBM India Pvt Ltd

Duration: Aug 2013 To March 2016

Role: Oracle APPS/Ebs Developer

Client Name: Emerson

Responsibilities:

Creating Custom pages as per MD-50 document.

Personalizing standard pages as per client requirements.

Worked on Item availability interface.

Worked on Price availability interface. Availability.

Created XML reports as per business logic.

Migrate all OA, SQL/PLSQL scripts to other environments.

Preparing technical design documents for build components.

Having calls with functional team and gather requirements.

Monitoring Junior associates.

Working OAF personalization IN OM module.

Creating MD-70, change document and UTP for delivered OA personalization objects.

Extending Custom VO objects as per business demand.

Extending Application Module in standard pages as per new implementation.

Responsible for Production support for issue resolution, user request, data load, performance issue.

Developing new XML Publisher reports and customizing existing Oracle standard RDF reports to meet the requirements using Reports 10g

Involved in Development & Design of a Custom OAF.

Set up test data/scenario as required for testing the resolution of the issues

Preparing MD50, MD70 and TE20 documents

Migration designing and strategy development of legacy data into Oracle Apps

Design and developer XML schemas used within the enterprise

Provide and manage the technical scope related to SOA integrations

Design and develop ESB/BPEL processes (Synchronous and Asynchronous)

Designed and built SOA composites and BPEL processes that polled the legacy system for incoming customer data, performed filtering and transformation operations on it before inserting into EBS system

Testing the functionality for new enhancements

All necessary support related to QA (Quality Assurance) for new enhancements

Post production Support when the new releases goes live

Environment: Oracle Applications R12 – Oracle Order Management, Oracle Purchasing (PO), Oracle Oracle Order Management (OM), OA Framework, Form Personalization’s, PL/SQL, Reports, XML Publisher, UNIX.

Company Name: IBM India Pvt Ltd

Duration: Aug 2013 To March 2016

Role: Oracle APPS/Ebs Developer

Client Name: Wyndham

Responsibilities:

Working OAF personalization IN AR module.

Creating MD-70, change document and UTP for delivered OA personalization objects.

Extending VO objects as per business demand.

Extending Application Module in standard pages as per new implementation.

Extending CO files as per new logic.

Personalizing standard OA pages.

Migrating all OA changes one instance to another instance.

Giving support for test team.

Prepared migration script for OA objects.

Preparing of technical design document for OA objects.

Having calls with client to collect requirements.

Monitoring junior associates.

Prepare and review project specific documents like Change Documents or MD-70, Unit Test Plan, Use case document, Setup documents.

Attend weekly status meetings and also one to one calls with the client CSIT team for requirement gathering and guiding the CSIT team with the testing steps by conducting WEBEX sessions for the same.

Created employee resignation flow pages for HRMS module.

Created employee resignation workflow for HRMS Module.

Environment: Oracle Applications R12 – Oracle Financials, Oracle Projects, PL/SQL, Oracle Forms, Reports, XML Publisher, OAF, Work Flow.

Company Name: IBM India Pvt Ltd

Duration: March 2010 to March 2013

Role: Technical Associate

Client Name: BT(British Telecommunication)

Responsibilities:

Developed inbound interface program to transfer data from Legacy system to Oracle PIM.

Attending the Design Walkthroughs and analysis of Functional design documents.

PIM Configuration management involving Item Catalog Category, Attribute Groups, Attributes and Value sets.

Creation of lifecycles, Phases and Lookups.

Developed Functions, Procedures and Packages to extend and customize.

Prepared unit test case documents.

Prepared Automated Unit test cases.

Followed the company standards for programming tools and techniques.

Actively participated in Deployments & Test support.

Create New Value sets as per design.

Doing ICC level configure changes.

Creating SQL/PL_SQL scripts.

Preparing Unit test cases for OA pages.

Executing PL/SQL Packages, SQL scripts.

Involving in Deployment on various environments.

Giving support for live deployment.

Creating Profiles and Look Up’s.

Downloading and uploading LDT files.

Working on various CRs related to Tools

Involving in Design calls.

Involving in Various Show/Tell programs

Creating VO’S, EO’s.

Involving in Design Calls.

Creating SQL/PL_SQL scripts.

Creating Custom Pages (Reference Data Pages) based on client requirement.

Personalize OA pages.

Preparing Unit test cases for OA pages.

Executing PL/SQL Packages, SQL scripts.

Involving in Deployment on various environments.

Giving support for live deployment.

Creating Profiles and Look Up’s.

Downloading and uploading LDT files.

Working on various CRs related to Tools

Involving in Design calls.

Involving in Various Show/Tell programs

Customizing PIM Application as per requirement.

Creating Attribute Groups, Attributes attach to Attribute Groups

Creating Valusets, Lookups and attaching them to attribute groups.

Developed Custom PL/Sql Packages, Procedures.

Applied Configure Changes

Developed various rules in PL/Sql.

Creating AOL components and down loading LDT and uploading LDT files.

Deploying Various EBS-Components in all environments

Creating serverdev.properties files.

Creating serverdev.properties files.

Giving support for various deployments.

Involved in giving solutions to ASG (Application Support Group).

Environment: Oracle PIM and PDH(Product Data HUB) –Oracle Inventory, Oracle Purchasing, PL/SQL, Oracle Forms, Reports, OA Frame Work, Oracle Work Flow.



Contact this candidate