We provide IT Staff Augmentation Services!

Sap Bw Hana Consultant Resume

SacramentO

PROFESSIONAL SUMMARY:

  • Result oriented SAP Consultant having around 8+ years of experience in SAP HANA/ BW/BO mainly focused in design, development, and implementation, reporting of SAP applications for different modules like IS - U, FI-CO, HR, SD, MM, PP, PS and PM, and having good experience in SAP BO reporting tools, third party tools and currently working on SAP BW 7.5 on HANA platform.
  • Involved in three full life cycle implementations projects for different modules in SAP HANA like IS-U, PM, MM, which involves all phases like Blue Printing, Requirement Gathering, Architecting, Technical Design documentation, Realization, Data Provisioning, Hana Modeling, Testing, Documentation, Reporting, Dash boarding, Go-live Support
  • Involved in three full life cycle implementations for different modules in SAP BW like PM, SD, MM, FI-CO, HR, PS and PP which involves all phases like Blue Printing, Requirement analysis, Gap analysis, Realization, Data extraction, Data Modeling, Data loading, Production Support, Testing, Documentation, End user training, Reporting and Go-Live Check
  • Experience in two successful BW on Hana Migration, latest was SAP BW 7.5 SP4 on HANA
  • Extensively worked on LSA++ architecture and hybrid modeling with SAP BW 7.5 such as Advanced DSO’s, composite providers
  • Extensive experience in data extraction from SAP ECC (IS-U, FI/CO, HR, MM, SD, PM and PS), flat files, non-sap sources and BW using extractors such as LO Cockpit, CO-PA, FI and Generic Extractors
  • Expertise in front-end BW components (BEx Analyzer, Query Designer, Web Application Designer, WEBI, Xcelsius and Dash Boards) for Queries, workbooks, calculated key figures, restricted key figures, filters, conditions, exceptions and have good knowledge on variables and its processing types
  • Experience in BOBJ 4.x version with BI Launch Pad, SAP Business Objects Dashboard design, WEBI, Crystal Reports and Analysis for Excel
  • Extensively worked on Business Information Warehouse Multiproviders, Info cubes, DSO’s, and Info-objects, APD’s and open hub destinations
  • Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques
  • Good experience in Hana optimization of custom extractors and Hana optimization of BW transformation routines
  • Actively contributed in cutover activities for PM, SD, MM, PS and FICO modules
  • Actively worked as a part of team doing system migration and upgrade activities
  • Good skills in dealing with production support issues, which involved debugging of data loads, process chains and monitoring and scheduling data loads
  • Good knowledge in creating database semantic layers (Universes) and developing Decision Support Reports using Business Objects
  • Strong planner and organizer with demonstrated ability to develop business solutions that increase productivity, efficiency and profitability
  • Excellent team player with good analytical and problem solving skills, Good Technical writing skills.
  • Good communication skills, strong decision making skills, organizational skills, and customer service oriented

CORE COMPETENCIES:

  • SAP BO 4.2 Enterprise Reporting
  • Business Intelligence / Enterprise Reporting
  • SAP BO Central Management Console
  • BPC Integration with BI
  • SAP HANA Studio
  • SAP BW on HANA
  • Data warehousing workbench-modeling techniques
  • Data extraction in SAP BI
  • SAP BEx Suite
  • Business Content
  • Information Design Tool
  • SAP ECC on HANA

TECHNICAL SKILLS:

SAP: R/3 4.5, 4.6C, 4.7, ECC 6.0, ECC 6.0 EHP 7, HANA

Net Weaver: SAP BI 7.5/7.4/7.3, BW 3.5

Other Tools: MS Office Suite, BMC Remedy, HPQC, Control-M

Programming Languages: ABAP and S QL

Data bases: Oracle10g/11i, DB2, SQLServer, MS Access and HANA

BI Tools: BEx Tools, BEx Query designer, BEx AnalyzerWeb Intelligence, Xcelsius 2008, Crystal reports enterprise, Tableau, SAS, Denodo, Design Studio, Hana Studio, Lumira

EMPLOYMENT HISTORY:

Confidential, Sacramento

SAP BW HANA Consultant

Environment: SAP BI 7.5 on HANA, BO 4.2 on Hana, Hana Studio

Responsibilities:

  • Requirement gathering sessions with business users from various departments like Billing, Market Research, Load Research, Customer Research
  • Blueprinting and preparation of functional specification documents
  • Preparation of technical specification document, estimates and schedule
  • Worked with sap basis team to set up the new Hana studio modeling tools, the new transport management system, CTS+ and a new UDC connection
  • Worked with sap security to set up the initial security on the hana side along with defining packages
  • Development of the BW models using the new info providers such advanced dso’s and composite providers on the new BW Modeling tools perspective in HANA Studio
  • Various of types of advanced dso’s were developed according to the need like corporate memory, standard etc along with partitions and secondary indexes on them
  • Composite providers were developed using various combinations of hana views, advanced dso’s and other info-providers, these where then used in an APD
  • On the Hana Modeling side, various types of views such as attribute view, analytic view and calculation views were developed
  • Calculations views of type graphical and SQL were developed according to the requirements which used projections, aggregations, unions and ranks, time conversions
  • Carried out unit and integration testing of BW and HANA models, worked alongside business user helping them with UAT
  • Go-live and hyper care support
  • Knowledge transfer to the support team

Confidential, Sacramento

SAP BW HANA Consultant

Environment: SAP BI 7.5 on HANA, BO 4.2 on Hana, Hana Studio

Responsibilities:

  • Currently working on SAP BW 7.5 on HANA platform
  • Preparing system for migration and running HANA checklist
  • Fixing all abap related issues which cannot be migrated to HANA
  • Writing abap for transformations to be optimized and compatible to run on HANA
  • Review and knowledge transfer
  • Fixing issues related to all other info-providers
  • Housekeeping activities to reduce the size as much as possible
  • Capturing queries and process chain benchmarks for performance measurement
  • Post migration system check up of each system
  • Post migration issue fixes
  • Support the cutover activity for production migration
  • Hyper care support for production after go live
  • Sap Hana and BW Modeling on Sap hana studio

Confidential, Fort Worth

Senior SAP BI BO HANA Consultant

Environment: SAP BI 7.4 on HANA, ECC on HANA, BO 4.1, PM, MM, Hana Studio, Tableau.

Responsibilities:

  • Worked on SAP BI 7.4 on HANA & ECC 6.0 EHP 7 on HANA platform
  • Gathered HANA view requirement from Business SME’s and functional
  • Translated the functional specification to technical specifications
  • Documentation of business KPI’s in technical terms
  • Creation of packages based on respective modules and business layer
  • Developed 80 odd HANA live views on ECC.
  • Identification and activation of SAP standard HANA live views
  • Enhanced SAP standard HANA live views as per requirement
  • Mapping of attributes and measures to the business KPI’s
  • Developed complex Graphical Calculation views, stored procedures for the same
  • Developed SQL script based views which were complex in nature and was not achievable in Graphical views
  • Developed Analytical, Attribute views and Calculation views for on Hana Studio to consume by BOBJ, Tableau and other third party tools.
  • Created calculated columns and measures in the view as per requirement for KPI’s
  • Defining the report and dashboard layout friendly to business user keeping their inputs in mind
  • Developed dashboards on Sap BO, Tableau for respective end user communities
  • Carried out unit testing, integration testing and performance optimization of HANA views
  • Worked with business users for UAT of the views
  • Worked with top level business users for UAT of the dashboards
  • Leveraged already existing BW extractors and enhanced them to perform better on HANA.
  • Identification of poor performing extractors and transformations in Sap BW
  • ABAP Hana optimization of all old custom extractors. Extractors runtime were brought down from 4 hours to 20 mins in SAP ECC on HANA
  • ABAP Hana optimization of slow running transformation routines. DTP’s runtime were brought down from 2 hours to 8 secs in SAP BW on HANA
  • Developed amdp’s to push BW transformation code to database.
  • Worked with change management team to promote of Hana views from Dev to QA system
  • Developed composite providers and virtual providers
  • Worked with security team to develop hana roles for the views developed
  • Go-live after Support of the developed objects

Confidential, Fort Worth

Senior SAP BI BO HANA Consultant

Environment: SAP BI 7.4 on HANA, BO 4.1, PM, PS, SD, FI-CO, HR, Denodo, Tableau.

Responsibilities:

  • Worked on SAP BI 7.4 on HANA & ECC 6.0 EHP 7 platform. Onsite lead for a team of 5 members.
  • Involved in the blue printing and functional document preparation of the requirements of the project
  • Created technical specification documentation of the same
  • Worked closely with business users, business analysts and team members to understand the business requirements
  • Involved in installing Business Content
  • Worked on several master data sources in Plant Maintenance
  • Developed several z-extractors for master data requirements of type function module and transparent table based, etc.
  • Worked on all Plant Maintenance 2LIS 17* data sources (maintenance order, notifications, order operation)
  • Enhanced most of the standard 2LIS 17* extractors as per business requirements
  • Worked on various transaction data extractors in PM apart from 2LIS extractors with respective delta types
  • Installed respective Info-provider Info-objects, dso’s and cubes, multiproviders and infosets. Enhanced several by developing customized info-providers of the same as per business requirement
  • Written simple and complex transformation routines for the same
  • Indexing, compression, roll up and db statistics of cubes has been done where ever required
  • Developed process chains according to the dependencies for master data and transaction data
  • Done scheduling and monitoring of the process chains and addressing issues of process chain failures
  • Worked on transport movement till production system and documentation has been accomplished on SolMan CHARM
  • Unit, Integration and regression testing has been done according to business standards and documented respectively
  • Involved in creating few BEx and BOBJ reports for the project
  • Involved in developing reports on Denodo platform and Tableau for the project
  • Involved in mirror validations of data in ECC and BW on different environments
  • Involved in rectification of different failures in the data loads and rectifying data issues
  • Worked on different update modes for uploading the data from SAP ECC to BW
  • Rectified the failures occurred when delta update is going on from one data target to another data target
  • Worked with SAP Security team in defining and developing roles for Consultants and business users respectively for the PM area
  • Done transition of the data loading process to the support team after hyper care
  • Developed 70 odd HANA Views in BW in the later stage of the project.
  • Creation of packages, analytic privileges
  • Developed Hana views of type calculation views, analytic views, attribute views
  • Creation of constants, calculated columns, use of Rank function, aggregation
  • Currency conversion, unit conversion, creation of synonyms, hierarchies
  • Developed script based SQL views for complex requirement
  • Developed composite providers, hana view based extractors

Confidential

SAP BI BO Consultant

Environment: SAP BI 7.3, SAP BO 4.0, Finance and General Ledger Accounting & Confidential (HR).

Responsibilities:

  • Worked on SAP BI 7.3/ ECC 6.0 platform
  • Worked on Business requirements and Gap Analysis to identify the gaps that exist in the Standard Sap provided extractors for FI
  • Worked on Confidential of various FI standard extractors as per new reporting requirements
  • Involved in developing contractor administration BW infoproviders and reports
  • Involved in developing e-recruiting BW info providers and reports
  • Worked on different update modes for uploading the data from SAP R/3 to BW
  • Involved in data loading, Job monitoring and created process chains for automating the process
  • Worked on Inbound and Outbound interfaces. Used Open hub service to distribute data to other systems (Hyperion and BPC)
  • Involved in collecting all the developed objects and releasing the TR’s
  • Created queries using BEx, and then generated Universes and reports using WEBI
  • Creating BI reports on Business Objects tools like Webi, crystal and design studio and see to the performance issues on both of them
  • Worked on transformations and writing simple routines in ABAP
  • Developed and modified Universes using BO Universe Designer to get data from BW Info Cubes and Queries, and created reports using Web Intelligence
  • Developed couple of dashboards on top of webi reports
  • Involved in performance tuning by creating indexes, aggregates
  • Involved in creating financial and accounting reports in BEx query designer in BI
  • Developed BW metadata reports such as query execution frequency, most used bw report
  • Involved in developing a tax flow by extracting data from system called sabrix
  • Developed a process chain monitoring tool for monitoring process chains automatically by generating email alerts on success and failure with details
  • Improvement of process chain timings to complete well before sla by resequencing considering the dependencies
  • Weekly, monthly process chains are automated using decision box process

Confidential

SAP BI BO Consultant

Environment: SAP BI 7.0, BO 4.x, Crystal Reports, Web Intelligence, Dashboards, IDT, and CMC.

Responsibilities:

  • Identification of all the BEx reports in the system to be migrated to BOBJ
  • Identification and differentiation of the reports to be developed on which platform of BOBJ based on the complexity and the usage statistics
  • Worked on Information Design Tool extensively to create universes and BICS connections for the BW BEx queries and info-providers
  • Developed Web intelligence reports for several BW workbooks
  • Written formula variables, simple & complex, used merge dimension concepts wherever required
  • Done extensive formatting of the WEBI reports as per BNSF business standards
  • Developed several Crystal reports for all Bex report designer reports
  • Worked on Central management console for BOBJ
  • Moved developed reports across systems through CMC
  • Developed dashboards on top of various webi reports
  • Did scheduling of bobj reports as per business users need
  • Published BOBJ reports to portals, user mailbox, user sapmailbox, sharepoint, shared folders etc
  • Configured bobj portal for published instance cleanup
  • Automation of triggering of bobj reports through BW process chains
  • Training to end users on how to use and schedule BOBJ reports

Confidential

SAP BW BOBJ Consultant

Environment: SAP BI 7.0, SAP BO 4.0, FI and Confidential -PA, PD, CATS.

Responsibilities:

  • Worked in a team having onsite-offshore model. Offshore lead for a team of four Consultants.
  • Written technical specification document for the project as per client standards
  • Developed several standard and customized master data Info objects/Texts, Info cubes, DSO and Multiprovider according to the specifications provided by the clients
  • Extracting master data / transactional data in to BI landscape (data from both SAP R/3 and external source systems) with custom extractors, modifications, enhancement of business content extractors, generic extractors, transports and process chains
  • Worked on employee and supervisor hierarchy. Flattened hierarchies for user requirement in other systems
  • Enhanced customized data targets Info cube, ODS and Multiprovider
  • Developed several Analysis Process Design
  • Developed several infosets to address certain complex requirements
  • Created info Packages and populated info Cubes with initialization and delta loads
  • Designed and developed process chains (RSPC) for master data loads and transaction data loads
  • Modelled process chains after looking at the runtime statistics to before finish business SLA
  • Customized multi provider, added necessary object from different DSO’s and Cubes according to the client requirement for generating reports
  • Used Web Intelligence for web based query and reporting. Creating BI reports on Business Objects tools like Web Intelligence, Desktop Intelligence, Crystal Reports and see to the performance issues on both of them. Developed specific Queries based on user requirements
  • Have written complex formula variable in webi reports to address user specific requirements
  • Used information design tool to create universes and bics connection for the queries developed
  • Used central management console to transport bobj reports to production system
  • Involved in writing complex business documentation for the repository

Confidential

BW BO Team member

Environment: SAP BI 7.0, SD, MM.

Responsibilities:

  • Developed several customized Info objects, Info cubes, DSO and Multiprovider according to the specifications provided by the client
  • Extensively worked with Orders, Deliveries and Billing areas of Sales and Distribution module
  • Enhanced Data source as per the user requirement
  • Extracted data from R/3 to BI using Logistics Extraction
  • Worked on Performing LO-Cockpit extraction to extract the Header and the Line Item data from the Sales and distribution (SD) module (Sales Order “2LIS 11 VAHDR/VAITM”)
  • Created info objects, Data source, ODS, Info Cubes, Transformations, Info Packages and DTP’s
  • Created Interface design documents and Technical Design Documents
  • Created the Multi Provider from Actual Sales Analysis and Forecast/Planning data Info Cubes, and developed Daily Sales Report, and Ad-hoc Sales Report
  • Developed and modified Universes using BO Universe Designer to get data from BW Info Cubes and Queries, and created reports using WEBI
  • Worked with BEX analyzer, created queries with variables, filters, calculated key figures and restricted key figures
  • Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects connected to multiple data sources
  • Designed and developed process chains (RSPC) for master data loads and transaction data loads
  • Involved in completing the data flow for APO Demand Planning and created reports like Forecast Accuracy by Account Tracker, Forecast Error Report, and MTD Update for shipments and orders
  • Customized multi provider, added necessary object from different DSO’s and Cubes according to the client requirement for generating reports

Hire Now