Senior Sap Hana Consultant Resume
3.00/5 (Submit Your Rating)
PROFESSIONAL EXPERIENCE:
- 9 Years and 2 months of total experience in SAP HANA /BW as module delivery lead Consultant.
- 7 Years of experience in SAP HANA (Certified Associate of SAP).
- Experience to drive projects through full development cycle within project and budget parameters.
- Extensively involved in all phases of life cycle including Requirement Gathering, Business blueprint, Realization, Final preparation, Post Go Live Support and Documentation.
- Experience in leading a team of technical consultant and deploy the requirement within the timeline.
- Worked in Confidential HANA full cycle development, implemetation and support Project for multiple clients.
- Proficient in analyzing and translating business requirements to technical requirements.
- Quick learner, excellent in learning new technologies and quickly adapting to new environment
- Dedicated, Innovative and self - motivated team player with an ability to easily assimilate new ideas, concepts and methods
- Ability to design data modelling as per business requirement and developed Confidential SAP BW object development and native HANA implementation.
- My Core skill is SAP BI/BW on HANA and Enterprise HANA with good knowledge and leading the team for requirement gathering, development of the applications,testing, delivery and post delivery supports.
- Flexible, result-oriented and adaptive to the environment quickly to meet the goals of the product and the organization.
- Designed data flows based on FS in the HANA Data modeler and also worked on data provisioning.
TECHNICAL SKILLS:
- Have worked on Native HANA and have good working experience in SQL/Graphical Methods for creating views.
- Have created Information Models in Native HANA such as attribute, analytical view, calculation view, HDB table, Dimensional CV s, synonyms, sequence, procedures etc.
- Worked on SQL Joins and have Good knowledge on them.
- Have used available Functionalities available in SAP HANA Input Parameters and Variables. Worked on Creating Calculated Columns and Restricted Columns.
- Good knowledge and experience on SCD types like type 1 and type 2.
- Have worked in transport of BW and HANA objects from devlopment till production through Confidential system movement and validations.
- Have sound working Experience on Integration of SAP BW and HANA and can combine the data models either sides and can able to provide complex business solutions.
- Implementing CDC logic in BW with the help Master data time dependent attributes and providing delta data for the down feeds.
- Have used BW objects like MD and DSO data into HANA using standard meta data tables and built view on top of the BW Tables like Active tables of DSO or MD tables based on the requirement.
- Worked extensively on Administrator Workbench(RSA1)
- Expertise in Business Warehouse Components like standard Extractors, Info Cubes, Info Objects, DSO,IP and DTP etc.
- Experienced in BW on HANA objects such as ADSO, Composite provider and open ODS.
- Worked exclusively on ECC 6.0 such as Data dictionary,Data comparision in the standard ECC transactions.
- Worked in creation, scheduling and monitoring the Process chain to make the data flow in BW.
- Have worked in BW transport through transport organizer and Transported HANA objects using Import and Exporting options with Confidential options like Developer mode, Delivery Unit and Confidential transport.
PROFESSIONAL EXPERIENCE:
Confidential
Senior SAP HANA Consultant
Responsibilities:
- Involved in requirement gathering and have worked on building the Functional Specifications
- Helping the team in understanding the requirements and deploy the requirements within the timelines.
- Involved in creating the complex information models such as calculation views and dimensional CV’s in native Hana.
- Responsible for validating the Confidential report with the ECC standard transaction output.
- Involved in the UAT validation and getting user sign off after the validation.
- Involved in creation of HDB tables and stored procedures to handle delta maintenance in HANA.
- Involved in creation of Process chain to complete the data loading process.
Confidential
Senior SAPHANA Consultant
Responsibilities:
- Involved in gathering requirements and documented the same as functional Specifications.
- Leading the project team, client communication and ensuring the delivery of the project.
- Involved in identifying solution and design Hana Models for the requirement.
- Worked in agile Process and used Jira for the Project updates.
- Involved in development of Confidential HANA Modeling objects.
- Lead the technical delivery of the Confidential 2 team from offshore.
- Involved in mentoring the new resources in the space of HANA.
- Developed the AFO reports on top of HANA Views.
Confidential
Senior SAP BW/HANA Consultant
Responsibilities:
- Involved in identifying solution for the existing design using SAP HANA.
- Created the implementation plan based on deadlines and delivered the project within stipulated timelines.
- Existing ABAP program was decoded, and it was designed and developed as HANA objects in the implementation.
- Worked on data modeling such as creation of Attribute views, Analytical views and calculation views.
- Worked on creation of design to implement the AS-IS flows as TO-BE flows using SAP HANA and BW.
- Worked on creation of procedures, synonyms, sequence, HDB tables, SQL files and scripted calculation views.
- Worked on the analysis, LLD, design modification and resource grooming.
- Accessing the HANA data models through the ODP data sources and external view.
- Expose the BW objects such as Info objects and DSO to the HANA system as the analytical view.
- Design the BW data flow and implement by consuming the HANA data model for the lookup of master data and transaction data.
- Worked for design, development and testing of Info Cubes, Multi providers, Info sources, data load process using Info packages, DTP, process chains and HANA Models.
- Involved in GO-NOGO- product explanation and Go live of the project is successful.
- Involved in fixing defects in QA and Production system during the hyper care and finished the product with zero bugs.
- The final table used by down streams, data stage tables and BO reports has been delivered as SAP HANA synonyms.
- As part of data provisioning, SLT, BW route and Flat file approach are used for the implementation .
- Responsible for providing knowledge transition to testing team, involved in fixing the bugs and moving the objects from Development to QA using Confidential + transport with Revtrac.
Confidential
SAP BW/HANA consultant
Responsibilities:
- Worked on the requirement analysis and design modification.
- Worked on data modeling such as creation of Attribute views, Analytical views and calculation views.
- Prepared technical specification based on functional specification
- Created ADSO with external HANA view setting and wrote complex calculations in Calculation view instead of writing in BW routines improving the performance.
- Create Transient Provider and Virtual Provider based on Hana model to consume HANA views to BW application.
- Used Calculated Key Figures, Restricted Key Figures, Variables, Free Characteristics, Filters.
- Created Process Chains to automate the Master and Transaction data loads
- Involved in creation of Attribute View, Analytical View and Calculation View.
- Experience in consuming the BW objects (DSO, Info object) as Analytic view and developed model on top of it.
- Experience in consuming the Master table of the Info object (Mtable, MView) and Active table of the DSO in SAP HANA database and developed model on top of it.
- Provisioning of Inventory, Production Planning, Customer and Materials data from ERP tables using SLT.
- Experience in consuming the HANA models into SAP BW with the help of Data source.
- Have used latest options in the data modeling such as Star join and SDI in the implementation.
- Implemented all the master data required for the implementation.
- Involved in testing Confidential info providers and working on the QA movement. Tested the Webi report and Dashboard data with the backend end tables and models to check the consistency.
Confidential
SAP HANA Consultant
Responsibilities:
- Hana to Hadoop data transfer is implemented successfully using the SQOOP technique.
- Hadoop to HANA data transfer is implemented using the smart data access.
- Attribute views, Analytical views and Calculation views have been created consuming the Hadoop data.
- Data tables were created in Hadoop consuming the existing views created in HANA from its base tables.
- Implementation of Hana-Hadoop models for the analysis of competitor is successful.
Confidential
SAP HANA Consultant
Responsibilities:
- SAP HANA Backend Models have been developed for different functional areas such as OTC, SD areas.
- BW on Hana Models has been developed and the same BW objects have been used in HANA data modeling.
- Involved in merging the other data base data to the SAP Data in HANA as part of the new firm acquired by our client.
- Involved in LO cockpit Extraction.
- Handled the Confidential variables which have Customer Exits and SAP Exits.
- Have thorough working experience in HANA Data modeling and Importing the data models from HANA to SAP BW and vice versa.
- Have a good understanding on Data Provisioning, SLT and Flat file load techniques has been used in this Project implementation.
- Responsible for requirement gathering, Modeling, User Acceptance testing, Go-Live and defect management.
- Have tested the reports in the BOBJ once it is developed and ensured that the requirement is satisfied for Each FS.
Confidential
SAP HANA/BW Consultant
Responsibilities:
- Understanding the existing SAP BW Models and documenting the business flows in SAP HANA.
- Have developed the needed BW Objects such as virtual providers, info objects in few of the reports as per the requirement.
- Involved in understanding the ABAP Logics implemented in BW system and have implemented the same in the Hana Modeling.
- Have thorough working experience in HANA Data modeling (Attribute, analytical and Calculation views) and Importing the data models from HANA to SAP BW and vice versa.
- Reporting on top of HANA views using WEBI and virtual providers using Confidential has been created and reused.
- Responsible for requirement gathering, Modeling, Report development, User Acceptance testing, Go-Live and defect management.
- Worked in WEBI SAP BO development for few reports through Self learning and executed it successfully.
- Lead the team from Offshore for the SD module delivery and reviewed the work of other team members as part of my work.
- Placed a final presentation on these reports to Client when they came here to take the final delivery of the Project.
- Post-delivery (hyper care period) handled the CR’s for the delivered reports.
Confidential
SAP BI Consultant
responsibilities:-
- Interacted with management and end-users and created Functional Documents based on their requirements, and have done Confidential analysis.
- Extracted data from SAP R/3 and from flat files into SAP BI System.
- Involved in Design, Development of the Business Information Warehouse and enhanced the R/3 extractors.
- Activated Business Content for standard Info Cubes and Info Objects.
- Transported the objects from Development to QA for testing.
- Worked for design, development and testing of custom and standard Info Cubes, Multi providers, Info sources, data load process using Info packages, DTP and process chains.
- Flexible queries using Confidential reporting features like variables, restricted key figure, calculated key figure, exception and conditions
- Delivered reports according to the user specified format.
- Responsible for Development, User Acceptance testing and Go-Live preparation.
- After Go-Live hyper-care support and project handover to support team.
- Responsible for post implementation process chain scheduling design.
- Have good hands on experience in Process chain monitoring.
- Involved in fixing the job failures that occurs in Production environment.
- Have worked on Tivoli job scheduler and ITSM tools.
- Have worked in Onsite-Offshore model and handled Weekly meetings from offshore providing updates and Involved in Knowledge transfer to Confidential new team members.
Confidential .
SAP BI Consultant
responsibilities:
- Involved in Batch job failure fixing process and Monitoring the Batch job run.
- Handled R&D for the job that fails frequently and fixed it permanently.
- Handled tickets and resolved some simple CR’s raised in Confidential reporting area.
- Involved in sending reports to the Client regarding the each and every job run on daily basis.
- Involved in coordinating with the client and developers in case of raising defects.
- Involved in debugging the ABAP code.
- Actively participated in Knowledge transfer and sharing views among the project members to effectively solve the problem.
- Involved in fixing issues that is reflected in Short dumps during the batch run.