We provide IT Staff Augmentation Services!

Sr. Sap Bw/bi Consultant Resume

IL

SUMMARY

  • SAP BW professional with 8+ Years experience in IT industry, including 7 years of implementation and production support experience in BW/BI.
  • Experience in Multi Dimensional Data Modeling (Star Schema, Extended Star Schema), Extraction Transformation and Loading (ETL).
  • Extensive experience in SAP BW configuration, Administrative workbench, OLTP Extraction, Reporting and administration of the BW system.
  • SAP BI BW, Business Objects Integration specialist with understanding depth and breadth of the SAP Business Objects application
  • Sound knowledge of different data models and BW Extended Star Schema
  • Expertise in development and maintenance of Info Cubes, ODS Objects and Multiproviders in R3 (SD, MM and FI - CO Modules).
  • Extensively involved in performance tuning of BW landscape. Reviewed BI statistics and proposed suitable aggregates for queries
  • Experience with Open Hub and Info Spoke technology to extract data from BW to 3rd party systems
  • Experience with using ABAP programming in Transfer Rules, Update Rule, Transformations Routines and BW extractors.
  • Good knowledge in documenting Functional specifications, Technical specifications, Test cases, Test results and Production support documents.
  • Expertise in creating Reports using BEx and Web Application Designer. Worked with Transformations and DTP in SAP BI 7.0

TECHNICAL SKILLS

Business Intelligence: SAP BW 3.5/3.X, BI 7.0

ERP: SAP R/3 4.6,ECC

Operating System: UNIX, Windows NT/2000.

Programming Languages: C, C++, Java

Database: Oracle 10g/9i, SQL Server and MS Access.

OLAP Tools: BEx Analyzer

PROFESSIONAL EXPERIENCE

Sr. SAP BW/BI consultant

Confidential, IL

Responsibilities:

  • Involved in requirement gathering from users and Modeled data targets according to the reporting requirements. Worked with teams to discuss/review technical specifications and functional requirements.
  • Created and configured Data Source, Transformations, DTP, DSOs, Info cubes, Multiproviders, Info Sets, Open Hub, and managed data loads into Info Providers via Process Chains.
  • Based on the project requirement enhanced Data sources and created several routines using ABAP/4
  • Used Routines (Start Routines, Update Routines) in Update rules and Transformations, user exits to Update Key Figures and Characteristics in the Info Cubes.
  • Experience in web application development and web reporting and extensive experience in Front End BW components like Workbooks, Queries, Calculated key figures, Restricted key figures, structures, variables, Formula Variables, Filters, Restrictions, Conditions, Navigational attributes, Adhoc Reports and Web Reports etc.,
  • Transferred data from Info Provider to Flat Files by using Open Hub (Info Spoke) and loaded data to the data targets from different sources (R/3, Flat Files).
  • Expertise in the Performance techniques like Performance tuning, Aggregates, Compression, Indexes, Statistics and Rollups (Performance Improvement).
  • Involved in documenting Functional specifications, Technical specifications, Test cases, Test results and Production support documents.
  • Developed weekly, monthly Quarterly reports on various products based on user requirements.
  • Involved Technical documentation for all the Changes End to end and Created new Reports.
  • Supported all phases of a project life cycle including analysis, design, development, configuration, testing, and development of solutions, as well as documentation, and end-user training.

Environment: SAP BI 7.0, ECC 6, SD and MM, Oracle.

SAP BW Consultant

Confidential, CA

Responsibilities:

  • Responsibilities include Production support like handling the data load issues on a day to day basis which includes monitoring, bug fixes and minor enhancements and developing of adhoc BEx reports.
  • Worked with Business Users very closely to gather the requirements, review the functional specs and help them resolve the production issues by attending various meetings.
  • Used the tools like HPSM to resolve the production issues in timely manner.
  • Handled the Data Load issues during data load monitoring on daily basis.
  • Editing the data in PSA and updating the relevant requests, handling the duplicate data records, repeating the failed delta loads by backing out the bad requests and un-checking the data mart status involving the loads from DSO to infoCubes, and compressing the cubes to avoid duplicate load requests
  • Involved in performance tuning for better performance. Created aggregates for specific cubes based on reporting requirements.
  • Extensively used Multiproviders for reporting using various Infocube combinations to suit business needs.
  • Created process chain sequence and dependency specification for the automation of the processes.
  • Extensively used Query Designer and Web Application designer to create reports and publish them in the web.
  • Created queries using Restricted and Calculated Key Figures. Used Conditions, Variables, Exceptions, Report-Report Interface etc to tune query output as per business needs.
  • Implemented BEx and Web Reporting and trained end users on BEx Reports
  • Worked with the Change Request Process to do the bug fixes and carry it all the way to production by performing thorough Unit and Quality testing's in Quality Center.
  • Involved in 36 months of historical conversion data loads to SAP BI.
  • Loading data from flat file to SAP BI. Configuring metadata in the data warehouse workbench for replications and update of Data Source from Source System.
  • Communicate the critical issues with the other Development team members/off shore and guide/mentor the off shore team accordingly.
  • Worked on the enhancements and do the end to end development and support, which includes document, design, build, test, Data Verification's (Quality Center) both the BW back end and front end (BEx) objects and implement to production.
  • Support the Weekend data loads and pro-actively monitor the data loads to improve load time performance.
  • Documented the issues, How to doc's for all the activities performed and data load steps based on the dependencies' following the SDLC SAP Best Practices.

Environment: SAP BW 3.5, SAP R/3 4.7, SD, and MM modules.

SAP BW Consultant

Confidential

Responsibilities:

  • Responsibilities include development of new Info Cubes & Enhancements to the existing functionality as per the user requirements
  • Used LO - Cockpit (V3 Update) extract structures and data sources to extract data in SD and MM to facilitate the data to BW.
  • Involved in performance tuning for better performance. Created aggregates for specific cubes based on reporting requirements.
  • Extensively used Multiproviders for reporting using various Infocube combinations to suit business needs.
  • Involved in transporting the objects from the Development to test and then production by fixing the un-imported objects if any and resend them to the basis team to import.
  • Extensively worked with the Tech documentation based on requirement changes
  • Enhanced Functions of SAP Business Explorer Analyzer.
  • Created process chain sequence and dependency specification for the automation of the processes.
  • Extensively used Query Designer and Web Application designer to create reports and publish them in the web.
  • Created queries using Restricted and Calculated Key Figures. Used Conditions, Variables, Exceptions, Report-Report Interface etc to tune query output as per business needs.
  • Implemented BEx and Web Reporting and trained end users on BEx Reports

Environment: SAP BW 3.5, SAP R/3 4.7, FICO and SD, Oracle.

SAP BW Consultant

Confidential

Responsibilities:

  • Analyzed business requirements and translated them into Multi-Dimensional Data Models using star schema.
  • Worked on Sales and distribution, finance data and pulled the data from R/3.
  • Involved In creating and maintaining Info Cubes, Data Store Objects, Info Objects, Info Source, Data Sources, Info Packages, and MultiProvider and prepared the technical specs for the same.
  • Modified and activated transfer rules and maintained communication structure.
  • Modified the user exits to populate the custom fields added to the data sources.
  • Data load management, event processing and reporting optimizations
  • Set up periodic jobs for delta-data uploads, created aggregates, indices for a better query performance and used event-chains to notify end-user of report availability.
  • Extensively worked on utilizing PSA for effective Loads and Error handling.
  • Worked with PSA in monitoring the data transfer from source system to BI.
  • Checking data and faced challenges here interns of quality and cube performance for reporting.
  • Used Summary level Cube to stage the data before doing reporting on cube transferring the extracted data to the Info Cube.
  • Involved in transporting the BI objects from development server to quality server for unit testing.
  • Involved in the transportation of various objects from development to quality system, and in turn transporting the same objects into production system after successful testing in the quality system.
  • Created Multi providers to enhance the reporting base.
  • Designed the new reports as per the requirement and also designed the technical specs for the same.

Environment: BW 3.OB, SAP R/3 4.6, FICO and SD, Bex Analyzer.

Hire Now