SUMMARY:

• Oracle Applications Techno Functional Consultant with 12 Years of IT experience in Software Design and Development using Oracle tools & technologies (Oracle Forms 10g/6i/4.5, Oracle Reports 10g/6i/2.5, Oracle ADF/OAF Framework, Workflow, Discoverer, RXi Reports, OBIEE, XML publisher/BI Publisher and Exposure to SOA (Service Oriented Architecture).
• Extensive experience in Oracle Applications (10.7/11.5.4/11.5.6/11.5.9/11.5.10.2, R12) E - business suite modules which include General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP),Project Accounting(PA), Grants Accounting(GMS), Cost Management, Fixed Assets, Order Management (OM), Inventory (INV), Trading Community Architecture (TCA), MRP, BOM, WIP and HRMS.
• Involved in three full cycle implementations with experience in requirements gathering, functional gap analysis, application design, configuration, conversions, module setup and test script generation, writing training guides, training end users, and Confidential .
• Analysis and business requirements gathering from business users and experience in design using MD50, MD70, CV40, CV60, TE10 documents and Application Implementation Methodology (AIM).
• Develop the Interfaces in General Ledger (GL), Account Receivable (AR), Account Payables (AP), Grants Accounting, Project Accounting (Costing, Billing, PRM, OTL), Order Management (OM), Inventory (INV), MRP and HRMS.
• Competent in understanding the functionality of core Oracle Modules (GL, AP, AR, CE, FA, PO, I-Proc, I-Exp, OM) and their interplay in the overall accounting structure of an organization.
• Diversified Project Profile in Oracle Applications Including, Implementations, Upgrades / Migrations, Production Supports, Testing Projects, Custom Solutions
• Having experience in applying of database patches and application patches.
• Experience in Installation of Oracle Applications Software in UNIX and Windows Platforms.
• Experience in Functional Design, Development and Functional Testing of Oracle Financials Modules, Reports and Customization cycles
• Programming experience in creating Functions, Procedures, Packages, Triggers and other database objects using SQL and PL/SQL. Experienced in fine-tuning code for better performance, have done performance tuning of SQL, PL/SQL applications.
• Strong experience with Onsite/Offshore Model and maintaining documentation and following the processes for maintaining CMM-5 standards.

TECHNICAL SKILLS:

Applications: Oracle Applications 10.7, 11i, R12 (General Ledger, Account Receivables, Account Payables, Oracle Grants, Project Accounting, Fixed Assets, Oracle Purchasing, iexpenses, iprocurement, Order Management, Inventory, BOM, WIP, MRP, HRMS, Strong in AOL, System Admin tasks, Oracle Alerts and Discoverer 4.0)

Operating Systems: Windows, UNIX, AIX

Language s: SQL, PL/SQL, JAVA

Databases: Oracle 8i,9i,10g,DB2

Tools: Developer 2000(Forms 6i, Reports 6i), BPEL, DISCOVERER 4i/10g, XML Publisher/BI Publisher, Workflow, Jdeveloper, Noetix

ETL: Informatica, Oracle Data Integrator (ODI)

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Techno Functional Consultant

• Worked on Module GL, AR, AP, PA and INV.
• Gathering the requirement from business for the custom Rental application.
• Implemented Vertex (US) and Oracle E-Business Tax (Canada) for Taxation.
• Worked on Vertex Clinet extensions to calculate the tax.
• Involved in up-gradation of applications from 11i to R12.
• Developed new forms using Oracle Forms and OAF for the Rental applications.
• Developed Interface to create the AR Invoice using API.
• Developed Item conversion and Vendor conversion.
• Developed New BI/XML Publisher Reports.
• Developed wrapper package for the custom web application to sync data with Oracle applications.
• Understanding the issues and providing the necessary fixes.
• Worked on Confidential issues.
• Optimize the SQL queries which are used in SSRS reports server.
• Developed MD 70, MD120, CV40 and TE20 documentation.

Confidential

Oracle Apps Techno Functional Consultant

• Worked on Module GL, AR, AP, PA, FA, PO, OM and INV.
• Implemented Oracle E-Business Tax.
• Worked extensively in Order to Cash (O2C) cycle & Procure to Pay ( Confidential ) cycle.
• Involved in up-gradation of applications from 11i to R12.
• Worked on Oracle AME (Approval Management Engine) for PO Requisition process.
• Worked on Workday application to sync data with the Oracle HRMS.
• Developed conversion programs for Items using Oracle PL/SQL and Standard APIs.
• Developed Wrapper package for Advanced Pricing to create new price list.
• Worked on Oracle AME (Approval Management Engine) for PO Requisition process.
• Worked on Workday application to sync data with the Oracle HRMS.
• Developed New BI/XML Publisher Reports. Create new OBIEE reports for GL and Project Accounting.
• Developed wrapper package for the custom web application to sync data with Oracle applications.
• Gathering the requirement from business for the custom application Asset Tracker, and Marketing.
• Understanding the issues and providing the necessary fixes.
• Worked on Confidential issues.
• Optimize the SQL queries which are used in SSRS reports server.
• Developed MD 70, MD120, CV40 and TE20 documentation.

Confidential

Oracle Apps Techno Functional Consultant

• Understanding the issues and providing the necessary fixes.
• Implemented Vertex for US for taxation.
• Confidential for Vertex Tax Issues.
• Worked on Vertex Clinet extensions to calculate the tax.
• Worked on Ariba Confidential process to integrate with Oracle applications.
• Developed API for Inbound and Outbound for Confidential Process.
• Extract the data from Ariba and creating the Invoices in AP.
• Developed GL interface for the PO Accrual process.
• Developed test scripts TE40 with test data in Order to Cash cycle - Enter Order, Schedule, Pick release, ship confirm, RMA, Auto Invoice, Receipts, Applications, GL Transfer.
• Work with super users in Setup of Order to cash process using BR100 documents. The business flows implemented were Standard Shipments; Bill only orders; Ship only Orders, RMA Orders.
• Creating New Supplier Sites for new operating unit using existing operating unit sites.
• Developed Fixed Asset detail report using eText.
• Developed custom WebADI to upload the data into the staging tables.
• Split the AR Invoice using XML Bursting and automatically send mail to the customer.
• Developed AR customer address validation process for the Vertex.
• Developed PL/SQL packages to for the inbound and outbound process.
• Developed new BI Publisher reports in FA and AP modules.
• Developed Supplier site conversions from one operating unit to another unit.
• Worked on Confidential issues.

Confidential

Oracle Apps Techno Functional Consultant

• Worked in Financials GL, AR, AP, GMS, PA, PO, INV & iexpenses.
• Providing the solution to the critical bugs in the Project Accounting and Grant Accounting.
• Involved in up-gradation of applications from 11i to R12.
• Customized the Standard Receipt Batch Form in Accounting Receivables.
• Setup the Write-Off limits in Account Receivables
• Fixing the Over invoicing issues in Oracle Projects and Grant Accounting system.
• Fixing the Funding summary mismatch issues in Oracle Grants.
• Setup AR Transaction types, Payment terms, Auto Lockbox, Automatic receipts to test receipts workbench.
• Setting up banks, bank branches and bank accounts.
• Customized the RXi report in R12 for the AR Unapplied and Unresolved Receipts Register.
• Developed BI/XML Publisher reports in R12.
• Customized the forms using the custom.pll and personalization.
• Fixing the Funding summary mismatch issues in Oracle Grants.
• Fixing the Over invoicing issues in Oracle Projects and Grant Accounting system.
• Responsible for developing Forms, Reports, PL/SQL Procedures, Triggers and Functions.
• Optimize performance and tune inefficient SQL code/queries and Reports.

Confidential

Oracle Apps Techno Functional Consultant

• Gathered functional requirements from business users for custom reports and programs.
• Worked in Financials and Supply Chain Modules GL, AR, AP, GMS, PA, PO, INV& iexpenses.
• Plans, designs and recommends business processes to improve and support business activities
• Worked on the Grants Accounting module using the GMS FUNDING PROJECTS, GMS FUNDING PATTERNS, GMS PROJECT TYPES, GMS INSTALLMENTS, GMS AWARDS ALL tables to develop interfaces between Oracle Grants and Oracle AR Module.
• Supporting the Confidential for the Oracle Projects and Grant Accounting.
• Created scripts to load Projects, Budgets and Agreements.
• Involved in transferring costs to GL and integrating Project costing with General Ledger.
• Involved in enforcing budgetary controls for project- related expense commitment transactions using oracle Project costing.
• Upload AR Receipts data into the Staging table using Oracle ADI
• Worked on ad-hoc queries and Oracle Alerts to monitor various error transactions (such as inventory adjustments, order imports, order drops, ship confirm, Purchase orders and receiving) in staging tables as well as oracle open interface tables
• Create test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated in to the system design.
• Developed test scripts TE40 with test data in Order to Cash cycle - Enter Order, Schedule, Pick release, ship confirm, RMA, Auto Invoice, Receipts, Applications, GL Transfer.
• Optimize performance and tune inefficient SQL code/queries and Reports.
• Worked on Confidential issues and providing the necessary fixes.

Confidential

Oracle Applications Technical Consultant

• Plan, design and recommend business processes to improve and support business activities.
• Analyze and documents client's business requirements and processes and communicate these requirements by constructing conceptual data and process models, including data dictionaries and volume estimates from organization.
• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Facilitate meetings with clients to gather and document requirements and explore potential solutions.
• Create test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated in to the system design.
• Assist in coordinating business analyst tasks on information technology projects and provide support to other team members.
• Develop MRP Forecast Interface using MRP FORCAST INTERFACE API for creating the Forecast Name and Forecast Designator, importing from legacy data into Oracle.
• Developed New Reports and Convert existing reports into XML Publisher / BI Publisher.
• Customization of Forms using Cutom.pll
• AR Lock Box Interface: Developed the AR Lockbox interface to interface Confidential with the receipt process
• AR Aging Report - Customized the AR Aging report for both 4 Bucket and 7 Bucket
• AR Auto Invoice - Developed the AR Auto Invoice Interface to load Invoices from Legacy into Oracle
• AR Invoice Print Report - Developed the AR Invoice Print report in XML Publisher
• Developed Interface in Oracle Projects using API’s to create the Projects.
• Interface Supplier Invoice from Oracle Payables to Oracle Projects.
• Loading the Serial numbers to the oracle tables.
• Extensively worked on custom reports using Reports 6i in Shipping Execution (WSH), Inventory (INV), Order Management (OM) and Account Receivables (AR).
• Developed Reports using Discoverer4i, Performed setups for EUL, Created business areas, Created joins, Create calculated items, Created conditions, Created new folders based on user requirements.

Confidential

Oracle Applications Technical Consultant

• Developed the inbound interface/conversion script for the Purchase Orders.
• Developed custom procedure for loading the data from the staging to interface tables with necessary validations like vendors, vendor sites, buyer, item, locations and many more.
• Developed the Custom Control file for the corresponding transmission format.
• Created Parties, Locations, Party Sites, Party Site Uses, Customers, Customer Sites, Customer Site Uses, Contacts and Contact Points using TCA API’s Hz cust Account Site V2pub,Hz Cust Account Role V2pub,Hz Contact Point pub
• Developed new reports and customized existing reports as per requirements (formatting, addition/deletion of columns, formulas etc) in GL, AP, AR and PO.
• Interacted with business to collect the requirements and developed GAP analysis documentation.
• Developed New cusotm forms and customization for forms using Custom.pll.
• Developed new reports and customizing the existing reports as per the client requirements and registered in the oracle applications.
• Followed MD50 functional documents and written the technical (MD70) specifications, provided support for end users and documented the modifications.

Confidential

Oracle Developer

• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Developed an applications system to handle all transactions using Oracle 9i (SQL * Plus, PL/SQL), Forms6i, Reports 6i on windows environment.
• Installation of oracle database in Linux.
• Provided technical solution for a small business component.
• Created database objects like Tables, Views. Packages, Procedures and Functions.
• Involved in fixing day to day issues via change requests.
• Taking the hot backups and cold backups.
• Resolving the network issues
• Query optimization and performance tuning issues related to Oracle.
• Tuning SQL using EXPLAIN PLAN, tracing at user level and TKPROF
• Used SQL * Loader to load into database from flat files. Wrote PL/SQL procedures, functions and triggers.