Summary

• Expertise in analysis of Problem severity, Defect tracking and Defects reporting system.
• Strong experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• In depth knowledge of software development life cycle SDLC .
• Strong experience in Reports, Interfaces, Conversions and Extensions R.I.C.E object development.
• Involved in implementing versions/upgrades of Oracle Applications 11i, and recently involved in implementing Oracle Applications R12 for Oracle Business.
• Software Professional with more than 8 years of total IT experience.
• Diversified technical expertise on Oracle Applications 11i, with extensive exposure in development of custom interfaces, Conversions, APIs, building control interfaces, dealing with Application Object Library AOL , customizing forms, reports and workflows.
• Expertise in Technical and Functional aspects of Oracle Applications 11i Financial, Supply chain, Order to cash and Manufacturing Modules which include Order Management OM , BOM, General Ledger GL , Service contracts, Accounts payable AP , Account Receivables AR , Inventory INV , Pricing QP , Shipping WSH , Purchasing PO , iProcurement, iExpenses, iReceivables, Fixed Assets FA , EDI, AOL, Oracle E Business Suite logistics.
• Have hands on experience in Oracle Release 12 Financial Modules and Order Management.
• Strong knowledge of the two Supply Chain Management SCM cycles, order to cash OTC and procure to pay P2P business flows.
• Support and maintain Oracle E-BUSINESS 11i CRM applications and good understanding of EB Tax module.
• Had an experience over Oracle Incentive Compensation OIC , in order to connect sales incentives to business objectives to motivate workers.
• On a day-to-day basis, acted as the leading point of contact with the client, understanding their needs and building the initial architecture/project according to the requirement using the Oracle E-BUSINESS 11i Trading Community Architecture TCA oracle CRM 11.5.8 .
• Registering of Custom Applications/Tables/Schema in Oracle Applications.
• Developed reports using Reports6i, Discoverer 9i/10g and XML Publisher.
• Developed forms using Forms 6i and also involved in Forms Personalization.
• Capable of Performance Tuning, Optimizing SQL and PL/SQL scripts.
• Used File Transfer Protocol FTP program to transfer a file from client machine to server machine and vice versa, when working on different operating systems.
• Creation of concurrent programs to execute requests viz. reports, stored procedures and shell script.
• Used third party software's like TOAD, PUTTY and WINSCP3.
• Extensive experience in writing Oracle backend objects like: Database Triggers, Stored Procedures, functions and Packages using PL/SQL.
• Involved in design of AIM Application implementation Methodology documents CV-40, CV-60, MD-50, MD-70, MD-120 for all conversion and interfaces and also completing BP080, BR100.
• Wrote Test Cases, Prepared Test Plans, did unit and integration testing.
• Also performed unit testing for different PL/SQL packages.
• Ability to provide work estimates and meet deadlines.
• Ability to adapt to a changing environment can work in diverse team environment.

Technical Experience

Professional Experience

Confidential Oracle Apps consultant

Responsibilities:

• Worked on PO forms and PO Requisition Forms Personalization.
• Independently personalized Oracle PO and PO REQ forms based on the GL budget amount and Purchase Order Amount.
• Was successful in moving the personalization to the production environment using ftp.
• Written the PLSQL Function for the Forms Personalization purpose.
• Was successful in calling all the parameters required for the personalization using the Function.
• Performed an all-round testing over the Function written and the PO forms by taking in a sample set of data for various departments and organizations.
• Presently working on Oracle XML reports for the faxing purpose, in order to send the report to the FAX number from the application itself using RICOH and using the XML Bursting Control File.
• Developed a XML/BI Publisher template for printing the AP Checks. Added logic for displaying Signature Images dynamically based on the Check Amount.
• Completed the XML Report for Request for Quote including the MD.070 and started designing the RFT template for Purchase Orders.
• Customized XML/BI Publisher reports for Oracle Purchasing.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.
• Created PDF/EXCEL output's for reports based on requirements
• Used Data Templates for generating the XML data.
• Developed XML template for invoice report using XML/BI Publisher
• Created output format in XML, new templates for XML/BI Publisher to display the reports in client requirement format.
• Worked on creating workflows with various Notifications, messages as per the client requirement.
• Worked on creating Workflow Events with XML Payload and performed WORKFLOW CUSTOMIZATIONS.

Environment: Oracle Apps 11.5.10, Oracle 9i PLSQL, Oracle Forms 6i and Oracle XML/BI Publisher 5.6.3 , Workflow 2.6.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked as a Technical consultant.
• Worked over Oracle Applications 11i financial modules.
• Initially worked on migrating data from COUPA to GL Interface and generate General Journal Entries.
• Used SQL Loader to populate the interface tables using the data from COUPA.
• Worked with project manager to confirm business requirements.
• Have been into discussion with business and indentified questions to be resolved.
• Create entries in originating entity and in receiving entity for AP intercompany cross-charges re-bill to receiving entity
• Create transfer price journal entries for management fees, cost-plus fees, etc.
• Generated these Journal Entries based on the currency codes such as to generate two journal entry lines for functional currency code USD and three entries for NON USD functional currencies.
• Given two different successful logics for generating journal entries for the originating and receiving entities based on the currency codes and the Intercompany segment values.
• Worked on cross charges for billing the receiving entities and generate transfer price journals based on the exchange rates of the receiving entities functional currency.
• Populated the AP Interface tables using the GL journal Entries already generated.
• Worked over the Tax rules for different entities and on the new VAT regulations of the year 2010 for entities in EUROPE.
• Create intercompany invoice in PDF format to be emailed to receiving entity Utilized PL/SQL developer tool in developing all back end database interfaces.
• Worked over with Oracle Cash Management API's, Auto Reconciliation and performed Oracle Cash Management Statement Level Validations.
• Worked on Transferring funds between internal bank accounts using Oracle Cash Management.
• Worked on complete process of loading electronic bank statements for Oracle Cash Management.
• Worked on responsible for performing code reviews.
• Worked in Oracle Cursor, Exception Handling, Collections like Nested tables and VARRAYS.
• Created database scheduler scripts and applications using Unix shell scripts, SQL Plus script
• Maintained performance tuning by using SQL-Related Performance Tools like EXPLAIN PLAN, SQL Trace and TKPROF, Indexes and Clusters etc.
• Have written PLSQL packages for GL journal import and AP Invoice Interface.
• Generated Intercompany Invoices from AP Invoice Open Interface.
• Performed Unit Testing and Performance Tuning over the PLSQL code and check for the validations in unit testing.
• Define test requirements and strategy.
• Performed PLSQL Performance Tuning on the code by verifying the time taken to run the code and have done few enhancements on the code in order to reduce the time taken to run the code.
• Worked over design and development of Business Requirement Document BRD .
• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 Functional Spec and then writing MD70 Technical Spec .
• Utilized Oracle's Application Implementation Method AIM approach, and documented the process using the recommended AIM documentation
• Prepared Mapping document and Design document for the Migration.

Environment: Oracle Applications 11i General Ledger, Cash Management and Accounts Payable , Oracle 9i SQL and PLSQL, PLSQL stored procedures, views, SQL Loader and various test environments.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in the design and technical development of Print Purchase Order Reports and Invoice reports using XML Publisher according to the client requirement.
• Have done mapping 11.5.10 reports to R12 XML templates, writing Extent and Validation rules, plugging Validation and extends to Payment Process.
• Assigned all the PL/SQL packages to Apps and ran the imports in order to populate the base tables.
• Created PL/SQL packages and performed various validations in them according to the client requirement.
• Created sql loader scripts to load the data from the legacy system to the staging tables.
• Have done the data mapping from the legacy system to the oracle system to perform the GL balance conversion and the customer conversion.
• AR Customer Outbound.
• Item outbound Interfaces.
• AR Invoice Import from One Operating Unit to another Operating Unit ESBS
• Customer PO Defaulting Rules
• Customer Item X-reference Conversion
• AR-Customer Load Using TCA API's.
• Working in the development team responsible for the following technical components of
• Performed various tasks in Customer conversion and mainly used API's for this conversion.
• Created Customer Profile at customer site level using HZ PARTIES PROFILE V2PUB API.
• Worked on Trading Community Architecture TCA for the AR Customer conversion.
• Involved in complete GL Balance Conversion, GL-AR balancing process journal entries , and maintaining the GL sync with AR.
• Involved in the UNIX shell script program in order to assign the responsibility and application for the developed control file.
• Developed interfaces to load the GL Data into GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using journal import concurrent program.
• Involved in Design and Development of Outlook soft to GL, BNA Journal to GL interface and various GL Objects.
• Imported data from Legacy system Mainframe to Account Receivables tables using SQL Loader and validated them using PL/SQL Procedures.
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables AR .
• Imported the data from legacy systems into the temporary tables in Account Receivables AR .
• Involved in entering the invoices, approving invoices and then GL transfer for Oracle Accounts Payables.
• Created new Invoices in AP for the Procure to pay process.
• Expertise on working with Payables open interface tables.
• Have extensively worked on Oracle Account Payables Open Interface and AP Invoice Interface for Oracle R12.
• Prepared Mapping document and Design document for the Migration.
• Utilized Oracle's Application Implementation Method AIM approach, and documented the process using the recommended AIM documentation
• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 Functional Spec and then writing MD70 Technical Spec .
• Involved in Design and development of AR Customer Conversion, GL Conversion, and GL Interfaces Budget and Actual
• Involved in developing interfaces, conversions and reports as a part of R.I.C.E objects development and development required for implementation of P2P process.
• Extensively performed conversions and interfaces on financial modules for upgrade to Oracle R12.
• Have worked over Technical Aspects of oracle R12.
• Developed AR Invoice Print Report on Pre-printed Stationery and AP Check Printing Report Using XML Publisher according to the Client Requirement.
• Recreate existing legacy report using Oracle XML Publisher.
• Created updated and closed several TAR s to solve issues related to XML Publisher.
• Worked on Production issues and gave 24 x 7 production support which also included training the end users on performed validations and reports.

Environment: Oracle applications 12i AP, AR, GL, Concurrent program, Request sets and Value sets , Oracle XML Publisher, PL/SQL store procedures, views, indexes, UNIX Shell Script, SQL LOADER.

Confidential

Oracle Apps Financials Techno functional Consultant

Responsibilities:

• Worked as a Techno Functional consultant.
• Working on the Oracle e-Businesses Suite R12 ERP Implementation.
• Involved in developing interfaces and conversions as a part of R.I.C.E objects development.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables.
• Performed Extensive Application tuning for Order to Cash Business process.
• Involved in design of architecture for supply chain management entities such as customer, vendor and Item.
• Performed Cost accounting for supply chain transactions for oracle cash management.
• Have completely involved in functional design and implementation two supply chain management cycles Procure to Pay P2P cycle and Order to Cash OTC cycle.
• Used Oracle iExpenses to manage procurement and card transactions.
• Select and verify transactions using Oracle iExpenses.
• Working on the implementation of Oracle Applications R12, Involved outbound and interfaces design and testing.
• Performed data and requirements gathering for Oracle iProcurement and purchasing modules.
• Have performed the Payables Open Interface Import program and Payables Invoice Import program.
• Also involved in implementing Purchase Document Open Interface with E-business Suite and integrated with Oracle Purchasing.
• Defining Invoice attributes like Payment Terms, Tax Codes, Approval Codes, and Distribution Sets.
• Developed AR Invoice Print Report on Pre-printed Stationery and AP Check Printing Report Using XML Publisher according to the Client Requirement.
• Customized the AR Aging 4 Buckets 7 Buckets - By Account Report to meet Client requirements Using XML Publisher.
• Worked over GL, AP reconciliation payments, entering and applying prepayments.
• Creating the Concurrent Programs Executables, Defining the Concurrent Programs, Request Sets, and Request Groups using FNDLOAD in multiple environments.
• Involved in shipping process of OM which involved pick confirm ship confirm using MSCA.
• Exclusively worked on Assemble to Order/Pick to Order ATO/PTO models.

Forms Reports:

• Check Validate, Rename, Recompile and Test existing customizations like custom forms, custom reports, and concurrent programs host, sql loader, sql plus, PL/SQL in Oracle 11i.
• Built the report using Reports Builder 6i and integrated it with the application based on the descriptive flex fields to solve the client's reporting needs.
• Built custom forms using Oracle Forms 6i Builder to fulfill the business requirements of the client.
• Worked on upgrading the existing Oracle Forms 4.5 to Oracle 6i.
• Customized existing forms to add search criteria on descriptive flex fields
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Proficient with the System administrator responsibility, which included customizing menus, adding new concurrent requests, request sets, registering the automation scripts as concurrent programs and created scheduling process that invokes the script periodically.
• Worked with performance tuning tools like Explain Plan to improve the performance of various custom PL/SQL packages developed.
• Performed unit and integration testing, maintenance for the projects.
• Revised Application Extension MD070s using AIM methodology by reviewing MD050s and interacted with onsite functional team to build technical extensions.
• Built the report using Reports Builder 6i and integrated it with the application based on the descriptive flex fields to solve the client's reporting needs.

Environment: Oracle applications R12 Accounts Payables, Accounts receivables, Order Management, iExpenses concurrent programs along with request sets and value sets , Developer 2000, SQL PLUS, SQL LOADER, Workflow builder 2.6.4.

Confidential

Oracle apps Implementation -

Responsibilities:

• Involved in identifying the impacted items in Oracle Applications version 11.5.10.
• Worked as a Oracle PL/SQL developer and involved in writing complex SQL queries.
• Developed OM queries to Count open orders per Header Hold name and Line Hold name, Count closed and cancelled Orders/RMAs per Order type/ reason code, Count Number of cancelled Orders/RMA lines.
• Developed OM queries for sum of total dollar value of Open Line Amount on open Orders, Open Line Amount on open RMAs in Dollars, Open Shippable Line Amount on open Orders/RMAs and closed Orders/RMAs.
• Troubleshooting of the Order Management OM/ONT , and Inventory INV modules within Oracle Applications.
• Imported customer data using customer conversion program into AR.
• Developed Auto lock Box AR interface program.

• Customized various transactions in Accounts Receivables like Invoices, Receipts, and Credit Memos and Debit Memos etc.
• Customized various transactions in Accounts Receivables
• Worked on major Conversions like Item Conversion, BOM Conversion, AR Customer Conversion and Pricing Conversion.
• Developed SQL Loader script to convert the euro direct bank statements data to meet the data requirements of Auto Lockbox interface tables.
• Customized to modify PO Approval Hierarchy and Notification.
• Developed new forms in PO module to show the all Purchase order details for a particular Vendor.
• Modified PO Requisition Approval Workflow to support custom routing process in accordance with business requirements.
• Customized the PO Approval report in purchasing module as per the users requirements.
• Customized Sales order form in Order Management.
• Developed Custom Pick release program based on shipment Priorities.
• Developed the validation program to validate the data that gets inserted into Order Entry Interface Tables before running the Standard Order Import Program.
• Involved in carrying over the Customizations and Extensions done on the Oracle reports, Oracle forms and PL/SQL programs using Oracle Apps version 11.5.8 to 11.5.10.
• Developed PL/SQL procedures, functions and packages.
• Created host programs using UNIX shell scripting for remote database access and ftp of files to the supplier site database.
• Developed several forms using Forms 6i in OM and PO modules.
• Customization of Discoverer reports 10g/4i.
• Experience in customization of XML Publisher reports like Purchase Order report, Custom Printed Blanket Release, Blanket Release report for Oracle Purchasing.
• Performed the unit test cases for all the identified impacted items and documenting the same for user acceptance test.
• Participated in the functional validation of the fresh oracle reports developed as a part of the up-gradation.

Environment: Oracle Application Release 11.5.10.2 AR, Order Management, Purchase Order , PL/SQL, Oracle Forms 6i, Discoverer, SQL loader and Toad.