We provide IT Staff Augmentation Services!

Sap Bi Consultant Resume

TX

PROFESSIONAL SUMMARY:

  • Over 7+ years in SAPBI/BWTechnical experience with releases up to SAP Net Weaver BW7.3/ NW2004s and SAP BO 4.0.
  • Strong experience in various phases of a project including analysis, blueprinting, design, development, configuration, testing, as well as documentation, and end-user training.
  • Performed all phases of Project Life Cycle in modules like Supply Chain (SD, MM, and IM, PM), HR-PY, HR-TM (Time Management), HR-PD, Finance (AR, AP, and GL)and CO-PA, CRM in multiple projects.
  • Strong Experience in SAP methodologies, Project Plan, Modeling (Star Schema, Multi Dimensional).
  • Expertise in all aspects of BI/BW : BI data modeling, data staging and Activating & Enhancing standard Business Content, InfoObjects, Hierarchies ,DSO, InfoCubes(non Cumulative), MultiCubes, Datasources (3.x & 2004s), Infosources (3.x & 2004s), Infospokes & OpenHub, Transformations and Data Transfer Processing (DTP), Master Data(Time dependent and Time independent)Features like Remodeling & Repartitioning, Administration, Scheduling, Process Chains, Performance Tuning with Aggregates, Infocube Partitioning & Compression, OLAP Cache, secondary Indices, Pre-calculations etc.
  • Excellent experience in Data Extraction (ETL): Activating & Enhancing the standard Datasources with structural changes & User Exits with complex ABAP coding, Lo-Cockpit, Generic Datasources with Tables/Views/Function Modules in releases up to ECC 6.0. Extracted Data from Flat files.
  • Hands on experience in Testing - Master/Transaction data testing in BW and handled Reconciliation with R/3 Data.
  • Universes are created over BEx queries and Info cubes using Universe Designer.
  • Working experience in Business objects (Universe, WEBI) and created dashboards using Xcelsius.
  • Excellent verbal and communication skills, has clear understanding of business procedures, adapt new environment quickly, Team building, Leadership and Project Management Skills.

TECHNICAL SKILLS:

SAP(R/3 & BW/BI): BW 7.3/3.5/3.1/3.0, R/3,ECC6.0/5.0/4.7/4.6c,SD,MM,HR,WM,APO,CRM.
OLAP/Reporting Tools: BO 4.0, Designer, Web-Intelligence, Desktop-Intelligence.
Data Modeling: Star Schema, Extended Star Schema.
Operating Systems: Windows 7/Vista/XP/98/2000.

PROFESSIONAL EXPERIENCE:

Client: Confidential, Tx Sep 2011 to Present
Role: SAP BI Consultant

Responsibilities:

  • Involved in complete life cycle implementation of SAP BW in SD, MM, and FI modules
  • Worked with several users, and interacted with them to gather requirements and transformed them into a data model with the concept of extended star schema.
  • Reviewing the Functional Specifications and Building Technical Specifications.
  • Created generic extraction by using View to extract data from SAP R/3 to BW.
  • Extensively worked on enhancing the standard data sources and generic data sources as per client requirement.
  • Extensively involved in setting up procedures for extracting the data from sap R/3 by using LO-Cockpit extractions and used initialization with delta update and full update.
  • Created custom InfoObjects, DSO, InfoCubes,Multiproviders, InfoPackages and DTP.
  • Used DTP's and loaded data to the InfoProvider through InfoPackages.
  • Enhanced the standard and generic data sources 0FI_GL_4 and ZBW_INVENTORY.
  • Created Queries based on SD, MM modules like Month of Supply Report, Ship Detail Report based on Fiscal year period.
  • Enhanced standard data sources, customized start routines and end routines.
  • Designed and activated process chain at various levels with varied processes which involves scheduling data in Info Packages, Reading data from PSA and updating corresponding data targets, Activating DSO data from data load, Deleting / Generating Indexes, Deleting requests.
  • Monitoring process chains and fixing data load issues.
  • Maintained Reconciliation's to verify the data in SAP R3 and SAP BW.
  • Maintained Aggregates, Rollup and compressed InfoCubes to improve the query performance.
  • Analyze the failed data loads and fixed the data loads.
  • Used CONVERT_TO_LOCAL_CURRENCY, CONVERT_TO_GLOBAL_CURRENCY, FIRST_DAY_IN_PERIOD_GET etc functional modules.
  • Enhanced process chains for master data attribute, text and hierarchies.
  • Enhanced standard data source for master data attribute and transaction data.
  • Created BEx reports using Query Designer by using free characteristics, Restricted Key Figures, filters, Calculated Key Figures, Variables, Conditions and Exceptions.
  • Scheduling Process Chains and monitoring the background jobs.
  • Worked on BEx reporting, Data modeling and Extraction.
  • Worked on analyzing data model, and BI indexes to improve the performance of the Bexqueries.
  • Solved a number of tickets which were found in production.
  • Worked on production support issues like manual data reloads as required, Front end issues in Reports and updating day-to-day activities by working with on-site team.

Environment: SAP BW BI 7.2, SAP R/3 ECC 6.0.

Client: Confidential, OH Jul 2010 to Aug 2011
Role: SAP BI Developer

Responsibilities:

  • Created generic extraction by using View to extract data from SAP R/3 to BW.
  • Extensively worked on enhancing the standard data sources as per client requirement.
  • Activated and utilized the business content according to the functional requirements.
  • Extensively involved in setting up procedures for extracting the data from sap R/3 by using LO-Cockpit extractions and used initialization with delta update and full update.
  • Created custom InfoCube, DSO, Multiprovider, InfoSet, InfoObjects and DTP.
  • Enhanced the data sources 2LIS_02_HDR and 2LIS_02_ITM.
  • Involved in creation of reports using BEX Analyzer by using free characteristics, Restricted Key Figures, filters, Calculated Key Figures, Variables, and Exceptions.
  • Enhanced standard data sources, customized start routines and end routines.
  • Monitoring process chains and fixing data load issues.
  • Involved in resolving the Tickets (Incident & change request).
  • Maintained Reconciliation's to verify the data in SAP R3 and SAP BW.
  • Maintained Aggregates, Rollup and compressed InfoCubes to improve the query performance.
  • Analyze the failed data loads and fixed the data loads.
  • Enhanced process chains for master data attribute, text and hierarchies.
  • Enhanced data source 2LIS_03_BF (Inventory: Material Movements)
  • Enhanced standard data source for master data attribute and transaction data.
  • Worked on analyzing datamodel, and BIA indexes to improve the performance of the Bexqueries.
  • Involved in resolving the Tickets like SR, MR & CR.
  • Scheduling and Monitoring background jobs and coordinating with on-site team lead and updating day-to-day activities.
  • Transported objects to QA and production.
  • Responsibilities include configuration, business process design, reporting design, testing and training.

Environment: SAP BW BI 7.0, SAP R/3 ECC 6.0.

Client: Confidential, MI Jun 2009 to May 2010
Role: SAP BI Consultant
Responsibilities:

  • Involved in Enterprise Planning, Budgeting, Consolidation, and Strategy and implementation process finalization.
  • Gathered Business Requirements from Users & Business Analysts for data modeling, identified the gaps and suggested necessary enhancements for transaction data and master data extractors.
  • Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA),General Ledger (GL), Purchasing (MM), Cost Center Accounting (CO-CA) and customized them as per the client requirement.
  • Created Generic extractors using Table/View and Infoset queries to satisfy multitude user requirements and maintain availability of specific data for reporting purposes.
  • Extracted Master and Transaction Data from Flat files and loaded into InfoObjects, DSOs and InfoCubes and developed many complex Start Routines and End Routines to meet business logic.
  • Extensively worked on customdata source enhancement, and used user exits to populate data & customized delta built up for the data sources.
  • Installed SAP BI standard business content InfoCubes for FI/CO, SD and HR and modified them to meet the Global Business Requirements and User needs.
  • Created Process Chains for automation of data load and data target administration and monitored the processes.
  • Used Open Hub Destination to store data from SAP BI to local databases for ad-hoc reporting purpose of ERP super users.
  • Created FI reports like GL Balance display, FI Actual/Planned Comparison, AR Payment history, AR Overdue analysis.
  • Worked on complex reporting requirements for BPC and BI applications to design end-to-end reporting solutions for optimal performance.
  • Customized the reports, Input Schedules, Logic to meet the specific needs of the client using supported functions as BADI's with BPC.
  • Extensively worked on BI reporting using BEx Analyzer, BEx Query Designer, BEx Broadcaster using Calculated Key Figures, Restricted Key Figures, Structures, Variables, Aggregations, Exceptions, Conditions and Customer Exits for calculating the YTD and MTD Values.
  • Worked with Business users on regression testing the Monthly and Quarterly reports and fixing the issues occurred with a team of developers.
  • Planned the cut over activities before go live and performed the downtime activities.
  • Worked on production support issues like data reloads as required, fixing bugs etc.; resolved issues connected with running the query.

Environment: SAP BI 7.0, SAP ECC 6.0, Business Objects 3.1, BEx Analyzer, ABAP/4, FI/CO, SD

Client: Confidential, Harrisburg, PA Oct 2008 to Apr 2009
Role: SAP BW/BI Developer

Responsibilities:

  • Worked on extracting the data to BW for S & OP report.
  • Involved in requirement gathering. Prepared a designed documents and data model for S & OP projects including Test Cases.
  • Designed Info Objects based on business requirements and built InfoObject and prepared InfoObjects design Documents.
  • Designed/Built InfoCubes, Multicubes and prepared InfoCube, Multicube Design Documents.
  • Developed a start routine and transfer rule for unit of conversion.
  • Worked on BW performance and Tuning project (Query).
  • Worked extensively on creating BEx Queries. Improved performance tuning
  • Improved loading performance by carrying out number range buffering, deleting secondary index, run Stats on Cubes/ODS using transaction DB20 and Database level.
  • Improved query performance by creating Aggregates, secondary Index.
  • Support post-production maintenance functions and documentation.
  • Transported objects to QA and production.
  • Responsibilities include configuration, business process design, reporting design, testing and training.

Environment: SAP BI 7.0, SAP R/3 ECC 6.0 FI/CO, SD, MM.

Client: Confidential, MI Mar 2008 to Sep 2008
Role: SAP BW Technical consultant

Responsibilities:

  • Involved in all phases of ASAP methodologies, project planning, Business Blue printing, Realization, Final Preparations, Go-Live and Support.
  • Analysis of data requirements and translation of these requirements into dimensional data models using star-schema and extended star-schema data modeling techniques, with an emphasis on actual implementation in BW.
  • Created InfoObjects, DataSources, InfoSources, Data targets, InfoPackages and InfoCubes to load Master and Transactional data from SAP R/3 system into BW system.
  • Developed Transfer Rules to extract data from various DataSources into transfer Structures.
  • Created, Maintained and modified existing queries on different InfoCubes related to SD, MM and FI/CO modules. Extensively worked on Query building, filtering data, variables.
  • Extensive use of process chain to automate loading all master and transaction data
  • Generated reports like Plan/Actual comparison, Open Sales Orders and Incoming Sales orders using Sales Planning.
  • Developed a custom Infocubes for material movement (quantity and value) like Goods receipts, returns and consignment stocks (vendor managed inventories and customer managed inventories) based on plant, storage location, material, material group, vendor and customer.
  • Designed and implemented a reporting solution for web reporting, information broadcasting, pre-calculated web templates and background scheduling.
  • Redesigned and indexed existing info cubes and ODS for better performance of the data loads and reporting.
  • Created Aggregates on the info cubes and compressed them to improve the report execution time.
  • Created documentation and implemented necessary authorizations and securities for the end user reports.
  • Worked on the creation of roles, Custom authorization objects on hierarchies.
  • Error Debugging and rectification, solving issues, problems faced during data uploads.
  • Involved actively in supporting the various issues addressed by the Users from the client side and providing them with required solutions.
Environment: SAP R/3, SD, FI/CO, MM, BW 3.X.

Client: Confidential, NJ Aug 2007 to Feb 2008
Role: SAP BW Consultant

Responsibilities:

Data Modeling, Extraction:

  • Worked for Evaluation Phase - To- Processes the Business Requirements with high-level process flows and process descriptions for the Roll Out, from requirement analysis, blue print, realization to post go live support
  • Requirement Analysis for key operational reports and management reporting, identification of potential gap information
  • Involved in creating the Business Blueprint documentation.
  • Created Process chains to automate the load schedule. Extracted data from ECC & Flat files.

Reporting:

  • Designed queries on Sales and Distribution, Finance, Material Management.
  • Created billing and history, credits raised, general refund, bad dept, customer invoices Split by material, state level pick and delivery reports, quote to cash.
  • Created Web templates for queries using Web Application Designer
  • Data loads (daily, weekly and monthly) using dedicated Process chains
  • Created authorization objects for reporting.
Environment: SAP BW 3.X, SD, FI-CO, SAP R/3 4.7, Business explorer, Web Application Designer.

Client: Confidential, India Apr 2006 to Jul 2007
Role: JUNIOR SAP BI Consultant
Responsibilities:

  • Involved in requirement analysis, modeling, Business Content Activation, Front-end design, data load scheduling.
  • Involved in extraction, configuration and construction of Data targets.
  • Created number of Reports with various filters, formulas and restrictions and variables
  • Enhanced the DataSources & InfoSources for additional business requirements, used Customer Exit Variables, Formulas and Filters for the client business requirement.
  • Extensively involved in debugging many ABAP report.
  • Involved in Query Definition, Query Presentation - BEx Analyzer.
  • Scheduling of Daily, Weekly and Monthly Data Target loads using Process Chain and Event Controller.

Environment: SAP R/3 4.5, BW 3.0B, ABAP/4, BEx Analyzer, Windows 2000/NT.

Hire Now