PROFESSIONAL PROFILE:

• Meticulous experience of 10 years in IT industry as a Senior SAP BI/BW, BO, IP, ABAP, BPC 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.
• SAP BI 7.0 and IP Implementation and support project experience.
• Having Knowledge on SAP BPC NW 7.0 and 7.3 concepts.
• 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.
• Experienced in providing training to the users and coordinating cross-functional teams.
• Experienced in creating system and User documentation as per the business requirements.

ACCOMPLISHMENTS:

Confidential

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.
• Taken care of employee details and the working hours as part of HR data.
• Built Planning Layouts for the Users to enter their Hours Worked as part of HR data.
• Sending BI report data to a shared folder using BO.
• Worked on WEBI Adhoc Templates.
• Upgrading the system from SAP BI 7.0 to SAP BI 7.3.

Environment Development : SAP-BI 7.0, SAP BI 7.3, SAP BO, ECC 6.0, HR 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 HR, MM, PP FI-CO Extractions.
• Having knowledge in BPC concepts such as Application Sets, Dimensions, Dimension Property, Dimension Hierarchy, Script Logic, BADI, EVDRE Functions, Data manager package and reporting.
• 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. Taken 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, BPC, HR, 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

Project5

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

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

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

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