We provide IT Staff Augmentation Services!

Sap Bw Consultant Resume

4.00/5 (Submit Your Rating)

GA

SUMMARY

  • 7+ years of SAP experience in BI 7.0/7.3 and BOXI R3 / BO 4.0/4.1 with S.P 2 and 3 indulging in the design, development, implementation and maintenance of the SAP BW/BI Client/Server environment.
  • Involved in 3 full - life cycle implementations of SAP BW projects.
  • Expertise in SAP BW/BI components like InfoCubes, Info Sources, Data Sources, Info Objects, Info Providers, Update rules, Transfer rules, Transformations, DTP in BI 7.0/7.3, Multi Providers, Info Sets, ODS(DSO) objects, OLTP Data Extraction, User Exits, Loading(Full/Delta uploads), Scheduling, Monitoring, Process Chains and Event management, Remote Cubes, Data marts, Open Hub Service and Master Data Management. Sound knowledge of Live Office, QAAWS.
  • Experience in Upgradation of SAP from BW3.5 to BI 7.0/7.3 and migration of components of conceptual design from SAP BW3.5 to BI 7.0/7.3. Maintaining the transformations and DTP’s and in migrating the new and existing queries in both BEx and WAD. Interpreting and writing ABAP routines.
  • Coordinated with Basis team in pre-upgrade and post-upgrade tasks like preparation, Go-Live tasks, clearing delta queues, mass migration of BW transports etc.
  • Well versed with SAP BEx Analyzer, BEx Browser, Query Designer, Web Application Designer, Crystal Reports, and Xcelcius and dashboards.
  • Created WEBI and Crystal reports and deployed them through Info view with BW Universe as source and created dashboards using Xcelcius.
  • Experience in running Queries, Calculated and Restricted Key Figures, Structures, Prompts, Sorted inputs, Drill down, Slice and Dice, Variables, Exceptions, Conditions, Authorizations, workbooks and web templates, User Profile maintenance, InfoSet Query, Jump Analysis using RRI and Web Reporting. Hands on experience in creating and administering BI Accelerator on the high volume cubes.
  • Extensively worked on Performance tuning and optimization techniques with respect to Loading and Querying performance using aggregates, Roll-ups, indexes, Partitions and Infocube Compression techniques, query pre calculation; evaluated statistical performance of OLAP using BW Statistics.
  • Excellent Production Support Skills including Data loads, Reporting related Issues, Archiving, Performance Issues and Data Compression activities.
  • Experience in creating Multi Provider, Multi Cubes and InfoSets as per the query needs.
  • Resolved performance issues by writing stored procedures and command objects in crystal reports.
  • Good Working Knowledge on reports using in Crystal Reports, Crystal Enterprise, Crystal Xcelsius, Business objects universe designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, CMC and Business Objects Enterprise.
  • Experience in designing and developing the Universe and updating the existing Universes, developing canned/ad hoc reports, scheduling the processes and administering the BO activities.
  • Expertise in creating, organizing, publishing and scheduling reports using CMC and creating reports with Charts (Bar chart, Pie chart…etc), cross tabs and sub reports.
  • Excellent production support and debugging skills, experience in resolving trouble tickets, monitoring loads, enhancements, Archiving, Performance, Data Compression activities and change requests.
  • Excellent verbal and written communication skills with strong analytical and problem solving skills.

TECHNICAL SKILLS

  • BI/BW BI 7.0/7.3.
  • SAP ECC 5.0/6.0.
  • SAP Modules FI, SD, MM, PM, HR.
  • SAP BO BO XI 3.x, BO 4.0/4.1, Universe Design Tool, Information designing tool.
  • Query Designer, BEX Analyzer, WAD, Web Intelligence, Dashboard design, Business Objects Explorer, Analysis for Office, Crystal Reports, Xcelsius.
  • Windows 98/XP/2000/7.
  • C, SQL, Basic ABAP.
  • MS Office, MS Visio, MS Power Point.

PROFESSIONAL EXPERIENCE

Confidential, GA

SAP BW Consultant

Responsibilities:

  • Involved in full life cycle implementation, right from requirement gathering, blue printing, development, testing, go-live and post go-live support.
  • Held meetings with business users in order to gather business requirements and prepared business blue print based on those requirements.
  • Worked with functional consultant for mapping the source data (ECC) to target data source in BW.
  • Generated Export Data Sources to transform data from one InfoCube to other InfoCube.
  • Also extracted data from standard data sources such as 2LIS 17 I0ITEM, 2LIS 17 I0NOTIF and 2LIS 17 I0CAUSE as a part of project.
  • Created MTTR(Mean time to repair) and MTBR( Mean time between repair) on Multiprovider.
  • Extensively used BEx analyzer, created queries with variables, filters. Used RRI feature to jump between the queries to analyze the data.
  • Scheduled Daily/Weekly/Monthly data loads.
  • Managed and monitored data loads with full upload and delta mechanism.
  • Created summarized reports which includes display of Plan/Actual variance measures, analysis of full cost by cost center, overdue analysis, and analysis of payment history.
  • Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
  • Extensively involved in the scheduling and monitoring using process chain in Administrative Workbench.
  • Monitored and implemented the solutions to the errors in the Production System.
  • Worked on performance of queries and performed various tuning techniques using Compression, Aggregates and Multiproviders.
  • Developed single and multiple dash boards and score cards using Business Objects.
  • Created Master/detail reports, cross tabs, charts and applied slice and dice, implemented different levels of hierarchies for drill techniques.
  • Involved in designing Universe and creating reports in it
  • Defined BO Classes, Objects in the Universe and defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
  • Enabled dynamic report linking by passing Variables (prompts) between reports.
  • Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.
  • Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them.

Environment: SAP ECC 6.0, SAP BW 7.3, BEx Analyzer, Query Designer, Web Application Designer, BO Designer, WEBI, Xcelcius 2008, SD,MM and PM module.

Confidential, TX

SAP BW Consultant

Responsibilities:

  • Involved in full life cycle of the project in Technical design. Carried out the requirement analysis with users.
  • Carried out end to end testing of interfaces required by the project.
  • Developed and maintained the objects necessary for loading Master and Transactional data staging to PSA, DSO and Info Cubes.
  • Defined and maintained transformations created DTP’s and Infopackage for scheduling the loads to data targets.
  • Created Start routines and End routine in transformations to update characteristics and key figures in the InfoCubes.
  • Performed Remodeling on existing cubes to accommodate new key figures and characteristics.
  • Responsible for loading Master data (Texts, Attributes and Hierarchies) and Transaction data from R/3 Data Sources, Non - SAP systems and from Flat Files.
  • Developed Process chains for Master and Transactional Data. Developed ABAP custom routine which facilitates the selective deletion of the requests in the info cube.
  • Worked on the transformation processes between BW 3.5 and BI 7.3.
  • Designed and developed Reports on multi providers (Chain and DMA) on Plan, target, Plan Vs Target Analysis web reports which are used by end users for actual reporting.
  • Developed reports using BEx Analyzer and BEx Query Designer. Vigorously used Aggregates, Restricted Key Figures & Calculated Key Figures for filtering and formula variables as per the requirement of query.
  • Involved in designing Universe and creating reports in it
  • Defined BO Classes, Objects in the Universe and defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
  • Involved in documentation and involved in End-User training on Post Go-Live maintenance manuals, Web Application Designer, Portals.

Environment: SAP BW (3.5), SAP Net Weaver BI 7.3), SAP R/3 ECC 6.0, BEx Analyzer, WAD, FI/CO, Enterprise Portals, SQL Server, Windows.

Confidential, TX

SAP BW Developer

Responsibilities:

  • Involved in full life cycle of the project in Technical design. Carried out the requirement analysis with users.
  • Designed & Developed custom Datasources, InfoSources, Extractor, InfoCubes and ODS to fulfill user requirements.
  • Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.
  • Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
  • Developed data loading strategies for master data, transactional data and delta uploads.
  • Created process chains for data loading, delta uploading and periodical PSA deletion.
  • Created Multiprovider on sales, delivery and billing cubes to assist reporting on sales, delivery and billing together.
  • Used Filters and Conditions to achieve report functionality.
  • Created group variables for grouping related data.
  • Worked on Creating Aggregates, Compressions, Indexes, multiprovider and parallel setups for data loading to improve performance and utilize data effectively.
  • Created reports using BEx Reports, Workbook, and Queries for the required sales order queries with exceptions, conditional formatting, restricted key figures and calculated key figures.
  • Extensively used BEx analyzer, created queries with variables, filters. Used RRI feature to jump between the queries to analyze the data.
  • Extensively worked on Query Designer and Web application designer to create Queries to perform sales, delivery and billing analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
  • Involved in the designing and Building of Universe, Classes and objects and Implemented Row level security & Object level security.
  • Resolved Universe issues like loops, traps using Contexts, and Aliases.
  • Created Hierarchies, complex objects using various @functions, aliases, contexts, Aggregate objects in the universe.
  • Involved in documentation and end-user training.

Environment: SAP BI 7.0, SAP R/ 3 4.7, business Object designer, SD.

Confidential, AZ

BW Techno Functional Consultant

Responsibilities:

  • Built Custom extractors and Infocubes for FI General Ledger (0FI Gl 4), and Special Purpose Ledger.
  • Created Custom extractors in SD/MM for Billing, Sales Documents, MRP, Goods Movements and Inventory Management.
  • Developed User Exits, and ABAP Routines for GL, Special ledger, Sales Orders, Billing
  • Build Event Chains for running Deltas for Batch jobs.
  • Involved in post Go-Live production support and end user knowledge transfer activities.
  • Activated, Enhanced and extracted data from the Profit Center Accounting using Profit Center line item extractor (0EC PCA 3) .
  • Involved in Business Content Activation, Enhancement of data sources and writing user exits (Master data and transaction data) on R/3 and BW.
  • Worked on the Reporting agent to run the queries in the background for the precalculation of the query results.
  • Worked extensively on the Business Content and Modified/Designed MM, Sales and Financial Info Cubes to meet the End-User Requirements.

Environment: BI 7.0, ECC 6.0, SD, MM, FI, BEx Analyzer, Query Designer, WEB Application Designer.

We'd love your feedback!