We provide IT Staff Augmentation Services!

Sap Bw/bi Sr. Consultant Resume

SUMMARY:

  • Seeking opportunities to assist organizations in achieving business objectives by bringing strong leadership, technical development, design experience, and effective communication skills to collaborative ventures with business partners and other stakeholders.
  • Total 8 years of extensive experience as a SAP BI/BW (7.5,7.4,7.3, 7.0.) consultant, which includes experience in SAP HANA as a techno - functional consultant playing various key roles in Design, development, Production support and reporting techniques across modules SAP Investment Management, FI/CO & Treasury.
  • Expertise in implementing 3 Complete Life-Cycle Implementation of SAP BW/BI which dealt with Blue Print, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up-loads), Scheduling, Monitoring, support packs implementation, BEx Analyzer, Query Designer, Web Applications Designer, Testing, Go Live & Production support, End user documentation.
  • Strong working experience in data analysis, design, development, implementation and testing of data warehousing using data conversions, data extraction, data transformation and data loading (ETL).
  • Extensively worked on LO Extractors.
  • Solid experience in construction of customized Info Objects, Basis Info Cubes, Remote Cubes, Transactional Cubes, Virtual cubes, Multi Providers, Info sets, ODS/DSO objects, Advanced DSO and Composite Provider.
  • Expertise in Transformations, DTPs, Update rules. Transfer Rules, Hierarchies, Routines, and Process Chains.
  • Extensively worked in creation of process chain for daily, monthly and quarterly data loads also involved in creation of mailing chains to deliver the mails automatically to the clients.
  • Conducted and performed Performance tuning Techniques (Aggregates, Process chains, Cube Compression, Line Item Dimension, and Indexing) for Improving the Reporting.
  • Expertise in BEx Analyzer, Web Application Designer, Info-Set queries. Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures. Expertise in publishing queries to web portals through Web Analyzer.
  • Expertise in Business Explorer Suite - BEx Query Designer, BEx Analyzer and BEx Web Analyzer.
  • Good Knowledge on BW 7.4 and its new features like Hybrid Providers, Semantic Partitioning Objects, Advanced DSO, Composite Provider, HANA Views, HANA Optimized Cubes.
  • Extensively worked on SAP BW 7.5. Extended non cumulative handling for Advanced Data Store Objects with delta calculation.
  • Conversion of existing MultiProvider and “old” Composite Provider.
  • Experience in Creating Universes (.UNX and .UNV) using Business Objects Universe Design Tool, Information Design tool(IDT) for Web Intelligence (WebI)
  • Expertise in creating complex filters such as pre-defined conditions, report filters, prompts and drill filters.
  • Extensively Worked on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges, Stored Procedures and CE Functions.
  • Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
  • Understanding of SAP In-Memory Computing Architecture, Column store, Row store tables in SAP HANA studio.
  • Experience in SAP HANA development, migration, optimization and support for mixed approach with Native and SAP BW on Hana solutions.
  • Extensively worked on SAP NLS (Near Line Storage), Hot, warm and Cold Storage and unlocking data when is needed.
  • Good HANA SQL scripting knowledge.

SAP TECHNICAL SKILLS:

Data Warehousing: SAP BW 3.5, BI 7.0, BW 7.3, BW 7.4, BW 7.5

ABAP: Routines (Start, End & Field Routines), Debugging, Modifying Existing Functional Modules, Executing Programs and reports, Creation of Customizing tables, Routines in DTP Filters.

SAP HANA: Hana Modelling, Data Provisioning methods and Performance optimization.

SAP BO: Creation of Webi and Dash boards.

PROFESSIONAL EXPERIENCE:

SAP BW/BI Sr. Consultant

Confidential

Responsibilities:

  • Implementing a full life cycle Analytics solution which includes Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
  • Designed and implemented SAP HANA 1.0 SP9 data modeling using Attribute view 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.
  • Extensively worked on Query building, filtering, free Characteristics, RRI-Jump queries, Restricted Key Figures and variables, Calculated Key Figures, Conditions, and Exceptions using BEX Analyzer.
  • Maintained Process Chains to automate and schedule the data loads.
  • Extensively worked on SAP BW 7.5. like Creating Advanced DSO, Open ODSO View and Composite Providers.
  • Extensively worked on Data design and Data modeling using Extended Star Schema.
  • Configured components related to sales orders like sales document types, item categories, schedule line categories etc.
  • Worked on Business Content SD and MM Extractors and enhanced datasources for 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL.
  • Developed trended versions of Revenue reports by Region, Product and Service.
  • Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
  • Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Advanced DSO, Composite Provider, Multi Providers, Info Sources, Infoset, time dependent master data also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc
  • Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.
  • Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.
  • Involved in postproduction support activities in monitoring the daily data loads, fix report issues, and reconciliation issues. Defined Transformations created DTP’s and Info package for scheduling loads to data targets.
  • Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
  • Worked on NLS, Achieving data.
  • Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.
  • Meeting SLA for all the developments and continuously tracking for the updates to move the project in a smooth way to the target state.

SAP BW/BI Sr Developer

Confidential

Responsibilities:

  • Uploading Master data and Transactional data of Daily, weekly, and Monthly, Data Loads using Process Chains.
  • Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.
  • Handled the tickets of priority S1, S2 and S3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
  • Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.
  • Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
  • Involved in creating data source for FI, MM and SD modules and also from flat files.
  • Created open hub to transfer data from Info Provider to Flat Files for further analysis.
  • Schedule Daily/Weekly/Monthly data loads schedule new jobs.
  • Worked on aggregates, export data source, transfer rule, update rule, info source.
  • Created process chains for data loads for transaction data, master data, and data from finance and Goods movement.
  • Created reports, web reports.

Hire Now