SUMMARY

• 7 plus years of Total Experience in the IT industry, Experience in SAP BI/BW, BI - BO, ABAP/4 Configuration, Implementation, Support, and Upgrade.
• Implemented 2 full life cycle implementations on SAP BI/BW following ASAP Methodologies, which involves Blue Printing, Realization, Data extraction, Data modeling, data loading, Production Support, Testing, Documentation, Requirement analysis, End User documentation and Reporting.
• Experienced in dimensional and relational data modeling: star schemas, extended star schemas, normalization, de-normalization, Physical database design, relational models, key performance indicators and other OLAP considerations.
• Experienced in SAP BW Net Weaver 2004S/ BI 7.X/3.5/3.1. Expertise in Upgrading to BI 7.0: Extensive experience in Multi Dimensional Data Modeling, Extended Star-Schema, Data Flow Strategy.
• Expertise in the Analysis and Configuration of BW 3.5 and 7.0 in FI/CO, SD and MM modules
• Proficient in Data Modeling, Data Architecture, and good understanding of system architecture.
• Full cycle development experience includes in DW Workbench: Extractors, Info Objects, Data sources, Info Sources, ODS objects, Basic Info Cubes, Transactional Info Cubes, Remote Cubes DTPs, Multi Providers, Info Packages, Update and Transfer Rules, User-Exits, Loading Delta and Full updates, Process chains, Open hub destination etc.
• Experienced in OLTP extractions using LO cockpit and building Generic Extractors, using FI-CO, SD, MM, FI-GL, PP, CRM functions. Experience in loading data using Flat Files and DB connect.
• Good experience in extracting data from SAP & non-SAP systems. Sophisticated skills to work on Flat File Extraction, Generic Data Sources, BI Content Data Sources, Full and Delta Extraction Management.
• Experience in ABAP to write start routines, update/transfer rules and user exits
• Expertise in BEx Analyzer, Query Designer, Web Application Designer, Info-Set queries. Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures.
• Expertise in publishing queries to web portals through Web Analyzer.
• Effective skills to build reports in Business Objects XI 3.1.
• Expertise in Creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Xcelsius Dashboard Components Like Charts, Selectors (Filters, label Based menus), Tabsets, Canvas Containers.
• Expertise in using Universe Designer over BEx queries and Info Cubes to migrate & model data from BI to BO for reporting. Excellent skills to develop reports using WEB I. Valuable knowledge of Crystal Reports.
• Extensively designed Drill Specific Reports.
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, Partitions and Info-Cube Compression techniques.
• Possess a very strong technical foundation with distinctive analytical abilities. Excellent communication skills and Well organized.

TECHNICAL SKILLS:

ERP: SAP ECC 6.0, SAP R/3 4.7

Data Warehousing: SAP BW 3.1/3.5, SAP BI 7.0

Reporting Tools: SAP Business Objects XI 3.0, 3.1, SAP Bex Reporting, Web Apllication Designer, Report Designer, Business Objects Explorer, Xcelsius (Dashboards), and MS Excel.

Functional skills: MM, SD, FI-CO, CO-PA, PP, CRM, SCM, SEM, HR

Environment: Windows 2000/XP/Vista/7, Unix, Mac OS

Languages: C, C++, Java, ABAP/4, SQL

Web technologies: HTML, XML

Application software: Flash, Adobe works, MS-Office Suite, Dreamweaver

Project Management: MS Project, MS Access, MS Visio and MS Excel.

PROFESSIONAL EXPERIENCE:

Confidential, MA

SAP BI/BW Consultant

Environment: SAP ECC 6.0, SAP BI 7.0, FI, SCM-APO ABAP/4, BEx Analyzer, Query Designer, and Web Application Designer

Responsibilities:

• Requirement gathering, design and analysis - Worked with users to identify and advise on existing info structures updated by business events in R/3.
• Identify potential uses and conduct functionality gap-analysis. Identify potential solutions, implement enhancements to existing functionality.
• Extensively worked on Sales, Delivery and Billing Extraction, Loading, Transformation and Reporting.
• Designed and developed the data flow for the Realignment of data for CUSTOMER, DIVISION, DISTRIBUTION CHANNEL, SALES ORG and MATERIAL.
• Developed many start routines, update routine, transfer routines to support Business model and also to improve the performance in ABAP
• Developed many Z- tables like ZREAL C1, ZREAL C2, ZCUSTMAT1… for the process of realignment.
• Extracted data from MM data source 2LIS 03 BF and PP data source 0PP WCCP (work center capacity).
• Activated the Data Source 2LIS 04 P MATNR in the LO cockpit. Extracting the data from MM (Material Management - “2lis 03 BF” data sources), and PP (Production Planning and controlling) modules.
• Worked with different billing datasources like Billing header 2lis 13 vdhdr, Billing item 2lis 13 vditm, Billing condition 2lis 13 vdkon and enhanced according to the business requirements.
• Customized and maintained Data Sources such as Billing (2LIS 13 VDHDR), Sales Order (2LIS 11 VAHDR), and Delivery Order (2LIS 12 VCHDR) for the SD module and Purchasing Order Item (2LIS 02 ITM) for MM.
• Maintaining Reconciliation’s to verify the data in SAP R3 with SAP BW. Extensively checked the missing values in the BW reports in the R/3 transaction and table’s level.
• Designed Technical Documents based on the business requirements in SD, MM and Controlling modules.
• Designed and modeled the data flow for Billing Header, Item and Condition data. Extensive working knowledge with the condition records.
• Created Process chains for the automation of Delta loads for the Billing Header, Item and Condition Records
• Worked extensively in solving the data load issues and also issues regarding the maintenance of process chains.
• Created many complex and customized reports with specific requirements in various modules like SALES OVERVIEW, WEEKLY BUDGET ANALYSIS, MISC WEEKLY BUDGET, and MONTHLY BUDGET ANALYSIS.
• Developed custom BEx queries and workbooks using BEx Analyzer. Published queries in BEx browser using Web Application Designer.
• Developed flexible queries using Filters, Navigational attributes, Variables, Calculated key figures (CKF), Restricted key figures (RKF) in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Defined percentage functions, Mathematical functions for new calculated key figures at both Query and Info cube levels using Formula.
• Defined and activated Hierarchies, hierarchy node and attributes in the characteristic properties for viewing in the workbook.

Confidential, San Francisco, CA

SAP BI/BO Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, FI/CO, SD, SCM 5.0, Business Objects Xi 3.1, BEx Analyzer, and Query Designer.

Responsibilities:

• Involved in the design, development and extraction of the data from R/3 system and flat files in to BW system from SD, PP and MM modules using LO Cockpit extraction methods
• Extensively worked on Modeling, Customize Info Cubes, Info Sources, Multi Providers, Update Rules, and Start Routines, Business Content, Generic data extraction, Data Loading (Full/Delta Up-Load), Scheduling, Monitoring Performance tuning and extracting.
• Extensively worked on Generation of Data sources, activation of Info Sources, Transferring Master Data to Characteristics and Transaction data from ECC systems to Info Cubes in BI. Responsible for loading Master data (Texts, Attributes and Hierarchies)/Transaction data from ECC Data Sources and from Flat Files.
• Regarding Logistics Extraction Cockpit, Maintained extract structures for Sales & Distribution generated data sources & activated the extract structures for the above modules. Scheduled data uploads in cockpit.
• Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL and activated the appropriate Business Content cube.
• Extensively involved in Activating Business Content for Standard Info Cubes, Info Sources & Info Objects of SD and HR-Payroll Modules as per the Client Requirements.
• Activated Info Cubes like Benefits 0PABN C01, Payroll Data 0PY C02 in HCM.
• Designed Transformations and DTPs as per the requirement. Developed ABAP routines and User -exits for this purpose.
• Modified existing queries on various InfoCubes related to SD and HR-Payroll.
• Worked on Enhancements, Reporting, Data Dictionary, BADI and IDOCS in ABAP
• Developed reports on the MM cubes to check the price variance for materials from different vendors.
• Extensively worked on BO XI 3.1 for reporting purposes.
• Involved in Adhoc query development and data mining.
• Extensively worked on Central Management Console (CMC) in configuring BO environment.
• Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Created Universes over BEx queries and Infocubes of SAP BI using Universe Designer
• Extensively worked in Infoview to create Web Intelligence Reports over the Universe Created.
• Created Web I reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Worked in creating Variables, Prompts in web I.
• Worked on Hierarchy Levels and developed hierarchies to support drill down reports.
• Created inventory accuracy Dash Boards (Xcelsius) and for management reports for inventory management and wages and costs report from cost center accounting.

Confidential, Dallas, TX

SAP BI/BO Analyst

Environment: SAP Net weaver 04 (BI 7.0), Business Objects XI 3.1, ECC 6.0, CRM 5.0, MM, SD, BEx Analyzer/ Browser, SD, MM, FI/CO modules, Windows XP, SOL MAN 7.0, SCM 5.0.

Responsibilities:

• Involved in Full Life Cycle Implementation followed by an up-gradation of clients present SAP BW 3.5 to BI 7.0 Net Weaver 2004s and Performanceanalysis.
• Involved in design and strong background on data modeling.
• Designed the New Queries and Modified the Existing Queries (SAP BI 7.0) according to requirements and generated reports.
• Analysis of Reporting Requirements and Translation of these requirements into Multi-Dimensional Data Models using Star-Schema and Extended Star-Schema Data Modeling Techniques, with an emphasis on actual implementation in BI.
• Developed DSO objects to load Sales Order Data from the Data Source. Loaded Transactional Data into PSA and updated Data from PSA to DSO and Activated DSO Data for Reporting and Analysis.
• Interacted with the Management and Business End-Users to identify business requirements and actively involved in implementing ASAP methodology.
• Extensively documented BI Reporting and Data Requirements.
• Extensively involved in Data Extraction from Non-SAP and SAP Systems.
• Participated in Strategic Customer Meetings to review and evaluate new technical challenges that are required to improve operating efficiencies.
• Handled Performance Tuning of queries using Aggregates, Table Partitioning and Indexing of Info Cubes.
• Responsible for customizing and activating the Business Content Objects and loading the data into DSO and Info Cubes.
• Uploaded Master Data and Transactional Data to BI System.
• Used BEX Analyzer to Create Queries with Variables, Filters, Calculated Key Figures, Restricted Key Figures, Exceptions, Conditions with Charts and Worksheets to access data from BI Info Providers to Generate Reports
• Design and developed query based and Info Provider based Universe and WebI Reports.
• Reporting designed and developed using BI query designer.
• Actual and Plan reports developed using WebI and QAAWS.
• Generated Web-I Reports using the Universe as the main Data provider and also using the personal data files provided by the users. Designed Universes for Financial billing system, Order processing and Supply chain planning.
• System design and data model developed in SAP BI 7.0 for Actual and Plan data model developed for reporting in BI and BO reporting.
• Developed dashboards using Xcelsius 2008 and published in intranet portal.
• Xcelsius 2008 installed in client system as well as Development server and Production App server.
• Performance testing developed in all the application servers.
• Backup plan for execution created for the client development and production system.

Confidential, Houston, TX

SAP BW Consultant

Environment: SAP ECC 6.0, SAP BI 7.0, BW 3.5, SD, MM, FI/CO, ABAP/4, Bex Analyzer, Query Designer, Web Application Designer

Responsibilities:

• Involved in the full life cycle implementation of SAP BW
• Involved in the business requirement gathering, system design document, technical specification, functional specifications, development, configuration, reconciliation to Go-live
• Implemented SAP BW for SD, MM and FI/CO modules which involves the designing of data flow from R/3 to BW
• Involved in the full upgrade of BW 3.5 to BI 7.0
• Involved in activating Business Content for Standard InfoObjects, InfoSources, InfoCubes related to Sales & Distribution, Material Management and FI.
• Activation of the Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Special Ledger (SL), Purchasing (MM), Cost Center Accounting (CO-CA) and customizing them as per the client requirement
• Generated report on Business Content Cost Center Planning Cube 0SEM C10 and Sales Planning Cube 0SD C08 for planning and analyzing sales data in BPS created Multi Planning Area, level, Planning Folder, Variables, Planning Area and Package
• Used the Business Content Sales Overview InfoCube 0SD CO3, for overall Sales Analysis. The transaction data is loaded from different Source Systems using the Info Sources 2LlS 01 S260 SalesOrder, 2LlS 01 S261 Delivery, 2LlS 01 S262 for Billing Document and 2LIS 01 S263 for Sales Order/Delivery using LO-Cock Pit.
• Actively involved in Monitoring Data Transfers from Source Systems into BW using PSA
• Worked on accounts payable cubes 0FIAP CO2 and accounts receivable cubes 0FIAR C03
• Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL and activated the appropriate Business Content cube
• Build Transactional and Master Process Chains for periodic upload of data
• Involved in the Performance Tuning of InfoCubes and Query reporting
• Worked with BEx Analyzer to generate Queries and embedding them into Workbooks and also published the queries onto the web using Free Characteristics, RRI-Jump Queries Calculated and Restricted Keyfigures, Filters, Variables and Exceptions
• Extensively used the wizard in WAD and published the reports on Enterprise Portal as iView
• Worked with BEx Broadcaster to schedule monthly sales reports as e-mail to the users

Confidential, Morgantown, WV

SAP BI/BW Consultant

Environment: SAP ECC 6.0, SAP BI 7.0 / BW 3.5, FI/CO, SD, MM, PP, BEx, Web Application Designer

Responsibilities:

• Participated in user meetings to discus project concept, design, and schedule
• Customized InfoCubes for FI-GL, FI-AR, and FI-AP.
• Worked with Sales delivery and customer cubes such as 0SD C05 and 0SD C06
• Implemented FI cubes and ODS objects such as 0FIAR C02, 0FIAR C03, 0FIAP C02, 0FIAR O03, and 0FIAP O03 with proper transfer rules and update rules
• Extended transaction DataSources by appending new data elements using enhancement component RSAP0001 and used the function exit EXIT SAPLRSAP 001
• Involved in the design, development and extraction of the data from R/3 system and flat files in to BW system from SD and MM modules using LO Cockpit extraction methods
• Created queries based on calendar day, week, month, and year to obtain a variety of reports for AR overdue analysis, AR-DSO (Days Sales Outstanding), details of AR line items,
• Overview of Accounts Payable reports, Sales reports, queries contained restricted and calculated key figures, filters, and conditions
• Created ABAP routines for transfer rules and update rules
• Involved in Logistic Information System (LIS) Extraction process, scheduling initial upload and V2 updates through system created transparent tables.
• Created Sales, Delivery, Billing InfoCubes OSD C05 and OSD C03 for sales overview.
• Configured LIS structures for Billing, Delivery and Orders. Filled setup tables, performed initialization and started delta process. Installed business content InfoSources and developed custom ODS Objects and InfoCubes.
• Enhanced transaction data source 2LIS 11 VAHDR, VAITM, 2LIS 13 VDHDR, VDITM.
• Created custom datasources for Service Entry and Purchase Order history information.

Confidential

SAP BW Developer

Environment: SAP R/3 4.6C, SAP BW 3.5, FI-AR, FI-AP and FI-GL, BEx Analyzer, Query Designer

Responsibilities:

• Actively involved in the requirement analysis, data modeling and technical implementation
• Worked extensively in the finance modules like FI-AR (Accounts Receivable), FI-AP (Accounts Payable) and FI-GL (General Ledger).
• Installed Business content for FI-GL, FI-AR and FI-AP business content cubes according to the business requirement
• Created master data InfoSources for uploading attributes, texts and hierarchies
• Experience in loading of transaction data for GL Line item data and AP Line item data
• Extensively worked with GL, AR and AP datasources for extracting and loading of data from FI to BW
• Worked on the enhancement of the business content data sources by using append structures and user exits from transactions SMOD and CMOD
• Experience in modeling and implementation of InfoObjects which include Characteristics, key figures, update/transfer rules, transfer/update routines, planning and implementing init/delta loads for master data and transaction data.
• Created start routines and end routine in transformations to update characteristics and key figures in InfoCubes.
• Created InfoCubes such as 0FIGL C01 for GL line item data and 0FIAP C01 for the AP line item data.
• Created process chains for periodic upload of master data and transactional data and monitored data loads with delta update and full update mechanisms
• Created BEx queries on InfoCubes as per the client requirement