Oracle Financials Functional Consultant/business Systems Analyst Resume
CA
PROFESSIONAL SUMMARY:
- Over 15 years of experience in IT software industry in enterprise environment.
- Experience includes Analysis & Solutioning in high tech, discrete manufacturing, fabless semiconductor manufacturing, contract manufacturing, networking and medical device companies.
- Played versatile roles that include functional roles, lead roles, project management roles and solutions architect.
- Proven experience in Order to Cash, CPQ, ERP, CRM, Procure to Pay, Finance, B2B and Supply Chain area
- Experienced in leading global cross - functional teams in large corporations as well as in fast growing smaller companies.
- Extensive onsite hands on experience in implementing, upgrading, integrating, customizing and supporting Oracle ERP/ Confidential CPQ Applications - expertise in Procure to Pay, Procure to Order, Quote to Cash, Record to Report, Apttus Sales Cloud, Manufacturing, Product configuration, Pricing, Quoting, Proposals, Costing, Supply Chain, B2B fulfillment & Finance.
- Requirement gathering & BRD process documentation, solution architecture, conducted gap analysis and suggested solutions
- Created Test Plans, conducted CRP/UAT Sessions, training and driving Change Management.
PROFESSIONAL EXPERIENCE:
Oracle Financials Functional consultant/Business Systems Analyst
Confidential, CA
Responsibilities:
- Performed requirement gathering & created functional design document of Yardi to Oracle journal automation. Conducted internal & business review of FSD and worked with development & QA team to build the solution.
- Performed the POC of secondary ledger migration project & created BR100 documents for France, Italy & Spain ledgers. Worked with QA & business team to finalize the QA test cases.
- Performed Concur & Oracle integration testing.
- Developed functional design documents of 2 GL reports & got approval from business to build the solution.
- Performed AR & CM reconciliation reports testing before moving into UAT.
- Attended daily stand up status meetings in Oracle P2P & R2R projects.
- Performed Oracle EBS R12 advanced global intercompany system end to end QA testing.
- Reviewed the QE test cases with internal IT team & business users to make sure the expected results are synced with actual results.
- Recorded defects in custom Confidential based applications including the test data & supported files.
- Developed & implemented test cases of monthly releases user stories in Oracle EBS R12 procure to pay & record to report business process using Agile methodology.
Lead Oracle EBS Quote to Cash Consultant/ Business Systems Analyst
Confidential, CA
Responsibilities:
- Performed cross functional lead role to get quarterly enhancement request in Oracle EBS Quote to Cash, supply chain, Invoicing (OM, INV, PO, AR, AP, GL, CPQ, WIP, BOM, CST, IB, SC, Mfg. operations) domain and deliver the solution with the help of offshore team.
- Conducted requirement gathering meetings with business users & created MD50 functional design documents & configuration in custom CPQ, Oracle EBS Q2C, Procure to Pay, Receivables, order booking, B2B fulfillment, licensing, service contract, standard cost updates & rollups, install base business applications & deliver solution with the help of offshore development team.
- Created test cases, performed unit/SIT/UAT testing in Oracle EBS Supply chain modules (OM, INV, PO, AP, AR, Costing, IB, SC, Reverse Logistics, CPQ, BOM, WIP)
- Managed team of 5 offshore developers successfully to build & test the solution in DEV instance on time before migrating to QA instance.
- Developed weekly status reports & presented to client manager.
- Delivered the level of effort estimate to client to deploy the solution in QA/Production & support them after go live.
- Validated the set ups & Oracle custom objects in DEV/TEST/Production Oracle instances.
- Supported business team by doing root cause analysis of issues during quarterly Q2C NPI testing cycles.
- Wrote SQL queries to do data validation & debug, review PL/SQL code for understanding business process logic.
- Participated release meetings to migrate the enhancement requests to Production & validated the objects.
- Participated in release meetings to present enhancement requests & problem tickets migrated in production.
Senior Order to Cash Functional Consultant/Business Systems Analyst
Confidential, CA
Responsibilities:
- Analyzed current business processes, performed gap analysis, and designed future business process flows in Apttus CPQ to Oracle eBusiness R12 Quote to Cash integration implementation project. (Oracle OM, Inventory, Apttus CPQ sales CRM cloud application, Service contracts, Install Base, Confidential B2B Integration, AR invoicing & revenue management, GL modules in R12.1.3 version)
- Created test cases, performed unit/SIT/UAT testing in Oracle EBS Supply chain modules (OM, INV, AR, GL, IB, SC, Apttus CPQ)
- Created MD50 functional design documents for customer/sales order creation, update, item attributes update, software license fulfillment processes.
- Worked with cross functional team including Confidential, Confidential tech team to do data mapping from Confidential to Oracle R12 for customer account, address, contacts, sales order creation.
- Performed AR transactions custom auto accounting, Confidential, revenue recognition testing.
- Created BR100 Oracle configuration documents including new order types, item templates, customer relationship.
- Worked with technical team to explain the functionality to complete the development stage.
- Helped business users in various CRP testing phases using Jira & Confidential .
SCMLSS Functional Consultant/Business Systems Analyst
Confidential, CA
Responsibilities:
- Analyzed current business processes, design future business flows, perform business requirements mapping, and identify gaps, impact, workarounds and reporting needs.
- Created BR100 configuration & set up documents for the implementation of quarterly project scope & enhancements.
- Created test cases & performed unit/SIT/UAT testing in Oracle EBS Supply chain modules (OM, INV, PO, OTM)
- Worked on various B2B PIP’s like 3A4, 3B2 ASN, 3B2 Ship confirm, 4B2 receipt confirmation, 3B18 Shipping instructions, 3B3 milestones for sending message from & to contract manufacturer.
- Worked with business users to discuss about some of the open issues in RD50 requirement document.
- Analyzed the applications in scope & out of scope, constraints, dependencies, impacted processes & systems.
- Worked with IT development team to propose optimized solution to support solution delivery.
- Performed go-live implementation & post production support.
- Created MD50 functional design documents for various processes like commercial invoice generation for cross border shipments, Russia green light process, 3B18 shipment generation for PO inbound shipment, Russia transit pad calculation, Hazardous & non FCC compliance process, smart compliance routing for faster on time shipments, Return to A stock process from RD50 business requirement documents in Cisco supply chain B2B deliver processes (OM, INV, WSH, PO, WIP, OTM, RMA).
Senior IT Business Systems Analyst/Program Manager
Confidential, Sunnyvale, CA
Responsibilities:
- For Confidential Service, I implemented repair automation process, which allowed Riverbed to reduce lead-time to replace customer defective unit in Confidential region by 70%.
- Worked on various B2B PIP’s like 3A4, 3B2 ASN, 3B2 Ship confirm, 4B2 receipt confirmation, 7B5 Work order extract, 7B6 work order completion, 4C1 Subinventory transfer for sending message from & to contract manufacturer. Created RD50 & MD50 requirement documents to deliver business impacted projects in EBS R12 domain.
- Created test cases & performed unit/SIT/UAT testing in Oracle EBS P2P & O2C business processes (OM, INV, AR, AP, PO, Costing, Reverse logistics)
- Supported sales CRM ( Confidential ), custom CPQ, P2P, O2C & B2B procure to pay (Contract manufacturer) integration application to create opportunities, quote & create sales orders, PO, AP invoices in Oracle ERP modules.
- Developed & executed OM, service contract & install base test cases during OpNet company acquisition & R12 upgrade.
- Supported the implementation of custom Confidential portal for RMA Fulfillment process between Riverbed & worldwide UPS Depots using Confidential & RosettaNet PIPs.
- Within a year of launch of Confidential service, I implemented repair & return process for countries like Argentina & Brazil, which enabled the export of defective units to the Riverbed repair vendor with subsequent return of a repaired unit at source country UPS depot.
- To staff our expansion, I partnered with external vendors & business group to roll out automated Oracle Demantra Demand Management & Rapid Planning modules implementation.
- I partnered with Riverbed business group to upgrade to EBS R12.1.3 in Global Support Delivery, Mfg. Operations & customer RMA fulfillment business areas.
- Partnered with cross functional teams to align new product releases (hardware & software) with the established Procure to Pay, Sales Order Fulfillment, Invoicing, revenue, standard cost updates & rollups, software license fulfillment & RMA fulfillment processes.
- For Baxter Planning System, I supported the integration of Oracle E-Business Suite with for Service Materials Planning to support worldwide 24x7 Customer Support Operations.
Senior Oracle Applications Support Project Manager/Business Systems Analyst
Confidential, Fremont, CA
Responsibilities:
- Managed the Oracle EBS R12 applications including production support in Confidential Quote to Cash (Sales CRM), Revenue management, Record to Report, Invoicing, RMA Fulfillment, Procure to Pay, service contracts, install base, Financials (AP/AR/GL/FA/SLA), Manufacturing, licensing, service supply chain, e-commerce portal and Confidential Orders to service contracts business flows.
- Created test cases & performed unit testing/UAT/SIT in Oracle EBS Supply chain modules (OM, INV, PO, Costing, Reverse logistics, AP, AR, GL, FA, SLA, Costing).
- Created RD50 & MD50 requirement documents to deliver value added projects in Order to Cash projects.
- Managed Oracle EBS R12 - ADP Taxware implementation project including Oracle O2C adapter installation, UAT testing, Production rollout & post production support.
- Implemented the company’s high visibility project called “iWellness” which includes Confidential Quote to Cash business flows in service mode using external integration partner. This project allows the company to use their ophthalmic diagnostics medical devices as pay per use mode.
- Gathered business requirement, validated functional requirements and design documents.
- Prepare MD50 document and work instructions for iWellness sales order placement, recurring transactions processing & software license fulfillment business processes.
- Wrote SQL scripts for data validation extensively to confirm desired master & transactions data in OM, INV, IB, SC, Shipping, AR, AP, FA, GL, SLA, PO modules.
- Performed OM & AR setups for iWellness project.
- Implemented unit testing, UAT testing, production rollout & post production support. Coordinated cross-functional initiatives to implement UAT.
- Prepared SOP & work instructions to document the end to end business flow.
- Trained users to explain end to end business flow.
- Managed offshore support team to implement projects like BPA AR invoices email distributions to sales persons, customization to Oracle ADP taxware adapter.
- Led the sales rep, VP, director incentive commission application integration with Oracle OM/AR applications.
- Configured & implemented new inventory org for service organization.
Senior Business Systems Analyst/Project Manager
Confidential, Sunnyvale, CA
Responsibilities:
- Played the role of applications support manager which included issue prioritization, requirement gathering, delivery of technical development, unit testing, and UAT and production migration in Oracle 11.5.10.2 Distribution, Supply chain, MRP planning, OSFM, Costing, standard cost updates & rollups, Manufacturing & Finance areas.
- Implemented Quote to Cash, Procure to Pay, Record to Report, AR/AP Invoicing, Revenue management, FA, GL, RMA business process for standard customer orders.
- Implemented Confidential B2B & OSFM integration project with the help of external implementation partner.
- Worked as functional & technical lead in the upgradation of E-Business Rel 11i from 11.0.3.
- Configured new AP Invoicing & check printing responsibilities for Macao & SV entities.
- Supported AP invoice import customization program for multiple vendors.
- Configured the EDI AR outbound process for multiple trading partners like Future Asia.
- Supported intercompany invoicing between SV & INTL entities.
- Created custom finance views in Oracle apps integrated with Cognos EIS system.
- Designed & implemented vendor shipment automation in custom dropship application and sales order shipment automation from legacy system.
- Developed & supervised the implementation of new fixed assets depreciation accounts project.
- Architected, designed & implemented cost variance & FA views for Cognos reporting system.
- Supported sales order creation customization from legacy e-Flash application.
- Performed UAT configuration setups during China, Taiwan & Macao Finance implementation project.
- Coordinated the technical development delivery for China, Taiwan & Macao Finance implementation project with the help of offshore development team.
- Supported Oracle/ADP integration projects which extracted Oracle HR data and input to ADP payroll applications. Also supported moth & quarter end close of Oracle Financials modules.
