We provide IT Staff Augmentation Services!

Oracle Applitions Technil Consultant Resume

CA

PROFESSIONAL SUMMARY:

  • Over Twelve years in Implementation of IT technology and supporting the framework.
  • Over Ten years of experience in Implementation of Order - Cash and Procure-Pay life cycles, Customization, Integration, Implementation, Upgrade and Support of E- Business suite.
  • Strong conceptual knowledge of ERP technologies and Databases.
  • Highly proficient in R12 Supply Chain Management (SCM) Modules like Order Management, Inventory, Purchasing, Bill of Materials, Shipping, Manufacturing, WMS.
  • Working experience in Oracle Application Financials modules 11i/R12 (General Ledger, Account Receivables, Account Payables, Fixed Assets).
  • Conceptual knowledge in working with Shipping Execution and Oracle Transportation Management.
  • Involved in Business Requirements definition, GAP Analysis, Design and Development of the solutions.Worked with business in defining the scope of the enhancements and interacted with the functional users to gain an understanding of the needs from the business.
  • Expertise in developing conversion routines between legacy systems to Oracle ERP Applications using Standard Open Interfaces, SQL*Loader, UTL File, PL/SQL, DATALOAD.
  • Solid Experience in Database design, Creation and Management of schemas, writing stored procedures, functions, triggers.
  • Proficient in usage of EXPLAIN PLAN and SQL Trace used in Performance Tuning of Code. Extensively worked with TKPROF to read a trace file and analyze using Rule based optimizer
  • Extensive experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, Data Migration, ERWIN, OWB and ETL Tools.
  • Experienced in RICE (Reports, Interfaces, Conversions and Extensions) components.
  • Extensive experience in Application Object Library (AOL), System Administration for Registration of Forms, Reports, other concurrent programs.
  • Thorough knowledge of Oracle Apps Data model and to leverage the data for effective reporting.
  • Good exposure in report writing tools like Oracle Reports and Discoverer.
  • Experience on Oracle Application 11i/R12, extending self-service applications, Oracle Application Framework OAF, Application development framework ADF, Java, JSP, Servlets. Exposure in web services development using XML, XPATH, XSLT, XML Parsers, and SOAP web services using WSDL.
  • Good experience in XML Publisher for customizing various reports using RTF template.
  • Comprehensive knowledge of AIM (Application Implementation Methodology).
  • Made Oracle Applications SOX (Sarbanes - Oxley) compliant, as segregation of duties by restricting the access levels to all the users.
  • Conceptual Knowledge on Workflow Customizations.
  • Implemented Archive and Purge Methodology in archiving the database.
  • Exposure to integration layers Hyperion, Rosettanet, BPEL, EDI implementations for iSupplier, iProcurement, iExpenses, iStore.
  • Involved in all stages of development with strong implementation skills spanning Full life cycle implementation and production support.
  • Presented typical Solutions for Technical and Functional challenges / requirements.
  • Good work ethics and interpersonal skills that help in communicating with the fellow team members, Managers, Developers and Users. Ability to handle multiple tasks and work independently as well as in a team.

TECHNICAL SKILLS:

Oracle Applications EBusiness Suite: 10.7, 11.0.2, 11.5.8, 11.5.9, 11.5.10, R12

Oracle Financials: General Ledger (GL), Account Payables (AP), Account Receivables (AR).

Order to Cash: Order Management (OM/ONT), Inventory (INV), Purchasing (PO), Shipping, Account Receivables (AR). TCA.

Procure to Pay: Purchasing (PO), Account Payables (AP), General Ledger (GL).

Supply Chain Management: SCM - Inventory (INV), Purchasing (PO), Bill of Materials (BOM), CostingOrder Management (OM/ONT), Manufacturing, Work in Process, WMS.

Oracle CRM: Service Contracts, Install Base.

Languages: SQL, PL/SQL, C, C++, JAVA, Visual Basic, HTML, XML

Oracle Tools: Reports 2.5/6i, Forms 4.5/6i, MySQL, SQL* Plus, SQL*Loader 5iTOAD 7/8.x, Oracle Discoverer 4i/9i, BPEL, SOA, WorkflowShellScripting, Oracle Configurator

Testing Tools: Test Director, WinRunner, Clearcase, HP Quality Center.

Oracle Application Framework: Application Objects Library (AOL), Concurrent Programs, Request Sets, Flex fields, Function, Security, Oracle Metadata Services (MDS), Business Components for Java (BC4J) JDBC, XML, XSL, JSP, SQL and PL/SQL.

J2EE: MVC, XML, XPATH, XSLT, Servlets, Java Beans and SOAP based web services, WSDL.

Reporting Tools: Cognos Transformer/Power Play Package, Crystal Reports 9

Operating System: Windows NT /2003Server, UNIX, Solaris, IBM-RISC

RDBMS: Oracle 9i, 8.x/7.x, MS-Access8

Microsoft Tools: MS-Word, MS-Visio, MS-Project, MS-Excel

PROFESSIONAL EXPERIENCE:

Confidential, CA

Oracle Applications Technical Consultant

Responsibilities:

  • Involved in Requirement analysis and Proof of Concept of tools; worked with business teams to evaluate the tools to fit the business requirements.
  • Validated Setups / As-Is Processes of HRMS and PAL and integration with Project Accounting and Financials.
  • Redesigned and developed State Controller Office (SCO) Interfaces functionality to automate Payroll and California Leave Accounting (CLAS) processes:
  • As part of this implementation, designed Business requirements.
  • Developed Solution Design and Application setup to accommodate the Business rules.
  • Detailed Data cleanup and Configured rules to derive the Hours by Employee.
  • Designed and developed Positive Pay, Shift differential and Overtime Payroll Processes.
  • Designed and developed California Leave Accounting Processes.
  • Trained the HR Users on the SCO Desk procedures
  • Documented BR100, MD050, MD070, MD120, Test Procedure Manuals.
  • Redesigned and developed Maximo Interfaces for FMD and BPM Departments:
  • As part of this implementation, designed Business requirements by coordinating Maximo teams.
  • Developed Solution Design and Application setup/changes to accommodate the Business rules.
  • Worked on Maximo Inbound and Outbound Interfaces to derive Straight and Overtime Hours and rates to integrate with Maximo and Fi$Cal.
  • Worked on Work Order with Project and Activity changes involving Maximo on PAL Time Entry System.
  • Designed and Developed Discoverer Reports involving changes.
  • Documented BR100, MD050, MD070, MD120, Test Case Procedure Manuals.
  • Implemented Expenditure Types functionality disintegrating Oracle Project Accounting and custom standalone application to map with all Interfaces
  • As part of this implementation, designed Business requirements.
  • Developed Solution Design, build Expenditure Type logic to accommodate the Business rules.
  • Implemented Payroll Functions eg; Positive Pay, Shift Differential and Overtime
  • Implemented Leave Accounting Functions eg; Leave Projects, Injury
  • Implemented Maximo Functions eg; Straight time, Evening time, Overtime, Call Back.
  • Implemented DSA ETRACKER Functions eg; Straight time, Evening time, Overtime, Call Back.
  • Documented MD050, MD070.
  • Designed Desk procedures and Training Manuals
  • Implemented Pre-Approval functionality disintegrating Oracle Project Accounting without routing to the regular Approval Process
  • Developed Solution Design, build Pre-Approval logic to accommodate the Business rules.
  • Implemented Payroll Functions eg; Positive Pay, Shift Differential and Overtime
  • Implemented Leave Accounting Functions eg; Leave Projects, Injury
  • Implemented Maximo Functions eg; Straight time, Evening time, Overtime, Call Back.
  • Implemented DSA ETRACKER Functions eg; Straight time, Evening time, Overtime, Call Back.
  • Documented MD050, MD070.
  • Designed Desk procedures and Training Manuals
  • Worked on developing Interfaces for Conversion data to integrate with Fi$Cal Layouts.
  • Worked on FNDLOAD utility for migrating concurrent programs, request groups, value sets from one instance to another.
  • Worked with users on user Tickets and implemented in Production. The responsibilities included responding to critical production events, analysis of application code and configuration settings in order to solve State Financial, Project Billing and Period close issues.
  • Worked with Oracle Support in raising TARs and provided point of contact and executing in resolving critical bugs, issues in relation to Application functionality.
  • Documented all processes using AIM Methodology.

Environment: Oracle Application 12i modules (PAL: Oracle HR, OTL, PA), ABMS: Account Payables, Account Receivables, General Ledger, XML Publisher, TFS, Java Eclipse, Discoverer 10g, UNIX.

Confidential, CA

Oracle Applications Functional Consultant

Responsibilities:

  • Involved in Requirement analysis and Proof of Concept of tools; worked with business teams to evaluate the tools to fit the business requirements.
  • Validated Setups of Purchasing, OM, OPM, EDI, WMS, Shipping.
  • Implemented IProcurement functionality to automate procurement and approval process using AME.
  • As part of this implementation, designed Business requirements.
  • Developed Solution Design and Application setup to accommodate the Business rules.
  • Detailed Data cleanup and Configured rules for the Approval process of Purchase requisitions.
  • Trained the Procurement Users on the IProcurement Desk procedures
  • Documented BR100, MD050, MD070, MD120, AP Desk Procedure Manuals.
  • Implemented Directed Putaway for WIP rooms, Cold Storages and Shipping:
  • As part of this implementation, designed Business requirements by coordinating Presort and Packing teams.
  • Developed Solution Design and Application setup/changes to accommodate the Business rules.
  • Setup Picking Rules, Release rules, Putaway rules incorporating business logic.
  • Worked on MSCA Customizations defaulting nearest Locator based on availability and Capacity under Subinventory per fruit varieties.
  • Worked on WIP Issue and WIP Completions of LPNs under Batches.
  • Designed and Developed Bill of Lading, Shipment Confirmation XML Templates.
  • Trained the Shipping Users on the INV Desk procedures involving integration process with Oracle.
  • Documented BR100, MD050, MD070, MD120, WMS Desk Procedure Manuals.
  • Implemented MSCA functionality to automate Warehouse functions and Production Line Operations.
  • As part of this implementation, designed Business requirements.
  • Developed Solution Design, build MSCA Application setup (Custom MSCA forms) to accommodate the Business rules.
  • Implemented Receiving Functions eg; Truck Receive, Return to Vendor, Hauler Bin tracking
  • Implemented WMS LPN Functions eg; LPN Pack, LPN Unpacking, LPN Attributes, Unload LPNs, Drop LPNs
  • Implemented WMS Putaway Functions eg; Multi Putaway, Directed Putaway
  • Implemented WIP Functions: Pick for Batch, Batch Input, Batch Output
  • Implemented Shipping Functions: Manual Putaway, Order Picking, Shipping
  • Documented MD050, MD070.
  • Designed Desk procedures and Training Manuals
  • Worked on FNDLOAD utility for migrating concurrent programs, request groups, value sets from one instance to another.
  • Worked on Performance tuning and other JVM Memory, Garbage Collection Issues involving MSCA operations.
  • Worked on supporting the WMS Presort, Pack and Shipping operations in fast paced Production line Operations during the peak business season.
  • Worked with users on user Tickets and implemented in Production. The responsibilities included responding to critical production events, analysis of application code and configuration settings in order to solve OM, Operational and Shipping and OPM Period close issues.
  • Worked on analyzing WMS and MSCA Patchset for Scangun and MWA Architecture.
  • Worked with Oracle Support in raising TARs and provided point of contact and executing in resolving critical bugs, issues in relation to Application functionality.
  • Documented all processes using AIM Methodology.

Environment: Oracle Application 12i modules (Oracle Procure2Pay, AME), OPM, WMS, WIP, EDI, OM, PO, XML Publisher, Tortoise SVN, Java Eclipse, Discoverer 10g, UNIX.

Confidential, CA

Oracle Applications Functional Consultant

Responsibilities:

  • Involved in Requirement analysis and Proof of Concept of tools; worked with business teams to evaluate the tools to fit the business requirements.
  • Implemented Setups of Advanced Pricing and Modifiers, Purchasing, EBTAX.
  • Setup Payables options, Receivables options and Shipping parameters.
  • Implemented Automation of Advanced Pricing for Modifiers for support SKUs and carried over till the Contract pricing and Revenue Recognition:
  • As part of this implementation, designed Business requirements and configured Application setups.
  • Developed Solution Design and Application setup/changes to accommodate the Business rules, by
  • Data Cleanup of Inventory Categories.
  • Created New Inventory Category to identify the Models and based on the Product category, created a discount Qualifier to generate the support SKU Price.
  • Designed PL/SQL API for pricing Engine call and Custom packages
  • Designed Custom reports to support the implementation.
  • Conducted End-End user testing starting Salesforce Quoting, OM Pricing, Service Contracts Pricing and REVPRO revenue recognition testing.
  • Trained the INV and OM Users on the Desk procedures
  • Documented BR100, MD050, MD070, MD120, AP Desk Procedure Manuals.
  • Implemented Automation of IExpenses accelerating Electronic notifications and Approvals.
  • As part of this implementation, designed Business requirements and configured Buisness rules.
  • Developed Solution Design and Application setup/changes to accommodate the Business rules, by
  • Data Cleanup of HRMS Data for Expense Approval Hierarchy.
  • Trained the Payables Users on the IExpenses Desk procedures
  • Documented BR100, MD050, MD070, MD120, AP Desk Procedure Manuals.
  • Implemented Automation of Picking Rules:
  • As part of this implementation, designed Business requirements by coordinating with VPI team and Payables team.
  • Developed Solution Design and Application setup/changes to accommodate the Business rules.
  • Setup Picking Rules, release rules,
  • Worked on Forms Personalization defaulting subinventories based on the regions
  • Designed and Developed Pick and Pack lists, Bill of Lading XML Templates.
  • Trained the Shipping Users on the INV Desk procedures involving integration process with Oracle.
  • Documented BR100, MD050, MD070, MD120, INV Desk Procedure Manuals.
  • Implemented IProcurement functionality to automate procurement and approval process using AME.
  • As part of this implementation, designed Business requirements.
  • Developed Solution Design and Application setup to accommodate the Business rules.
  • Designed iProcurement internal requisition & external requisition processes to meet the business requirement at iPS
  • Designed user friendly Requisition process in iProcurement for different Checkout levels. (Step by Step, Power & Express).
  • Automated Catalog loading process for suppliers and business partners for use in iProcurement (iPS)
  • Detailed Data cleanup and Configured rules for the Approval process of Purchase requisitions and
  • Automated Service Contract/Waranty Start date and End dates based on the SLA between various regions like N America, LATAM, EMEA, APAC, ANZ, etc..
  • Involved in Month End close procedures in handling Struck Shipping transactions, COGS matching and Revenue Recognition, Invoicing issues, Missing Receipt Events, SLA Exceptions, Inventory Reconciliation and Sales tax issues, etc.
  • Involved in Financial book Month End and Quarter end close Procedures.
  • Worked on FNDLOAD utility for migrating concurrent programs, request groups, value sets from one instance to another.
  • Worked with users on user Tickets and implemented in Production. The responsibilities included responding to critical production events, analysis of application code and configuration settings in order to solve Implementation and Customer Service, Operational and Financial issues.
  • Worked with Oracle Support in raising TARs and provided point of contact and executing in resolving critical bugs, issues in relation to Application functionality.
  • Documented all processes using AIM Methodology.

Environment: Oracle Application 12i modules (Oracle TCA, Procure2Pay, AME), INV, BOM, OM, PO, IProcurement, Shipping, Oracle 10g, Oracle Reports Builder 10g, XML Publisher, Mercury Kintana, PVCS, Discoverer 10g, UNIX.

Confidential, CA

Oracle Functional Consultant

Responsibilities:

  • Involved in Requirement analysis and Proof of Concept of tools; worked with business teams to evaluate the tools to fit the business requirements.
  • Designed the SLA rules, Bad debt write off methodologies,
  • Worked on designing the Invoice Templates for invoicing the Partners and Customers
  • Designed ADI Templates and coded for Loading credit memos, Invoices, AGIS Intercompany transactions
  • Worked Extensively on Revenue recognition for deferred Invoicing and amortization.
  • Worked on Bank Statement reconciliation and GL Reconciliation Issues.
  • Documented Desktop Procedures for Receivables team on Bad Debt Scenarios, Write offs.
  • Worked with users on user Tickets and implemented in Production. The responsibilities included responding to critical production events, analysis of application code and configuration settings in order to solve Implementation and Financial issues.
  • Worked with Oracle Support in raising TARs and provided point of contact and executing in resolving critical bugs, issues in relation to Application functionality.
  • Documented all processes using AIM Methodology.

Environment: Oracle Application 12i modules (Oracle TCA), IExpenses, EBTax, Account Payables, Account Receivables, General Ledger, Fixed Assets, AGIS, Oracle Lease Management, JIRA, SVN.

Confidential, CA

Oracle Applications Functional Consultant

Responsibilities:

  • Involved in Requirement analysis and Proof of Concept of tools; worked with business teams to evaluate the tools to fit the business requirements.
  • Implemented Setups of IExpenses, Payables, Purchasing, EBTAX, Advanced Collections.
  • Setup Payables options, Receivables options and Shipping parameters.
  • Implemented Segregation of Duties in compliance with Sarbanes-Oxley recommendations
  • As part of this implementation, designed Business rules and SOX rules by coordinating with User teams.
  • Developed Solution Design and Application setup to accommodate the Business rules,
  • Created Custom menu Entries and assigned to the Existing responsibilities and excluded existing menu entries to the Responsibilities and added to the new Responsibilities.
  • Assigned users appropriately to the relevant responsibilities.
  • Documented MD050, MD070, MD120.
  • Implemented Vendor Payments Automation in Payables integrating with Paymode-X providing banks way to accelerate Electronic transactions.
  • As part of this implementation, designed Business requirements by coordinating with paymode team and payables team.
  • Developed Solution Design and Application setup/changes to accommodate the Business rules, by creating a new PayGroup, and accommodating payments via new payment template from Payment Process Manager.
  • Designed the Custom Interface scripts using UTL file utility to extract the payments processed by Oracle Payables and interface with the Paymode-X Application.
  • Designed Custom Reports for reconciliation between the two systems.
  • Trained the Payables Users on the AP Desk procedures involving integration process with Oracle.
  • Documented BR100, MD050, MD070, MD120, AP Desk Procedure Manuals.
  • Implemented Automation for Leasing Application (VPI) integrating with Oracle Payables providing Invoicing, Invoice Payment history, Journal Import Process.
  • As part of this implementation, designed Business requirements by coordinating with VPI team and Payables team.
  • Developed Solution Design and Application setup/changes to accommodate the Business rules, by creating a new Invoice Source and vendor type, and accommodating payments via new payment template from Payment Process Manager.
  • Designed Custom Interface Mapping for loading VPI Lease Invoices into Oracle Payables Designed the Custom Interface Mapping using UTL file utility to extract the payments processed by Oracle Payables and interface with the VPI Application.
  • Designed Custom Interface for automating Deferred Rent/Percent Rent Journal Entries using GL Import Process.
  • Designed Custom Reports for reconciliation between the two systems.
  • Trained the Payables Users on the AP Desk procedures involving integration process with Oracle.
  • Documented BR100, MD050, MD070, MD120, AP Desk Procedure Manuals.
  • Implemented Advanced Collections Functionality to automate Dunning letters for Delinquent Customers.
  • As part of this implementation, designed Business requirements.
  • Developed Solution Design and Application setup to accommodate the Business rules.
  • Setup IEX Profile Options.
  • Implemented Staged Dunning and Overdue Days Dunning. Setup Emailing/Printing Dunning Letters to Customers.
  • Created Custom Dunning templates for dunning profiles using XML publisher.
  • Documented MD050, MD070, MD120, TE020.
  • Implemented IProcurement functionality to automate automate procurement and approval process using AME.
  • As part of this implementation, designed Business requirements.
  • Developed Solution Design and Application setup to accommodate the Business rules.
  • Implemented emailing AR Invoices and Customer Statements.
  • Implemented DTC (direct to Cutomer) business process for France, by integrating with Sterling OMS for Orders and and fulfilling in Oracle and integrating with DPD ( a shipping carrier) for shipment execution.
  • As part of this implementation, designed Business requirements.
  • Developed Solution Design and Application setup to accommodate the Business rules.
  • Developed Pricelist Interface, Item Enrichment Interface, GL Upload Interface by parsing XML messages from Sterling and loading to Oracle.
  • Developed Order Interface, Back Order Changes Interface, Pick and Pack list reports, Order Status and Shipment Exception Interfaces.
  • Documented MD050, MD070, MD120, TE020.
  • Worked on designing extending EDI Interfaces for boutique stores:
  • Worked on EDI 856 ASN outbound Interface for Vendors .
  • Worked on EDI 810 Invoice Outbound Interface for Customers.
  • Worked extensively on XML Reporting involving AR Invoice Register, Pick and Pack lists, Bill of Lading for Zebra Printers, AR Invoices, AP Check Printing Templates: Designed and build RTF Templates, XML files and implemented XML Bursting.
  • Involved in Financial book Month End close procedures in handling Struck Shipping transactions, COGS matching and Revenue Recognition, Invoicing issues, Missing Receipt Events, SLA Exceptions, Inventory Reconciliation and Sales tax issues, etc.
  • Involved in Financial book Month End close Procedures.
  • Worked on FNDLOAD utility for migrating concurrent programs, request groups, value sets from one instance to another.
  • Worked with Oracle Support in raising TARs and provided point of contact and executing in resolving critical bugs, issues in relation to Application functionality.
  • Documented all processes using AIM Methodology.

Environment: Oracle Application 12i modules (Oracle TCA, Procure2Pay, AME), IExpenses, EBTax, Account Payables, Account Receivables, General Ledger, Fixed Assets, Collections, OM, PO, Shipping, Oracle 10g, Oracle Reports Builder 10g, XML Publisher, Mercury Kintana, PVCS, Discoverer 10g, UNIX.

Confidential, CA

Oracle Applications Functional Consultant

Responsibilities:

  • Implemented Setups of Order management, Inventory, Account Receivables, Payables and Purchasing, EBTAX.
  • Worked extensively on CUSTOM.pll to implement the business logic. Worked on Forms Personalizatins.
  • Setup of Financial options, Purchasing options, Receivables options and Shipping parameters.
  • Designed and developed Conversion Interfaces to load Customers, Customer profiles, Customer Contacts, Open AR Invoices, Open AR Payments(Applied receipts and Sales deposits), for integration with Netsuite (a CRM application).
  • Implemented Consigned Inventory Process in Purchasing as procuring consigned items from the vendors and owning the inventory and bill the customer.
  • Optimized Oracle Workflow performance by tuning the code and implementing various versions for different Transaction Types.
  • Worked extensively on XML Reporting involving Order acknowledgements, Pick and Pack lists, Bill of Lading, AR Invoices, AR Statements, AP Check printing: Designed and build RTF Templates, XML files and implemented XML Bursting.
  • Worked on Discoverer reports: Customer activity report, Daily Shipment report, Engineering service queue report, Purchase analysis report, Freight Quote report, Invoice hold lines on shipped orders report, Due to Ship report, Inventory Transactions details report, Inventory Aging report, Commissions report for Finance, Open POs - Not delivered or invoiced, Sales Analysis by Customer and Salesperson, Gross margin Price list report, US Sales Tax report, SLA to GL transfer detail report.
  • Involved in Financial book Month End close procedures in handling Struck Shipping transactions, COGS matching and Revenue Recognition, Invoicing issues, Missing Receipt Events, SLA Exceptions and Reconciliation, Sales tax issues, etc.
  • Worked on Procure 2 Pay SOX Alerts.
  • Written Custom scripts to enhance the functionality as per the business. Championed critical and high service level production issues through the organization from problem definition, research, analysis, resolution.
  • Worked on FNDLOAD utility for migrating concurrent programs, request groups, value sets from one instance to another.
  • Prepared Functional design document MD50, Process Mapping Documents, Setup document BR100, Testing documents TE40 and Installation documents MD120. Trained key users in Sales, Credit and Receivables.
  • Responsible for testing of customized components and Standard functionality in Order to Cash. Prepared System Test Scripts, documented Test Results and User Acceptance Test (UAT) for Regression Testing. Resolved issues during CRP, UAT (User Acceptance Testing), Go-Live and Post Production Support. Responsible for leading the UAT sessions, SIT testing & Regression testing, executing the conference room pilot.
  • Implemented Archive and Purge Methodology in archiving the database.
  • Worked with users on user Tickets and implemented in Production. The responsibilities included responding to critical production events, analysis of application code and configuration settings in order to solve Implementation and Customer Service, Operational and Financial issues.
  • Worked with Oracle Support in raisng TARs and provided point of contact and executing in resolving critical bugs, issues in relation to Application functionality.
  • Scheduling and Monitoring RMAN Backup jobs for daily cold backups. Designed Purging Strategy for Concurrent jobs files and backup job runs and maintain Space utilization and resource optimization.
  • Documented all processes using AIM Methodology.

Environment: Oracle Application 12i modules (Oracle TCA, Procure2Pay, Order2Cash), Oracle OAF, Oracle Workflow, AME, Oracle 10g, Oracle Forms Builder 10g, Oracle Reports Builder 10g, XML Publisher, Mercury Kintana, PVCS, Discoverer 10g, UNIX.

Confidential, CA

Oracle Applications Functional Consultant

Responsibilities:

  • Direct Interaction with end-users located globally in the US, UK, Singapore, Hong Kong, Japan. Interacting with Onsite Functional Consultants and Business domain Leads.
  • Involved in Requirement analysis and Proof of Concept of tools; worked with business teams to evaluate the tools to fit the business requirements.
  • Implemented Setups of Account Receivables.
  • Worked extensively on CUSTOM.pll to implement the business logic. Worked on Forms Personalizatins.
  • Setup of Financial options, Purchasing options, Receiving options and Shipping parameters.
  • Expert in System Administration tasks related to Menus/Functions, Menu Exclusions, Form Personalization, Request Groups, Responsibilities, Users etc as per SOX Compliance.
  • Extensively used the Data-Loader for Item categories, Attachments, Locators, MPN assignments, FND User Responsibilities, Menu creations.
  • Worked extensively on XML Reporting involving Invoices: Designed and build RTF Templates, XML files and implemented XML Bursting.
  • Worked on Designing AR Discoverer reports: Deferred/Recognized Revenue Reports, Sales Journal by GL Account, Incomplete Invoices Report.
  • Created OAF Self Service Pages: Build Self Service Pages for Internet Expenses Auditor responsibility as per the business requirement. Implemented OAF Personalizations as per the business logic.
  • Worked on PO change Acknowledgement process. Worked on Procure2Pay SOX Alerts.
  • Worked on FNDLOAD utility for migrating concurrent programs, request groups, value sets from one instance to another.
  • Prepared Functional design document MD50, Setup document BR100, Testing documents TE40 and Installation documents MD120. Trained key users in Receivables.
  • Responsible for testing of customized components and Standard functionality in Order to Cash. Prepared System Test Scripts, documented Test Results and User Acceptance Test (UAT) for Regression Testing. Resolved issues during CRP, UAT (User Acceptance Testing), Go-Live and Post Production Support. Responsible for leading the UAT sessions, SIT testing & Regression testing, executing the conference room pilot.
  • Worked with users on user Tickets and implemented in Production.
  • Documented all processes using AIM Methodology.

Environment: Oracle Application 11i modules (Oracle TCA, Account Receivables, Order2Cash), Oracle OAF, Oracle 9i, Oracle Forms Builder 6i, Oracle Reports Builder 6i, XML Publisher, Mercury Kintana, PVCS, Discoverer 10g, UNIX.

Confidential, NJ

Oracle Applications Functional Consultant

Responsibilities:

  • Direct Interaction with end-users located globally in the US, UK, Singapore, Hong Kong, Japan. Interacting with Onsite Functional Consultants and Business domain Leads. Understand existing business processes and served as an IT Supply Chain techno-functional subject matter expert(SME).
  • Involved in Requirement analysis and Proof of Concept of tools; worked with various vendors and business to evaluate the tools to fit the business requirements.
  • Designed and developed Quality plan, Data Integrity, Corporate Profitability checks for Sales Orders. Worked extensively on CUSTOM.pll to implement the business logic.
  • Successfully implemented Order Management stock sale, Internal orders and their shipping. Defined Purchasing and OM Setup and Receiving options.
  • Implemented normal Internal sales order, Back to back, Drop shipment, ATO and PTO.
  • Implemented price Modifiers and Qualifiers for different sales orders. Implemented Position Approval hierarchy for Requisition and purchase order. Implemented receiving of Standard, Direct, Inspection and 3/4 way Matching.
  • Setup of ship confirm rule, release rule, release sequence rule and pick slip grouping rule.
  • Setup of Financial options, Purchasing options, Receiving options and Shipping parameters.
  • Designed custom interface to merge Subinventories with in the Warehouse. Designed conversion for item subinventory assignments, Resource subinventory assignments for SPARES Organizations.
  • Designed custom Interface for COGS Account to split the RMA line between salesreps.
  • Implemented R12 Revenue- COGS Matching Customer acceptance (Revenue Recognition).
  • Worked extensively on Move Order process. Developed custom scripts using Move order API.
  • Worked on PO change Acknowledgement process.
  • Designed reports on closed Promotional orders, Merchandise used, Main Units Shipped, Open RMA orders, and Order Delivery status Reports using Discoverer.
  • Worked on FNDLOAD utility for migrating concurrent programs, request groups, value sets from one instance to another.
  • Resolved shipping exceptions during picking. Setting up the attachments for reports like Pick Slip and Pack Slip reports. Involved in migrating master data like Item, BOM, Forecast, ASL, Sourcing Rule and Assignment
  • Worked with BU management to review and prioritize requests. Designing and Execution of Test Cases and analyzing the Test Results and identifying Bugs. Work with Business Users on a daily basis, providing functional support as well as technical troubleshooting assistance to ensure the successful flow of Business processes.
  • Prepared Functional design document MD50, Setup document BR100 and Testing documents TE40. Trained key users in Oracle Inventory, OM and logistics. Key member in closing first inventory period and reconciliation. Setup done for cycle counts with ABC classes and physical inventory.
  • Responsible for testing of customized components and Standard functionality in Order Management, Inventory and Purchasing modules. Prepared System Test Scripts, documented Test Results and User Acceptance Test (UAT) for Regression Testing. Resolved issues during CRP, UAT(User Acceptance Testing), Go-Live and Post Production Support. Responsible for leading the UAT sessions, SIT testing & Regression testing, executing the conference room pilot.
  • Designed and built EDI interface for EDI transactions using the XML gateway supporting the clientele.
  • Worked on Customizations involving E-Commerce Gateway.
  • Able to document and analyze business processes to help functional areas maintain process discipline, and or embark on redesign/improvement/enhancement initiatives. Assist with designing, documenting and implementing process change.
  • Worked with technical assistance request (TAR) for Application issues.
  • Documented all processes using AIM Methodology.

Environment: Oracle Application 11i modules (Quoting, OM, INV, PO, Shipping, RMA, Quality, Field Sales, Spares management CRM: Service Contracts, Install Base), Oracle 9i, Oracle Forms Builder 6i, Oracle Reports Builder 6i, XML Gateway, XML Publisher, Mercury Kintana, PVCS, Discoverer 10g, UNIX.

Confidential, CA

Oracle Order Management Consultant

Responsibilities:

  • Involved in Requirement analysis and Proof of Concept of tools; worked with various vendors and business to evaluate the tools to fit the business requirements. Developed Project Approach and Project Plan/Schedule for the complete implementation.
  • Lead and discussed needed To-Be process additions, changes, and opportunities in both the Order management and Inventory modules. Worked on Gap analysis by comparing those fundamental requirements (identified requirements) against the R12 feature set.
  • Facilitated and lead the design meetings with the Steering committee. Updated Risk Management logs.
  • Implemented setups in IProcurement module to establish Electronic Ordering and Receiving transfers at remote sites. Involved in the setup of Financial options, Purchasing options and Shipping parameters. Implemented Position Approval hierarchy for Requisition and purchase order. Configured Oracle iProcurement for catalog request and non-catalog request. Loading of item's catalog data for Oracle iProcurement and defining stores. Worked with Bulk load file import process.
  • Worked extensively withTCAModel. Setup Customers, Contacts, Salesreps, Contact Points using Standard Interfaces.
  • Validated the setup for Order Management like System Parameter, System Option, Transaction Types, Payment Terms, Defaulting Rules, Sourcing Rules and Processing Constraints. Validated the setups for Hold Management, Price list, Modifiers, Document Sequence, Document Categories and Document assignment. Validated Setup for Shipping like Organization Parameters, Shipping Parameters, Defined Exceptions, Defined Pick Slip Picking Rule, Defined Release Sequence Rules, Define Release Rule Form and Auto Ship Confirm Rule. Validated delivery-grouping rule based on BRD document. Created various Roles Like Roles for Superuser, Roles for Picker, Roles for shipper and granted to User. Resolved shipping exceptions during picking. Setting up the Document sets for Pick Slip and Pack Slip.
  • Involved in setup of Back order process, Available to Promise (ATP), Min-Max, Blanket Distributions and fulfillment process at warehouse. Managed and executed complete flow including business case development.
  • Defined the setup for cycle counting in Inventory like defining the ABC classes, classification of item in ABC classes. Defined Buyers, Position, approval groups, Position hierarchy. Defined Key flexfield structures in Inventory like Item catalog, Item Category, Sales orders, Stock Locators and System Items.
  • Translated business requirements into system definitions and solutions and functional and technical specifications. Updated Application setup document (BR100). Developed Technical design documents (MD070).
  • Worked on patch analysis. Involved in developing the RICE components based on the user requirements to bridge the gap between the business and the application. Implemented changes to the custom interface that validates the receiving and transfer transactions between field offices and business partners. Designed Discoverer reports as per user requirements.
  • Designed reports such as Inventory Movement Statistics Report based on ATP in INV according to the user requirements. Designed Custom Bill of Lading report based on the user requirements.
  • Training the client’s super users and users on the application and conducting pilot testing, integrated testing, test strategies (TE010), design validation walkthroughs. Developed Unit Test Scripts (TE040) and User Guides (DO070) for the complete process. Responsible for leading the UAT sessions, SIT testing & Regression testing, executing the conference room pilot. Developed Migration setup documents (MD 120).

Environment: Oracle Application 12i modules (OM, INV, PO, Shipping, TCA, IProcurement, AME), Oracle 10g, Oracle Forms Builder 10g, Oracle Reports Builder 10g, OAF,ADF, JDeveloper, Workflow 2.5, Discoverer 10g, UNIX.

Confidential, CA

Oracle SCM Consultant

Responsibilities:

  • Involved in Requirement analysis; worked with various functional teams and business to evaluate the tools to fit the business requirements.
  • Created Concurrent programs in Oracle Applications. Worked on Alerts, Attachments, Forms Personalization, opening new DFF’s, dynamic flex values based on Value sets as per the business requirements. Worked on FNDLOAD utility for migrating data from one instance to another.
  • Conversion plan for Model, Option, Planning, Standard Bills to meet Configurator business rules.
  • Development of UI and testing of UI also publishing the Configurator rules and UI to Production system
  • Deployment new Cart system for iStore to enable cart to cart transfer (for B2B users)
  • Implemented Back to Back orders in Configured scenario.
  • Used GS for few Configured Models in Configurator. (Guided Selling Model)
  • Successfully Implemented Stock and Sale, Drop Ship, Internal Order, Returns with Credit and without credit in Order Management.
  • Implemented complex ATO/PTO models in Order configuration
  • Setup of modifiers and qualifiers to suit the Pricing needs utilizing the Pricing SQL package in advanced pricing.
  • Documentation of Sales Order acknowledgements customization.
  • Developed custom form to implement the Archive and Purge Framework so as to archive the Outerbox tables data and finally purge them from the database.
  • Worked on Translating the TCA IDs of Custom tables as part of new system upgrades by making use of the cross reference table and use the new system IDs to load the data/Incremental data.
  • Wrote scripts in PL/SQL to download data into text files from various tables using DBMS UTL file package and procedures.
  • Developed ad-hoc reports using Oracle Discoverer on Noetix: Worked on creating EUL, Business area, custom views, new folders, custom folders, complex folders, conditions, joins and building discoverer workbooks.
  • Worked on Performance tuning and optimization of PL/SQL routines, SQL Views.
  • Worked on Version control system (PVCS) for checking in files and deploying the packages through the Kintana. Created design documents (MD070) and test scripts (TE040) as per AIM methodology.
  • Worked with Support issues (24/7) on Quality Center involving Data migration and related applications integrating the implementation.
  • Participated in code reviews, unit testing, regression testing and CRP defined by the system development lifecycle (SDLC). Identified and escalated issues that impacted testing progress.

Environment: Oracle Application 11i modules (Quoting, OM, INV, (CRM: Service Contracts, Install base), TCA), Oracle 10g/9i, Forms Builder 6i, Reports Builder 6i, Noetix, HP Quality Center, Discoverer 4i, UNIX.

Confidential, VA

Oracle Applications Functional Consultant

Responsibilities:

  • Involved in Requirement analysis; worked with various vendors, users and business to evaluate the tools to fit the business requirements.
  • Worked extensively on Kanban analysis and printing Kanban Cards for all types of PO’s for different releases based on the buyer. Customized Job Component Shortage report based on QOH to meet the business requirements. Developed reports such as Inventory Movement Statistics Report based on ATP in INV according to the user requirements.
  • Set up of Purchasing options, Receiving Options, Financial Options, and Ship-to Location. Set up PO vendors, vendor sites, and Descriptive flex fields to capture additional information. Assisted users in creating Standard Purchase order and Blanket agreement. Configured Optio to print Invoices, Purchase Orders, and Checks etc. Configured Optio email and Fax to send the POs to vendors.
  • Worked on Set-Up Document (BR-100) and was responsible for configuring the application OM based on various discussions in CRP’s. Defined the Pricelist and involved in designing the qualifiers and modifiers for different business scenario’s.
  • Worked with Engineering department on Inventory costing analysis and considerations, methods involved in calculating cost of goods sold and capacity planning. Developed Item Status report to implement the costing methods based on the levels of Inventory.
  • Worked extensively with business on generating Shipping Barcode, PO Barcode and Kanban Cards.
  • Created reports for Discrete Work Order and Pick List Printing linking BOM to extract phantom components under a particular Product line in the warehouse according to the Business Process.
  • Worked on Interface mappings for AR Customer Interface, BOM Conversion, Items Conversion and Pricelists Conversion.
  • Customized COGS Workflow: Customized the Oracle Order Management COGS account generation workflow process depending on business requirements. Implemented COGS matching and revenue Recognition process.
  • Set up the process for visualizations of the configuration created using Oracle Configurator which helps manufacturing assemble the product in a timely and effective manner.
  • Involved in CRM OA Frame work Deliverables for personalization, LOV’s and dependent LOV’s. Designed and developed OA Framework screen for existing Customer address validation via DQM system and iStore customer address validation via First Logic/Data Quality address cleansing approach. Involved in controlling functions on the pages using SPEL programming. Developed the user interface using HTML, JavaScript, XML, XSLT, SOAP WSDL and Web Services. Developed the user interface for testing all the SOAP calls using WSDL, XML, XSL and JavaScript

Environment: Oracle Application 12i modules (OM, INV, Advanced Pricing, BOM, CST, WIP, PO, Shipping, Receivables, CRM: Service Contracts, Install base, Depot Repair), Configurator, Optio, Oracle 9i

Confidential, WA

Oracle Applications Functional Consultant

Responsibilities:

  • Involved in Proof of Concept of tools; worked with various vendors and business to evaluate the tools to fit the business requirements.
  • Involved in development, customization of Forms, Reports and data migration into Oracle Applications.
  • Designed Schema and built the application based on the business process. Configured, built, and tested application enhancements as appropriate. Worked on setups of Inventory. Prepared Installation specifications (MD 120) supporting the application. Developed Program Scheduling Form according to the business implementation by the standards of Oracle. Opened Flex fields, created Lookups, Value Sets and Values supporting the Form. Worked extensively on PL/SQL creating Stored Procedures, Functions and Triggers validating logic into the base tables backend.
  • Configurations to implement Order Management and to integrate OM with Account Receivables and Oracle Purchasing (for Drop Ship order functionality).
  • Made Enhancements to a custom system that automatically creates Return Material Authorization
  • Developed Conversion script for Importing Orders from legacy system to Order Management tables using SQL*Loader and interface tables. Involved in Cut over Planning and execution, as part of Cut over Planning involved in code migration into different environments and made sure that the code is migrated correctly.
  • Imported regular Debit memo, Credit memo invoices from legacy system to Oracle Receivables tables using CTL file and Auto Invoice import program. Worked extensively on AR Autolockbox and Auto Invoice process.
  • Designed a complex JTT Framework UI of Applications. Developed the presentation layer using OA Framework and JTT in Oracle E-Biz 11i. Designed Site Maintenance Setup screens, Crew Maintenance setup screens, Lookup Maintenance applets, Approver Java applets using JSP, Servlets. Incorporated userId and Password validation for certification.
  • Defined WSDL for BPEL process, partner links, BPEL process templates and developed process logic definition. Design and Developed ESB processes, configure database, file adapters and tuned BPEL and ESB processes.
  • Created Concurrent programs in Oracle Applications. Worked on Alerts, Attachments, Forms Personalization as per the user requirements. Customized PO Validation Form based on the Business requirements.
  • Designed and built EDI interface for help desk EDI transactions using the XML gateway supporting the clientele. Configured Trading Partners · Transaction setup · Mapping setup · Customization to Standard Templates · Error Handling.
  • Developed reports for Component Partlist Revisions, BOM Assembly revisions, Inventory Management for the application using XML Publisher. Customized JTF pages and page rendering as per the user requirements. Implemented Structured Query Reporting and worked with Peoplesoft tools.
  • Customized Engineering Change Orders Report in BOM according to the business requirements.
  • Developed ad-hoc reports using Oracle Discoverer: Worked on creating EUL, Business area, custom views, new folders, custom folders, complex folders, conditions, joins and building discoverer workbooks.
  • Worked with post production issues in FA, CE, AP, PO, GL as per the user requirements.
  • Participated in code reviews, unit test plan reviews, and other quality reviews defined by the system development lifecycle (SDLC). Identified and escalated issues that impacted testing progress.
  • Documented all processes using AIM Methodology.

Environment: Oracle Application 11i modules (Quoting, OM, INV, BOM, WIP, PO, AP, AR, Customers Online, TCA, CRM, Manufacturing), Oracle 9i, ADF, BPEL, Forms Builder 6i, Reports Builder 6i, OAF, JDeveloper, EDI / XML Gateway, Discoverer 4i, UNIX.

Confidential, MA

Oracle Applications Consultant

Responsibilities:

  • Prepared technical specifications (MD 070) for customizations in Order Management, Inventory and Purchasing.
  • Involved in development, customization and data migration into Oracle Applications.
  • Worked on Transaction quantity and ATP details report(custom) for the materials in ITEM MASTER.
  • Worked on Manifesting application in Warehouse Management System involving MSCA. Involved in gap analysis, architecture, and interface design for integrating the new MOVE warehouse management system (WMS) (a 3rd party product from Optum) with the existing Oracle Applications installation.
  • Developed Custom Self Service Web Applications(SRI): Responsible for writing Session Beans and Entity Beans in the system. Responsible for implementing the J2EE design patterns (business delegate, value object and session facade patterns) and Data access objects. Created several Exception classes to catch the error for a bug free and environment. Developed web service for dynamic interaction between web applications using SOAP: Installation and Configurations of JDeveloper RUP4 OA Extensions patch. Creating custom menus structures, responsibilities. Creating custom PL SQL scripts for custom tables, views and lookup codes. Creating directory structure, Business Components for Java (BC4J) components, such as Entity Objects (EO), View Objects (VO), List of Values (LOV), Pop lists, Transient View Object, Page (PG) files and Region files (RN). Designing Graphical User Interface for the custom web forms. Created Customized Search Criteria based results pages and handling events on the page. Creating master - details (Header -Line) relationship. Created Dynamic user interface and data manipulations using Partial Page Rendering (PPR). Created Dynamic control on Advanced Table region in enabling or disabling Comment Audit facility.
  • Developed interface program and conversion program to load the legacy data into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables.
  • Designed and developed custom Vendor Interface for import of vendor information into the system.
  • Customized and developed various reports some of which like Open Orders Report, Pick Slip Report in OM.
  • Developed a detail report on delivery of orders for shipment date more than the request date (custom).
  • Customized PO Form using Custom.pll as per the business requirements.
  • Registration of new programs in Oracle Applications as concurrent programs.
  • Workflow Customization: Used AME to configure approvers. Developed procedures for custom Approval workflow. This workflow is kicked off as soon as the new user is created. The responsibilities will be added to the user created using the process that in turn calls the respective procedure.
  • Customization of sourcing complete auction workflow to update all the sourcing documents i.e. ASL, catalog quotations as an attribute to ASL, sourcing rule, assignment set and Lead Time. Therefore, when the Plan runs for the existing demand, PO can be automatically rolled out.
  • Developed reports using Oracle Discoverer by creating EUL, Business area, custom views, new folders, custom folders, complex folders, conditions, joins and building discoverer workbooks.
  • Involved in UAT, CRP Testing and supported go live activities.

Environment: Oracle Application 11i modules (OM, INV, PO, AME, AP, AR, TCA, Shipping, WMS), Oracle 9i, OAF, Forms Builder 6i, Reports Builder 6i, OAF, JDeveloper, Workflow 2.5, Discoverer 4i, UNIX.

Hire Now