SUMMARY

• Meticulous experience of 10 years in IT industry as a SAP Senior BI/BW Consultant in software Gathered business requirements, Design, Analysis, Coding, Development, Enhancements, Cutover and Testing with specialization in Warehousing techniques including data extraction, transformation and loading.
• Experience in Five complete life cycle implementations in various industries for SD, MM, PP, HR, CO - PA, FI-CO, CO, PS and APO and followed ASAP methodology.
• Expertise with Multi-Dimensional Model and Star Schema in SAP BW and Administration of BI/BW development Workbench (RSA1).
• Involved in SAP Integrated Planning with SAP Netweaver BI 7.0.
• Interacted with the client and expertise on enhancements and cut-over of SAP ECC 6.0 modules like Logistics(SD,MM,PP) & as well as the ECC Upgrade Cutover.
• Involved in creating Info Cubes and master data info objects using DTP (Data Transfer Process) and types of DTP’s i.e. Standard DTP, Error DTP.
• Designed and created Info Objects, Info Cubes, ODS/DSO Objects, Info Sets, Multiproviders, Datasources, Infosources, Process Chains, Transfer Rules, Update Rules, transformations, data transfer process.
• BEx Query Designer (Restricted Key Figures, Calculated Key Figures, Formulas, Exception Aggregation, Formula Variables, etc…), BEx Analyzer, Views and Work Books.
• Worked on Data Modeling, Data Staging, Data Extraction and using LO Cockpit, Generic Extractor and extraction from non-SAP sources using Flat Files.
• Knowledge on types of Routines i.e. Start Routine, End Routine, Expert Routine.
• Involved in Migrating the Objects from BW 3.x to BI 7.0.
• Involved in the upgrade of Enhancement Packs(EHP4) & Support Packages. Taking care of the BI system of Pre & Post upgrade of Support Pack & Enhancement Packs.
• Expertise in Datasource Enhancement, Generic DataSource using Function Modules, Business Content, User Exits, Scheduling, Monitoring, Process Chain, InfoSource, MultiProvider, InfoSet, InfoCube, DSO/ODS and Open Hub Service.
• Extensive experience in Modeling, Data Extraction Transformation and Data Loading (ETL), Reporting, Web Application Designer (WAD), Portal Reports, Analysis Process Designer (APD), Web Templates, Information Broadcasting and Integrated Planning (IP).
• Experience on Data Modeling, Data Staging & involved in creation of Multi providers.
• Worked on WEBI Adhoc Templates in BO.
• Created Process Chains, scheduling delta loads, monitoring data loads, PSA maintenance and de-bugging/rectification of data load errors.
• Performance Tuning in BI/BW by creating Aggregates for frequently used queries and Compression on InfoCubes.
• Having Knowledge on BPC Concepts.
• Experienced in providing training to the users and coordinating cross-functional teams.
• Experienced in creating system and User documentation as per the business requirements.

TECHNICAL SKILLS

Operating Systems: WINDOWS 98/2000/XP

Data Ware Housing Tools: SAP BI 7.0 in Nw2004’s, BI with IP, BW 3.5.

ERP: SAP R/3 4.6 and ECC 6.0.

DBMS: ORACLE

Reporting Tools: BEx, WAD

PROFESSIONAL EXPERIENCE

Confidential, NewYork, NY

SAP BI/BO Consultant

Responsibilities:

• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• As part of Information Consumer Layer making changes as per the user requirements and designed BEx Reports providing for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.
• Taken care of Broadcasting of BEx Queries.
• Sending BI report data to a shared folder using BO.
• Worked on WEBI Adhoc Templates.

Environment: (Development): SAP-BI 7.0, SAP BO, ECC 6.0, ABAP/4 & MM

Confidential

SAP BI Lead Consultant

Responsibilities:

• Design and analysis - Work with users to identify and advise on existing info structures updated by business events in R/3. Identify potential solutions, implement enhancements to existing functionality.
• Worked on Logistics Cockpit and extracted data with V3 updates. The data included MM, PP & CO Extractions.
• Taken Care of the Pre & Post Cutover activities for the data of MM & PP.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Involved in the Basis (performance, clearing the tRFC’s) and Security (provided the role name to assign to the users, checking the user authorizations and roles) issues.
• Involved in taking the responsibility of the development till the go-live of the reports.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• As part of Information Consumer Layer making changes as per the user requirements and designed BEx Reports providing for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.
• Involved in creating Start Routines & End Routines as per the Business requirement.
• Analyzed, Designed, development, coding and implemented multiple DSO, BW infocubes and multi-providers
• Using Real Time Cubes in Integrated Planning, Created Aggregation Levels and the reports for planning cubes.
• Added new infoobjects using Remodelling concept and involved in creating Process Chains.
• Using BEx broadcaster, distributed the customized reports by region and exported to the Enterprise portal.
• Scheduled and Automated data loads from R/3 to BI and optimized the load performance by creating Aggregates.
• Transported Objects of cubes from Development to Quality for Testing and Production System during Cut-Over Phase.
• Created Web Templates and Web reports using WAD.
• Created and Maintained Info Cubes using RSA1(T-Code), Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources, Transformations, Data transfer Process and Info Packages.
• Scheduled the Web Templates to make the InfoCubes data Available to the Portal Reports.
• Involved in Training the end users on BEx Queries and customer support to schedule the process chains.
• Working with reports in the PP and Master Data areas. Examples: PP: Confirmed Hours Actual vs. Plan, Put to Stock Actual vs. Plan, Component Usage, Process Order Confirmations (Process order phase confirmations) MD: Master Recipe Reports, Material Master Reports.

Environment: (Development): SAP-BI 7.0, ECC 6.0, ABAP/4, MM, PP & CO

Confidential

SAP BI Lead Consultant

Responsibilities:

• Design and analysis - Work with users to identify and advise on existing info structures updated by business events in R/3. Identify potential solutions, implement enhancements to existing functionality.
• Worked on Logistics Cockpit and extracted data with V3 updates. The data included MM, PP & FI-CO Extractions.
• Having Knowledge on the BPC Concepts.
• Taken Care of the Pre & Post Cutover activities for the data of MM & PP.
• Involved in taking the responsibility of the development till the go-live of the reports.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Involved in the Basis (performance, clearing the tRFC’s) and Security (provided the role name to assign to the users, checking the user authorizations and roles) issues.
• As part of Information Consumer Layer making changes as per the user requirements and designed BEx Reports providing for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.
• Involved in creating Start Routines & End Routines as per the Business requirement.
• Analyzed, Designed, development, coding and implemented multiple DSO, BW infocubes and multi-providers
• Using Real Time Cubes in Integrated Planning, Created Aggregation Levels and the reports for planning cubes.
• Added new infoobjects using Remodelling concept and involved in creating Process Chains.
• Using BEx broadcaster, distributed the customized reports by region and exported to the Enterprise portal.
• Scheduled and Automated data loads from R/3 to BI and optimized the load performance by creating Aggregates.
• Involved in the upgrade of Enhancement Packs(EHP4) & Support Packages. Taking care of the BI system of Pre & Post upgrade of Support Pack & Enhancement Pack Upgrade.
• Transported Objects of cubes from Development to Quality for Testing and Production System during Cut-Over Phase.
• Created Web Templates and Web reports using WAD.
• Created and Maintained Info Cubes using RSA1(T-Code), Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources, Transformations, Data transfer Process and Info Packages.
• Scheduled the Web Templates to make the InfoCubes data Available to the Portal Reports.
• Involved in Training the end users on BEx Queries and customer support to schedule the process chains.

Environment: (Development): SAP-BI 7.0, ECC 6.0, ABAP/4, MM, PP & FI-CO

Confidential

SAP BI Consultant

Responsibilities:

• Design and analysis - Work with users to identify and advise on existing info structures updated by business events in R/3. Identify potential solutions, implement enhancements to existing functionality.
• Worked on Logistics Cockpit and extracted data with V3 updates. The data included SD Orders, Billing, PS & CO-PA Extraction.
• Taken Care of the Pre & Post Cutover activities for the data of SD Orders & Billing.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Involved in the Basis (performance, clearing the tRFC’s) and Security (provided the role name to assign to the users, checking the user authorizations and roles) issues.
• As part of Information Consumer Layer making changes as per the user requirements and designed BEx Reports providing for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.
• Created Open Hub Destinations for sending the data to 3rd Party tool Metreo.
• Involved in creating Start Routines & End Routines as per the Business requirement.
• Analyzed, Designed, development, coding and implemented multiple DSO, BW infocubes and multi-providers.
• Scheduled the Web Templates to make the InfoCubes data Available to the Portal Reports.
• Involved in Training the end users on BEx Queries and customer support to schedule the process chains.
• Transported Objects of cubes from Development to Quality for Testing and Production System during Cut-Over Phase.
• Created Web Templates and Web reports using WAD.
• Using Real Time Cubes in Integrated Planning, Created Aggregation Levels and the reports for planning cubes.
• Added new infoobjects using Remodelling concept and involved in creating Process Chains.
• Using BEx broadcaster, distributed the customized reports by region and exported to the Enterprise portal.
• Involved in taking the responsibility of the development till the go-live of the reports.
• Scheduled and Automated data loads from R/3 to BI and optimized the load performance by creating Aggregates.
• Created and Maintained Info Cubes using RSA1(T-Code), Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources, Transformations, Data transfer Process and Info Packages.

Environment: (Development): SAP-BI 7.0, ECC 6.0, ABAP/4, SD, PS, CO-PA

Confidential

SAP BI Consultant

Responsibilities:

• Involved in Upgradation of the System from BW 3.5 to BI 7.0
• Taken care of Pre Upgrade and Post Upgrade steps.
• Solved the issues after upgrade by following the OSS Notes.
• Involved in the authorization concepts after upgrade.
• Migrated the objects to BI 7.0 and loaded the data using DTP.
• Created the Queries in the new BI 7.0 functionality and enhancing the reports.
• Taken care of BI System at the time of ECC Upgrade. Involved in the upgrade of Enhancement Packs(EHP4) & Support Packages. Taking care of the BI system of Pre & Post upgrade of Support Pack & Enhancement Packs.
• Involved in testing phase of the new concepts like IP, Remodelling, Repartioning.
• Repairing the objects if any inconsistency using RSRV.
• Transported the objects before the upgrade to syncup the systems.
• Involved in the refresh of the BI Quality & R/3 Quality systems as part of BI Testing.
• Created Process Chains for the cutover of BI Upgrade & ECC upgrade to pull the delta loads.
• Involved in taking the responsibility of the development till the go-live of the reports.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Involved in the Basis (performance, clearing the tRFC’s) and Security (provided the role name to assign to the users, checking the user authorizations and roles) issues.
• Scheduled and Automated data loads from R/3 to BI and optimized the load performance by creating Aggregates.
• Involved in Training the end users on the new functionalities of BEx Queries.
• Creating & deleting the indexes before & after Upgrade, checking the consistency of the Infoproviders, InfoObjects & Queries.
• Transported Objects of cubes from Development to Quality for Testing and Production System during Cut-Over Phase.

Environment: (Upgrade): SAP-BI 7.0, ECC 6.0, ABAP/4

Confidential, Waterford, NY

SAP BI Lead Consultant

Responsibilities:

• Handled the cases of priorities Normal, Urgent and BC (Business Critical).
• Taken initiative Ownership of the case and keep posting the updates of the case to the users till it satisfies the Client and User requirements.
• Involved in both the Activities monitoring and Production Support.
• Fix the identified problems, make necessary break fixes/enhancements in the development system and transport them to Production.
• Upgraded, enhanced and supported activities from BW 3.5 to BI 7.0 in Nw2004’s.
• Supported the client by providing long-term solutions to the tickets by doing Root Cause Analysis.
• Prepared Factory Calendars to schedule the jobs.
• Automated the Process Chains and creating alert messages for the process in the Process Chain.
• Involved in Enhancements and validating reports in EP (Enterprise Portal).
• Maintain list of all the activities for all the tickets until it is closed down.
• Extracting required data from the Data Source of PSA to ODS
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.

Environment: (Upgrade & Production Support): SAP-BI7.0, ABAP/4, ECC6.0

Confidential, Waterford, NY

SAP BI Consultant

Responsibilities:

• Handled the cases of priorities Normal, Urgent and BC (Business Critical).
• Taken initiative Ownership of the case and keep posting the updates of the case to the users till it satisfies the Client and User requirements.
• Involved in both the Activities monitoring and Production Support.
• Fix the identified problems, make necessary break fixes/enhancements in the development system and transport them to Production.
• Upgraded, enhanced and supported activities from BW 3.5 to BI 7.0 in Nw2004’s.
• Supported the client by providing long-term solutions to the tickets by doing Root Cause Analysis.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Create OSS Notes, investigate and follow up with SAP.
• Monitor daily, weekly, monthly data loads on SAP BW Production systems. BW daily jobs consist of loading data into BW and extracts from BW using Info Spokes and RSCRM REPORT.
• Worked with Redwood Cronacle (Monitoring Tool).
• Prepared Factory Calendars to schedule the jobs.
• Automated the Process Chains and creating alert messages for the process in the Process Chain.
• Involved in Enhancements and validating reports in EP (Enterprise Portal).
• Maintain list of all the activities for all the tickets until it is closed down.
• Extracting required data from the Data Source of PSA to ODS
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.

Environment: (Production Support): SAP-BI7.0, SAP-BW3.5, ABAP/4, ECC6.0, APO

Confidential, Chicago, IL

SAP BW Consultant

Responsibilities:

• Taken initiative Ownership of the case and keep posting the updates of the case to the users till it satisfies the Client and User requirements.
• Involved in both the Activities monitoring and Production Support.
• Fix the identified problems, make necessary break fixes/enhancements in the development system and transport them to Production.
• Upgraded, enhanced and supported activities from BW 3.5 to BI 7.0 in Nw2004’s.
• Supported the client by providing long-term solutions to the tickets by doing Root Cause Analysis.
• Automated the Process Chains and creating alert messages for the process in the Process Chain.
• Involved in Enhancements and validating of reports in EP.
• Handled the cases of priorities Normal, Urgent and BC (Business Critical).
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Create OSS Notes, investigate and follow up with SAP.
• Monitor daily, weekly, monthly data loads on SAP BW Production systems. BW daily jobs consist of loading data into BW and extracts from BW using Info.
• Enhanced/Maintained Info Cubes, Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources, Transformations, Data transfer Process and Info Packages as per the Business requirement.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Improved performance by creating Aggregates, Compressions, Partitions and Indexes using BW statistics and repaired the objects if any inconsistency using RSRV.

Environment: (Production Support): SAP-BI7.0, SAP-BW3.5 ABAP/4, ECC6.0

Confidential

SAP BW Consultant

Responsibilities:

• Taken initiative Ownership of the case and keep posting the updates of the case to the users till it satisfies the Client and User requirements.
• Involved in both the Activities monitoring and Production Support.
• Fix the identified problems, make necessary break fixes/enhancements in the development system and transport them to Production.
• Supported the client by providing long-term solutions to the tickets by doing Root Cause Analysis.
• Automated the Process Chains and creating alert messages for the process in the Process Chain.
• Involved in Enhancements and validating of reports in EP.
• Handled the cases of priorities Normal, Urgent and BC (Business Critical).
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Create OSS Notes, investigate and follow up with SAP.
• Monitor daily, weekly, monthly data loads on SAP BW Production systems. BW daily jobs consist of loading data into BW and extracts from BW using Info.
• Enhanced/Maintained Info Cubes, Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources and Info Packages as per the Business requirement.
• Created process chains for data loading, delta uploading and periodical PSA deletion.

Environment: (Production Support): SAP-BW3.5 ABAP/4, ECC6.0