Profile

Mr. Swope specializes in the design and delivery of SAP solutions. He has over 18 years of experience implementing SAP solutions for global companies in the industries of retail, pharmaceuticals, and telecommunications. For the last 15 years, Mr. Swope’s primary focus has been lead and architect of SAP Retail solutions. Previously he worked on implementing SAP Project Systems (PS) and Investment Management (IM). Mr. Swope has been involved in all parts of the SAP implementation life cycle used under the ASAP, Waterfall, Agile & Kanban methodologies.

Skill Summary

Expert Architecture and Development of SAP Enterprise Data Warehouse and Analytical Solutions

Expert Architecture and Development of SAP Retail Solutions

Expert ABAP Programming using both Object Oriented and non-Object Oriented Methodology.

Expert SAP Integration, Performance Tuning, Upgrade/Patching Strategies and Landscape Design

Expert Developing and Communicating SAP Roadmaps and Long Term Planning

Expert Change Management Strategies for Operational and Project Scenarios

Expert in Project Management and Delivery of SAP Initiatives

Product Experience

Process Proficiencies:

Enterprise Reporting & Analytics, Retail Master Data Setup and Governance, Pricing & Promotions, Inventory Management, Domestic & Global Sourcing, Allocations, Merchandise Planning, Financial Accounting, CAPEX, Asset Accounting, Financial Reporting, China Import & Tax, Store Operations, Sales Audit, GRC, Change Management & Project/Program Management

SAP Systems & Products:

S/4 HANA to 1809 & SFIN, ECC, IS-Retail, CAR(PMR, OPP, POSDTA), BW 3.0 to 7.5, Business Objects XI 3.1 to BI 4.2, Fiori, F&R, BPC 10.1, EPM, PI/PO, LSMW, Solution Manager, SAP Gui, SAP NWBC, Traversity & SAP EP

Non-SAP Systems & Products:

PCMS, Toshiba ACE, Oracle 360, IBM Sterling Order Management, JDA Merchandise Management, Manhattan Associates Warehouse Management System &Smart Focus PivotLink

DW Applications and Databases:

SAP BW 3.0 to 7.5, HANA Studios, HANA, Oracle, SQL Server, DB2, MS Access

Modeling, ETL and Front End Tools:

Integrated Planning, Native HANA, CDS Views, BOBJ 4.X(CMC,LP,IDT, WEBI, Crystal, AO, Lumira, Design Studios, MOBI), BPC 10.1, EPM, Analysis for Office, Operation Data Provisioning (ODP), Smart Data Access(SDA), SAP Landscape Transformation (SLT), SAP Business Objects & Data Services(BODS)

Project, Testing & Misc Tools:

MS Word/Excel/Visio/Project,HP Quality Center(Mercury), Jira, Confluence, Autotask, Waypoint, MKS, Zena, Tibco, Mulesoft & Control M

Employer History

SAPCentric Solutions, LLC. August 2007 – Present

Owner & SAP Architect

SAP America July 2004 – August 2007

Senior BW Consultant

IBM Business Consulting Services October 2002 – July 2004

SAP Consultant

PricewaterhouseCoopers March 2001 – October 2002

SAP Consultant

Experience/Project Work

Industry: Retail Grocery Company – Edison NJ

Project Description/Scope: Implementation of S/4 1809 and CAR 3.0(POSDTA, UDF & PMR)

Role: SAP CAR Lead Duration: Mar 2019 – Present

Responsibilities/Deliverables: Responsible for SAP CAR solution and Integration to ACE POS system

Achievements:

Integration of Toshiba ACE POS TLOGs from 360 supermarkets generating average daily transaction count of 1 million transactions per store. Data integration included coupon to item linkage, stacked coupons, loyalty program details, balanced transactions, WIC details, Rain Checks and GS1 Coupon Bar Code translation.

Integration of ACE Accounting End of day and book keeper close files to POSDTA Totals and Financial transactions.

Advised on CAR/POSDTA/UDF/PMR road map and integration that included custom integration of Coupon Code/PMR Offer Id conversion and Coupon stacking to UDF Sales Time Series

Industry: Retail Children Apparel Company – Secaucus NJ

Project Description/Scope: CAR, PMR and OPP Implementation

Role: SAP Retail and Integration Lead Duration: Oct 2018 – Feb 2019

Responsibilities/Deliverables: Responsible for SAP Retail solution and Integration across the program

Achievements:

Designed Pricing and Promotions solution using CAR, PMR and OPP. Pricing scenarios included, MSRP, Promotions, Coupons and Markdowns.

Designed Integration solutions and roadmaps across functional areas and multiple releases

Deliver and Manage Cutover Strategies for SAP CAR/PMR/OPP on HANA go live

Advise on S/4 Hana roadmap approach from ECC

Developed a custom Reports: Asset History Sheet Report(AR02) & Missing Retail Price Report

Enhanced ME28 PO approval transaction and ME22N to include custom fields.

Industry: Retail Children Apparel Company – Secaucus NJ

Project Description/Scope: Process build and execution of a complete Merchandise Reclass

Role: SAP Retail Lead Duration: Aug 2018 – Oct 2018

Responsibilities/Deliverables: Responsible for Merchandise Reclass solution, building a playbook, leading and educating internal team and managing the project plan.

Achievements:

Built a detail run book for future Merchandise reclass involving SAP ECC/BW/POSDM, JDA Allocations/MFP, WMI, ECOM/DOM, PLM, APT, Store Systems, IBM ODM & EDW

Designed and coded an ABAP program to reclass over 48,000 styles expanding out to over 500,000 variants and prepacks, executing in under 4 hours.

Delivered with zero business impact

Industry: Retail Women Specialty Apparel Company – Columbus OH

Project Description/Scope: Supply Chain Bulk Inventory/In Region DC for China. BW on HANA, SFIN, CAR/POSDTA, ECC, BOBJ, and JDA

Role: BW/BI/HANA/CAR Reporting and SAP Integration Architect Duration: Nov 2017 – May 2018

Responsibilities/Deliverables: Responsible for solution integration and analytics delivery.

Achievements:

Integration of US SAP Inventory, Supply Chain and Allocations data into China SAP BW on HANA

Integration of EDI messages to track Handover, VAS, CIQ and other supply chain milestone dates

Integrate Planning solution for Article, Site and Article/Site metric modification and maintenance

Hana Models and SDA to integrated JDA and Transportation data

Integration of Sales data to consolidated financial reporting system Hyperion.

Automatic week shift for week 53 reporting

Integration of all data to self-service reporting on BI Launchpad using WEB and AO for Excel

Industry: Retail Women Specialty Apparel Company – Columbus OH

Project Description/Scope: Integration of China TMALL e-Commerce solution using Baozun as the OMS and Li&Fung as the WMS technology partners. BW on HANA, SFIN, CAR/POSDTA, ECC, BOBJ, and JDA

Role: BW/BI/HANA/CAR Reporting and SAP Integration Architect Duration: Jan 2017 – Sep 2017

Responsibilities/Deliverables: Responsible for solution integration and analytics delivery.

Achievements:

Ensure overall solution aligned to SAP Retail best practice and Client architecture

Provide solution guidance in:

oSales integration between Baozun OMS and SAP CAR

oPricing and markdown solution for new Internet Distribution

oInventory tracking between OMS, WMS and SAP

Enhance POSDTA data using customer extension

Design Inventory Sync reporting solution between Li&Fung WMS and SAP

Design reporting for new sales channel

Industry: Retail Women Specialty Apparel Company – Columbus OH

Project Description/Scope: SAP SFIN 1503,Fiori 1.0, BW 7.4 and CAR 2.0 rollout for Finance and Merchandising for the Greater China SAP enablement project.

Role: BI/HANA Reporting and Integration Architect Duration: Apr 2016 – Dec 2016

Responsibilities/Deliverables: Responsible for delivering SAP Reporting and Analysis solution.

Achievements:

BW 7.4 on Hana rollout with integration to SFIN 1503, Fiori, and CAR 2.0.

BW & Hana Data Models: Designed GL, CCA, AP, PS, FA, POS, Inventory Non Cum and Snap Shot, MM documents, Procurement, Traffic & supporting Master Data using ADSO and Composite Providers

BW/HANA Configuration: ODP data sources, Remote data access setup of MS SQL server tables for Integration of Store traffic data, Extractor and Variable Class Based BADIs, Development Standardization & BW/HANA Security

BOBJ: Integration of BI 4.1 to SAP BW and BI Launchpad as the reporting landing page.

BOBJ: Integration of CAR RDS Lumira reports as Fiori tiles.

Developed daily extraction of SAP data from China to US Data Lake.

Provided extensive training in the use of Webi and Analysis for Office Excel

Provide solution for dual ledger for US & China GAAP and Financial reporting for both ledgers

Provide Integration solution between China and US systems using VDI & SFTP.

Industry: Retail Grocery Company – Sacramento CA

Project Description/Scope: SAP BW rollout for merchandising project & BPC Financial Planning

Role: BI/HANA Architect Duration: Aug 2014 – Oct 2015

Responsibilities/Deliverables: Responsible for architecting BI solution to support the IS-Retail rollout for Merchandising, BPC and CAR.

Achievements:

Upgrades: BW from 7.3 on DB2 to 7.4 on HANA, BPC from 10.0 to 10.1 and from CPMBPC to HANABPC, POSDM from BI_CONT to RTLPOSDM

BPC: For CONSOL01 and PLAN01: BW configuration and transports, Package Link Management, UJFS file conversion, BPC Report conversions, BPC Security management both in BPC Console and ABAP roles, Data conversion and conversion to HANA enabled content.

BOBJ: Integration of BI 4.1 to SAP BW, BI Launchpad as the reporting landing page & BOBJ Security integration to BW

BW/HANA Configuration: ODP data sources, Oracle Virtual Tables using SDA, Extractor and Variable Class Based BADIs, Development Standardization & BW/HANA Security

BW & Hana Data Models: GL, CCA, AP, PS, FA, POS, Inventory, MM, Purchasing & Master Data.

Retail Process: Assisted in POSDM, Master Data, Purchasing, Inventory and Replenishment Design

Support: BW ETL, Bex Reporting, BOBJ Publications, BPC Package Links

PM/Leadership Advisement: HANA Usage scenarios(Enterprise vs Runtime), Upgrade & Migration Project Plans, BW Merchandise Project Plan, Resource Plans, BW Roadmaps, Executive/Management presentations, Change Management Solutions, CAR Analysis & MDM Analysis

Industry: Retail Outdoor Recreation Merchandise Company – Kent Washington

Project Description/Scope: There were 4 stages in the project

Stage 1: Stabilization of BW 7.0 implementation. Support data modeling for MAP implementation

Stage 2: Architect and develop a new BW EDW to support operational and strategic corporate reporting for: Store Operations, Sales Audit, Merchandising, Warehouse Management, Purchasing, Inventory Control, and Finance.

Stage 3: Migrate Merchandise adhoc reporting from legacy system onto SAP BW using Bex Web and SAP Portal.

Stage 4: Implement & integrate SAP SD data model for Sterling Order Management Implementation

Role: BW Architect & Technical Lead Duration: Oct 2010 – Dec 2014

Responsibilities/Deliverables: For each stage, responsible for architecting, leading BW team, project planning and overall delivery.

Achievements:

Designed and built a harmonized 5 TB EDW using a 3 tier Data Model (Staging/Business/Reporting)

Designed and built a Portal based self-service merchandise reporting system for over 400 internal users.

Designed and implemented development and data model best practices such as transformation common code consolidation into Utility ABAP classes, datasource & variable user exits into ABAP classes, common naming conventions & 3-Tier data architecture

Integration of POSDM into SAP BW data models and the WPUUMS, WPUTAB, WPUFIB IDOC integration into SAP ECC.

Achieved stabilization by correcting core retail KPI metrics, re-establishing business trust in SAP BW data

Improve performance of extract files from 20 hours to 4 hours.

Develop and enhanced to Integrated Planning MAP data models using integrated planning

Realign IS-Retail processes in ECC to ensure accurate data generation.

Assist in integration of BW data into BO Webi reports thru better query and Universe definitions.

Defined BW Security and User roles for content management of BW queries for SAP Portal and Single Sign On.

Assisted Basis with performance and system configuration guidance regarding memory management and server group configuration, increasing Database performance and reducing memory overflow system errors.

Defined BW security model and roles

Integrated SD and POSDM sales into one harmonized sales data model.

Provided strategic direction for system integration of Online sales data comparing the pros and cons between SD and POSDM as the interface into SAP.

Industry: Retail Women’s Apparel Company – Fort Myers Florida

Project Description/Scope: NetWeaver 7.0 BW implementation supporting ERP2005, POS DM, BW Analytics, MAP, Allocations and JDA for 3 Brands

Role: BW Architect, Technical Lead & Project Management Duration: Jan 2007 – Aug 2010

Responsibilities/Deliverables: Responsible for architecting, leading BW team, project planning and overall delivery.

Achievements:

Designed, lead and delivered a 10 Terabyte EDW supporting three brands which encompassed over 1000 stores, 3 Direct Channels, 1 distribution center, over 300K UPCs(variant articles) and 5 years of historic data supporting SAP COE, Inventory Controlling, Merchandise Procurement, Global Trade Compliance, Sales Audit, Allocations, Store Operation, Executive Reporting & Merchandise Planning(MAP).

Analyzed, reviewed, consolidated and migrated 800+ legacy reports to 200 SAP BW reports.

Managed Project timelines, resource assignments, development deliverables, data conversions from Blue Print to Production Support for the following go lives: 3 SAP BW/ECC, 3 JDA Allocations, 1 Article Restructure, 1 SAP Allocation/Size Scaling and 1 JDA Size Scaling.

Designed and built interfaces to support JDA functionalities in Allocations, Size Scale, Channel Clustering and Enterprise Planning.

Provided guidance, analysis and direction on integration of technology and business processes including SAP BI, SAP ECC, JDA, POS and other business systems

Designed and implemented development and data model best practices such as transformation common code consolidation into Utility ABAP classes, datasource & variable user exits into ABAP classes, common naming conventions & 3-Tier data architecture

Assisted in the integration of POSDM into SAP BW data models and the WPUBON, WPUTAB, WPUFIB IDOC integration into SAP ECC.

Assisted Basis with performance and system configuration guidance regarding memory management and server group configuration, increasing Database performance and reducing memory overflow system errors.

Developed Data Model functionalities that included:

oAccurate sales costs matching FI Cost of Goods Sold.

oGross Margin match between FI and Merchandising.

oMarkdown(MD) reporting for Permanent MD, Temporary MD and Discounts.

oAbility to track purchasing, inventory and sales by any promotions, past, present or future

oStock Transport Order analysis for allocated not shipped measure as well as In transit from Warehouse.

oBalanced Stock Ledger Reporting

oAbility to report on Article, Style, Style/Size & Style/Color granularities and individual attributing of first/last goods receipt date, first/last markdown date, first/last sales date, price status and retail price.

oAnalysis of purchase orders, inventory and sales by prepacks and components of prepacks for units, cost and retail.

oAssociation Analysis for comparative sales reporting.

oAnalysis by store category/groups

Integrated Planning solution for management of Size Curves and integration into JDA Allocations.

Integrations and Data Model and queries to support Allocations Strategies in ECC.

Integrations into of Sales and Inventory data between SAP and JDA

Industry: Retail Convenient Store Company – Media, Pennsylvania

Project Description/Scope: NetWeaver 2004s BW implementation supporting ERP2005, SCM F&R 5.0, POS DM, Enterprise Portal and Integrated Planning.

Role: BW Co-Lead Duration: Jun 2005 – Dec 2006

Responsibilities/Deliverables: Responsible for architecting, co-leading BW team, project planning and overall delivery. Conducted and documented Blueprint workshops in the areas of AP, AR, GL, PCA, AA, PS, F&R, Inventory, Procurement and Executive Reporting.

Achievements:

Successful go-live of BW Reports to 560 Stores, Finance, Store Operations, F&R and Executive Management groups.

Implemented data models for Inventory, Procurement, DPP and F&R.

Replaced manual Comparable Store status calculation with an automated BW solution.

Successfully migration of the Netweaver BW software from ramp-up to final release which involved the repetitive upgrade of 7 support stacks. (SP5 – SP12)

Trained client resources to manage and administer the BW environment.

Education & Certification

Bachelors of Arts, Temple University – Philadelphia, Pa

SAP BW 7.0, 3.5 & 3.0

Citizenship: U.S. Citizen

Mobility: U.S. Passport

Languages: Fluent in English, written and spoken.

Contact this candidate