We provide IT Staff Augmentation Services!

Oracle Apps Consultant (techno-functional) Resume

Sunnyvale, CA

PROFESSIONAL SUMMARY:

  • IT consultant experience with 18plus years, dedicated to Oracle tools and technology based applications
  • Expert in custom solutions and has over 12 years of experience in ERP solutions
  • ORACLE Certified Professional for Oracle EBS R12 - SCM - Order Management module.
  • Good experience and knowledge in Oracle Financials OM,Purchasing, AR. AP,GL,Inventory, Service Contracts, Install Base,CRM Modeless - Services (Service Request,Field Service and Depot Repair), Spares, Cash Managementmodules. Having good knowledge and understanding on Quote and Pricing, Revenue Recognitionfunctionalities
  • Expertise in Oracle (SQL,PL/SQL), Oracle Developer 2000 (Forms & Reports), Discoverer & BI Publisher Reports, OAF(Beginner),Oracle Warehouse Builder, SQL Server and MySQL Trained in Oracle BEPL & SOA from Oracle University, India
  • Good team enabler and team player and has architected, developed tested and deployed Oracle APPS Configuration, migration and integration solutions to the clients across globe

TECHNICAL SKILLS:

EBusiness Suite: Oracle Applications 11i and R12

Languages: SQL & PL/SQL, UNIX Shell Script

RDBMS: Oracle 7.x / 8i / 9i / 10g / 11g

GUI: Developer 2000 (Forms 4.5/5.0/6x/ 9IDS Reports 2.5/3.0/6x) Discoverer (10x),Oracle Warehouse Builder, BI (XML) Publisher, OAF

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Oracle Apps Consultant (Techno-Functional)

Responsibilities:

  • Directly interact with the business user to understand the business process and requirements for and provide correct solution to the requirements and problems
  • Working in Production Support in PO, AP, OM, AR, Service Contracts, CRM - Service Request, Field Service, Depot Service, and Inventory modules.
  • Gatherrequirements, Analyze requirements and suggest appropriate solutions
  • Conduct meetings with Business Users to discuss and understand the business process and requirements
  • Developed custom interface for Customer Maintenance (TCA)
  • Enhanced the AR Credit Memo Creation Custom process - PL/SQL interface
  • Created AR Claims (Refund) Custom process - PL/SQL interface
  • Created Custom Interface for Lockbox Receipt Creation
  • Worked with Oracle Support for AR Reconciliation report mismatch, applied Oracle suggested fix and took it until Production
  • Worked with Oracle Support forSales OrderInterface Trip Stop process failed due to Invalid Account combination, tested and moved it into Production
  • Working on AR, AP and Inventory Month End close activities
  • Working on Suppliers, AP Invoice and Payment Process
  • Working on custom process of creating Sales Orders, Service Contracts through EDI Inbound data source
  • Working on custom process of Service Parts Request upload, create order and fulfillment of the Parts order which are comes through EDI Inbound data source
  • Working on Pro Forma Invoice and Preventive Maintenance custom process
  • Create and enhance XML Publisher reports for the additional / new business requirements
  • Created and enhance Oracle Alerts to send Email Notifications on the below:
  • New Service Request assigned to a field service technician
  • Alert for Backlog Sales Orders which are not shipped
  • Service Request Status updates on spares ordered and delivered
  • Alert to display Closed Service Contracts which has future scheduled maintenance tasks
  • Closed Service Request status update
  • Duplicate Sales Orders created for the EDI PO interface
  • EDI files received and Sent count on daily basis
  • Working on Production Support tickets on below:
  • Suppliers, AP Invoice and Payment Process
  • AR Invoice, Tax Calculation and Cash Receipts
  • Credit Memo and Claims Custom process
  • Sales Orders, Service Contracts and Warranty
  • Customer Calls, Service Request, Task Assignment, Parts Shipment and Call/Task Status updates and closure
  • EDI inbound and outbound automated process
  • Custom Reports enhancement and fix in Oracle 10g Reports and XML Publisher Reports
  • Data extracts as requested by Business for AR Transactions, Sales Orders and Service Contracts
  • Prepare and review technical, testing documents and mentor team members on the solution implemented.

Confidential, Rancho Cordova, CA

Oracle Apps Consultant (Techno-Functional)

Responsibilities:

  • Created Custom Interfaces for the below AR Invoices
  • Created Oracle PL/SQL custom Interfaces to create Customers (TCA) in Oracle EBS using Oracle Standard Customer API to interface data from another source system
  • Created Oracle PL/SQL custom Interfaces to create AR Invoices in Oracle EBS using Oracle StandardAR Invoice APIs to interface data from another source system
  • Created Oracle PL/SQL custom Interfaces to Debit Memo, Suppliers and AP Invoices for Voucher Process for the Applied Receipts
  • Created Oracle PL/SQL custom Interfaces to Debit Memo, Suppliers and AP Invoices for Refunds Process for the Unapplied Receipts
  • Created custom build OAF Search forms
  • Developed, Tested and Deployed MIS reports for State
  • Provided Production Support on below areas:
  • Customer Maintenance
  • AR Invoicing
  • Lockbox Receipt Creation
  • Receipt Applications
  • AR Adjustments
  • Supplier Maintenance
  • AP Invoices
  • AP Payment Process (PPR)
  • Custom Process on CFP (Continues Fail to Pay), Garnishment, Refund, Disenrollment and Voucher
  • MIS Reports

Confidential, Pleasanton, CA, USA

Oracle Apps Consultant (Techno-Functional) \ On-Site Coordinator

Responsibilities:

  • PL/SQL interface to extract the Mexico AR Invoice data load it into Custom Staging table
  • PL/SQL interface to validate and log errors\exceptions on the custom staging table data
  • PL/SQL interface to generate the AR Invoice CFDI extract output file
  • PL/SQL interface to generate the AR Invoice, CFDI output file to SOA, to upload into Mexico government site
  • SFTP the AR Invoice CFDI extract output file to EDI to publish with Mexican government through EDICOM
  • Created Custom Interfaces for the below AP Invoices
  • PL/SQL interface to apply and release hold on Mexico AP Invoices
  • PL/SQL interface to extract the AP Invoice data which are on Hold and load it into Custom Staging table
  • PL/SQL interface to validate and log errors\exceptions on the custom staging table data which is being called from SOA
  • Worked on AP Invoice Approval workflow notification to display the Invoice Currency Code and PO Line details
  • Created the Exception Report in Oracle BI Publisher
  • Worked on enhancement of “AR Invoice and Adjustments Listing by GL Periods” Oracle discoverer report
  • Enhanced the AR Invoice custom PL\SQL interfaces for additional requirement from business for new Operating On-boarding
  • Enhanced the AR Invoice custom interface for performance improvement
  • Worked on the inbound and outbound data files with EDI Team on EDI850 Purchase Order and EDI810 - Invoice
  • Worked on CAWA Scheduling jobs for New Operating Units onboarding
  • Enhanced the custom build PO Print XML Publisher Report for New Operating Units

Confidential

Oracle Apps Consultant (Technical)

Responsibilities:

  • Analysis, business logic and processes data processing
  • Application design, development architecture, maintenance and support the business requirements
  • Provide leadership in the definition implementation and continuing evolution of application development

Confidential, San Francisco, CA

Oracle Apps Consultant (Techno-Functional) \ On-Site Coordinator

Responsibilities:

  • Performed On-Site Co-Ordinator role, worked with the Client’s functional \ business team to understand and freeze the requirements, Client’s Technical Team on Design and Solutions, worked with Offshore team on the Deliverables
  • Performed Independent Contributor role, worked with the Client’s functional \ business team to understand and freeze the requirements, Client’s Technical Team on Design and Solutions, developed, tested and delivered the components as per the design and solution
  • Confidential upgraded the Oracle Financials to R12.0.4 and R12.1.3.The below projects are implemented in above versions and.in AR, Purchasing, APandGLmodules
  • Integrated Consignment Solution to support GAP - Old Navy’s growing jewelry business. The Consignment product is a new way of doing business for the brand. Old Navy will not own any of the product, they will simply pay a percentage of the sales back to the vendor.
  • COA EBO Changes” project - transfer new Oracle Financials chart of account (COA) combinations, segment value descriptions, and GL Ledgers to downstream applications
  • Regional Inventory is a Hub model to place Purchase Orders, maintain Inventory and distributions to the internal organizations and franchise partners which are being operated under the same region.
  • Journals are created for Intercompany stock transfers and Buy Sell Flip Currency journals created based on the intercompany transfers.
  • As a lead, reviewed functional and prepared technical design documents and test plans
  • Lead the offshore team for some of the components development and testing
  • Designed and built custom PL/SQL Interfacesto create the below:
  • Purchase Order
  • AP Receipt
  • AP Invoice
  • AR Invoice
  • AR Auto Lockbox
  • AR Receipts
  • GL Journals
  • Developed custom forms to define customer address to store in a custom table for reporting purpose
  • Developed Discoverer reports for integrationsolution exception and errors
  • Developed Discoverer reports for “Blanket Agreement Detail and Summary”, “Receipt Details by location”, “Consignment PO (sales) at a Summary level”, “Consignment Self Billing Statement” and “AR Cost of Goods Sold” based on the Business Requirements
  • Enhanced the “Commercial Invoice” Oracle 10g custom built report with additional columns as required by business
  • Developed and delivered “AR Invoice and Adjustments Listing by GL Periods” BI Publisher report
  • AR Invoice Journals created with SLA setup to override the default accounting codes
  • Worked on the inbound and outbound data files with EDI Team on EDI850 Purchase Order and EDI810 - Invoice
  • Worked with multiple work groups to migrated the developed components from DEV, Test and Production environments
  • Prepared Migration request and HP Service Manager Change & Task for production cutover
  • Took a key role in cutover planning and deployments
  • Post production support provided for the delivered components
  • Gained client’s confidence by ensuring the quality and on time deliverables

Confidential, Memphis, TN

Oracle Apps Consultant (Techno-Functional) \ Team Lead

Responsibilities:

  • As a lead, reviewed functional design documents for the rollout of conversion solutions to multiple markets
  • As a lead, conducted regular meetings with functional team and business users for requirements and deployment
  • Lead the offshore team for project deliverables
  • Prepared \ Reviewed technical design documents for multiple markets rollout
  • Developed custom forms to define the business rules for conversion solution
  • Developed custom forms to define the conversion mapping for the legacy values with oracle apps lookup values
  • Developed custom forms to process the data file from data loading, validation, mapping and enrichment until to load into oracle apps core tables
  • Developed PL/SQL interface for the conversion solution for Customer (TCA), Pricelist, Sales Orders and AR Open Invoice O2C components to dynamically pick the business rules and process validations based on the parameters
  • Prepared test scenarios, test scripts and tested & delivered

Confidential, Santa Clara, CA

Oracle Apps Consultant (Techno-Functional)

Responsibilities:

  • Analyzed the business requirement, identified the Confidential and created change request to provide solution to the business need
  • Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs
  • Worked on order processing custom solution APIS for Oracle Apps upgrade 10.7 to 11i
  • Provided support on testing Order Processing and Service Contracts for Oracle Apps upgrade 10.7 to 11i
  • Prepared and reviewed technical design and test plan documents for the enhancements
  • Interacted with users, business team and other work groups to resolve the reported problem.
  • Analyzed the custom interface routines to identify cause for the reported problem and provided solutions
  • Tested and delivered solutions for the reported problems in multiple environments and tracked the Ticket till closure

Confidential, Seattle

Oracle Apps Consultant (Techno-Functional)

Responsibilities:

  • Gathered business and technical requirements from Premera business and IT Team
  • Analyzed and reviewed the business Requirements
  • Prepared business and technical requirement catalog
  • Identified the entity level data sets for the interfaces between CC&B to other existing applications
  • Prepared used cases and business process diagrams for the billing application functionalities as well for interface details and logical integration architecture
  • Reviewed and validated the testing strategies to ensure completeness for multiple application integration

Confidential

Oracle Apps Consultant (Techno-Functional) \ Team Lead

Responsibilities:

  • As a process improvement, analyzed, architected, designed, tested and deployed a conversion solution using Oracle Warehouse Builder (OWB) with a single window conversion processing screen to execute the OWB process flows from Oracle ERP application
  • Defined the conversion standards and methodologies for OWB conversion process.
  • Analyzed the business requirements, reviewed the functional design and technical design documents
  • Architected OWB migration solution for Oracle Apps rollouts
  • Automated data migration solution using OWB for concurrent usage across multiple countries
  • Designed and delivered a forms interface for more user friendly single window conversion processing screen to execute the OWB process flows from Oracle ERP application
  • Verified all data is transformed correctly according to business rules and/or design specifications
  • Tested OWB migration application end to end, for all the test cases which must be passed successfully to declare that build hasn't contained any showstopper bug
  • Architected, designed and delivered unified Oracle data migration solutions from the existing Heterogeneous technologies conversion solution.
  • Analyzed the business requirements with respect to the existing Heterogeneous technologies conversion solution
  • Defined conversion methodology for the unified Oracle solution that reduced dependency and saved effort and time
  • Designed online discoverer reporting solution for reconciliation, errors / exceptions
  • Reviewed technical design, test plan and code reviews. Ensured that the review inputs were addressed
  • Coordinated with on site project team, vendor partners and other work groups
  • Tested end to end conversion solution in multiple environments to identify the hidden defects
  • Tested for all business rule and lookup validations
  • Mentored the team members on technical and functional areas
  • Developed and deployed solution to extract and provide data to the divestiture division of Confidential
  • Segregated, extracted financials data from Oracle APPS for divestiture
  • Developed custom interfaces to extract the Closure / Inactivation of divestiture division transactions and relevant referential data within Oracle applications
  • Developed and delivered reports for Closed / inactivated data.
  • Reviewed Technical Design
  • Handled Customers, Item Master, Item Cross Reference, AR Open Invoices extract interfaces

Confidential

Team Leader / Developer

Responsibilities:

  • Conducted Business Review meetings with Emirates Business team
  • Prepared Functional Specification document and reviewed Technical Design and Test Plan documents
  • Prepared Fit Confidential Analysis and Impact Analysis for New requirements and Change Request
  • Designed and delivered solution using Oracle Forms / PLSQL, API
  • Coordinated with Business Team and Development Team
  • Mentored Team on Functional and Technical Solutions

Hire Now