SUMMARY

• SAP BW consultant with 9 years of experience which includes Technical and Functional Consultant role played.
• Expertise in various versions of SAP BW / BI which includes 3.0 to 7.3, 7.4 with multiple implementations experience and IP Integration experience.
• Worked on creating Real time Info cube, Aggregation Level, Querys and WAD's as per the Integrated Planning settings.
• Functional experience and exposure to various modules such as FI/CO, COPA, SRM, CRM, APO, HCM, SD, MM, PP, P2P and SAP APO/SCM.
• Good hands on experience in various phases of the project such as design, development, deployment and hyper care and support.
• Worked different type of roles ranging from a Developer to Architect.
• Expertise in Data Modeling for Design, Development of standard and custom BW solutions including extractors, info providers, data providers (DSOs), info sources, info objects, and info packages.
• Extensively worked in Data Extraction from Multiple SAP and Non SAP (Legacy) Systems.
• Strong Hands - on experience in large-scale Data Warehousing projects Expertise in using Business Objects Suite products like Designer, CMC, Web Intelligence.
• Good knowledge of BW security design concepts.
• Extensively worked on SAP BEx query designer, Analyzer and WAD.
• Strong experience in configuration of SAP BW, Multi Providers, Info Cubes, DSO, Info Sources and different types of extractors based on the business requirement.
• Has extensively worked with Accelerated SAP Methodology in Implementations.
• Created Technical Specifications from Functional Specification documents.
• Extensively worked with ABAP Routines in Transfer Rules, Update Rules, Transformations and Start Routines.
• Expert in batch schedules using process chains for data loading.
• Hands on experience in Performance tuning Techniques for overall system performance (Aggregates, Cube Compression, Line Item Dimension, Indexing) for Improving the Reporting.
• Good experience in developing queries and other options for data access like BEx reports, Web reporting, Report-to-report interfaces, Operational Data Store reporting, master data reporting, Open Hubs and 3rd party tools.
• Good Knowledge on BI Accelerator
• Strong Communication, Analytical, Presentation skill with ability to work in a team and individually.
• 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

PROFESSIONAL EXPERIENCE

Confidential, Oregon

SAP BW/BI Consultant

Responsibilities:

• Gathering the requirement process and conducted Current State Gap analysis.
• Developed Macro Design's (data models, information flows, data integration, and functional reporting design) related to the SAP BI.
• Evaluate current architecture and solutions to recommend the best approach or actions to improve the BW/DW environment.
• Participate in the BI, helping to set standards, evaluate solutions and define best practices for reporting and the Business Warehouse.
• Developed custom Info Cubes, DSO’s and Multi Provider’s to meet requirements.
• Working on Unit testing, Functional testing and UAT with users.
• Involved in design of Integration Planning for business planning applications.
• Created Real-Time Info-provider's for creating Planning Application based on this Info-provider's.
• Created Aggregation Levelfor User Level Planning
• Moving the objects from Development to Quality and Production systems.
• Providing knowledge transfer to client support team.

Environment: NW 2004s, BI 7.4, SAP ECC.6, SAP SCM, SRM and Enterprise Portal.

Confidential, NJ

SAP BW/BI/HANA Consultant

Responsibilities:

• Conducting analysis of systems specifications for Dash boards and preparing the design flow in SAP BI with BO 4.0 Dash boards for the same to replace existing reporting systems.
• Perform Investigational Analysis with the Business to Determine Project Feasibility / Define Value Propositions / Create Business Intelligence Project Plan
• Developed / Manage Project Timelines / Plans and Coordinate within an SAP BW Environment.
• Gathering the requirement process and conducted Current State Gap analysis.
• Doing co-ordination with offshore team and clarifying the issues raised by them.
• Used Data replication Techniques SLT.
• Imported and exported the HANA Models from development to Production system using Delivery Units.
• Published HANA Models into BW As Transient Providers
• Developed Macro Design's (data models, information flows, data integration, and functional reporting design) related to the SAP BI.
• Developed custom Info Cubes, DSO’s and Multi Provider’s to meet requirements.
• Worked on Unit testing, Functional testing and UAT with users.
• Moving the objects from Development to Quality and Production systems.
• Applying the fixes for the issues raised during the testing and moving into to corresponding systems after successful testing.
• Providing the hyper care for to Production support for 4 - 6 weeks.
• 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.

Environment: NW 2004s, BI 7.3 & 7.4, SAP HANA, SAP ECC.6, SRM, P2P, IM, Enterprise Portal.

Confidential

SAP BI/BW Consultant

Responsibilities:

• Conducting analysis of systems specifications in SAP FI, QM, SCM, SRM, P2P and APO applications and preparing the design flow in SAP BI for the same.
• Gathering the requirement process and conducted Current State Gap analysis. PO.
• Developed Macro Design's (data models, information flows, data integration, and functional reporting design) related to the SAP BW.
• Responsible for Design, Development and Implementation of customized MultiProviders, Infosets, InfoCubes and Data Store Objects.
• Worked on APO demand planning history design flow in BW to pull from ECC and send it to APO system.
• Provided different reports in Demand planning by using BEx and BO tools.
• Created Webi reports and deployed them through Info View.
• Used Solution Manager for handling the transports.
• Conducting Technical Unit Testing, Function Unit Testing and User Acceptance Testing.
• Involved in SAP BW 7.3 upgrading
• Created Real time Info cubes, Aggregation Levels, Querys and WAD's as per the Integrated Planning settings.
• Created BIA Indices on cubes to work on BI Accelerator.

Environment: NW 2004s, BI 7.3 & 7.4, SAP HANA, SAP ECC.5, SRM, HCM, P2P, QM and Enterprise Portal.

Confidential

SAP BI / BW Consultant

Responsibilities:

• Conducting analysis of business requirements for operational & analytical reports in Financials and HR.
• Business requirements and Report HR for operational & analytical reports. Involved in data extraction.
• Gathered requirement process and conducted Current State Gap analysis.
• Developed data flow diagrams and flow charts. Gathers information from system users, functional experts, and business analysts.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and MultiProviders.
• Reviewing designs and finalizing the final data flow in BI.
• Working with offshore team for the development of HR, PCM, SRM and SCM applications and clarifying issues.
• Did changes for existing flows in PCM, Funds Management and in Accounts Payable applications, resulting improved efficiency.
• Conducting Technical Unit Testing, Function Unit Testing and User Acceptance Testing.
• Taking responsibility to move the objects and do data loads for the same in Production system.
• Data loads, testing, and UAT assistance.
• Giving hyper care for 4 - 6 weeks in Production system initially and handover to support team.

Environment: NW 2004s, BI 7.0, SAP HANA, SAP ERP ECC.5,EWM,SAP SEM, SAP SCM and Enterprise Portal.

Confidential

SAP BI / BW Data Modeler

Responsibilities:

• Contribution-Identified the functional derivations for the new developments in FI-Accounts Receivables, Accounts Payable and Billing (FI-AR, FI-AP, SD) applications.
• As a consultant preparing the functional design documents by conducting meeting with business users.
• Responsible for creation of design Documents for Info providers, Queries and process chains in order to meet the client requirements.
• Ensure that customer needs are identified and that appropriate, cost effective solutions are provided to the satisfaction of customers on schedule, within budget and to the appropriate quality
• Designed project model based on the requirements.
• Involved in the requirement gathering for Data Warehouse Environment for SD and MM applications
• Managing and resolving errors in transports from development to quality system.
• Provided assistance and created training curriculum, guides, checklists and courses.
• Created test plans, scripts and scenarios for Unit Testing and User Acceptance Testing.
• Coordinated and managed User Acceptance Testing.

Environment: SAP BI, SAP ERP ECC.5 and BEx tools.

Confidential

SAP BI / BW Consultant

Responsibilities:

• Developed Plan and Actual Cubes for SEM and Integration Planning for FIGL, PCA, CCA, and COPA.
• Responsible for driving the review and approval of the operational, analytical, dashboard and external reporting requirements.
• Involved in design of Integration Planning for business planning applications.
• Created Real-Time Info-provider's for creating Planning Application based on this Info-provider's.
• Created Aggregation Levelfor User Level Planning: for example CFO, Regional Manager, Supervisor, etc.
• Individual Aggregation Level will have to be created respective user depending on respective user requirement.
• Migrated the 3.x data flow to 7.x model.
• Migrated the queries and workbooks from 3.x to 7.x
• Error Debugging and rectification, solving issues and problems faced during Data uploads.
• Corrected problems and recommend solutions to problems for permanent fix.
• Created adhoc process chains for managing the data loads.
• Involved in Increasing the Load performance of the BW system while loading.
• 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.

Environment: SAP BI.3.5 & 7.0, Net weaver 04’s, SAP R/3 4.6C and BEx Analyzer.