We provide IT Staff Augmentation Services!

Hana Consultant Resume

2.00/5 (Submit Your Rating)



  • 14+ years in SAP consulting with wide experience in teh field of SAP Analytics
  • Over 5+ Years of working on Hana Projects as Architect, Administrator & Developer and Implemented Four projects on SAP HANA.
  • Experience working with Python for data wrangling (Numpy, Pandas), visualization (Matplotlib, Bokeh) and machine learning (Scikit - Learn)
  • Experience working on AWS EC2 instances for HANA, Hadoop
  • Experience working with MapR and Cloudera Hadoop implementations
  • Couple of Years of experience in CPI, HCI integration mechanisms
  • Experience with various source data replication mechanisms, (ETL/Log/Trigger based).
  • Experience with SAP HANA Data Provisioning and using SAP LT Replication Server (SLT) and SDI
  • Experience with Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.0
  • Experience with SAP HANA Data modeling using Attribute View, Analytic View, and Calculation View.
  • Experience handling integration between multiple systems for reporting - SAP ECC, SAP BW, BOBJ integration
  • Well versed in BW and BI solutions.
  • Installed, Upgraded Hana Systems Using LCM
  • Understanding of cloud, and distributed systems principals, including load balancing, networks, scaling, in-memory vs. disk
  • Experience with Large Scale/ Big Data methods, such as Map Reduce, Hadoop, Spark, Hive, Impala, Storm
  • Integrated SAP HANA with Hadoop
  • Migrated Data from oracle DB to SAP HANA
  • Experience in HANA Sand Box environment to model views and Hana Information Composer
  • Understanding of major programming/scripting languages like Python, Scala and/or R
  • Knowledge of NoSQL Products: MongoDB, CouchDB, Hbase and Big Table
  • Basic noledge of machine learning, statistics, optimization or related field is a plus
  • Used Hana Studio to Create Attribute Views, Analytical views and calculated views
  • Worked with both application specific extractors and generic extractors.
  • Well verse with SAP HANA Administration, Performance Optimization, Modeling using Different types of views, SQL, SQL Script topics
  • Experience with SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)
  • Authored Presenting Business Cases, Investment Areas, and Architectural Views to demonstrate value of technology/initiatives.
  • Proficient Knowledge in SAP Modules(FI-CO, AR,MM,SD,CRM)
  • Expertise in SAP HANA Administration, Performance Optimization (Python Admin Tool), Modeling using SQL, SQL Script, Java, L language, Predictive Analytics and Application Development, R Server integration with SAP HANA
  • Proficient in SAP HANA Data provisioning using SAP Landscape Transformation and SAP Data services 3.x,4.x


ERP: SAP R/3 ECC 5.0, 4.7/4.6c/4.5/4.0.

SAP In-Memory (HANA): Data Provisioning (Flat Files, Confidential, SLT for SAP & Non-SAP), Information Models(Attribute View, Analytic View & Calculation View ), SDI/SDA/SDQ

Reporting Tool: BOBJ WEB Intelligence, Cognos 8.x/7.x, TM 1 (Impromptu, PowerPlay), Business Objects XI 3.1(Web Intelligence, Xcelsius) BEx Reporting, Web Reporting & BW 3.5/3.x/2.x,, Crystal Report 7.X/8.X.,Lumira,Tableau

Programming Languages: Java, C++, Pl/Sql, UNIX Shell Scripts, XML

RDBMS: Oracle 10g/9i, SQL Server 7.0, DB2

Operating Systems: Windows XP/NT, UNIX

Tools: TOAD, PL/SQL Developer, Microsoft SQl Server

Scheduling tools: Tivoli

Version Control tools: PVCS, VSS

Data Modeling: SAP HANA Studio

Data warehouse ETL Tools: SAP Business Objects Data Services 4.0,Informatica Power Center 9.X/8.X

Data Mapping: XML, Electronic Data Interchange (EDI)

Data Formats: EDI, EDIINT, SAP IDocs, XML, xCBL, cXML

Web Based technologies: HTTP, HTML5, and JavaScript/JQuery

Data Acquisition: (SAP Data Services, ESP, SDS, SRS, SDI, SLT)

Reporting and Visualization: (SAP BI tools, Lumira)

Advanced Analytics/Predictive: (SAP Predictive Analytics, KXEN)

Technical architecture: (SAP HCP, Hadoop, SAP HANA, SAP HANA VORA)

Data Management: (SAP HANA, Hadoop/Spark, SAP HANA VORA, Sybase IQ)

Middleware Migration: CPI/HCI-DS, EDI, Dell Boomi


Confidential, NJ

HANA Consultant


  • Created Complex calculation billings views with optimum performance
  • Created Customer Calculation views and worked with big data team to get data loaded into AWS and PostgreSQL database
  • Worked closely with Business on Everchanging requirements and implemented teh logic on teh go

Confidential, Nashville TN

Big Data /HANA Architect


  • Used CPI REST services to Read data from different Social web platforms and generated
  • Positive sentiment analysis in Hana
  • Converted complex file integration-based flow to direct connection using jdbc call and proxy
  • Worked as a Sr. HANA Engineer (Multiple roles: HANA DBA, Data Provisioning and Data Modelling).
  • Built Custom API’s (LWS,PWS,IWS)- native Hana Applications based on XSA (XSJS, Java script) & SAPUI5 (front end) that consumes Hana XS OData Web service performing CRUDQ batch operations, deep inserts and client side validations.
  • Advised Customer on how to set teh development environment for Authorization and access control and maintain Application security via XS Admin.
  • Modelled and Created Artifacts- packages, attribute views, analytic views, calculation views, Analytic Privileges, Security, Procedures, Functions, Sequences, Views, Synonyms, Triggers, Decision tables, CE Functions, Attribute Mapping, Constants, and Hana CDS Views to support teh application development effort.
  • Configured SLT and used it for Real time data Provisioning.
  • Created Dimension Calculation views to get master data, Calculation views (with cube or Star Join) to get fact data and utilized Star schema modeling.
  • Creating information objects/Data models (packages, calculation views, Decision tables, Stored Procedures).
  • Created HANA models using both physical tables and virtual tables.
  • Created Analytic Privileges based on filters required as per teh users using teh privileges like restriction based in country and region etc. using normal filter and stored procedures upon teh data models.
  • Created Input parameters, Variables, Calculated columns, restricted columns (KPIs) according to teh business requirement.
  • Created Calculated Measures and Restricted Measures in Aggregation node to serve different business requirements.
  • Worked on performance tuning teh HANA models using Explain plan and Visualize plan.
  • Involved in design and development of Advanced DSOs and Composite providers.
  • Worked on migrating teh HANA objects from Development/Test environment to Production environment using Delivery Unit.
  • Involved in Transportation support for moving Delivery Units (DU) from development/QA system to production system.
  • Created complex calculations fields in tableau depending on teh business requirement and used these fields in dashboards.
  • Worked on creating Universe and exporting it to teh semantic layer.
  • Created filters, variables, prompts and calculations in teh universe for KPIs.
  • Data provisioning from SAP ECC system to HANA using SLT replication, to replicate tables from SQL server to HANA.
  • Loaded data into table definitions, suspending data loads, resuming data loads using SLT Replication.

Confidential, AR

SAP HANA Architect


  • Interacted with functional business units to analyze, gather and prioritize business and reporting requirements
  • Built data warehouse on stand-alone HANA with data from various sources like Big Data Hive, NetSuite, SalesForce, Oracle, MySQL, SQL Server, Sybase IQ, SAP ERP data, flat files
  • Imported data from Sales Force, HANA, MySQL into HDFS/Hive (data warehousing for Big Data) using Sqoop. Exposed data in Impala (fast analytics for Big Data). Re-developed teh GCS data marts using SQL in Impala.
  • Implemented Migration of POS data on Teradata platform to Sap Hana Using SAP Data services
  • Designed Blue print for data Rollout
  • Migrated schema, BTEQ queries and Teradata objects to SAP Hana
  • Performed leadership role in design, implementation, testing, and roll-out of enterprise BI applications including development of proof-of-concepts
  • Partnered with teh IT technical leaders and teams to manage teh key data processes, tools, and architectures needed to deliver confidence in regular reports and key business analytics
  • Implemented data management, governance best practices and standards
  • Hands on experience with HANA landscape using functionalities like data provisioning, Modeling and Administration, and Information Composer.
  • Proficient in Performance analysis of HANA system using SQL plan cache.
  • Expert in Delta merge analysis, and analysis of long running statement in HANA.
  • Supported add-on installations in addition to support packages and enhancement packs.
  • Monitoring and maintaining system and customer background jobs
  • Work with team to manage and maintain SAP HANA application and infrastructure systems.
  • Monitoring and administration of SAP HANA Databases using Solution Manager and DBA cockpit.
  • Share Hana noledge with team to enhance team capabilities
  • Well versed with replication methods like SAP Landscape transformation and Business Objects Data services.
  • Completed various certified courses and participate on various HANA open houses and webinars to keep upto date on technology.
  • Comprehensive modeling experience in creating various views like Attribute, Analytic and calculation views.
  • Hands-on experience with SQL scripts like stored procedures and CE scripting
  • Created Catalog and Content Procedures to Consume Information Models

Confidential, TN

SAP HANA Architect


  • Ability to review and gather business requirements and interpret these into an architectural design and information model in SAP HANA environment
  • Resolved Issues/Errors during Migration to Hana
  • Optimized DMO performance
  • Responsible for Improving Hana Performance using Query Plan analysis to identify long Running queries
  • Strong experience in all of teh following tools: SAP HANA studio, SAP Solution Manager, HANA cockpit, SAP HANA Database Lifecycle Manager (HDBLCM), SAP HANA XS Administration Tools.
  • Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
  • Implemented Table Partitioning to Improve Hana Data Load && Query Analysis
  • Experience in Managing Attribute Mapping and creating Constant columns, Analytics Privileges, Calculated Attributes
  • Expert in SAP HANA Modeling, Information Modeling, Data Provisioning, backup and restore, security and user management, Real-Time Replication
  • Responsible for Installation && managing Data services, Hana Software Platforms
  • Responsible for administering and maintaining BODS environment and providing day-to-day operational support, troubleshooting and fixing production issues.
  • Used OData Services(XSJS) for SAP FIORI / SAPUI5 projects.
  • Experience in SAP FIORI Implementation and Extensibility (Customization, Config, and Routing)
  • Design and develop OData Services(XSJS) for SAP FIORI project.
  • Developed User interface using standard SAP UI5(XSJS) Controls library to meet specific requirement of teh client and integration with backend system using OData services
  • Data stored in Information models was analyzed using Custom HTML5 UI (XSJS)written in jQuery and Bootstrap
  • Developed a responsive HTML5 application using teh SAPUI5(XSJS), JQuery, and JavaScript

Confidential, TN

SAP HANA Architect


  • Created Data services Job/Data flow to Populate Data from SQL server to HANA
  • Worked extensively on Information Data Modeling design like building attribute views, analytical views and calculation views
  • Created Data services Job/Data flow to Populate Data from SQL server to HANA
  • Created Text Analysis scripts to Identify and Separate Clients from Source Data and Mapping it to Master data
  • Expertly Configured and used Different configuration’s like Ling Analysis basic, 'EXTRACTION CORE VOICECUSTOMER', Ling Analysis full to Identify teh sentiment and content from Web Articles
  • Performed Address Cleansing and Name Cleansing for teh Customer Records.
  • Performed Parsing of Customer Details.
  • Experience in data warehousing techniques for Data Profiling, Change Data Capture, Data Cleansing, Slowly Changing Dimension, surrogate key assignment
  • Managed escalation process to resolve product issues working along with SAP support and system integrator.
  • Created OData Service(XSJS) for Hana Information models
  • Utilized CRUD ( Create, Update, Delete ) capabilities of Odata services(XSJS) to dynamically refresh teh data at UI5 interface(XSJS)
  • Used standard OData(XSJS) URL parameters like $top, $skip, $filter.
  • Developments of SAP UI5(XSJS) custom controls.
  • Used OData Services(XSJS) for SAP FIORI / SAPUI5 projects.
  • Experience in SAP FIORI Implementation and Extensibility(Customization, Config, and Routing)
  • Design and develop OData Services(XSJS) for SAP FIORI project.
  • Developed User interface using standard SAP UI5(XSJS) Controls library to meet specific requirement of teh client and integration with backend system using OData services
  • Data stored in Information models was analyzed using Custom HTML5 UI (XSJS)written in JQuery and Bootstrap
  • Developed a responsive HTML5 application using teh SAPUI5(XSJS), JQuery, and JavaScript
  • Created a responsive cascading stylesheet that handled a majority of teh various layouts, with JavaScript support for handling orientation and resizing
  • Used teh MVC pattern to speed up development time
  • Integrated teh UI with teh SAP systems(XSJS) via AJAX connecting to RESTful webservices
  • Used data quality management application (DQM) to Ensure Data Quality before Loading into Data Warehouse
  • Used DQM for address validation of Customer detail Information
  • Strong Experience with BO EIM products (Data Services/Data Integrator, Metadata Manager, Information Steward)
  • Strong familiarity with Central Management Console & Lifecycle Management

Environment: SAP HANA SP10 (GL, Time & Expense, Project Financials, FI-AP,FI-AR), SAP SLT and BODS, SAP Analysis for Office 2.x, SAP Crystal Reports 2013, SAP Business Objects BI Platform 4.1, Tableau Server 9.

Confidential, INDIANAPOLIS, IN

SAP HANA Architect


  • Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
  • Configured Security Setup for Hana and Created Users, Groups and roles
  • Helped with teh following solutions
  • ETL scenarios with SAP HANA (Data services/SLT/Sybase replication /Sybase ESP)
  • R Integration with SAP HANA
  • BI/Analytics on SAP HANA
  • Predictive Analytics on SAP HANA
  • Working Knowledge of SAP HANA XS Applications Including server-side JavaScript, ODATA,XMLA/MDX
  • Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
  • Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
  • Established teh best modeling and recommended strategies for BOBJ environment and architecture for SAP HANA

Environment: BODS 4.0, BOBJ4.0, HANA 1.0 SP2, SAP BW 7.3, SAP ECC 6.0, Linux, MS office, Visio, MS Outlook, SAP LUMIRA, R language, SAP HANA 1.X, Business Objects Data Services 4.0, Oracle, OData, Jscript

Confidential, NJ/IN

Data Services/HANA Architect


  • Involved in full migration of BI to HANA including planning, scope, pre-analysis, testing, go-live and support.
  • Decide on extract strategy (SLC, LC and/or DS) for new development in teh HANA landscape
  • Expert in data Visualizations and Knowledgeable in developing Applications using HANA XS, and Web API’s
  • Installing and Configuring SAP HANA systems
  • Conducted on-site investigation on customer requirements
  • Analyzed and translated teh client's business requirements into information data modeling
  • Worked extensively Data Modeling design including building attribute views, analytical views and calculation views
  • Delivered HANA Stand-alone solution (data replication into HANA with SLT and BO DS, HANA views creation, BO4.x reports development)
  • Performed data modeling and developed Analytical views for teh transactional data, Attribute views for teh master data, and teh calculation views as final model in HANA Studio.
  • Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
  • Gathered and analyzed teh requirement to replicate teh ECC content in HANA using data provisioning.
  • Developing and leading workshops with various business leaders
  • Architecting a HANA solution for teh OLAP analysis through leveraging data from source systems
  • Managed enhancements of Data Services Jobs, HANA Models and applying Patches on HANA
  • Performed data modeling and developed Analytical views for teh transactional data, Attribute views for teh master data, and teh calculation views as final model in HANA Studio.
  • Reviewed existing BW standard documentation to add some recommendations. Architecting a solution for supporting a requirement for BW/BI.
  • Designed simple to complex data flows as per teh requirement using most of teh BI objects (Info objects) and info providers (Multi provider, Info cube, DSO etc.). Used ABAP for transforming some of teh HR data to support report level calculations.
  • Created generic data source for custom requirement and enhanced data sources as required.

Environment: Business Objects XI R2/R3, UNIX, Web Sphere, Windows, DB2,SQL Data Insight, Viewer, Autosys, Business Objects XI 3.1, Data Integrator/Data Services, SAP IDOCS, Informix, SAP Hana V7, SLT, OData, Java Script, SAP Lumira, Information Steward

Confidential, Reston, VA

Sr.BI Consultant


  • Experience in cleansing data in DI using proper data types and mappings
  • Ability to create Work-flows using object library and tool palette to execute data flows.
  • Experience in creating and administering teh metadata Data Integrator repository in a multi user environment.
  • Performed profiling of financial Records.
  • Experience in data warehousing techniques for Data Profiling, Change Data Capture, Data Cleansing, Slowly Changing Dimension, surrogate key assignment

Environment: Business Objects XI R2/R3, Unix, WebSphere, Windows, DB2, Viewer, Autosys, Business Objects XI 3.1, Data Integrator/Data Services


Sr.BI Consultant


  • Responsible for developing all DI mappings to load data from multiple SQL Server data sources for load into a custom reporting data mart.
  • Designed job/workflow/dataflow structure for optimized batch load performance.
  • Developed complex mappings utilizing built in Data Integrator functions, including reverse pivots, table comparisons, map operations, and SQL transforms.
  • Provided user guide documentation and customer training
  • Worked on performance tuning of SQL, PL/SQL and analyzed Tables
  • Actively participating in project specification reviews, writing and maintaining technical documentation.
  • Performance tuning of ETL Load processes.
  • Participated in various data cleansing and data quality exercises
  • Design and Recommend changes to Data warehouse schema’s like Star and Snow Flake designs at BCBS Health

Environment: Business Objects, Teradata, Informix, and Oracle 8i, MS SQL, HP UNIX, Crystal Reports, Data Integrator

Confidential, Herndon, VA

Sr.BI Consultant


  • Managing and mentoring a team of new developers
  • Single Handedly worked on SCBSL Amortization engine, which generates teh Factors for different types of amortization
  • Worked directly with customer to clarify requirements and to coordinate teh deployment of phased releases of teh software.
  • Involved in modeling teh business processes and business requirements resulting in process improvement.
  • Maintaining of teh BO servers on both UNIX and Windows environments.
  • Training teh end user community for creating adhoc reports

Environment: s: BusinessObjectsXIR2/R3, DB2, MSSQL, HP, UNIX, Abinitio, Oracle, PL/SQL, Data Integrator

Confidential, Harrison, NY

Sr.BI Consultant


  • Studied teh Business Requirements Document (BRD) to understand teh requirements posed by teh business for creating teh Hub.

Environment: Ab Initio Co>Os 2.13.1, GDE 1.13.14, Oracle 8i, Perl, IBM AIX 5.1.1, PL/SQL, IBM DB2 UDB 8.0, Business Objects, Data Profiler 3.5.2.

Confidential, KS

BI Developer


  • Created Universes/Ad hoc Reports
  • Created Aliases and Contexts for resolving Loops, Chasm Traps & Fan Traps and checked teh cardinality and Integrity of teh Universe

Environment: Ab Initio 2.11, Teradata V2R4, UNIX, Windows NT, SQL, PL/SQL, K-Shell, Oracle 8i, SQL Loader, Business Objects.

We'd love your feedback!