SUMMARY:

• 7 years of total IT experience in Oracle Applications as a Techno Functional Consultant. Involved in Implementation, Upgrade and Support Projects of Oracle Applications R12/11i, with hands on working experience on various RICEW Components (Reports, Interfaces, Conversions, Extensions and Workflow)
• Experience in Project Life Cycle including requirement gathering and Analysis, Database design, Database development, Application development, Test and Support.
• Experience on AOL objects and System Administration Activities in Oracle Applications.
• Expertise in Oracle E - Business flow in Procure to Pay (P2P), Order to Cash (O2C) flow.
• Sound experience in writing SQL/PLSQL scripts to create database objects like Tables Views, Sequences, Synonyms, Stored Procedures, Functions, Triggers and Packages.
• Implementation and Customization of Oracle Applications 11i/R12 with good Technical Development skills in developing RICE (Reports, Interfaces, Conversions, and Extensions) components in the domain of Oracle Applications E-Business Suit
• As a technical Consultant worked on Developing and Customization of Reports.
• Expertise in XML Publisher reports and e-text templates.
• Experience in Importing Information into Oracle Apps through SQL* Loader.
• Experience in Development of Outbound Interfaces using UTL FILE Packages

WORK EXPERIENCE:

Oracle Techno-Functional Lead

Confidential, Tampa, FL

Responsibilities:

• Part of a team to provide technical support of modules of Oracle Financial(P2P) like Self Service Banking (SSB), Account Payables (AP), General Ledger (GL), Purchase Orders (PO), Inventory (Inv), eBtax and Internal Tool Service Now.
• Executed full configuration of Accounts Payables in Oracle EBS, including eBtax modules.
• Organized and worked with team of people worldwide to setup EBTAX for different Operating Units across Multi-Org Structure.
• Daily Monitoring to the outbound jobs for successful completion and data posted to Legacy System.
• As a part of L2 Production Support team, investigate and provide the solution of any job failure to meet the GL cut off dates.
• Working on enhancement requests and debugging of Shell Scripts
• Writing SQL and PL-SQL from scratch for different requirements.
• Code migration through HP Kintana and PVCS.
• Point of Contact of Service now Tool, which is used to records all kind of errors, failures, enhancement as well as Change Request for Code Migration.
• Working closely with Oracle through SR to resolve standard issues.
• Communicating with different teams to fix user login issues, portal issues and java issues.
• Creating Data Fix for failure Oracle Payable jobs.
• Report Development and modifications through Oracle Discoverer, Oracle Report Builder and XML Publisher.
• In case of job Failure, Debugging the job through output and logs through Autosys Program.
• Designed/developed tables, views, various SQL queries, stored procedures, functions, packages, triggers to pull the required data.
• Focusing on technical solutions for the enhancements assigned.

Environment: Oracle EBS 12.1.3, Account Payables (AP), General Ledger (GL), Purchase Order (PO), Inventory (Inv), eBtax, Self Service Banking, Service Now, SQL, PL-SQL, XML Publisher.

Oracle EBS Technical Consultant

Confidential, Fremont, CA

Responsibilities:

• Developed complex queries, joins, inline views stored procedures and functions, packages in PLSQL for various business requirements.
• Extracting data from the database using SQL queries as per requirements.
• Developed Triggers for implementing the complex business rules.
• Provided Period end / Quarter End/ Year end closing activities.
• Participate in the entire lifecycle of the Product - design, documentation, coding, testing and deployment.
• Responsible for developing the Reports, Interfaces, Conversions and Extensions (RICE).
• Identified the customization for Standard Oracle Reports to satisfy Business requirements and modified various standard AR reports.
• Worked on performance tuning of custom programs built on PL/SQL packages and reports.
• Build complex Stored Procedures to populate millions of Data from XML Feed into tables and to transfer the data to other DB nodes.

Environment: Oracle EBS, AP, AR, Oracle 9i PL/SQL, MYSQL, SQL, LINUX, TOAD, SQL * Loader, XML Publisher.

Oracle Techno-Functional Consultant

Confidential

Responsibilities:

• Gathering the requirements from the business users on regular meetings and converted the MOM'S to design documents. Understand the functional specification and technical aspects of the project.
• Worked on Configuration of Modules (AP, AR, INV, GL) and coordinating between offshore and Onsite.
• Developed Outbound interface to extract open Invoices and Customer data from AR tables to Flat file using the UTL FILE.
• Developed different types of Value sets for various concurrent programs as per the requirement.
• Defined new value set of special validation type based on the KFF and added it to the DFF.
• Worked on SQL*Loader Scripts to create the receipts data from the flat files and populate the staging tables using API.
• Developed framework to generate the XML reports using SQL, PL/SQL, existing packages, procedures and Views. These reports are used for customers and invoice data.
• Developed Concurrent Programs as part of that created Request Group to run the XML report.
• Developed standard file format (SFF) to export Customer and Open AR Transactions to CSV files.
• Modified database objects based on project needs to update the factor flag on which transactions are factored fully or partially.
• Responsible for developing the Reports, Interfaces, Conversions and Extensions (RICE).
• Defined Invoicing information including Payment Terms, Invoicing, accounting rules, Territories and Invoice Sources.
• Designed and developed AP Invoice Open Interface for different sources in Oracle Payables (AP).
• Worked on Order Import Interface program to load Order Information from legacy system to base tables.
• Build Creation and Source control through PVCS Version Manager.
• Writing custom packages using API's to develop the interface Programs.
• Worked on exception handling for the ease of debugging, displaying the error messages in the calling application and stores the logs in auditing table.
• Performed Unit Testing for Outbound Interface and deployed to UAT and then to PROD.
• Assists Business users for new implementations and Initiatives for testing and Design, Created Use cases, Test Cases, Test Scripts, Test Plans and uploaded to the Quality Center and ran manual testing for Implementation on each release.

Environment: Oracle EBS - R12.1.3 - INV, OM, AR, AP, Oracle 11g, SQL, PL/SQL, Oracle Forms, Oracle Reports, Oracle Workflow, XML/BI Publisher.

Confidential

Oracle Techno-Functional Consultant

Responsibilities:

• Worked on the concept of Form Personalization and made the changes in Oracle standard forms as per the client requirement.
• Techno-functional Analyst for oracle EBS Procure to Pay (P2P) modules
• Requirements gathering, Gap Analysis, functional testing, conducting CRPs, UAT and training of Procure to Pay solution for marketing department. This involves Requisition, PO, Release and AP Processes.
• It also involves custom processes for prior month accrual, negative accruals
• Designing and leading the development of Purchase Document Open Interface for Standard POs.
• Oracle purchasing previously allowed Blankets and Catalogs to be imported using open interface.
• I extended this feature to allow import of Standard Purchase Order.
• Once the customer creates a PO, the vendor could immediately see the PO online using PO acknowledgement and acknowledge it online
• Supporting and Enhancing Requisition approval Workflow
• Supporting and Enhancing PO Approval workflow
• Developed new Oracle reports of AR, Inventory, AP, and PO along with the customization in the standard oracle reports.
• Performed requirement gathering for RICE components for AR, AP modules.
• Prepared the test documents for AR interfaces for Oracle Audit.
• Participated in doing the setups for AR, Inventory module.
• Partially involved in the setups of AR, AP and Inventory and presented the demo to the client.
• Prepared the documents for all customized objects like reports, forms and interfaces etc.
• Developed and tested for conversions and enhancements in PO, INV modules.
• Created value sets for various components in the modules of GL, AP, AR, PA, and PO.
• Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development.
• Implemented conversions scripts and developed Install Scripts for Code Movement.
• Done Sanity Testing after the code movement in Production Instance.
• Defining concurrent programs, executable, forms, request set, values set.
• Responsible for writing UNIX Shell scripts for automating tasks like FTP, Migration automation.
• Worked on personalizing the Oracle Application through Form Personalization and Custom.pll.

Environment: Oracle Applications 11.5.10 Financials (AP, FA, PO, P2P, AP, CM), Supply chain Modules (INV, PO), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports).