Oracle Applications Pl
Resume:
Punyavathi Chevuri
**** ******* ****, ******, ** - 22101
571-***-**** -***************@*****.***
Professional Summary
To secure a challenging position with scope for future career growth, which will enable me to use my strong technical and functional skills in the field of Oracle Applications. Having 11+ years of experience in IT (as an Oracle PL/SQL Developer (4 years) and Apps Technical consultant (7+ years)).
5 Full cycle implementation experience of Oracle E-Business Suite R12 and workflow implementation.
Good experience in capturing requirements from the clients and providing the solutions.
Skills:
Oracle PL/SQL Expertise:
Having total 4+ years of experience in Oracle PL/SQL Domain.
Having experience in both End to End Implementation and Supporting of Oracle database Projects.
Good Experience in Oracle Database design and programing.
Developed multiple PL/SQL packages as per the client’s requirements for data conversions.
Involved in the data reporting.
Involved in the Triggers development as per the client requirement.
Worked with advanced PL/SQL objects like Pragmas, BULK Collect and BULK Select options.
Oracle Applications Experience:
Having Good Experience on RICEW, OAF, and Workflow and Forms Personalization Components in finance and SCM Modules.
Experience in Procure to Pay cycle (PO-AP-GL).
Experience in Order to cash cycle (OM-AR-GL).
Experience in programming with Oracle tools such as Forms 10g, Reports 10g,PL/SQL, SQL, SQL* LOADER.
Having functional knowledge in different modules in Oracle Applications (PO, AP, AR, GL, INV)
Developing oracle Applications reports, Interfaces and Customization of Apps reports and enhancement of Interfaces.
Experience in working with custom Reports and developing Interfaces in PO, AP and INV.
Having Good Knowledge on AOL (System Administrator, Application Developer).
Work History:
Worked as Oracle Apps Technical Consultant at Divimaxim Technologies Pvt Ltd, Hyderabad from OCT-2016 to Mar-2023.
Worked as PL/SQL developer at HCL Technologies, Hyderabad from Aug-2012 to Sep-2016.
Technical Competencies:
ERP : Oracle Applications R12 (Financials, SCM)
Technical : RICE (Reports, Interfaces, Conversions, Forms), OAF Workflow.
Reporting Tools : MS Excel 2003, Web Analysis Studio, BI, OTBI Reports.
Operating Systems : WINDOWS 98/2000/NT 4.0/XP/2003 server, MS-DOS.
Databases : MS SQL Server 2000, MS Access.
Oracle EBS Professional Experience:
Project:1
Client : WABCO Implementation
Project : Oracle EBS implementation R12
Role : EBS Techno-Functional Consultant
Responsibilities:
Development and Customization of RICE components.
Involved in the OAF page Personalization and Extensions.
Development of Technical Design Documents.
Defining Concurrent Programs and Executable.
Customized existing reports as per the client requirement.
PL/SQL Coding for interfaces and Reports.
Development of PL/SQL validations for the inbound interface.
Developed XML Publisher Reports.
Worked on UTL PACKAGES and SQL*LOADER for the interfaces and conversions.
Performed the unit testing for the code and migrated the files through FND LOAD.
Project:2
Client : Pearson
Project : Oracle EBS implementation R12
Role : EBS Technical Consultant
Pearson Education is a British-owned education publishing and assessment service to schools and corporations, as well for students directly. Pearson owns educational media brands including Addison–Wesley, Peachpit, Prentice Hall, eCollege, Longman, Scott Foresman, and others
Responsibilities:
Customized BI Report as per the client requirement.
Involved in Forms personalization and also Customization of OAF Page by using the JDeveloper worked with View Object changes.
Developed GL Journal interface for data loading
Involved in the AOL Objects Creation, Customization and Migration process.
Customized Print RFQ Report
Customized AP Module Check Printing reports
Developed BI Reports with Multi layout and also developed Multi Language reports.
Developed Quotation BI Template report.
Developed PL/SQL Packages for Data validation purpose.
Developed SQL Loader program for data loading in Inbound Interfaces.
Worked with D2K reports customization for making changes in Query, Formula Columns.
Customized Oracle Standard Reports in Inventory module.
Worked with Fusion Trees.
Project #3
Client : Puffer-Sweiven
Role : Technical Consultant
Modules : Oracle Applications R12 (AP, AR, GL, PO, INV, OM)
Puffer-Sweiven is a leading solutions provider for process control and flow control. We serve several industries including Oil & Gas, Refining, Petro-chemicals, Utilities, Power and Pulp & Paper. We also provide products and services to the Engineering Contractors who serve these industries.
Responsibilities:
Part of production as well as enhancement team on support.
Resolved the issues related to customizing the reports, extracts etc.
Conduct Technical analysis for developing new reports.
Mapping functional specifications to technical for customizing existing reports as well as new reports and registering all custom components in Apps.
Unit testing and Integration testing.
Other issues related to reports in Production.
Reports:
Developed Purchase order and Receipts report.
Developed Shipment transaction report.
Developed Purchase requisitions report.
Customized Invoice report.
Interfaces:
Developed Inbound Interface in GL module to upload the transactions data from flat file to Oracle apps base tables.
Developed Replenishment Interface to upload the data from flat file to apps Inventory base tables.
Forms:
Developed new forms in Purchasing and BOM module using the TEMPLATE.fmb
Having Good knowledge in the CUSTOM.pll Package.
Implementing DFF’s for the new forms.
Project: 4
Client : Swiss Re
Role : Technical Consultant
Modules : Oracle Applications R12 (AP, AR, GL, PO, INV, OM)
Responsibilities:
Prepared detailed test scripts for change requests and end to end testing.
Worked on functional and technical testing.
Constant interaction with Onsite team.
Involved in UAT activities.
Prepared SQL scripts to fetch details from backend.
Worked on testing activities related to Oracle development.
Providing Technical support solutions to the customers.
Interacting with customers on critical issues and providing resolutions in time.
Worked on AP, AR, CM.
Defect tracking.
Daily interacting with development team regarding defects.
Execution of test cases.
Customized Oracle Standard Workflows.
Customized Requisition Approval workflow as per the client requirement.
Oracle PL/SQL Professional Experience:
Project:1
Client : RAMCO ERP Implementation
Project : Oracle D2K Custom ERP
Role : PL/SQL Developer
Responsibilities:
Developed PL/SQL Triggers as per the client requirement for execution of Jobs.
Developed PL/SQL packages for data validation purpose.
Be the go-to expert for Oracle and PL/SQL.
Experience in PL/SQL Advanced concepts like Pragmas, UTL_FILE Packages as well as BULK Collect.
Participate in coding and enhancements.
Tune, script, and extract, transform and load.
Support daily business operations related systems.
Run systems manually (test files, re-runs) for exception cases.
Development and support Applications and services as specified by our business partners.
Project:2
Client : ICICI Banking Services
Project : Oracle
Role : PL/SQL Developer
Responsibilities:
Design, develop, and maintain database objects such as tables, views, stored procedures, functions, and triggers using PL/SQL.
Create and maintain database scripts for data migration, data transformation and data validation.
Develop and maintain database security and access control.
Develop and maintain database performance tuning and query optimization.
Develop and maintain database monitoring and alerting.
Develop and maintain database documentation.
Develop and maintain database standards and best practices.
Develop and maintain database integration with other systems.
Develop and maintain database reporting and analytics.
Develop PL/SQL packages for data import as well as export purpose.
Involved in the data Manipulation of the product transactions data as per the client requirement.
Contact this candidate