We provide IT Staff Augmentation Services!

Sap Hana Consultant Resume

Seattle, WA

SUMMARY

  • 7 Years of experience as SAP BW/HANA consultant providing end - to-end reporting solutions to business stakeholders from a wide range of industries
  • Expert in In-memory, row and column based HANA concepts, HANA migration and Extraction with data provisioning techniques like SLT (SAP Landscape Transformation), ETL (BODS) and DXC (Direct Extractor) for SAP and non-SAP data
  • Extracted data from SAP ECC by using SLT and BODS with HANA data provisioning techniques from legacy database, SAP and Non-SAP data
  • Worked on 2 full life-cycle implementation projects involving gathering of functional requirements, analyzing data flow, performing data provisioning using SLT, creating graphical views on SAPHANA Architecture and creating reports using BEx, Lumira and Webi
  • Experience on business process reengineering for corporate reporting solutions, reporting performance optimization, data modeling using different types of graphical views and SQL
  • Industry knowledge in the areas of FI/CO, SD, MM, PP, PS, IS-U, SCM, CRM, BPC, QM functionality.
  • Hands-on experience with SAP BW (BW Extractors, ODS, Info-Cubes, Info-Sources, Info-Objects, BEx Analyzer, BEx browser)
  • Built ETL flow from BW for Master/Transaction Data Loads with extraction/Retraction, Process Chains, dimensions, and script logic for Allocation and Currency Conversion, business rules.
  • Expertise in OLTP extraction from SAP ECC into BW using different extraction structures such as FI, CO-PA, IS-U and Generic Extractors along with flat file extractions of data from non-SAP
  • Worked extensively on new BW info-providers like aDSO’s, Composite Provider & open ODS
  • Experience in both onshore and offshore business models for delivering the business solutions
  • Strong analytical, interpersonal and communication skills with the ability to have executive interactions
  • An enthusiastic team player with strong leadership skills and an ability to develop creative solutions for challenging client requirements
  • Proficient in data modelling using BW extended star schema model
  • Proficient in evaluating requirements and implementing BI solution for Clients
  • Extensive experience in implementation, Development as well as Production Support projects
  • Performed extensive Logistic extractions, Finance and generic extractions
  • Worked on queries using BEX Analyzer, BEX workbooks and WAD.
  • Extensively used structures, variables, exceptions, conditions, restricted and calculated Key Figures and customer exits in reporting
  • Experience in Performance Tuning.
  • Proficient in handling support projects. Analyzed and corrected production problems as they occur in the SAP BW system.
  • Experience on implementing BW 7.5 new concepts.
  • Experience in Full Lifecycle HANA Implementation in Native Hana (HANA Studio) and BW on HANA Implementation.
  • Created Technical specifications and Logical modeling documents for HANA.
  • Having Strong Knowledge on SAP HANA Data Modeling using Attribute views, Analytic Views and Calculation Views (both Graphical & SQL script based) & SAP HANA data provisioning using SAP LT Replication Server (SLT).
  • Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script and CESQL scripting.
  • Worked on HANA with Business Objects reporting tools like Dashboard, WEBI Crystal Reports etc.
  • Good Exposure on Schemas, table definitions, attributes, table definitions, Attributes, Measures & Hierarchies in HANA.
  • Experience on HANA Integration with IDT and UDT Semantic Layers.
  • Experience in importing data from flat file to HANA data base Tables.
  • Having Good Experience in data provisioning method SLT and Maintained real time data replication from ECC to HANA.
  • Worked on Different types of Transformation in BODS Like Query, Merge case, Key generation and Pivot Transformations Etc.
  • Migrated HANA content (Packages, Information Models) from development, testing environment to production environment using delivery Units.
  • Good Knowledge in SAP HANA security including user Management, Roles and Privileges.
  • Sound Knowledge on Decision table, Mass Copy, Migrate, Auto Documentation, delivery units, Data Provisioning, Import and Export.
  • HANA SQL SCRIPTS & CDS CORE DATA SERVICES - Strong experience on Creating SQL, Stored Procedures with SQL Script and also with Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like - Tracing, Using the SQL Script Debugger.
  • HANA SECURITY & TRANSPORT- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges. Hands-on experience on all three modes of transport - Delivery Unit mode, Development mode, as well as on the ‘SAP support mode’, Apt in Direct metadata import - mass import of metadata, selective import of metadata.
  • Experience on Universe, Tableau, WEBI, SAP Business Objects 4.0, Web Intelligence, OLAP Analysis Explorer
  • Knowledge on Data integrator and Data Services, SAP Business Objects MOBI and SAP Mobility, Design Studio, Lumira
  • Proficient in SQL
  • Worked on ETL development involving objects like real-time/batch jobs, workflows, data flows Transformations (Query, SQL, and Merge).
  • Experience in performing BODS mapping at source level, target level and performance tuning SQL.
  • Performed Batch jobs to extract data from SAP BW (DSO & HANA Calculations Views), transform the data and load into specified destinations either generating files or into target tables.

TECHNICAL SKILLS:

SAP Systems: SAP HANA; SAP BW 7.5, 7.3; ECC 7.0,S/4 Hana 1709

Reporting Tools: BEx Analyzer, Lumira, Webi, Universe Designer, Information Design Tool, Crystal Reports 2008/XI, Import Wizard, Report Conversion tool and services, Scheduler

ETL Tools: SLT, SAP Data services, DXC (Direct Extractor Connection), Flat File Uploader

Databases: Oracle 11i/10g/9i/8i; SQL server 2005, 2008

Operating Systems: Windows 10 & prior version; Linux

Internet Technologies: HTML, XML, Java script

Microsoft Technologies: MS Office Suite (Advanced Excel, Word, Power point, Outlook)

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

SAP HANA Consultant

Environment: BI, BW 7.4, ECC 6.0, BODS, HANA DB

Responsibilities:

  • Worked with the business togather user requirements,analyzed reporting requirements andcreated technical specifications worked closely with the client inall phases to design, build, test and deploy
  • Worked on a full life-cycle implementation project involving gathering of functional requirements, analyzing data flow, performing data provisioning using SLT, creating graphical views on SAPHANA Architecture and creating reports using BEx, Lumira and Webi
  • Analyze business requirements, review existing systems, define the solution, and translate that into detailed design documentation then efficient and accurate code.
  • Developed reports, dashboards, and analytic solutions using technologies in the SAP Business Objects BI suite, Microsoft SQL Server,SAP Business Objects Design Studio, Lumira, and Webi
  • Testing of reports against universes and database connections and validating the report data against the database.

Confidential

SAP BW/HANA Consultant

Environment: BW 7.4, ECC 6.0, BODS, HANA DB, CRM & SD.

Responsibilities:

  • Worked with the business toGather User requirements,analyzed reporting requirements andcreated technical specifications
  • Worked closely with the client inall phases to design, build, test and deploy
  • Extracted data from SAP ECC by using SLT and BODS with HANA data provisioning techniques from legacy database, SAP and Non-SAP data
  • Successfully designed and developed the whole data model like Attribute views, Analytical views and Calculation views in S/4 HANA for Enterprise reporting in SAP
  • Designed, developed and implemented enterprise-level Business Intelligence solutions to address ongoing business strategies based on business requirements, technology standards and service level agreements with different modules
  • Involved in extraction of Data from R/3 to BW using LO Cockpit for Sales Order Header, Sales Order Item, Billing, Delivery, Purchase and Finance
  • Successfully designed and developed the whole data model like Attribute views, Analytical views and Calculation views in S/4 HANA for Enterprise reporting in SAP of Purchase order data like invoice, goods receipt and purchase order values, quantities and dates for in-depth analysis of purchasing data at purchase order item and scheduling level
  • Interacted with senior management and business leaders to elicit business and technical information in-order to produce high quality decision making solutions. Worked closely with SME’s, functional specialists and process owners to gather detailed business requirements and translated the requirements into robust reporting solutions
  • Responsible for understanding the client business process, review the functional specifications and provided the estimates for reports development and resource. Involved in estimating the manhours for Change Requests and time lines planning for whole reporting requirements
  • Responsible for providing leadership, guidance, and mentoring for a team of 5 Business Intelligence members
  • Responsible for defining and driving the use of standards for BI work and review the quality of the development work. Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity
  • Identify the need of custom extractors or the right model on native HANA or BW on HANA or hybrid model on BW with HANA, design and implement end to end dataflow for different data
  • Created the Attribute views, Analytical views and Calculation views in SAP HANA Studio. Enhanced the existing standard HANA Live views and integrated with BO reporting tools for Ad-hoc or formatted reporting
  • Created SAP CDS views like Basic views, Composite views and Consumption views with Object Model Category like Text, Dimension, Fact, Cube models in DDL (Data Definition Language) and AMDP views with SQL for Master data and transactional data for real-time reporting solution.
  • Involved in extracting the data from SAP ECC by using the SLT and BODS by HANA data provisioning techniques from legacy database, SAP and Non-SAP data for different modules and Ticketing data.
  • Worked with basis team to transport HANA calculation view, BO reporting objects from Development system to Quality system and Production system.
  • Created Business Objects reports like Time Phase Management, Vendor Score card, Line List, Shipment reports in BO WEBI and Analysis of Office and created Sales dashboard with BO Design Studio reporting tools.
  • Extracted Sales Order Header, Sales Order Item, Billing, Delivery, Purchase and Finance data from SAP to SAP Hana by Data provisioning using SLT and created attribute views, analytical views and calculation views and joined the relationship to meet the business requirement and analyzed using Bex analyzer and created report.

Confidential

SAP BW/HANA Consultant

Environment: BW 7.5, ECC 6.0, HANA DB, BODS, BEX

Responsibilities:

  • Worked on FI, SD, CRM-BW integration projects and involved in the major financial reconciliation project between data posted in GL against the EIP system. Involved in project design, development and unit testing and providing KT sessions to the team after completion.
  • Extracted Sales Order Header, Sales Order Item, Billing, Delivery, Purchase and Finance data from SAP to SAP Hana by Data provisioning using SLT and created attribute views, analytical views and calculation views and joined the relationship to meet the business requirement and analyzed using Bex analyzer and created report.
  • Worked extensively on Administrative Workbench (RSA1) and customized different InfoCubes, Transfer rules, Update rules, Routines etc., according to the client requirements.
  • Created Cubes, ODS and Multi Providers for the Sales and Distribution, Material Management Reporting.
  • Prepared LIS extractor in Sales and Distribution by creating information structures and thus generating data source and configuring for Initial, Delta and Full updates.
  • Customized Business Content extractors in LO customizing cockpit and also took necessary steps in converting LIS to LO data extraction.
  • Extensively worked on Web Reporting, BEx Analyzer for designing the reports on Sales, Deliveries, Shipment, Purchasing, and Inventory using Conditions, Exceptions, and Variables & Structures.
  • Used BEx Analyzer for enhanced the already created queries. I created Calculated Key Figures, Restricted Key Figures and Variables in the existing queries.
  • Created a BW report on Sales Analysis Enquiries and a report on Daily Bookings and Shipments using company code.
  • Created reports on general quotation information at sales area level, Material availability analytics back orders and Incoming orders per Calendar year and month.
  • Created a new workbook to identify discrepancies between the material values as per the purchase order and the materials invoiced based on plant, vendor, and material for various periods.
  • Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing reports based on various roles.

Confidential

SAP BW

Responsibilities:

  • Worked with the business to gather requirements and participated in designing solutions in line with the SAP best practices and Involved in the end to end implementation from requirement gathering to post go-live activities in Finance and Quote to Cash modules.
  • As a part of an implementation team, helped in the design of an end to end data flow to get new GL transaction data, LFL Data, Exchange rates and Master data from ECC to BW including activation of standard business content, creation of DSO, Cubes, Transformations, and Routines.
  • Involved in extracting the data from SAP ECC by using the SLT and BODS by HANA data provisioning.
  • Created the HANA optimized InfoCube/DSO, Composite providers, Transient provider, InfoObject on HANA Attribute view, InfoCube on HANA Analytical view, Open ODS view on HANA Calculation view and vice versa. Pushed the BW standard transformation code into HANA ABAP.
  • Successfully designed and developed the whole data model like Attribute views, Analytical views, Calculation views and Procedures in S/4 HANA for Enterprise reporting in SAP Finance data like General Ledger transactions, Global Expense dashboard, Global P&L dashboard and Accounts Receivable dashboard, Media Product master, Projects, Asset accounting dashboard.
  • Designed and Developed HANA Model for sales report using Sales Order Header, Sales Order Item, Billing, Delivery, Purchase and Finance data from SAP to SAP Hana by Data provisioning using SLT and created attribute views, analytical views and calculation views and joined the relationship to meet the business requirement and analyzed using Bex analyzer and created report.
  • Administrative deliverables included maintenance of dimensions, properties and models, creating and monitoring of data manager packages and data loads (transformation and conversion files).
  • Took the ownership of running the month end and year end processes (changing work status, running recon reports, ownership maintenance, exporting journals, executing controls, closing and opening of prior time periods etc.).

Hire Now