SUMMARY:

• Over 10 years of Professional experience on Oracle Applications as a Techno - Functional consultant, focused on Implementation, Upgrade and Support of Oracle Financials, Oracle Manufacturing, and Oracle Supply Chain modules.
• Experience in all phases of the Software development life cycle (SDLC) in an ERP environment.
• Good Experience in Oracle Financials and supply chain modules like GL(General Ledger), AP(Accounts Payable), AR(Accounts Receivable), FA(Fixed Asset), CM(Cash Management), PO(Purchase Order), OM(Order Management), INV(Inventory), WIP(Work in Progress), BOM(Bills of Material), Install Base, Service Contracts, iExpenses, iProcurement and AOL(Application Object Library).
• Strong implementation knowledge of O2C(Order to Cash), P2P(Procure to Pay) and Drop Ship end to end Cycles.
• Extensive experience in designing, developing and testing the RICE components (Reports, Interfaces, Conversions, Extensions) as per Oracle Standards.
• Extensive experience in design, development, customization and implementation of various business applications in different platforms using Client-Server Technologies.
• Extensive knowledge and expertise in using various Oracle technologies to effectively implement an end-to-end solution to an organization's strategic goals and objectives including: Oracle 11i E -Business Suite, Oracle Discoverer, Oracle Application Server and Oracle PL/SQL and SQL and Oracle RDBMS , Oracle Developer (Oracle Forms and Reports Developer)
• Expert in developing programs using SQL*loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Experience in development of concurrent programs, customization and modifications of repots.
• Excellent skills in Analysis and business requirements gathering from end users to the client and experience in design using MD50, MD70 documents.
• Knowledge and Experience of TCA (Trading Community Architecture).
• Expert in developing custom reports in XML Publisher.
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Experienced in Database Design, Data Modeling, Migration, and Systems Architecture, Planning.
• Demonstrated ability to identify root causes/ debugging of problems and troubleshoot, considering both long and short-term impact of proposed solutions and developed workable solutions
• Onsitecoordination experience and work with the offshore team to knowledge transfer and development support.
• Excellent technical background for the accurate evaluation of customization efforts. Strong business, analytical and technical problem solving skills.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite 12i/ 11.5.10/11.0.3.

Modules: Order Management (OM), Inventory(INV), Bill Of Materials(BOM), Account Receivables(AR),Purchase Order(PO),Fixed Assets(FA), Account Payables(AP),General Ledger(GL),Application Object Library(AOL), Flex fields, TCA, CRM, Service Contracts, Service Fields, SYSADMIN, INSTALLBASE

Tools: Toad, SQL * Loader, PL/SQL Developer, Discoverer, Data LoaderBI/XML Publisher, Load Runner.

GUI: Developer 6i,Developer 2000,Forms 6i/10g, Reports 6i/10g.

Programming Languages: SQL & PL/SQL, FORTRAN, JAVA, JavaScript, HTML5, PHP.

Database: Oracle 8i/9i/10g, SQL Server 2000, MS Access, Sybase.

Operating Systems: Windows 98,2000,NT,XP,7, Unix(Solaris, HP-UX),Linux.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Design & development of reports and Forms for Financial modules
• Designing, building, testing and deploying various Oracle solutions.
• Worked mainly on Financial modules AP, AR, GL, FA, PO .
• Created Workbooks based on the Custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop.
• Responsible of business requirements gathering and post production support for the expenses cycle (PO, INV, AP, GL).
• Set-up the system to meet the desired business process and requirements
• Define and design the mapping of the business processes applying the best practices to use Oracle Financials.
• Customize business areas and custom folders using discoverer administrator and customize and create new reports
• Develop testing scenarios, test scripts and leading teams in unit, integration and acceptance testing
• Functional requirements analysis and documentation
• Coordinate technical issues or questions
• Perform Federal Financials reconciliation and reporting
• Validate that the required daily production reconciliation reports such as system, application and financial integrity are being produced and reviews.
• Business Requirements Mapping for General Ledger, Accounts Receivable and Accounts Payable modules.
• Responsible for the compilation, prioritization and solution of users’ requirements.
• Design technical and functional documents like MD65, MD70, MD120 and BR100 .
• Design of documents and guides for new users of Oracle Financials R11i (GL, AP, AR, FA, PO)
• Study of current business processes, future business flows and identification of gaps and workaround.
• Accomplishment of functional business tests during the data migration

Environment: Oracle Applications 11i, AR, AP, GL, PO, FA, Oracle, Forms, Reports, Discoverer, PL/SQL, Toad 8.5, Workflow, JDeveloper.

Confidential, Dearborn, MI

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Provided solution with delete reservations in Oracle Order Management (OM)
• Worked on the XML reports like Pick slip report, Packing slip report, Sales Order Acknowledgement report, Invoice reports, quotation reports, Purchase Order reports and Discoverer reports to make sure they are upgraded from 11 to R12 and displaying the same output as in 11.
• Replaced the RA customer view with AR customer when the PO Close Process has been upgraded to R12.
• Involved in the Order management -Landed Costing Custom module-Inventory-Account Payable and Purchase-Landed Costing Custom Module-inventory-Account Payable.
• Key user Training for the landed Costing custom Module and Integration with Oracle Purchase, Inventory, Order Management and Account payable.
• Import Work Orders from various legacy systems to Oracle Enterprise Asset Management and Oracle Order Management (OM) system.
• Extract program for Open orders information (Requisitions, Purchase orders, Internal Sales orders, Move orders information which are not materialized) and corresponding stock amounts program, which shows the costing information for those open orders in Purchasing (PO) and Order Management (OM).
• Import Program from the Servigistics data file, which create Requisitions , Purchase orders in Oracle Purchasing (PO) and order import program in Oracle Order Management (OM).
• Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow.
• Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 6i and XML Publisher.
• Converted Fixed Assets Data from Legacy System to Mass Additions Table using SQL Loader and developed programs for Conversion of Tax Data from flat Files to Tax Interface Tables.
• Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
• Customized the Print Purchase Order Report based upon user requirements and added bitmap image of company logo to the report.
• Customized the following workflows: PO Approval Workflow: Implemented notification reminder and Timeout needs for the PO Approval workflow,PO Account Generator Workflow
• Worked closely with the team responsible for Setups and Customization of self service modules like iProcurements, iExpenses, iPayment, iReceivables, Modified XSL, JSP, XML files for additional functionality and GUI enhancement.
• Updated MD50, MD70 and MD120 documents according to the R12.

Environment: Oracle Applications R12 12.1.3, 10.2 (AR, AP, GL, PO, FA, iProcurement), Solaris, Oracle, Forms, Reports, Discoverer, PL/SQL, SQL* Loader, Toad 8.5, Workflow, JDeveloper.

Confidential, NY

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Responsible for requirements gathering and definition, conversion of business requirements into technical specifications, technical project plans, overseeing the development work etc.
• Developed SQL scripts to create temporary tables and SQL*Loader control files to load the item legacy data into the temporary tables.
• Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Created and modified PL/SQL API for creation of assets retirement and Mass additions in interface table in FA module
• Imported new, changed and completed sales orders from legacy system to oracle using order import (order management open interface).
• Implementation and Customization of MODULES AP, AR & GL, FA in Multi - Org environment.
• Developed AP Invoice interface to load data from legacy system to AP interface tables.
• Designing and development of custom interfaces on the Oracle AR and Oracle AP.
• Designed and developed reports to handle multi-currency exchange gain and losses.
• Imported Open Payables Invoices from legacy system into Oracle AP using Ap Invoices Interface and Ap Invoice Lines Interface tables.
• Worked on the Budget Upload Open Interface to load the data from legacy systems to the GL Budget Interface table using SQL*Loader.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables
• Created new custom reports in XML/BI Publisher
• Used Template, sub Template method for a creating single report with multiple Layouts
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level
• Developed Business Areas, Custom folders, Item classes, Hierarchies in Discoverer Administration Edition
• Created Workbooks based on the Custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and DiscovererDesktop.
• Involved in Performance tuning of the discoverer reports.
• Modified and created new concurrent programs as well as executable files when new reports were created.
• Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Development/modification of custom reports in purchasing and payables
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.
• Designing the Functional Document MD-50 for the landed Costing Custom Module and interface with Inventory, Purchase, Order Management, Account Payable and Landed Costing Report as per AIM methodology .
• Designing and coordinating all data conversion development/testing tasks (for IB instances withCounters, Warranties, Service Agreements, and Service Contracts with Charges) and customdevelopment items (e.g., Field Service Debrief customizations to facilitate data flow to ordermanagement (OM) and cost tracking).
• Techno-functional troubleshooting of the Shipping Execution (WSH), Order Management (OM/ONT), and Inventory (INV) modules within Oracle Applications. Working on issues related to pick release, pick confirm, deliveries, reservations (hard, soft, ATP), backorders (B/O), interfacing to 3rd party warehouse /packaging systems (ALS and FedEx), and ship confirmations (WSH, ONT, INV). Methodological identification of issues starting from order initiation to ship confirmation and closing of order line. Analysis of all scenarios/paths an order line can go through, and issues that may occur during the full lifecycle of an order. Changes in configuration to Shipping, OM, and INV setups as needed to address issues, improveperformance, and ensure proper flow of data to 3rd party systems.
• Preparation of technical and Solution Design document for the offshore developer.

Environment: Oracle Applications R12/11.5.10, Reports 6i/10g, SQL, PL/SQL of Oracle 9i/10g,PL/SQL on UNIX, Windows 2000/NT environment, Forms 6i/10g, Discoverer10g, XML/BI Publisher, Toad, SQL * Loader.

Confidential, TX

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Understanding the Existing and Legacy system
• Worked with the functional team while extracting non-Oracle data and Converting to Oracle with validations.
• Work with functional setups to create AP invoice sources, Accounting flex field, Chart of accounts.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, Credit Memos and Debit Memos etc.
• Designed and developed Journal Import interface to import journals from legacy system.
• Have Good understanding of Reconciling, Period Close Processes, Global Accounting Engine, Billing and pricing Engine across various Modules.
• Extensively work with the RICE components
• Worked with the GL Journal Import, AP Invoices, AR Invoices, Item conversions
• Worked with functional team to prepare the chart of accounts cross-reference data to load the chart of accounts, Journals data and Invoices data.
• Used the System Administrator responsibility to create users, responsibilities, Value Sets and Request Sets.
• Driven requirement gathering sessions and provide functional assistance to business users for Quick Service
• Developed SQL*Loaders control programs to load the data from Legacy data to the Temporary table
• Developed PL/SQL Programs to validate data and insert into the interface tables. Then used standard import programs to load the data from interface tables to base tables.
• Extensively used Discoverer administrator and Discoverer desktop versions.
• Developed and customized business areas and custom folders using discoverer administrator and customized and created new reports using Desktop.
• Generated ad-hoc reports in end user layer.
• Extensively worked with the analysis and documentation R12 future upgradation using R12 vision database.
• Analyze and provide documentation of the new table structure in R12, schemas, reports and XML publisher modifiable formats in financials.
• Working with creating snapshots for Open Orders Data, Purchase Orders, Forecasting, Inventory Measures and Item Master and developed Concurrent Programs and PL/Procedures to refresh those snapshots and sending email to the owners about the status.
• Involved in Developed Advanced Shipment Notice (ASN) process and printing.
• Designed and Developed the Commission payments project, which loads the all rep groups and percentages information to the custom tables.
• Developed new and customized existing Oracle and Discoverer reports as per the user request.
• Involved in testing existing FSG reports.
• Developed AIM Documentations for the components.
• Involved in Peer review and Unit testing.
• Involved in resolving daily business issues in Quick time.

Environment: Oracle APPS 11.5.10, R12, Oracle 9i/10g, Reports 6i/10g, Discoverer 9x, 10g, PL/SQL, Shell Script, Accounts Payables, Accounts Receivables. General Ledger, Purchasing Order, Fixed Assets, Cash Management, Inventory, Order Management

Confidential, Charlotte, NC

Oracle Applications Technical consultant

Responsibilities:

• Actively involved in full implementation of E-business suit including gathering the requirements from the user and understanding their business model.
• Worked on various financial modules (AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables).
• Worked in getting the requirements from the users and involved in functional setups in financial modules.
• Defined the descriptive flex fields on Sales orders and Invoices to facilitate additional information.
• Support the users when loading AP Invoice and other payment activities like printing payment registers and checks.
• Develop AP/AR/GL/PO reports using discoverer which include the following PO requisition reports, AR sales profit report with cost of goods, GL Summary Report.
• Customized seeded reports as per the requirement like Customized the standard Purchase Requisition Status report in purchasing and scheduled payment report.
• Created new reports and Customized standard reports in PO such as Expected Receipts Report, Printed Requisitions Report and Purchase Order Detail Report.
• Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM .
• Involved in generation of FSG reports according to the client requirement and consolidated automated financial statements using Financial Statement Generator (FSG).
• Involved in writing interface program to load the data from external systems into Oracle purchasing (PO) interface tables.
• Developed AP Invoice Conversion and vendors conversion programs.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Customized the PO entry form to ensure Revision field is not null when item is entered.
• Defined request sets with concurrent programs to run in stages depending on the output generated by each request.
• Developed Interfaces for OracleApplications modules, XML Publisher, Oracle Discoverer, OA Frame work etc in co-ordination with the functional consultants.
• Worked on items in Inventory.
• Imported Bills and Routings through BOM Interfaces .
• Developed Work Order Interface to import discrete job information into oracle apps base tables.
• Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
• Developed custom workflows for tracking service requests, and notifying users about the status of these service requests.
• Developed custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report etc.

Environment: Oracle Applications 11i, GL, AR, AP, PO, Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts.

Confidential

Oracle Applications Technical consultant

Responsibilities:

• Designed & Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Involved in the requirement gathering, analysis and design of the interfaces and reports.
• Responsible for creation of MD070s for AP Invoice import.
• Developed new Custom Oracle 6i, SQL, PL/SQL Reports as per the business requirement.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Purchasing and Payables and Fixed Assets Module.
• Developed custom forms and reports to correct interface errors and send the error messages to legacy system owners.
• Using SQL*Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Involved in the development of TCA (Trading Community Architecture) Model .
• Developed a custom layout XML format according to the user specifications and worked on incorporating it to the standard print Purchase Order and Invoice reports using XML Publisher (BI Publisher).
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Developed custom reports: Sub Ledger Accounting Report and New Account Code Combination Report using XML Publisher.
• DevelopedCustomer License Form to save the Customer’s License information.
• Involved in migrating developed objects between instances.
• Developed custom shell scripts to create synonyms and grant necessary permissions for the objects which are being migrated into new instances.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL by populating GL Interface Table.
• Developed PO outbound interface to get the flat files from Base Tables.
• Developed Customerconversions Program and upload the data into Customer base tables.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).

Environment: Oracle Apps 11.5.8, Procure-2-Pay, Oracle 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, AR, OM, INV, TCA, TOAD, Discoverer, XML Publisher, SQL*Developer, Forms(6i), UNIX, Shell Scripting, WINDOWS XP.

Confidential

Oracle Applications Technical consultant

Responsibilities:

• Design & development of reports and Forms for various modules of Oracle Apps
• Preparation of documentation such as MD050/MD070 for Customizations
• Involved in Data migration.
• Write Interfaces for Oracle Applications modules, XML Publisher, Oracle Discoverer, OA Frame work etc in co-ordination with the functional consultants.
• Worked on technical developments as a part of Oracle Applications implementation covering the technical design, documentation and development, etc.
• Managing custom application development projects, customization and extension of Oracle Applications. PLSQL, Workflow, Forms and (Java, JSP, XML) & OA Framework are an added advantage.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Develop Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
• Create and define template and data definitions for OpenPurchase Order report . Conditionally display company logo information based on run time parameters.
• Worked on the entire life cycle of the project starting from Requirements Gathering, Analysis, Design, Development, System Testing and Production support
• Involved in the complete Order to Cash, Procure to pay cycle, Oracle Grants and Projects implementation.
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.
• Implemented Order Management Workflow extension for RMA Finance approvals for various financial validations which Carnival requires during Order to Cash process.
• Seeded OM Workflows are copied and customized.
• RMA Approval workflow notification for Sales Order will be triggered at the launch of Sales Order “Book” event.
• RMA amount was set up in a value set on Operating Unit Level.
• Developed the custom programs for the below conversions.
• OM Item Substitution Conversion
• Developed RMA Receipt Report using Reports 10g.
• Reviewed Business requirements, IT Design documents and prepared Technical Design Documents for this release.
• Responsible for Process setup.
• Extensively involved in designing the project and coordinating a highly professional team.

Environment: Oracle EBS 11.5.10.2 (OM, INV, PO, AR, AP), Workflow Builder, Reports 10g, PL/SQL Developer, SQL*Plus, TOAD, PL/SQL, SQL*Loader.