OBJECTIVE

• Seeking a career position as a consultant in Oracle E - Business Suite environment 11i/R12 involving Implementations/upgrade/support where I can be a part of the positive change using my ERP Skills.

SUMMARY

• Having around 8+ years of IT experience in Oracle Applications (11i and R12) and complete SDLC (gathering Business Requirements, Analysis, Design, Implementation and Testing) cycle.
• Hands-on experience in Application Implementation Methodology AIM and Application Object Library AOL .
• Expertise in developing the Technical Specification & Module Design Documents.
• Extensive experience in Application Developer and System Administrator responsibilities.
• Involved in R12 end to end implementation and upgradation cycles.
• Hands on experience in Production Support Environment.
• Responsible for implementation and support using Oracle ERP applications including SCM modules like Order Management, Inventory, Purchasing and financial modules like Accounts Receivable, TCA(Trading Community Architecture) Accounts Payable, Fixed Assets and General Ledger also on Service Contract, Installed Base, Advance Pricing and Quoting.
• Good understanding of Organizational Structure.
• Extensively worked on Oracle ERP modules like GL, CM, AP, AR, FA, INV, OM, PO, QP, Shipping, I-Procurement, I-Receivables, I-suppliers, Oracle PIM and AOL.
• Hands-on experience on Oracle CRM (Service Contracts, Field Service).
• Worked on tools like Developer (OA Framework Pages, Forms, and Reports), Discoverer & XML Publisher.
• Hands on Experience on AR Auto Lock box and Auto Reconciliation process.
• Strong Programming experience in developing Packages, Procedures, Functions, Cursors, Views, database triggers, interfaces and other database objects using PL/SQL and SQL*PLUS
• Proficient in writing & tuning complex SQL statements.
• Extensive experience in customization of forms using Custom.pll forms Personalization, customization of reports, defining concurrent programs, defining value sets, defining profile options, and functional setups.
• Good working knowledge of RICE components (Reports, Interfaces, Conversions, Extensions) which involves working on Reports 6i/10g and SQL, PL/SQL packages and functions.
• Expertise on designing and implementing Oracle Alerts.
• Expertise on developing Oracle Forms 6i/10g and OA Framework.
• Developed Inbound and Outbound Interfaces.
• Experience working in Corporate Finance, Federal Finance, Telecom, and Health domains.
• Performed Unit testing, Integration testing & User Acceptance testing of the Applications.
• Developed the Documentation Process of the application with end-user training.
• Strong Production Support experience in Order-2-Cash, Procure-2-Pay, Drop Ship and Finance Processes.
• Experience with performance tuning, query optimizations.
• Well equipped with UNIX shell scripting & UNIX commands.
• Excellent all round team player with good interactive skills.
• Well experienced in Multi-Org and Multi-Currency implementations.
• Good understanding of TCA data model and APIs.
• Flexible to learn advancements in the IT industry and deliver the goods.
• Accurately estimating and meeting the time-lines in delivering the objects.
• Ability to understand the requirements and delegating it to the technical team members.
• Ability to learn and implement the setups needed for any module.
• Good at understanding the business requirements and providing technical inputs to the technical team.

TECHNICAL SKILLS

ERP: Oracle Applications EBS 9i, 11i 11.5.10,11.5.8, R12 12.1.3

Databases: Oracle Database 8i, 9i, 11g

Languages: SQL, PL/SQL, Java, HTML, XML, C, C++

ERP Processes: Order-2-Cash (O2C), Procure-2-Pay (P2P), Finance

Oracle Modules: General Ledger, Payables, Receivables, Cash Management, Fixed Assets, Federal Administration, Inventory, Order Management, OPM, Oracle CRM, Advanced Pricing, Purchase Order, Shipping and AOL

Self-Service Modules: i Procurement

Tools: Developer 2000, Discoverer, XML Publisher, RDF reportsForms Builder, workflow Builder

Development Tools: TOAD, SQL*Plus, SQL*Developer

Operating System: Windows NT, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Dallas/Fort Worth, TX

Oracle Apps Technical Consultant

Responsibilities:

• Working in DFW as an Oracle Applications Technical Consultant.
• Converted RDF reports to XML reports.
• Developed DFW AR custom Report to show contact list which are existing in oracle by choosing self-service role to give the access to i receivables module.
• Customized D/FW AP Trail balance report.
• Customized several AP reports according to user specifications.
• Personalized the supplier’s bank details page and invoice work bench page as per user requirements.
• Developed XML Reports, OA Framework pages, Custom Forms and Workflows in different modules.
• Worked on GL custom reports migrated from 11i in R12.
• Worked on D/FW Printed Requisitions report after migrating from 11i to R12.
• Developed D/FW Payables Open Interface Import Custom report from Payables Open Interface Import.
• Involved in production support for fixing the issues in AP, AR, GL.
• Developed a custom workflow to notify PO change information to the users.
• Developed process to communicate between external application and the CRM via API.
• Developed a custom workflow to notify Credit/Debit Information to the users.
• Created CRM Training/Desktop Documentation and Integrated Test Scripts.
• Worked on AR Auto Lock box and Auto Reconciliation.
• Worked on D/FW Printed Requisitions Report.
• Upgraded from 11i to R12.
• Worked on Request for payment(RP)

Environment: Oracle EBS R12(12.1.3), Oracle Apps 11.5.10, Procure-2-Pay, Oracle Forms 6i, 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, TOAD, SQL*Developer, Java APIs, UNIX, Shell Scripting, WINDOWS XP.

Confidential, North Wales, PA

Oracle Apps Technical Consultant

Responsibilities:

• Working in Confidential as an Oracle Applications Technical Consultant.
• Developed AR Customer License Form for the customer service department to insert and update the customer license information.
• Developed AR Customer License XML Report to send Emails to the Customers whose License is about to expire using XML Bursting.
• Developed EDMS form in OPM Module which allows user to enter plant code and batch number related data.
• Developed few Custom Forms in AP.
• Activating descriptive flex fields to capture additional information for the client not available in standard Oracle forms, set up Suppliers and Banks for AP use.
• Converted RDF reports to XML reports.
• Developed Oracle Workflows for customer License Database and involved in production support.
• Developed Custom AR Transaction Form along with the mapping form.
• Developed AR Conversions Process from the legacy systems to Oracle Apps using BPEL.
• Designed & developed the Inbound and Outbound Interface Programs to do settlements and other business requirements in Oracle ERP from other Database services.
• Developed Confidential AP Rebate Approval Form (OA Framework) pages and worked on some customizations.
• Developed Customer License OA Framework page to add the excluded list of customers in to the custom table.
• Trained super-users on CRM application functionality.
• Developed several XML Reports, OA Framework pages, Custom Forms and Workflows in different modules.
• Developed a GL Outbound interface programs to extract data in to Blackline database located in Canada.
• Designed & developed Database components specific to Services & Product like Tables, Materialized Views, Procedures, Indexes, Grants and PL/SQL Packages.
• Developed CRM business requirements.
• Customized and Implemented CRM.
• Personalized the standard and custom forms.
• Worked on Oracle Alerts to send Email, based on some changes in the custom table.
• Registered Forms, Reports, PL/SQL Packages, and UNIX Shell Scripting with AOL with parameters & incompatibilities.
• Wrote Control Files for SQL Loading to facilitate uploading of data from legacy system to the new system.
• Thoroughly Unit tested all the developed technical objects.
• Properly documented all the developed objects with MD0.50, MD0.70 and BP0.70 using Application Implementation Methodology (AIM).
• Designed the Technical Document Specification (TDS) for Service Items module and Product related module.
• Designed & developed the One-time data migration scripts.

Environment: Oracle Apps Financials EBS R12(12.1.1), 11.5.10, GL, AR, FA, AP, CE, Oracle 11g, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, Discoverer 10g, UNIX Shell Scripting, Java APIs, TOAD, SQL*Developer

Confidential, Boca Raton, FL

Oracle Apps Technical Consultant

Responsibilities:

• Working in ADT implementation project as an Oracle Applications Technical Consultant.
• Designed & Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Developed Custom claim form in Trade Management Module.
• Designing & developing of the GL Balances Outbound interfaces end-to-end and exporting the files to Mainframes, Hyperion, and other downstream consumption using FTP and UNIX Shell Scripting.
• Developed Custom PL/SQL packages and procedures. Used advanced PL/SQL concepts like Objects, Bulk collect etc.
• Involved actively inupgradation project from 11i to R12 and some of the duties involved changingall the database objects from11ito make them compatible to the schema changes inR12.
• Developing GL Balances Out bound interfaces and integration with Mainframes and other downstream systems is the major component of the first release of the current implementation.
• Developed Packages and a custom API for applying and releasing Holds using Oracle API
• Understanding the current UNIX & SQL scripts in Oracle Apps 11i and developing R.I.C.E components in Oracle EBS R12.
• Performed unit testing and involved in the functional testing of the applications.
• Working on implementing Oracle Workflows for upcoming requirements in the project.
• Worked on the Auto Lockbox in receivables that automatically creates receipts using the electronic information that the bank provides.
• Developed XML Reports, OA Framework pages, Custom Forms and Workflows in different modules.
• Proven ability in creation and customization complex Workflows involving email notifications, HTML reports etc. using Oracle Workflow.
• Worked on interface to import sales order data in to Order Management Module.
• Worked on gathering the requirement from the user, preparing the Scope and Requirement Document, Functional Document, Technical Design Document, Oracle Setup Document and Production Change Control Document.

Environment: Oracle EBS R12(12.1.1), Oracle Apps 11.5.10, Procure-2-Pay, Oracle Forms 6i,10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, TOAD, SQL*Developer, UNIX, Shell Scripting, WINDOWS XP.

Confidential, Phoenix, OH

Oracle Apps Technical Consultant

Responsibilities:

• Working in Confidential as an Oracle Technical Consultant.
• Involved in R12 end to end implementation and upgrade cycles.
• Designed the Technical Specification Document (TSD) for Service Items module and Product related module.
• Involved Implementation and production support to Oracle Accounts Receivables (AR), Accounts Payable (AP), Purchasing (PO), Fixed Assets (FA) and Inventory (INV) modules.
• Created custom values sets, menus, and responsibilities as a part of R12 Upgrade from 11.5.10.
• Created MD70 documents, shell and fnd load scripts, built new workflows to replenish or supplement the upgraded functionality in R12.
• Worked on debugging OM Workflow. Worked with Orders whose workflow got stuck and researched them to release.
• Defined set of book with Currency and calendar in GL
• Defined operating units and profile options in GL.
• Wrote Control Files for SQL Loading to facilitate uploading of data from legacy system to the new system.
• Worked on Auto Invoice Interface, to import data with all validations. The logic was written based on the invoice type like Credit Memo, Debit Memo, Invoice etc. and the Line Type like line, Tax, Freight etc.
• Designed & developed database components specific to Services & Product like Tables, Materialized Views, Procedures, Indexes, Grants and PL/SQL Packages.
• Designed & developed the One-time data migration scripts with the transformation logic to load the data from upstream systems to Item Hub.
• Involved in achieving various custom functionalities like defaulting DFF values, resetting Need By Date Value etc. by personalization in I Procurement as per user requirements
• Designed & developed customized form to allow users to enter and update item information.
• Designed & developed the custom interface program to create and update an item in Item Hub with database validations, which will be consumed by front-end Java application.
• Developed Custom Forms and XML Reports
• Designed and developed custom reports which will fetch the Service Items and the History of the Service Items and will be consumed by front-end Java application.
• Performed data analysis of various systems to validate the One-time data migration.
• Performed the Unit Testing of the components developed.
• Registered the developed components in Oracle Application Object Library (AOL) as Concurrent Programs.
• As part of the Development team Interacting with various teams in the project like functional, QA, upstream & down-stream applications.
• Interacting with various cross-functional and off-shore teams on a daily basis.

Environment: Oracle EBS 12.0.4/12.1.1 , 11.5.10, Oracle 10g, Oracle Inventory, Oracle Reports, Oracle AIM, Oracle SQL, Oracle PL/SQL, Windows XP, TOADSQL*Developer

Confidential, Ashburn, VA

Oracle Apps Technical Consultant

Responsibilities:

• Worked in Confidential project as a Technical Consultant.
• Designed and developed various RICE components in R12 and 11i.
• Designed and developed a Form from end-to-end which corrects the Suspense Entries and sends for the Journal Import in GL module.
• Developed Extracts in GL and FA modules and the extracted files are FTPied to other systems using the UNIX Shell Script.
• Developed AR Invoice Report with Print facility in Reports 10g.
• Designed and Developed end-to-end Bank Statement Interface in Cash Management module.
• Developed AR Customer Conversion Process from the legacy systems to Oracle Apps.
• Developed various Shell Scripting Programs for FTPing files to others systems, exporting files into GE libraries and Email program.
• Designed and developed a process for GE Treasury which involves extracting the data and applying business rules and report creating and exporting reports to GE Libraries using Java APIs.
• Developed custom edits to notify the user about the faulty data based on different business rules.
• Worked in Data Analysis of various systems to compare data and the data flow of the complete system.
• Migrated and developed legacy system objects into Oracle Apps EBS R12.
• Designed and developed various technical components like SQL, PL/SQL, Procedures, Functions, DFF’s, Value Sets, views, and materialized views.
• Registered all the developed components in AOL with parameters and incompatibilities.
• Documented all the above-mentioned processes with BP070 and MD070 using AIM methodology.
• Unit tested all the development objects and also tested for different scenarios.
• Worked on ad-hoc reporting on Discoverer with the extracted data in FA and GL.
• Maintained high standards of coding and involved in fine tuning the applications throughout the implementation.

Environment: Oracle Apps Financials EBS R12, 11.5.10, GL, AR, FA, AP, CE, Oracle 10g, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, Discoverer 10g, UNIX Shell Scripting, Java APIs, TOAD, SQL*Developer

Confidential, Walnut Creek, CA

Oracle Technical Consultant

Responsibilities:

• Worked with the implementation team for the development of various technical components in PO, AP, QP and AR
• Developed Interfaces, Conversions, Reports using SQL, PL/SQL Packages, Procedures, Functions, SQL*LOADER.
• Defined expense report template required to generate expense reports for employees in Oracle Payables.
• Customized the standard Cross Order Volume Report in Oracle Advanced Pricing (QP) module.
• Performed Modifiers related setups in Oracle Advanced Pricing (QP) module for maintaining the discounts & surcharges of items.
• Developed a Pricing Formula in Oracle Advanced Pricing (QP) module to dynamically update the pricing of items.
• Developed interface to load Receivables invoices from external system, contract base to Oracle using Auto Invoice Concurrent Programs.
• Personalized few forms to restrict users from entering journals or doing wrong transactions based on certain criteria in GL & QP modules.
• Maintained the GL INTERFACE table data from different Journal Sources on a daily basis for the Journal Import.
• Designed and developed Auto Lock Box interface in Oracle Receivables using proper validation and loaded the data.
• Customized Standard Oracle Reports and built custom reports using Oracle Report builder and integrated them with the application to solve the client’s reporting needs as per Business Requirements.
• Worked on oracle alerts and developed alerts to send mail notification to employees for settlement of advances in Oracle Payables.
• Registration of Program: Registered Reports, SQL*LOADER, PL/SQL Packages, UNIX Shell Script with Oracle AOL.
• Defined Value Sets, Concurrent Executable, Concurrent Program, Request sets and attached in Request Group.
• Performed SQL tuning activities to enhance the performance of customized PL/SQL programs.
• Worked on UNIX Scripts & Commands for reporting needs.
• Designed and developed various custom packages, procedures and functions in PL/SQL.
• Involved in creation of views for various processes.
• Prepared design documents (MD0.50) and technical documents (MD0.70) for all the customizations.
• Developed various documents to track change request using AIM methodology.

Environment: Oracle EBS 11.5.9, Order-2-Cash, INV, OM, PO, AR, AP, GL, QP, Oracle 9i, Forms 6i, Reports 9i, SQL, PL/SQL, Oracle Alerts, TOAD, SQL*Developer, XML Publisher, Discoverer, Windows 2003, UNIX

Confidential, Solano County, CA

Oracle Apps Technical Consultant

Responsibilities:

• Worked as an Oracle Applications Technical consultant and was a part of six member development team.
• Interacted with users, performed requirement analysis and prepared technical design documents.
• Extensively developed the R.I.C.E components in the major financial modules like GL, AP, AR and Oracle Federal Administration (FV) module.
• Developed Purchase Order variance report using Oracle Discoverer.
• Designed and developed the Extracts of GL Balances by department, cost center, accounts and legal entity and then generated the reports using UTL FILE Package and FTP’ied the files to legacy systems.
• Designed and developed end-to-end Budget Execution Open Interface in Oracle Federal Financial (FV) module.
• Developed the Funds Available - Available Balances Report with various customizations in Oracle Federal Financial (FV) module.
• Developed email notification to the users using Oracle Alerts in Oracle Payables.
• Analyzed data of various systems to compare data and the data flow of the complete system.
• Developed ad-hoc & interactive reports using Discoverer.
• Developed various technical objects like Tables, Views, SQL*Loader, Packages, Procedures, Functions, Sequences, Synonyms and Materialized View for different processes.
• Personalized few forms to restrict users from entering journals or doing wrong transactions based on certain criteria.
• Registered Forms, Reports, PL/SQL Packages, and UNIX Shell Scripting with AOL with parameters & incompatibilities.
• Thoroughly Unit tested all the developed technical objects.
• Properly documented all the developed objects with MD0.50, MD0.70 and BP0.70 using Application Implementation Methodology (AIM).
• Provided technical support during integration testing, quick fixed code bugs.
• Worked on some additional requirements from onsite to reduce the time gap of the similar development effort from the offshore team.

Environment: Oracle EBS 9i, GL, FV, AR, AP, PO, Oracle 9i, Forms 6i, Reports 6i, Discoverer, Oracle Alerts, SQL, PL/SQL, SQL*Loader, TOAD, Windows 2003.