We provide IT Staff Augmentation Services!

Sap Hana Solution Architect & Specialist Resume

CAREER OBJECTIVE:

To contribute to the world of Information Technology in a way that fosters innovation, personal growth and puts forward new challenges to extend the skills and learning opportunity.

SUMMARY:

  • 12 yrs. of total IT Experience.
  • 12 years of SAP BW experience.
  • 1 yr of Big Data - Hadoop-HANA integration experience.
  • 5 yrs. of SAP HANA experience. HANA as main EDW with S4 as source. HANA as a DATA HUB - Modeling, Extraction & Reporting. HANA as a Side-Car - Modeling, Extraction & Reporting. Worked on both SP9 and SP10 versions. Worked on complex - SQL Scripting.
  • 1 yr of SAP ISU-BW experience.
  • 3 yrs of SAP BPC-BW experience .
  • 1 year of DSiM experience
  • 4 yrs. of SAP BOBJ experience.
  • 5 yrs of BW-ABAP experience
  • 8 end-to-end implementations, 2 upgrades, 1 rollout and 2 sustainment/development assignments.
  • SME for 2 Major BWonHANA Migration projects
  • Implemented in SAP ISU-BW Implemented ISU-BW for Billing, Invoicing, Device management and FICA functionality for Major Utility client. Implemented ISU-BW Integration for Sales Statistics Data Flow which included:
  • Working with ECC side configs to enable BW extraction.
  • Working with functional team to work with reconciliation keys
  • Working with table - DBESTA BWPROT to check the closed and open reconciliation keys.
  • Implementing mass activity to enable delta transfer to BW.
  • Implemented SAP BPC-BW for both Planning and Consolidation. Planning - BW Backend model Budgeting - BW Backend model Forecasting - BW Backend model. Worked on developments and support for BPC front end w.r.t Data manager logic enhancements, ad-hoc data manager loads and issue resolution.
  • Experience on BW Upgrade from 3.x to 7.0
  • Experience on BW Upgrade from 7.0 to 7.3 including BWA upgrade and Unicode conversion and analysis authorization migration.
  • Worked on HR-BW Integration
  • PA (Personnel Administration)
  • Payroll
  • Time Management
  • Designed technical design document for the HR-BW Integration design
  • Created ETL process PA, Payroll and Time management
  • Worked on issues resolution and performance optimization for HR-BW flows
  • Worked on COPA model prototype with SAP HANA
  • Rich experience in Designing, Modeling, Reporting and extraction work in BW.
  • Extensive ABAP experience which includes Routines, User Exits, Function Modules
  • Implemented HANA end to end project with WebI reporting - CEI
  • Implemented DSiM 2.0 (Demand Signal Mgmt) for Swedish Hygiene Company
  • Implemented DSiM 2.0 (Demand Signal Mgmt) custom development through HANA procedures for US largest Sausage manufacturer.
  • Implemented HANA POC Design.
  • Implemented CEI on HANA project.
  • Experience in SCM-BW integration .
  • Demo and Training experience in Celonis on HANA
  • Knowledge of SAP OPI (Operational Process Intelligence)
  • Experience in BW-APO modeling, design and reporting.
  • Experience in PBF 8.1 Implementation and Support.
  • Experience in Vistex-BW Integration.
  • Experience in generic datasources and enhancements.
  • Experience in advanced reporting using WAD, BEx web and other tools.
  • Experience in BWA implementation, upgrade and troubleshooting.
  • Implemented FI G/L (New GL), AP & AR applications in BW.
  • Implemented CO-PA model and extraction (Costing based).
  • Implemented Project Systems (PS).
  • Implemented SD, Purchasing and Inventory applications in SAP BW .
  • Implemented POS DM in BW.
  • Implemented APDs and OHDs for the data export.
  • Implemented archiving using NLS DAP (Near Line Storage - Data archiving)
  • Implemented PM (Plant Maintenance) data model and reports.
  • Implemented analysis authorizations in SAP BW 7.0.
  • Implemented BW Admin cockpit for the BW usage reports.
  • Experience in Request Administration Archiving.
  • Defect Management, Incident Management and Client handling.
  • Experience in User acceptance & Integration testing.
  • Mentoring new team members.
  • Recognized for a niche in client interaction skills.
  • Experience in SOMAN, HP Service Centre, Mercury Quality Centre & Lotus Notes.

EXPERIENCE:

Confidential

SAP HANA Solution Architect & Specialist

Responsibilities:

  • Analyzing the data and table structure in the source before provisioning into SAP HANA.
  • Building ER diagram and table relationships with start-schema modeling and snow-flake schema modeling, along with history preserving and table comparison operators.
  • Working with SDI (Smart Data Integration) using the DP agent and adapters to both pull data from legacy databases and to push data onto cloud based solutions (Netsuite-Monexa).
  • Setting up the persistency model with versioning and change control via repository artifacting using HDBDD and HDB* models.
  • Setting up the A-LCM(Lifecycle Manager) to design and implement the transport routes and promote the DU (delivery units) across the HANA landscape.
  • Building and implementing HANA models with Flowgraphs, Calculation views and Catalog objects (Views, Sequences etc.).
  • Performance optimization using the PlanViz tool.
  • Building the SAP Lumira and Design Studio dashboards to showcase the data modeled in SAP HANA.

Confidential

SAP HANA Big Data Solution Architect

Responsibilities:

  • Analyzing the data lakes and big data formats to be loaded into Hadoop.
  • Integrating HANA and Hadoop using SAP Spark Controller, which leverages Apache Spark framework and SDA (Smart Data Access).
  • Loading Data into Apache Hadoop (CDP) and building Hive tables.
  • Federating data integration into SAP HANA using virtualization framework via SDA (Smart Data Access).
  • Setting up the persistency model with versioning and change control via repository artifacting using HDBDD and HDB* models.
  • Building and implementing HANA models with Flowgraphs, Calculation views and Catalog objects (Views, Sequences etc.).
  • Performance optimization using the PlanViz tool.
  • Building the SAP Lumira and Design Studio dashboards to showcase the data modeled in SAP HANA.

Confidential

SAP HANA Lead

Responsibilities:

  • Leading the BW on HANA migration project and also the Native HANA – BW HANA mixed scenario using Smart Data Access (SDA).
  • The migration work involved end-to-end planning starting with Blueprinting to Go-live and post-go live support.
  • This involves executing the pre, post and actual migration tasks. Post migration, the responsibility also entailed optimization w.r.t SAP HANA, table redistribution and cube optimization.
  • On the native side, it involved building HANA model with virtual tables using SDA (Smart Data Access) and using the OpenODS view generated Calculation views, combining data.
  • Once the HANA modeling is completed, we also need to use Design Studio on tablet mode for the field engineers and reporting end-users.
  • Creation of BW backend flow including custom extractors. Bex report creation on top of BW model. Rendering Bex report for BOBJ front end reporting and dash boarding.
  • Managing and implementing BPC data manager packages, working with BPC functional team to implement new dimensions, properties and models.
  • Working as a lead from BW team for the BPC 7.5 to 10.1 NW upgrade.
  • This involves workshops for design sessions.
  • Delineating the upgrade and migration plan. Implementing the pre and post migration activities.
  • Troubleshooting the issues during the upgrade and migration.
  • Modifying the custom Logic Script and BW components to comply with 10.1 framework.
  • Working with BPC functional team to implement Consolidation Solution.
  • Working with Portal team to implement SSO. Go Live and post Go-live support.

Confidential

Onsite BW Lead

Responsibilities:

  • BW Presentations for upgrade process, expected issues and resolutions.
  • Upgrade and Authorization migration design documentation.
  • End-to-End execution of the upgrade process.
  • Analyzing current model and landscape and preparing process documentation to handle all scenarios.
  • Pre-upgrade checks and activities.
  • Cutover plan preparation and successful execution with minimal issues.
  • Pre and post upgrade Portal-BW integration issues and resolutions.
  • BEx Broadcasting configuration and automation through process chain.
  • Authorization migration from 3.x to Analysis authorizations.
  • Optimization of the existing design with performance improvement measure and implementing Industry best practices.
  • Replicating the same upgrade modus-operandi for DR (Disaster recovery site)

Confidential

Onsite BW Lead

Responsibilities:

  • Client discussions to delineate the BW blueprint.
  • Preparation of Tech Spec.
  • Analyzing the current model and the SAP Portfolio in EHS for Web reporting.
  • Complete Custom development blueprint.
  • Implementing multiple custom extractors, based on function modules, both transactional and master data.
  • Testing the custom extractors and presenting to client.
  • Pre-go live support.
  • PoC for PBF 8.1 PEP (Personnel Expenditure Planning) Module:
  • Installation of PBF 8.1 BW ABAP Add-on.
  • Supported installation of PBF-JAVA Add-on.
  • Activation of BI content for fiscal period and flexible pay period PEP.
  • Creation and execution of PEP process chains.
  • Integration of HR data into PBF PEP.
  • Supported the creation and maintenance of master data for Budget Form templates: FM Area, Fiscal Year Variant, Fund Center, Funded Program
  • Grant, Functional Area, Fund.
  • Responsible for end to end delivery including blueprinting, realization and final delivery.
  • Also entails mentoring team members and training client core teams to understand and efficiently use the BI system.
  • Completed 2 end-to-end HANA-BO Implementation with complex SQL scripting.
  • HANA as a DATA-HUB: Implemented a completely new Solution from ground up for the SAP Marketing Team.
  • Requirement involved designing HANA acted a DATA-HUB wherein all the Campaign data needs to be consolidated in the HANA DATA-HUB and processed via procedures and Scripted Calculation views. Finally the data had to be consumed by the BOBJ reporting toolset (Design Studio, WebI, Lumira).

HANA-BO Lead

Confidential

Responsibilities:

  • Discussion with Database Architect and understanding the data model for Nurture.
  • This model had complex hierarchical relationship between Nurture hierarchy and the relationship between Nurture and Campaign Hierarchy.
  • Building the HANA Model which included creation of Attribute Views, Analytic and Calculation views.
  • These calculation views were developed using complex SQL scripting to accommodate the requirement.
  • Extraction of data from OLTP system (CRM) via SLT to store Campaign related data.
  • Built BO-WebI and Lumira reports for Business to visualize and analyze the KPIs.
  • Worked on BO-HANA Integration through Universe Design.
  • Worked on Analytic Privileges to setup authorizations for reporting users.
  • Implemented Dashboarding Solution – VnV – from ground up for the SAP Marketing Team.

HANA-BO Lead

Confidential

Responsibilities:

  • Blueprint discussion and Signoff. Translating the Blueprint to Technical Design Document.
  • Evaluating various BO-Tools for the best-fit. Evaluated Design Studio, Lumira, Analysis for Office – Excel and WebI.
  • Building the HANA Model which included creation of Attribute Views, Analytic and Calculation views.
  • Built BO-WebI reports for Business to visualize and analyze the KPIs.
  • Worked on Analytic Privileges to setup authorizations for reporting users.
  • Worked on 2 Projects which involved end-to-end DSiM config, BO-DS config and implementing custom function through custom HANA Script Procedures.
  • Understanding the data and Blueprint and translating it into DSiM components. This involved adjusting excel and csv files to tailor them to suit the DSiM format.
  • Converting weekly data format to dates for Enrichment. This involved orchestrating complex lookup logic in the BO-DS job.
  • End-to-End configuration setup for DSiM system which included IMG and DSM setup for all the components: Data Upload, Harmonization, Quality Validation and Enrichment.
  • End-to-End configuration and setup of BO-DS (Data Services) Project and Job for loading data into DSiM. This setup involved both Master and Transaction Data.
  • Supervising the data upload process to make sure all the roadblocks/errors are addressed and the upload is successful.
  • Testing of the DSiM data upload, web-dynpro and UI5 reports.
  • Presentations and Status Upload to customers.
  • Developing custom functions as HANA procedure to accomplish a custom KPI – Most Common Price per Unit.
  • Here we had the challenge to convert a C++ code to a HANA SQL script procedure which can handle millions of data. Implemented HANA SQL Script procedure successfully with optimized code.

Hire Now