We provide IT Staff Augmentation Services!

Sap Bw Consultant Resume

PA

SUMMARY:

  • Over 8 years of experience in SAP BW 3.x/BI 7.0 indulging in the design, development, implementation and maintenance of the SAP BW/BI Client/Server environment.
  • In depth understanding of SAP R/3 functionality (SD, MM, PP, FI, CO - PA, HR), Standard Business Contents and Data Modeling (star schema, extended star schema, flat structure and multi-dimensional data modeling) in Sap BI/BW.
  • Expertise in all the areas of BI, Data Extraction, Data Modeling, Data Loading (ETL), Performance tuning and Reporting.
  • Actively involved in full end to end implementation project including requirement gathering, design, development, testing, solutions, post production support, documentation and user in SAP BI/BW
  • Experience Data Modeling activities like creation and maintenance of InfoCubes, ODS/DSO, InfoObjects, Multi Providers, Infosets, InfoPackage, Transformations and DTP.
  • Expertise in OLTP extraction from R/3 source systems like LO-Cockpit, LIS, CO-PA, BI Content and from non-SAP systems, Flat files and from Generic Data Sources.
  • Worked on Initialization of Data Sources (Full/Delta Upload), Process chain, scheduling, Monitoring and Error handling.
  • Experience in analyzing BW statistics, Aggregates, Rollup, Compression, Partitioning, and Remodeling.
  • Experience in Automation of BW jobs- Scheduling/Monitoring, Process Chains- Creation and Maintenance.
  • Well versed with SAP BEx Analyzer, BEx Browser, Query Designer, Web Application Designer, Crystal Reports, and BEx Alerts, Web reports, Xcelcius and dashboards.
  • Expertise in creating, organizing, publishing and scheduling reports using CMC and creating BOBJ reports with Charts (Bar chart, Pie chart…etc), cross tabs and sub reports.
  • Able to broadcast reports using Information Broadcaster
  • Documented Test Plans and complete Unit Testing of Developed Objects and Reports.

TECHNICAL SKILLS:

ERP Versions: SAP R/3,4.6b, 4.7, ECC 6.0 .

Net Weaver Versions: SAP- BW 7.3, BI 7.0, BW 3x .

Reporting Tools: BEx Suite, WAD, Business Objects .

Operating Systems: Microsoft Windows XP/Sever 2003/2008/Linux.

Databases: Oracle 9i/10g, MS SQL.

Programming Languages: ABAP, SQL, PL/SQL.

PROFESSIONAL EXPERIENCE:

Confidential, PA

SAP BW Consultant

Environment: ECC 6.0, BI 7.0/BI 7.3

Responsibilities:

  • Participating in the design, development and testing of the SAP BI and Business objects components to support clients' requirements and to integrate these designs into the overall client data strategy.
  • Designed Info cube/ DSO architecture. Created custom data Sources for master and transaction data from legacy system, created ODS objects, cubes and multi-cube, wrote complex transformations, extracted hierarchies and created aggregates, wrote queries
  • Designed, developed and maintained quotation and order management cubes.
  • Activated Business Content Info cubes and Info objects.
  • Scheduled delta queue by using delta method as per requirements.
  • Worked with Delta Update mechanisms for uploading delta records from SAP R/3 to BW at specified intervals
  • Hands on experience on working with LO-Cockpit Extraction.
  • Extracted Sales and Distribution (SD) data using LO Cockpit and customized extractors for sales order and deliveries.
  • Collaborated with basis team to solve any connection issues and released transport request from development server to QA server and then to production server.
  • Worked with basic Start Routines so as to filter the data to the data targets.
  • Worked on ABAP in writing routines for transfer and update rules so as to customize as per requirements.
  • Created interactive and easy to interpret reports by incorporating exemptions and conditions.
  • Uploaded master data including version dependent hierarchies and then worked on this master data for reporting purposes.
  • Designed customized reports and queries for priority customers and cost centers.
  • In order to create single report retrieving data from different queries linked universes and merged dimensions at Web intelligence level.
  • Worked extensively on designing dashboards with BI WAD and dashboards displaying dynamic visibility.
  • Created Interactive Dashboard reports for carrying out analysis of the various aspects of profit and cost centers.

Confidential, OH

SAP BW Consultant

Environment: ECC 6.0, BI 7.0, BO Designer, Xcelcius

Responsibilities:

  • Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Special Ledger (SL) and customized them as per the client requirement.
  • Developed write optimized DSO's for EDW layers and standard DSO for consolidation layers and created direct update DSO's.
  • Developed transformations with start routine, update routine and end routine and involved in the creation and maintenance of DTP and Info Packages for loading data in to data targets.
  • Created generic data sources with Function module extraction method.
  • Experienced in enhancement of the master data and transaction data sources with Z-fields and are populated using User Exits.
  • Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement.
  • Responsible for Configurations in Assets like, Copying Chart of Depreciation, made required settings for account determination, asset classes, screen layout rules, defining number ranges, valuation of assets in different depreciation areas, external asset acquisition, in-house asset acquisition, cross company code transfers, settings for depreciation runs, Asset Explorer, Settings for automatic account assignment ( FI-AA Integration).
  • Configured the controlling area, cost elements, Cost centers (CO-CCA), Number ranges, Cost center hierarchy.
  • Enhanced the business content data sources by appending structures, User Exits and customized delta
  • Worked on Accounts payable cubes and accounts receivable cubes and enhanced the performance (Modeling, Data load) from other systems and did currency conversions for Country specific.
  • Created process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta update and full update mechanisms.
  • Created Aggregates on Info Cubes to improve the query performance.
  • Developed custom BW extractor and to extend BW functionality in BW User exits (ABAP).
  • Created ABAP Start Routines, End routines, Expert routines where ever necessary.
  • Created BEx queries for reporting on InfoCubes, InfoSets, ODS and MultiProvider
  • Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
  • Created BOBJ WEBI reports and crystal reports and deployed them through info view with BW universe as source.
  • Created Business Objects Universes and also enhanced it as and when necessary.
  • Generated month to date and year to date BOBJ reports for MM and FI and monthly distribution reports for Human Resources.
  • Also provided maintenance, support and documentation of Business Objects Universes.
  • Created formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom BOBJ reports.
  • Created exception aggregations, cell editors, formula variables, RFK's and CKF's in the queries.
  • Extensively used WAD and published reports on Enterprise portal as iView
  • Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
  • Created inventory accuracy BOBJ Dash Boards (Xcelcius) and for management reports for inventory management and wages and costs report from cost center accounting
  • Involved in the migration and deployment of the universes and reports across multiple domains.
  • Implemented analytics across the organization and used tabs on company performance via flexible management dashboards and implemented index awareness.

Confidential, FL

SAP BW Consultant

Environment: SAP BI 7.0, BW 3.5, SAP ECC 6.0, SD, MM, ABAP/4, BEx Analyzer.

Responsibilities:

  • 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.
  • Analyzed the Info Cubes and ODS objects to meet the reporting needs of the client.
  • Loading of transaction data to the business content Info Cube from Info Sources like 2LIS 11 VASCL, 2LIS 11VAHDR for sales, 2LIS 13 VDHDR, 2LIS 13 VDITM for billing, 2LIS 12 VCHDR for order.
  • Experience in the creation of the setup tables for the LO Cockpit extraction.
  • Created process chains for periodic upload of the master data as well as the transactional data
  • Involved in the monitoring data transfers from source systems into BW using PSA.
  • Developed reports on the MM cubes to check the price variance for materials from different vendors.
  • Created reports on SD cubes for displaying sales figures and incoming orders.
  • Experience in creating formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
  • Involved in the creation of the dash boards for sales, purchasing and delivery using Web Application Designer.
  • Working expertise in: Storage unit management, Handling unit management, Goods receipt process, Goods issue process, Inbound delivery, Master data in WM/MM, Internal warehouse processes, Monitoring of warehouse activities, Put-away and picking strategies, RF, Physical Inventory processes, SAP standard tables and WM/MM reports.
  • Experience of Materials Management and Warehouse Management.
  • Conceptual design and development of SAP BW-BPS planning applications
  • Concept and development of data models for planning and reporting
  • Integration of reporting and planning applications using SAP BW-BPS.
  • Performance tuning of queries using aggregates, table partitioning, indexing of Info Cubes.
  • Extensively used the wizard in WAD and published the reports on Enterprise Portal as iView.
  • Performed extensive unit testing in the development environment for all the objects created.
  • Worked with the security team in designing the security strategies for global front end reports and workbooks.

Confidential, CO

SAP BW Consultant

Environment: SAP BI 7.0, BW 3.5, SAP ECC 6.0

Responsibilities:

  • Involved in the full life cycle implementation which includes Gap Analysis, design, development, testing, implementation and support.
  • Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multi Providers, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
  • Analyzed business reporting requirements that could be satisfied by Business content Info Cubes for Cost and Allocations.
  • Extensively worked with General ledger, Accounts payable data sources for extraction and loading of data from FI to BW.
  • Created custom Info Cubes and worked on line item dimensions and standard DSOs.
  • Developed Custom data source (Generic data Source) using various HR PA and OM info types based on this project requirements.
  • All the transactional data sources were generic data source built from the info types based on OM and PA requirements.
  • Developed more than eighty reports in both OM and PA. Published them based on the portal.
  • Created and maintained queries containing restricted and calculated key figures, filters, and conditions and structures in BEx and presented in Workbooks.
  • Developed programs to populate reporting customer exit variables.
  • Extensively used formula variables, conditions, exceptions, exception aggregation and Cell editors for developing complex custom reports and dashboards.
  • Created iViews, pages to display BEx/web reports in Enterprise portal 7.0.
  • Involved in assignment and maintenance of Roles and Authorizations to users for BI security.
  • Employed Web Application Designer (WAD) to facilitate the analysis in a drill down or summarized way to give detailed levels of data.
  • Created Crystal BOBJ reports and dash boards using Business Objects Xcelsius.
  • Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
  • Also writing test scripts for the Testing purpose for the Business side people to execute the test cases and help them to detect the defects during the flow.
  • Actively participated in the User Acceptance Test (UAT) Planning once done with ITC phase 3
  • Designed UA Test scenarios and coordinated the UAT team to execute test cases.
  • Created BOBJ WEBI reports and crystal reports and deployed them through info view with BW universe as source.

Confidential, Fort Wayne, IN

SAP BW Consultant

Environment: ECC 6.0, SAP R/3 4.6b, BW 3.0b

Responsibilities:

  • Worked on end-to-end project upgrade and enhancement
  • Migrated 3.0b data sources to BI 7.0
  • Understood and analyzed BW system, and migrated the functionality to BI 7.0.
  • Identified various report requirements for HR Module and prepared Technical and functional documents.
  • Activated Business Content for the areas Personal administration, Payroll and Organizational management.
  • Created process chains to load HR data and merged process chain into Meta chain.
  • Activated Content reports for HR and customized according to user requirements.
  • Creating aggregates by analyzing the Query statistics using RSDDSTAT, RSDDAGGRDEF, RSDDSTATAGGRDIR tables and used RSRT, RSRT2 Tcodes.
  • Improved Longer loading times because of potential buffer replacements of big master data/SID tables by unbuffering big Info objects SID and master data tables in accordance with SAP note
  • 803958. Performance of single record buffers in general was improved and this was in accordance with SAP note 801316.

Confidential

SAP BW Consultant

Environment: ECC 6.0, SAP R/3 4.6b, BW 3.0b

Responsibilities:

  • Coordinated with project teams to define data analysis requirements for projects, identified relevant data tables, extracted data from SAP systems for data analysis.
  • Worked closely with the corporate consultants in providing Functional specifications to enhance the current model and develop new ODS and Info Cubes. Defines custom cubes and Multiproviders for the business scenarios along with aggregates. Defined guidelines to Basis team for Aggregates and data loading.
  • Designed Info Sources, activated transfer and update rules, scripted extraction routines for master data Texts and Hierarchies.
  • The main cubes developed are Customer (0SD C01), Sales Overview (0SD C03), Delivery Service (0SD C04), Purchasing Data (0PUR C01) and Vendor Evaluation (0PUR C02).
  • 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.
  • Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
  • Created Info Packages to do Full, Initial and Delta extraction for both Master and Transaction data with dynamic selection criteria as per the requirement.
  • Used Process Chains to schedule the Info Packages and data transfer processes.
  • Worked with users for defining reporting needs and pre-calculated reports.
  • Used BEx and Web Application Designer, Web templates extensively for publishing, broadcasting of web reports.

Hire Now