OVERVIEW:

• Over 8 years of extensive experience as SAP BI /BW/BO Consultant.
• Experienced in BW/BO Implementation Support projects for SAP MM, SAP SD modules
• Expertise in working with BI along with ABAP development, and end-to-end development.
• Experience in SAP Business Objects suite of products like Universe designer, Information Design Tool, Web Intelligence, Webi , Dashboards and SAP-Lumira Reports.
• Expertise in building BI components like Info-objects, Data sources, Info cube, DSO, Transformations, Data Transfer Process DTP , Multi providers, Open ODS View, virtual providers and Master data Info Objects.
• Experienced in installing the Business Content Objects depends on client requirements.
• Extensive Experience in LO Extraction using different Update modes.
• Expertise in Performance Tuning Concepts like Compression, Aggregation, partitioning.
• Worked on Scheduling and Monitoring the daily and weekly process chains, Data loads Full /Delta Up-Load .
• Expertise in writing SAP ABAP code for Start Routines, Field Routines End Routines.
• Worked on Bex query designer and analyzer in building Queries, Columns, Rows, Filters , Structures, Restricted key figures, Calculated key figures, Variables, Exceptions, and conditions
• Worked with cross functional teams interacting with management and business users.
• An excellent team player as well as an individual contributor with good communication and interpersonal skills.

SKILL SETS:

• ERP : SAP BW/BI 7.3, SAP ECC 6.0, HANA 1.0
• Reporting Tools : Bex Suit, BI 4.0 Tools - UDT, IDT ,Webi, Dashboards
• Operating Skills : MS-DOS, WINDOWS'95/98/NT, WINDOWS 2000/7/8
• Programming Languages : ABAP/4, C, C , VB.Net
• RDBMS : Ms Access, SQL Server 2000, SQL Server 2005.

PROJECT EXPERIENCE:

Confidential

Role : SAP BI/BO

Responsibilities:

• Collect business requirements and perform GAP analysis by comparing the business requirements and standard content.
• Created the technical specifications for the SAP SD module to extract sales orders, inventory stocks and delivery of product.
• Created the Generic Extract Structure for Transactional data using Views and Function modules as per the extraction requirements.
• Preparation of data model and dataflow of sales process for barcode readers and printers based on the specifications.
• Schedule data loads into BW from R/3 involving initial data loads and delta data loads.
• Data loading was monitored and the failed data packets were analysed and if possible manually edited in PSA mostly for invalid characters and re-loaded to DSO.
• Created Classes, Objects, Measure objects, Joins, short cut joins and predefined conditions in the universes.
• Designed and linked the universes for query reporting and analysis.
• Resolved loops in existing universes using Aliases and defining Contexts.
• Used Dashboards as a Data Visualization Tool to transform some Microsoft Excel spreadsheet data into visuals such as Pie-Charts, Bar Graphs that can be shared via PowerPoint and PDF files.
• BW Queries, BW cubes and R/3 table data and Universes were used as the main data sources.
• Designed Process Chains with Decision Making Process to automate Sales orders , Delivery and Billing loads as per the weekday and weekend schedule.

Confidential

Role : SAP BI/BO Consultant

Responsibilities:

• Designed and Developed WEBI Reports as per the Users Requirements using the features in Business Objects including: Master/Detail, Charts, Cross Tabs, Drill Down and Formulae to analyse the data.
• Scheduling the processes and administering the BO activities using Business Objects
• Extensively worked with Web Intelligence to create thin client reports based on the business requirements.
• Created Classes Sub classes , Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes.
• Implemented various types of joins including eqi-join, outer-join, theta-join, self- restricting join, defined cardinalities and resolved issues like loops by creating aliases and contexts to remove the cyclic dependencies.
• Worked with various enhanced front end tools, BEx Query Designer, BEx Query Analyzer.
• Worked on user generated tickets like Data mismatch, data inconsistency and other report related issues and fix the same.
• Created an Open hub procedure to send the data to Third Party Tool like Excel as an outbound file.
• Worked on data source enhancements for LO Extractors to populate the data for custom fields using CMOD.
• Designed and developed Info Cubes with various aggregate levels and Multi providers.
• Created new Data models using data loading with IP, Transformation and DTP Data Load Process for data distribution into Info Cubes and DSO.
• Studied and analyzed business reporting requirements to build proper data flow.
• Designed Universe by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the Objects like Dimensions, Details and Measures.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.

Confidential

Role : SAP BI Consultant

Responsibilities:

• Responsible for requirement gathering and analysis of the business requirement that could be satisfied with SAP business content and created the necessary objects required.
• Customized LO cockpit by using enhancements and wrote User-Exit programs to populate the enhanced fields.
• Enhanced 0MATERIAL ATTR and 0MAT PLANT ATTR to enable Mat Grp1, Safety Stock and Lot sizes.
• Designing ETL Documents for setting up the procedures for extractors.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Installed and activated various businesses content info objects for different applications.
• Expertise on Queries by using the diff functionalities like Calculated, Restricted key figures, Structures, Variables, Exceptions, Conditions and Formulas.
• Created the different types of variables in Bex according to the business requirements.

Confidential

Role : SAP BW/BI Consultant

Responsibilities:

• Activated the business content objects includes info cubes, data sources, info object according to the report requirements.
• Involved in the unit testing and integration testing for the developed flows.
• Coordinating all maintenance activities with Basis team other support IT staffs.
• Maintain Work History for all the tickets until it is closed down.
• Expertise on creating Queries by using the diff functionalities like Calculated, Restricted key figures, Structures, Variables, Exceptions, Conditions and Formulas.
• Managing the process chains and monitoring them.
• Maintaining work history for the changes made to the process chains.
• Preparing the BW System for reporting by end of the day.
• Requirement gathering for new Defects related to BW system

Confidential

Role : SAP BI Consultant

Responsibilities:

• Worked on user generated tickets like Data mismatch, data inconsistency and other report related issues and fix the same with root cause analysis
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Supporting production system through timely availability of data to meet the customer SLA with business.
• Monitoring the data loads from various source systems by means of process chains /batch Jobs as part of support.
• Error Debugging and rectification of the problems faced during Data loads.
• Developed flexible queries using filters, navigational attributes in BEX Analyzer to facilitate data analysis in a drill down.