Post Job Free

Resume

Sign in

Oracle Apps Techno functional consultant.

Location:
Muscatine, IA
Posted:
October 13, 2020

Contact this candidate

Resume:

Seshaiah Boddukuru

Ph: 832-***-****

adgxj2@r.postjobfree.com

SUMMARY

Over 12 Years of Experience in IT and 11+ years in Oracle EBS implementation and Enterprise Applications Practice with proven experience in Developing, Customizing and Supporting Oracle Applications (11i & R12), AOL of Oracle E-business Suite. These include Analysis, Design, Development, and Implementation of different projects for applications based on Relational DBMS, and in the field of Oracle e-business Suite.

Good Expertise in developing applications using SQL, PL/SQL, Database Triggers, Stored Procedures, Oracle 10g/9i/8i/8.0.5/7.x and Developer 6i and 10g.

Expertise in RICEW (Reports, Interfaces, Conversions, Extensions and Workflow).

Highly proficient in requirements gathering, business systems study, technical solution design, and system document preparation using AIM methodology

Good Expertise in functionality of Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Oracle Purchase Order(PO), Oracle Order Management (OM), Oracle Projects (PA), Oracle Inventory (INV), Bill of Material (BOM), Work in process (WIP) and Oracle Application Object Library (AOL).

Functional knowledge on Cash Management (CM) module.

Good Expertise in developing automated processes using Oracle Workflow 2.6 /AME

Good Knowledge in developing self service applications using Oracle Application Framework (OA Framework) using Oracle Jdeveloper 9.0.3/10g.

Good Expertise in Query and Performance tuning in Oracle.

Extensive experience in conversion of legacy data into Oracle Applications using SQL Loader and PL/SQL.

Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.

Extensive Experience in using Oracle Application Object Library (AOL) features including implementation of Flexfields (Like Implementing Cross Validation Rules, Implementation flexfields in reports, Security rules), creating and scheduling of Concurrent programs etc.

Experienced in Full software development life cycle implementation (SDLC).

Extensive experience in design and development of applications under UNIX and Linux environments.

Setup and Configured applications to support client requirements.

Good Expertise in TCA (Trading Community Architecture).

Good functional expertise on Open Interfaces (Includes both inbound and outbound interface) in Oracle Manufacturing and Financials.

Experience in E-R Modeling to create Data Models both Logical and Physical design using ER Win.

Experienced in working with Huge Datasets comprising of at least greater than 10 Mill records.

Competent in Tuning the SQL and PL/SQL Procedures by enforcing HINTS and OPTIMISER and by using SQL Trace, Explain Plan and TKPROF Tools.

Exposure to data support on Multiple Environments like UAT, SIT, INT, INT2, Training, and Production Environments on an Enterprise Level. Responsible for data consistency and integrity across the board.

Enthusiastic to learn new skills with a shorter learning curve.

Excellent Communication, Good Work Ethics, and a Team Player.

TECHNICAL SKILLS

ERP : Oracle Applications Release 12, 11i, and Release 10.7.

Modules : Oracle Inventory (INV), Oracle Purchasing (PO),

Oracle Order Management (OM), Oracle Work in Progress (WIP), Oracle Payables (AP), Oracle Receivables (AR), Oracle General Ledger (GL), Oracle Projects (PA), Oracle iProcurement and Oracle iExpense and TCA

Others : Oracle Application Object Library (AOL) and Oracle System

Administrator (Sysadmin), Oracle Workflow version 2.6 and

Oracle XML Gateway

Primary Skills : Oracle Apps Techno functional

Databases : Oracle 11g, 10g, 9i, 8.x/7.x/6.x, SQL Sever (v7.0).

Development Tools : Oracle Developer - Forms 10g/6.x/5.0, Reports 6.x/3.0/2.5

Oracle Discoverer 4i, 3.0, Oracle Jdeveloper 11g, Workflow 2.6.3

Programming Languages : Core Java, SQL, PL SQL, HTML, XML, WSDL

Operating Systems : Windows 2000, Windows NT, Windows 98/95,

UNIX, Sun Solaris, AIX, HP-UX, IRIX.

Hardware : Intel Based Servers and Workstations, HP DEC Alpha,

DEC VAX.

Case Tools : Oracle Designer 2000

Version Control Tool : PCVS, STAT, SVN and Microsoft Visual studio.

Tools : TOAD, SQL-Navigator, SQL Loader, SQL Developer and

Pl/Sql Developer

Scripting : ksh/ C shell

ACADEMICS

Master of Computer Applications from Acharya Nagarjuna University, 2008.

PROFESSIONAL EXPERIENCE

HNI – Muscatine, IA 05/2018 to Current

HNI and Walls Integration Technical Architect/Developer

Environment: RICE Elements, R12.2.4, Linux Scripting, SQL, PL/SQL of Oracle 12c, Developer 12C Oracle Developer (OAF Personalisation, SOAP UI, Web services), XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Modules: Oracle Inventory (INV), Oracle Payables(AP), Oracle Purchasing (PO), Application Object Library (AOL), Oracle Order Management (OE/OM), Oracle Accounts Receivable (AR), Oracle Project accounting (PA), Oracle iProcurement and Oracle Cash Management.

HNI Corporation (formerly HON Industries) is the second-largest office furniture manufacturer in the world in regard to revenues resulting from office segment sales, behind Steelcase. Its headquarters are in Muscatine, Iowa U.S. HNI's brands include The HON Company, Allsteel, Gunlocke, Paoli, Maxon, HBF, Sagus, Heatilator, Heat & Glo, Harman, Quadra-Fire, Lamex and OFM, Inc. The company was founded in 1944 by engineer C. Maxwell Stanley, advertising executive Clem Hanson, and industrial designer H. Wood Miller.

Responsibilities:

Working as a technical developer in OTC track and supporting Oracle Applications R12.2.4.

Worked on sales order line workflow (OEOL) and header (OEOL) customizations for walls project implementation.

Supporting Order Entry issues and assisting customers with the resolution.

Responsible to fixing the issues in Test environment as part of POC.

Co-Ordinating with Offshore folks and arranging client meeting if they required any.

Making the require code changes and migrating the objects if business wants to fix on any object on urgent basis.

Troubleshooting long running jobs and assisting on the performance tuning.

Working on forms personalization’s, customizing the report objects, XML reports, and using Custom and Standard APIs.

Expertise in using the Bitbucket, Flex deploy, Microsoft Visual Studio, SVN, PVCS and Kintana tools for version control and migrating objects from instance to instance.

Working with Oracle Support Team and get the fixes for Oracle standard bugs.

Airliquide - Houston Texas 02/2017 to 04/2018

Orchestra and Enhancements, Computer Programmer

Environment: RICE Elements, R12.2.5, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 11g, Developer 10g Oracle Developer (OAF Personalisation, SOA, BPEL, Web services), XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME. Discoverer 10g

Modules: Oracle Inventory (INV), Oracle Payables(AP), Oracle Purchasing (PO), Oracle General Ledger(GL), Application Object Library (AOL), Oracle Order Management (OE/OM), Oracle Accounts Receivable (AR), Oracle Project accounting (PA), Oracle iProcurement and Oracle Cash Management.

Airliquide is a French multinational company which supplies industrial gases and services to various industries including medical, chemical, and electronic manufacturers. It is world’s second largest supplier of industrial gases by revenues and has operations over 80 countries.

Responsibilities:

Developed AR Auto invoice open interface

Developed Sales Order shipping confirmation alert using Oracle Business Events.

Worked on AP unpaid invoice report.

Retrofitted objects of PO, OM, AP, AR and GL in accordance to 12.2.5 standards.

Developed/Retrofitted AP check printing program according to R12.

Developed Expenditure extraction outbound interface.

Developed/Retrofitted AP check printing program according to R12.

Worked on supplier extraction outbound interface and transmitted the data to third party systems using secured file transfer protocols.

Developed a script to update missing credit receivers information in Oracle projects

Worked on Project transaction client extensions.

Worked on project accounting expenditure report.

Customized Invoice print report in AR module.

Co-ordinated with offshore team in compiling the custom forms and reports in 10g which are developed in 6i.

Developed UNIX shell scripts

Expertise in using the SVN, PVCS and Kintana tools for version control and migrating objects from instance to instance.

Airliquide - Houston Texas 03/2016 to 01/2017

Chrysalis, Airliquide Oracle Techno functional consultant

Environment: RICE Elements, R12.2.2, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 11g, Developer 10g Oracle Jdeveloper (OAF Personalisation, SOA, BPEL, Web services), XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME., Discoverer 10g

Modules: Oracle Inventory (INV), Oracle Payables(AP), Oracle Purchasing (PO), Oracle General Ledger(GL), Application Object Library (AOL), Oracle Order Management (OE/OM), Oracle Accounts Receivable (AR), Oracle Project accounting (PA), Oracle iProcurement and Oracle Cash Management.

Airliquide is a French multinational company which supplies industrial gases and services to various industries including medical, chemical and electronic manufacturers. It is world’s second largest supplier of industrial gases by revenues and has operations over 80 countries.

Responsibilities:

Worked on PO Print Report.

Worked on Project transactions extensions.

Worked on ACE and Oracle Interface

Worked on ACE Information Report.

Developed Inventory item Outbound interface.

Developed discrete job routing with MIS information report.

Developed sales order extraction outbound interface and transmitted the data to third party systems using secured file transfer protocols.

Developed Intercompany report in Oracle Order management.

Developed on Project commitment report.

Worked on project accounting expenditure report.

Worked on OAF customizations in Oracle Order Management module.

Worked on duplicate project report.

Developed the OAF customizations in Customers pages which are changed from Forms to OAF.

Co-ordinated with offshore team in compiling the custom forms and reports in 10g which are developed in 6i.

Co-ordinated with offshore in retrofitting other module objects.

Involved in arranging the sequence of objects for migration activities.

Expertise in using the PVCS and Kintana tools for version control and migrating objects from instance to instance.

Airliquide - Mumbai 12/2015 to 03/2016

Airgas and Airliquide Integration Oracle Apps Technical

Environment: RICE Elements, R12.2.5, 11i, UNIX Scripting, SQL, PL/SQL of Oracle 11g, Developer 10g Oracle Jdeveloper (OAF Personalisation, SOA, BPEL, Web services), XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME. Noetix, Discoverer 10g

Modules: Oracle Inventory (INV), Oracle Payables(AP), Oracle Purchasing (PO), Oracle General Ledger(GL), Application Object Library (AOL), Oracle Order Management (OE/OM), Oracle Accounts Receivable (AR), Oracle Project accounting (PA), Oracle iProcurement and Oracle Cash Management.

Airliquide is a French multinational company which supplies industrial gases and services to various industries including medical, chemical and electronic manufacturers. It is world’s second largest supplier of industrial gases by revenues and has operations over 80 countries.

Responsibilities:

Developed AP Invoice Open Interface

Worked on outbound pull the information from Oracle systems and provided to SAP

Worked on couple of scripts by pulling the customer information, item and supplier and fixed assets information and provided to Airgas system.

Flowserve, Chennai 08/2015 to 12/2015

Role Oracle Apps Techno functional

Environment: RICE Elements, R12.1.3, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Modules: Oracle Inventory (INV),Oracle Payables(AP), Oracle Purchase (PO), Oracle General Ledger(GL), Oracle HRMS, Application Object Library (AOL), Oracle Order Management (OE/OM), Oracle Accounts Receivable (AR), Oracle Fixed Assets (FA), and Oracle Cash Management.

Responsibilities:

Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.

Gathering User requirements and implement them in the best possible way and document the process.

Experienced with P2P and O2C cycles.

Defined the Qualifier and Modifier setups in pricing module.

Automated Employee vendor Bank Account in synch with Payroll Bank Account for Electronic payment.

Worked on Invoice prepayment report.

Customised AP EDM Invoice Report.

Customised I-Supplier Self serviced pages to capture Bank Account Details.

Developed INBOUND and OUTBOUND Interfaces based technical specifications.

Developed custom reports (including BI Publisher) in Financial Modules based on user requirements.

Configured descriptive (DFF) flex fields for storing custom information.

Developed, Personalized & Configured through Oracle Forms, Oracle Reports, Oracle Workflow, Oracle ADI, Oracle APIs, Fast Formulas, Oracle 10g, PL/SQL, UNIX for Writing registration Scripts for Application Object Library objects, also used FND_LOAD to migrate object from one instance to another.

Post production maintenance for the conversions and interfaces in Oracle Applications.

Airliquide, Houston Texas 03/2014 - 08/2015

Role Computer Programmer

Environment: RICE Elements, R12, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Modules: Oracle Inventory (INV),Oracle Payables(AP), Oracle Purchase (PO), Oracle General Ledger(GL), Oracle HRMS, Application Object Library (AOL), Oracle Order Management (OE/OM), Oracle Accounts Receivable (AR), Oracle Fixed Assets (FA), Oracle iSuppliers and Oracle Cash Management.

Airliquide is a French multinational company which supplies industrial gases and services to various industries including medical, chemical and electronic manufacturers. It is world’s second largest supplier of industrial gases by revenues and has operations over 80 countries.

Responsibilities:

Preparing MD070 documents based on MD050.

Experienced with P2P and O2C cycles.

Gathering User requirements and implement them in the best possible way and document the process.

Done the Configuration for GL, AP, AR, and Cash Management modules as per the client needs.

Interact with third Party vendors like Citibank to setup them as Vendors in Oracle AP module and process invoices, electronic payments for these Vendors.

All store managers does have corporate credit Cards for their expense maintenance, American express sends these Credit Card expenses electronically, we load these transactions as Credit Card Expenses into Payables and these payment for these Credit Card transactions will be made through normal AP Invoice, payment Process.

Designed Technical Designs for RICEW elements based on Functional Specs.

Projects Expenditure Transactions Process.

Developed INBOUND and OUTBOUND Interfaces based technical specifications.

Developed custom reports (including BI Publisher) in Financial Modules based on user requirements.

Implementing Forms personalization.

Internal Sales Order/Internal Requisition process was Configured to establish a simplified Intercompany sales across operating Units

Developed custom self serviced pages using Oracle Jdeveloper.

Development of Custom Packages, Procedures and Functions in ERP. Involved in Performance Tuning of the SQL Statements to reduce the process time. Conducted Business meetings for the Project plan.

Writing registration Scripts for Application Object Library objects, also used FND_LOAD to migrate object from one instance to another.

Developed shell scripts to automate the processes using Autosys scheduler.

Post production maintenance for the conversions and interfaces in Oracle Applications.

Airliquide, Mumbai India 08/2011 - 03/2014

Role Oracle Apps Technical

Environment: RICE Elements, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Modules: Oracle Inventory (INV),Oracle Payables(AP), Oracle Purchase (PO), Oracle General Ledger(GL), Oracle HRMS, Application Object Library (AOL), Oracle Order Management (OE/OM), Oracle Accounts Receivable (AR), and Oracle Cash Management.

Responsibilities:

Oracle Apps Technical Consultant for support and maintenance project.

Involved in the day to day activities of production support of Oracle applications environment in AP, PO, OM, INV, AR, iExpense, iProcurement and GL.

Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.

Work on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.

Support includes the transaction integration for Sales Orders, Purchase Orders, and Customer Returns etc. Setup related integration for Items, Vendors, and Customers etc.

Avantha Technologies Limited, India 07/2010 - 07/2011

Ingersoll Rand Oracle Techno Functional

Environment: Oracle 9i RICE Elements, 11i, UNIX Scripting, SQL, PL/SQL, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Modules: Oracle Inventory (INV),Oracle Payables(AP), Oracle Purchase (PO), Application Object Library (AOL), Oracle Order Management (OE/OM), Oracle Accounts Receivable (AR), and Oracle Cash Management, Oracle Work in progress(WIP).

Ingersoll Rand is one of leading manufacturing organization which advances the quality of life by creating comfortable, sustainable and efficient environments. Their main brands including Club Car, Ingersoll Rand, Thermo King and Trane - work together to enhance the quality and comfort of air in homes and buildings; transport and protect food and perishables; and increase industrial productivity and efficiency. They are a global business committed to a world of sustainable progress and enduring results.

Responsibilities:

Worked as team member in the team.

Developed RDF reports and XML publisher reports.

Developed and customized on Oracle interfaces by using third party applications like SOA and Web Methods.

Registration of Concurrent Program Executables, Concurrent Programs, Parameters, Value Sets, Request Sets.

Worked on Picking and shipping Outbound Interface.

Developed Internal Requisition Interface by using XML gateway.

Developed on Debit and Credit Memo Invoice Report.

Customized on Oracle Supplier and Supplier sites Reports.

Developed custom Inventory material transactions error XML report as per my client requirement.

Migration of AOL and Non AOL objects from one Instance to another Instance by using Kintana tool.

Kenexa Technolgoies, India 01/2009 - 06/2010

Environment: Oracle 9i, Oracle Apps 11i, Developer 2000, SQL, PL/SQL, Unix, Brio, HTML, Word, MS SQL Server, Windows NT and Data Loader.

Responsibilities:

Worked as Oracle apps Technical Consultant.

Extracted data from existing data source by using SQL, PL/SQL, and UNIX.

Created tables, views, procedures, SQL scripts.

Worked on Onhand quantity conversion

Worked on Data loading activities using Data Loader tool.

Physical and Logical Database Backups. Export/Import Tables.

Developed forms using Forms 6i using advanced GUI features like pop-ups, stacked canvasses etc.

Designed & developed reports using Oracle Reports, SQL, PL/SQL.

Requirement gathering and analysis.

Implementation of new organizations.

Development of inbound interface.

PL/SQL packages, procedure and function creation and modification.

Enhancing requisition approval workflow by adding new nodes and attributes in requisition workflow.

Creation of attributes, processes, functions, roles, messages, Notifications in using Oracle workflow builder.

Carrying out testing from Req creation to invoice creation.

Coordinating the team during production move.

Dealing with clients on day to day basis.

Analysis of impacted reports including PO print rdfs.

Modifying Oracle reports as per business requirement.

Providing Support on Postproduction issues.

CERTIFICATIONS

Oracle Financials Cloud: Payables 2019 Certified Implementation Essentials.

Oracle E-Business Suite 12 Supply Chain Certified Implementation Specialist: Oracle Purchasing Certification

Oracle E-Business Suite 12 Supply Chain Certified Implementation Specialist: Oracle Inventory Certification



Contact this candidate