SUMMARY

• 8+ years of Experience in SAP - BI/BW (3.5, 7.0, 7.3 and 7.4) involved in Implementation projects in which 2 Full Life Cycle Implementations and 2 - Enhancement and Support projects.
• One year of Implementation experience in HANA Modeling from various SAP and Legacy systems.
• Good Understanding of the Retail Business.
• 2.6 years of experience in BO 4.0 on IDT, WEB Intelligence, Dashboards and SAP Explorer
• Participated in all phases of life cycle including Requirement Gathering, Analysis, Design, Development, Testing, Deployment Solutions, Post Go Live Support, Documentation, and User Training.
• Experience in Migrating BW Implementation to BW on HANA environment.
• Ability to work independently with minimum supervision.
• Effective communication and presentation skills, Quick adaptability and systematic approach towards work.
• Worked As a lead in the teams of 5 during earlier projects and displayed good planning and coordination reflecting good results.
• Involved in writing cut-over plans for data loads during go-live.

Areas of Expertise

• Knowledge on Modeling.
• Knowledge on ERM and MDM.
• Sound Knowledge on SAP BI 7.3 and 7.4 concepts
• Involved in complete life cycle implementation of BW projects including data extraction from SD, MM, FI (AP/AR), SRM, PS, PM, APO and SAP-HR-Travel Time management & Personnel administration.
• Worked extensively on Business content activation.
• Build custom info providers, info sources and Generic Extractors.
• Experienced in data extraction using LO Cockpit, Flat file and Generic Data sources.
• Specialized in data transformation using transfer rules and Update rules.
• Knowledge in extraction of data from BW to External systems Using open hub destination
• Extensive knowledge on Reporting using Query Designer and Bex Analyzer.
• Reasonable Knowledge on CO-PA.
• Extensive Knowledge on Transport Mechanism.
• Worked with Transformations and DTP.
• Good Knowledge on Real-Time Data Acquisition.
• Good Knowledge on BI Accelerator
• Worked with Transient Providers, Hybrid Providers.
• Knowledge on creating universes and OLAP Universes using Bex Queries, ODS, Info set, Multi providers and Info cubes.
• Sound Knowledge on SAP BI/ BO integration.
• Exposure on Design Studio
• Sound Knowledge on creating universes Based on Bex Queries.
• Good knowledge on creating Web Intelligence documents & Xcelsius Dash boards based on the Business Requirement for Adhoc Analysis.
• Involved in writting test scripts to validate newly developed queries.
• Developed the Attribute Views based on Master Data Tables in the SAP ECC.
• Created calculated columns in analytic Views in Attribute Views
• Created the Analytic Views based on the Info cube models in SAP BW/BI system.
• Worked with Calculation Views for master and Transaction Data.
• Used Data replication Techniques SLT.
• Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
• Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio.
• Imported and exported the HANA Models from development to Production system using Delivery Units.
• Published HANA Models into BW As Transient Providers

TECHNICAL SKILLS

SAP BWVersions: 7.4,7.3, 7.0, 3.5

SAP BOVersions: 4.0

SAP R/3 Versions: ECC 6.0, 5.0

Business Objects Tools: Universe Designer, WEB Intelligene, Dashboards.

Databases: SAP HANA, SQL Server, Oracle

BW reporting: BEx Query Designer, BEx Analyzer, BEx Web Analyzer, WAD Portal, Web Intelligence, Dashboards

PROFESSIONAL EXPERIENCE

Confidential, Oregon

Sr. SAP BW Developer/Testing Consultant

Responsibilities:

• Involved in preparing Technical Design specifications for user report requirements.
• Involved in development of BW Objects InfoObjects, DSO, InfoCube, Multiprovider, Transformation, DTP, OHD, APD, Datasource, Infopackages.
• Involved in BW BEx Reporting using BEx Query Designer.
• Involved in creation of process chains.
• Experience in Environment synchronization to maintain consistency across the landscape.
• Extracted data from SD, PM, MM, Finance (AP/AR) Data sources of ECC system
• Written test scripts to validate newly developed queries.

Environment: SAP BW 7.3, SAP ECC 6.0

Confidential, NJ

Sr. SAP BI/BO/HANA Consultant

Responsibilities:

• Responsible for analyzing the requirements gathering, design and eventually the build of SAP HANA data models.
• Responsible for reviewing Technical Design specifications.
• Involved in replicating ECC tables to HANA studio through SLT Technique
• Worked on creating HANA views like Attribute View, Analytic View & Calculated view based on requirements and data warehousing standards.
• Involved in migrating BW objects like Cube & DSO to HANA Optimized versions Implementation
• Have worked on Virtual Provider & SLT technique
• Involved in ETL Based replication to provision the data from ECC to BW system,
• Involved in providing solutions to the complex requirements using BW 7.3 Infoproviders
• Involved in BI 7.4 implementation.
• Extensively worked in SAP Business Objects (4.0) tool like Universe Designer, WEB Intelligence, Dashboards.
• Involved in coordinating with offshore for the daily deliverables throughout the ASAP phases.
• Involved in explaining the end user requirements to the Onshore/Offshore & filling the gaps
• Involved in upgrading BW systems from 7.0 to 7.3
• Extracted data from SD, PS, PM, MM, Finance (AP/AR) Data sources of ECC system

Environment: SAP BW 7.4 & 7.3, SAP ECC 6.0, SAP BO 4.0

Confidential

Sr. SAP BW-BO Consultant

Responsibilities:

• Involved in SAP BW 7.3 upgrading
• Involved in preparing Technical Design specifications for user report requirements.
• Involved in development of BW Objects InfoObjects, DSO, InfoCube, Multiprovider, Transformation, DTP, OHD, APD, Datasource, Infopackages.
• Involved in BW BEx Reporting using BEx Query Designer.
• Involved in SAP BO WEB Intelligence, Dashboards.
• Involved in automation of data loads to BW using process chains.
• Created BIA Indices on cubes to work on BI Accelerator.
• Experience in Environment synchronization to maintain consistency across the landscape.

Environment: SAP BW 7.3, SAP BO 4.0, SAP ABAP, SAP ECC 6.0

Confidential

SAP BW Consultant

Responsibilities:

• Responsible for solution design for the SAP BW Implementation flows.
• Responsible for reviewing Functional Specification, Technical Design specifications and providing corrections in the design.
• Identifying gaps in the system to stabilize the BI System.
• Involved in different BW releases to handle the enhancements in BW.
• Involved in Performance & Tuning activities.
• Involved in Transportation repackaging activities to transport the objects in cross environments.
• Involved in System refresh activities.
• Responsible for maintenance of system consistency across the landscape.
• Identifying performance improvement areas to improve the Flexibility, Maintenance of the BI System.
• Extensively coordinated with the Security teams to design & implement Analysis Authorization for various Reports
• Responsible to meet the SLA to deploy the objects in the production environment.
• Responsible for implementation of authorization activities in the BW system
• Involved in End user support to fulfill the requirements.

Environment: SAP BI 7.0, SAP ECC 6.0

Confidential

SAP BW

Responsibilities:

• Involved in the requirement gathering for Data Warehouse Environment for SD and MM applications.
• Involved in coordinating with functional team and created business blue print and data flow diagrams.
• Coordinated closely with the business team in development of the Technical & Functional specs.
• Designed functional specification and technical specifications as per the business requirement.
• Involved in creation of Unit test script templates and executed of those scripts and ensured there are no gaps between functional and technical aspects.
• During the testing phases took up more responsibilities in all the activities related to defects resolution.
• Involved in data loading from different source systems for Plan & Actual data loads.

Environment: SAP BI 7.0, ECC 6.0

Confidential

SAP BW

Responsibilities:

• Monitoring of BW loads through Process chains and Solving load failures during the data Loads.
• Solving performance-related issues by applying Partitioning, Aggregates, and Compression.
• Involved in Re-modelling of the Cube.
• Created BIA Indices on cubes to work on BI Accelerator.
• Created Queries on Multi providers and Info cubes.
• Created Transformations, DTP’s between the Objects.
• Designed process chains for Batch job scheduling of loads and Updating data targets.
• Transported the objects in system landscape.
• Involved in meeting SLA for data loads & development.

Environment: SAP BW 3.5 & BI 7.0, SAP ECC 5.0