We provide IT Staff Augmentation Services!

Sap Bw/hana Architect Resume

3.00/5 (Submit Your Rating)

VA

SUMMARY:

  • SAP BW/HANA Certified Architect / Project Manager with over 20 years of SAP experience in managing and leading projects in SAP BW/HANA and ECC with top Fortune 500 companies in Pharmaceuticals, Consumer Product, Banking and Finance industry and Federal Clients.
  • Proven ability to plan, organize and execute BI projects on quality, in time and under budget.
  • Seven full SAP BW life cycle implementations. Managed all aspects of SDLC, including but not limited to business and technical assessments, requirements determination, gap analysis, deployment of complex back and front - end BI solutions, testing, issue resolution, go-live assistance, validation and client training.
  • Recognized as BW-SME and point of contact on many projects. Managed and lead successful implementations in multiple domains like Order to Cash, Forecast to Stock, Record to Pay, Record to Report, Dashboards, Funds Management, Supply Network Planning (SNP), CO-PA, SMARTOPS, Finance and Controlling solutions on various SAP projects.
  • Author of various articles published in BW Expert Magazine.
  • Recognized as BW-SME and point of contact on many projects
  • Expert in detailed analysis needed to solve complex problems using innovative, out-of-the-box solutions stretching the capabilities of SAP BW/HANA and ECC.
  • Expert in performance tuning of BI and HANA based solutions.
  • Motivated, responsible and capable of handling multiple, complex assignments at the same time. Excellent project management, communication, and inter-personal skills.

TECHNICAL SKILLS:

  • SAP BW (3.0B/ 3.1/3.5/7.0/7.3/ 7.4 ), BW on HANA
  • SAP ECC - in-depth knowledge of business processes and interaction between various ECC domains - SD/MM/FI/FI/CO/PP/WM/CO-PA/FM
  • HANA (SP9/SP10), HANA Side-Car, HANA Live, RDS, ERP Accelerators, BAA, HANA Studio Development - Attribute, Analytic & Calculation views, HANA SQLScripts, CE Scripts, Procedures and Triggers, HANA Lifecycle Manager, HANA live Brower and Extension Assistant, HANA Live Query Views
  • Data Provisioning (Trigger based ETL/SLT SAP, Business Objects Data Services), Universe design
  • SAP Reporting tools (Crystal Reports, WebI, Dashboard Designer, Lumira, Fiori, BEX) & SAP Programming - ABAP, BADI, BAPI

PROFESSIONAL EXPERIENCE:

SAP BW/HANA Architect

Confidential, VA

  • Assessment of AESIP/GCSS-Army BW environment for performance improvements
  • Provided SAP Best Practices document / recommendations for BW housekeeping tasks to reduce data footprint and improve performance
  • Provided recommendations for conversion of Equipment Text from full to Delta load and conversion of FULL GMMDDS MDMA DAILY to a pseudo-delta extractor to reduce DSO Activation time
  • Enabled parallelization of AEEMKEY loads to reduce initial load time from 70 hours to under 3 hours.
  • Provided recommendations on improving performance of expensive SQL statements from AWR reports

SAP BW/HANA Architect

Confidential, VA

  • Architect for BW on HANA data models for Materials Management, Purchasing and Finance functional areas.
  • Design of Asset and Asset pricing data models in BW based on pricing conditions for DLA materials.
  • Design of Item Detail infomodel for FEDMALL with data for multiple sources. The challenge was to bring in millions of rows to report on via wrapper views in HANA within DLA specified SLA .
  • Responsible for performance tuning of existing data models to drive efficiencies in data loads, automation of manual processes in DLA and query response time
  • RQH parallelization - reduction of load times from 10 hours to under 3 hours
  • APR/ACF/DUE IN automation - Highly customized solution to trigger BW loads from ECC programs to eliminate manual intervention
  • Item detail MTD Quantity performance tuning - reduced load time from 2.5 houes to under 2 minutes
  • Performance tuning of HANA datamodels to reduce query response times in multiple areas.

SAP BW/HANA Architect

Confidential, VA

  • Advisor to Technical Managing Director (TMD) on HANA Sidecar implementation and BW on HANA migration strategy (In-place DMO of SUM).
  • Support and enforce SDLC and Software Quality Assurance processes.
  • Review SI provided roadmap and two-phase project plan for HANA Sidecar and BW on HANA migration. Advise PMO Director and functional Managers on schedule, staffing levels and budget to meet project goals.
  • Provide recommendations for pre/post migration activities, risk assessment and mitigation strategy, SI deliverables review,
  • Provide sizing for HANA Side car and BW on HANA. Work with SAP and HP to validate vendor offering.
  • Present alternatives to manage data growth in the current environment to extend life of existing BWA appliance (reaching capacity and EOSL) by proposing redesign for three existing BW data models for performance and redundancy
  • Present HANA use cases for SAP RDS (Financials) and Business Application Accelerators (BAA) for HANA Sidecar implementation, Database Tiering options post-migration to manage BW data growth.

SAP BW/HANA Architect

Confidential, New Orleans

  • Responsible for all client deliverables for the SAP BI and HANA environments. Managed a team five of BI resources - resource assignment, tracking progress and risk mitigation for deliverables, review of all technical development to ensure content and quality of BI reporting solution.
  • Managed project to reconstruct Commitment strings for pre-2013 data in the Funds Management. This was critical to determine Funds management Obligation document for various reference transaction types in support of various reporting requirements in HANA.
  • Managed development of “Un-liquidated Obligations” Data model in HANA Side Car scenario. Developed procedures / triggers for updating custom HANA tables in this model.
  • Managed project to develop high volume extracts via procedures in HANA for Funds Management data, triggered from BW process chains.
  • Led project to evaluate and improve performance of HANA Side-car replication process
  • Led project to improve performance of HANA data models and existing SAP BI environment.
  • Led development of a reconciliation program for Funds Management tables in ECC, BW and HANA track SLT data replication issues as reported by users.
  • Developed Business Application Accelerators solution for long running custom SAP ECC reports to improve performance by re-directing selects off HANA Side-car replicated tables.
  • Design of reporting solutions in SAP Lumira (POC) for ULO obligations

SAP BW/HANA Architect

SAP Project - CDC, Atlanta

  • Architect for SAP’s Assessment of CDC’s BI environment for robustness, scalability and performance from a reporting and data modeling perspective.
  • Delivered blueprint for redesign of existing data models to manage projected data growth without impacting reporting performance.
  • Responsible for providing ‘immediate’ solution for 3 critical business issues identified by CDC from a reporting perspective in CRM and SD. Performance tuning of BOBJ WebI queries to reduce reporting response time by over 80%
  • Presented business case for implementing HANA based reporting solution to client.

SAP BW Architect / BW-SME

Confidential

  • Implemented BI Strategy for SMARTOPS project. The data model for lag-based material aggregation identifies Historical / Future forecast and Corrected shipment history to source a multi -echelon SMARTOPS tool to determine safety stock for materials across J&J supply chain. The new architecture reduced data load times from 60 hours to 6 hours, facilitating on-demand, daily loads
  • Managed a team of developers to deliver Vendor Performance KPI Metrics
  • Managed project to improve performance of SNP data model, reducing load times by as much as 40% using out-of-the box solutions.
  • Manage Preparation/Delivery of Unit test plans and Quality Test plans for go-live.

Senior Solutions Consultant / BW-SME

Confidential, Montvale, NJ

  • Development of BI Strategy for Global reporting based on single-code base design
  • Managed a team of developers to redesign data models for Debtor Management, Engagement Management and Time and Expense Management for performance and scalability.
  • Conducted impact analysis of local CO-PA data model for Global implementation of BI solution
  • Managed a team of off-shore resources to resolve HPQC tickets

SAP BW Architect

Confidential, Milwaukee, WI

  • Led a team of BI resources responsible for BI Blueprint covering Record-to-Report, Order-to-cash, Procure-to-Pay, CO-PA for ‘Project Foundation’
  • Managed development of Data Models for OTC, RTP, R2R, Financial Reporting, CO-PA and Query Mockups for end user reporting after extensive meetings with Process Leads and Business Owners.
  • Activated relevant BI Content for prototyping, Demo and development of Queries for:
  • Consolidated Balance Sheet (Gross and Net)
  • P&L reporting (Gross and Net )
  • Accounts Receivable and Accounts Payable reporting
  • CO-PA reporting by Business segment, Customer and Product, Constant Currency reporting to track foreign exchange variances in Revenue, Expenses and NOP.

SAP BW Architect/Project Lead

Confidential

  • Recognized point of contact for all technical issues across all BI models. Responsible for final review of all BI deliverables to client specification. Manage system-wide BW data load performance strategy to meet SLAs
  • Managed development of Forecast to Stock (FTS) and Order to Cash (SD) data models
  • Responsible for delivery of one-of-a-kind “Inventory Days of Sale”, Non-working and SLOB (Slow-Moving and Obsolete) Inventory, Kanban Supplier Trigger and Forecast BI reporting solution.
  • Managed a team of BI developers working on data models for reporting Closed Capital and Expenses, Forecast and Authorized Amounts, Latest Budget Estimates and Commitments against Internal Orders.
  • Led Development of Dashboard for Financial Daily Sales using WAD (Web Application Designer Tool)
  • Design of out-of-the box solutions not available in Standard SAP BW. Dynamic determination of planning fence time-scale in BW from APO planning book
  • Manage Development of custom BADIs (Published Work) to manipulate conditional processing of Process Chains for performance and data flow integrity.
  • Client Training provided at client site on Use of ABAP in Object-Oriented context and efficient use of ABAP in SAP BW context
  • Manage Unit test plans and Quality Test plans for go-live.

SAP BW Senior Consultant

Confidential

  • Managed a team of BI resources to redesign J&J Pharma’s DPDP (Direct Purchase/Direct Procurement) data model to in corporate Brokerage data of Cardinal Healthcare (a major J&J customer). The data model required increasing the granularity of the existing data model to report demand based on customer purchase orders.
  • Lead development of business logic for front-end transactions to allow Brokerage reallocation percentages from one ship-to to another and time-dependent adjustment of quantity allocation for various ship-to/material combinations.
  • Manage Code reviews to ensure high performance in ABAP code.

SAP BW Senior Consultant

Confidential, Washington D.C

  • Data Modeling/Technical Lead for Redesign of entire Resource Management Infoarea (Employee/Sector Theme/ Portfolio and Ratings Cubes)
  • Managed project for enhancement of SAP Funds management extractors for FI/CO/Commitment items
  • Development of new strategy to eliminate manual load of Dashboard data using transactional ODSs.. This reduced downtime from 48 to 4 hours at month end.
  • Responsible for Performance tuning of data loads.
  • Led effort to develop a set of BW utilities to improve day to day operations
  • Developed BADI to create custom functions (Published Work) to remove unwanted characters from data feeds of external sources on Oracle database.

Senior BW & ABAP Consultant

Confidential, PA

  • Design and Development end-to-end Inter-company Invoicing/WAII Interface
  • Responsible for development of various interfaces and Custom Dialog transactions for SD/MM/WM/QM/FI/CO areas
  • Developed custom BMV0 functionality to permit multiple session loads via direct input for material master data

Senior SAP Consultant

Confidential, New Jersey

  • Development of custom reports in the OTC business area.
  • Configuration of Partner Profiles/ IDOC Extensions and modifications

SAP ABAP/4 Consultant

Confidential, CT

  • Custom report design in FI/CO area
  • Development of a very complex transaction to bring global general ledger 8A in synch with daily and monthly ledger for Residual Funding Analysis
  • Verify RFA cost centers and profit centers against master data in ECC.

Senior Process Engineer

FMC CORPORATION / ABB

  • Design and development of mathematical models to improve plant operations all over US. Process optimization using Ultramax software

We'd love your feedback!