Oracle Ebs Techno Functional Consultant Resume
5.00/5 (Submit Your Rating)
Sunnyvale, CA
SUMMARY
- Over 12 years of experience as Oracle EBS Techno Functional Consultant with good exposure to Business flows.
- Technical expertise in Order Management, Purchasing, Inventory, Advance Pricing, Account Receivables, General ledger, Account Payables and Service Contracts.
- Extensive work in functional areas like Order to Cash, Procure to Pay and Finance Modules.
- Extensive expertise in Oracle EBS Open Interfaces, Standard API’s, integrating Oracle EBS with third party systems, and upgrade/migrate data from legacy systems to Oracle.
- Expertise in implementing RICEF (Reports, Interfaces, Conversions, Extensions and Forms) components. This includes System Study, Technical Design, Solution Development, Integration Testing, Deployment and Post implementation maintenance.
- Have good knowledge of AIM documentation methodologies i.e., Functional design documents, Technical design documents, Technical Test documents, Conversion & Migration documents.
- Possess good communication skills with strong proficiency in problem solving, initiative taking and time management.
TECHNICAL SKILLS
ERP: Oracle E - Business Suite R12.2.5/R 12.1.3/11.5.10
Processes: O2C, P2P, B2B
Development Tools: JDeveloper 10g, Reports 11g/10g, Forms 10g/9i, XML/BI Publisher
Database Tools: SQL* LOADER, SQL*PLUS, TOAD, SQL Developer WinSCP, Putty, SVN.
Database: Oracle Database 11g/10g/9i.
PROFESSIONAL EXPERIENCE
Confidential, Sunnyvale, CA
Oracle EBS Techno Functional Consultant
Responsibilities:
- Worked on various projects/enhancements related to LinkedIn OTC-Online custom application. This custom application involves data pull from Commerce Team (LinkedIn Billing System), process the Orders based on business logics, Revenue recognition for the Online orders based on billing rules, and book the corresponding JE entries.
- Designed and developed the new Architecture for OTC Online Order Processing. New Architecture has flexibility to process orders based on newly designed configuration. Everyday 500K Orders will flow from Commerce to Oracle. Newly build process helps to process entire data more efficiently and accurately.
- Worked on New Payment Processor Billdesk Implementation. Provided a generic design that helps to load settlement, deposit and transaction data.
- Streamlined Settlement, Fee Chargeback and Deposit process.
- Provided solution to improve the 3-way recon process to match Orders to Settlements.
- Enhanced the Cash In-Transit process for US & IE operating units to book JEs on a daily basis.
- Development related to automating the month end OTC-Online Accruals as part of Project MORe. The goal of this project is to automate the Month End Revenue Accrual JE creation process and reduce the manual JE creation process.
- Worked on enhancements related to LinkedIn Oracle/Fin Waterfall, which is a custom program used for B2C Revenue recognition purpose.
- Enhancements related to reconciliation between Order Booking/Fulfillment system to Bank Settlements/Deposits system.
- Worked on Oracle APEX Workbench to capture Order Information.
- Worked on Web ADI to upload product related information into custom Oracle Application.
- Worked on performance tuning on complex SQL’s and data extracts involving huge set of data.
Confidential, Chicago, IL
Oracle EBS Techno Functional Consultant
Responsibilities:
- Enabled new Partner System AFFIRM in addition to existing Partner ALIPAY and GOINTERPAY. Created a new program to send settlement information to AFFIRM once orders are Invoiced in ERP.
- Created OBIEE Report for report monitoring of any issues related to ADS and AFFIRM Partners.
- Receipt was not getting applied to Invoice. Worked with Oracle and got patch for the same. Applied the patch and tested all functionality working fine and migrated the changes to Production.
- Created a new program to refund to consumer when Xcode bought by the consumer is cancelled.
- Worked on Automation of IDM request to create new User and Responsibility. User will apply for any access in idm website. After all approval is done, support team need to manually create user, add responsibility and disable user based on the request received. Automation solution is provided for the request using new program created.
- B2B orders created in system have Shipset to make sure all items in orders are shipped together. Fulfillment partners were sending partial shipment in many case and manually shipset need to be broken in system by working with business team and process shipment. Enhancement to existing shipment process is provided to automate the breaking of shipset if it is partially received.
- Created a new program to extract the Prepay Credit card CASH and MISC Receipts. This program populate data into staging table and give user details to writeoff/Refund/Manual settle the transaction.
- Created a new user friendly Refund form to list the transaction populated by the program.
- Participated in the entire SDLC (Software Development Lifecycle) of the Project i.e., work with Business Analysts to gather Functional requirements, convert the requirements into Technical Design specs, develop the code as per coding standards, resolve issues encountered during SIT & UAT phases, participate in deployment & post Go-Live activities.
Confidential
Oracle EBS Techno Functional Consultant
Responsibilities:
- Modified Invoice printing program for Mexico direct-to-consumer (D2C) business.
- SF Express is new Carrier in China. Tested End to End flow to make sure new carrier works with Existing Functionality.
- Golden Tax Adaptor is used for sending Invoice from R12 AR to China Government. Modified Golden Tax Extract process to extract data to handle the China direct-to-consumer business. Configuration are modified to fetch only China Invoice to Golden Tax Adaptor. Once Export file are generated, existing process will be followed to send the export file to GTS System.
- Enhanced Ship confirm Program to handle ship set for Brazil direct-to-consumer business.
- Worked on the Automation of Order to Cash flow.
- Worked on getting the approval for low level design and proceed towards leading the team in construction and development phase.