Operations Analyst Business
Resume:
Daniel Ng
Belmont, CA *****
Home 650-***-****
Cell (650) 888 - 5625
Personal E-Mail : ******.******@*****.***
Confidential – Oracle Internal
OBJECTIVE: Seek for a position as a Senior Business Analyst PROFESSIONAL SUMMARY
• Highly professional, multilingual, and motivated Oracle Techno-Functional Analyst with 4 full cycle Implementation of Oracle ERP Suite in Electronic Arts, SUN MICROSYSTEMS, Cisco, Oracle.
• Significant experience and proven track record in Oracle EBS Systems design, development, testing, and integration in complex and advanced environments. Demonstrated ability to provide application and process support to keep business processes running.
• 20+ years strong exposure of Supply Chain, Oracle Settle to Pay, Order to Cash including Versions 10.7 and 11.03, 11.5.10, R12, Fusion.
• Oracle Advanced Pricing
• Service Contracts, Service Delivery, Install Base.
• Oracle Customer Trading Community Architecture (TCA) and Setup related issues.
• ASCP includes Inventory, Purchasing, BOM, WIP, Cost, MRP/MPS, RMA Process.
• Cash Management, GL (including Intracompany, Intercompany definition, AGIS), Fixed Assets, FSG.
• Revenue Recognition (Deferred Revenue, Event Based Revenue recognition including Revenue Policies, Revenue Contingencies Application / Removal, RAM Wizard).
• REVPRO Setup.
• Cash Application / Advanced Collection / Billing Presentment Architecture in Oracle Receivables environment.
• Self-Served applications including iSupplier Portal, iExpense, Iprocurement. iReceivables.
• Configuration Management utilizing automated tools DataLoad & LoadRunner.
• Global Taxation Solution using Taxware / Sabrix / Vertex O Series Software integrating together with Oracle Ebtax.
• Multibytes-Language.
• Oracle Form Personalization, Oracle Alerts, Workflow Customization, Oracle Customization
• Approval Management Engine (AME) Definition for Expense PO and Service Contract.
• OTBI, SQL, PL/SQL, SQL Tuning, Stored Procedures, Packages, Database Trigger, Views, SQL Loader.
• Software Development Methodology SBSPLC, Agile/Scrum.
• Excel for handling large dataset, Powerpoint, Visio, Data Mining
• Manage a small group of Technical Off-Shore Team for 8 years. COMPUTER KNOWLEDGE:
ORACLE TOOLS: Developer 2000, Discover, SQL Navigator and Browser, BI Discoverer. Brio. SmartDB, TOAD.
WEB TOOLS: JDeveloper 2.0 and JAVA, HTLM. Javascript. DATABASE: Oracle 7, Oracle 8, Oracle 9, Oracle 9i, Oracle 10g. VERSION CONTROL TOOLS: Clearcase, CVS.
COMPUTER LANGUAGES: SQL, PL/SQL, C, PRO*C, Java, Perl, Unix Scripting. MERCURY TOOLS : Quality Center, PPM, DataLoad, LoadRunner. BUSINESS INTELLIGENCE: Hyperion.
Confidential – Oracle Internal
EDUCATION
B. S. in Computer Science,
University of Manchester Institute of Science and Technology in England, UK. PERSONNAL: US Citizen.
EXPERIENCE
Oracle Corporation’s Oracle Cloud Infrastructure Team. IT Supply Chain Techno-Functional Analyst: July 2016 - Now
• Convert Oracle r12 Procurement, Costing, Sourcing modules into Fusion and provided necessary trainings to the Strategic Sourcing Manager community.
• Train Strategic Sourcing Manager community how to use Negotiation Tool including RFQ/RFI, Blanket Purchase Agreement, Purchase Order, Receipts, complicated Sourcing setup, iSupplier Portal to achieve Supplier daily Supply Chain Operation Requirements like BPA pricing update, PO, Invoice and ASN creation.
• On-boarding Supplier and Authorized Manufacturer List (AML) into Fusion.
• Automate the setup Item attributes like Cost Owner, Sourcing Classifications, Sourcing Business Model, Sourcing Category, Core/Non-Core.
• Deploy Supplier Qualification Model to evaluate Supplier’s Business Continuity Plan (BCP), Risk
& Security assessment.
• Develop KPI and Business Required reports using Oracle Transactional Business Intelligence
(OTBI) to serve the Strategic Sourcing Manager community.
• Design and maintain Supplier Scorecard, Supplier Directory Tool.
• Automation of Monthly Standard Cost upload into Simulation scenario.
• Deploy Requisition to Negotiation to Purchase Order process to achieve the Buyer and SSM segregation of duty purpose.
• Integrated Cerner (Aka Oracle Health) into Oracle Fusion.
• Design and deploy a process to extract the ‘Responsible Business Alliance’ (RBA) Audit data into our Supplier Directory to serve the VAP Audit report finding Automation.
• Collecting Manufacturing Location data, Country of Origin for Tariff and Compliance analysis.
• Daily resolving stuck Sales Order in Sourcing and Procurement Orchestration stage.
• Collecting Green House Emission data for Scope 1, 2, 3 from our Top Spent suppliers for ESG Compliance purpose.
Specialized Bicycles
Oracle Technical/Functional Analyst September 2014 – February 2016 Specialized Bicycles, being the 2nd largest Bicycle Manufacturing Company in US, markets and distributes top brand bicycles and related products through a global direct sales force in more than 40 countries and my engaged Projects worked on are:
• Rollout Mexico/Columbia/Canada Markets (Operating Units) into Oracle including Order-To-Cash
(setup of Order Types, modification of their related Workflow, Pick Release rules, Auto-calculation of Freight, define new models pricing features by Advanced Pricing using Modifiers and Formulas, AR Transaction Types, Invoice Grouping rule, Auto-Invoice Request Set, Customer Facing Documents including Commercial/Intercompany Invoice), Procure-To-Pay, FA, GL functionalities.
• Enable Global Distribution Center (GDC) functionality allowing one single source of Inventory Confidential – Oracle Internal
Distribution for Asia Pacific region.
• Define Intercompany Transaction Flows (including Shipping / Procurement) for different Markets having Intercompany transaction relationships.
• Re-define COGS derivation.
• Define and streamline US Month-End Close processes including Subledger Receivables, Payables, Inventory, Fixed Assets close.
• Rollout Lockbox Functionality for US/UK.
• Rollout BI Discoverer reporting.
• Enhancement of 6i Report/Form, Form Personalization.
• Setup Procure to Pay Approval Management (AME) for US, Switzerland, Mexico, Columbia OUs.
• Customer Facing Document by Bill Presentment Architecture and XML Publishing.
• Support their daily operations including Order Management, Inventory, Receivables, Payables, Fixed Assets, GL, AME, iExpense, iProcurement, iReceivables.
• Support On-Line Bill Pay system which allows their B2B Retailer paying Invoices On-Line.
• Managing/Resolving Help Desk tickets related to Oracle EBS Application Support issues. Cisco
Oracle Technical/Functional Analyst April 2012 – July 2014 Joined IronPort (One of Cisco’s Acquisitions):
• Enhance/Support their highly customized Order Management, Service Contracts and InstallBase supporting their Hardware, Subscription Based software, licensing, Cloud/Hybrid model.
• Develop Formulas, Qualifiers/Modifiers to enhance Advanced Pricing features.
• Streamline their ordering process.
• Support Licensing system Jester and SWIFT which integrate with Order Management / Service Contracts.
• Ad-hoc reporting for data analysis.
• Integration project to migrate all the service contracts to main Cisco Responsible for the Design phrase, Implementation, BRDs, Different Test Cycle and Post Go-Live support. Joined Webex (One of Cisco’s Acquisitions):
• Enhance/Support their Legacy System BliS including Subscription-Based Offer Enablement, Front-End user interface iPortal/MyResource, Provisioning, Invoicing in 11i.
• Enhance/Support Subscription Billing Platform including Subscription-Based Offer Enablement, BRM, iService, iPortal, Provisioning, Invoicing in R12.
• Responsible migrating Webex11/Classic offers from Legacy System Blis to their new Subscription Billing Platform SPB.
• Data Migration project to migrate the BabyBear Accounts to Webex11 Accounts
• Enhance / Support their extremely high volume Finance Receivables Applications in 11i/R12 including Cash Apps/Collection/Billing/Lockbox process related to check/credit card/direct debit transactions.
• Data Mining / Analysis
Cisco
Consultant February 2011 – April 2012
Joined the GTC (Global Tax & Custom) team responsible transforming India/Italy Operating Unit into Buy/Sell Operating Unit emphasizing on the Service Contracts, Direct / Indirect Tax and Customer Acceptance areas and Change Management :
• PSD / BRD deliverables.
• Worked closely with Biz to derive Test Cases.
• Sabrix/Oracle Setup Validation
• Worked closely with QA through different Test Cycles from data mining, test cases execution perspective.
• Preparing Test results and sent to Biz for validation.
• Logged Defect Bug/Alliance Case where applicable. Confidential – Oracle Internal
• Follow-up with IT/Functional team for each Defect Bug/Alliance logged case until getting resolved.
• Identified Regression Test cases related to resolved Defect Bugs/Alliance cases and performed Regression Test cases with QA.
• Go-Live / Normalization period Support.
• Point Release Support.
Oracle Consultant September 2010 – January 2011
• Implement Corporate Solution/Advertising Service Contracts Taxation solution using Tax Engine Vertex O-Series
• Responsible for Gap Analysis, Functional Analysis, BRD, Test Cases Development, Product Category Mapping between Vertex/Oracle, maintaining US/EMEA customer tax exemptions.
• Vertex/Ebtax/Oracle Setup, Testing cycles/Data mining/Documenting Testing result, Production Go-Live support and Oracle/Vertex Tax Reports Reconciliation.
• Perform REVPRO setup to perform Revenue Recognition processes. Cisco
Business Analyst August 2009 – September 2010
Joined the GTC (Global Tax & Custom) team responsible transforming UK/Brazil Operating Unit into Buy/Sell Operating Unit and Prime Deal Implementation:
• BRD deliverables.
• Worked closely with Biz to derive Test Cases.
• Sabrix/Oracle Setup Validation
• Worked closely with QA through different Test Cycles from data mining, test cases execution perspective.
• Preparing Test results and sent to Biz for validation.
• Logged Defect Bug/Alliance Case where applicable.
• Follow-up with IT/Functional team for each Defect Bug/Alliance logged case until getting resolved.
• Identified Regression Test cases related to resolved Defect Bugs/Alliance cases and performed Regression Test cases with QA.
• Go-Live / Normalization period Support.
• Point Release Support.
Sun Microsystems
Business Analyst September 2002 – July 2009
After successfully implementation of the SunRAMP Project (Sun Replacement of Axiom & MFGPro Systems, a global systems alignment project which migrate APAC, EMEA & Latin America's Legacy system into Oracle ERP) and Internal Re-Org In Sep 2002, joined the Finance/AR Business Team as a Business Analyst getting involved in several projects.
• Work closely with the Business Community (including US, Canada, EMEA, APAC) to drive the Gap analysis, Business Requirement Document (BRD), estimate time/cost of projects
(ROM).Perform Functional/Business Analysis and develop Functional Spec. Get sign-off of the Functional Spec. from Biz.
• Pass on the Functional Spec. To the Off-Shore Software Engineer Team and help them to translate the Functional Spec. Into Technical Spec and doing Technical Spec. Review.
• Perform coding myself occasionally / with the Software Engineer team, developed test scripts, perform Unit, String, Regression Tests and document the testing results in matrix form.
• Perform Code Review.
• Provide guidance and help to Biz during UAT.
• Make sure the final product going smoothly into Production on a scheduled release calendar. Projects worked on :
Confidential – Oracle Internal
• A lead position to implement a 4-Walls solution for a sensitive Government Customer based Transactions System (GCIS) using 7 Oracle 11.5.10 modules including Order Management, Service Contract, Service Delivery, Install Base, Advanced Pricing, Receivables, Inventory.
• On going 'Ingerated Business Infrastructure Solution' (IBIS) project to replace Sun’s Legacy Systems by Oracle 11.5.10 by participating in 2 tracks : Data Migration Integration Team and Process Vertical Team. Responsible for Migrating important Entities from 10.7 to 11.5.10 including Customer Trading Community Architecture (TCA), Invoices, Credit Memos and Process Mapping between 10.7 and 11.5.10 to minimize any Customizations in 11.5.10. Also a team member in selecting a new Tax Engine Vendor.
• Performed Configuration Management (Setup) on several Oracle 11.5.10 modules including Inventory, Payables, Receivables, Treasury using Dataloader/Loadrunner.
• Deployed a Third Party software 'Taxware' integrating with Oracle for our Global Taxation Solution.
• Work with Bank of America to bring in Lockbox Functionalities to 22 Operating Units in Oracle ERP.
• Added two brand new Operating Units including Russia, South Africa to Oracle ERP providing Order Entry / Receivable Functionalities.
• Tax Engines Consolidation Project – To deploy one single Tax Engine Infrastructure across Oracle ERP, US Services, Webstore & MFGPro Systems.
• On-going ERP enhancing like new report requirements/Formats, Global Invoice Print Biz Logic change, Lockbox, Application support & Period-Close Support.
• Auto Reconciliation project which handles Auto Period Close Reconciliation between Oracle and the Corporate SFS GL systems for 45 Operating Units.
• To handle 10 more countries in Oracle ERP as EU countries including Czech, Slovakia, Hungary, Poland, Cyprus, Malta, Slovenia, Estonia, Latvia, and Lithuania joining the European Union countries in May 2004.
• Worked with Ernst & Young on the Sarbanes-Oxley Act compliance (SOX) project.
• Application Support for Order Entry / Receivable on Daily Basis.
• On-Going Global New Tax Requirement Changes.
• Perform Revenue Recognition / Amortization on Sun’s Bundle Hardware/Software & Software packages.
Sun Microsystems
Software Engineer November 2000 – September 2002
Lead Position as Senior Software Engineer in the SunRAMP Project in Reporting, AR, Data Conversion, System Setup, Specification Documentations
• Responsible to develop reports & Flat Files for Japan to replace their Axiom system in the manufacturing area using Oracle Report 2.5 and the corresponding Flat Files in PL/SQL at the Transfer Price level for the posting of Japan's Local GL System.
• Responsible for the Japan's Inventory, BOM, Routings data conversion into Oracle's ERP inventory, BOM tables and the corresponding reports & scripts to verify the conversion result and reconciliation.
• Responsible for development a Global Invoice Print & Order Acknowledement which can print 44 different Countries' Invoice and Order Acknowlegement in their local languages and Biz Req., including Multibyte countries like Japan, China by interfacing with a Multibyte Database & a Third Part's software called Tetronix.
• Europe's country Lockbox setup and modification of the LockBox Reportset.
• Deployed a Third Party software called Taxware integrating with Oracle for our Global Taxation Solution.
• Responsible to do the setup on the Order Entry, Inventory modules for Japan & Europe by setting up new Operating Units, Inventory Organizations, Responsibilities, Order types, Order Cycles, Holds, Payment Types, different Inventory accounts.
• Responsible to write Functional specifications, Technical Specifications, Unit Test Matrix, String Test & Regression Test Matrix.
Confidential – Oracle Internal
Electronic Arts
Order-To-Cash/Procure-To-Pay Lead Analyst November 1997 – November 2000
• Support extremely high volume of transactions in Order-To-Cash track for Dealer Services, Direct Services, Web Orders (EA.com), EDI Orders, and Sales Analysis.
• Enhance and Customize operations such as Dealer order entry, Direct order entry, Mass update of orders, Global cancellation of orders, Stock balance inquiry.
• Setup and schedule processes (Report Set) for OrderImport for various type of order source, Pick Release for various type of pick release rules, Update Shipping information, Inventory Interface, Receivable Interface, and AutoInvoice.
• Provide Ad Hoc Reports and Inquiry.
• Support the distribution center operations (Hayward-CA, Louisville-KY) on daily basis.
• Responsible for pick tickets generated from the pick release job and sent to the DC and processed by the warehouse management system.
• Enhance and customize operations using Reports and Forms for Mass backordering of tickets, Release of tickets earlier than schedule date, Mass cancellation of tickets.
• Support and enhance customized RMA process includes authorized RMA, unauthorized RMA, and blanket RMA.
• Responsible for quarterly and annually physical inventory processes.
• Involved with the Warehouse Management Systems project implementation.
• Support Manufacturing/Purchasing areas includes Procure-To-Pay BOM, WIP, Cost, and MRP,
• Involve upgrade Oracle Application from 10.6 to 10.7 and from 10.7 to 11.03.
• Implement 2 projects: 'Jit Sku Labeling' and 'Forecast and Demand' using Forms 4.5 and Reports 2.5.
• Customization base on users requested using Forms 4.5, Reports 2.5, PL/SQL, Stored procedures, Packages and Database Trigger.
Contact this candidate