We provide IT Staff Augmentation Services!

Sap Bw Consultant Resume

2.00/5 (Submit Your Rating)



  • More than fourteen years of IT experience in Analysis, Technical Design, Development, Testing and Documentation including ten years of BI experience and more thanfour yearsof programming experiencein Application development.
  • Good functional knowledge of SCM, SD, MM and FI modules.
  • Having good experience as Business Analyst - Requirements gathering, Business requirements writing, Use Case development, and Analysis & Organizational skills.
  • Excellent analytical and logical skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
  • Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the Software Development Life cycle.
  • Good communication skills, interpersonal skills, self-motivated, quick learner.
  • Very good experience of SAP BW Components like Info Cubes, DSO, Multiprovider, Info Source, Info Objects, & Transformation.
  • Expertise in Data Modeling, Activity Diagrams, ETL, Business Objects, Data warehousing, SQL, Extended Star Schema, Data slice, Requirements Gathering.
  • Expertise in performance tuning of BW systems. Evaluated statistical performance and improved data load performance, query performance by compression of InfoCubes, creating aggregates etc.
  • Undergone complete life cycle implementation of BW, which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO Cockpit, CO-PA and BEx Query.
  • Used Delta Update process for loading the data to BW from R/3 in specific intervals.
  • Experience in Report Generation in BEX Analyzer in building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries using Conditions, Exceptions, Variables & Structures and created Aggregates for frequently used Queries.
  • Excellent production support skills including data loads, reporting related Issues.
  • Extensively involved in production support, expertise in process chains monitoring and resolving the support tickets.
  • Good understanding of OLAP concepts and OLAP database environments.
  • Unit, integration, performance testing and Participated in design reviews.
  • Experience in connecting legacy system/Non-SAP System via DB connect, and pulling data in SAP-BI system.
  • Experience in Stored procedures and writing SQL scripting in SQL server 2014.
  • Experience of BOBJ tools like Crystal Report, Dashboard, Web Intelligence, Information design tool, Explorer, Design studio.
  • Good understanding of creating BW on Hana database.


Business Intelligence: SAP BW 7.0, 7.3, 7.4 BO 4.0

ERP: SAP R/3 and SAP ECC 6.0

Reporting: BEx Report Designer, Web Application Designer (WAD), BEx Web Analyzer, BEx Analyzer, Dashboard, Crystal Report, Webi, MS Excel

Modeling tools: SAP HANA, SAP NetWeaver BW

Languages: ABAP, SQL

Database: SQL Server 2012/2014, SAP HANA


Confidential, NY

SAP BW Consultant


  • Monitored, troubleshoot and resolve system issues, determine root cause analysis.
  • Involved in architecture level support for existing and new reports.
  • Implemented SCM BW reports for Delivery Assurance, Supplier category and Material Performance.
  • Created technical specification documents.
  • Created financial report for the variance on GL detail and GL summary.
  • Implemented new monthly Budget & Plan reports in Investment Management (IM).
  • Provided support to end users after go-live.
  • Written Badi methods in ABAP to move the data for newly included field in the extractor in ECC.
  • Debugged, tested data models for unit and integration testing.
  • Maintained all support documentation in accordance with Brion standards requirements.
  • Involved in escalating high-prioritized tickets regarding extractions, performances issues and load failures.
  • Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
  • Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
  • Analyze and coordinate efforts in transforming business requirements into cost-effective solutions.
  • Experience in creating universes using information design tool 4.0 and also connecting to multiple data sources.
  • Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
  • Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
  • Developed WEBI reports on Webi Rich client.
  • Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
  • Implemented on data staging process for BPC 10.0 project.
  • Involved in creating architecture for GL cube.
  • Implemented process chain to upload the delta to staging cube
  • Worked with client to give more summarized data on the staging cube.
  • Written transformations and Badi methods in ABAP.


SAP BI Analyst


  • Monitored data loads (Flat file, R/3) on daily basis and effectively handled many extraction errors during data load.
  • Effectively handled Flat file and master data loading to the DSO's and Cubes.
  • Handled effectively the change requests for the DSO's and Cubes and queries.
  • Worked on creating transport requests and Releasing to the test and production servers.
  • Resolved many issues that came in production support.
  • Extensively used BEx Analyzer and Query Designer for building Queries.
  • Created the process Chains and automated the load process based on the business needs.
  • Review of Functional Requirements, identify gaps and recommend/suggest changes.
  • Involved in developing the DSO, Cubes, Web Templates, Bex Reports and other BI objects.
  • Worked on job schedules for loading data and monitoring Process Chains to run periodic loads and other processes.
  • Involved in escalating high-prioritized tickets regarding extractions, performances issues and also load failures.
  • Involved in fixing Delta load failure while extracting data from R/3 to BW.
  • Performed periodic cleanup in PSA. Extracted and loaded data from SAP R/3 into Sales Order InfoCube using Data Sources.


Engineer -Software Development


  • Supported and monitor data warehouse batch schedule, information access, reporting and analytics service performance
  • Analysis, writing Functional and Technical specification, Visio flow diagrams.
  • Prepared reports, manuals and other documentations on the status, operation and maintenance of software.
  • Involved in fixing data load failure while extracting data from R/3 to BW.
  • Involved in ETL process, process chain.




  • Involved in gathering the requirements and creation of functional specifications and solution design document.
  • Build objects in BW Administrative Workbench adhering to the naming conventions and guide-lines set for the project.
  • Worked in data extraction - enhanced COPA Data source to extract additional fields required for reporting.
  • Wrote ABAP Code for transformation routines and Customer Exit variables in BI.
  • Enhanced Sales analysis report with new logic for analysis on different variances. It also included data model change to populate the new fields.
  • Prepared reports, manuals and other documentations on the status, operation and maintenance of software.
  • Developed a new consolidated Profit & Loss report at group and country level to analyze Measure hierarchy based on reportable and non-reportable materials. It also has an impact analysis of different currencies on different levels of profitability.
  • Involved in transportation of objects, data validation, User acceptance testing and documentation.


Trainee Software Engineer


  • Involved in Analysis of the functional modules.
  • Involved in Data Modeling, Extraction and loading.
  • Created Data modeling flow on Visio.
  • Analyzed Production Support Calls.
  • Development of Sales Summary Report and Inventory balances Report.
  • Data Reconciliation between EIS report output.
  • Prepared reports, manuals and other documentations on the status, operation and maintenance of software.

We'd love your feedback!