Sign in

Sales Data

Chennai, Tamil Nadu, India
January 18, 2019

Contact this candidate


Certified SAP BI Consultant

Certification ID: 001*******

Mr Rubhan Edwin; +919*********

No:43, 4th Block, 104th street, Muthamil Nagar, Kodungaiyur, Chennai-600118. Personal profile:

Master’s in Computer Networking Principles and Practice (MSc) from University of Hertfordshire and Bachelor of Engineering in Electronics And Communication Engineering from Anna University Chennai. Has great passion for working in SAP. Recently trained in SAP BI and completed SAP BI Internship in United Kingdom. Exceptional communication skills, innovative and team working capability with an assured and positive approach to everyday challenges.


My Objective is to start a career as an SAP BI consultant and gain new technical skills and knowledge. My solid academic background, good technical aptitude, and experience that I attained through internship at Wizcore, made me a strong candidate that is eager to pursue an extensive and successful career by means of your company. Technical Skills:

● Data Warehousing - SAP BI 7.0,7.4, ERP Packages – SAP R/3 ECC 6.0

● Programming Languages - Java, C, C++, HTML

● Networking - Configuring Cisco Devices, VLAN Configuration, Network Design, Virtualization

● Operating Systems – Windows NT, Windows 8.1, Mac Ox and work with Linux


● Competent with computer hardware; Installing or removing hardware and troubleshooting issues.

SAP Certification

Certified SAP Consultant on August 10, 2017 from SAP Global Certification in United Kingdom.

SAP Certified Application Associate – Modelling and Data Management with SAP BW 7.4 Education and achievements

MSc Computer Networking Principles and Practice University of Hertfordshire 2017 B.E. Electronics and Communication Engineering Anna University Chennai 2014 SAP BI Key Skills:


Created Info objects, Info Cubes, DSO, Multi providers, Info sets, Data Source. Administration of data targets, ETL, Create and use data transformation and Data Transfer Process to load and transform data from various sources. Analysed and activated relevant Business Content in BI system. Process chains design, Managed process chains Reporting:

Experience in Report Generation - worked on BEx Analyser, Query Designer, Web Application Designer, Info set queries and queries on Multi providers. Created custom queries using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures. Created aggregates for frequently used queries. Query performance optimization Data extraction from SAP Components:

Generic Extraction, Customized LO cockpit Performance Tuning: Compression, Aggregates, Rollups, Cube Partition. Improved data load and query performance by doing compression, aggregates, partitioning and SQL Trace. Created and maintained Authorizations, Events, and Process Chains (RSPC)

Internship Experience Wizcore Consulting Ltd

Sap Bi Junior Consultant

Job Description: Working with the SAP Delivery team. The job involves understanding the business requirements of the client and implementing it in the system like generation of reports from various other processes like Financials, Logistics, Materials Management, and Human Resources by coordinating with consultants from respective processes. Responsibilities:

● Involved in design and development of stage 2 & 3 for client Logistics &Supply BI solution.

● Sales, Billing Cubes, and Data Store objects will be used to capture details of all Sales Orders & Billing documents generated daily in the ECC System and will pass the data to the client BW that will support the CLIENT Order Book reporting requirements using standard extractors.

● Payments cube will be used to capture the data by using customer defined table in the ECC system to report customer, Sales Order, and Method of payments details.

● Footfall and Footage data is interfaced from the ‘Shopper track system’ from stores to a central legacy system database table on a daily basis. These Cubes are used in a multi cube with the sales order cube to report on the conversion rates, actual sales orders and KPI for sales by square footage.

● Material Moment Info Cube contains all goods movements that affect stock during the logistics process like All goods receipts and goods issues, Merchandise clearing

(receipt/issue), Stock correction (positive/negative) (for example, due to physical inventory) and Returns to vendors. Info Cube is supplied with values from standard data sources from ECC system.

● Developed flat file structure to load CSV files into estimates DSO to hold CLIENT sales order history. Conversion of Sites IDs, Cost Centre and Profit Centre will be carried out through the update rules when the data is loaded into the estimates DSO. The DSO will be used subsequently to load the data into an Estimates Summary Cube that will be used for estimates Reports like (Weekly Estimates Report, Monthly Estimates Report and Regional Estimates Reports).

● Enhanced Master Data Objects Article, Plant, Vendor, and Customer by using the standard business content data sources.

● Implemented new concepts and technologies that are available in the Data Warehousing Workbench for process design and modelling data.

● Created Data Transfer Process (DTP)to transfer data within BI from one persistent object to another object.

● Performed migration of emulated data source

● Formulated logical splitting data leads for more robust data loading to reduce data loading impact on reporting to improves query performance.

● Involved in designing the End to End-Daily Sales reconciliation report in Portal cockpit using Web Application designer 7.0 for Sales and distribution Lean Process.

● Used Direct Update DSO in the process of APD (Analysis Process Designer).

● Near real-time reporting.

Work Experience:

Company Name : Prompt Integrated Facility Services Pvt Ltd. Designation : SAP BI/BW Consultant.

Duration : Oct 2017 – Till date.

Environment: SAP BI 7.0, ECC6.0 Business Areas: SD, MM. Role: SAP BW/BI Consultant Description: Working with the SAP Delivery team. The job involves understanding the business requirements of the client and implementing it in the system like generation of reports from various other processes like Financials, Logistics, Materials Management, and Human Resources by coordinating with consultants from respective processes.


● Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and multiproviders

● Set up periodic Data loads from legacy system (flat files)

● Involved in extracting the data from External Source system like Informatica.

● Installing and creating BI objects like info objects, DSOs, Info cubes.

● Creating and managing dataflow using DTP, transformations and info packages.

● Data Source Enhancement according to customer requirement.

● Designed and developed queries to generate reports inBEx Analyzer.

● Worked extensively on query designer.

● Extensively Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system.

● Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.

● Created ODS, Infocubes, Multi-providers and infosets and extracted SD data (Data sources Like 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL) of SAP R3 into SAP BW using LO Cockpit(LBWE) extraction. Extensively worked for Sales Order Review.

● Setup and monitored collective run jobs for SD module in LO Cockpit.

● Monitored loads for SD module from R/3 source system.

● Corrected delta load failure for SD module.

● Schedules DTP for loading Transactional Data from PSA to Info Provider using process chains.

● Extensively used Structures, cell definition, calculated key figures, restricted key figures, new selection, new formula, exceptions and conditions.

● Involved in frequent client meetings to discuss project status. Languages

- English (Fluent)

- Tamil (Fluent)

Additional Skills

• Enthusiasm – Enjoy learning new skills, techniques and approaches to problem solving.

• Flexibility – Able to adjust to any given scenario to achieve the task at hand.

• Teamwork – Work well within a team and ensure all members opinions are heard and used to achieve the best outcome.


I do hereby confirm that the information given above is true to the best of my knowledge. Date: Rubhan Edwin

Place: India.

Contact this candidate