We provide IT Staff Augmentation Services!

Sap Hana Lead Consultant Resume

San Francisco, CA

SUMMARY

  • Having 7+ years of experience in SAP HANA, SAP Business Objects (BO) and SAP BWBI which includes extensive client interaction to understand expectations, requirements, formulate solutions, estimations of the application. Currently working on SAP HANA platform tools
  • SAP HANA Consultant with Hands on project Experience in SAP HANA 1.0, SP9
  • Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0
  • Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.
  • Good working knowledge of different replication technologies like BODS, SAP LT and DXC replications into SAP HANA database.
  • Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA.
  • Experience in modeling scenarios and activities such as adding a system, creating schemas, importing table definitions, adding connections, setting preferences for the modeler and working in HANA studio.
  • Good conceptual knowledge on SAP Business objects Data Services (BODS).
  • Knowledge in SAP HANA Data Provisioning using SAP LT Replication Server (SLT) and Data Services.
  • Expertise in using Information Design Tool (IDT) over BEx queries and Info Cubes to migrate & model data from BI to BO for reporting.
  • Enterprise Data Warehouse Solution Architect with wide-ranging hands-on experience & good functional knowledge in the following SAP business process area (FI-GL, FI-SPL, FI-AP, FI-AR, FI-AA, FI COPA, FI PCA, FM, MM-PUR, PS, SD, SRM-EBP, CO, PCA, IS-Retail, & IS-OIL modules)
  • Designed and provided solutions to clients based on client’s requirements.
  • Expertise in Solution architect on Enterprise HANA & BW on HANA
  • Worked on Business KPIs for Dashboards and HANA & Defined layouts.
  • Sound Knowledge on SAP Technical Architecture skills with HANA Platform
  • Expertise in HANA security including users, roles, privileges.
  • Good knowledge on Data Harmonization issues of data’s like master, transaction and also derived Key Performance Indices.
  • Worked on set up a Data Archiving Strategy specifically for Financial Objects relating to the following areas: Business Workflow/SAPOffice,Cost Estimates (Tables CKIS, CKIT) and Characteristic Values (IBI* Tables),Material Documents (Table MSEG),Warehouse Transfer Requests and Transfer Orders - Kanban Requests (Tables LTAP, LTBP),Handling Units (Tables HUMSEG, VEPO),Purchase Orders (Table EKPO).
  • Expertise in backup and restore of HANA Database.
  • Knowledge on formulating recommendations based on Fit-Gap analysis.
  • Extensively involved in interviews within defined areas.
  • Expert in Providing design, modeling, implementation to teams to ensure dat reporting solutions are aligned with architecture direction.
  • Experience handling integration between multiple systems for reporting - SAP ECC, SAP, BOBJ.
  • Good knowledge for Create Info Object, Data Source, Info Source, Info Area for SAP BW.
  • Experienced in integrating and extracting data from Source systems ECC5.0/6.0, SAP R/3 (4.7, 4.6C, 4.6B), CRM, SAP R/3 SD, MM, FI/CO, SEM and SCM(5.0) using Standard, Generic extractors and DB Connect.
  • Strong Work experience in all areas of SAP BW viz. Reporting, Info Source, Data Source, Info Objects, PSA, Data Targets like DSO and Info cubes, Multi Provider, Data modeling, generic Extractors, LO and COPA extractors
  • BW Reporting - BEx Query Designer, BEx Analyzer, Web Application Designer, Visual Composer, RRI. Created custom queries using Conditions, Exceptions, Filters, Calculated Key Figures, Restricted Key Figures, Variables & Structure
  • Involve indesignanddevelopmentof Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.

TECHNICAL SKILLS

  • SAP CRM 7.0
  • SAP BI 7.0
  • SAP Business Objects XI 3.1 Suite
  • Designer Web Intelligence Rich Client
  • BEx Query Designer
  • BEx Analyzer
  • Xcelsius 2008
  • Sybase IQ
  • Modules: CRM
  • SD and FI.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

SAP HANA Lead Consultant

Responsibilities:

  • Worked as lead HANA XS developer, designed and developed an enterprise level XS application.
  • Expertise in RESTful service design and development using XSJS for JSON and XML
  • Sound Knowledge on how REST fits within SOA.
  • Used SAP HANA Web-based Development Workbench for SQLScript editor, SQL Script debugger and a Calculation View editor.
  • Worked on SQL queries to create Information models, tables, stored procedures.
  • Good understanding of HANA appliance architecture and hardware, Worked on HANA installation and Configuration phases
  • Worked on Extracting the data from Jsonapi to Hana cloud platform, by using serverside outbound API.
  • Expert in set-up, provision and run services like MongoDB as a service on Cloud at HANA cloud platform.
  • Developed oData services on HANA XS Engine to retrieve and manage entries in staging tables.
  • Expertise in backup and restore of HANA Database.
  • Involved in Development in WebIDE and configuration of Hana Cloud Platform (HCP).

Confidential, Pleasanton, CA

SAP HANA Lead Consultant

Responsibilities:

  • As a HANA consultant, gatheird business requirements and deliverables for report requirements alongside functional end users in the business areas. Conducted analysis to identify business content data sources for Enterprise Data warehouse.
  • Participated in Blueprint and design sessions, review options and provide recommendations while communicating the benefits, risks and constraints to both the business and IT stakeholders.
  • Expertise in Replication of Huge Volumes of data from Non SAP Systems like Flat file to HANA.
  • Involved in replicating Real time data using SAP Landscape Transformation (SLT).
  • Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
  • Created multiple schemas and table definitions. Experience in creating Attribute views, analytical views and calculated views.
  • Coordinated and responsible as Data Architect to assess and evaluate the business requirements, and design & develop a data access solution.
  • Expertise in HANA technology at the application, database and hardware appliance level
  • Expert in business development of HANA solutions involving process and technology.
  • Experienced in applying privileges.
  • Involved in Architecting the entire BI-HANA solution with mixed approach data Flow design involving SAP ECC and other systems as source systems and using BW powered by HANA as Enterprise Data warehousing application by utilizing existing extractors to load transactional data into DSO objects to formulate Analytical views, Attribute views and Calculation views (Using HANA Studio/Modeler Perspective) exposed to frontend layer implemented with SAP BO.
  • Expertise in Derived attribute views, Time based attribute views, Currency conversions for advance modellings. Loading data into table definitions, suspending data loads, resuming data loads.
  • Involved in Administration and operation including monitoring backup and restore security and user management.
  • Involved working with content models attributes and measures.
  • Extensively experienced in trouble shooting, investigating, analyzing and solving problems.
  • Retrieved the data from multiple tables using inner join, left outer join, Right Outer join, and full outer join, Based on the complexity of the requirements, created Scripted Calculation Views and Stored Procedures.
  • Migrated HANA content from development & testing environments to Production environment using delivery units.
  • Collected the objects in Delivery unit, and Developer mode.
  • Worked on currency translation and Input parameters, Decision tables.
  • Good understanding of Performance consideration while designing HANA views and blue printing.
  • Experienced in creating complex Business Objects Reports and queries with constant interaction with the end users. Repeatedly used functionalities such as Slice and Dice, Drill mode, Ranking, Scope of Analysis, Aliases, Contexts, functions, Derived tables, Cascading Prompts, Filters etc. for Multidimensional Analysis.
  • Worked Closely with SAP BO reporting team on the requirement needs for WEBI and LUMIRA reporting.
  • Improved the performance and reduced the coding by learning and implementing use of CE functions.
  • Coordinated and worked along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs.Participated in meetings with upper management, business analysts and users in understanding the business requirements and analyzed various use cases for developing WEBI reports.
  • Responsible for optimization and data access performance tuning.
  • Created various LOVs for ease of Ad-hoc reporting in the process of building the Universes.
  • Created reports in WEB Intelligence module and implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.

Environment: SAP HANA 1.0, SAP BO 4.0, SQL, SAP LUMIRA, BEx Reporting, Web Reporting, Report Designer.

Confidential, Dallas, TX

SAP HANA, BW Consultant

Responsibilities:

  • Design the entire landscape of EHP7 on HANA SP06
  • Experience on HANA solution specification - Single Node Applying support patches on HANA DATABASE
  • Involved in Business and Architecture discussions
  • Good understanding of various component of SAP HANA
  • Worked on creating Attribute views, Analytic views and Calculation views
  • Determined the size and scope of technical developments for HANA Project
  • Performed UNION and INTERSECTION between views to represent business cases
  • Worked on SQL queries to pull the data
  • Security including User Management, Roles, and Privileges
  • Design and implementation of SAP SLT replication schemas in SAP HANA
  • Worked closely with SAP Technical team on Implementing the first customer’s project on HANA Applying support packages using SUM 1.0 SP9
  • Expert in business development of HANA solutions involving process and technology.
  • Experience handling integration between multiple systems for reporting - SAP ECC, SAP, BOBJ
  • Involved in business discussions and Designed Blue Print Document for FI-GL, CRM, SD/MM/PP, CO-PA.
  • Project plan with deliverables and play backs to demonstrate the demo reports.
  • Involved in Architecting the entire BI-HANA solution with mixed approach data Flow design involving SAP ECC and other legacy systems as source systems and using BW powered by HANA as Enterprise Data warehousing application by utilizing existing extractors to load transactional data into DSO objects to formulate Analytical views, Attribute views and Calculation views (SQL Script and CE functions) exposed to frontend layer implemented with SAP BO.
  • Installation of Business content objects: Info Objects, DSOs, Cubes, Transformations.
  • Worked on SD, FI-GL Data Flow and Sales and Delivery Reports.
  • Worked on LO Cockpit Data source activation, setup tables’ deletion, Delta Configuration.
  • Generated Costing based COPA data source.
  • Worked on Extracting ECC data using LO Extraction and Generic Extractor.
  • Installed LO Cockpit Extractors and configured Deltas.
  • Worked on Billing Reports - Net Value of Sales and Returned Sales; Weekly & Monthly Delivery Sales.
  • Worked on Quotation Overview and Quotation Tracking Reports
  • Created Generic Extractor. Created DSO, Cubes and Multiproviders.
  • Worked on APDs to create a CSV files on Appl Server with selected data from Cubes/Multiproviders
  • Worked extensively on BEx, created structures, Calculated Key Figures, Restricted key Figures, variables.
  • Created Delivery reports to analyze Delayed Delivery orders & Pending orders

Environment: SAP HANA SP9, SAP BW 7.3, SAP SD, SAP Bex Query designer, Bex Analyzer

Confidential, Hartford, CT

SAP BI, BO Consultant

Responsibilities:

  • Created Business Objects Universes and Webi reports, Crystal reports based on the requirements.
  • Business Objects Migration experience migrating contents from older versions to newer versions of Business Objects Enterprise.
  • Extracted Accounts Payable (0FI AP 4) and Accounts Receivable (0FI AR 4) data from R/3 for developing DSO (Day Sales Outstanding Reports, Late Pay Metrics Reports) and procurement data from R/3 using the Purchasing Header (2LIS 02 HDR), Purchasing Item (2LIS 02 ITM), Schedule Line (2LIS 02 SCL) and COPA to extract data for Invoice Proceeds related to FI Work stream and areas like APO for Demand Planning.
  • Extensively worked on SAP BW delta loads, Maintaining update rules, InfoPackage creation, modifying communication structures. Supported day-to-day data loads.
  • Collected requirements in specific areas of SD, MM and FI-CO.
  • Designed and developed several universes with calculated measures and custom filters.
  • Designed, installed, and configured system for new implementations, upgrades, and maintenance.
  • Manage incidents, including complex troubleshooting across technologies.
  • Coordinated configuration, change, release, capacity and availability capabilities.
  • Extensively involved in training users in Web intelligence, Crystal Reports, and Xcelsius Through training led scenarios.
  • Interacted with Business Users to know their needs to TEMPeffectively develop and modify Universes.
  • Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports. Involved in migration 3.1 to 4.0.
  • Designed/Modified the Universes as per the requirements adding new classes and objects as required.
  • Used derived tables to create the universe for best performance, and use context and alias tables to solve the loops and traps in the Universe.
  • Created reports in WEB Intelligence module and implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.
  • Created Projects, Jobs, Workflows, Dataflow based on the mapping document to load the data from staging tables to target tables

Environment: SAP BI 7.0, SAP Business Objects XI 3.1 Suite (Designer, Web Intelligence Rich Client), BEx Query Designer, BEx Analyzer, SAP FI.

Confidential, Detroit, Michigan

SENIOR SAP BI Consultant

Responsibilities:

  • Worked on multiple projects (GSI Finance Integration project, MRA & BOBJ reporting project, SRM BI reporting Project and Bank Balance Project with Hana Integration.)
  • Worked on Integration of GSI Commerce and retailfinancial solution with the existing Business Reporting system.
  • Implemented comprehensive BankBalancereporting solution for Bank Statements already available in ECC.
  • Worked on integrated planning for FPL statement planning
  • Implemented BW reporting solution on APW invoice sytem.
  • Enchaned New GL realtime and Non real time solutions with minimum impact to meet the business needs
  • Implemented SRM BI reporting solution on shopping carts and Purchase order approvals
  • Created and modified existing inbound and outbound interfaces(khalix, Metrices..) to flow data.
  • Created new reports and modified existing reports to meet GSI and business reporting.
  • Enchaned For management reporting, business needs the flexibility to move expenses between profit centers and reflect the changes on historical and new balances.
  • Enhanced New GL realtime and Non real time BI back end solutions and making profit center as reporting attribute .
  • Worked on a POC project forSAPHANA on new GL solution.
  • Worked on BO explorer, Business objects Webinteligence reporting on BW queries and infoproviders.

Environment: SAP BI 7.0, SAP Business Objects XI 3.1 Suite (Designer, Web Intelligence Rich Client), BEx Query Designer, BEx Analyzer, SAP FI.

Confidential

SAP BI Consultant

Responsibilities:

  • Involved in complete lifecycle implementation of the project from gathering user requirements, creating fields mapping documents from SFDC to SAP BW thru SAP CRM. Design and modelling the DSOs and InfoCubes, Integration testing, unit testing, UAT to Go-live and production support.
  • Activated the business content and enhanced the various master data objects like Business Partner, Target Groups, Lead GUID, Marketing Element, Product and CRM User and loaded the data from SAP CRM.
  • Activated and enhanced the transaction data data objects for Sales & Marketing mart: Campaigns, Leads, Opportunities and Contracts Service mart: Service Requests, Service Orders and Activities.
  • Added custom fields to the standard extractors using Application Enhancement Tool (AET) in CRM.
  • Developed Virtual Provider for Service Requests to meet the real-time reporting requirement.
  • Created Transfer rules and transformations from datasources to data targets using various types of routines like start routines, transfer routines and inverse routines.
  • Extensively involved in implementing the BADIs CRM BWA MFLOW and RSU5 SAPI BADI in customizing the standard extractors of CRM.
  • Created generic data sources for Employee master and CRM User Master based on Function module and View respectively.
  • Built BEx queries for the real-time operational dashboards (Service Desk Dashboard and VZW SLA Metrics) with Restricted Key Figures, Calculated Key Figures and Variables.
  • Built real-time operational dashboards (Service Desk Dashboard and SLA Metrics) using Xcelsius and SAP Netweaver BW Connection (BICS) with detail level drill-down Web Intelligence reports.
  • Developed universes and Webi Reports based on SAP Datasources.
  • Unit testing of the real-time Dashboards and Business Objects reports by data validations by comparing data against the BEx queries using BEx Analyzer and WebI reports.
  • Used trace mechanisms ST12 and Fiddler to trace the data issues from CRM to BW and from BW to BO respectively.
  • Performed performance tuning and debugging of data issues in reports by doing MDX trace test on BW and debugging the real-time extractor in CRM.
  • Did master data attribute and text data loads and implemented attribute change run to all the required master data objects.
  • Created the Open hub destinations, transformations and loaded data into Sybase IQ database through the logical file path and UNIX script.
  • Implemented RDA (RealTime Data Acquisition) in order to streamline the data loads into Sybase IQ database with a 10 minute interval.
  • Automated the process of dataloads from SAP CRM to Sybase IQ thru BW using process chains.
  • Loaded the data from the CRM 7.0 into BW, Involved in data load monitoring, fixed the issues and Performance optimization.
  • Extensively worked on data load issues and streamlining the process chain loads to not run the next PC if another in progress and to Bypass the Sybase IQ load if no delta records exists.
  • Extensively involved in UAT, Go-live and post production issues.

Environment: SAP CRM 7.0, SAP BI 7.0, SAP Business Objects XI 3.1 Suite (Designer, Web Intelligence Rich Client), BEx Query Designer, BEx Analyzer, Xcelsius 2008, Sybase IQ, Modules: CRM, SD and FI.

Hire Now