Sap Hana Architect/modeler Resume
3.00/5 (Submit Your Rating)
SUMMARY
- 12+ years of experience in software Industry as a SAP BI/HANA Consultant.
- 6+ years of experience in SAP HANA 1.0 and 2 years of experience in SAP BO.
- Involved in development and implementation of SAP BI. Worked extensively on various functionalities of BI.
- SAP Certified Application Associate - SAP HANA 1.0
- Strong and experienced team player, with excellent communication and interpersonal skills. Proven ability to work independently.
- Able to learn new technologies, concepts and Business processes quickly, evaluate their applications, and apply them to business need when appropriate.
- Worked on SAP HANA implementation projects with both native HANA and SAP BW on HANA.
- Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0
- Worked on installations of SAP HANA SDI configurations and SAP HANA cockpit environment.
- Experience in SAP Business Objects Universe Design, Web Intelligence and Tableau report development. Knowledge on Big Data, Analytics and IoT technologies.
- Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.
- Excellent knowledge and experience on: HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
- Exposure on S4 HANA deployment options and knowledge of new S/4HANA features.
- Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.
- Excellent issue resolution skills which are raised over BW on HANA migration.
- Experience in Importing BW models (Info Cube, DSO) in HANA as Analytical view.
- 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 Data-Provisioning techniques using SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
- Expertise on BW on HANA, HANA LIVE VDM, HANA LIVE Browser, SLT, Information Models.
- Worked on all technical aspects of SAP BI and familiarity with right from SAP BI Administration Workbench.
- Proficiency in analysis, development, implementation of Standard / Customized Info Cubes, DSO, BEx Analyzer, BEx Browser.
- Extensive experience in creating/configuring Info Objects, Transformations, Info cube, Communication Structure, DSO, DTP, Error handling, Info packages, Scheduling, Monitoring.
- Worked extensively on Aggregates, Compression, Partitioning, Navigational Attributes to improve data load and query performance.
- Worked extensively on Extraction (Flat File, Business Content, LO Cockpit and Generic Extractions. Experienced in Activation and Installation of Business Content.
- Experience in creating Queries & Reports in BEx Analyzer, BEx Browser and Customized/Configured Queries using Calculated Key figures, Restricted Key Figure, Filter, Exceptions, Variables, Conditions and Structures.
- Experience in creating web reports using WAD.
- Experience in building Multi Providers as per query needs.
- Knowledge on Process Chains, Performance Tuning, Enhancements, Open Hub Service.
TECHNICAL SKILLS
ERP Packages: SAP R/3 version 4.6C, 4.7 Enterprise.
Data Ware Housing: SAP BIW versions 3.0B, 3.1c, 3.5 and B.I 7.5, SaP S/4 1610
OLAP Tools: SAP BI/BO 4.0, HANA SPS09/10/11, Webi 4.0
Operating Systems: WINDOWS 2000/2003/NT/XP
Data Bases: Oracle, DB2 and HANA 1.0
Languages: ABAP/ 4, SAP HANA SQL Script
PROFESSIONAL EXPERIENCE
Confidential
SAP HANA Architect/Modeler
Responsibilities:
- Leading and implementing multiple native HANA projects in Global Supply Chain domain while closely working with different business users, analysts, strategists and solution managers for Universal Order Visibility (UOV) initiative.
- Extensively involved in Project design, roadmap, detail designs and Development approaches.
- Architecting and developing complex HANA-XS information models such as Analytic/Calculation Views (Graphical/Scripted), SQL procedures (.hdbprocedure) and CDS entities (.hdb/.hdbdd).
- Integrating and consuming data from Hadoop in HANA for data archiving project using Smart data access (SDA) connectivity. Coordinating with DBA and implementing security.
- Defined web-based data access by building consumption models in HANA XSJS (server-side JavaScript) exposing HANA artifacts to client applications.
- Configured and Installed HANA EIM (Enterprise Information Management) to create SDI/SDQ flowgraphs, Data Provisioning (DP Server configuration) Agents/Adapters, Virtual Tables, and Replication Tasks (.hdbreptask) and Security using HANA Web IDE.
- Exploring HANA Rules Framework (HRF) to build automated decision making and solutions that require business rules management capabilities. Participated in the installation process along with DBA team. Building Rules, Vocabularies and Services for Rules management.
- Presenting demo’s by showcasing new HANA features and capabilities and how it can efficiently solve client’s current use cases.Coordinating with Informatica ETL team for data integration/data quality and advocating them for efficient data loading strategies.
- Participating in peer design review sessions and also providing recommendations to the client for efficient HANA data modeling strategies
Confidential
SAP HANA Architect/Modeler
Responsibilities:
- Worked with project business requirements and involved in preparation of client SOW and lead project delivery for green field implementations.
- Mapped business requirements to the technical architecture design and information model in SAP HANA.
- Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
- Worked on multi system landscape architecture and integration aspects between heterogeneous system technologies in the areas of HANA Implementation, Modelling, Security & Authorization, Data Provisioning, SAP HANA Administration, reporting.
- Involved in creating Packages, Schemas, Tables and Information views like Attribute views, Analytic views, and Calculation views(SQL Script based and graphical based).
- Implement HANA development best practices and develop performance optimized solutions.
- Good exposure on various components of SAP HANA. Worked on SAP LM and CTS++.
- Worked independently with minimal supervision and ensure timely deliverables.
- Developed models in HANA studio and tested by replicating the data using SLT and BODS.
- Worked on HANA stored procedures with parameters from BODS.
- Developed Advanced Models using either by SQL Script or Calculation Engine (CE) functions or CE Operators.
- Designed and Developed SAP HANA artifacts such as Attribute Views, Analytic Views and Calculation Views. Created Composite Calculation views that includes variables, input parameters and calculated columns.
Confidential
BI/HANA Consultant and SAP HANA Modeler
Responsibilities:
- Involved in creating Packages, Schemas, Tables and Information views like Attribute views, Analytic views, and Calculation views(Sql Script based and graphical based).
- Tested BI reporting performance and data loading performance by reconciling the results in Oracle and HANA databases.
- Good exposure on various components of SAP HANA.
- Worked on latest features of SAP BI 7.4 and fixed various issues after BW- HANA Migration.
- Worked on LSA++ architectures and reduction of staging layers. Designed LSA++ data flows with SPO’s.
- Developed use cases in HANA side car and tested by replicating the data using SLT and BODS.
- Worked on HANA stored procedures with parameters from BODS.
- Designed and Developed SAP HANA artifacts such as Attribute Views, Analytic Views and Calculation Views.
- Created Composite Calculation views that includes variables, input parameters and calculated columns.
- Developed Advanced Models using either by SQL Script or Calculation Engine (CE) functions or CE Operators.
