We provide IT Staff Augmentation Services!

Sap Hana Application Consultant Resume

SUMMARY:

  • 9+ years of experience in Business Intelligence, Business Object, WEBI. Crystal Reports
  • 12+ years of experience in SAP (BO, BW).
  • 6+ years of experience in SAP HANA, BODS.
  • 12+ years of experience in ETL.
  • Proficient Experience with AWS (Amazon Web services).
  • Proficient Experience in Big Data and Hadoop.
  • Well Vast with new SAP BW4 HANA and S4 HANA
  • Excellent communication and interpersonal skills.
  • Certified SAP HANA Application Consultant / Business Intelligence (BI) Consultant with over 14 years of IT experience which include 12 years’ experience in SAP discipline, which involves the responsibility in partnering with the business to gather and document key BI requirements, Mapping tables, business rules and business logic for the design face, implementing end to end solutions using tools like BODS for ETL, SLT replication from backend enterprise systems R/3, ECC, Legacy Systems; Modeling in SAP HANA Studio, SAP BW, SAP BW4HANA, Red shift in Amazon Web Services (AWS); and delivery of BI solutions on front end using dashboards, scorecards, standard reports, ad hoc self - service reports, discovery and analysis, predictive analytics and comprehensive visualization.
  • Installation and Implementation of SAP HANA, Used Download manager from SAP Service Marketplace to get HANA Client, HANA Studio and SAPCAR, used SAPCAR from command prompt to extract the HANA client and
  • HANA Studio as they had (.SAPCAR) as file extensions, Install SAP HANA client first to get the ODBC and JDBC client drivers and install SAP HANA Studio. Implement SAP Cloud platform and on-premise platform.
  • Configured SuSE Linux server for directories for backup, create users and perform HDBADMIN roles, scripts to clear logs files Maintain ROOT and SYSTEM Passwords. Performed admin role on created roles, assigned roles, Privileges to users, licenses management, monitoring and maintaining the server. Logged in to Replication server Via SAP, used Transaction code (LTR) to access the Configuration and Monitoring Dashboard for HANA and created new schema and grant SELECT to SYS REPO, defined RFC connection for SAP system and Scheduled jobs. Created Schema using SQL Script on HANA Studio.
  • Data Acquisition; Configure Data Provisioning tools for SAP HANA, Direct Extract connect (DXC) for SAP BW where BW Embedded on ERP(Default), Side -car connection and BW on HANA; configure and implement SAP Landscape Replication (SLT) on replication server to replicate Real-time and non-real-time Data from SAP and non-SAP data sources. Monitor replication job through SLT server IUUC Synchronization Cockpit (transaction code: IUUC SYC MON) and (transaction code MWBMON) administration of transfers to also monitor changing SLT jobs. Configure and implement Adaptor for Smart Data Access (SDA) and connected to multiple source system to expose tables structured/unstructured virtually; Smart Data Integration (SDI) to BW4 HANA using provisioning server and connect to external Data Sources; use Confidential for ETL loads to HANA,
  • Imported BW model info cube to HANA, performed analysis on the analytic view before creating a report in Business Objects explorer. Imported data using BO Data Services to HANA from SAP ECC, Microsoft SQL Server, Flat files and excel spreadsheets, Oracle and DB2, Developed Complex information models from HANA Studio and created Delivery units, Packages under Content folder, created Attribute view, some with Hierarchies, Created Analytic View and identified private attributes and measures, calculated measures, restricted measures and variables.
  • Created Calculation Views (graphical and Script) to form an union of two tables, Analytic Privilege to restrict certain data on the model (row level security), saved and deployed models. Created Role and assigned the role to users with required privileges needed for the roles (Grant Role, Package privileges, SQL privileges, system Privileges and Analytic privileges).
  • Design, implement and deploy SAP HANA solutions in SAP Cloud Platform.
  • Used Information Design Tool (IDT) to create universe on top the information models ( analytic view) and also universes on top of individual tables within the schema on HANA Studio, developed Webi and dashed boards using Design Studio and Dashboard (Xcelsius) reports on Business Objects, Lumira and Explorer directly conned to Hana, used the HANA MDX tool in Microsoft excel to analyze data with or without Hierarchies.
  • Set up data backup on external server, run test on recovery of data. S4HANA modeling experience, Migration (data migration, DB Migration) and integration.

BUSINESS INTELLIGENCE KNOW-HOW:

  • Data Provisioning, SLT, ETL processes and Data Modeling.
  • Reporting, Query and Analysis and Dashboard development.
  • Data Warehouse Design and Configuration.
  • SAP HANA Administration.
  • BW Data Mining, Analysis Process Designer (APD).
  • BW Administrator Workbench Configuration.
  • BW, SAP and non-SAP Systems Integration.
  • Troubleshooting and conducting training sessions for the users.

SKILLS:

  • Strong organizer with demonstrated ability to master new concepts quickly, incorporates the latest technology and develops business solutions that increase efficiency, productivity and profitability.
  • Capability to prioritize, integrate and coordinate project activities and tasks.
  • Ability to work effectively in a diversified team, guiding and supporting project team members
  • Excellent communication, presentation, interpersonal and analytical skills.
  • Strong analytical problem-solving abilities and decision-making skills.
  • Highly organized and dedicated team player with a positive attitude.
  • Able to handle/lead multiple assignments under high pressure and consistently meet deadlines.

TECHNICAL SKILLS AND MODULES:

Business Warehouse: SAP BW 7.5,7.4, 7.3, 7.0, 3.5

ERP: ECC 6.0, SAP R/3 4.6, 3.5

Reporting Tools: Business Objects 4.x, 3.x

Data Visualization: Xcelsius dashboards, Tableau 10.x

Data Provisioning: SAP BO Data Services 4.x, 3.2, SAP Landscape Transformation (SLT) for Hana, BW Extraction, Direct Extractor Connection (DXC), Attunity Gold Client

RDB: Microsoft SQL Server 2010/2008/2005 , Oracle 11g/10g/9i, SAP HANA

Languages: ABAP/4, T-SQL, P-SQL, SQL

Modules: FICO, PS, PBF, CO, SD, PP, MM

Utility Tools: Microsoft Outlook, Lotus Notes, MS Projects, etc.

PROFESSIONAL EXPERIENCE:

Confidential

SAP HANA Application Consultant

Responsibilities:

  • Implementation and Integration of SAP and Non-SAP applications with SAP BO on various end to end projects in various capacities which include: implementing the SAP Business Objects Enterprise 4.x/XI 3x (and associated components) in the non-production environment and production environment, documenting key deliverables such as the installation and configuration build document, defining key aspects of the implementation, items such as high availability, capacity planning, Reports developing using Xcelsius.
  • BICS and connecting Xcelsius directly to BEx queries, Webi, Live-Office, Query As A Web Service (QAAWS), Crystal reports on top of ECC tables, info set, BW query, info cube, MDX query, universe, Voyager. Experience designing and developing OLAP universes on top BW BEx queries, info cubes, Multi-provider, Info sets, DSO, MDX expressions to customize universe, Relational universes created a schema joining table cardinalities, Data Federator and combining data from multiple sources SAP and Non-SAP. Implemented strategies on Performance tuning at universe level, report level, database level and server level, Managed CMC, LCM to move from DEV, QA to Production.
  • Experienced in working with BO 4.x suite tools, installation, configuration, implementation on top of SAP HANA and deployment of various reports using all reporting tools in BO4.x as per requirement need. Webi and Dashboards (Xcelsius)against universe that sitting on top of SAP HANA views, Lumira against HANA Views, Lumira against HANA optimized Universe connected to HANA Views, Dashboard Design studio against HANA Universe, Explorer, Crystal reports and Analysis for OLAP against HANA.
  • Gather, analyze, and identify opportunities for enhancements; work closely with business and technology partners to seek and provide effective resolution to business issues.

Confidential

SAP HANA Application Consultant

Responsibilities:

  • Experienced in implementing and leading various end to end BW projects in various capacities including data mining, developing new SAP BI/BW solutions, changing and enhancing current solutions, supporting of existing solutions and training of super users and end users.
  • Developing reports using BEx, Web Application Designer, Crystal reports, visual composer, dashboards. Providing recommendations on BI infrastructure, BI (front-end) tools, Requirement gathering and finalizing of specs / defining business and functional requirements for high level SAP BI Data Model, creating Data Model design specifications (star schema, data flow, etc.), Activating standard business content, building info-object, DSO layer and Back-end objects.
  • Creating and maintaining data model solution, overall cube and multi-cube design, Performing performance optimization for extractor, interfaces, queries, data load and process chains, Conducting systems and integration tests, Design data extraction and loading, writing routines (start and end routines) to enhance transformations before loading to targets, Enhancement of Extractors, configuration, transformation rules and reports, Query performance tuning and reusability, Ensuring initial functional string testing is successful and performing other duties and responsibilities successfully as assigned, ensuring adherence to standards and best practices.
  • BW On HANA upgrade and migration experience, working with HANA optimized info providers (Advanced DSO's, Composite providers, Open ODS views.) used Modeled view in HANA to load back to BW (Transient, Composite and Hybrid info providers for reporting requirement.
  • SAP BW/4HANA deployment and implement strategy around ETL, MDM, Modeling, Data Transformation and Analytics Reporting.

­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­ Confidential

SAP HANA Application Consultant

Responsibilities:

  • Over six years working with SAP BODS Versions XI3.2 and 4.x (Data Services / Data Integrator, Data Quality) with extensive experience in Data warehousing ETL tools for analysis, design, development, extraction, transformation and Loading. Installation, Configuration, Implementation and Integration of BODS 3.2, 4.0 and 4.1, Rapid Marts for all SAP Modules.
  • Extracted data from Non -SAP and SAP data sources (SAP R/3 4.6, ECC 6.0, SAP BW 7.x/3.5, SAP HANA, Oracle, SQL, Microsoft SQL server, Flat Files, Teradata, etc..) transformed and loaded to various applications (SAP BW, SAP HANA, Oracle, SQL, Microsoft SQL server, flat files, XML, XSD and text files). Managed and administered from central management console and configured job servers, created and managed repositories (local, Central and profiler) across the environment.
  • Managed and scheduled batch jobs, managed users and group roles, run reports on object create to view objects and changes that have occurred on them, created and managed RFC connections. Used SAP Open Hub Destination service in SAP BW environment to read data from an Info Provider (such as an Info Cube, Data Store object and Info sets) and load an Open Hub Destination tables that Data Services reads as a source table.
  • Designed, developed and managed batch jobs that extracted data from SAP R/3 4.6, ECC 6.0 tables using ABAP flows, extracted transformed loaded data using SAP BW as source and BW as target. Worked with multiple transformations, functions for ease of transformation and data massaging, history preservation, Change Data Capture (CDC), key generation.
  • Implemented slowly changing Dimensions of Type1 and Type 2 based on full load, Data and cleanse for address validation, Used Business Objects Data Services SMTP feature to send email notifications on any error or data quality issues while job executions.

­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­ Confidential

SAP HANA Application Consultant

Responsibilities:

  • Experience in Amazon Web Services (AWS) cloud solutions where I’ve worked with setting up Users and groups in IAM, applying policies to that govern authorization on the users and S3 Buckets.
  • Set up and configured EC2 instances for a windows and Linux virtual server, Elastic Bean stalk (EBS) for storage volume and attached EC2 instance.
  • Data bases RDS for relational db. Nonrelational database Dynamo DB and Redshift for BI data warehouse.

Hire Now