Senior Sap Hana Modeler Resume
Tampa, FL
SUMMARY
- 12 years of experience in SAP, focused on SAP HANA, SAP BI, SAP BO, SAP SLT, SAP DS & SAP EP
- Experience as HANA Modeler in 5 HANA projects - Including 2 Cloud Projects (HEC and Virtustream), 2 On premise HANA Projects and One Product Development Projects
- HANA Product Development: Experience in Managing, Planning, Design, Develop SAP HANA BW Migration Accelerator which is Certified by SAP
- HANA Architecture: Experience in S/4 HANA Migration, BI on HANA Deployment and Development project, Native HANA Project, HANA Data Mart, HANA BO Integration and report development, BI BO integration Scenarios & BI EP integration scenarios
- HANA Modelling: Experience includes creating HANA Views (Analytic, Attribute and Calculation), Hands on Experience in HANA XSC and XSA developement
- Data Provisioning: Extracted data from ECC using SAP Landscape Transformation Replication Server (SLT), Smart Data Integration (SDI)& Business Objects Data Services (BODS) is used as an ETL from extracting data from external systems (Oracle, SQL and Flat File Sources)
- HANA Cloud: Involved in implementing Migration of on premise ECC (to S/4 HANA) and BW systems into HANA Cloud . One project on SAP HEC and Other Project on SAP Cloud Partner (Virtustream)
- BW on HANA Mixed Scenarios: Experience in Modelling on BW 7.5 on HANA mixed scenarios including creation of ADSOs, Composite Providers on generated BW infoproviders.
- BW on HANA DB Migration: Experience including sizing, Planning, Migration, Pre and Post Migration activities, Testing and issue resolution
- S/4 HANA Embedded Analytics: Implementation of S/4 HANA embedded analytics for Finance Reporting, Creation and Extension of CDS Views, Creation and Extension of Analytic Apps for FIORI & BOBJ front end consumption
- S/4 HANA: Experience in Configuring S/4 HANA simple finance- GL Accounting & New asset Accounting, Migration - Cost Elements, Line items & Balances, data enrichment, preparing for Migration, Reconcile & Compare Migrated data
- SAP BI Experience: Involved in full - life cycle BI/BO implementations, upgrades, Enhancements and Post Production Support in the areas of SAP TM, EWM, SCM, SD, MM, PP, PM, PS, FI and SAP CRM.
- SAP BOBJ Suite Experience: Involved in on SAP HANA and SAP BI sources using reporting tools SAP BO Web Intelligence, SAP Crystal Reports, AAO, Lumira knowledge in SAP HANA Infrastructure including SAP Basis, Security, Change Management & Network
- Expertise in all phases of SDLC like Realization, Analysis, Functional and Technical specification, Development, Integration and UAT, End-User trainings and Post Go-Live support.
PROFESSIONAL EXPERIENCE
Confidential, Tampa, FL
Senior SAP HANA Modeler
Responsibilities:
- Involved in Native HANA Modelling - Creation of Graphical Calculation Views ( WEB IDE and HANA Studio)
- Worked extensively with Modelling functions including Calculated Columns, restricted Columns, Filters, Variables, Input Parameters, Currency Conversion and Hierarchies.
- Exposure to SQL Script Functions and Procedures, Debugging and Performance Tuning and Optimization
- Worked with XSA Application Development using Web IDE - MTA Application Projects
- Involved in Dynamic Tiering Migration, Changes to HANA Views post Migration, Testing and Issue Resolution
- Involved in HANA PAL functions for Classification, Clustering and Prediction of Customers
- Experience in Performance Tuning and Query Optimization of Existing Calculation Views using SQL Analyzer Tool
- Hands on experience in using SAP BODS (Business Objects Data Services), SLT and SDA (Smart Data Access) to extract structured/unstructured data from different source systems into HANA
- Experience in designing and implementing security for SAP HANA ( Native Hana)
- Working experience on HANA Application Lifecycle Manager
Confidential, Phoenix, AZ
SAP HANA Modeler
Responsibilities:
- Involved in BW 7.5 on HANA modelling of Mixed scenarios including creation of ADSOs and Composite Providers on top of generated HANA views.(For BW info providers)
- Modelling of scripted and Graphical calculation views on BW Info Providers (HANA Views)
- Data extracted, Loaded and Transformed in BW into ADSOs
- Enriching Generated HANA views and combining with Native HANA views for Business Requirements
- Extensive experience in writing Stored Procedures in HANA using SQL Script
- Strong Experience in Performance Tuning and Query Optimization
- Involved in HANA XS, JavaScript and developing User Interface with SAP UI5.
- Hands on experience in using SAP BODS (Business Objects Data Services), SLT and SDA (Smart Data Access) to extract structured/unstructured data from different source systems into HANA
- Experience in designing and implementing security for SAP HANA ( Native Hana & BW on HANA )
- Working experience on HANA Application Lifecycle Manager to transport Code
- Experience in SAP HANA advanced features - Dynamic Tiering, Smart Data Integration from Oracle and Access DB DATA Source
- Involved in Design and Deployment of BW on HANA security model including RS2HANA Gen, BW Analysis Authorizations, Analytic Privileges, and BOBJ Security
- Involved in BW on HANA 7.5 life cycle management including new ABAP transports and Old Export/ Import Transports
- Leading Onshore and Offshore teams
- Test final output based on requirements and business needs.
Confidential, Hicksville, NY
SAP HANA Architect/Modeler/ Administrator
Responsibilities:
- Facilitate requirements gathering and reconciliation of data definitions with business and IT experts.
- Lead the HANA DC migration, DB upgrade, SAP BW SP Upgrade, AT&T Netbond Implementation
- Worked on HANA End to End performance Tracing and issue resolution including - Network Traces (Iperf) & Front end tool Traces ( AO traces & SAP client Plugin)
- Involved in integration of Upstream and downstream Systems with Informatica PowerCenter and SAP BI
- As part of business requirement We had SCM HANA live Models to be implemented. Which we have excluded some unwanted fields, Added custom Fields and Changed Business Logic to the Models.
- Playing a Lead role for onshore and offshore.
- Involved in BW on HANA, Native HANA and BPC Implementation Projects
- Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
- Data provisioning using SLT for SAP ECC source system, Smart Data Integration (SDI) for Flat file Source and SDA for Oracle DW and SQL source Syetms.
- Creation of Stored Procedures and Calculation Views using SQL Script & CE Functions
- Moving the developed jobs in HANA from DEV to PROD using Export and Import functionality and also Life Cycle Management.
- Leading Onshore and Offshore teams
- Test final output based on requirements and business needs.
Confidential, Dallas, TX
SAP HANA Architect/Modeler
Responsibilities:
- Facilitate requirements gathering and reconciliation of data definitions with business and IT experts.
- Playing a Lead role for onshore and offshore.
- Involved in S/4 HANA migration, Testing and issue resolution.
- Experience in Configuring settings for General Ledger accounting & New asset accounting
- Involved in Migration of cost elements, Line Items & Balances
- Worked on data enrichment, preparing for Migration, Reconcile & Compare Migrated data
- Involved in Fiori Implementation and deployment for S/4 HANA Simple finance
- Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
- Involved in SAP HANA Security including User Management, Roles, and Privileges.
- Data provisioning using SAP Landscape Transformation(SLT) and SAP Data services
- Involved in Configuring SLT, Loading ECC tables, Monitoring and Administration of SLT.
- Creation of Stored Procedures and Calculation Views using SQL Script & CE Functions
- Moving the developed jobs in HANA from DEV to PROD using Export and Import functionality and also Life Cycle Management.
- Leading Onshore and Offshore teams.
- Test final output based on requirements and business needs.
Confidential, King of Prussia, PA
SAP HANA Architect/Modeler
Responsibilities:
- Facilitate requirements gathering and reconciliation of data definitions with business and IT experts.
- Playing a Lead role for onshore and offshore
- Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
- Involved in SAP HANA Security including User Management, Roles, and Privileges
- Data provisioning using SAP Landscape Transformation and SAP Data services,
- Involved in Design, Develop Dashboards/Reports on top of HANA Views using BO Web Intelligence
- Worked in Loading data into table definitions, suspending data loads, resuming data loads using LT Replication
- Designed and Worked with Joins and Union functions of HANA DB tables to meet the business requirements and use cases
Confidential, TX
SAP HANA Architect/Modeler
Responsibilities:
- Facilitate requirements gathering and reconciliation of data definitions with business and IT experts.
- Playing a Lead role for onshore and offshore
- Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
- Involved in SAP HANA Security including User Management, Roles, and Privileges
- Data provisioning using SAP Landscape Transformation and SAP Data services,
- Evaluate the information gathered from multiple sources, reconcile conflicts, decompose high level information into details, abstract up from low-level information to a more general
- Understanding, distinguish presented user requests form underlying true needs and distinguish solution ideas from requirements.
- Prepare requirements documents to be used as the basis for project development.
- Leading Onshore and Offshore teams.
- Test final output based on requirements and business needs.
- Coordinate with global IT and Business teams to deliver the requirements
Confidential, Dallas, TX
HANA BI BO Architect /Project Manager
Responsibilities:
- Plan, Design, Develop and Manage the HANA BW Migration Accelerator Project
- Involved in Preparing Detailed Solution Document for BW Migration Accelerator
- Worked on Preparing FDD and TDD for Mswift Migration Components
- Worked with HANA BW Migration Preparation, Actual Migration, Post Migration Testing,Issue Resolution Cycles
- Involved in Design, Develop Dashboards/Reports on top of HANA Views using BO Suite of reporting Tools
- Involved in Design, Prepare Migration Methodology Framework and Best Practice Documents.
- Support Sales Team with GTM Plan including HANA Sales PPTs,Battle Card,Brocures, Webinar, Case Studies
- Worked with Confidential Internal Investment Approval Process including preparation of supporting Documents for Analyst Feedback (Gartner and Forrester)
Confidential, MA
SAP HANA/BIBO Architect
Responsibilities:
- Involved in Sizing, Design, Configuring of HANA landscape for both LT and SAP DS replications
- Involved in Design and Development of HANA Views - Attribute, Analytic and calculation Views
- Experience working with content models, attributes and measures, hierarchies
- Involved in Design of SAP DS Jobs for Replication of Data to HANA DB with complex Data Transformations and Data Cleansing
- Worked in Loading data into table definitions, suspending data loads, resuming data loads using LT Replication
- Designed and Worked with Joins and Union functions of HANA DB tables to meet the business requirements and use cases
- Worked with Design and Development of Dashboards/Reports on HANA using BO Reporting tools
- Involved in design and implementation of Security model for HANA users and Administrators
- Experience in Methodical skills of collecting business requirements, conducting blueprinting workshops, writing functional/technical specifications for HANA Landscape
Confidential, CT
SAP BI/BO Lead Consultant
Responsibilities:
- Involved in Design and development of Reporting Framework on top of SAP BI 7 using SAP BO Reporting Tools
- Experience on Entire BO Suite - Webi, Xcelsius, Explorer, AA0, and Crystal Reports
- Strong understanding of Configuration and integration of SAP BO with SAP BI 7 / ECC (including SAP Enterprise Portal Integration)
- Extensive experience in designing and building Dashboards/Reports from SAP BI 7.0 Bex Queries by using Hyperlinks, Prompted Filters, sections and Breaks for providing Drill Down/Navigation to business users
- Worked in configuring BO Explorer Accelerated version, created information spaces on BI queries
- Worked in design of data migration strategy with BO DS to migrate and load data from Non SAP System (QAD system) to SAP BI 7.0 using complex transformations and ETL methods
Confidential
SAP BI/BO/EP Consultant
Responsibilities:
- Involved in Design and development of Reporting Framework on top of SAP BI 7 using SAP BO Reporting Tools
- Experience on Entire BO Suite - Webi, Xcelsius, Explorer, AA0, and Crystal Reports
- Experience in design and development of SAP BI objects such as InfoObjects, InfoCubes, InfoSources/Data Sources, Master Data, Transformations, Update Rules, ODS, Extractors, Aggregates and Process Chains
- Configured and Activated SAP BI Business Content to meet Reporting and Analytics Needs.
- Worked extensively on BEX Reporting tools - Query Designer, WAD for creating queries with
- Variables, Filters, Conditions, and Restricted & Calculated Key figure
- Integrate SAP BI System with SAP EP and publish BEX reports on EP system
- Involved in Developing Dashboards using Visual Composer on Top of BEX queries
Confidential
SAP BI/BO/EP Consultant
Responsibilities:
- Involved in Design and development of Reporting Framework on top of SAP BI 7 using SAP BO Reporting Tools
- Experience on Entire BO Suite - Webi, Xcelsius, Explorer, AA0, and Crystal Reports
- Experience in design and development of SAP BI objects such as InfoObjects, InfoCubes, InfoSources/Data Sources, Master Data, Transformations, Update Rules, ODS, Extractors, Aggregates and Process Chains
- Configured and Activated SAP BI Business Content to meet Reporting and Analytics Needs.
- Worked extensively on BEX Reporting tools - Query Designer, WAD for creating queries with
- Variables, Filters, Conditions, and Restricted & Calculated Key figure
- Integrate SAP BI System with SAP EP and publish BEX reports on EP system
- Involved in Developing Dashboards using Visual Composer on Top of BEX queries
Confidential
SAP EP Consultant
Responsibilities:
- Implemented Standard ESS/MSS Business Packages onto Portal
- Customized Portal Theme( Portal Desktop & Rule Collections) and assigned permissions to the Portal Themes
- Worked with NWDS to customize EP Logon Page as per GEE Standards.
- Involved in Developing a new Layout which can accommodate GEE Footer
- Involved in Customizing SAP Delivered Components (Masthead, TLN, DLN etc) to meet the GEE Branding Requirements.
- Configured Portal Server for SSO with SAP logon Tickets and Configured SAP BW System to Accept and Verify SAP Logon Tickets
- Worked with all the concepts of VC like Filters, Value help, Exceptions, Data store, Entry List