SAP BW/BI Consultant


SAP BI 7.0 Certified Application Associate An accomplished business intelligence professional, with full lifecycle experience in the specialisms of data warehousing and business intelligence. Working collaboratively to translate business requirements into robust BI solutions, through a business partnering approach. An individual with a proven track record of successful implementations of BI reporting solutions. Over Ten (10) years of experience in Information Technology including four (04) years of Techno-Functional experience in SAP BI/BW SAP BI Expertise & Professional Exposure Data Warehousing: Experience in BI 7.X and BW 3.5 Data Warehouse Solutions. I have worked on requirement gathering, development, testing, go live and post go live support. Possess good experience in extracting data from SAP & non-SAP systems. I have sophisticated skills to work on Flat File Extraction, Generic Data Sources, BI Content Data Sources, Full and Delta Extraction Management. Data Modelling: Based on user and business requirements definition designing and building BI Objects like Info Objects, Info Cubes, DSOs, SPOs, Info Sets, Multi Providers, Info Sources and Data Sources. Creating Transformations, Info Packages, and DTPs for cleansing (consolidating), extracting and loading data into BI data targets. Activating and deploying Business Content objects and their customization as per business requirement. Data Extraction: Have experience in data extraction from SAP R/3 (ECC) using standard BI Content data sources like LO Cockpit, CO-PA data sources and also generic data sources. Also, used BODS as data access tool to access data from heterogeneous Data Sources. Standard business content data source enhancement as per the client’s business requirement. Experience with initial and delta loads process from ECC System. Reporting Solutions: Expertise in Reporting with Business Explorer using BEX Aalyzer, Query Designer, Universe, Web Application Designer and hands on experience building reports based on WEBI, XCelsius (Dash Boards) and Crystal Reports. Expertise in generating reports on the Multi Providers, Info Providers and Info Cubes using Filters, Restricted key Figures, Calculated Key Figures, Structures, Characteristic Variables, Text variables, Formula Variables, Cell Editors, Exceptions, conditions, RR etc. I have extensively worked on Sales Monitoring Reporting and Inventory reporting. Scheduling & Performance Tuning: Have expertise in creating process chains, Data load management, Scheduling Start Process, event triggers, event chains. Automation of complete master data as well as transactional data on daily, weekly, monthly and quarterly load. Also, have experience in Performance Tuning using Aggregates, Rollup, Multi Providers, Indexing, Partition and Compression. SAP BW/4Hana: Knowledge of SAP BW/4Hana Landscape and its architecture. Testing and Training: End user Training Document preparation.

Key Skills
  • SAP ECC 6.0
  • SAP R/3 4.6C
  • BEx
  • Query Designer
  • BW 7
  • BW 7.3
  • BW 7.4
  • SQL
  • PL/SQL

Work Experience

SAP BI Consultant

Allergan3 Years

Project Synopsis: Sales Reports using external Data: This project was to develop an application for monthly sales data reporting from IMS (data providers for pharmaceuticals). The requirement was to automate the data loading process with flat files as source and development of the cube that will cater for the monthly sales performance reporting of sales representatives. The main objective of this project is to identify the customers that still have payments and to align these customers with the sales rep in order to make them responsible for the payment clearance. The net outcome of these reports will affect their bounces Project Synopsis: AR Report: Responsibilities: • As BI Consultant worked closely with the individuals responsible (BI Team Leader/Business analysts) for business requirements gathering and analysis and have a thorough understanding of the way the data will be used to make business decisions and deliverables for report requirements along with functional end users in the business areas. And analysed to identify business content data sources for Enterprise Data warehouse. • Proactively involved in logical data modelling along with BI Team Leader as per gathered requirements from functional users in relevant functional areas. Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements. • Extensive work on Design & Development of Cubes, DSO Objects, MultiProviders and InfoSets. • Extensive work on design and development of data model to satisfy the various functional requirements by implementing cubes and queries using business content. • Worked with Team Leader and functional consultant for mapping the source data to target DataSources in BI. • Implemented various initiatives to streamline BW Health Check services as part of maintenance strategy which helped the customer to reduce their maintenance costs. • Used process chains to schedule the InfoPackages and data transfer processes. • Configured BI objects including generic data sources to extract data from R/3 systems. • Created & modified queries based on the user requirement using Calculated Key Figures, Restricted Key Figures, Free Characteristics, Navigational attributes, Filters, Structures, Variables, Text Variables, Conditions, Formulas, Exceptions. • Created SAP BI reports which include Plan/Actual revenue comparison, Order and sales value by sales representatives and Vendor delivery efficiency. • Developed on Sales and Financials reports as per User requirements. • Configured and implemented BW reporting using BEX analyzer/browser • ETL tools to include Dimension definition, Dimension attributes, Fact definitions, and Info Cube data structures. • Proposed and implemented performance improvement initiatives in the BW application area of Extraction, Data modelling and Reporting. • Trained users in reporting functions.

SAP BW Application Analyst

Sigma Intelligence 8 months

Duties (Main): London Borough of Southwark – Customer service centre analytics and performance reporting Full development life cycle SAP BI project to develop the analytical reports for monitoring the performance of the borough call centre. Created data model using EDW concept in SAP BI 7.0 and the developed reports using Web application designer, to be accessed on EP7.

SAP BW Support Analyst

Allergan1.5 Years

Responsibilities: • As a BW Team Member involved in the Maintenance and Support project. • Process chains Monitoring ( through Process Chain only) • In case of Process Chain failure, rectify the problem locally, if the nature of the problem is critical then escalated to European team and followed the instructions. • Involved in escalating high-prioritized tickets regarding extractions, performances issues and also load failures. • Maintaining reconciliation’s to verify the data in SAP R/3 and SAP BW and analyzing the data after the data loads. • Data Validation and Verification checking in BW and R/3 • Daily monitoring of Info Cubes and ODS object requests. • Project documentation (documentation of customised objects) for FDA Regulatory Compliance Software. Daily monitoring of Info Cubes and ODS object requests. • To assist with managing the BI transport process and to attend the change board as required. • Develop an understanding of Master Data management, Extraction, Transformation and Loading (ETL). • Regulatory Compliance Software. Daily monitoring of Info Cubes and ODS object requests.

System Analyst

Cogilent Solutions 2.5 Years

Duties (Main): Conducting a feasibility study to evaluate the business needs of the clients and document their actual procedures for various purposes. Analysing clients' existing systems. Study and gather end-users' requirements, business specifications and processes to compile system requirements and specification (SRS) document.

Software Developer

Digital Processing System 3 Years

Being a software developer involved in System Study and Development. Also, part of a team performed requirements analysis, data modelling of conceptual, logical and physical models. Assisted in writing specification and compiling the related documents for various business processes.