Pierre Lafond Email and Phone Number

• Monitor daily SAP failed idocs operations on inbound and outbound flow.• Worked with Inventory Management on correcting PO issue in SAP.• Use VB to schedule SQL data load jobs for exporting to outside consultants.• Create and update BW queries and hierarchy tables in for reporting and querying.• Updating and managing Silverpop database for the Marketing department and loading campaign data into Silverpop and SAP CRM.• Creating, updating and maintaining customer master data in SAP CRM along with creating campaign data. • Create and analyze weekly Google Analytics reporting for the CEO and Marketing department for web trending and demand analysis for web base customers. • Creating and updating SAP BI queries and Webi’s for Sales department to use for daily reporting of customer sales and data. • Identified and implemented process improvement efforts within the EDI structure including system interface, policy and procedure changes.• Worked with the Easylink/VAN to implement the necessary enhancements and monitor document transmissions. • Worked on creating, update and implementing 850, 855, 856 maps in QA and transporting them to Production.• Acted effectively as point-of-contact on status of EDI transactions from internal and external customers.• Monitored, investigated and resolved EDI production problems; reviewed daily EDI error/exception reports; analyzed process and recommended improvements• Responsible for all EDI map development and testing, version control, profile setups and documentation for new trading partners for both production and test environments• Acted as liaison between buyers and vendors and warehouse personnel• Became familiar with SQL statements and created statements to research necessary information to help in analyzing EDI issues such as context of PO's, and shipment information.• Maintained and updated EDI Vendor Compliant list.

Use PL/SQL software to connect to Oracle database to write queries for researching customer issues and writing update queries to correct issues.Research data in PowerVue to find issues for customer.Writing multiple queries for research and inserting corrected data on different issue types.

• Manage and maintain Highland Managed Care SQL Database• SQL Server 2005 & 2008• SSIS Package writing• Monthly ETL cycles for Blue Cross, Fallon, Harvard Pilgrim and Tufts• Work on MS Access Database updates and improvements for IPA Physician database

• Designed, tested and implemented standalone databases to connect to main SQL database for SAP idoc research from ODBC Access connections.• Installed, maintained and tuned SQL database for multi connections for Canada and Latin America.• Acted as liaison between HP IT and HP Business to facilitate effective task management with SAP cutover issues for HP Blue (2007), Canada (2008), Japan (2009) and Latin America (2010).• Provided F2F training for HP Costa Rica team on SAP and SQL/Access database.• Designed, tested and implemented SAP BW queries and reports for HP Logistics team.• Acted as liaison between HP and UPS IT for root cause system related issues and to help implement corrective actions. • Created Excel reports for Invoice Billing for Vendors• Designed, tested and implemented SQL database for HP Business cross functional for different area of the US.• Designed, tested and implemented SQL database from data received from UPS Oracle database system for HP business end and for external use by different countries.• Maintained Sybase database for document retrieval for paperwork invoicing records.• Designed, tested and implemented SAP ABAP programming to clean up idoc delivery note error issues.• Developed extract reports and MS Access programming to transform data into required upload format• Streamlined HP department operations on continuing basis for processes and created a more efficient work force.• Completed SAP Business Information Warehouse Power User training and created multiple ad-hoc queries for end-Users to run reports for everyday business needs.• Scripted BDC sessions in SAP to clean up business process on order backlog.• Acted as liaison between UPS IT and business to retrieve FTP flat files for HP Canada.• Provided ongoing support with HP Buyer/Planners to clean up Purchase Orders on SAP.• Key contributor and liaison for HP Canada team