SUMMARY

• Setting up and support of Oracle Applications R12,11i&11.5.4: Financial Modules (Accounts Receivable - AR, Accounts Payable-AP, General Ledger-GL, Fixed Assets-FA)/Distribution Modules (Purchasing-PO, Inventory-INV, Order Management - OM, Shipping-WMS)/CRM (Services, Install Base)/ HRMS (HR, Payroll & OTL) - Responsible for AIM documentations, setups, bugs, enhancement requests, escalations
• Develop As-Is Process Flow Diagrams, Presentation Slides, Functional Specifications (BR.100), Technical (MD50&MD70) - Custom Extensions and Interfaces, CV40 - Data Conversion Mapping Documents, TE040 System Test Script, End User Training Manuals, Unit Test Scripts.
• Creation of Data Conversion script. Developing Interface programs, Custom forms, Custom reports, and Functionality customization. Design the interfaces to integrate between Oracle Applications and external systems, Used Application Desktop Integrator (ADI), Financial Analyzer (OFA) and Financial Statement Generator (FSG) to develop various custom financial reports and integrate with ADI to pull the reports in custom company format.
• Worked within Manufacturing and Distribution - defined inventory org, custom inventory item templates, inventory items, BOM, routing, resources, departments and related costs - performed end to end unit testing from Procurement to Inventory Setup to Discrete Manufacturing to Sales Order to Shipment to Invoicing to Collections to Reconciliation(Payment Clearing).
• Excellent working experience within Customer Data Hub & TCA (Trading Community Architecture) model/Multi Org architecture in 11i & R12
• Excellent experience using Oracle On Demand development tools such as SQL(Complex Analytical Query writing skills), PL/SQL(Packages, Procedures, Functions, Triggers, Complex Data Conversion Scripts) and Oracle Reports, Oracle Forms and Custom PLL,XML Publisher, Application Desktop Integrator (ADI), Workflow, Financial Statement Generator (FSG)
• Good Experience working with 3rd party tools such as Secure CRT, Secure FX, PL/SQL Developer, TOAD, SQL Navigator, SQL Developer, Perforce & PVCS (Source Control), etc.
• Experience with relational and dimensional logical and physical database design, query optimization, performance tuning, advanced PL/SQL and SDLC
• Design datamarts and extraction process for terabytes of data through ETL tools such as OWB, PL/SQL, TOAD, etc. to map Oracle Apps/3rd party legacy systems such as Sales force.com, 3rd party freight data etc. for Business Intelligence reporting through Business Objects & Cognos V8.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior Oracle Apps SCM Techno Functional

Responsibilities

• Conduct Business Requirement Analysis, Business Review, Escalations & Acceptance Meetings.
• Responsible for creating Process Flows, Presentation Slides, Change Requests, User Training Manuals, AIM Methodology Functional/Technical Design Documentation of various custom RICE components: Reports, Interfaces, Extensions & Conversions.
• Provide Hands-On User Training & Support, Debugging, Validation, & Unit Testing of various RICE components.
• Support Oracle EBS-R12 Financial Modules (GL. AR, AP & PO) Upgrade; Custom Reports Development (Purchase Order/AP&AR Invoices/E-text Templates for Cheques & Remittance Advice), Log Oracle SR for Bugs & Enhancements Requests (mainly AP/Payables), Ad-hoc Reporting Needs (Queries & Scripts), & Bug Fixes (Custom Views, Forms, Reports Issues) using SQL\PL/SQL\TOAD\Oracle Forms & Reports (10g)\XML/BI Publisher
• Development of data conversion scripts using SQL*Loader, SQL, PL/SQL, API/Open Interfaces, Unix Shell; for conversion of master data: products/items, vendors, customers, open purchase orders, open sales orders, & Demantra/Demand Planning namely sales history and promotions data from legacy system MBDS (Mainframes/IBM).
• Design, development and support of complex business extensions such as Load Build, Special Pricing, Sales Order Pricing Extension, What-if Analysis, etc. using Oracle Forms (6i/10g)/Custom PLL & Forms Personalization/ API & Open Interfaces
• Build custom order line flows to support custom business process flows using Workflow Builder
• Build custom interfaces using PL\SQL/API/Open Interfaces for various Inbound and Outbound processes like WMS Inbound/Outbound Interfaces, Payables Invoices EDI Interfaces, Demantra Inbound Interfaces, etc.
• Build custom reports for satisfy the business supply chain reporting requirements using Oracle Reports (6i)/XML\BI Publisher
• System Administration Setups: Define System Profile Options, Profile Assignments at Site, Responsibility and User level, Key Flex Fields (KFF), Descriptive Flex Fields (DFF) - Define Segments, Value Sets, Hierarchies & Security Validations, Request Sets, Concurrent Programs, Executables, and Responsibilities & Users.

Confidential, San Diego, CA

Senior Oracle Apps SCM Functional

Responsibilities:

• Responsible for Business Analysis, Functional Design, Configuration, AIM Documentation, Support, Oracle Tar logging, Code Walk Through, Validation of Data from 3rd Party System using TIBCO Middle-ware Integration, Off-Shore Functional & Technical Team Support & QA test defects debugging & fixes.
• Responsibilities as functional consultant for Order2Cash (OM, TCA, INV &AR) Modules, Procure2Pay (PO, AP, INV), Finance (GL) &
• Manage 3rd Party Integration Extension - Empowered POS, TIBCO, etc.
• Work with the MDM Team by providing product categories, product template & customer information for Master Data Management. Help validate product data once interfaced through PIM into Oracle Apps Inventory Module.
• Create standard business requirement(RD10/50), extensions(MD20/MD50/MD70), environment setup (BR100), conversion mapping (CV40) AIM methodology documents
• Customize Oracle Workflows for custom Order Management process flows, Cost of Goods Sold (COGS) customization & Requisition Approval customizations.
• Used HP Quality Center to manage defect logs and issues in during the QA & UAT process.
• Duties included base lining current business practices, setup of modules to customer specifications in a Multi Org environment.
• Performed functions in several instances which included testing, training, conference room piloting, documentation, and go live support.

Confidential, CA

Oracle Apps BA/Functional/BI Architect

Responsibilities:

• Responsibilities included lead consultant for Order2Cash Modules, Procure2Pay & Customer Relationship Management (CRM) Modules. Duties included base lining current business practices, setup of modules to customer specifications in a Multi Org environment. Performed functions in several instances which included testing, training, conference room piloting, documentation, and go live support.
• Support existing Oracle Apps 11.5.4 CRM(Contracts, Services & Install Base), Order 2 Cash(OM, INV,WMS) & Financial modules (AR, AP & GL)
• Oracle 11i CRM support: BI integration and production support of Oracle 11i Service Contracts (Service Agreements and Warranties), Service Requests, Install Base and TCA (Trading Community Architecture); including full integration with Order Management.
• Assist in configuration and setup of the following self service modules iProcurement, iStore & iExpenses.
• Handle upgrade issues from in oracle apps from 11.5.4 to 11.5.10 i.e. troubleshoot issues, perform unit testing, verify setups, analyze data, perform data loads in multiple upgrade environments, convert custom form and reports, verify and change existing ad-hoc business queries to cater to upgrade environment, verify system profile options. Verify the localization setups for Mexico & India operations.
• Worked within Manufacturing and Distribution - defined inventory org, custom inventory item templates, inventory items, BOM, routing, resources, departments and related costs - performed end to end unit testing from Procurement to Inventory Setup to Discrete Manufacturing to Sales Order to Shipment to Invoicing to Collections to Reconciliation(Payment Clearing).
• Used Electronic Signature Loader to load batch of root, intermediate & personnel certificates for various registered APPS users.
• Customer Data Hub - Manage and Setup DQM scoring parameters to identify and cleanse duplicates and provide clean customer data.
• Build custom APIs for Web Services i.e. Order Address Validation against Web Service such as FedEx, UPS etc.
• Organized and lead meetings with business users and oracle apps BA to finalize BI designs for the following BI Analytics Projects - Freight & Shipment Analysis (OM/WMS), Order Management (OM/AR), Order Incentive Compensation (OIC), Services (CRM), Finance (GL) & Receivables (AR/GL/Revenue & Billing Info) - discussed all aspects of analysis & required Facts & Dimensions related to each project.
• Created Datamart/Metrics Design documents & Performed ETL (Extraction, Transaction & Load) process for Business Intelligence (BI) reporting through Cognos V8 and Business Objects using ETL tools such as OWB, Advanced PL/SQL & TOAD i.e. prepared data mapping documents & mappings through OWB, data extraction procedures & scripts for materialized views, and load/refresh data and validate against respective data sources.

Environment: Oracle 10g, Oracle 11.5.4 & 11.5.10, RICE objects, Oracle Apps Framework, OWB, Toad 8.0, UNIX, BI/OLAP tools - Cognos V8 & Business Objects

Confidential, CA

Senior Oracle Apps Financial Functional Consultant

Responsibilities:

• Implemented Oracle Apps Financial modules GL,AP,AR & FA - Prepared questionnaire for requirement gathering, As Is To Be flow, BR100 Setup Documents, MD50 Functional Design & MD70 Technical Design documents for custom extensions, CV040 Data Conversion documents for conversion of financial data, Apps Test Script & User Training Documents.
• Setup financial modules GL, FA, AR & AP in R11i(actual upgrade environment) and R12 (demo setup only) - Multi-Org Setup, Define required Key (KFF) & Descriptive (DFF) Flex Fields, Define Accounting Calendar, Set of Books, Asset Book, Depreciation Methods, Financial Options for Payables, Receivables & Assets, Define Financial Budgets, Define and Schedule Recurring Journals, Quick Codes, Asset Categories, Depreciation Methods, Asset Locations, setup AR invoicing and accounting rules for revenue management and billing, etc.
• Procurement/Purchasing (PO) - Supplier Master, PO’s, Requisitions, Approval Hierarchies, Receiving Process, etc.
• Advanced Pricing: Pricing Agreements, Multi-Org Setup, Modifiers, Attribute Mapping, Integration with Order Management
• Accounts Receivable: Assessment of Business Requirements, Invoicing, Auto Invoice, Customer TCA Management, Prepayments, Collections Management, Cash Applications, Tax Integration/Vertex
• Order Management: Assessment of Business Requirements, Customer TCA Management, Sales Orders, Pricing, Advanced Pricing, Scheduling, ATP, ATO/PTO, Pick Release, Shipping
• Inventory: Including Item Master, Inventory Transactions, ATP, Scheduling, Inter-org/Intercompany processing
• System Administration: User Account Creation/Maintenance, Customized Menus, Menu Path Security, Printer Maintenance, Printing Solutions
• Create custom financial reports using Financial Statement Generator(FSG) and integration with Application Desktop Integrator(ADI) and also used Financial Analyzer to generate the same financial reports(OFA)
• Created data conversion scripts, created custom API using standard apps API (TCA HZ/OE API) & used Apps Open Interfaces (Journal Import/Order Import/Auto Invoice Import) for migration of financial data (GL) - accounts, account hierarchy, account combinations, journals & balances/Sub ledger Modules (AP& AR) - AP & AR Open Invoices/Order Management (OM/INV) - Open/Closed Orders & Items/Products.
• Created custom API for AR and AP - Load financially eligible data from OM to AR & AP open interface tables after deriving various charges and pricing information through custom pricing engine, created triggers against AR and AP interface tables for custom requirements, Created API and Custom Concurrent Programs for AR Invoice Consolidation, AR invoiced data to AP for cash disbursement to vendors/customers.
• Handled production support tasks post go live such as AR & AP reconciliation – created ad-hoc financial queries to reconcile Purchase Order Receipts to AP Payments, Order Management to AR & GL to Sub ledger Modules AR & AP. Created data correction scripts & API for various financial data correction/reconciliation issues.
• Created custom extension services such as API for Order Preprocess (Validation, TCA, Order Entry & Booking (custom workflow) process automation), Address validation against USPS/FedEx web services, Item Validation, Inbound and Outbound for integration with 3rd Party WMS VMware, Portal Integration Web Services API such as Address Correction, Update Order Tracking Information, Apply/Release Holds, Cancel Orders/Lines, Real Time Order Compliance Check, etc.
• Performed custom forms personalization in Order Management & Purchase Order modules
• Created the following custom reports using Oracle Reports and rtf formats using XML Publisher for Purchase Order, AP checks, AR Invoice & AP Minimum Contract Billing reports. Also created other custom oracle reports such as Return Material Authorization (RMA) against SR module.
• Performed End to End Testing & Provided User Training of Financial Modules Receivables (AR), Payables (AP), Fixed Assets (FA) & General Ledger (GL) modules.

Environment: Oracle 10g, Oracle 11.5.10, R12, RICE objects, Oracle Apps Framework, Toad 8.0, UNIX

Confidential, San Jose, CA

Senior Oracle Techno Functional Consultant

Responsibilities –

• Responsible for design, development and support of reports, interfaces, forms, and extensions in the Project Accounting and other modules of the Oracle Applications suite (11i)
• During GL Implementation - Used Open Interface feature of the GL module to convert existing journal data. Wrote SQL*Loader scripts to migrate the data from the text files and populated the intermediate tables like GL INTERFACE and GL BUDGET INTERFACE. Executed Journal Import program from GL menu. Used FSG to generate GL reports.
• During AP, AR&PA module Implementation - Extensively used Workflow to build and launch business processes. Developed custom forms using standard AOL components like template forms and libraries. Used descriptive flexfields extensively to capture additional information in standard as well as customized forms. Extensively used Forms/Reports 6i to customize 11i Forms and Reports then attach it to the 11i Application. Created various customized reports using Reports 6i. Used OFA/FSG to build GL Reports. Wrote SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the intermediate tables.
• Created a custom PA application, Reverse Billing to process invoices and Revenue using developer 2000 form and reports
• Wrote SQL scripts to assist in the identification of Projects revenue issues such as to verify the information contained in the PA-AR invoice interface
• Set up WMS system profile options and defined Item Specification.
• Set up cycle count system and perform miscellaneous WMS troubleshooting/testing.
• Assisted in system admin functions including user security and printer setup/maintenance.
• Develop programs that facilitate data conversion from legacy applications to Oracle's enterprise suite, including Financial, HR
• Developing Functional Specifications for RICE objects
• Involved in developing Integration Test Scripts and Documenting End-User Training Materials for project-Accounting and Fixed Assets and Performing Integration Test
• Support HRMS (HR & Payroll) module and troubleshoot errors during payroll generation etc.
• Provided Post Implementation Support for Project-Accounting and Fixed Assets modules

Environment: Oracle 11.5.10, Oracle 10g/9i, Reports 6i, Forms 6i, Toad 8.0, UNIX, Workflow

Confidential, Atlanta GA

Senior Oracle Functional Consultant/Team Lead

Responsibilities Included:

• Team Lead - Gathering the functional/process requirements from the business users, acted as the link between the business users and the technical team and also between QA and the Technical team. Excellent skills in understanding the requirements from business and using functional documents and client specified documents.
• Used Oracle Developer 2000 (oracle reports 6i/9i & Forms 6i) extensively to modify new changes for exiting applications.
• Developed reports to provide Vendor details, Purchase Order details and Invoice and Payment details for reconciliation purpose.
• Developed Daily, Weekly Progress charts to monitor the Project Progress.
• Involved in Assembly Testing for 2 releases to test the scenarios to identify any defects and enter in Test Director and PROD TEST fixes.
• Involved in Work Flow Diagrams Business (Internal & External), Consumer (Internal & External).
• Customized the PL/SQL script to automate pricing Setups without manual intervention.
• Analyzing the bugs reported by users, fixing and migrating code to production and documenting the changes made to original code.
• Extracted data from existing data source and performed ad-hoc queries by using SQL, PL/SQL.
• Performing in-depth quantitative analysis or data analysis.
• Performed numerous data pulling requests involving SQL scripts, UNIX, TOAD.
• Wrote stored procedures and packages using PL/SQL.
• Optimized SQL statements for better performance using TKPROF Utility and Explain PLAN Method.
• Analysis was demonstrated through entity relationship diagrams and data flow charts that I developed via Designer and Erwin design tools.
• Modified and enhanced database structure when required.
• Using Oracle Explain plan to optimize the queries.
• Writing technical documents using the functional specifications.
• Involved in Custom reports creation.
• Designed & developed various ad hoc reports for the finance (Oracle SQL, PL/SQL, and MS ACCESS).
• Developed the Test Scripts and Assembly and Product testing and uploading them into Test Director.
• Involved in the analysis, and did modifications for existing test plans and test cases.
• Developed test cases using Test director after analyzing the Specification document.
• Involved in Work Flow Diagrams Business (Internal & External), Consumer (Internal & External).
• Writing PL/SQL code using the technical and functional specifications.
• Creating oracle objects like tables, procedures and functions.

Environment: Oracle 8i/9i, Oracle Reports 6i/9i, Oracle Forms6i, SQL Loader, Toad.