We provide IT Staff Augmentation Services!

Sap Bw Hana Consultant Resume

IL

SUMMARY:

  • Over 7+ years of experience in SAP BW, SAP HANA and SAP BW powered by HANA, 2 years of experience in SAP Testing.
  • Expertise in creating of SQL Scalar functions, SQL Table functions and SQL Stored procedures. Created advanced modelling views using Hierarchies, Calculated and restricted columns, variables, input parameters, currency conversions and UOM conversions. Having Strong understanding of Joins (Inner, Outer, Referential, Temporal and Text), aggregations and unions.
  • Hands on experience in SAP HANA Data provisioning using SAP BO Data Services 4.0. and have knowledge on SLT Replication server. Gained experience with Data Extraction Transfer Loading ETL for loading data from SAP ECC System to SAP HANA System. Well versed with importing table definitions, performing initial load and replication, resuming and suspending data loads using SAP HANA studio.
  • Extensively worked on creating BW modelling objects like InfoObjects, Info object Catalogs, Infocubes, DSO objects, MultiProviders, Advanced DSO’s, Composite Providers, Application Component, InfoSources, Data Sources, Update Rules, Transfer Rules, Communication Structure, Transfer Structure, Info Packages, Info Package Groups, Process Chains, PSA, Transformations, Data Transfer Process (DTP) etc.,
  • Extensively worked on Extraction of data from ECC, Flat Files. LO Cockpit Extraction, Generic Extraction, Flat file Extraction for Master data and Transactional data, and Activating Data structure, transporting data sources, customizing and Enhancement of Extract.
  • Having precise expertise in Report Generation with Business Explorer using BEx Analyzer, BEx Query Designer. Building Queries using Filters, Free Characteristics, Calculated Key figures, and Restricted Key figures, Filters, Variables, Structures, Conditions and Exceptions.
  • Created process chains to load the data into the targets and monitoring the same for daily, weekly and monthly schedules and maintained the activities like scheduling and monitoring of process chains, resolving errors and tickets.
  • Expertise in transport management process.
  • Written ABAP code for customer exit variables, start routines, end routines, expert routines and field routines also Written, customer & variable exits in ABAP.
  • Having Experience on BODS job modeling. Involved in creating the Dataflows, work flows and Job. Worked optimization tasks of BODS jobs as part optimization performance improvement.
  • An excellent team player as well as an individual contributor with good communication and interpersonal skills.
  • Quick learner and stronger desire to master in new Technologies.
  • Involved in Implementing SD, MM (Inventory Management), support & Maintenance Projects, Enhancement Projects.
  • Worked on BW powered by HANA objects Advanced DSO, Virtual Provider, Transient Provider, and composite provider.
  • Involved in areas of BI in Data Modeling and Extraction.
  • Worked for BW4 HANA Environment.
  • Created BEX reports using Eclipse based query designer and changed existing reports as per BW4HANA functionality
  • Experienced in BI components like Info Cubes, DSO Objects, Transformations, DTPs, Info Objects, Info packages, Info Objects Catalogs, Characteristics and Key figures, Data sources, Business Content and Process Chains.
  • Performance tuning by maintaining Aggregates, Compression, Partition, indexing of info cubes and use of statistics for the same.
  • Have extensive work experience with data extraction, scheduling, monitoring, and loading data from SAP R/3.
  • Handling errors while extracting from ECC 6.0 and loading the data into Data Targets.
  • Proficient in extracting data from SAP ECC source system like LO - Cockpit SD, Generic Data sources and Flat Files.
  • Worked on performance tuning on Aggregates, Indexes and Data Compression.
  • Worked for BI Related ABAP in transformation and BeX Query Level.
  • Worked for Copa Data source .

TECHNICAL SKILLS:

ERP: ECC 6.0, S/4 HANA

Data Warehousing: SAP BI 7.5,7.3, 7.0, BW 3.x.

Data Bases: SAP HANA, Oracle

Languages: SQL Script, ABAP/4, Core Java (SCJP Trained), C language

Reporting Tools: BEx Query Designer, BEx Analyzer,SAP Lumira 1.0, Analysis for office

ETL Tool: Business Object Data Service 4.2

PROFESSIONAL EXPERIENCE:

Confidential, IL

SAP BW HANA Consultant

Responsibilities:

  • Created Attribute views, Analytical views and Calculation Views and Modeled advanced models using Hierarchies, calculated measures, restricted measures and columns, variables and input parameters to satisfy reporting requirements.
  • Created SQL Scalar functions, Table functions, Analytical Privileges and Procedures using SQL script to satisfy the complex requirements which were used in Calculation views and Created the graphical calculation views by converting from Script based calculation views.
  • Developed business models and reports, includes Divert report, purchase related views, Sales margin and price related reports, Spend Analysis report, Employee Hierarchy views, Currency Exchange rate view and Analytical privileges in S/4 HANA system.
  • Developed models, includes SCM reports like Program Summary view, DRP vendor dashboard view, PO line quantity views and few wide-open reports of different areas like finance, sales, purchase and in HANA EDW system.
  • Implemented currency conversions and unit of measure conversions in calculation views.
  • Created different views in S/4 HANA systems like pricing and Invoice related views to provide as interfaces to other teams like Vistex and BODS teams.
  • Created calculation views for YTD, MTD and QTD reports using scalar function.
  • Imported data through flat files into SAP HANA and created schema and required tables.
  • Utilized practices and performance Optimizations to improve the performance of views.
  • Created Technical specifications and standard modelling documents for HANA.
  • Extensively worked on UAT testing for all developed models and prepared technical documents to share with users.
  • Transported various HANA views to higher landscapes. Extensively worked with LCM Life Cycle Management Console to Transport the Objects in System Landscape.
  • Involved in SAP HANA Data provisioning using SAP Data services.
  • Migrated HANA content from development to testing and to production environment using Delivery Units.
  • Worked on performance improvement of Data flow in BODS by created some logic in HANA.

Environment: SAP HANA SPS 12, SAP S/4 HANA, SAP BODS 4.2.

Confidential, PA

Senior SAP BW Consultant

Responsibilities:

  • Created, scheduled and monitored the process chains and fixed the failures within the permits of the service level agreement (SLA).
  • Involved in Implementing SD, MM (Inventory Management), support & Maintenance Projects, Enhancement Projects.
  • Worked on BW powered by HANA objects Advanced DSO, Virtual Provider, Transient Provider, and composite provider.
  • Involved in areas of BI in Data Modeling and Extraction.
  • Worked for BW4 HANA Environment.
  • Created BEX reports using Eclipse based query designer and changed existing reports as per BW4HANA functionality.
  • Experienced in BI components like Info Cubes, DSO Objects, Transformations, DTPs, Info Objects, Info packages, Info Objects Catalogs, Characteristics and Key figures, Data sources, Business Content and Process Chains.
  • Resolved different type of user tickets including data issue related and enhancement related based on ticket priorities.
  • Created BW objects such as infoobjects, data store objects, infocubes, multiproviders, transformations, infopackages, data transfer processes, open hub destinations and analysis process designer and few 3.x objects such as infosource, communication structure, transfer rules, update rules, infospokes according to the technical specifications.
  • Developed and enhanced various BEx reports using BEx query designer according to business requirement.
  • Extensively worked on BEx analyzer and delivered reports to user and broadcasted BEx reports using email.
  • Extensively worked on placing files to application server using infospokes, open hubs and ABAP program and worked with UNIX commands to open, close, delete and move the files which are placed in application server across all SAP landscape.
  • Created ABAP programs with variants to place the data in file format in application servers.
  • Written ABAP code for customer exit variables, start routines, end routines, expert routines and field routines.
  • Worked on migration project of BW objects from SAP 3.x to 7.0 system.
  • Extensively worked on collecting objects into transport and transporting it from the development to quality and finally to production systems.
  • Worked on year-end activity program (developing, testing and loading yearly objects).
  • Created various documents like issue log, service level agreement report, runbook etc.
  • Developed few ABAP reports which are useful as some tools like (to get info providers list based on queries and vice-versa, to get where used list for DTP’s and Queries and helped on developing of Housekeeping report.
  • Involved in frequent client meetings to discuss project status. Coordination and communication with the onsite team.

Environment: SAP-BW 7.0, BW 3.x, SAP ECC 6.0, BEx query designer and query analyzer.

Confidential

SAP BW Consultant

Responsibilities:

  • Maintained Functional Design and Technical Design Documents.
  • Involved in complete life cycle implementation of SAP BW.
  • Analysis of data requirements, data mapping, data extraction development and translation of these requirements into dimensional data models using star-schema and extended star-schema data modeling techniques.
  • Hands on experience on Administration workbench, Maintained and Created Info Object, Data Source, Info source, Communication Structure, Transfer Structures, Transfer rules, Transfer and Update routines.
  • Experience with Data Mart Interface, Multi Providers, Info Cubes, ODS Objects, Info Objects and Info Sources.
  • Implemented Update Rules and Transfer Rules to transform data into a more meaningful representation.
  • Defined new custom extractors and enhanced standard extractors.
  • Experience in creating database Views, Generic Data sources in SAP R/3 and replicating them to BW in the process to load R/3 Data to SAP BW.
  • Worked extensively on Business Content and installed necessary BW objects for extracting data from SAP R/3 into BW.
  • Uploaded master data and transactional data from SAP R/3 to ODS and Info Cubes through PSA.
  • Create Info Packages Scheduled them in order to load Master Data and Transaction Data from SAP R/3 as well as FLAT FILE Source system into SAP BW Data Targets.
  • Creating and maintenance of Process Chains and Triggering of Event Chains.
  • Performance tuning of queries using aggregates, table partitioning, indexing of Info Cubes.
  • Defined and customized Reports by BEx queries, BEx Analyzer, and (WAD) Web Application Design using Variables, Filters, Structures, Calculated key figures, Created Workbooks.
  • Support:
  • Involved in escalating high-prioritized tickets regarding extractions, Performance Issues and also load failures.
  • Monitoring of process chains to load data.
  • Analyzing the reasons for frequent failures of Info packages.
  • Maintaining Reconciliation's to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
  • Maintain Work History for all the tickets until it is closed. Communicate with the User who Opened the Ticket.
  • Worked on OSS for solving the issues.
  • Supporting and Training BW User by Conducting End Users training according Best practices Material.

Environment: SAP BW 3.5, R/3 4.7 (MM, PS, SM, FI, CO)

Hire Now