OBJECTIVE:

A senior IT/SAP/ERP/data consulting SME (subject matter expert)/lead role.

SUMMARY:

• Confidential is a dynamic ERP and Big - Data consultant in the areas of Enterprise Applications business systems -- SAP, Oracle, MS SQL, data migrations, ETL -- with his name synonymous to all the latest and past prominent technologies used in the data processing industry.
• In 1995 right out of college he started his IT career and quickly became hands-on with multiple programming languages, and database technologies.
• His can-do attitude and quick-learner mentality enabled him to excel at all the ERP and data endeavors he took on, with references and testimonials from many satisfied customers.
• To backdate a little further, he started programming in high school back in China in the 1980s when the only computer at the school was an Apple II with green letters on a black screen.
• Since moving to the States as a student in 1998, he acclimated himself to the North American culture, and quickly built an SAP-ERP and data consulting practice, getting involved in SAP and other data-intensive projects around the globe.
• Confidential lives in Calgary and is an expert skier. His younger son is aspiring to be a 2022
• Olympian in freestyle skiing, encouraged personally by a former world champion and family friend, and now a coach for the Canada national snow sports team. Lifeng loves travel and takes his family around in excursions worldwide.
• SAP procurement automation with workflow
• Paperless office for vendor and Accounts Payables management
• Landscape optimization in data quality management for diverse SAP systems
• Data cleansing with multiple clients in different industries
• Data migrations from legacy ERP to modern ERP systems
• Data asset management: mining data as a strategic asset in the corporate
• FDC field-data collections and conversions into SAP
• ETL setups for data warehouses/business warehouses with Informatica and MS SQL SSIS, SSRS, SSAS.
• Data archiving (SAP ArchiveLink)
• SAP data retention, SAP ILM (Information Lifecycle Management)
• Document digitization, automation, workflow-enablement and full-solution management with Content Server technologies from SAP (MaxDB & SAPdb: ArchiveLink), OnBase, OpenText (LiveLink)
• Delivered an SDLC project for Confidential in the commissioning of a 30-billion-USD oil-sands commissioning project.
• SAP Vendor invoice automation with imaging using diverse technologies: OpenText ECM/VIM, OnBase Content Server, SAP MaxDB Content Server, SAP ArchiveLink, OpenText LiveLink.

SKILLS:

• Strong hands-on SAP configuration and data migration/integration/ETL experience with all SAP modules: PP, MM, PS, FI, CO, SD, CRM/SCM:
• Solid hands-on SAP MM, PP configurations in SAP R/3 ECC 4.6, 4.7 and ECC6.0
• TSQL, SQL expert; stored procedures and database scripts
• Oracle SQL/TOAD for Oracle
• SAP CMS (Content Management Systems)
• PP master data (BOM, routings, work centers)
• MM /PM master data (materials, procurement, Accounts Payables, Finance/EAM Enterprise Asset Management)
• Hands-on: SAP LSMW expert Batch Input, Direct input, BAPI, IDOC/EDI
• Hands-on: EMIGALL
• Solid hands-on configuration AP (Finance/Accounts Payable), LIV (Logistics Invoice Verification)
• SAP ArchiveLink, SAP HTTP Content Server, NetWeaver/Basis
• SAP DMS (Document Management System)
• SAP S&OP Sales and Operations Planning
• MySQL database programming, MS Access to MySQL migration
• MaxDB, SAPDB in content management scenarios
• Working knowledge of SAP LO/SRM and SAP Solution Manager
• MS SQL Server 2005, 2008, 2012 ; SSMS, SSRS, SSIS
• SAP IS-Oil and Gas, Upstream (Industry Solution - Oil and Gas)
• SAP MM EWM
• SAP SCM 7.0 APO DP
• Hands-on with SAP suite of data tools: Data Services, Information Steward, Winshuttle
• Multi-person project management experience. Strong project and team driving skills. Project racking with MS Project and other project management tools. Delivered numerous training presentations.
• Systems migration, conversion and integration. Project management in Software Development Lifecycle.
• OpenText Archiving Server integration with SAP R3 for non-structured and structured data
• OpenText Content Server integration with SAP R3 for non-structured data
• MS SQL Server maintenance, configurations and programming (stored procedures)
• Senior SAP ILM consultant (Information LifeCycle Management)
• Senior SAP ECM consultant (Enterprise Content Management)
• SAP ArchiveLink/LiveLink consultant
• SAP SLO work (System Landscape Optimization)
• Amazon AWS Amazon Web Services server management/virtualization of servers
• Hands-on data mining, reporting and analysis in SAP. (Spend analysis, vendor performance)
• SCOR / Six-Sigma Training
• Extensive e-commerce infrastructure building experience
• Database management expert for RDBMS systems (SQL, Oracle)
• SAP Advanced Planning and Optimization (SAP APO): Demand Planning, Supply Network Planning, Multi-level Supply and Demand Matching, Production Planning and Detailed Scheduling, Transportation Management, and Global Available-to-Promise.
• SAP Forecasting and Replenishment (SAP F&R)
• SAP Event Management (SAP EM)
• Supply Network Collaboration (SNC) - formerly SAP ICH
• SAP Extended Warehouse Management (SAP EWM)
• Proven project leading capabilities with successful deliveries in SAP solution implementations
• Strong people skills. Personable. Always willing to stop work on hand to help others.
• Delivered training courses to end users with end results such as improved productivity and user confidence with new systems.
• Ability to co-ordinate multiple tasks with conflicting priorities
• Multiple life-cycle SAP implementations.
• Strong impact on cost reductions and productivity improvements in operations.
• APICS certified CPIM (Certified in Production and Inventory Management)
• Bi-lingual and fluent in both Chinese/English. Strong work background in China.
• Offshore development team management: experience as e-commerce consultancy development manager, managing offshore development resources on ASP.NET and SQL server technologies. Managed and supported multiple e-commerce website accounts.

WORK EXPERIENCE:

SAP DMS/PLM/ECM/KPro/ArchiveLink consultant

Confidential

Responsibilities:

• Designed an SAP DMS document-management-system in conjunction with SAP KPro Knowledge Provider and ArchiveLink to manage engineering CAD drawings, with Workflow built-in and ECM engineering change management
• Workflow customizations, ABAP work

Retained Advisor

Confidential

Responsibilities:

• As technical architect/lead of a data archiving solution, successfully designed and implemented the divestiture of two company codes within SAP ECC, with 8 plant codes.
• Archiving and deletion of two complete company codes to near-line storage with real-time production data-access.
• Saved client millions of USD by going with generic SAP-released Content Server version 6.50 based on MaxDB version 7.9, and ArchiveLink/SAP HTTP Content Server version 4.7, instead of buying off-the-shelf solutions from vendors
• DART, ABAP and BAPI development in conjunction with SAP BusinessObjects DataServices for data-prep work pre-archiving.
• Supporting ReadSoft Vendor VIM solution: a solution that's a scaled-down version of the OpenText VIM.
• This in-house solution uses SAP MaxDB Content Server, the ReadSoft SCAN/OCR solution, and SAP standard vendor invoice management functionalities. Designed PDF content lifecycle auto-destruction solution for client.

Retained Advisor

Confidential

Responsibilities:

• Lead the design of two alternative solutions to bridge the connection between SAP ECC and Nuxeo an open-source Java-based content server.
• Designed two solutions for document archiving/imaging.
• Solution 1: via SAP ArchiveLink and REST API acting as a servlet between SAP ECC and Nuxeo -- SAP certification of the interface design pending
• Solution 2: via ArchiveLink connection to Microsoft BizTalk Web Services Orchestration, then via a proprietary API connected to Nuxeo.

SAP Data Archiving Technical Lead

Confidential

Responsibilities:

• SAP technical lead for archiving two company codes out of the SAP system.
• The two company codes are in the same Controlling Area as the active company codes currently operating.
• Technologies used: ABAP programming, LSMW, SAP BODS BusinessObjects Data Services. SARA archiving, ADK archiving development kit, SAP DART
• Proof-of-concept on SAP ILM new licensing/ SAP Business Framework activation

SAP IS-U Load Settlements Data Migration Consultant

Confidential

Responsibilities:

• SAP Project Conversion Lead. Lead activities, plus hands-on data conversion activities in a project where SAP IS-U Load Settlements functionality is replacing Confidential Energy Vision Enterprise ( Confidential ).
• EMIGALL/LSMW data conversion and ABAP code development specifically for mass data loads. Data volume exceeds 10 billion records.
• Lead developer, SAP BODS -- BusinessObjects Data Services. Oracle backend datastore migrating to SAP ECC.
• Lead developer, SAP ABAP Function Modules for data migration from legacy systems into SAP ECC.
• The Alberta Load Settlement functions are a regulatory requirement as outlined in the Confidential Rule 021 Settlement System Code Rules.

SAP BODS/HANA Data Migration Lead

Confidential

Responsibilities:

• As a bridge resource, I lead the data migration effort from legacy Sage MAS 500, Oracle PLM, DBR+ shop-floor scheduling, and Salesforce.com data objects to SAP ERP ECC 6 EHP8 on HANA. I lead a team of 12 data specialists/SAP functionals/SAP business-process owners.
• Designed data-migration blueprint for SAP BODS (SAP BusinessObjects Data Services) with integrated connections to source data systems, and SAP IDOC migration roadmap.
• Delivering world-class technology, Avigilon’s industry-leading HD network video-management software, megapixel cameras, access control and video analytics products are deployed by more than 25 percent of the top 50 companies on the Fortune Magazine Fortune 500 list.
• Avigilon products are sold in more than 120 countries. Avigilon products are designed and manufactured in North America, providing customers with reliable and high quality technology.

SAP Master Data Consultant

Confidential

Responsibilities:

• Cleansing of SAP service master data, activity master data, material master data, vendor master data.
• Daily operations and triage of SAP service master data, activity master data, material master data, vendor master data.
• SCM Master Data. Cleansing, enrichment, strategy, architecture and implementation.
• ServiceNow StartNow Methodology for incident and service management in the MDM area
• Architect for data-enrichment project for 15,000 material master records using the MDM launcher/staging production system in Riversand and SAP.

SAP data migration consultant and lead

Confidential

Responsibilities:

• Leading SAP data migration for Vendor Master Data and Customer Master Data from Great Plains, Infor / Baan LN, and legacy SAP systems.
• Project Scope include 4 company codes with US and Canada service and manufacturing businesses, retrofit - rebuilding services business
• Responsible for driving a data team of a mixture of IT and business resources for Mock 1, Mock 2 and ACO Actual Cutover
• Data migration scope: MM, SD, FI/CO, stock balances, GR/IR, open POs... full spectrum data-migration into SAP, 4 company codes; SAP BP Business Partners for Vendors /Customers

Database integration architect

Confidential

Responsibilities:

• Leading integration efforts on consolidating data from Confidential P6 (Oracle cluster), Orbit OCCMS (MS SQL Server) and other heterogeneous sources of data into data marts and home-grown DW for reporting and DS decision support.
• SQL Server and other database technologies; SSMS, SSIS, SSRS, SSAS Data Services; SSIS integration services, Visual Studio data-package coding.
• Developed an application called EFAC Confidential Field Activity Collection System for capturing worker hours and categorizations according to contractor schedules; data is exported for PF productivity factor analysis for senior management. EFAC has an MS Access FE front end and Access backend; later upsized to SQL Server backend.
• Custom application built on C# and VB for invoice verification before SAP payment settlement

Senior SAP Data Archiving Consultant

Confidential

Responsibilities:

• System architect for an archiving solution for archiving SAP IS-U data onto an OpenText Content Server/Archive Server version 10.0
• OpenText Archiving Server integration with SAP R3: configurations
• SAP ILM data archiving integration with OpenText Content Suite
• Master data and transactional data migration from MS AX Dynamics, in a small acquisition transition. Setup of the EMIGALL project, ETL processes, legacy system deep-dive analysis, data quality control and monitoring, coordination of data cleansing, staff training, QC workshops, change management with the functional teams.