We provide IT Staff Augmentation Services!

Sap Bw Hana Consultant Resume

SUMMARY:

  • A self - motivated, highly talented and result oriented IT professional with around 9.5 years of experience as a SAP BW,SAP Certified HANA & ABAP Consultant with a very good experience in working with all the new feature of SAP Net Weaver BW 7.X and BW powered by SAP HANA, with all integration scenarios of BW and HANA. Migration of HANA views to
  • BW and import of BW Info providers to SAP HANA and providing the best modelling solution.
  • Around 9.5 years of experience in project development and application support using the SAP BW/BI and SAP HANA tools.
  • Has extensively worked with Accelerated SAP Methodology in Implementations.
  • Experience in working with all the new feature of SAP Net Weaver BW 7.4 and BW powered by SAP HANA, with all integration scenarios of BW and HANA. Migration of HANA views to BW and import of BW Info providers to SAP HANA and providing the best modelling solution.
  • Expert in designing and developing standard and custom Info cubes, DSO objects, info-object catalogs, Info objects, Transformation, Info package, DTP, Data source, Characteristics, Key figures, Multi-providers, Business content Installations, WODSO, Process chains, Semantic Partition Objects, Composite Providers and Data Flows.
  • Expertise of understanding the Next generation data base management system which is SAP HANA (In memory data base) and various use cases related to SAP ERP and SAP BW.
  • Expertise with SAP HANA Studio with Modelling and Administration Perspectives.
  • Expertise in creating various Information Models like Attribute, Analytic and Calculated Views and exposure to Procedures decision tables and calculated columns.
  • Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
  • Good knowledge on SAP BODS connectivity’s, extractions and loading in to HANA Database and BODS core functionalities like Jobs creation and data transfer methodologies and Repository managements.
  • Expertise with HANA Administration areas like Authentications, security management, backup and recovery, Persistency layer management.
  • Good exposure to SAP BI tools and SAP HANA integration with BI tools like Crystal reports, Dashboards, webi, information designer, Explorer and Analysis editions.
  • Hands on experience and Knowledge in Business Objects and Business Planning and Consolidation.
  • Exposure and knowledge to latest versions of SAP Hana 1.6 and various features in it.
  • Experience in automating Data loads using process chains and Meta chains for BW.
  • Worked extensively on Business Explorer Suite tools. BEx Query Designer, BEx Web Application Designer, BEx Analyzer & BEx Web Analyzer
  • Excellent skill set in building queries using Reusable structures, filters, Restricted Key Figures, Calculated Key Figures, formulas, conditions, and exceptions.
  • Proficient in extracting the data from SAP R/3 system. Expert in LO Cockpit & Generic Extraction
  • Involved in managing of Info cube, which involves Info cube contents, performance issues like Indexes, partition, Aggregates, Line item Dimension, compression of Info cube and rolling up the data to the aggregates.
  • Expertise in ABAP development related to transformations and enhancements.
  • Good understanding and experience with Business Objects, report creation and development using tools like Crystal reports, webi and Universe designer.
  • Functional expertise in SD, MM and FI/CO. In-depth knowledge of reporting flow from R/3 to SAP BW.
  • ABAP - Reporting, User Exits, Customer modifications. Specifications for Documented functional and technical production support and project enhancements.
  • Worked with the project team and multiple end-users to resolve accounting issues and identify opportunities for business process improvements. Provided production support in BW reporting.
  • Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation. Documented functional and technical specifications for production support and project enhancements. Participated in change management activities.
  • Assisted in ongoing communication to SAP and BW end-users on business process and systems changes, and issues resolutions.

TECHNICAL SKILLS:

SAP In: Memory (HANA): Data Provisioning (Flat Files, SLT for SAP & Non-SAP ), Information Models(Attribute view, Analytic View, Calculation View )

SAP BI: BI Platform 4.0/BOBJ (IDT, WEBI, Crystal Reports, Xcelsius, SAP Integration Kit, Advance analysis), BEx (BEx Query Designer, Web Application Designer, BEx Analyzer, BEx Web Analyzer)

Programming Language: ABAP (IDOC s, LSMW, RFC, BAPI s, BADI s, Reports, Module Pool), SQL

SAP EDW: SAP NW BI 7.x, SAP BW 3.x.

ERP: SAP R/3 4.6, 4.7 & ECC 6.0.

Database: SQL server, DB2, Oracle, HANA

Operating System: Win XP/2000/NT/ME/9x,MS DOS.,UNIX, Linux, IBM-AIX

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW HANA Consultant

Environment: ECC 6.0,SAP HANA SPS 9,SAP BI 7.4, Business Objects (Crystal reports and Webi)

Responsibilities:

  • Created attribute, analytic and calculation views for Sales and Procurement modules as part of the current POC.
  • Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.
  • Replication of the selected tables of SD from ECC to SAP HANA. Performed transformations during the replication process.
  • Created HANA modelling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
  • Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.
  • Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.
  • Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Migrating standard Infocubes to In memory optimized Infocubes using migration Tool.
  • Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool.
  • Importing the BW Models in to HANA using HANA Studio.
  • Consuming the HANA Models in BW by creating the Transient Providers.

Confidential

SAP BW HANA Consultant

Environment: ECC 6.0,SAP HANA SPS 6,SAP BI 7.3, Business Objects (Crystal reports and Webi)

Responsibilities:

  • Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
  • Replicated data using SLT and BODS and created models as per requirement.
  • Involved in moving Information models to BW as transient provider and created Reports.
  • Created SPOs and In-memory Cubes and DSOs. Utilized most of the new features of BW 7.3.
  • Migrated In memory Cubes and DSOs to Hana studio and modified as per requirement to create Calculated and Analytic views.
  • Created Decision tables and performed various calculations using best function provided by Hana.
  • Created Query and process chain log documents.
  • Created and maintenance of Info Objects, DSO, Cubes, Transformations, DTPs, Data Sources.
  • Created and maintained reports using Crystal reports Database expert, Grouping expert and Cross tab expert
  • Created process flow module documents and Scheduled SPM loads through Portal
  • Involved in Unit Testing and Business Acceptance Testing using HP Quality Center
  • Interacted with Business users and collected requirements and provided solution accordingly.

Confidential, Plano,TX

S AP BI Consultant

Environment: ECC 6.0,SAP BI 7.0

Responsibilities:

  • Created and maintenance of Info Objects, DSO, WODSO, Cubes, Transformations, DTPs, Data Sources
  • Created Generic Data sources using Tables and Views for extracting Master and Text Data.
  • Uploaded master and transaction data from flat files
  • Collected, released and imported the BI Objects from Development to Acceptance to Quality boxes
  • Direct interaction with the business users
  • Created and maintained queries in BEx Query Designer and BEx Web Application Designer for analysis and web reporting respectively which are published in Enterprise Portal
  • Developed Custom Generic Data Sources through Views
  • Involved in escalating prioritized tickets regarding extractions, performance issues and load failures. Analyzed and corrected production problems as they occur in the SAP BI
  • Successfully scheduled repair full loads for master data attributes and master data texts whenever new attributes or texts enhanced.
  • Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain teamwork
  • Attending weekly meetings like Internal Review Meeting, Quality status and Client Review Meetings.
  • Interaction with users to resolve BW reporting issues
  • PSA Data Deletion on weekly and monthly basis
  • Involved in submitting the Ticket Status (Open/Close) report
  • Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
  • Installed Business Content Objects when required

Confidential, Detroit, MI

SAP BI Consultant

Environment: ECC 6.0, SAP BI 7.0

Responsibilities:

  • Installed Business Content Objects as and when required
  • Extensively involved in setting up the procedures for extracting the data from ECC by using the LO COCKPIT and GENERIC extractions
  • Created Generic Data sources using Tables and Views for extracting Master and Text Data.
  • Uploaded master and transaction data from flat files
  • Collected, released and imported the BI Objects from Development to Acceptance to Quality boxes
  • Direct interaction with the business users
  • Created and maintenance of Info Objects, DSO, WODSO, Cubes, Transformations, DTPs, Data Sources
  • Created and maintained queries in BEx Query Designer and BEx Web Application Designer for analysis and web reporting respectively which are published in Enterprise Portal
  • Developed Custom Generic Data Sources through Views
  • Involved in escalating prioritized tickets regarding extractions, performance issues and load failures. Analyzed and corrected production problems as they occur in the SAP BI
  • Successfully scheduled repair full loads for master data attributes and master data texts whenever new attributes or texts enhanced.
  • Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain teamwork
  • Attending weekly meetings like Internal Review Meeting, Quality status and Client Review Meetings.
  • Interaction with users to resolve BW reporting issues
  • PSA Data Deletion on weekly and monthly basis
  • Involved in submitting the Ticket Status (Open/Close) report
  • Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
  • Installed Business Content Objects when required

Confidential

Module Lead

Environment: ECC 6.0

Responsibilities:

  • Developed Enhancements using User exits, BADI and conversions using BDC and LSMW.
  • Created a Dialog Programming (Module pool, Screen painter, Menu painter) to display ‘Price Calculation Design’ for a WBS Element, ‘Feasibility to Launch Database’
  • Created a LSMW to migrate Quality Inspection Plan data (QP01).
  • Created a BAPI Program to migrate the Material Master Data (MM01).
  • Enhanced the standard MIGO Transaction to create Transfer Posting for material-to-material transfer (309) in MB1B using the BADI “MB DOCUMENT BADI”.
  • Enhanced the QM01 Transaction to update the Complaint Quantity which is the sum of all the defects (item level) using the BADI “NOTIF EVENT SAVE”.
  • Created a Remote Enabled Function Module to get all the Process Orders using the BAPI

Confidential

SAP ABAP Developer

Responsibilities:

  • Enhanced the standard VA01 transaction to calculate the load equivalent cube and total weight of the sales order which determines whether the delivery block should be applied for the sales order once the tolerance limit is exceeded
  • Developed a program to filter incoming customer payments and remittance advices through pre-processing rules in order to align customer specific business requirements into a format that SAP can process efficiently and accurately through the lockbox processor.
  • Enhanced the standard VA01 transaction Additional Data B screen with a number of fields on the order that will not be displayed in standard out of the box screen fields.
  • Enhanced the standard VA01 transaction to read the order lines looking for values in the Event Number and Priority Indicator fields. If found, then a header level priority flag will be set to ‘Y’. The Priority will be updated on the additional data B tab for the order, and should not be changed by this process, if that occurs.
  • Enhanced the standard VA01 transaction to grab the user id from a Z-table and add that ID as the responsible CSR within the partner tab on the order when the order is saved. This will be used for assigning work and for coverage when a CSR is unavailable. Once defaulted from the z-table, the CSR can view and manually update the responsible CSR ID on the partner tab of the order.
  • Created a report to implement a delivery block edit to determine whether an individual sales order that is created or changed meets specific minimum requirements stored in ZOONA ORDER MIN Table
  • Created a report to download Trade receivables to the specified path in the application server
  • Created a report to download Revenue factor to the specified path in the application server
  • Performed Performance Analysis for the ABAP reports that include SQL Trace and Runtime analysis.

Confidential

SAP ABAP Developer

Responsibilities:

  • Development of Data Take Over Programs
  • Unicode Conversion of ABAP programs
  • LSMW for Data transfer for different scenarios like
  • Customer Master Data Transfer
  • SAP Script texts
  • Creation of Work Centers
  • Creation of Maintenance Plan
  • CoA profile
  • Purchasing Contracts Source Lists
  • Created ABAP program to display - Sample Inventory, Unclaimed Property Report, Stock Maintenance Report, Sales returns report, Purchasing Delivery Statistics

Confidential

SAP ABAP Developer

Responsibilities:

  • Worked in the development of ALV grids, Smartforms, BAPIs, classical reports, BDC programs and creation of custom transactions
  • Developed CVS credit Report for credits using ALV grids
  • Developed PO form for Great Britain
  • Developed an editable ALV for Target and bridge quantities report
  • Developed Goods receipt label using SAP Scripts
  • Documentation of various development activities across different modules in Solution Manager

Hire Now