• Over 11 Years of experience in SAP.
• 10 years experience in SAP-BW Versions BI 7.3,7.0, 3.5, 3.1c 3.0B. And 2 years in SAP-IP&BPC . 1 years experience in SAP-ABAP and BO reporting
• Experience as Team lead managing teams on a full-lifecycle implementation project.
• Completed 5 end-to-end implementations. And experience with 3 production projects.
• Worked in various functional areas SD,MM,FI,CO,PP,HR Undergone complete life cycle implementation.
• Involved in various phases of project Initial LOE, BRD Design project time lines project plans project kick-off Development UAT, User Traning regression test,
• Experience with Requirement Gathering from process design owners, Business Groups, Users, Business Blueprint (Identifying Reports, Gap Analysis, Enhancements), Realization (Design & Development of BI objects), and Post Production Support.
• Enhancements of existing system, coordinate testing, and perform change management/training for SAP BI Reporting and applications.
• Create data models and data flows (extended star schema, ODS, data marts & external data).
• Technical Design spec and functional Design specs, power point presentations, cut over plans.
• Document reporting to the needs of the business service and support organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Knowledge in non-SAP reporting tool like Business Objects.
• End to end architecture knowledge in Business Objects XI 3.1/3.0 and Create universes on top of SAP BW and other non-SAP systems like Oracle, SQL, etc.
• Understand the BW queries and cubes very well to create universes in BO
• Knowledge in Develop Crystal Reports on top of SAP BW design, develop and deploy Xcelsius dashboards using BW queries, Multi providers.

SAP BW

• Worked as BW Architect with experience in designing the solution for SAP and non SAP system
• Involved in gathering user requirements and data modeling using Extended Star Schema concepts.
• Experience in Retail, Sales, HR, FI GL Account Variance Report Liability and Equity Y TO D, Unaged cashing reports and Port folio cube report and portfolio cube details Stock reports and Aging report functionality, Material Movements from Inventory and SCM
• Developed Real-time Info Cubes standard Info Cubes DSO and MultiProviders.
• Worked in Data Extraction, Transformation, Staging and Reporting, Testing of Extractors, configuration, transformation rules and Reporting using BEx, Web Application Designer
• Uploaded master and transactional data from flat files and SAP R/3 as the OLTP source. Worked extensively on administration workbench (RSA1). Customized Info Objects, Info Sources, ODS, Info Cubes and Multiproviders.
• Used DSO to stage the data before transferring the DSO contents to the Info Cube. Done DSO reporting to give detail level data.
• Monitored data loads effectively handled many data loading errors during data load.
• Defined Master data attributes (Navigational and Display)
• Created DSO for staging layer before transferring the DSO contents to the Info Cube.
• Created DSO to stage master data to share it across the different cubes and other Master data objects.
• Created hierarchies.
• Created DTP and Transformation to load the Data in to Cube.
• Performance issue raised during the design has been handled effectively.
• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing
• Resolving the tickets according to priority based created in the Remedy Tool.
• Scheduled Daily/Weekly/Monthly data loads schedule new jobs.
• Configuring metadata in the Administrator work bench for replication and the update of Data source from source system
• Down loading Data from Cube and ODS to /BIC/OH tables using open hub service and info spoke
• Worked on Technical content (static’s) cubes for performance
• Worked on Logistics Cockpit uploaded data from r/3 to BW
• Worked on SAP BW Transports
• Enhancing standard SAP extractors and created data extractors in R/3 for data loading

BW BO

• Knowledge in non-SAP reporting tool like Business Objects.
• BOBJ integration with BW
• End to end architecture knowledge in Business Objects XI 3.1/3.0 and Create universes on top of SAP BW and other non-SAP systems like Oracle, SQL, etc.
• Understand the BW queries and cubes very well to create universes in BO
• Knowledge in Develop Crystal Reports on top of SAP BW design, develop and deploy Xcelsius dashboards using BW queries, Multi providers.

SAP BPC

• Knowledge of Modeling Application sets and Applications for different Planning Scenarios
• Knowledge of automation programs to facilitate loads of Transactional and Master Data.
• Knowledge of BI integration for Sequencing dependencies of SAP BI Process Chains to BPC data manager packages for Transactional and Master Data Loads
• Knowledge of Configuration of Work Status Tracking for monitoring Forecast Status
• Knowledge of Configuration of SAP BPC security including Task Profiles and Member Access Profile and related user assignments.
• Advance Script development for Custom Data Manager Packages covering custom Prompts and Script Logic Assignment Input Schedules and reporting templates utilizing the new EVDRE functionality.

SAP IP

• Tracking actual versus planned expenses for projects.
• Developed Real-time Info Cubes standard Info Cubes DSO and MultiProviders, Aggregates Planning functions Filters Planning Sequence variables classes data base tables
• Development of URM & PNL & Retail Actual and forecasting reports
• Promotion processes such as; Discounts, Bonus Buys, etc.
• Requirements Planning and Allocation: Allocation tables, SAP F&R (Forecasting and Replenishment), Store Replenishment, Requirements Planning for a Distribution Center, and Price Calculation
• Involved in Architect design and validating the design with respect to performance data redundancy and make sure to use of business contact objects as much as possible.
• Design of WAD Templates and queries
• Design and creating of Filters Planning Functions, Planning Sequences and Classes
• Fox Code for generic functions
• Created Generic functions for File Upload.
• Data Slice to lock and unlock the user input report cells.
• Created generic formulas and Classes in SE24 Used different planning functions Copy, Allocation, Distribution, Formula, Forecast Exit Function, Repost, Rounding, Delete.
• Created Global template for uploading of SUBORGS and CALFX Function
• Transports of Planning Function planning Sequences and Table and WEB Templates
• Service Consumption, Mobile Me consumption, Allocation by Default Allocation Overwrite FX Calculation and many other generic functions.
• Process chains to automate consumption process.

SEM BPS

• Gathered information regarding the business requirements from Management and Users to design the overall Layout.
• Creating Planning Layouts with locking mechanism with setting data slice restrict.
• Distribute the overhead cost based on a reference value. Product Group. And planning function to distribute data planned for a year into a monthly plan
• Design and use of Basic & Transactional Info-Cubes for actual / plan data comparison
• Responsible for through data validation using different unit test cases Involved in implementation of SEM-BPS, including conceptualizing and building the Planning areas, Planning Levels, planning packages, planning functions and planning folders relating to Manufacturing cost planning.

• B.E (COMPUTERS)

• SAP BW Business Intelligence Ware House Certified Consultant
• SAP Solution Manager Certified Consultant

Reporting Tools: SAP BW, BO.

GUI: Visual Basic 6.0
Assembly languages: Intel 8086, Intel 8085, pdp-11 programming
Operating System: Ms-DOS, UNIX, Windows ‘95, ‘98, 2000 / NT 4.0

Client

Confidential,USA

Role

SAP Senior Consultant

Duration

Aug 2008 – Till Date

Project

Development

Responsibilities:

SAP BW

• Requirement Gathering from process design owners, Business Groups, Users, Business Blueprint (Identifying Reports, Gap Analysis, Enhancements), Realization (Design & Development of BI objects), Design Play Back, IT, UAT and Post Production Support for FI,CO,SD,MM modules
• Worked on MM inventory and PO intransit process.
• PO and MM data source enhancement
• Developed Real-time Info Cubes standard Info Cubes DSO and MultiProviders.
• Design and development of WAD Templates and queries
• Worked in Data Extraction, Transformation, Staging and Reporting, Testing of Extractors, configuration, transformation rules and Reporting using BEx, Web Application Designer
• Generic data sources design using RS02
• Worked with Query monitor (RSRT) for setting Read modes and enabling OLAP Cache for many queries.
• Troubleshooting issues and follow up with SAP (OSS-Notes)
• Process chains to automate consumption process.
• Worked extensively to debug the existing SAP program and modify the code as per the requirements
• Developed many variable exits
• Created generic formulas and Classes in SE24
• Triggering Process chain from layout and sending mail conformation on completion of job.
• Performance tuning by customizing processing logic and reducing load time.
• Worked with Query monitor (RSRT) for setting Read modes and enabling OLAP Cache for many queries.
• Troubleshooting issues and follow up with SAP (OSS-Notes)
• Process chains to automate consumption process.

BO

• BOBJ integration with BW
• Understand the BW queries and cubes very well to create universes in BO
• Knowledge in Develop Crystal Reports on top of SAP BW design
• Triggering Event from IP layout to download data from BW to Flat File and load data for BO reporting
• Pushing Actuals data from BW to BO by using process chain APD.

SAP IP

• Involved in Unit testing of development objects, prepared test scripts for Integration testing and UAT. Participated in UAT and resolved various issues. Prepared the system for Go-live and involved in Go-live and post Go-live activities
• Created Generic functions for File Upload.
• Development of URM & PNL & Retail Actual and forecasting reports
• Transports of Planning Function planning Sequences and Table and WEB Templates
• Service Consumption, Mobile Me consumption, Allocation by Default Allocation Overwrite FX Calculation and many other generic functions.
• Worked on STS to automate data slice locking and maintained STS for different forecast versions.

Client

Confidential,Boston, USA

Role

BW Data Architect

Duration

Dec 2007 – July 2008

Project

Development

Responsibilities:

• Working as BW Solution Architect
• Involved in Architect design and validating the design with respect to performance data redundancy and make sure to use of business contact objects as much as possible.
• Technical Design spec and functional Design specs, power point presentations, cut over plans.
• Interacting with functional team to finalize the design and approving the same
• Implementation of FSE Stock reports and Aging report functionality
• 2LIS_11_VAITM Sales Order Numbers by order type, Sales Order values by order type, by article or by sales organization
• 2LIS_03_BF Material Movements from Inventory.
• Stock figures (Quantities and values) for normal stock and special stock types (sales stock, project stock).
• Report of all goods issues posted in a certain period (report by movement type)
• Report of all movements for a material in a certain period
• 2LIS_18_I30P Service work order number.
• Operations per service order

Client

Confidential,USA

Role

Duration

(02/2007) – (12/2007)

Project

Development

Responsibilities:

• Worked as Data Architect and Data Analyst for a big implementation project Business
• Process Management Initiative (BPMI) for British Petroleum.
• Define technical and strategic architectures at the conceptual and logical Level Model.
• Analyzed how the data is coming from different source systems understand the requirement.
• Designing of schemas for different databases like informatics, and design with kalido model, and different sources of BP refineries like eCHOCK, PCMS, Resolution Tracker, and Mimosa.
• Requirement gathering and designing of Star Schema and Process Flow in Visio and ER Studio Embarcadero Version 7.1 according to BP standards.
• Prepared Functional specifications, Technical specifications, test plan and end user manual.
• Defined Master data attributes (Navigational and Display)
• Created DSO for staging layer before transferring the DSO contents to the Info Cube.
• Created DSO to stage master data to share it across the different cubes and other Master data objects.
• Created hierarchies.
• Created DTP and Transformation to load the Data in to Cube.
• Performance issue raised during the design has been handled effectively.

SAP IP

• Gathered information regarding the business requirements from Management and Users to design the overall Layout.
• Creating Planning Layouts with locking mechanism with setting data slice restrict.
• Distribute the overhead cost based on a reference value. Product Group. And planning function to distribute data planned for a year into a monthly plan.
• Design of WAD Reports
• Design and use of Basic & Transactional Info-Cubes for actual / plan data comparisons
• Responsible for thorough data validation using different unit test cases.
• Design of Agg Levels, planning functions, Filters, Planning Sequence and folders relating to manufacturing cost planning, Formula Extensions (FOX).
• Created Planning functions in with ABAP and Fox code
• Weekly data distribution, consumption function and repost functions

Client

Confidential

Role

Duration

Mar 2006 – Feb2007

Project

Development and Support

Responsibilities:

• Understand the relationship between BW and SEM.
• Developed technical specification for objects like reports and Cube and ODS And tested Involved in the testing reports and other objects.
• Worked on BEx analyzer and BEx Browser. Developed flexible and configured use of Restricted Key Figures, Exceptions, Currency conversions, Variables, and Queries using Filters in BEx Analyzer.
• Scheduling Daily/Weekly/Monthly data loads.
• Monitored data loads (Flat file and R/3) on daily basis and effectively handled many extraction errors during data load.
• Working with workbooks.
• Used ODS to stage the data before transferring the ODS contents to the Info Cube. Done ODS reporting to give detail level data.
• Developed MultiProviders and did Multireporting.
• Performance tuning using Aggregates, Rollups and Compression and statics.
• Knowledge on Generic extractions, Reporting Agent, Info package Groups and Process Chains.
• Used Reporting Agent tool to schedule reporting functions in the background for Evaluating exceptions and printing queries.
• Troubleshooting data extraction errors using the monitor tool in the administrator workbench.
• Resolving the tickets according to priority based created in the Remedy Tool.
• Participating in the Status meeting with the Client Advising the Client regarding the Performance improvement.

BPS

• Gathered information regarding the business requirements from Management and Users to design the overall Layout.
• Creating Planning Layouts with locking mechanism with setting data slice restrict.
• Understand the relationship between BW and SEM
• Distribute the overhead cost based on a reference value. Product Group. And planning function to distribute data planned for a year into a monthly plan.
• Extensively worked with SEM -BPS statistics to tune BPS performance
• Design and use of Basic & Transactional Info-Cubes for actual / plan data comparisons
• Responsible for thorough data validation using different unit test cases.
• Involved in implementation of SEM-BPS, including conceptualizing and building the Planning areas, Planning Levels, planning packages, planning functions and planning folders relating to Manufacturing cost planning for BPS security authorizations, Formula Extensions (FOX) and hierarchy variables.
• Created global and local planning sequences