Frank (Bin) He
********@*******.***
Cell: 647-***-****
Toronto, Ontario
CAREER OBJECTIVE
Seeking a SAP SD/MM consultant position to work closely with the technology team where my knowledge in SAP and consulting skill can effectively contribute to successful and advantageous operation of the organization.
SUMMARY OF QUALIFICATION
Over 5 years SAP function consulting experience and over 7 full cycle plus multiple mini size SAP Implementation Projects in SD/MM modules. Expertise in Requirement Collecting, Blue Print Designing, Implementing, Unit/Integration Testing, User training, Go Live supporting and Report Developing; Expertise in Order Management, Shipping, Billing, Pricing, Output Determination, Procurement and Integration to PP and FI, MM Master Data, Purchasing, Inventory Management, Logistics Invoice Verification, Availability Check, Credit Management, Inter Company Business Process, Returns Processing; Strong experience in Function SPEC, SQL (SQLEXPLORER), EDI, IDOCS, RFC, LMSW, VOFM routines, ABAP, BAPI, PI, IS such as Retail (Grocery) and AFS.
PROJECTS
Project 1: SAP Implementation of SD/MM module (from project preparation to go live support)
Title: SAP SD/MM Consultant (Contract with Deloitte)
Project Duration: Oct, 2015 to May, 2016
Company: Josiny Inc.
Location: Wenzhou, China
Josiny is famous national wide Women Fashion/Shoes Corporation in China, with nearly over 30 sub-companies, 1500 corporate stores and franchises. The SAP Implementation Project including SD, MM, PP, SCM and BI has been considered the largest SAP Implementation in Chinese fashion industry in 2015. It is also one of critical projects for Deloitte Consulting.
Implement business needs including: Sales & Distribution and Material Management and oversee the project activities through project life cycle (Project Preparation, Blue Print, Realization, Final Preparation and Go Live&Support);
Work as key member to identify sources of problems and initiatives, recommend new solutions and develop test scripts, execution plan and troubleshoot methodology. Maintain productive relationships between consulting team and business teams to facilitate cross-team communications;
Configure and customize enterprise sales and distribution structure, master data in different areas, sales order types, item categories, schedule line categories, deliveries, billing types, invoices, output determination, partner determination, text determination, account determination, copy control, availability check, credit management, intercompany business process, procurement, material substitution, LSMW for various upload, credit control area, credit groups, data determination, VOFM routines, purchasing, inventory management, logistics invoice verification and integration to PP and FICO;
Configure pricing master data, condition types, access sequences, pricing procedure, condition supplements, new fields to the pricing structures (KOMP,KOMK);
Configure IDOCS, RFC and other interfaces to integrate both between Retail and AFS and to other systems such as IPOS(store), OMS, SPS, DMS and SCM;
Architect implementation plan, write function SPECs and work closely with developers about enhancements and new program development;
Write the test scripts, train SAP super users and support other activities after go live.
Project 2: SAP SD module implementation
Title: SAP SD Consultant (Contract with Deloitte)
Project Duration: Sep, 2015 to Oct, 2016
Company: Ellesay Inc.
Location: Shenzhen, China
Ellesay is one of top 6 fashion corporations by market share in China. It owns over 400 corporate stores and franchisees.
Analyze and evaluate current systems, benchmark best practices and recommend solutions to improve the use and execution of business systems applications
Troubleshoot all configuration problems in enterprise sales and distribution structure, master data in different areas, sales order types, item categories, schedule line categories, deliveries, billing types, invoices, output determination, partner determination, text determination, account determination, copy control, availability check, credit management, intercompany business process, procurement, material substitution, LSMW for various upload, credit control area, credit groups, data determination, VOFM routines, purchasing, inventory management, logistics invoice verification and integration to PP and FICO;
Support cross-team activities such as accounting Month-End preparation and material master data corrections
Organize and hold trainings to business stakeholders on SAP new functionalities
Project 3: SAP SD module Wave 2 Rollout
Title: SAP SD Consultant (Contract with Deloitte)
Project Duration: Jul, 2015 to Sep, 2015
Company: Ribo Fashion Ltd.
Location: Shanghai, China
Ribo is famous national wide Women Fashion Corporation in China, with nearly over 500 corporate stores and franchises. The SAP SD module Wave 2 Rollout focus on different updates and interfaces to other systems.
Communicate with the business teams, gather business requirements and design business processes;
Configure IDOCS and other interfaces to integrate both between Retail and AFS and to other systems such as IPOS(store), SCM and X2(BS);
Customize enterprise sales and distribution structure, master data in different areas, sales order types, item categories, schedule line categories, deliveries, billing types, invoices, output determination, partner determination, text determination, account determination, copy control, availability check, credit management, intercompany business process, procurement, material substitution, LSMW for various upload, credit control area, credit groups, data determination, VOFM routines, purchasing, inventory management, logistics invoice verification and integration to PP and FICO;
Customize pricing master data, condition types, access sequences, pricing procedure, condition supplements, new fields to the pricing structures (KOMP,KOMK);
Architect implementation plan, write function SPECs and work closely with developers about enhancements and new program development;
Support business users desk issues, interact with the users to understand the business issue and provide the solution on daily manner after system go live;
Write the test scripts, train SAP super users and support other activities after go live;
Project 4: SAP Implementation of Pricing Procedure in Wave 5 Rollout
Company: Loblaw Companies Ltd.
Location: Brampton, Canada
Conduct many workshops to gather the business requirement and meet business process owners and departmental heads to identify the business requirement;
Analyze current Pricing Analytics Team as-is business process and mapping it to to-be business processes by identifying the gaps;
Draft functional requirement specifications for pricing process and prepare dataflow diagram for all of the business processes;
Prepare unit test scripts and checklist to be included in the functional specification.
Help design and test the pricing execution and identify bugs in price procedure, condition types, access sequence and pricing tables;
Prepare test scripts, support testing activities and work on training;
Train testers to execute the test steps in SAP and record the test results;
Project 5: SAP Competitor Base Pricing Calculation Work Bench
Company: Loblaw Companies Ltd.
Location: Brampton, Canada
Host business meetings for business process owners to identify the business requirement;
Analyze current Pricing Analytics Team as-is business process and map it to to-be business processes by identifying the gaps;
Work with Supply Chain Cost Team to identify data flow of cost records;
Prepare functional specification for the development of reports and interfaces;
Prepared unit test scripts and checklist to be included in the functional specification;
Help design and test the pricing execution and identify bugs in price procedure, condition types, access sequence and pricing tables;
Prepare test scripts for the Sales and Distribution.
Project 6: SAP Enterprise Structure Adjustment
Company: Loblaw Companies Ltd.
Location: Brampton, Canada
Analyze incidents ticket about the potential risk of current setup for one division with team;
Meet business team to collect the business requirement;
Analyze current Supply Chain as-is business process and mapping it to to-be business processes by identifying the gaps;
Help define Supply Chain, Pricing Analytics, Business Process Expert and Master Data team’ priories and schedule of the projects;
Help draft functional requirement specifications;
Prepare dataflow diagram for all of the business processes. Help correct Sales Organization and Distribution Chanel configuration for this assigned business division;
Prepare test scripts, support testing activities and work on training.
Project 7: SAP Master Data Record Adjustment
Company: Loblaw Companies Ltd.
Location: Brampton, Canada
Help analyze incidents ticket;
Collect business requirement and meet business process owners and departmental heads to identify the business requirement details;
Analyze impact on different Teams as-is business process and map it to to-be business processes by identifying the gaps;
Work with different teams such as Supply Chain, Pricing Analytics, Business Process Expert, Master Data team for adjustment about articles split.
Collect old data records and transfer to new split articles;
Prepare unit test scripts and checklist to be included in the functional specification;
Train testers to execute the test steps in SAP and record the test results;
WORK EXPERIENCE
Deloitte China
Jul 2015 to now
SAP SD/MM Consultant
Implement business needs including: Sales & Distribution and Material Management and oversee the project activities through project life cycle (Project Preparation, Blue Print, Realization, Final Preparation and Go Live&Suport);
Work as key member to identify sources of problems and initiatives, recommend new solutions and develop test scripts, execution plan and troubleshoot methodology. Maintain productive relationships between consulting team and business teams to facilitate cross-team communications;
Configure and customize enterprise sales and distribution structure, master data in different areas, sales order types, item categories, schedule line categories, deliveries, billing types, invoices, output determination, partner determination, text determination, account determination, copy control, availability check, credit management, intercompany business process, procurement, material substitution, LSMW for various upload, credit control area, credit groups, data determination, VOFM routines, purchasing, inventory management, logistics invoice verification and integration to PP and FICO;
Configure pricing master data, condition types, access sequences, pricing procedure, condition types, pricing exclusion, condition supplements, new fields to the pricing structures (KOMP,KOMK);
Configure EDI, IDOCS, RFC and other interfaces to integrate both between Retail and AFS and to other systems such as IPOS(store), OMS, SPS, DMS and SCM;
Architect implementation plan, write function SPECs and work closely with developers about enhancements and new program development;
Write the test scripts, train SAP super users and support other activities after go live.
Loblaw Companies Limited
Jun 2011 to Jul 2015
SAP Super User – Category Management Team & Pricing Team
Work through Scope definition, Requirements, Realization, and Go-Live phases;
Collect business requirements from business users and document business requirements to resolve issues, communicate the progress and status during the realization phase;
Support SAP configuration, customization and integration;
Support pricing procedure design and maintenance price execution;
Develop and execute Unit Test Plan activities (plan, prepare, execute, document test results);
Test configured transactions and create test data for related transactions;
Prepare and execute Go-Live plan and activities;
Support incident tickets on Day-to-Day business;
Discount car and truck rentals Limited
Sep 2008 - Apr 2011
Intermediate Business Analyst, Pricing and Revenue Management
Work with CEO to manage business development specialists, account auditors, internal sales associates, customer care specialists, and call centre agents and manage multiple Sale Channels and monitor business flow including call center, website and local stores;
Design and built Macro with VBA, I-Macro tools to automate reporting processes resulting in a 26.6% efficiency increase;
Analyze data using Query and prepare Business Performance Report, debug if needed and reviewed accuracy.
AWARDS
2016: Best Performance Award for SAP Consultant
Honored by Josiny Inc.
EDUCATION
2004-2008: University Of Toronto
Honors Bachelor of Science
Specialist: Actuarial Science; Major: Economics
2013-2014: Pures College
SAP Certification Study - Sales and Distribution Module
SAP Certification Study - Material Management Module
LANGUAGE
English and Chinese