SUMMARY

• Proactive, result - oriented with over 5 years of work experience in SAP BW/BI7.0 SAP BW experience includes full Life-Cycle implementation on Modeling, Extraction and Reporting using BEx and have extensively worked on creation of InfoCubes, DSO, activation of Business Content and designing of process chains.
• Proficient in understanding client business process and requirements gathering.
• Able to demonstrate high attitude, honesty and dedication towards any project working along with Senior Teams and Project Leads in a pro-active disciplined manner
• Implemented SAP BW through 2 Complete Life Cycles using ASAP Methodology.
• Focus on SAP Business Data Warehouse, Design, Development, and Performance.
• Business requirements gathering, Developing data models and front-end reports in the SAP Business Warehouse Environment
• Experienced with all phases of BW application development, data extraction, InfoCube building and reporting.
• Good knowledge on how to improve data load and query performance using compression, aggregation and partitioning.
• Good communication skills with the ability to train end users, develop end user processes documentation, and provide support in production environment.
• Highly experienced in creating queries in BEx Designer using Conditions, Exceptions, Filters, Calculated Key Figures, Restricted Key Figures, Variables, and Structures
• Experience in developing generic extractors.
• Excellent ETL experience from SAP, and Non SAP systems into the Info Providers.

PROFESSIONAL EXPERIENCE

SAP BI Consultant

Confidential

Responsibilities:

• Developed queries using filters, variables in BEx analyzer to facilitate data analysis in a drill down and summarized way to give detailed level of information
• Provided production support including but not limited to monitoring data loads, and system performance during the data loads.
• Interacting with business users to gather reports requirements, perform gap analysis and develop customized reports
• 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.
• Used BEX Analyzer, and Query Designer for Query Presentation, Management and Generation.
• Optimized queries run time by creating aggregates as per the report design.
• Implemented various Performance Tuning activities to increase the performance of Queries by Creating Aggregates, Partitioning and Compression of info cubes.
• Responsible for Identifying Business Requirements from end-users. Installed Business Content, Modeling various objects like Info Object, Info Source, Info Cubes and DSO Object to satisfy the business requirement.
• Worked extensively on Logistics Cockpit and extracted data. The data included Sales Order, Delivery, Shipment, and Billing.
• Managed, monitored several data loadings, Error Debugging and rectification, solving issues, problems faced during Data uploads. Involved in Improving 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.
• Developed queries using filters, navigational attributes, variables in BEx analyzer to facilitate data analysis in a drill down and summarized way to give detailed level of information.

Environment: SAP version BW7.0.

SAP BW Consultant

Confidential

Responsibilities:

• Analyze and configure BW/BI 7.0 data environment to facilitate custom reporting and data analytics solutions.
• Build and enhance BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data, Transformations, and Update Rules, DSO, Extractors, Info sets,
• Developing as well as providing support to the existing project throughout the system.
• Monitoring of loads and fixing failures.
• Interaction with teams providing data for data issues.
• Administrating PSA data for all PSA tables and monitoring of their sizes.
• Resolved Remedy tickets raised by Business Users for their issues on BW Reports on data integrity, assistance for writing queries, saving workbooks, validating data with source systems or if application is not working or its slow.
• Communication to users in case of any load delays or issues with source systems.
• Modeling, Changing Info cubes, DSO, Info Objects, Info Sources, Update rules, Transfer Rules, Routines e.g. Start Routines.
• Enhancements of new fields, user exits both for Master Data and Transaction Data Sources.
• Creation new Generic Extractors based on Tables and Info Sets using Programs.
• Created, modified and monitored Process Chains, Info package Groups.
• Activated Business Content and data staging for new developments.
• Extensively worked on BW Scheduler to load data into Info cube.
• Created Aggregates to improve system query performance.
• Worked extensively on Administrator Workbench (AWB) including an in-depth knowledge of Sap’s Extended Star Schema Modeling.
• Worked on Sales Order Data Sources 2LIS 11 VAHDR and 2LIS 11 VAITM, Sales delivery - 2LIS 12 VCITM, Sales Billing - 2LIS 13 VDITM.

Environment: SAP BI 7.0, ECC 6.0, BEx Portal

SAP BW Consultant

Confidential

Responsibilities:

• Created a new data model with multi-providers to improve query performance.
• Activation & Installation of Business Content Objects for business content Enhancement.
• Created an Aggregate-schema to improve the Query Performance drastically.
• Analyzed business reporting requirements against standard Business Content and installed the necessary objects.
• Responsible for extraction of Purchasing and Inventory logistics data Creating new Info Objects and enhancing Extract structures, Enhanced Transfer rules and communication structure
• Designed and developed MultiProvider connecting sales, shipping, purchase, inventory, and created reports using BEx.
• Worked with process-chains to automate the Data Loads, Rollups into Aggregates.
• Designed Queries, Reports, Workbooks and assigning them to Roles. Used calculated key figures and restricted key figures Conditions,
• Worked extensively on Extraction from multiple Source Systems - SAP ECC, and Non SAP Systems (Flat Files).
• Worked on Info Set queries for reporting on master data and ODS objects.
• Experience in troubleshooting DataLoads.
• Created a Generic extractor with data capability from a database view.
• Involved in Production Support, DataLoad Monitor, and On Call for users.
• Provided Process documentation, which includes data flow and how to guides end users for post production support.

Environment: SAP version SAP BI 7.0, ECC 6.0, BEx Portal

SAP BW Developer

Confidential

Responsibilities:

• Participated in Data Modeling and development of Multi Dimension Models by consolidating business objects (Info Objects) involved.
• Utilized Business Content and Custom Extractors to extract data from multiple, SAP ECC system modules. Detailed analysis was carried out to identify the matching standard Business content.
• Created Info Objects, Data Sources, Info Sources, Data targets, Info Packages and Info Cubes for standard SAP master (Customers, Materials) and Transactional data (sales order, shipping and billing data sources).
• Extract data from SAP ECC system and flat files.
• Created reports on InfoCubes/DSO objects using BEx Analyzer/Explorer to facilitate data analysis.
• Developed performance-tuning measures for extraction by implementing efficient methods to retrieve the data. Also performance tuned reports through the use of aggregates, statistics, and query design.
• Created Custom reports: Sales Order orders according to sales organization, distribution channels, Sales Billing, Material Management, Shipping labels, Account payable, Account receivable, Purchasing, Inventory and Warehouse related reports etc.
• Defined queries by its rows, columns and free characteristics providing drill down functionality in reporting, report-to-report interface using query jumps.
• Defined queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detail level of information

Environment: SAP version SAP BI 7.0, ECC 6.0, BEx Portal

SAP BW Developer

Confidential

Responsibilities:

• Provided day-to-day SAP BW support.
• Monitoring of Process Chains and analyzing the reasons for frequent failures of info packages.
• Setup periodic PSA data deletions, Checking Reports.
• Reconstruct the data requests from PSA in case of data load failure.
• Maintaining Aggregates, Rollup and Compressed on Info Cubes as part of the Info Cube Management.
• Maintain history for all the tickets until it is closed down.
• Involved in resolving high priority tickets.
• Worked on open tickets related to data load issues and solved them based on priority.
• Installing Business Content, Info Cubes and DSOs and used BC Data sources.
• Created Aggregates and used Line item dimensions to increase the performance of the query.
• Creation of InfoCubes, InfoObjects and DSOs.
• Created R/3 source system on the BW server.
• Scheduling and monitoring data loading.
• Loading of historical data using Flat File (CSV format).
• Performance tuning by compressing the cubes and creating batch indexes
• Loading Master and Transaction data from the flat file.
• Worked on Data Extraction from SAP R/3 using Generic, LO Extractions, Data Loading (Full/Delta Upload), Scheduling & Monitoring
• Working on development of new queries and extractors.
• Creation of queries as per the user requirements and testing

Environment: SAP BI 7.0, ECC 6.0, BEx Portal

SAP BW DEVELOPER

Confidential

Responsibilities:

• Provided day-to-day SAP BW support.
• Monitoring of Process Chains and analyzing the reasons for frequent failures of info packages.
• Setup periodic PSA data deletions, Checking Reports.
• Reconstruct the data requests from PSA in case of data load failure.
• Maintaining Aggregates, Rollup and Compressed on Info Cubes as part of the Info Cube Management.
• Maintain history for all the tickets until it is closed down.
• Involved in resolving high priority tickets.
• Worked on open tickets related to data load issues and solved them based on priority.
• Installing Business Content, Info Cubes and DSOs and used BC Data sources.
• Created Aggregates and used Line item dimensions to increase the performance of the query.
• Creation of InfoCubes, InfoObjects and DSOs.
• Created R/3 source system on the BW server.
• Scheduling and monitoring data loading.
• Loading of historical data using Flat File (CSV format).
• Performance tuning by compressing the cubes and creating batch indexes
• Loading Master and Transaction data from the flat file.
• Worked on Data Extraction from SAP R/3 using Generic, LO Extractions, Data Loading (Full/Delta Upload), Scheduling & Monitoring
• Working on development of new queries and extractors.
• Creation of queries as per the user requirements and testing

Technical Skills: SAP BW 7.0, Microsoft Office (Access, Excel, PowerPoint, Word, Outlook), ERP, Data warehouse, OLTP, OLAP and Legacy system