SUMMARY:

• 7+years of techno - functional experience (backend and frontend) in SAP BI (Business Intelligence)/BW (Business Information Warehouse).
• Good understanding of ASAP methodology.
• Implemented SAP BI/BW through 2 full lifecycles in multi-industry global deployments.
• Extensive knowledge of BEx Query Designer for developing reports and analysis including restricted key figures, calculated key figures, Structures, Variables, Exceptions and Conditions, RRI, Jump Queries, user entry variables, replacement path variables, customer exit variables, SAP exit variables, and authorization variables, Views, and Work Books,BEx Broadcaster etc, and use of Analyzer and WAD.
• Experience in Business Objects, building universes using both UDT and IDT and Reporting using Dashboards,Web Intelligence (Webi), Webi Rich Client, Crystal Reports,Lumira,Widgetsetc.
• Knowledge in BOBJ upgrade.
• Configuration of BW by identifying the needs of customer, modeling the data, defining the data sources at OLTP and reporting the data by using Administrator Workbenchs business explorer.
• Good understanding of Data Modeling using BW Extended Star Schema.
• Hands-on expertise in all stages of SAP BI/BW rollouts i.e. Data Extraction, Staging and Storage, Transformation, and Presentation.
• Experience in loading (Full /Delta Up-Load) and Monitoring of data.
• Maintenance, Installation and Enhancement of Business Content objects.
• Strong analytical, conceptual and problem solving skills to evaluate complex BW/BI technical and functional problems and apply knowledge to identify appropriate solutions.
• Involved in managing of Infocube, which involves Info cube content, performance issues like Indices, Statistics, partitioning, compression of Infocube and rolling up the data to the aggregates.
• Development / Coordination with offshore development.
• SAP BW on HANA knowledge.
• Prepared to work flexibly to meet changing priorities and deadlines.
• Good team player.

TECHNICAL SKILLS

• SAP BW 3.5
• SAP BI 7.0
• SAP BI 7.3
• R/3
• 4.6c
• 4.7 ECC 5.0
• 6.0
• Netweaver 2004
• BEx Analyzer
• Web Application Designer
• BOBJ 4.x. Modules include: FI
• COPA
• PP
• MM
• WM
• SD etc.

PROFESSIONAL EXPERIENCE:

Confidential, TX

SAP BI/BW Consultant

Responsibilities:

• Checked PSA for errors involving invalid characters.
• Enhanced the different Transactional DataSources with new fields and added functionality to populate them.
• Modeling, building and customizing InfoCubes, DSO, Info Objects, Infosets and Multi Providers as per the functional specifications.
• Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2.
• Included the newly created DTPs in the Process Chain for that automatic scheduling of data loads.
• Production support, which involves daily monitoring of data loads via process chains, trouble shooting and correcting the known errors and escalating the unknown to the SAP support team.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Interacting with different teams for the delay of schedule loads and re-schedule the loads when the file is arrived by control team.
• Building universes and reports using BO Dashboards, Crystal, and WEBI, Analysis,-based on business requirements.
• Prepare and run daily, weekly, and monthly Business Warehouse reports, validate report accuracy, troubleshoot issues as required, deliver reports to required resources on time.
• Understanding of database principles, multi-dimensional design & analysis.

Environment: SAP BI 7.0,SAP BI 7.3, ECC 6.0, BEx Analyzer, Web Application Designer, BOBJ 4.x. Modules Implemented in BI: SD, MM, FI/CO, WM.

Confidential, NC.

SAP BI Analyst/Developer

• Worked in functional areas FI-AR, FI-AP, FI-GL and Logistics (SD&MM) for backend development and front end reports.
• Implemented CO-PA (Costing and Accounting Profitability Analysis)and Inventory Valuation.
• Understanding of database principles, multi-dimensional design & analysis.
• Application areas included Purchasing, Sales and Distribution, and Inventory Management.
• Implemented query performance techniques including usage of aggregates and indexes to improve query response time.
• Understanding the client requirements and project functionality.
• Prepared technical documentation as per deliverables and Interacted with users for gathering information on reporting requirements.
• Translating functional business requirements into technical reporting designs.
• Involved in Creation of DSO Objects and also worked with various options, which involves activating data in DSO and also updating the data in DSO to subsequent data targets.
• Involved in maintaining Multi-Providers for Purchasing Data and Sales Overview.
• Included the newly created DTPs in the Process Chain for that automatic scheduling of data loads.
• Used generic extraction (RSO2) to extract data from SAP R/3 to BW.
• Designed complex queries for Account Ledger using variables, calculated key figures, filters and conditions, Exceptional Aggregations.Used Report Designer tool for formatting queries.
• Validated all the variables, formulas, text variables, restricted and calculated key figures, custom exits.
• Involved in building the Business objects reports using SAP BW as well as non-SAP as backend.
• Create BO reports, Crystal, XCelsius/Dashboards and WEBI, Analysis,-based on business requirements.
• Creating SD, MM and FICO Bex reports and run in Bex Analyzer saving as work books by using excel formulas.
• Involved in Creation of Reports such that the execution time is evenly distributed throughout the Report using Restricted Key Figures, Calculated Key Figures, Variables, Exceptions & Conditions and Structures.

Environment: SAP Netweaver 2004s, SAP BI 7.3, ECC 6.0.

Confidential, Mexico City

SAP BI Analyst

• Involved in a fresh BW implementation.
• Activated all datasources in RSA5 and checked extractors in RSA6 and then RSA3
• Documented short dumps and faulty extractors.
• Created many custom InfoObjects documented to satisfy requirements for connectivity with Legacy systems.
• Activated Master Data objects.
• Performed and documented unit testing for all objects in Sandbox and development system.Took screen shots and documented all unit testing required.
• Created Infopackages in Development system and tested new InfoObjects data loads
• Checked PSA for errors involving invalid characters.
• Enhanced the different Transactional DataSources with new fields and added functionality to populate them.
• Modeling, building and customizing InfoCubes, ODS, Info Objects, Infosets andMultiProviders as per the functional specifications.
• Involved in Installing Business Content for Standard InfoObjects, InfoSources, InfoCubes related to Sales & Distribution, Material Management and Finance.
• Used the Business Content Sales Overview InfoCube 0SD CO3, for overall Sales Analysis.
• Developed simple Routines in Update rules and Transfer Rules for the key figures of InfoCube Purchase Data 0PUR CO1. InfoCube was used for Analyses of Material groups, Vendors, and Materials.
• Monitored data extraction and created queries based on client’s requirement.
• Performance Tuning of queries and data uploads: OLAP Caching, Aggregation and Compression.
• Implemented BW statistics to monitor BW system performance.
• Liaised with SAP Basis Team regarding BW Transport requests.
• Worked extensively in creating reports like Balance Sheet, P&L, Cash, Gross Margin, Monthly Sales, Open Orders, Back Orders, Overdue, Daily Sales Reports, Payment History, etc. using structures, formulas and Cell definitions.
• Worked with BEx Analyzer to generate Queries and embedding them into Workbooks.
• Configured BEx Queries for Free Characteristics, Calculated and Restricted Key Figures, Filters, Variables and Exceptions.
• Worked on WAD, Crystal and Dashboards for building queries and workbooks by providing quality documentation generated reports requested or required by client and management.
• Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting.

Environment: SAP BW 3.5, SAP R/3, BEx Analyzer, Query designer.

Confidential, Kansas

BW Developer

• Worked in functional areas FI-AR, FI-AP, FI-GL and Logistics (SD&MM) for backend development and front end reports.
• Installed standard FI-GL, FI-AP, and FI-AR from business content. Developed ODS and Cubes based on the data sources 0FI GL 4, 0FI AR 4, 0FI AP 4, HR.
• Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2. Used generic extraction (RSO2) to extract data from SAP R/3 to BW.
• Designed custom InfoCubes for company wide Sales, delivery, billing with various aggregate periods, Designed Multi-Cube based on Sales, Delivery, Billing cubes.
• Worked with Flat File Interface in loading corresponding Master Data Order / Delivery, Extracted data from flat files for Master data and Transactional data.
• Mapped R/3 fields to BW InfoObjects in transfer structure during the creation of transfer rules.
• Created Info-Packages and scheduled night jobs to runusing the BW scheduler and handling Process Chains,and monitoring and error handling.
• Included the newly created DTPs in the Process Chain for that automatic scheduling of data loads.
• Created communication structure and Info-Sources, creating update rulesusingdifferent options (source Info-Object mapping, constants, routines, automatic master data read).
• Designed and created several Queries using BEx Analyzer, with drill down functions, calculated key figures using formulas and variables.
• Optimized load performance and query performance.
• Translated new requirements into Functional Design and relayed information to team members.
• Involved in the requirement analysis meetings and was solely responsible for developingtechnical and functional specifications.
• Had series of meetings with business users to understand new requirement that needed urgent attention.
• Created several web reports with editing charts, tables, templates and style sheets.
• Worked with severa lpre-calculated web templates.
• Extensively used Bex analyzer to create queries and work books.

Environment: SAP Netweaver 2004s, ECC 6.0, Modules Implemented in BI: SD, MM, FI/CO, WM.

Confidential, California

SAP BI/BW Consultant

• Involved in complete life cycle implementation of SAP BW using ASAP methodology as a team member, converting Functional Specifications into Technical Specifications and then to realization.
• Analyzed the requirements and identified the suitable business content for SD, FI/CO and had the standard infocubes, ODS’s, Multicubes and various other relevant objects installed and activated.
• Used full features of BI 7.0 (DTP, Transformations, and DSO).
• Developed BW Queries, Testing and transporting through landscape.
• Extensive work on translation keys & Function modules for (ODS) to do Currency conversions.
• Involved in testing extractors, data loads and reports before transporting into production.
• Enhanced extract structures by adding new fields and populating them with the user/function exits in CMOD.
• Created the processchains to automate the data loads for transaction, master, text, hierarchies, currency exchange rate tables.
• Performed standard, application specific and generic extractions such as LO Cockpitand FI/GL extractions.
• Extensively worked with PSA in Monitoring the Data Transfer from Source Systems into BW.
• Extensive work on Design & Development of Custom Cubes, DSO/ODS Objects, Multiproviders and Infosets; Enhancements on Accounts Receivables (AR) cube 0FIAR CO2.
• Delta Management.
• Modeled Data targets according to the reporting requirements.
• Performance Optimization by Tailoring Transfer Structures, Communication Structures, and Update Rules using routines and Start Routines.
• Developed various FI/CO and SD reports such as DSO Analysis Current Period, Days overdue Analysis, Customer Sales Trend, Actual Contribution margin in Sales, Incoming Orders Analysis and Product Profitability Analysis in SD.
• Worked with SAP Open Hub service for sending the data from BW to External Systems.

Environment: SAP BI 7.0, FI, MM, SD, SAPNetweaver 2004s.