SUMMARY
Certified SAP BI/BO consultant with 5 years experience. Worked on several life cycle implementation projects with hands-on experience in different stages of SAP BI rollouts: Modelling, Extraction, Transformation, Loading, Reporting and Analysis. Experience in Data Extraction from SAP ECC6 into SAP BW 7.3 and 7.0 system using LO-Cockpit Extract Structure. Able to present data with various tools within Business Explorer as well as Business Object XI 3.1 and 4.0 suite. Conducted number of training sessions and knowledge transfer. Sound knowledge of the new technologies used in HANA 1.0.

SKILLS:

• SAP Tools: SAP NetWeaver 20004s, SAP BI 7.0,SAP BI 7.3,SAP BO 3.1, SAP BO 4.0, ECC6.0, HANA 1.0, SAP SOLMAn
• Languages: SQL, ABAP
• Database: Microsoft SQL

Reporting tool: BEx Query Designer, BEx Query Analyser, WEBI, Universe Designer, Xcelsius 2008,Hyperion reporting

SAP EXPERTISE:
Expertise in Data Modeling: Creating necessary BI InfoObjects, Data Store Objects, InfoCubes, InfoSets, MultiProviders, InfoPackages, Data Transfer Process and Transformations as per client requirements.
SAP BI 7.0 & 7.3 Data Extraction: Experienced in Data Extraction from SAP R/3 using LO-Cockpit extraction structures and other extraction structure.
Good experience of BW backend dataload and front end query performance tuning
Good experience of integrating BW and SAP BO 3.1/ BO 4.0 together
Good experience of working with ECC6.0 components like Data Source Enhancement. Created and activated Generic Data Sources.
Versatile experience in creating Queries in Query Designer, using various activities such as Variables, Restricted Keyfigures, Calculated Keyfigures, Filters, Exceptions. Customised and improved query navigation by implementing Conditions, Jump queries using RRI, Free Characteristics.

Experience:

• Use SAP HANA sandbox to practice on HANA for 7 months
• Data provisioning using SAP BODS to load data into HANA from a Microsoft server environment
• Created Attribute view, Analytical view and calculated view
• Created analytic privileges based on attribute
• Created SAP BI 4.0 SBO report based on schema defined in SAP HANA
• Created HANA optimised DSO based on HANA as a database
• Assign users to user group and created privileges based on the user group define

Company: Confidential,Houston Texas, USA
Duration: May 2010 – Present
Role: SAP BI/BO Consultant
Environment: SAP BI 7.0,SAP BI 7.3, SAP BO 3.1, SAP BO 4.0, BEx Suite, ECC6, OTC, P2P, P2M, QA, Microssoft SQL, Hyperion Reporting, SAP Solution Manager, WEBI, Universe

Confidential, is a leading provider of electronic security products and services, fire protection products and services, valves and controls, and other industrial products. Tyco is a highly diversified global company that provides vital products and services to customers in more than 60 countries around the world. SAP is used to support a wealth of Tyco activities making sure that they are handled in timely efficient and effective manners.

Excellent knowledge of design and implementation of an end-to-end project using ASAP methodology.
Working with the Global Business user community and IT Business Analysts to analyse business needs, document requirements, develop technical designs and to deliver technical solutions
Responsible for delivering the Business Intelligence solutions to the end user with in a structured framework based around the SAP Business Objects BI and SAP Business warehouse BW platform.
Responsible for implementation of global business process for OTC (order to cash), P2P (procure to pay),P2M (procure to Manufacture), Inventory etc. in the Business Warehouse and business intelligence environment
Creating various Sales Analysis and other KPI’s report used by business
User support and responsible for conducting user training.
Responsible for weekly and monthly Validation and recon activity using Microsoft SQL in order to make sure that data in BI report and database match
Review and validate data loaded into the data warehouse for accuracy and at the same time, interacts with user community to produce reporting requirements.
Provides technical consulting to users of the various data warehouses and advises users on conflicts and inappropriate data usage.
Optimised queries run time by creating queries with Variables [User Exits, Replacement variables and Manual input].
Integration of SAP BW and SAP BO using SAP integration Kit
Business Object Universe design
Involved in various kinds of Unit testing, Integrated Testing, Acceptance testing and Regression testing of the developed objects, reports and checking the data quality and the functionality of the objects as per the requirements.
Implemented various Performance Tuning activities to increase the performance of Queries by Creating Aggregates, Partitioning and Compression of infocubes.

Responsible for Identifying Business Requirements from end- users. Installed Business Content, Modeling various objects like Info Object, Info Source, Info Cubes and DSO Object.
Tested the new features of BW 7.0 which includes new data flow, re-modeling, Real-time Data Acquisition, enhanced features of Process Chains etc.
Responsible for the creation of Naming Convention document and other Documents for Infocubes, DSO Objects, Info Sources, Info Objects.
Worked extensively on Logistics Cockpit and extracted data. The data included Sales Order, Delivery, Shipment, Billing, Purchase, Goods Movement, and Stock Revaluation.
Extended the Business Content Data sources using Enhancements and populated the appended fields using User Exits. Created custom Info Source/Data Source, ODS, and Info Cubes for Data extraction, transformation and loading from SAP R/3 system to SAP BW
Involved in Sales order Header and Item Level data extraction
Used different tables to extract data, tables such as VBAK (Sales order header data), VBAP (Sales order item Data), VBUK (Sales document Header status), and VBUP (Sales document item status).
Was involved in Building different Cubes, DSO’s in supply chain management, info-providers in Quality Management: Inspection lot cube, notifications item DSO, Notification Activities Cube, Plant maintenance: Equipment Dismantling, Maintenance orders Cubes. Purchasing, Production Planning and Controlling.
Managed, monitored several data loadings, Error Debugging and rectification, solving issues, problems faced during Data uploads. Involved in Increasing the Load performance of the BW system while loading into ODS objects and Info cubes.
Created Process Chains for loading Master and Transaction data and running subsequent processes.
Data querying using SQL within Microsoft server 2008 environment
Project and user support and responsible for ticket escalation in cases of data mismatch
Responsible for Oracle ERP trouble shooting and oracle data recon within BI environment
Responsible for Oracle Hyperion data extract and loading into BI
Project monitoring and planning in MS project
Project documentation and Business process roadmap definition within SAP Solution manager environment

Company: Confidential,London, UK
Duration: 2007 – September 2010
Role: SAP BI Consultant
Environment: SAP BI 7.0, BEx Tool, ECC6.0, MM, PP, SD

• Understand design documentation including the high-level data model and understand the complexity and dependencies and plan the timelines for development based on the resource availability.
• Interpret functional requirements based on the design document and support the Technical Development Specifications for SAP BW database and reporting objects.
• Creation of Generic Datasource using Tables/Views, Functional modules and customizing the Business content Datasource through User Exit in SAP R/3 and ECC6.0.
• Developing various kinds of reporting objects including the Queries, query variables, Variable exits, workbooks, RRI. Exceptions, conditions etc.
• Customizing of standard BW objects as per the client requirements and extraction and loading of data from ECC.
• Used RRI interfaces, filtering, conditions, variables, currency conversions, jump queries and navigational attributes. Exception handling through SAP Mail, batch printing and alert monitor.
• Created Aggregates for Info Cubes to improve query performance.
• Develop SAP BW Reports in support of Functional and Technical specifications and document the design and development of the Database objects and reports.
• Transportation of BW Objects from Development system across the landscape through Transport Connection.
• Schedule daily/weekly/monthly data loads.

Maintaining Reconciliation to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
Monitoring of data loads and analyzing the reasons for frequent failures of info packages.

• Involved in solving tickets regarding Extractions, Performance Issues and also Load Failures.
• Created Reports using Calculated Key figures, restricted key figures, Formulae, Conditions and Variables and Developed Drilldown Reports Using RRI
• 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.
• Maintain list of all the activities for all the tickets until it is closed down.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of infopackage.

Education/Certifications

• Certified HANA Consultant
• SAP Certified Solution Consultant
• Masters in Petroleum Engineering
• Bachelor in Mechanical Engineering