SUMMARY:

• Over 20 years of experience in implementing and managing ERP/MRP by using the standard project management methodologies. Extensive practice in delivering the solutions to an organization by mapping various business processes onto the products
• Hands - on project management skills and positive interpersonal attitude
• Competent functional and technical skills in Oracle EBS
• Excellent analytical, problem-solving, priority-setting, and communication skills
• Extremely fluency in Chinese mandarin

TECHNICAL SKILLS:

• Various Oracle EBS releases (R12.1.3, R12.0.6/4, R11.5.10, R11i, R10.7) and modules (BOM, INV, PURCHASING, iSupplier, iProcurement, COST, WIP, ASCP/MRP, GOP, Collaborative Planning, Demantra, and Order management)
• OBIEE, TOAD, SQL Plus, Oracle SQL Developer, and Oracle Discoverer

PROFESSIONAL EXPERIENCE:

Lead IT Business Systems Analyst

Confidential, Richardson, TX

Responsibilities:

• Provide production support in Oracle EBS R12.1.3, focusing in Supply Chain and manufacturing operations
• Identify the business improvement opportunities and work with the business users to design the solutions and automate it to increase the business efficiency
• Setup and implement cycle count program for company’s manufacturing sites in California and Texas
• Conduct trainings to the user community to enhance their working knowledge in Oracle EBS
• Improve the API between Oracle EBS and other third party software (i.e. Oracle CRM OnDemand, Ultriva, and Brightree)
• Implement ShipConsole to streamline the shipping processes in Oracle EBS

Oracle Business Analyst

Confidential, Vista, CA

• Provided production support in Demantra, ASCP, Order Management/Shipping Execution, Purchasing, Inventory, BOM, and WIP modules
• Conducted an ASCP (R12.1.3)/Demantra (R7.3.1.4) upgrade project
• Used Oracle OBIEE, TOAD and other tools to provide management dashboard in manufacturing and sales areas as well as ad-hoc reports
• Prepared functional specifications for system enhancements to the offshore development team

Consultant

Confidential, Sunnyvale, CA

• Implemented Collaborative Planning, iProcurement, consigned and vendor managed inventory, MSCA, and constraint-based planning
• Worked with business groups in supply chain, purchasing, receiving, and planning to perform the gap analysis on those new modules/functions, to develop the functional specs, to configure the system, and to create the desktop procures as the training materials
• Provided routine support and process enhancement in iSupplier, Sourcing, Purchasing, and Receiving
• Provided training to the user group on new modules, functionality, and enhancement

Consultant

Confidential, Santa Clara, CA

• Reviewed the business requirements and processes with different stakeholders in US, Asia, and Japan
• Performed setups/configuration of new organizations, INV, OM, WMS, and ATP modules in Oracle
• Conducted CRP/UAT with key Logistics users in different regions (US, EMEA, and Asia)
• Interfaced with other Hitachi business entities to ensure the working of custom programs and data integrity in supply chain processes
• Enhanced the warehouse/shipping procedures to meet the export compliances set by local government
• Prepared BR100, MD050, sign-off, release, and training documents.

Sr. Oracle Supply Chain Business System Analyst

Confidential, Santa Cruz, CA

• Made use of Microsoft Project to scope the project, to develop and to manage detailed project plans/schedules/WBS, and milestones; monitored project progress, mitigated risks, and resolved issues
• Identified the gaps, developed deliverables and functional/technical specifications and managed system/software customization through SDLC and Oracle AIM methodology
• Interfaced with key users in US, EMEA, Mexico, and China to define the business requirements and to map out the footprint of the implementation method and strategy
• Oracle APS suite modules setups and configurations and conducted workshop, Conference Room Pilot, Regression test, and User Acceptance test
• Performed production support in Oracle EBS core manufacturing and distributions modules
• Used TOAD to write ad hoc scripts

Sr. Functional Analyst

Confidential, Wallingford, CT

• Led plan-to-produce, procurement-to-pay, and engineering tracks in Oracle EBS upgrade project by adopting the standard project management and software development life cycle (SDLC) principles
• Implemented ASCP module using Oracle AIM methodology
• Migrated to Oracle EBS from a legacy system for a division in West Coast as a result of business acquisitions
• Developed functional designs and technical specifications to support business requirements
• Designed and delivered various training to user community to optimize the use of Oracle functionality
• Conducted Change Control Management by using IBM Rational ClearQuest/ClearCase tools

Business Analyst

Confidential, San Jose, CA

• Performed Sarbanes-Oxley (SOX) 404 reviews and remediation
• Used diagrams, flowcharts, and narratives to document all business processes in the manufacturing/supply chain area
• Reviewed and identified the key controls and potential risks or deficiencies for remediation in each business process
• Designed, developed, and executed the test plan
• Reviewed the test results and enhanced the execution of the processes

MIS Manager

Confidential, Sunnyvale, CA

• Implemented Oracle Financial modules for company’s subsidiary in China by working with the Chinese management teams and various stakeholders
• Saved $200K annually by establishing Electronic Data Interchange (EDI) business with company’s trading partners and distributors
• Automated the work order job creation, release, kitting processes, and OSP receiving process to eliminate manual intervene
• Implemented Oracle OSFM module to track the materials on the shop floor

Application Developer

Confidential, San Mateo, CA

• Collected business requirements and analyzed the gaps with users in financial group for Oracle migration project
• Maintained and enhanced the functionality of financial modules in TOLAS software
• Reduced the discrepancy of physical inventory to less than 0.5% by providing technical leadership to inventory/warehouse personnel

Project Leader

Confidential, South San Francisco, CA

• Designed and developed the RMA systems and the MRP front-end processes for the users in manufacturing operations group
• Designed and setup the company’s first data center
• Saved 30 plus man hours per week by enhancing the interface between purchasing module and accounts payable module in MAXCIM MRP software for a smoother verification
• Installed DWSA’s Depot Repair module for the company’s repair center to meet the FDA compliance
• Initiated and completed the study of disaster recovery plan