Philip Loo Email & Phone Number

Hyannis, Ma, Us

New York, New York, Us

Dallas, Tx, Us

Maintain Sales Hierarchy and Accounts data consistency between Siebel CRM, Sales Billing and HR systems. * Delivered data solutions to sales segment’s champion to maintain accurate Sales hierarchy and sales to customer relationship. * Improved efficiency by automated monitoring Sales organization changes and notification process.* Administered Oracle 10G database with data load, index creation, and SQL development to support production data integrity requirements in the areas of Accounts, Opportunity, Contacts, Contracts and D&B.

Hyannis, Ma, Us

Planned and executed data migration and conversion strategy for SAP implementation project with a pharmaceutical company. * Corresponded with legacy system data owners in Europe to acquire information and identified SAP SCM master data requirements for Material Master, BOM, Inventory and purchasing information. * Transformed specification rules for data object such as Revision level, Material Type, Unit of Measure, and document management in EZMap repository to data migration rules.* Developed SQL based data migration rules in Data Staging Warehouse for data mapping, extract and transform source data meeting SAP configuration requirements.* Designed and created CranSoft SQL based Web applications in Data Construction Server to provide user to review and update material master related data.

Us

Led the charge to search and replace legacy ERP system with SAP ECC. Managed six SAP installations and databases to support system landscape includes development, QA and production systems. * Effective in collaborating with business functional users and configuration consultants to ensure the transfer of functional knowledge and defining requirements for developing application solution. Business process included Sales, Purchasing, Material, Inventory and Customer Services.* Utilizing ER methodology to establish data structure and mapping for data migration from legacy system to SAP. Developed SQL-based programs to extracted master data for Customer, Vendor, Material and Stock, performed cleansing and conversion to ensure data quality and integrity for SAP data load with LSMW.* Application support and training in the area of creating and maintaining customer, vendor, material master, sales order, purchase order, shipping and receiving, stock movement, physical inventory, customer service and Engineering Change Control. Trouble shoots user’s challenge, worked with subject experts to resolve the issue including enhancement development, applied system patch and acceptance testing.* Responsible for data accuracy. Using SAP Query and reports to perform on periodic audits and data integrity checks. * Worked with Finance and Vertex Tax consultant to setup Vertex to calculate sales tax and provide monthly tax filing reports. Maintained Vertex sales data and configured sales tax rules for tax exception and exemption.

Us

Managed implementation of DataFlo ERP System. Coordinated work effort on each business function enhancement with development team. Responsible for providing system administration, database maintenance, user training and support, saving in support licensing fee. Developed database applications and provided database administration on object oriented database and Oracle relational database.

Atlanta, Ga, Us

Led support team in development and enhancement of Quality Assurance application for maintaining worldwide product quality.

Bs, Marketing / Computer Science

Master, Cis

Education record