Oracle Ebs Consultant Resume
Sfo, CA
PROFESSIONAL SUMMARY:
- 13+ years of experience in Information Technology and played various role like Lead, Techno - functional and technical in different applications.
- Functional and technical experience in Oracle Applications Cloud - fusion financials, Fusion Tax, EBS Finance, HRMS and SCM modules
- Having strong experience in full life cycle implementation, enhancement, upgrades and conversion in e-Business suite R1x.x.x.
- Work closely with business users to gather business requirements, suggest solutions, define and simulate business processes, configure and validate processes with business, setup and configure business requirements, problem solving and troubleshooting day to day business issues.
- Experience in oracle implementation terminology such as CEMLI Framework, RICE development and AIM methodology in e-business suites (EBS), documents like business requirement, user guides, functional, technical and test case and migration documents as per client standards / AIM methodology. Eg. BR100, MD50, CV40, MD70, CV60, TE20 and TE040 etc.
- Having functional / techno-functional and technical experience in Oracle modules Finance, SCM & Advance Supply Chain (ASCP), Rapid Planning (RP), APCC Dashboard, Order to Cash (OTC), Procure to Pay (P2P) and Portals (iSourcing, iSupplier and iProcurement) and technical experience CRM modules Service Contract and Field Service.
- Having strong Integration experience in integrating Oracle Application with other Business systems like Vertex, Workday, SAP, Salesforce, Nestivo, Steelwedge, EEDAR, POS, Legacy and Partner/3rd party systems etc., using various architectures like FBDI, Service Oriented Architecture (SOA) and other adaptor tools.
- Design, Develop and extending standard and custom Oracle Application Framework (OAF objects such as View Objects, Controller, Application Module (AM) and Entity objects.
- Design and develop custom approval processes, build and enhance/customize existing/standard workflow/approval processes as per business requirements.
- Excellent Intra-personal and communication skills, work experience in onsite offshore model, ability to lead, design, develop and deliver complex solutions/projects to meet deadline with in the budget and holding project management experience too.
STRENGTHS:
Attention to detail, Speed, Sense of Ownership, Quality-focus, Result oriented, Cross team Synchronization, Excellent organizational, Verbal and Written Communications skills, Self-Motivated and Sense of ownership.
TECHNICAL SKILLS:
- SQL, PL/SQL, Java, C++, C, PERL, Pascal, COBOL, HTML, DHTML, VBScript, ASP, MTS, MSMQ and FoxPro 2.6
- Workflow Builder, Discoverer, Oracle Forms / Reports, Optio, XML Publisher and RXi
- Unix and Windows J2EE, JMS, JCA, XML, XSD, XLST, XPATH, XQUERY, WSDL and Oracle BPEL
- MS SharePoint 2016,MS Outlook, MS Project, MS Excel, MS Visio, MS PowerPoint, MS Word, MS Outlook, Remedy
EXPERIENCE:
Oracle EBS Consultant
Confidential, SFO, CA
Responsibilities:
- Involved in R12 implementation team to implement R12 for Confidential .
- Covert/migrate Current version of R11 setup/data into R12.
- Gather business requirement, gap analysis, compile document for existing and new processes as per client standards.
- Enabled and configured AR and OM setup in R12 as per R11 and import and troubleshoot R11 open and required transactions into R12 using API.
- Reconcile imported transactions against R11 at each stage.
- Customize workflow to close OM line as per business requirements.
- Interface daily transactions like OM Subscription, AR Invoice, Receipts, Adjustments etc., into application as per requirement.
- Developed XML publisher and Oracle reports as per requirements and needs.
Oracle EBS Consultant
Confidential, SFO, CA
Responsibilities:
- Involved in collecting requirements from cross functional teams and solely created the business process flow, functional & technical, test cases and migration document.
- Simulated Oracle Application Cloud (Fusion financial) as like current EBS system with fusion future
- Gather business requirement, gap analysis, compile document for existing and new processes as per client standards.
- Enabled and configured fusion financials modules AP, AR, GL, FA, CE, Fusion Tax and Fusion Expense.
- Integrate in-house and 3rd party application with fusion financials such workday, Epay, Apple, Google Play etc.
- Define Approval process, hierarchy and rules for approvals
- Develop OBIT and BI Reports for existing e-biz reports and gather requirement for report enhancement such as Open Invoice, Open PO etc.
- Support day to day business issue on EBS R12 and work with Business and IT to resolve issues and enhancements.
- Walk through and document existing processes, integrations and interfaces programs to avoid reverse engineering and improve IT productivity.
- Redesigned interfaces which cause issues and need more human intervention on daily basis.
- Played key role in tricore server move projects, validated all communication protocols and server response and request objects.
- Automated Amazon monthly invoices, payments, journal entries creation and reconciliation as per business requirements.
- Define game mapping, configure invoice and payment process against the game.
- Designed reconciliation process which helps business to reconcile invoice and payment transactions with customer systems on monthly and daily.
- Enhance existing Workday - Oracle HRMS integration to avoid routine error and reduce manual intervention on fixing those issues.
- Templates defined for PO Communication and Customer Invoice Printing.
- Setup and Configure modules GL, AP and AR for new acquisitions.
- System administrator role to configure and validate all required setups.
- Support Month, Quarter and Year end period close activities.
- Troubleshoot and problem solving on day to day issues.
Techno functional Consultant
Confidential, San Mateo, CA
Responsibilities:
- R12 Implementation and Post go-live production support.
- Support on daily production issues, RICE and CEMLI business components.
- Configure business setup and processes as per business requirements.
- Implemented custom P2P Process, Item and PIM configuration processes.
- Involved in Period close activities in all sub ledgers and general ledger. Provided detail and drill down reports solution from SLA to subledger to reconcile.
- Setup new ledger, organization and operating units for 3rd party and Brazil and acquisitions
- Designed and developed custom Forecast, Scheduling and planning process in R12. Build custom reports for APCC dashboard as per business requirements.
- Developed interfaces in all modules like Finance, SCM and ASCP. Interfaces for Sales Order, Purchasing, Supplier, Customer, Item, PIM attributes, Material and WIP transactions, forecast, purchase orders, Sales Orders, Bill of Materials and invoices (AP&AR).
- Purchase order work flow customized to default account string based OSP items.
- Customize PIM product attribute pages based item catalog category in OAF.
- Integrate 3rd party system with Oracle applications like Steelwedge, EEDAR, PIMA, DADC, and Channel Management.
- Digital Game and DLC (Down Loadable Content) Item configuration in Item and PIM for to forecast sales and revenues.
- Develop and enhance custom forms, workflows and reports for R12 implementations in order to bring custom process into R12
- Configure sourcing rule, supplier registration, negotiation, negotiation, define catalog and non- catalog for an item master and supplier items. RFI, RFQ and Auction configuration on iSourcing.
- Configure 3rd party integration related setup in R12 like item template, item hierarchy for disc and digital products, price list, customer and Order type etc.,
- Design and develop OSP process for warehouse. Setup OSP items, OSP operation and resources etc. and enabled return/reversal process (RTV) to return item back to vendors/suppliers.
- Interface daily inventory transactions like account alias issue/receipt, miscellaneous issue/receipt and work order less transaction etc., into application.
- Developed XML publisher reports as per requirements and needs.
Production Support Engineer
Confidential, San Jose, CA
Responsibilities:
- Production support in all EBS modules.
- RICE development as per business requirements.
- Convert Text format output to EXCEL using XML publisher.
- System Administrator to new user, responsibility role to a Project development and production support.
- Report development on Finance and MFG modules
- Interface internal sales and panel system, vendor invoices into applications
- Form personalization, enable Org specific DFF on iProcurement and Requisition forms.
- Setup and configure items, vendors, BOMs, Routing, Work Order sequence etc.
- Customize employee expense page in OAF.
Oracle R12.1.2 Development and Production support
Confidential, San Jose, CA
Responsibilities:
- Project development and production support on day to day business processes.
- Month and Quarter period end close activities and day to day issues, reports and troubleshoots.
- Changed fiscal calendar to monthly calendar as per new business.
- Configured new Set of Books in GL for US, AUS, France and US Investment Company. Invoice match option from PO to Receipt, Direct delivery route instead of Inspection on PO, Lead time update for assembly and sub assembly items, enable OSP items and associate with Resource, department etc.,
- Advance supply chain (ASCP) setup configuration like Sourcing Rule for ISO orders, WIP accounting class, Item Min Max planning and other parameters like netting subinventory etc.,
- Support on Agile PLM and Oracle EBS integration using SCM Net.
- Define cost types, material sub elements, management profile option and security functions
- Import Items, Item assignment, create cost for internal org from existing domestic frozen cost and enable list price in the price list.
- Working on Quickwin project to simplify user navigation in Oracle application and development on RICE objects
- Automation of WIP job creation, Copy bulk items for donor systems,
Production Support Analyst
Confidential, San Francisco, CA
Responsibilities:
- Oracle EBS R12 Production support
Production Support Analyst
Confidential, Santa Clara, CA
Responsibilities:
- Oracle EBS R12 Production support