We provide IT Staff Augmentation Services!

Sap Hana Migration Consultant Resume

5.00/5 (Submit Your Rating)

Harrisburg, PA

PROFILE:

  • SAP certified Senior BI/BW/HANA/ABAP Architect/Lead/Developer having around 24 years of Information technology experience and 22 years of SAP consulting experience with various industries implementing SAP BI/BW/HANA/ABP and SAP ECC. 6 years of business experience in process industries in different roles.
  • Good knowledge of layout, customization and data extraction methods (ETL) into SAP NetWeaver Business Intelligence/Business Warehouse/HANA from SAP and Non - SAP systems.
  • Hands-on experience in the design, development and testing of Multi-Dimensional Data Models (OLAP), Semantically Partitioned Objects (SPO), InfoProviders, VirtualProviders, MultiProviders, Transient Providers, Data Store Objects (DSO), InfoSets, Compression of InfoCubes & creating Aggregates for improving Query/Report performance, Hierarchies, InfoObjects, DataSources, InfoSources, Extract Structures, Enhancements to DataSources, Generic DataSources, Confidential ’s, User Exits (ABAP Extractors), LIS Extraction (LIS), Logistics Cockpit (LO), Transfer rules, Update rules, Transfer routines, Data Transfer Process (DTP), Transformations, Start routine, End routine, Expert routine, Remodeling tool box, Open hub Service, Data Warehousing Workbench, BEx Analyzer, Web reporting, Web Analyzer, Web items, Web templates, Web Application Designer, Report Designer, Precalculation Server, Visual Composer, Analysis Process Designer (APD), Operational Data Provisioning (ODP), BI Portal, Prequery, Report-to-Report Interfaces (RRI), Work books, Virtual Characteristics and Key figures.
  • Hand-on experience with in-memory technologies like Native HANA, HANA Enterprise, BW on HANA, HANA Sidecar and HANA Live. HANA modeler experience includes creating Composite Providers, Open ODS Views, CDS Views, Advanced Data Store Objects, HANA Views (Attribute, Analytical, and Calculation), Graphical modeler and CE functions. Extracted data from ECC and created reports using SAP Landscape Transformation Replication Server (SLT). Created reports on external Databases using Smart Data Access (SDA). Business Objects Data Services (BODS) is used as an ETL from extracting data from external systems.
  • Deep knowledge and understanding of SAP FI/CO, MM, SD, HCM, PS, IM, PP and SCM modules and business processes. Thorough knowledge of BW product life cycle that includes prototype/design/development/configuration, quality testing/defect resolution, deployment/go-live, and post-production support/user . Well versed with ASAP /Agile/Activate project methodologies and followed BW/BI best practices and standards for maintaining stable reporting environment.
  • Proficient with Business Objects Web Intelligence (WebI), Explorer, Universe Designer, Analysis for Office, Query as a Web Service, and Xcelsius.
  • ABAP Programming experience includes developing reports, interfaces, conversions, enhancements, SAP Scripts, User Exits and BDC. Developed data clean-up programs for master data and transactional data.
  • Experience in SAP includes project management, interacting with business users/ functional consultants for requirements gathering and analysis. The design, development and technical documents were done based on the reporting requirements/functional documents.
  • Worked on blue printing, functional/reporting requirements gathering and architecting it into a successful SAP BI/BW/HANA technical design. Worked as project lead/consulting resource to other developers in the team often leading the technical implementation of project.
  • Team player with excellent analytical, technical, interpersonal and communication skills.

TECHNICAL SKILLS:

SAP: SAP BW 2.0B/2.1C/3.0B/3.1C/ 3.5/7.0/7.3/7.4/7.5 , SAP R/3 3.XX/4.XX, ECC, HANA

FE: Business Objects Enterprise BI 4.X, Crystal Reports, Business Objects Dashboard (Xcelsius), Design Studio, QlikView, Tableau

ETL: Informatica, Business Objects Data Services (BODS), SAP Landscape Transformation Replication Server (SLT), Smart Data Access (SDA)

Programming Languages: ABAP, SQL

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, PA

SAP HANA Migration Consultant

Responsibilities:

  • Executed SAP Code Inspector ( Confidential ) in Confidential Production systems like ECC, BW, SCM (APO) and SRM using variants FUNCTIONAL DB, FUNCTIONAL DB ADDITION & PERFORMANCE DB and downloaded the reports for performing ABAP code remediation after HANA migration.
  • Ran SAP Code Inspector ( Confidential ) in development systems after HANA migration using variants FUNCTIONAL DB, FUNCTIONAL DB ADDITION & PERFORMANCE DB. Compared the list of issues with Production and carried out ABAP code remediation for Programs, Classes and Function Groups (FUNCTIONAL DB, FUNCTIONAL DB ADDITION) as per SAP recommended HANA code remediation guidelines. ABAP code remediation is carried out in ECC, BW and SCM systems.
  • Worked with Confidential BSC (Navy Support Business Systems Center) Functional team and Testing team for Unit testing the HANA migrated Development systems in the cloud and made sure that functionality is not impacted and the results are validated against on-premise Development systems.
  • Converted Data cleansing code written in Oracle SQL, PL/SQL for removing PII (Personally Identifiable Information) to HANA compatible SQL.
  • Currently working with RICE Government Team on preparation tasks like finalizing the delta transports and comparing the differences between on-premise and cloud so that they won’t impact or merge the existing changes.

Confidential, Wilmington, DE

Sr. SAP BI/BW/HANA/ABAP Architect/Developer

Responsibilities:

  • Responsible for developing Supply Reports using HANA views and Tableau.
  • Supply related tables are replicated into HANA using SLT (SAP Landscape Transformation Replication server). SAP HANA views are developed in HANA studio and reports are developed in Tableau using HANA views as data source.
  • Reports developed for Supply IMR reporting are Inventory and COGS (Cost of Goods Sold), OTD (On Time Delivery), Billing Accuracy, Order Completion Accuracy and CDN (Common Data Accuracy).

Confidential, Buena Park, CA

Sr. SAP HANA/BI Architect/Developer

Responsibilities:

  • Created Packages, Information views, Stored Procedures in HANA Studio. SQL scripts based or Graphical Calculation views are created based on the complexity of the functional requirements.
  • Hana views are analyzed using PlanViz for performance tuning. SQL scripts are optimized for performance and HANA views are built using best practices like optimizing joins and cardinality, filtering the data, avoiding aggregation nodes, pushing custom calculations to the top and avoiding “is Null” check on large volumes of data.
  • Go Get Em Report is developed for Finance as it displays AR open items by Sales Representative and Division along with Promise to Pay Dates and Collection Specialist notes.
  • Some of the Materials Management reports created are Customer Contact Info and Customer Material Analysis.
  • Some of the Logistics and Warehouse Management reports created are Inventory Accuracy (Daily/Weekly/Monthly), Warehouse Capacity (Daily/Weekly/Monthly), Cycle Count, Productivity.

Confidential, Springdale, AR

Sr. SAP BI/BW/HANA/ABAP Architect/Developer

Responsibilities:

  • Production Planning Schedule (PPS) is a home-grown application primarily used for Tyson’s Supply network planning. Tyson uses JDA for Demand Planning. PPS application runs on top of HANA database. PPS tables are updated with data from JDA & ECC for supply planning. SAP Landscape Transformation replication server (SLT) is used for replicating data from ECC to HANA.
  • HANA Calculation views and Stored Procedures are created for reporting. Optimized HANA views using PlanViz. PPS reports are created in Web Intelligence (WebI) based on HANA views.
  • PPS reports created as part of Propel: PPS Order vs Forecast Weekly, PPS Features by Req. Delv Day, PPS Plant Capacity Utilization, PPS Feature pricing, PPS WIP Requests Schedule, PPS WIP Requests, PPS Fresh Poultry Forecast by Ship/Delv Day, PPS Fresh Forecast vs Orders, PPS Orders vs Forecast Summary, PPS Orders vs Forecast Daily, PPS Forecast Ship Dates by Category, PPS Fresh Projection, PPS Fresh Poultry Forecast Weekly and PPS Fresh Projection Export.
  • Tyson uses BW HANA as it’s Enterprise Data warehouse. BW for HANA optimized objects like Composite Providers and Advanced DSO’s are created in BW on HANA. HANA views are created for WebI and AFE (Analysis for Excel). Web Intelligence (WebI) reports are created for WIP Adherence report, Current Days of Supply report and Sales and Operations Adhoc report.

Confidential, Broomfield, CO

Sr. SAP BI/BW/HANA/ABAP Architect/Developer

Responsibilities:

  • Reports enhanced for Supply Chain: Allocation Procedure Report, Demand Planning KPI Scorecard, SNP Data Reporting
  • Reports enhanced for Sales and Distribution: Purchasing Report, Lean Freight Accrual Report
  • Reports enhanced for Finance: Shipment Cost Billing Report, General Ledger Line Items Report, Sales Billing and Plan Report
  • Attended workshops and worked with members of Demand Planning team and Functional team for understanding the requirements of new planning area for Demand Planning
  • Designed and developed data flow for extracting Customer hierarchy, Order history and Shipment history from BW to APO & BW development needed in APO system.
  • BW Development in APO: Developed realignment program in APO for reading Customer hierarchy. Some of the BW objects designed & developed for Demand planning area are APO DP Forecast (Daily planning), APO DP Forecast Snapshot, Demand Planning report based on VirtualProvider (Live cache reporting), TPM Sales Forecast, Backup InfoCubes based planning areas for current, forecast and historical snap shots.
  • APO related development in BW: Designed and developed the BW related objects for extracting DP planning related data for reporting. BW objects developed for Demand planning are APO DP Forecast - Current Version, APO DP Forecast - Budget, APO DP Forecast - Accuracy, APO DP Forecast - History, APO DP Forecast - Prior Versions Detail, APO DP Forecast - Prior Versions High Level, APO DP Forecast - Weekly Versions, APO DP TPM Forecast - History. APD’s are created in BW for sending Forecast information to BPC for planning. BW reports are developed for FSOO & Consensus reporting.

Confidential, Buena Park, CA

Sr. SAP HANA/BI Architect/Developer

Responsibilities:

  • Developed Attribute, Analytical and Calculation views, Stored Procedures and Schemas in HANA Studio. SQL scripts based or Graphical Calculation views are created based on the complexity of the functional requirements.
  • Some of the Finance reports developed are DSO Report, Group Debtor Report and AR Discrepancy Report
  • Some of the Sales & Distribution reports created are Sales Order Status Report, Open Lines Report, Line Items Back Order Report, Freeway Report and Sales Order Blow Out Report.

Confidential, Canonsburg, PA

Sr. SAP BI/BW/HANA/ABAP Architect/Developer

Responsibilities:

  • Activated SAP delivered LO DataSources for Sales, Delivery and Billing.
  • Made enhancements to the DataSources and added the additional fields required through Confidential ’s.
  • Additional Custom InfoObjects needed for reporting are created in BW.
  • Advanced DSO’s are created using HANA Studio and transformations are created in BW using Data Warehousing Workbench. Composite Providers are created on top of Advanced DSO’s to meet reporting requirements. HANA views are created as per User Requirements Specifications. Webi reports and Dashboards are created using HANA views.
  • Technical unit testing is completed in Development system. Worked with Power users for unit testing, quality testing in Development and Quality systems. HP ALMQC (Application Lifecycle Management Quality Center) is used for running the scripts and approve the development to Production.
  • Prepared the cutover plan with cutover team and provided support for moving the transports to Production and extracting the data into BW. Worked with business team for testing the reports and getting them certified for business use.

Confidential, St. Paul, MN

Sr. SAP BI/BW/HANA/ABAP Architect/Lead/Developer

Responsibilities:

  • Involved in the migration of BW Database from DB2 to HANA using data migration option (DMO) of Software Update Manager (SUM). Responsible for carrying out ABAP remediation activities like SPAU & SPDD, Unicode compliance, and optimization of custom ABAP code using ABAP SQL Monitor. BW Migration Cockpit for SAP HANA was used to checking, migration conversion and optimization of BW on HANA. Implemented LSA++ (Layered Scalable Architecture) for SAP NetWeaver BW on SAP HANA.
  • Created Composite Providers in HANA Studio and developed HANA views (Attribute, Analytical and Calculation) based on Composite Providers in BW on HANA. Some of the HANA modeling concepts used are creating Restricted & Calculated Columns, Filter operations, Hierarchies, Variables, SQL Script & Procedures, and Currency conversion. Performance optimization is done for the ABAP related programs as per SAP recommendation.
  • Reports (Documents) were created using SAP Lumira with HANA online/offline as a DataSource. Datasets/Reports/Dashboards were shared with different sharing options like export as file and publish to SAP HANA/Explorer/SAP Lumira Cloud.
  • Setting up driver and providing connection parameters for connecting to Teradata using Smart Data Access (SDA). Open ODS views are created and reports are created based on the Teradata tables. SAP Landscape Transformation Replication Server (SLT) was used for extracting Finance related data from ECC into HANA. HANA views and reports were developed once the data is extracted into HANA.
  • Designed BW data models and developed backend technical objects in BW for enterprise wide reporting. WebI, Analysis for Office reports were developed for detailed analysis and Dashboards were created using Xcelsius for summarized reports.
  • Open hubs are created in BW and data is fed to Global Enterprise Data Warehouse (GEDW) so that the business can report on SAP as well as non-SAP data.
  • Part of the cutover over team for moving the development to Production as part of minor & major releases and provided hyper care support on 24x7 basis
  • Some of the Source to Pay (STP) reports developed: Blocked Invoice Detail and Summary, Buyer Metrics, Daily Invoice Metrics Summary, Duplicate Invoice, Invoice Throughput, Payment Timeliness, Days to Pay (DTP), Goods Receipt, New Vendor Setup & One time Vendor, PIR to PO, PO Line Item and Summary, PO to Goods Receipt to Invoice, and SRM Shopping Cart Details.
  • Worked with Forecast to Schedule process team for understanding the requirements for Demand planning and Supply Network Planning reporting. Developed the backend objects and reports for Demand Planning and Material Requirement Planning (MRP).
  • Sales order history & Open orders related data is extracted from ECC into BW and then sent to APO for planning the demand along with other forecasts like Marketing demand, etc. Sales history and historical forecast data from legacy systems is loaded into APO Demand planning sales history InfoCube through flat files.
  • Created APO DP basic cube for sales history, APO DP Archiving Cube for daily backup and APO DP Forecast cube to maintain approved forecast for reporting.
  • CVC’s (Characteristic Value Combinations) are created on the requirements provided by DP Planner and they’re loaded into Planning Object Structure. DP Planners use Planning books to review and make adjustments to the demand. CVC realignment is performed and existing CVC’s in Planning Object Structure are overwritten/appended based on the input from Demand Planners.
  • Extracted inventory data, stock requirement list (MD04), MRP lists from ECC into BW for Material Requirement Planning (MRP). LO extractors for Purchasing, Sales, Inventory, Production planning and Sales and Distribution required for ECC MRP are activated and enhanced to meet the business requirements.
  • Some of the Forecast to Schedule (FTS) reports developed: Dollarized Key Figures Weekly/Monthly/Lags, Demand Planning Dashboard for Planners, DP Alerts Demand and Forecast Data, DP Alerts Order Tracking Data, PIPO Time Series, GDMR Supply Plan for non-SAP Locations, Plan versus Actual Order Comparison, External Intelligence, Tasks List Details, Inventory Projection, and Lead Times for APO GI, GI ECC Time, GR Time, Transit Time.

Confidential, Boise, ID

Sr. SAP BI/BW/ABAP Architect/Lead/Developer

Responsibilities:

  • Completed blue printing the requirements by conducting workshops with business for gathering the reporting requirements.
  • Worked closely with APO SNP functional team for understanding the CTM (Capable to Match) process of SNP and designed the reporting model based on business reporting requirements.
  • Created functional and technical documents for DP, SNP and GATP reporting solutions.
  • Designed data model and developed master and transactional data interfaces for CTM results validation.
  • Conducted design reviews and solution reviews with the functional team and business.
  • BEx reports are developed to analyze the Statement of Supply (SOS). Some of the reports developed are Statement of Supply report, Execution or Goals report, Capacity Utilization report, Supply Demand match (availability) report, Demands met, partial, late report, Planned transports report, Planned Purchases (by CTM & MRP) report, Surplus Supply (Unconsumed Supply) report, Constraints report, Demand report, Supply report, Subcon report, Simulation report and Planned to Actual report.
  • Created test plans for testing the reports in different environments. Worked with business users and testing team for successful completion of unit testing, integration testing and user acceptance testing.
  • Worked with Project Management team for cut over planning, including the sequence of events (SOE) in the cutover plan and provided cutover support for move to Development (Support pipeline), Quality and Production environments.
  • Created documents and conducted KT (Knowledge transfer) sessions for Client reporting team as well as support team.
  • All the configuration, development and reports were moved to Production. Successfully transitioned the production support to support team after hyper care.

Confidential, Hartford, CT

Sr. SAP BI/BW/ABAP Architect/Lead/Developer

Responsibilities:

  • Interacting with Basis and Security to resolve issues during upgrade.
  • Coordinated with Functional teams and Front end team for investigating and fixing the issues with testing.
  • Updating management with the status of upgrade in various systems and the corrective actions taken to mitigate upgrade issues.
  • Closely working with other technical team members for timely completion of upgrade activities.
  • Responsible for executing pre and post upgrade reports, testing various objects, data loads before and after Oracle and technical upgrade. Cleaned up unwanted database tables after Oracle 10g upgrade.
  • Technical upgrade was completed successfully in four months. Data flows for critical InfoProviders were changed from 3.x to 7.0.
  • Worked on the successful completion of functional upgrade. Enterprise Portal is implemented as part of functional upgrade. BI 7.0 tools like BEx Analyzer, BEx Query Designer, BEx Web Analyzer, Web Application Designer, Report Designer, Information Broadcasting, Administration Cockpit, Precalculation Server and Visual Composer were rolled out as part of functional upgrade.
  • Modified Sales document item (2LIS 11 VAITM) user exit to populate Commercial warranty item level details. Modified Shipping document item (2LIS 12 VCITM) to populate item level record with item level PO number instead of header level PO number. Modified the user exit for QM Notification item (2LIS 05 Q0ITEM) to extract data for Engine Change Number.
  • Worked on China Eastern and Turkey projects for implementing BI 7.0 tools and analysis, Integrated Planning (IP) for Inventory Management Planning, and Inventory Management & Engine Center Performance (CATS) projects.
  • Coordinating with Basis, Security, Development and Production support teams for resolving issues and making sure that the BW system performance is optimal.

Confidential, Indianapolis, IN

Sr. SAP BI/BW/ABAP Architect/Lead/Developer

Responsibilities:

  • Evaluating existing processes and executing conversion programs as recommended by SAP.
  • Analyzing impact of upgrade and testing the existing functionality during upgrade such as creating various BW objects, activating and loading.
  • Coordination with Basis team for resolving issues during prepare and upgrade.
  • Listing down the issues and prioritizing them basing on the complexity and seriousness.
  • Creating OSS messages to SAP for new issues and corresponding with SAP for escalating the issues.
  • Investigating the issues and finding suitable OSS Notes. Resolving the issues by applying the OSS notes and/or SAP recommendations.
  • Upgrade was done in a phased manner to minimize the impact. It was first carried out in sand box to analyze & troubleshoot issues and then in development, followed by quality and production systems.
  • Coordinated with security team in implementing analysis authorizations for BI 7.0.
  • Technical Conversions after Upgrade:
  • Involved in the phased migrations of existing objects into the latest technologies, which include, migrating existing 3.0 DataSources to 7.0 DataSources, Conversion of Transfer Rules & Update Rules to Transformations. Activated business content for NW 2004s BI Statistics and implemented BI Administration Cockpit.

We'd love your feedback!