We provide IT Staff Augmentation Services!

Sap Hana Bw Consultant Resume

Lake Forest, IL

SUMMARY:

  • Having 10 Years of professional experience engaging with the business stake holders to understanding business needs and provide solutions out of 9 years of SAP Business Warehouse experience encompassing a wide range of skill set, roles and industry verticals.
  • Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA and BW4/HANA Landscapes.
  • In depth Reporting Skills and knowledge in the areas of financial, COPA and inventory reporting
  • Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of HANA, SAP BW4/HANA
  • Experience working on HANA Enterprise Modelling including Calculation Views, Table functions, Procedures, SQL scripting, CE functions, Analytical Privileges and SQL privileges, CDS views
  • Excellent knowledge on: Planning ADSOs, ADSOs, aggregation layers, Composite providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
  • Expert knowledge in SAP BW/HANA hybrid/mixed approaches.
  • Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.
  • 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 suing SLT SAP Landscape Transformation to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
  • Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis Business Objects Explorer MS Excel.
  • Hands-on Knowledge in SAP BW data extraction, ODP-SAP, ODP-SLT data sources
  • Expertise in Report Generation. Worked extensively on BEx Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.
  • Bex query / BW query ( calculated key figures restricted key figures, structures, exceptions, conditions, variables)
  • Front end reporting using BExQuery Designer, BEx Web, analyzer and Web Application Designer.
  • Experienced in designing the BEx reports according to the user requirements and designing the BEx Workbooks by using the new design tools (analysis grid, navigation pane, structures, exceptions, conditions, variables, calculated key figures, restricted key figures, charts)
  • Experience in designing BW query in SAP BW/4HANA and calculated key figures restricted key figures, structures, exceptions, conditions, variables
  • Assisted in System integration performance and user acceptance testing and well acquainted with SDLC process, SAP ASAP methodology, Agile methodology and SAP guidelines and standards for enhancements and configuration
  • Working knowledge and proficiency with Business Objects Reporting tools BI launch Pad, Web Intelligence, Dashboard designer, Dashboard Design, BO Explorer, Crystal reports.
  • Build BEX queries for feeding data into SAP BO for delivering BO platform solutions including Analysis for Office, Web Intelligence reports
  • Designing Workbooks in analysis for office and inserting a cross tab with HANA data, analysing data with design panels, calculating new measures, inserting charts, converting cross tab cells to formula
  • Grouping crosstabs, linking dimensions and conditional formatting to highlight important values or unexpected results in your data in analysis for office.
  • Expert in creating stories, Input Templates andanalytical applications in SAP Analytics cloud
  • Hands-on knowledge on calculated measures, Linked analysis in SAP Analytics cloud
  • Expert in creating scripted based analytical applications in SAP analytics cloud.
  • Used Analysis for Microsoft PowerPoint to display data in a crosstab.
  • Using BI Launch Pad and the Central Management Console (CMC), scheduled Analysis workbooks to automatically run at specified times
  • Working knowledge on creating universes using IDT on SAP HANA views and reports development on the same using Web Intelligence.
  • Create Queries and Workbooks using SAP BEx Analyzer and Analysis for Office
  • Implemented 3end-to-end full-life cycles using ASAP methodology across various modules in SAP BI/BW projects.
  • Worked on Management Work Bench with creating and maintaining Data targets like Info Objects, DSO, Info cubes and Virtual Provides like Info sets, Hybrid Providers and Multi Providers.
  • Strong experience in BW 3.x and BI 7.x version and upgrade technical and functional.
  • Strong experiences in installing the Standard Business Content objects and enhance them into custom objects based on the business requirements.
  • Worked on BW support project activities data loading monitoring and troubleshooting the failures

SOFTWARE SKILLS:

Skills: SAP BW, HANA 2.0 SP6 Database, HANA Studio

O. S.: Windows 2000/NT/XP, Windows 98

Languages: ABAP/4, Baan, C, C++, VB 6.0, VC++, PL/SQL

Databases: Oracle 8i, DB2 UDB

Design Methodology: OOAD using the Rational Unified Process and UML

Scripting Language: UNIX Shell Script, VB Script

GUI: HTML, SAP R/3 GUI 6.2

Tools: Rational Rose, Oracle Portal, Baan Tools, BEx Analyser, Web Application Designer

PROFESSIONAL EXPERIENCE:

Confidential, Lake Forest, IL

SAP Hana BW Consultant

Responsibilities:

  • HANA and Business Objects Development done across all the business Areas for the BI Projects: Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
  • Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
  • Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
  • Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Mart.
  • Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool.
  • Develop SQL scripts and functions for complex reusable scenarios in HANA.
  • Consumption of HANA information Models in BW by creating Composite and Transient Providers.
  • Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI.
  • Designed Web Reports Using Be Queries BICS Connection.
  • Designed developed cross tab reports, reports with sub reports linked unlinked and charts using Crystal Reports.
  • Designing Workbooks in analysis for office and inserting a cross tab with HANA data, analysing data with design panels, calculating new measures, inserting charts, converting cross tab cells to formula
  • Grouping crosstabs, linking dimensions and conditional formatting to highlight important values or unexpected results in your data in analysis for office.
  • Worked on connecting with live data connections and import data connections to connect with SAP Analytics Cloud data sources.
  • Used Analysis for Microsoft PowerPoint to display data in a crosstab.
  • Using BI Launch Pad and the Central Management Console (CMC), scheduled Analysis workbooks to automatically run at specified times
  • Created reports using SAP BO Analysis Office 2.8 for multidimensional ad-hoc analysis of Headcount Analytics data from SAP BW and HANA in Excel.
  • Created Planning workbooks in Analysis for office to valuate cost and revenue
  • Used BEx analyzer to develop Sales Analysis reports using filters, navigational attributes, calculated and restricted key figures.
  • Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web reporting tools.
  • Extensive work in reporting using BEx query Designer, Analyzer, Web Application Designer (WAD)
  • Created Dashboard story in SAC using Canvas, Responsive pages and Digital boardroom.
  • Successfully display story in Mobile SAC app using Responsive pages.
  • Worked with LCM Life Cycle Management Console to Transport the Objects In System Landscape Dev, QA and Prod
  • Involved in developing and conducting extensive Unit testing, Integration testing FIT, Regression testing, User Acceptance Testing UAT and documentation.

Environment: SAP HANA, Business Objects, AO, SAP BW 7.5, SAC 2018.14.2.

Confidential, Virginia Beach, VA

SAP HANA BW Consultant

Responsibilities:

  • End-End experience in implementation of Data warehouse using SAP BW on HANA.
  • Creating & migrating the packages and delivery units through the landscape using HALM
  • Created Advanced Replication Configurations on SLT server to cleanse & replicate ECC data into HANA.
  • Created Multiple complex SQL procedures & statements to extract, transform & load data into target HANA systems
  • Expert at creating Hana 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.
  • Responsible for technical design of Enterprise Data warehouse solution using HANA
  • Design SAP HANA data model information Views for report consumption with time dimensions.
  • Develop SQL scripts and functions for complex reusable scenarios in HANA.
  • Created HANA database users, role, analytical privileges for data and data model security
  • Implemented complex data models leveraging HANA capabilities using Composite Providers and Semantically Partitioned Objects.
  • Implemented HANA procedures and views for complex data model requirement.
  • Implemented system maintenance scripts for monitoring HANA memory and send trigger to Technical team.
  • Extensive SQL scripting in Oracle for data analysis.
  • Developed high performance analytical reports using Analysis for OLAP.
  • Data Migration of massive volume of smart meter data using SAP Data Services.
  • Implemented dynamic Network Hierarchy solution based on business requirements.
  • Implemented Basic Meter disaggregation process in BW leveraging capabilities of HANA.
  • Used Business Objects for reporting.

Environment: SAP HANA, SAP BW 7.3

Confidential, Grain Valley, MO

SAP BW BOBJ Consultant

Responsibilities:

  • Estimated for object developments and resource planning
  • Created extractions using standard extractors for various Plant maintenance and Logistics data sources and moved data to info cubes and DSOs in BI system.
  • Extensively used Restricted and Calculated Key Figures, Replacement path Variables, Customer Exit Variables, calculations, variables, prompts, sorted inputs, drill down, slice and dice, alerts for creating business objects reports
  • Extensively worked in Business objects reporting, in the context of developing the Universe using the Universe Designer and the Analytics using Xcelsius, WebI and Crystal Reports.
  • Worked on redeveloping Visual Composer reports to Design studio with a different User Interface using different customized cascaded style sheets.
  • Installing, configuring and administering the Business Objects 4.x environments and configuring Development, Test and Production cluster virtual environments.
  • Migrated legacy BOBJ 3.x environments to 4.X
  • Develop SQL scripts and functions for complex reusable scenarios in HANA.
  • Created complex dashboards which use live office to feed the data into Xcelsius from the source webi reports.
  • Responsible for handling requirements and distribute the work
  • Estimation of new objects for country rollouts
  • Responsible to manage offshore team
  • Ensure quality and timely deliverables

Environment: SAP HANA, SAP BW

Confidential, St Louis, MO

SAP BW BOBJ Consultant

Responsibilities:

  • Involved in Full Life Cycle implementation, which includes GAP Analysis, Requirement gathering, Blue Printing, Development, Testing, Reporting, Go Live & Support.
  • Designed functional and technical specifications for implementation and development of BI 4.0 over SAP BI 7.0 and implemented BO 4.0.
  • Designed and developed Universes using Information Design Tool (IDT) on Relational Tables.
  • Created Pre-Canned and Ad-hoc reports using Business Objects Web Intelligence (Web I) Rich Client by utilizing BICS Connection and Universes.
  • Designed, developed and managed Universes in Business Objects Designer for generating reports against SAP BW.
  • Created Info providers &Bex queries to simulate/validate results achieved from Design Studio reports
  • Worked on creating Universe using IDT for one of the dashboard designed on Design Studio
  • Created many WEBI reports over OLAP universes.
  • Designed Complex Web I report including Combined Queries and Drill Down reports.
  • Worked on Creating WEB I reports using Prompts, filters, Variables and various Manual cell Calculations.
  • Extensively Worked on Linking Web I reports with Crystal Reports using Open Doc Functions.
  • Extensive experience in working on IDT (Information Design Tool).
  • Created BICS Connection using IDT in SAP BI 4.0.
  • Created Dynamic Xcelsius Dashboards using QAAWS, Live Office and BI services.
  • Analyze the impact of the upgrade of SAP ECC System from BW perspective.
  • Analyze the impact of the upgrade of SAP BI 7.0 System.
  • Make changes to existing Data Sources, Transformations, Info Objects

Environment: SAP BW 7.3, SAP Business Objects

Confidential

SAP BW Consultant

Responsibilities:

  • Worked with end users and SAP team members to create and develop specifications
  • Worked extensively on bringing master data and transactional data from flat files and SAP R/3.
  • Experienced in activation of Business Content
  • Experience in Extraction (Generic Extractions, Flat file, LO Cockpit, LIS and Business content)
  • Expertise in Report Generation - Worked extensively in BEX Analyzer in building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries usingConditions, Exceptions, Variables & Structures and created aggregates for frequently used queries.
  • Experienced in Scheduling Start process, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes and Multicubes.
  • Created Basic Info Cube and created dimensions for the Cube and assigned the characteristics to these dimensions.
  • Monthly & Weekly extractions are scheduled using InfoPackages on Sunday nights & End of month by using after jobs & after events.
  • Created updated rules by writing routines and other user exits in ABAP.

Environment: - SAP BW 7.0

Hire Now