Candidates About

Tammie  l. Tan

SUMMARY

·         10+ years of IT experience in software implementation and quality assurance focused on Oracle ERP functional, Financials and Supply Chain.

·         Participated in several full cycle implementations of Oracle E-Business Suite (EBS) 11i & R12, covered Order to Cash, Procure to Pay and CRM Service Contract processes.

·         Project and Program Management using SDLC, Agile Scrum and MS Project.

·         Ability to multi-task and work with all levels of cross-functional team, responsible for improving business process and providing values to the functions they support.

SKILLS

·         Oracle and Cloud EBS (E-Business Suite) modules covering GL, AP, AR, OM, PO and INV.

·         PL/SQL,  MySQL, Toad, MS Excel, Word, Visio, PowerPoint, Access and Project

EXPERIENCE

2016 – Current            Sr. Consultant (Remote Work), Business Processes

Tianshu Technologies, Nanjing, China

·         Served as Project/Program Manager to define project scope, develop Communication Plan and Key stakeholder RAM.  Monitor project performance and risk status, identify variances with effective review and recovery.

·         Worked in both in onshore and offshore with stakeholders to define end-to-end business processes related to order-to-cash and procure-to-pay procedures and UAT test plan.

·         Validated Oracle EBS P2P Automation Test Scripts including iProc, PO, AP and GL.  Reviewed end to end test scenarios, setup testing instance and data between Oracle R12 and HPALM systems.

·         Joined client projects, Cash Management and GL Accounts Reconciliation implementation, between Oracle R12.2.4 and 3rd party business applications.  Worked with Business Users, IT and Vendor to implement Research Template program.  Developed system and business process document, conducted Mass Accounts Maintenance and Reconcilers Assignment setup.

2014 – 2015    IT Data Management

Motorola Mobility Google/Lenovo, Sunnyvale, CA

·         Acted as a liaison among Global Customer Service, business partners and IT teams, responsible for system improvement, data validation and UAT across Oracle EBS, CRM, Service Cloud RNT, Web Services and other applications to analyze Reverse Logistics business process and system functionality.

·         Reviewed BRD and technical design documentation, tested and supported Depot Repair Orders end-to-end process, including repair orders loading, receiving, shipping, billing, Credit & Collections, Revenue recognition in O2C and Service Contracts processes.  Used SQL to check and analyze data in table.

·         Perform Gap analysis, provided solutions of Hold function and data security for Proof of Purchase attached Repair Orders, the solution has been implemented, tested and deployed into production successfully.

·         Worked with Project Managers and Product Owners, lead offshore team in new products and SBOM creation, configuration, verification and tracking in PDM/PLM and Oracle Inventory.

·         Validated Service Contract/Warranty configuration and transformation at Installed Base.

·         Setup Advanced Pricing and Deductable Modifiers for new products go-live.

2011- 2013      Sr. Consultant, Oracle Financials

Infosys, Fremont, CA

·         Acted as onsite EBS Lead to conduct BRD review and analysis, define test scope, create test scenarios, setup testing environment, lead an offshore team extracting, loading, transforming and validating sales, inventory, assets and payable data from legacy systems into Oracle GL in data migration project.  Used SQL to check data integrity from backend tables.  Supported GL Interface and Revenue Recognition.

·         Worked with Project Manager in Procure-to-Pay implementation of an M&A project for Cisco Systems, to analyze application setup and testing data, defined test scenarios covered PO, AP, FA and GL modules in HP Quality Center.

·         Provided solutions for financial data security and conducted client review meetings in Procure-to-Pay.  Worked out processes for Master data taken from SAP system interface to Oracle GL.

2008 – 2011    Business Systems Consultant

LPT Int’l, Sunnyvale, CA

·         Participated in Cisco Systems EBS enablement project, Order-to-Cash.  Developed Business Requirement Document in Manage Orders and Service Contracts attached Sales Order.

·         Conducted BRD review meetings, Customer Acceptance workshop and cross functional teams meeting, provided recommendations for multiple orders fulfillment.

·         Worked for a smart card developer company in NetSuite implementation of Order-to-Cash and Procure-to-Pay processes, and provided feedback of end users from Logistics and Finance groups.

·         Assisted in identifying and documenting project requirements and functional specifications, acted as a liaison between end users and project development team.

·         Redefined all the responsibilities to remove any Segregation of Duties (SOD) issue to progress business and system of internal control.

2004 – 2008    Business Systems Analyst                  

Alpha & Omega Semiconductor, Sunnyvale, CA

·         Setup the distributor revenue recognition and costing process which enabled accurate revenue distribution records for invoices and credit memos in EBS financial modules.

·         Integrated General Ledger with Payroll, Expense reporting and localized stand along system.

·         Worked with HR, Finance and IT to design and implement support Oracle Procure-to-Pay process.

·         Developed Oracle ERP User Acceptance Testing (UAT) plans for Procure-to-Pay (P2P), Demand-to-Build (D2B) and Order-to-Cash (O2C).  Coordinated user testing activities.

·         Built Data Quality team and work process in China.  Communicated with global users and more than 20 subcontractors, worked with teams to resolve critical issues.

·         Used Oracle SQL plus, TOAD to analyze the underlying data in the tables.

·         Conducted legacy E-biz system study and coordinated with team members for system improvement, testing, integration and application maintenance.

·         Gathered and documented business and functional requirement.

1999 – 2002    Software Quality Assurance Engineer                     

OpenTV, Mountain View, CA

·         Lead QA and tested multiple software products - SDK, OpenAuthor, GDK, Account (eCommerce), EPG and Interactive TV applications on different set-top boxes, from start until release.

·         Identified test scope, developed test plans, test suites, test cases and test guides.  Developed Shell scripts for testing of SDK command line tools.  Executed testing on Windows NT, Windows 2000 and Solaris.

·         Key team member worked closely with product/project managers, developers and releases.  Organized test procedures and delivered products to meet deadlines.

• Trained new QA engineers and supported Customer Service in replying customer’s question and improved customers’ satisfaction.

Relevant Experience Prior to 1999   Accountant     Dynasty Customs Broker, S. SF, CA

·         Processed AP, AR, Monthly Consolidations and Cash Management (Bank Reconciliation).

·         Contacted overseas agents and reconciled business transaction statements.

EDUCATION AND TRAINING

·         Project and Program Management Certificate, UCSC, CA

·         Oracle Certified Professional (OCP) 11i Supply Chain Consultant in Purchasing, Order Management

·         Oracle Certified Professional (OCP) 11i Financial Consultant in Payables, Receivable

·         SQA Engineer Certificate, Stanford Advanced Technologies, Los Altos, CA

·         Accounting Specialist Diploma with honors, Heald Business College, SF, CA

·         BA, International Politics, FuDan University, Shanghai, China