SUMMARY

• 7+ years of experience in SAP Business Intelligence & Business Objects environment.
• Involved in multiple full life cycle SAP BW implementations which includes Data modeling, Data extraction and Reporting.
• Experienced with ASAP methodology, including project preparation, gathering requirement, business blue print, realization, post user support and end user documentation and training under deadlines. Extensive experience in business processes across the following modules: FICO, MM, SD, SEM, HR.
• Expertise in all phases of BW implementation - Data Analysis, Data Modeling, Data Extraction/Uploading and Reporting.
• Worked on Universe design, WebI, Crystal reports and Xcelsius Dashboards.
• Good experience in extracting data from SAP & non-SAP systems. Sophisticated skills to work on Flat File Extraction, Generic DataSources, BI Content DataSources, Full, Initial and Delta Extraction Management. Working with SAP Netweaver2004s (BI 7.0) and extensively used DTP’s & Transformations.
• Exhaustive analysis of business content at the project Blueprint level.
• Worked with complex multi-dimensional data models, including InfoCubes, DSOs and MultiProviders, Master Data, InfoObjects, InfoSources, transformations, process chains and batch scheduling. Creating & Enhancements upon requirements on components like InfoCubes, InfoObjects and InfoPackages.
• Worked on transformations using routines like Start routine, End routine and Field routines.
• Strong knowledge on Open Hub service.
• Improved data load and query performance by using BI Accelerator (BIA).
• Worked on Front-end environment: Business Explorer (BEx), BEx Analyzer, Creating queries, Workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, RRI, Ad-hoc Queries and WAD.
• Worked with various kinds of performance tuning techniques such as Indexing, aggregates, Rollup, Line Item, Partitions and Infocube compression techniques.
• Good understanding of Portal security roles (Enterprise Portal), Information Broadcasting, and publishing reports on the web.
• Expertise in Unit testing, Integration testing and user Acceptance testing.
• Strong Problem Solving and Analytical skills and abilities to make Balanced & Independent Decisions.
• Good Team Player, Strong Interpersonal, Organizational and Communication skills combined with Self-Motivation, Initiative and Project Management Attributes.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

SAP Consultant - SAP BI

Responsibilities:

• Responsible for requirements gathering working with the functional teams and developed the Functional & Technical Specification documents.
• Worked with the Customization of the Infocube, InfoSets, DSO, MultiProvider and Info Objects as per requirements.
• Worked with the Data model Design & Development for the BI-HCM reporting requirements to develop a Reporting Solution.
• Worked extensively with BW for Modeling, Monitoring, Scheduling DTP/Info package and Process chains.
• Brain storming sessions for Data Modeling the HR Solution for NS working with the Onsite & Offshore teams.
• Worked extensively with ECC - HCM Modules - PA, OM, PD, LSO, CM, BN, PY, ERC and historical data.
• Activated the Business Content and Data Sources into 7.x/3.x version and also performed the Data Source Migrations, Mappings and Transformations.
• Worked with performance aspects during Design of the Data Model and also for Reports to improve runtime.
• Worked with the offshore team by providing the Logic/ Specification documentation as inputs in the development of the BADI’s, user exits for BEX variables (Customer Exit), BEX reports, BI backend development and documentation.
• Worked with the Implementation of the BI-HCM security with security teams and Business.
• Extensively worked with BEX reporting for most of the modules within HCM.
• Training the Power Users about the BEX/BI.
• Worked with the defects, validation and providing knowledge transfer to users on various aspects.

Environment: SAP BI 7.0 and ECC 5.0 MM, SD, FI, HCM.

Confidential, Greensboro, NC

SAP BI Consultant

Responsibilities:

• Responsible for creating the Queries based on the user requirements.
• Customized and maintained Datasources for the SD module and Purchasing Order Item (2LIS 02 ITM) for MM.
• Developed reports using query designer, BEx analyzer and web application designer.
• Used “Queued Delta” method to extract the delta records of MM and SD application.
• Extensively worked in generating reports on Finance Invoices and MM Invoices. Worked on Finance Data Extractors 0FI AR 03 and 0FI AP 03 and loaded data into data targets.
• Developed reports on Profit and Loss account, Income statement and Balance Sheet. Created Variable Exits to show the Invoicing amount of the respecting periods.
• Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of Info Packages and these Process chains are scheduled for periodic loads.
• Worked on BI 7.0 testing, Involved in postproduction support activities in monitoring the daily data loads, fix report issues, and reconciliation issues.
• Expertise in creation of BEx Queries, Workbooks, structures, variables, calculated key figures, restricted key figures and RRI reporting.
• Extensively worked on Creating Dashboards & Web Reports Using Web items Like Tables, charts, Drop down Box, Radio button Check Group, Label, Filter and Text Elements.

Environment: SAP ECC 6.0, SAP BI 7.0, SD, MM and FI/CO modules, Windows 2000/NT.

Confidential, Rancho Cordova, CA

SAP BW/BI Developer

Responsibilities:

• Responsible for the development, support & maintenance of SAP BI/BW version 7.0 connected to ECC 6.0 system.
• BW/BI developer will be responsible for analysis, design, and development of SAP BW backend components and front end reports and dashboards.
• Interaction with business personnel and users for gathering business requirements & identifying standard business content including preparing a plan for custom info cubes.
• Developed enhancements, InfoObjects, InfoCubes, DSO, Queries, Multi Providers and Custom Multi providers in BW implementation phases.
• Created and unit tested BW internal objects (InfoObjects, ODS, InfoCubes) in MM, SD modules.
• Developed custom defined Infocube and DSO like ZPUR T01 and ZPUR C01 for purchasing cost history.
• Worked extensively on LO structures for extracting sales order, delivery, billing and purchase information.
• Worked on data enhancements for the extractor programs of LO Cockpit data sources.
• Involved in Modeling/Designing and implementing data warehouse solutions using SAP BI 7.0 using with SAP ECC for Materiel Management.
• Worked with transformations routines like Start routine, End routine and Characteristic routine.
• Created and maintained Process chains to automate data loads.
• Worked with Query designer to develop query using structures, formulas, selections, calculated key figures and restricted key figures.
• Worked with Business Objects XI 3.1 Enterprise Suite (Desktop Intelligence, Web Intelligence and Dashboard Manager)
• Worked In creating Variables, Prompts in WebI.
• Filters and conditions were applied to the query to have different views of the same query.
• Worked with different variable processing types like Manual Input, Replacement path, custom variables like User Exit.
• Involved in Unit Testing, Integration testing & User Acceptance testing.
• Monitoring and implementing the solutions to the errors in the Production System.

Environment: SAP ECC 6.0, SAP BW 3.5, 7.0, B.O, ABAP/4, FI/CO, PM, MM/SRM.

Confidential, Hagerstown, MD

SAP Consultant - BI/BW

Responsibilities:

• Conducted Requirements Gathering interviews and workshops with end users.
• Mapping of Data elements, Data dictionary, Design of ODS, InfoCube, and Multi Providers.
• Definition of key figures and characteristics. Some areas are for FI (AR,AP,GL).
• Used BW Standard and Generic Extractors to fetch the data from ECC to BW.
• Developed and modified InfoObjects, InfoCubes, ODS Objects, DTP, Transformations, to suit the business requirements.
• Involved in the development of Infocubes for FI, FI-GL, FI-SL, CO-PA.
• Implemented complex update rules and transfer rules. R/3 User exits for transactional and master data attributes.
• Worked on data modeling. Worked on Infocubes such as 0FIAP C02 (Account Payable), 0FIAP C03 (Account Payable Line items), 0FIAR C02 (Account Receivables), 0FIAR C03 (Account Receivables Line Items), 0FIAR C05 (Account Receivables Payment history) and developed custom Infoproviders and ODS objects required for MIS to analyze data in decision making.
• Migration of DataSources from 3.x to BI 7.0.
• Involved in creating update rules and start routine. Designed and developed technical architectural solution.
• Involved in creating MultiCubes, Infosets based on the requirements.

Environment: SAP BW 3.X, 7.0, SAP ECC 5.0, Bex Analyzer, Bex, ABAP4, FI, CO.

Confidential, Chicago, IL

SAP BW Consultant

Responsibilities:

• Heavily involved in customizing and activating standard delivered BW business contents in the areas of Sales and Distribution, Profitability Analysis, Account Receivable and Account Payable.
• Worked with CO-PA and Standard Business Content Cubes for accounting reports on Cost-Center and Profit Center.
• Developed InfoCube, MultiCube, ODSs, define DataSource and load R/3 data using extractors for Sales Order, Sales document, Billing, Delivery, Materials, Purchasing, Orders, Customers, General Ledger, Account Receivable.
• Scheduled and monitored Daily/Weekly/Monthly data loads to InfoCubes and ODS-objects through process chains. Involved in setting up on Full and Delta Loads for SD Business Content and Custom Data.
• Widespread use of ABAP/4 programming skills for numerous enhancements, Start routines, Update rules and Transfer rules.
• Extended IDocs and programmed user-exits to populate the outbound delivery, inbound shipping IDocs and posting, as well as triggering outbound shipping notification IDocs to legacy systems where appropriate.
• Created Multi-Providers to extract data from Multiple Data Targets for providing information to the queries for Sales/Billing Reporting.
• Modified the User exit programs to accommodate the additional fields in the extract structure of the DataSource with ABAP.
• Advised delta loading and ODS Loading process. Performed Delta repairs whenever required.

Environment: SAP R/3 4.6C, ABAP/4,SD,FI/CO Modules.

Confidential

SAP BW Consultant

Responsibilities:

• Resolved various BW query performance and load performance to support the implementation.
• Designed and configured Process Chains for entire BI load Process and implemented email notification of load progress.
• Actively involved in preparing user and technical documentations.
• Gathered and Mapped Sales Order Item attributes for BW reporting purpose.
• Designed and developed/created InfoCubes, ODSs and IP.
• Activated necessary Standard Business Contents and used the required standard queries.
• Enhanced the Extractors to suit the requirements.
• Defined target currency in info objects and determine Target Currency for currency conversion from InfoObject.
• Worked on Multi Currency Translation in BEx.
• Loaded Master and Transaction Data. Handled full, init and Delta loading.
• Worked with BEx Tool to design and develop Queries and Reports.
• Developed highly customized analytical reports with Business Explorer (BEx) Analyzer.
• Developed custom queries for user specifications.
• Created variables and associated user exits to assign the default values such as sales organization and purchase organization.

Environment: SAP R/3 4.0b, ABAP/4, FI,SD and Oracle.