SUMMARY

• Around 8+ years of diversified experience as an Oracle Apps (EBS) Consultant in the Analysis, Design, Development, Implementation, Customization and Supporting of Oracle Applications in Ecommerce Business to Consumer (B2C), Assemble to Order (ATO), Procure to Pay (P2P), Order to Cash (O2C), and Projects to Invoice (P2I) Cycle’s Using Multi - Org concepts having good experience in various stages of Software Development Life Cycle Process (SDLC) and its deliverables in ERP Sector.
• Strong background in development and customization of RICEW objects in ORACLE General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Purchasing (PO), Oracle Projects (PA), Service Contracts (OKS) and Advanced Collections Modules.
• Good knowledge and Hands-on experience with project costing and Interfacing costing with AP and HR Modules.
• Involved in requirements gathering workshops, prepared as-is (BP-040), To-Be (BP080), GAP analysis, setups (BR-100), Functional design (MD050), Technical Design (MD070) documents using AIM methodology.
• Expertise in design and development of Interface/Conversion programs for Enterprise level integration of legacy systems into Oracle Applications using open interfaces and APIs.
• Good knowledge in development of Business Processes, Custom interfaces, APIs, building control files, dealing with Application Object Library (AOL), reports and workflows.
• Extensive exposure in working with Import, Validate and Post QuickCash using AR Autolockbox functionality.
• Experienced in dealing with concepts of Revenue Management and Revenue Recognition like, COGS, Earned Revenue, Unearned revenue and Revenue adjustments.
• Experienced in Development Customization, Personalization and Registration of Oracle forms6i/9i/10g/11g, Discoverer 9i/10g and XML Publisher.
• Capable of Optimizing SQL and PL/SQL scripts and creation of concurrent programs to execute requests, reports, stored procedures and UNIX shell scripts.
• Extensive experience in Oracle backend objects like: Database Tables, Views, Indexes, Triggers, Stored Procedures, Functions, and Packages.
• Strong understanding on underlying data structures in Financial Modules and good knowledge on Application Object Library (AOL).
• Ability to utilize the Project methodologies, good understanding on Business terminology, quickly adaptable to new environments and innovative technologies.
• Good team player having excellent interpersonal, presentation, oral and written communication skills.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications (E-Business Suite), E-Biz, R12/11i (PO, AP, AR, GL, OM, HR, PA Inventory).

RDBMS: Oracle (11g/10g, 9i), MS Access.

Tools: Developer Suite (Reports10g/9i/6i), Discoverer 4i/10g, XML Publisher, Work-flow Builder, OAF, and TOAD (10.6.0 & 12.0.0).

Operating Systems: Unix, Windows XP, Windows NT

Languages: SQL, PL/SQL, UNIX, Confidential and Confidential ++

Web Tools: HTML, MS Front page

Other Tools: MS Office, HP Quality Centre, Secure shell.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle Techno-Functional Analyst

Responsibilities:

• Worked on Ecommerce application in the Business to Consumer (B2C) flow for order fulfilment in ATO cycle.
• Worked closely with Business users for inputs on Order orchestration from external data sources to design order import program.
• Have done set-ups for Pricelists and added items to the pricelists for different locales.
• Worked on setting up the Approved suppliers, Sourcing rule assignments and GBPA’s for the ATO models.
• Worked on New product integrations for product releases like Moto G and Moto Z droid and validated the test readiness to carry out the SIT.
• Worked on supporting the test cycles by debugging the issues and making code changes if any required towards the resolution.
• Worked on validating the prod readiness for the release of new products and sent reports to the PMO regarding the readiness of environment from Oracle R12.
• Developed an interface to pull the active sales items details into a staging for sending the price feed details into the front end systems.
• Developed PL/SQL packages and registered the concurrent program for the development of interfaces.
• Supported the release of multiple NPI’s and supported the transition of shipment warehouse as part of Lenovo integration.
• Performed the Unit testing for all the developed Interfaces, conversions and Extensions.
• Mocked and prepared the data to cover all the scenarios in Unit-testing.
• Worked on monitoring the jobs in production, fixed and reported the issues if any for smooth flow of orders towards customer fulfilment.

Environment: Oracle Applications R12.1.3 (E-Business Suite), OM, PO, BOM, Advanced Pricing, INV, AR, PL/SQL, Putty, Reports 10g, UNIX, SQL Developer, SVN, JIRA .

Confidential, Keene, NH

Oracle Techno-functional Consultant

Responsibilities:

• Worked closely with Functional Team to get the required inputs on MD-50's and involved in design review sessions.
• Extensively worked on improving the performance of form, intended to display the item details for cost layers.
• Worked on extending the pre-processing of data for the AR invoices before submitting the Auto-invoice import.
• Designed and developed a custom logic for the billing number and billing date generation during pre-processing of AR invoices.
• Worked on designing and developing a custom credits interface to process the Credits to AR as Credit Invoices.
• Designed and Developed the Open Invoice Conversion programs for Payables (AP) and receivables (AR).
• Extensively worked on designing an extension Program for loading the gross-profit tables for internal reporting.
• Worked on developing a loading program for loading the Inventory item details to a custom staging, where active sales items are staged.
• Designed and developed an Interface to do pre-processing of PO reclamation invoices and importing them to Payables (AP).
• Developed PL/SQL packages and registered the concurrent programs, value-sets and request sets.
• Experience in writing the dynamic SQL to enable more flexibility for functional owners to have control over the data being processed.
• Designed an extension to generate delinquent invoices for the customer delinquent charges calculation process.
• Performed the Unit testing for all the developed Interfaces, conversions and Extensions.
• Mocked and prepared the data to cover all the scenarios in Unit-testing.
• Provided professional analysis on requirement gathering in business process description utilizing Oracle AIM 3.0 for HR, Payroll.

Environment: Oracle Applications R12.1.3 (E-Business Suite), AP, AR, GL, PL/SQL, Secure shell, Reports 10g, UNIX, TOAD 11.5.0, SVN, STAT 5.7.2.

Confidential, Sunnyvale, CA

Oracle techno-functional Consultant

Responsibilities:

• Gathering the requirements from Business users and Functional team and involved in business review sessions.
• Provided professional analysis on requirement gathering in business process description utilizing Oracle AIM 3.0 for HR, Payroll.
• Wrote functional (MD050) specifications, provided recommendations for user challenges and designed process and system modifications using AIM approach.
• Worked as Business Analyst with the Payroll team and developed functional specifications on interfaces to and from Oracle HRMS/Payroll to other third party systems.
• Have developed a PL/SQL packages, procedures and functions using cursors, sub queries and table types.
• Designed and developed a custom interface program to Auto-adjust Employee compensation details interfacing Payroll and Projects as part of costing Interface.
• Extensively worked on HR and Payroll tables to retrieve data to update the Project compensation details of permanent and contingent workers.
• Written PL/SQL packages for custom API to adjust the employee cost rate for Project Costing process.
• Have worked on standard Oracle API's like PA EVENT PUB to create a program using the custom validations to load the billing events into base tables.
• Worked on customizing the PA CLIENT EXTN OUTPUT TAX API to generate the tax code on draft invoices in Project Invoicing configured in EB Tax.
• Converted the tax rates from legacy Vertex tax engine to mapped EB Tax Engine for 11i to R12 conversion.
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs.
• Generated .FMX from .FMB’s and registered the forms in the required responsibility Menu’s.
• Worked on customizing the GL Journal Approval workflow to add attachments to the Workflow Notifications.
• Extensively worked on creating the Project events for Project billing and developed a custom program to update SHIP TO at top task level.
• Performed the Unit-testing and also the system integration testing in test instances to present the results in Conference room pilot.
• Worked on customizing the fixed assets Account Generator workflow to generate the new PCC’s as part of R12 (EBS) re-implementation.

Environment: Oracle Applications 11.5.10.0.2 , R12 (E-Business Suite),PA, AR, GL, EB Tax, Vertex, PL/SQL, Secure shell, Reports 10g, UNIX, TOAD, SVN.

Confidential, Chicago, IL

Oracle Apps techno-functional Consultant

Responsibilities:

• Gathering the requirements from Business users and involved in business review sessions.
• Prepared BR-100's and MD-50's for the user requirements that are recorded during the business review sessions.
• Prepared the data extract lay-out for legacy systems and also developed the field level validation document to capture the attribute level business validations.
• DevelopedInterface of Sales Orders Import in OMafter actively participating in the preparation of the conversion mapping documents.
• Performed data-validations by writing PL-SQL package into theOrder Import (OE) headersandline interface tablesand then toOEbase tables.
• Developed table scripts for custom tables, synonyms, indices, sequences and other database objects required for the AR conversion.
• Used Vertex API's for sales Tax calculations during the invoicing process.
• Extensively worked on EB Tax and Vertex API's for tax calculations on Open invoices.
• Extensively worked on AR interface tables like RA INTERFACE LINES ALL and RA INTERFACE DISTRIBUTIONS ALL to stage the data before the auto-invoice picks the data for loading.
• Have worked on standard Oracle API's like AR INVOICE API PUB and AR RECEIPT API PUB to load the invoices and receipts information respectively.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications.
• Used 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.
• Consolidated the Invoices based on the customer, item and transaction date to reduce the invoice count and thereby reducing the load for API and auto-invoice.
• Extensively worked on tuning the performance of the conversion program by using DBMS PROFILER and gathering the stats and adding the hints to fine tune the performance of PL/SQL package.
• Improved the performance of the concurrent program by balancing the load and number of threads being spawned by concurrent program.
• Documented the CV-60 for AR Conversion program and reviewed the technical specifications with the tech lead and all the team members.

Environment: Oracle Applications 11.5.10.0.2 , AR GL, PL/SQL, Secure shell, Office 365, Reports 10g, UNIX, TOAD, SVN.

Confidential, San Jose, CA

Oracle Apps technical Consultant

Responsibilities:

• Understanding the existing documentation and documenting the changes for the re-design.
• Interacted with Business users to get required inputs on design changes as part of the WebEx order integration.
• Involved in code review sessions and TFSD walk through sessions to understand the existing complex revenue application.
• Worked on the design review sessions and documented the changes for the existing batch jobs to process and transfer revenue data to GL.
• Worked on a code changes for applying holds on the AR invoice data as part of WebEx integration.
• Provided solution forRevenue Recognitionrequirements by developing extensions.
• Extensively worked on reporting the business impact due to development effort and communicated them with Business team on timely basis.
• Worked on an application for linked OM orders and AR invoices to leverage the revenue management application.
• Made changes to the existing PL/SQL code to provide user to link multiple deals to NGCCRM specific profiles.
• Developed PL/SQL Procedures for Validations of OM Sales order data. And populated the data into base tables.
• Extensively worked on linking profiles and sales orders and deals to test the functionality of the application.
• Worked on testing the inherited hierarchy of the deferrals on the OM data at sales order level.
• End-to-end testing of the application with variable user inputs and wide scenarios to ensure the changes reflected at all levels.
• Communicated with the offshore on daily basis on task allocation and resource sharing for the modules assigned.

Environment: Oracle Applications (EBS) R12, O2C,OM, AR GL, PL/SQL, Secure shell, HP Quality Centre ALM, Reports 10g, UNIX, TOAD, PVCS, Kintana.

Confidential, Milwaukee, WI

Oracle Enterprise Programmer Analyst/R12 Support

Responsibilities:

• Analyzing and understanding the user requirements and moving forward on priority solutions for key stakeholders.
• Meet and discuss with Business analysts to determine the business and functional impact of the issues.
• Extensively worked on AP, AR, PO and GL modules to develop and change the PO customized reports, AP Work-flow alerts and AR Interfaces.
• Released holds usingOE ORDER PUB APIand adjusted line adjustments.
• Worked on customizing the AR custom interface for OB10 process,which moves the AR invoices from MCW to Department of Veteran Affairs.
• Creating new Value-sets and updating look-ups as per the Business/user requirements and making changes to code ensuring expected end-user results.
• Worked on customization of Sys Admin reports using people tables to get the security audit details for contingent workers along with employees.
• Query optimization and performance tuning of Alert queries, report queries, PL/SQL procedures and Interfaces using Oracle hints and reduced the run-time in production.
• Created MD-120’s for all the change requests (CR’s) that I have worked and sent for reviews to confirm right time for migration occurrence.

Environment: Oracle Applications (EBS) R12, P2P, Purchasing, AP, AR, HR and GL, AP Workflow Alerts, XML Publisher, Reports 10g, UNIX, TOAD, SSH SFTP, SSH Secure Shell, Star-team Cross Platform Client-2006

Confidential, Warren, NJ

Oracle Apps Technical Analyst

Responsibilities:

• Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
• Developed and customized Financial Modules Interacted with end users to gather requirements and Draft specifications for development Phase.
• Written an API for Converting the Invoice Payments(AP) and was able to convert all the Historical Invoice Payment History into Production.
• Registered customized Oracle reports and BI/XML Publisher reports using System Administrator and Application Developer.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
• Strong Oracle RICE development experience in all AP, AR, FA, GL, PO and OM Modules.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
• Utilized Forms Personalization utility to call a PLSQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data.
• Experience in System Administration activities like Managing Concurrent Programs and Responsibilities.
• Setting upmulti-Currency processing, revaluations and consolidations in General Ledger module.

Environment: Oracle Applications R12/11i - AP, AR, Purchasing, GL, FA, Cash Management, OM, INV, Work Flow, OA Framework, Forms 9i, Reports 9i, Discoverer 4.1/9.0.2, XML publisher, UNIX, TOAD.

Confidential, Arlington, VA

Oracle Apps System Analyst

Responsibilities:

• Implementation of Oracle Receivables including setup of system options, payment terms, transaction types, transaction sources, auto accounting, banks, receipt methods, receipt classes, tax codes.
• Defined the custom lookup values in AOL & project accounting and assigned dependent value sets.
• Involved in complete cycle testing of process flow and reconciliation of revenue data received from external system and transferred to ALE and posted to GL
• Participated in user testing, helped in migration to production.
• Providing production support of Oracle financials, including following

Environment: OracleApplications11.5.10.2(PA,AR,GL,AP,PO),Oracle,10g(SQL,PL/SQL),TOAD.

Confidential, San Diego, CA

Application Analyst/Developer

Responsibilities:

• Customized release sale order Standard form through form personalization, to meet the requirements of user as they wanted to release the sale order by predefined rules and so the ‘based on rule’ field is made mandatory in the form and whenever end user tries to enter anything without selecting a rule in the field custom message is generated to choose the rule in the field which is made mandatory.
• Imported and validate transaction data from other financial systems and create Invoices, debit memos, credit memos in Oracle receivables via the Oracle Auto Invoice open interface
• Resolving all kinds of technical issues spanning from OE, INV, AP, AR, and GL.
• Involved in business process analysis, design, planning, implementation, user testing coordination and acceptance related to project implementations.
• Involved in the Technical Design for Interfaces.
• Interface directly with business system teams and end-users.
• Performance tuning of oracle programs.
• Data extractions from Oracle to give the information to data warehousing data mart.
• Worked in PL/SQL, Forms, Reports and UNIX Shell Scripting

Environment: Oracle Applications 11i (11.5.10.2), Oracle 10g, GL, AP, Purchasing, AR, INV, OM, Workflow Administrator, Forms9i and Reports9i, Discoverer 10g, UNIX, PLSQL Developer.

Confidential

Oracle Developer

Responsibilities:

• Coordinated with the business users to collect requirements.
• Prepared requirement specification document that gives the comprehensive details about the requirements worked on logical and physical data modeling.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data-mart.
• Participated in System test case preparation and execution.
• Prepared unit test cases and executed the same.
• Worked on tuning the SQL Queries for better performance.
• Performance tuning: Partitioning the fact tables and materialized views to enhance the performance.
• Developed Reports to extract the monthly sales information.
• Customized and developed Reports and Forms using Forms 6i and Reports 6i.

Environment: Oracle, SQL, PL/SQL, Developer/2000 (Forms 4.5, Reports 2.5), UNIX and Windows NT.