SUMMARY:

• Having 10+ years of experience in SAP as BI/BW consultant in various implementation and support projects
• Experience in working with client directly at onsite providing better solutions and ensuring on time delivery
• Lead the team of 9 from onsite and experience on coordinating and work allocation
• Worked as Service Improvement Plans coordinator and proposed more than 9 improvements.
• Created Technical Specs, Functional Specs and Test Cases templates, migrated objects across the landscape
• Expertise in data archiving by analyzing the tables through the program RSDB002
• Involved in implementation and support of BW projects that included data modeling, extraction and report generation
• Expertise in Site Switch activities for both SAP BW and SAP ISU and ECC Systems
• Installation of relevant SAP business content as and when required
• Enhancement of data sources through BADI’s
• Knowledge on accessing Hadoop to HANA DB using smart data access.
• Experienced in loading Master and Transactional Data from SAP - R/3 and Flat Files into BI and BW
• Data Load Management using Info Packages, Creation of Process Chains, and scheduling of Process chains
• Hands on Experience on Delta Cleanup activities during down time
• Worked on EHP6 and EHP7 upgrade testing processes and clearing up delta queues during upgrade
• Proficiency in performing service pack upgrades by analysing side affect notes, testing and deployment.
• Involved in improving both query performance and loading performance by building aggregates, caching and splitting the loads into serial process.
• Expertise in root cause analysis in load failures and providing a permanent fixes thus reducing the support effort.
• Sound knowledge in extending and enhancing Business Content based on requirements.
• Designed and developed Multi-Providers, DataStore Objects, InfoCubes and InfoSets.
• Experience in working with standard and custom InfoCubes, InfoObjects, Info Sources, DSO’s, Multiproviders, Extraction Process (LO Cockpit, and Generic).
• Experience in creating Views, Data Sources in SAP R/3.
• Designed queries in BEx Query Designer and created workbooks in the BEx Analyzer using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables.
• Experience in pushing TRFC's manually from source system to BW System
• Extensive knowledge on LSA, LAS++, composite provider, ADSO and open ODS views using BW modelling tool in HANA studio
• Hands on with creation of attribute views and and analytical views in HANA studio
• Know-how on analyzing partner profile parameters issues with connections to and from BW systems.
• Experience in data visualisation by creation of story boards using SAP Lumira.

TECHNICAL SKILLS:

SAPData Warehousing Tools: Net Weaver - BW/BI 3.5, 7.0, 7.3 and 7.5 with HANA

ERP: ECC 6.0, SAP CRM 7.0 and SAP IS-U

Reporting Tools: BEX Query Designer and BEX Analyzer

Databases: Oracle 9i and IBM 9, HANA DB

Servers: Apache Tomcat 5.0

Operating Systems: Windows - 98 / XP / NT / 2003 EP Server

Ticketing tools: Open Pursuit 6.0, HP Service Manager

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW Consultant

ENVIRONMENT: SAP BI 3.5,7.0, 7.3 and 7.5 with HANA and SAP IS-U 7.1 and SAP CRM

Responsibilities:

• Responsible for all the weekly, monthly, mid year and annual recurring tasks.
• Fixing the load failures, which are notified through UC4 monitoring tool.
• Successfully increased the batch parallel process in DTP thus improvising data loading.
• Analyzed the load failures for the years 2014 and 2015 which was very much well received and appreciated by the client
• Introduced message alerts in Confidential for the load failures, which are triggered manually thus reducing the effort of manual monitoring.
• Created APD s where queries can be used as a data source thus saving the table spaces.
• Worked on reinitializing the data sources during the site switch activities
• Enhanced the standard extractors fetching the data from a different field through BADI s
• Proposed service improvement plans constantly few of them being migration of query variables from CMOD to BADI, setting dependency on BO jobs from BW, work delivery report, cleanup of unnecessary flows
• Created Open hub destinations where the files are generated to AL11 and to datamarts from there on
• Handled tickets with different priority and never missed the SLA.
• Involved in validating data consistency in reporting with data target against PSA and then with the source tables after loading them to the data targets if there is any miss match.
• Design and maintenance of customized Info objects, DSO Objects, Infocubes, Multiproviders, Data Sources, Info packages and DTP s
• Sound Knowledge on SAP BW (powered by HANA) 7.5 on new features like Hybrid Providers, composite providers, transient providers and semantic partitioning.
• Sole responsibility in handling and monitoring data loads, fixing the failures and root cause analysis on BW powered by HANA
• Migrated various 3.X standard and custom extractors during the migration of BW to BW on HANA 7.5
• Hands on experience with testing on migration of 7.3 to BW on HANA 7.5
• Sound knowledge on data archiving and cleansing methodologies using DB02 and program RSDB0002.

Confidential

SAP BI Consultant

ENVIRONMENT: SAP BI 7.0, SAP ECC 6.0, SAP ISU 6.0

Responsibilities:

• Created critical tickets to the basis team due to connection failures (BW to R/3) in the production system.
• Monitoring Daily, Weekly and Monthly data loads by Process Chains and resolving the errors which occurred during data loading.
• Successfully increased the batch parallel process in DTP thus improvising data loading.
• Interacting with the onsite coordinator to analyze and resolve the errors which occurred during data loading.
• Worked on loading of master data and transaction data from SAP R/3 to SAP BW.
• Handled tickets with different priority and never missed the SLA.
• Involved in validating data consistency in reporting with data target against PSA after loading them to the data targets.
• Interacting with the client during the daily status meeting.
• Updating the client on the status of the tickets posted by him and maintaining the history of all the tickets until they are closed down.
• Updating client tracking sheet at the end of the shifts.

Confidential

SAP BI Consultant

ENVIRONMENT: SAP BI 7.0, ECC 6.0

Responsibilities :

• Automated the data uploading through Process Chains.
• Activated Business Content Info Objects, Transformations in alignment with the requirement.
• Loaded Master and Transaction data from SAP R/3 system and non-SAP systems like Flat files into BI system Using Full and INIT loads.
• Creation and Maintenance of Info Cubes, ODS and Multi Providers based on the naming convention.
• Using LO Cockpit, performed necessary procedures like maintained Extract Structures, activated the data sources, filling up of setup tables and Setting up of queued delta Update in SAP R/3 source system.
• Customized Data Sources by enhancing the Extract structure fields as per the client requirement.
• Involved in the data retention like deleting all the PSA data and change log tables data, which are older than 7 days for PSA and 90 days for change log table.
• Changed the properties of info objects from display attributes to navigational attributes as per requirement.
• Created BEx reports by modifying Existing Queries based on User Requirement. Created Variables of type Characteristic values and processing type as User entry/Manual.
• Worked on performance tuning by creating Aggregates, Compression and Partition.
• Created secondary index on active table of the Standard DSO to improve the data load performance.
• Involved in the change management to export the transport requests into production system with the help of the basis team.

Confidential

SAP BI Consultant

ENVIRONMENT: SAP BI 7.0, ECC 6.0

Responsibilities :

• Involved in Process chain monitoring using ST13 T-Code.
• Successfully handled in removing scheduled jobs from process chains.
• Monitoring the info packages and analyzing the reasons for frequent failures of info packages.
• Actively involved in rectification of load failure errors like master data loads and transaction data.
• Involved in performing Delta clean up activity.
• Involved in the down time and clear the delta queue as per the basis team due to patches updating.
• Interacting directly with the client for resolving the errors and for clarifying the queries regarding the tickets posted by them.
• Handled the tickets of priority P1, P2 and P3 by following SOP (Standard Operating Procedures) and never missed the SLA.

Confidential

SAP BW Developer

ENVIRONMENT: SAP BW 3.X, 7.0, ECC 6.0

Responsibilities :

• Creation of Info Objects, Info Cubes, ODS, Info Sources, Application Component, Data Source, Communication Structure, Transfer Structure, Transfer rules, Update rules, Update methods, info packages.
• Installed Business Content as and when required.
• Designed and developed process chains (RSPC) for master data loads and Transaction data Loads with the help of Info packages. And these Process chain are Scheduled for periodic loads.
• Installed Business Content Sales Overview Cube and designed and activated Customer service to meet user needs. Created several ODS objects which acts as data staging. Configured Data sources in R/3 by using LO Cockpit (LBWE) initialized the setup tables.
• Scheduled and Implemented delta mechanism for Periodic loads.
• Worked extensively on Business Content Extractors and Enhanced Data source to add Custom fields for 2LIS 11 VAITM, 2LIS 11 VAHDR.
• Experience in extracting data from SAP R/3 using LO Cockpit, Generic Extractions, Loading (Initial / Delta Up-Loads), and also Extraction with flat files.
• Expertise in creation of reporting using BEx Analyzer such that the execution time is evenly distributed throughout the report by using free characteristics, Restricted Key figures, and Calculated Key figures, Variables, Exceptions.