We provide IT Staff Augmentation Services!

Bi/hana/car Reporting And Sap Integration Architect Resume

Columbus, OH

SUMMARY

  • Confidential specializes in the design and delivery of SAP Retail solutions.
  • He has over 17 years of experience implementing SAP solutions for global companies in the industries of retail, pharmaceuticals, and telecommunications.
  • For the last 15 years, Confidential ’s primary focus has been lead and architect of SAP Retail analytics solutions using SAP BW, BOBJ, BPC, CAR, HANA & SAP Retail.
  • Previously he worked on implementing SAP Project Systems (PS) and Investment Management (IM).
  • Confidential has been involved in all parts of the SAP implementation life cycle used under the ASAP, Waterfall, Agile & Kanban methodologies.
  • Expert Architecture and Development of SAP Enterprise Data Warehouse and Analytical Solutions
  • Expert Architecture and Development of SAP Retail Systems
  • 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

TECHNICAL SKILLS

Functional Areas: IS-Retail (Master Data, Pricing & Promotions, Inventory Management, Purchasing, Replenishment, Allocations, POSDM, CAR, MAP), Logistics (SD, MM, PP, QM), FI-GL, FI-COProject Systems, Investment Management & Fixed Assets

Data warehouse: SAP BW 7.5 & 7.4 powered by HANA, Native HANA, SAP BW 7.X, SAP BW 3.X

Database: SAP HANA, Oracle, SQL Server, DB2, MS Access

Modeling, ETL and Front End Tools: BW 7.X(All BW Modeling & Reporting tools), BOBJ 4.X(CMC,LP,IDT, WEBI, Crystal, AO, Lumira, Design Studios, MOBI), HANA Studios, BPC 10.1, EPM SAP 7.X Gui, FIORI, SAP Business Client, SAP Portal, Operation Data Provisioning (ODP), Smart Data Access(SDA), SAP Landscape Transformation (SLT) and SAP Data Services

SAP Systems & Products: S/4 HANA, SFIN 1503, ECC, IS-Retail, CAR, F&R, POSDM, PI, BPC & Portal

Non-SAP Systems & Products: IBM Sterling Order Management, JDA Merchandise Management, Manhattan Associates Warehouse Management System & Smart Focus PivotLink

Project, Testing & Misc Tools: MS Word/Excel/Visio/Project, SAP Solution Manager, HP Quality Center(Mercury),Jira, Confluence, Autotask, Waypoint, MKS, Zena, Tibco, MulesoftEmployer History

PROFESSIONAL EXPERIENCE

Confidential - Columbus OH

BI/HANA/CAR Reporting and SAP Integration Architect

Responsibilities:

  • Integration of US SAP Inventory, Supply Chain and Allocations information into China SAP/BW
  • Integration of EDI messages to track Handover, VAS, CIQ and other supply chain milestone dates
  • Enhancement of Master data attribution to Article, Site and Article/Site
  • Automatic Daily Comp Sales attribution with Temp Closing Logic
  • Integration of Sales data to consolidated financial reporting system Hyperion.
  • Automatic week shift for week 53 reporting

Confidential - Columbus OH

BI/HANA/CAR Reporting and SAP Integration Architect

Responsibilities:

  • Ensure overall solution aligned to SAP Retail best practice and Client architecture
  • Provide solution guidance in:
  • Sales integration between Baozun OMS and SAP CAR
  • Pricing and markdown solution for new Internet Distribution
  • Inventory tracking between OMS, WMS and SAP
  • Design Inventory Sync reporting solution between Li&Fung WMS and SAP
  • Design reporting for new sales channel

Confidential - Columbus OH

BI/HANA Reporting and Integration Architect

Responsibilities:

  • BW 7.4 on Hana rollout with integration to SFIN 1503, Fiori, and CAR 2.0.
  • BW 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.

Confidential - Sacramento CA

BI/HANA Architect

Responsibilities:

  • 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 Data Models: Designed 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

Confidential - Kent Washington

BW Architect & Technical Lead

Responsibilities:

  • 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
  • Assisted in the 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 as well as introduced additional reporting capabilities such as:
  • Accurate sales costs matching FI Cost of Goods Sold.
  • Gross Margin match between FI and Merchandising reports.
  • Accurate Markdowns Analysis by breaking out POS Markdowns vs. Permanent Markdowns.
  • Ability to track purchasing, inventory and sales by any promotions, past, present or future.
  • Historic Article attributing of retail price and prices status(Full Price, Markdown, Promotion).
  • Insight to product damage and validation of the negotiated Vendor Returns Allowances.
  • Analysis of domestic and international freight on Vendor Purchase Orders.
  • Balanced Stock Ledger Reporting thru accurate Inventory valuation and units and correct bucketing of inventory movement types
  • Ability 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.
  • Improve performance of extract files from 20 hours to 4 hours.
  • Support and make enhancements to MAP data models using integrated planning
  • Configure ERMA model to client definition
  • 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.

Confidential

BW Architect, Technical Lead & Project Management

Responsibilities:

  • 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
  • Accurate sales costs matching FI Cost of Goods Sold.
  • Gross Margin match between FI and Merchandising.
  • Markdown(MD) reporting for Permanent MD, Temporary MD and Discounts.
  • Ability to track purchasing, inventory and sales by any promotions, past, present or future
  • Historic Article attributing of retail price, prices status(Full Price(FP), MD1, MD2, Clearance) and promotion status(FP, FP Promo, MD, MD Promo).
  • Stock Transport Order analysis for allocated not shipped measure as well as In transit from Warehouse.
  • Balanced Stock Ledger Reporting: Beginning Balance + Purchases - Vendor Returns + Distributions In - Distributions Out + Transfers In - Transfers Out - Sales + Customer Returns – Shrink – Scrap + Other Adjustments = Ending Balance. Includes Cost Revaluation and Retail Revaluation adjustments for cost and retail measures.
  • Ability 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.
  • Analysis of purchase orders, inventory and sales by prepacks and components of prepacks for units, cost and retail.
  • Data model to support Mailers(Catalog) reporting that overlap in time and contain same Articles.
  • Association Analysis for comparative sales reporting.
  • Analysis by store category ranks.
  • Data Model to support management of Size Curves and integration into Allocations using Integrated Planning.
  • Data Model and queries to support Allocations Strategies in ECC.

Confidential – Pennsylvania

BW Co-Lead

Responsibilities:

  • 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.

Hire Now