SUMMARY:

• Overall 10+ years of experience as Oracle Apps Techno Functional Consultant.
• Involved in Requirement Gathering, Analysis, Technical Specification, Design, Development, Conversions and Maintenance.
• Good experience of Order to Cash cycle (SCM and financials) Modules.
• Worked in Oracle ERP modules: GL (General Ledger), AR (Account Receivables), AP (Account Payables), PO (Purchasing), OM (Order Management), INV (Inventory), Sys Admin, Service Contracts, Oracle Install base, Oracle Quoting, AOL (Application Object Library), QP (Advanced Pricing).
• Good understanding of data modeling, tables and table relations in GL, AR, AP, PO, OM, OKS, SC, IB, INV modules.
• Expertise in SQL, PL/SQL, Advanced PL/SQL coding, Oracle XML Publisher, Oracle Apps Module, Oracle Forms, Oracle workflows and Oracle Reports.
• Experience with RICE components and Oracle AME workflows.
• Actively involved in maintenance/support projects, interface development, coding and testing with business. Given data extracts by developing SQL queries based on client’s requirement.
• Experience in maintenance/support projects of Oracle Order Management, Oracle Install Base, Service Contracts and Financial applications.
• Having Good Knowledge on JAVA. Developed OAF Pages.
• Involved in development/enhancements/bug fixes of Oracle Interfaces, Advanced PL/SQL units, Oracle Forms, Oracle Reports, BI (XML) Publisher and Oracle Discoverer Reports.
• Exposure to Oracle SOA, Oracle OAF and Informatica.
• Fair Knowledge and experience in Oracle Demantra Technologies.
• Worked on tools like Remedy, HP service desk, Citrix, TRS and Tracker.
• Very well versed with PVCS (Version Control Systems) and Migration Tools such as Kintana.

SKILL:

ERP Applications: Oracle EBS R12/11i

Modules Financials: Oracle Order Management, Accounts Payable, Oracle PurchasingOracle Service contract module, Oracle Install Base, Oracle Cash Management, Oracle Fixed Assets, General Ledger.

Languages/Frameworks: SQL, PL/SQL, JAVA, OAF and Oracle SOA.

GUI/Tools: JDeveloper, Oracle Forms, SQL*Loader, SQL*Plus, SQL Developer, Toad, Oracle Forms, Oracle Apex.

Databases: Oracle and MySQL

Reporting Tools: Oracle Reports, Oracle Discoverer, BI/XML Publisher Reports and Oracle Apex.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Oracle EBS Developer

Responsibilities:

• Identified the recurring issues in support and proposed an efficient solution with development plan and estimates with stakeholders.
• Providing the technical solutions on any issues proactively and communicate the same with stakeholders aligning with strategy of the team for smooth execution
• Oracle AR Receipt Performance Tuning and Automating the AP payment.
• Working with business analyst, to prepare the technical design documents and give estimates for the deliverables Developing the technical documentation using AIM methodologies and follow SOX procedures.
• Good Integration with external systems using SOA and build visualization and dashboards in Tableau based on business needs.
• Good Expertise in Database Management systems and Data modeling.
• Strong Unix Shell Scripting experience for file transfers to external and internal systems. Project: Wells Fargo inbound and outbound integration for payment files.
• Development/integration for new projects in financial modules (AR, AP, GL, CM and Purchasing) of Confidential . Given the idea for Confidential Product Rollout Automation Project which saves almost 2 to 3 months for each Product addition to Oracle Revenue Recognition Systems.
• Experience in Webservices to integrate the systems with other peripheral systems.
• Worked with Business Analyst to understand the business requirement and translate into technical specifications.
• Worked with System Administrator and Oracle Support for coordinating the support and maintenance of Oracle System.
• Providing the custom solutions for internal/third party interfaces, reporting and Oracle upgrades.
• Technical Design and development of bank integration in inbound/outbound interfaces.
• Worked with Business team to ensure all the configurations/setups are done to make the interface/extensions work.
• Worked with business team to understand the SOX and Audit pain points and automated the process to make the SOX/Audit practice easier.
• Automated the product addition in Oracle Financial systems for revenue recognition.
• Development of OAF pages and customization of OAF pages in iProcurement space.
• Implemented the GIT and review board process to fit in SCRUM process
• Development of Oracle BI publisher Reports (XML Reports).

Environment: SQL, PL/SQL, Java/OAF, BI/XML Reports, GIT, Shell Scripting, AP, AR, PO, CM and Fixed Assets

Confidential, Sunnyvale, CA

Oracle EBS Techno Functional Consultant

Responsibilities:

• Created PL/SQL procedures, functions, triggers as needed. Developed complex technical changes in PL/SQL and SQL queries.
• Development of Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos and AR receipts Interface for AR applications.
• Development of Customer API in Oracle Receivables. Developed Customer and Service Contracts Conversions.
• Worked with Business Analyst to understand the business requirement and translate into technical specifications.
• Development of OAF pages and customization of OAF pages.
• Developed customized Invoice print report, Revenue and Tax reports.
• Worked in Revenue Recognition part to create invoice with invoice rule, accounting rule to create the distributions for Revenue account.
• Development of Oracle BI publisher Reports (XML Reports).
• Experience with Agile methodologies and Scrum practices. Migration using Kintana.

Environment: SQL, PL/SQL, Java/OAF, BI/XML Reports, GIT, Shell Scripting, AP, AR, PO, CM and Fixed Assets.

Confidential, CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Created PL/SQL procedures, functions, triggers as needed. Developed complex technical changes in PL/SQL and SQL queries.
• Developed Customer API in Oracle Receivables. Developed Customer Conversion.
• Developed Data Conversion programs for Service Contracts.
• Worked in Process Lockbox inbound integration script.
• Mainly worked in Service Contracts Module (Order to Cash cycle). Solved the critical issues in Service Contract billing part.
• SQL queries performance tuning to improve the run time results.
• Worked in Oracle workflow issues and enhancements (OM Order Line Workflow and service contract Order Line Workflow). Personalization’s in - Service Contracts Form.
• Developed Lookup Form using Oracle Forms to display the order information, invoice information and Service Contract Information based on Customer PO information.
• Solved issues in Oracle AME workflow.
• Developed reports using Oracle XML publisher. And modified existing rtf report based on business needs.
• Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow.
• Prepared the technical design documents based on requirements.
• Prepared MD070 document for the PL/SQL and Report objects developed.

Environment: SQL, PL/SQL, Java/OAF, BI/XML Reports, GIT, Shell Scripting, AR, GL, Order to Cash, Install Base and Service Contracts.

Confidential, San Jose, CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Created PL/SQL procedures, functions, triggers as needed. Developed complex technical changes in PL/SQL and SQL queries.
• Developed Data Conversion programs for Sales Order, AP invoices, Install Base, Service Contracts, Unvoiced Receipts from Legacy (PeopleSoft) system.
• Worked in Oracle workflow issues and enhancements (OM Order Line Workflow and PO approval workflow).
• Worked in Sales Order form customization. Created the Order Import for implementation projects
• Created Integration package to extract balances from EBS to Hyperion interface.
• Involved in Financial audit and given all required reports to Audit team. GL and AP, AR report queries.
• Customized standard reports such as AR Customer Invoice Report, Pack Slip Report and Purchase Order Report.
• Developed Oracle Forms and have good knowledge in Oracle forms Personalization.
• Good knowledge in Defaulting rule of Sales order forms and processing constraints.
• Solved issues in Oracle AME workflow.
• Developed reports using Oracle XML publisher. And modified existing rtf report based on business needs.
• Worked in extending the functionalities of reports, workflows and Forms as per business need.
• Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow.
• Prepared MD070 document for the PL/SQL and Report objects developed.
• Expertise in Performance tuning to improve the run time results.
• Written PL/SQL stored procedures for back-end business logic and reports processing.
• Developed a program to import the GL budget balances from Hyperion Interface into Oracle Interface tables.
• Developed a Program to back up the GL workflow information for audit purpose
• Exposure to Unix Shell Scripting for deployments.
• Responsible for Migrations from Development instance to other testing instances and production using Dell Stat tool.
• Developed SQL queries to provide business critical data extracts. Exposure to customization of OAF pages.

Environment: SQL, PL/SQL, Java/OAF, BI/XML Reports, GIT, Oracle Workflow, AME, RICEW components, Shell Scripting, AP, AR, PO, CM and Fixed Assets.

Confidential, Milpitas, CA

Oracle EBS Techno Functional Consultant

Responsibilities:

• Worked in Custom TCA. Development of test scripts for UAT and testing. Creation of OAF Pages.
• Data Conversion scripts for Customers. Sales Order, Install Base and Service Contracts.

Environment: SQL, PL/SQL, Java/OAF, BI/XML Reports, Kintana, Web ADI, Shell Scripting, AR, OM, Install Base, Service Contracts .

Confidential, Palo Alto, CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in analysing the technical issues of Order to Cash cycle, Inventory, Install Base, Service Contracts.
• Provided production support to Service Contracts. Analyzed issues technical and helped the business user to solve their service Contracts issue.
• Worked on BPEL SOA suite. Analyzed the issue with the request and response from the Oracle ERP system.
• Worked in Oracle Workflow issues. Creation of OAF pages.

Environment: SQL, PL/SQL, SOA, BI/XML Reports, OM, IB, Service contracts.

Confidential

Senior Oracle Developer

Responsibilities:

• Involved in Functional Requirement Gathering from Business.
• Prepared the technical design document, Requirement Design Documents, Unit test Specification document.
• Based on the Customer need, Oracle Forms are Developed/Modified.
• Developed Oracle Forms and PL/SQL Code units as per the business requirements.
• Involved in testing of the developed Oracle Forms.
• Involved in value addition task i.e. Developed Multi excel download functionality in Advanced PL/SQL which can be invoked from Oracle Forms.

Environment: SQL, PL/SQL and Oracle Forms.