SUMMARY:

• SAP BI Consultant having around 8 years of SAP experience involving Implementation, customization, reporting, testing, user, documentation and support in BW 3.5 & BI 7.0.
• High - level Expertise with proven efficiency in development & implementation
• Involved in 2 full Life Cycle Implementation including Requirement Gathering, Blue Print Preparation, Configuration and Testing with Go Live readiness and Post Go Live Support.
• Extensive knowledge in modeling the d targets and reports.
• Followed and implemented ASAP methodology.
• Hands-on implementation experience in BW7.4, BI 7.0 and BW 3.5 and SAP HANA Studio Version: 2.3.31 along with knowledge of SD, MM, PS, HR and ABAP.
• Involved in creating ADSOs, Semantic partitioned objects, Composite providers, Hybrid providers, Transient providers.
• Expertise of various data design models - Entity Relationship (ER), Multi-Dimensional/Star Schema and Extended Star Schema models
• Experienced in Data-Modeling, Data Extraction, Generic Extraction, Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, Info-cube Creation, Info-Source, Multi-Cubes, ODS object creation.
• Experience in Background Scheduling and Monitoring of Data Loads.
• Experience on Transport Management System in R/3 and BI.
• Involved Generating Reports with Multi providers, Info Cubes and DSO Objects Using BEx Query Designer.
• Knowledge of ABAP used in routines.
• Expert in Mapping the business requirements on to SAP and documenting the same
• Updated with all the latest functionalities of BI 7.
• Customizations - Datasource enhancements, generic extractors, CMOD enhancements, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.
• Knowledge in Business objects universe designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, CMC and Business Objects Enterprise
• Expertise in performance tuning using Aggregates, Rollup, collapse, Partition, Compression and query cache maintenance.
• Involved in presentations, end-user and documentation.
• Excellent Communication and interpersonal skills and the knowledge attained through the involvement in different projects make me suitable for adapting to any work environment and building good relationship with customer.
• Possess Strong analytic skills, with ability to follow project standards.

TECHNICAL SKILLS:

ERP: SAP R/3 4.7, ECC 5.0, and 6.0

Data Warehousing: SAP BW7.4, SAP BI NW04s (BI 7.0), BW 3.5.

Reporting Tools: BEx and web reporting, Web Application Designer, Crystal Reports, BOXI 3.0Web Intelligence 3.0, BO Integration 3.0, MS- Excel

Databases: Oracle 9i/8i, SQL Server 7.0, MS SQL Server 2000

Programming:

Languages/Protocols: ABAP/4, C, C++, SQL, HTML/DHTML.

Operating Systems: Windows NT/XP/2000/98/95.

Agile Tools: Octane

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW on HANA Consultant

Responsibilities:

• Extensively involved in creating ADSOs, Composite Providers, Transformations, DTPs and Info packages as per the business requirement.
• Extensively involved in creating the Formulas, Start Routine and End Routine based on the requirement.
• Extensively involved in transport the objects from Development to Quality and from Quality to Production.
• Extensively involved in install the LO Cockpit Data Sources like, Material movements, Invoice verification, Sales and Purchasing as per the business requirement.
• Extensively involved in filling the set up tables for Material movements (2LIS 03 BF) and Invoice verification (2LIS 06 INV).
• Extensively involved in creating the Flat File Data sources as per the requirement.
• Extensively involved in creating the Generic Data sources based on views as per the business requirement.
• Extensively involved in Cutover activities like prepare the transport list in order, migrate the objects from Quality to Production, validating all the objects whether they imported properly or not, do the follow up with respective teams to fix the issues while migrating, and do the data loads in Production system.
• Extensively involved in performance tuning by partitioning based on the requirements
• Extensively involved in creating the Process chains to automate the data loads.
• Extensively involved in creating the Base level calculation views for Master Data (Dimension) and Transactional Data (CUBE without Star).
• Extensively involved in creating the Star views (CUBE with Star type) as per the business requirement.
• Extensively involved in creating the calculated columns and restricted columns based on the requirement.
• Extensively involved in filter the data at projection level.
• Extensively involved in creating the Input Parameters, Variables to improve the performance.
• Extensively involved in combine the views by using UNION Node in Report level views.
• Involved in doing the Currency conversion based on the business requirement.
• Involved in fixing the high, medium and low priority defects.

Confidential

SAP BI Consultant

Responsibilities:

• Involved in handling the high, medium and low priority incidents.
• Involved in transport the objects from development to quality to production by using CHARM process
• Extensively involved in creating the Technical Specifications.
• Involved in some enhancements for break fix the issues.
• Involved in Broadcast the reports to the particular users.
• Involved in creating the mercury test cases.
• Extensively involved in creating the cube, info objects, Infosources, Transformations, and Data Transfer Processes.
• Involved in enhance the Master data objects and the process chains.
• Extensively involved in define the selections and the formulas in the report level.
• Extensively involved in creating the new reports based on the Functional Specifications which are provided by the users.
• Extensively involved in enhance the reports as per the user requirements.
• Created the CHARMS for transport the objects from Development to Quality
• Involved in update the Functional Specifications as per the user requirement and upload into the Solution Manager.
• Involved in enhance the existing cubes and multiproviders as per the requirement.
• Created Start Routines, Field level Routines, and Formulas in Transformations.
• Involved in Migrate the objects from BW3.5 to BI7.0
• Involved in creating the reports and connect the reports through RRI based on the user requirement.
• Involved in remodeling the data model as per the requirement.

Confidential

SAP BI Consultant

Environment: BI 7.0

Responsibilities:

• BW Ops team is responsible for fixing any batch job failures escalated by Bristlecone level 1 support. Escalate to Platform Config or other teams if necessary.
• Create and execute works plans as necessary (Sometimes help monitoring other teams’ workplans)
• Executing on-demand load requests from business
• ECCS
• PO Commitment (once a year)
• Sales Authorize Freeze calendar update (Once a year) recovery of missing EBS (temporary task until fixed)
• Execute Finance Month End job tasks
• Aggregates rebuild monthly tasks (monthly)
• North America COPA loads (monthly)
• FI Material Ledger DC Shipments
• Manage invalid char handling procedure.
• Adding Info objects to DSO, Infoset and Multi providers.
• Have Done Unit testing document and submitted to Customer for Validation.

Confidential

SAP BI Consultant

Environment: BI 7.0

Responsibilities:

• Monitoring Data load activities and recovered failures in Dev, Quality system as a part of unit testing.
• Preparing the process documents for each and every enhancement.
• Involving in solving high-prioritized tickets regarding extractions, performance issues and data load failures.
• Working on process chains to automate the Deleting indexes in Info cubes, Process of info packages, creating indexes, ODS activation, further updating, PSA request deletion and Attribute change run so on.
• Using open hub to export data from BI to External systems (flat file, table, 3rd party tool).
• Involving in Unit testing, Integration testing, Regression testing and User acceptance tests.
• Enhancing the existing reports as per the new requirement.
• Monitoring the daily loads to various data targets in the system.
• Monitoring the process chains on the basis of daily, weekly & monthly.
• Manual loading and rolling up the data into data targets.
• Maintaining the logs for each manual load.
• Creating aggregates to improve the query response.
• Performance tuning of queries using aggregates, indexing of Info cubes.

Confidential

SAP BI Consultant

Environment: BI 7.0

Responsibilities:

• Extensively involved in installing the business content info objects, cubes, transformations.
• Created Info Objects, Key figures, DSO’s, Cubes and Multiprovider as per the Specifications.
• Extensively Involved in Setting up the LO Data sources for Sales and Distribution and Material management from SAP to BI.
• Involved in enhancing the data sources and write the ABAP Code to populate those fields.
• Created Start Routines, Field level Routines, End routines and Formulas in Transformations.
• Created the process chains to load Daily deltas from SAP for Master and Transaction Data and automated the same.
• Extensively involved in transporting the objects to Quality system.
• Used Multiprovider and Info sets to design complex queries.
• Created Calculated Key figures, Restricted Key figures, formulas and Structures as per the report requirements
• Experienced in creating formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• Do the testing for SD, MM and FI.

Confidential

SAP BI Consultant

Environment: BI 7.0

Responsibilities:

• Extensively involved in creating the Technical Specifications and Functional Specifications.
• Extensively involved in installing the business content objects as per the requirement.
• Created the Info Objects, DSOs CUBEs and MultiProviders as per the Technical Specifications.
• Extensively Involved in Setting up the LO Data sources for Purchasing and Material management from SAP to BI.
• Involved in enhancing the data sources and write the ABAP Code to populate those fields.
• Extensively involved in creating the Generic Data Source with Tables and View as per the requirement.
• Created Start Routines, Field level Routines, and Formulas in Transformations.
• Involved in migrate the objects from BW3.5 to BI7.0
• Extensively involved in loading the data from Flat File Source System.
• Extensively involved in transporting the objects to Production system.
• Involved in creating the Reports as per the User Requirement by using the BEX Query Designer.
• Extensively involved in creating the different type of variables as per the requirement.
• Created the Currency Translation Type for converting the different types of currencies into the Group Currency.
• Extensively involved in do the Performance Tuning by using the Partioning, Aggregates and compression.
• Involved in Creating the Dash Boards by using the WAD.
• Created the New Selections and New Formulas as per the requirement.
• Created Calculated Keyfigures, Restricted Keyfigures as per the report requirement.
• Created the reports by using the Variable Offset values.

Confidential

SAP BI Consultant

Environment: BI 7.0

Responsibilities:

• Involved in handling the high, medium and low priority incidents.
• Involved in transport the objects from development to quality to production by using CHARM process
• Extensively involved in creating the Technical Specifications.
• Involved in upload the technical specifications to the solution manager.
• Involved in some enhancements for break fix the issues.
• Involved in Broadcast the reports to the particular users.
• Involved in creating the mercury test cases.
• Involved in creating the dashboards by using the Visual Composer.
• Extensively involved in creating the cube, info objects, Infosources, Transformations, and Data Transfer Processes.
• Involved in enhance the Master data objects and the process chains.
• Extensively involved in define the cell definitions, and the selections and the formulas in the report level.
• Extensively involved in creating the new reports based on the Functional Specifications which are provided by the users.
• Extensively involved in enhance the reports as per the user requirements.
• Created the CHARMS for transport the objects from Development to Quality
• Involved in update the Functional Specifications as per the user requirement and upload into the Solution Manager.
• Involved in enhance the existing cubes and multiproviders as per the requirement.
• Created Start Routines, Field level Routines, and Formulas in Transformations.
• Involved in Migrate the objects from BW3.5 to BI7.0
• Involved in creating the reports and connect the reports through RRI based on the user requirement.
• Involved in creating the APD (Analysis Process Designer).
• Involved in remodeling the data model as per the requirement.