We provide IT Staff Augmentation Services!

Sap Bi Technical Consultant Resume

Boston, MA

Professional Summary

  • Proven 06+ years SAP BI /BW Techno-Functional implementation experience.
  • Business area worked - HR, FI, and CRM.
  • Thorough knowledge and experience with business requirements gatherings & analysis, gap assessment, development of functional specifications, data modeling and testing.
  • Full life cycle experience in implementations encompassing architecture and landscape design, data acquisition, transformation, data warehousing and modeling, information delivery and performance tuning.
  • Excellent knowledge of ASAP Methodology and implementation.
  • Experienced in providing training to the users and also experienced with coordinating cross-functional teams
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing.
  • Extracting master data / transactional data in BI landscape (data from both SAP R/3 and external source systems) with customs extractors, modifications/ enhancement (user-exit) of business content extractors, generic extractors, and master data extractors, transformation rules (ABAP/4 routines), transports and process chains.
  • Experience in leading team. Performed Offsite Coordinator roles.
  • Converting the functional specification into technical specification.
  • Strong knowledge and experience of full life cycle SAP BI/BW project planning, systems development, integration and support.
  • Good Exposure of Crystal Reports 2008, Xcelsius 2008, Universe Designer,
  • Exposure in Central Management Console (CMC).
Professional Experience

Groupsoft March 2011 - Presently Working
Client: Confidential, Boston, MA, USA
Role: SAP BI Technical Consultant

Project Details:

Samsonite implemented the GrMAP. It is an enterprise - wide merchandise assortment planning and analysis solution for large and mid-size retail organizations. The objective of the proposed new SAP BI system will be to provide flexibility, reduce risks, and easily fetch the data from GrMAP. We worked on GrMAP reports that we created in SAP BI.

Role/Responsibilities:

  • Involved in the business requirements (Reports and Data Analyses) gathering exercise.
  • Modeled and developed custom DSOs and custom info cubes and multi provider in order to fulfill the business requirements.
  • Involved in creating Info cubes, ODS objects, Multi providers, Info sets, Info sources, Info packages, Update rules, Queries, Info spokes, and Process Chains.
  • Query development in Bex Query Designer with filters, free characteristics, formulas, selections (restricting), reusable objects like calculated (CKF)/restricted (RKF) key figures, conditions, exceptions, cells calculation, variables and display in Bex Analyzer/ Report Designer.
  • Helped to design and develop custom data sources for master and transactional data.
  • Extracting master data / transactional data in BI landscape (data from both SAP R/3 and external source systems) with customs extractors, modifications/ enhancement (user-exit) of business content extractors, generic extractors, and master data extractors, transformation rules (ABAP/4 routines), transports and process chains.
  • Involved in the creation of test cases and regression testing for Samsonite GrMAP Reports with users.
  • Coordinating with team and assign the work accordingly.
  • Created Universes by Using Universe Designer. Enabled features like Cascading list of values, Delegate Search at the prompts end in the Universe.
  • Created SAP Business Object Xcelsius Dash boards by using QAAWS.
  • Generated Crystal reports per the business users requirements. Exported the Crystal Reports to Repository and scheduling using CMC.

Environment: SAP BI 7.0 (NW2004s), BW 3.5, Bex Query Designer, Bex Analyzer, Crystal Reports 2008 and Xcelsius 2008,

Client: Confidential, Exton, PA
Role: SAP BI Technical Consultant

Project Details:

Confidential, is a preeminent supplier of SAP services and training capability to integrators and direct clients in several industry verticals, including the public sector. We are giving SAP BI support to different clients like: Sport Basements and Vitamin Cottage for Gryffns Inc.

Role/Responsibilities:

  • Involved in the Fiscal year activity for Sales & purchasing cubes. Creation of Info Cubes, Transformation, DTP and info packages.
  • Copied the reports from one data target to another data target.
  • Modified the process chains.
  • Process Chain Monitor & fix the data load related issue.
  • Gathering exercise for enhancement of existing reports.
  • Query performance analysis and optimization/tuning through data model, query definition, Aggregates, Comparison, Drop/Generate the Index's and Database Statistics.
  • Assigns the RT (Request Ticket) to team and discuss the RT between the team to resolve the RT.
  • Coordinating with team and assign the work accordingly.

Environment: SAP BI 7.0 (NW2004s), BW 3.5, Bex Query Designer, Bex Analyzer,

Client: Confidential, Egypt
Role: SAP BI Technical Consultant

Project Details:

Confidential, implemented the GrMAP. GrMAP is an enterprise - wide merchandise assortment planning and analysis solution for large and mid-size retail organizations. The objective of the proposed new SAP BI system will be to provide flexibility, reduce risks, and easily fetch the data from GrMAP.

Role/Responsibilities:

  • Involved in the business requirements (Reports and Data Analyses) gathering exercise
  • Also helped team to distinguish between SAP R/3 Reports and BW Reports.
  • Modeled and developed custom multi cube in order to fulfill the business requirements.
  • Involved in creating Info cubes, ODS objects, Multi providers, Info sets, Info sources, Info packages, Update rules, Queries, Info spokes, and Process Chains.
  • Query development in Bex Query Designer with filters, free characteristics, formulas, selections (restricting), reusable objects like calculated (CKF)/restricted (RKF) key figures, conditions, exceptions, cells calculation, variables and display in Bex Analyzer/ Report Designer.
  • Involved in the creation of test cases for Magrabi Assortment Reports.
  • Involved in integration testing with users for Magrabi Assortment Reports.

Environment: SAP BI 7.0 (NW2004s), Bex Query Designer, Bex Analyzer,

Client: Confidential, Egypt
Role: SAP BI Technical Consultant

Project Details:

Metro Market the objective of the proposed new SAP BI system will be to provide flexibility, reduce risks, and easily fetch the data from SAP Posdm, MM & SD.

Role/Responsibilities:

  • Involved in the business requirements (Reports and Data Analyses) gathering exercise.
  • Activated the BI contents related to SAP PosDm, SD & MM.
  • Creating the process chains & fixed the data load related issue.
  • Involved in the creation of test cases and regression testing for Metro Reports.
  • Query performance analysis and optimization/tuning through data model, query definition, Aggregates, Comparison, Drop/Generate the Index's and Database Statistics.

Environment: SAP BI 7.0 (NW2004s), Bex Query Designer, Report Designer and Web Analyzer.

Confidential, Noida (India) August 2010 - January 2011
Client: Confidential, Ghaziabad, U.P
Role: SAP BI Consultant

Role/Responsibilities:

  • Involved in the business requirements (Reports and Data Analyses) gathering exercise (Business Blueprint phase). Also helped team to distinguish between SAP R/3 Reports and BW Reports.
  • Assisted team in using ASAP methodology for all phases of BI implementation.
  • Modeled and developed custom DSOs and custom info cubes and multi cube in order to fulfill the business requirements.
  • Involved in creating Info cubes, ODS objects, Multi providers, Info sets, Info sources, Info packages, Update rules, Queries, Info spokes, and Process Chains.
  • Query development in Bex Query Designer with filters, free characteristics, formulas, selections (restricting), reusable objects like calculated (CKF)/restricted (RKF) key figures, conditions, exceptions, cells calculation, variables and display in Bex Analyzer/ Report Designer.
  • Involved in integration testing with users for HR reports.

Environment: SAP BI 7.0 (NW2004s), Bex Query Designer, Report Designer and Web Analyzer.

Confidential, CA October 2008 - April 2010
Client: Confidential, Cupertino, CA
Role: SAP BI Consultant

Role/Responsibilities:

  • Gathering/assessing of business requirements (functional specifications and technical specifications) and designing star schema for the requirements for operational & analytical reports in SD.
  • Modeled and developed custom DSOs and custom info cubes and multi cube in order to fulfill the business requirements.
  • Developing complex queries in Bex Analyzer and publishing the queries to Enterprise Portal.
  • Query development in Bex Query Designer with filters, free characteristics, formulas, selections (restricting), reusable objects like calculated (CKF)/restricted (RKF) key figures, conditions, exceptions, cells calculation, variables and display in Bex Analyzer/ Report Designer.
  • Involved in creating Info cubes, ODS objects, Multi providers, Info sets, Info sources, Info packages, Update rules, Queries, Info spokes, and Process Chains.
  • Ensured performance tuning analysis (index, aggregates, statistics, compression) code review, query design review, SAP change control, transport system, managing transports, BW data quality, reconciliation and validation with R/3 and external sources systems, and master/transactional data alignment/realignment.
  • Participated in data transfer from multiple Sap and non-SAP (DB Connect, UD Connect, flat file interfaces) source systems through Direct Update and Flexible Updating.
  • Migrated BW 3.5 Data Sources into BI 7.0, controlled data flow with info packages (IP) and data transfer process (DTP).
  • Involved in integrated testing with users for reports.

Environment: SAP BI 7.0 (NW2004s), BW 3.5, Enterprise Portal, Bex Query Designer, Report Designer, Web Analyzer, and Web Application Designer.

Confidential, (U.S.A) December 2007 - September 2008

Client: Confidential, Torrance, CA

Role: SAP BI Consultant

Role/Responsibilities:

  • Gathering/assessing of business requirements (functional specifications and technical specifications) and designing star schema for the requirements for operational & analytical reports in FI, CRM etc.
  • Working on BI 7.0 Data Warehousing Workbench: designing functional/physical data model, backend configuration, testing, cutover/go-live planning, production support of Info Objects, Info Cubes, Data-Store Objects (DSO/ODS), Multi providers, Info sets, Open Hub Services, Info spokes and Process Chains.
  • Extracting master data / transactional data in BI landscape (data from both SAP R/3 and external source systems) with customs extractors, modifications/ enhancement (user-exit) of business content extractors, generic extractors, and master data extractors, transformation rules (ABAP/4 routines), transports and process chains.
  • Reconciled and validated data targets like Info cubes and ODS objects with R/3 and BW data analysis.
  • Developing complex queries in Bex Analyzer and publishing the queries to Enterprise Portal.
  • Query development in Bex Query Designer with filters, free characteristics, formulas, selections (restricting), reusable objects like calculated (CKF)/restricted (RKF) key figures, conditions, exceptions, cells calculation, variables and display in Bex Analyzer/ Report Designer.

Environment: SAP BI 7.0 (NW2004s), Enterprise Portal, Bex Query Designer, Bex Analyzer,

Confidential, India January 2006 - November 2007

Client: Confidential, India

Role: SAP BW Developer

Role/Responsibilities:

  • Involved in the business requirements (Reports and Data Analyses) gathering exercise (Business Blueprint phase). Also helped team to distinguish between SAP R/3 Reports and BW Reports.
  • Assisted team in using ASAP methodology for all phases of BW implementation.
  • Implemented newly developed Fit/Gap analysis templates/tools to speed up the realization (development).
  • Participated in data transfer from multiple Sap and non-SAP (DB Connect, UD Connect, flat file interfaces) source systems through Direct Update and Flexible Updating.
  • Helped to design and develop custom data sources for master and transactional data.
  • Modeled and developed custom ODSs and custom info cubes and multi cube in order to fulfill the business requirements.
  • Worked with the user-exits for extension of master data.
  • Migrated BW 3.5 Data Sources, retrieved data from service API (SAPI), generated, generic, and custom ABAP/4 Data sources (PSA), consolidation layer in DSO/ODS, controlled data flow with info packages (IP) and data transfer process (DTP).
  • Hands-on performance tuning analysis (indexes, aggregates, statistics, compression), query design review, SAP change control, transport system, managing transports, load performance analysis/optimization of data warehouse through BI Statistics.
  • Developing complex queries in Bex Analyzer and publishing the queries to Enterprise Portal.
  • Reporting (query development, Bex, WAD, query structures, variables, CKF's, RKF's, customer exits), query performance analysis and optimization/tuning through data model, query definition, Aggregates, Database Statistics.
  • Query development in Bex Query Designer with filters, free characteristics, formulas, selections (restricting), reusable objects like calculated (CKF)/restricted (RKF) key figures, conditions, exceptions, cells calculation, variables and display in Bex Analyzer/ Report Designer.

Environment: SAP BI 7.0 (NW2004s), BW 3.5, Enterprise Portal, Bex Query Designer, Report Designer, Web Analyzer, and Web Application Designer.

Education:

  • Bachelors in Arts.
  • Computer Diploma in Software.

Hire Now