SUMMARY

• B - Tech professional with total over 3.3years of experience in IT with 3.2 years of experience in SAP-BW/BI for Extraction, Modeling and Reporting.
• Currently working with Confidential as SAP BW/BI Consultant for British Petroleum Project
• Experience in Data loading, Monitoring and Scheduling using Process Chain
• Extensively worked on designing/creating Info Objects, Info Sources, Transfer Structures, Communication structures, Standard and Custom Info Cubes, Data Store Object (DSO)
• Adept in end-to-end development of products from requirement analysis to system study, designing, coding testing, de-bugging and writing technical documentation for scripts / tools
• An excellent team player as well as an individual contributor with good communication and interpersonal skills
• Quick learner and stronger desire to master in new technologies
• Received best performance certification from Client

TECHNICAL SKILLS

• SAP BI, BO ( BO Analysis ) - Analysing and Handling of issues
• BeX and BI Analyzer - Deveoped Queries, Workbooks as per business requirement
• Database SQL Server 2000/05
• Trained in BW362 course for BW on HANA .

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/BI Consultant

Responsibilities:

• Enhancing the data sources based on the business requirement.
• Worked on Transport Mechanism for transporting objects from Development to quality and Production with Change management team.
• Created standard and custom reports using Query Designer by incorporating all the features available in BI/BW 7.3
• Created Reports using CKF & RKF by implementing all the new features available in BI/BW7.3
• Data extraction from Flat files, loading data into Info objects, DSOs and Info Cubes.
• Worked on Infocubes, DSOs, Multiproviders based on the reporting requirements.
• Created Transformations between Data Sources and DSOs, DSOs and Info Cube.
• Managing data in Info Cubes including request management in Info Cubes, performance management through compression and Rolling up data to the aggregates.
• Supported client by working on the incidents raised through Remedy Tool regarding the data loads, broadcast, advices, data mismatch, report issues.
• Successfully coordinated with the onsite team and client regarding various business clarifications.
• Performed Delta Queue clearing activities before system refresh and upgrade and cut over activities in coordination with Basis Team.
• Coordinated with other teams which are source or target systems and communicated and resolved the issues faced.
• Proposed workarounds and possible nearby solutions before the client approached.
• Involved in Regression Testing and Issue handling and documentation of the results in QC Tool.

Confidential

SAP BW/BI Consultant

Responsibilities:

• Have involved in the SAP system Pre-and Post-patching activities from BW perspective.
• Estimate the system performance and functionality of the system by testing various data loads.
• Validating the functionality of the objects across the system landscape in both Pre-and Post-system patching by provides the valid inputs.
• Analyze and Fix the issues that encountered in the system Post patching.
• For critical issues have coordinated with SAP by raising OSS messages and analyzed the SAP Notes that been suggested by SAP.
• Coordinating with Basis team and involved in the Patching cutover activities like Delta queue clearance, System basic functional validations.
• Defects has been raised in ALM tool if any issues and coordinating with concerned team to expedite resolving of the issue.

Confidential

SAP BW/BI Consultant

Responsibilities:

• Actively involved in the discussions on change requirements and create Functional specifications and Technical specifications.
• Estimate the amount of effort and time involved for responsible change requests.
• Carry out the technical changes and transport them across systems.
• Have involved in Creating BW on Hana objects e.g. ADSO’s.
• Responsible for developer role.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Responsible for requirement gathering, developing, testing and delivery of objects like Data source, Transformation, Info package, DTP, Info objects, DSO, Info cubes, Open Hub, Multi Provider, Query, Workbook and Process chain.
• Responsible for MRT, Testing of patches and Refresh activities
• Responsible for Quarter and Year end Release activities, effective and timely communication to Business, reporting of release issues or concerns to Management and Business
• Responsible for Handling EWA report by understanding and analysing areas to improve to make sure EWA report is not turning to red
• Taking care of BW issues raised by business
• Ticket handling through Remedy tool
• Responsible for effective communication to the customer.
• Guiding load monitoring team for effective monitoring of system
• Responsible for MRT and update in ALM tool
• Developed Data sources, transformation, Info-packages, DTP to add fields as per the requirement of users for Auditing and checking the data comparison in the report.
• As requested by User we have added the following fields into Rows of (ZXFSLM60 Q019) report.
• 2. Worked on enhancement to correct the invalid character issue for the Document header text
• Involved in requirement Gathering, FS, TS, Designing of Info Cubes & DSO's
• Build, Unit Testing, Defect Fixing as part of UAT, Handled Cutover activities, Hypercare Support
• Providing KT for the Support Team
• End-User Training
• Apllication Areas: SD (Sales Orders, Contracts, Nominations),
• MM (Inventory Management, Purchasing), FI (FI-GL, AR,AP,AA)
• Bex Reports - with Variables (Replacement Path, Customer Exit), .....
• As part of the build involved in installing Business Content objects and customized the same by creating a copy objects.
• As part of unit testing involved in preparing test case, test script, Test Documents.
• Implemented LSA by building dataflows with DSO's (Standard & Write Optimized) and Info Cubes, Multiprovider, Complex Transformations using (start Routine, End Routine, Expert Routine)
• Built provcess chains for Batch scheduling of data loads.
• Extracted data from SAP & legacy systems using SAP Connections, DB Connect, Flat file Interfaces, External System BAPI
• Configured Information broadcasting Setting to distribute the BEx Queries & Workbooks to Email & portal.
• Involved in handling query performance strategies using Compression, Aggregates, DB Statistics, Indices.
• As part of ECC extraction involved with LO Cockpit & Generic Extractors based on Table, View, Function Module and also cutomized the standard extractors using enhancement RSAP0001.

Confidential

SAP BW/BI Consultant

Responsibilities:

• Data Load monitoring and resolving issues immediately.
• If any delay in the data loads, update the status to business at proper time.
• Worked on many data drop and reload activities to delete the data from various data targets in BI and again loading the data from source.
• Execution of Reconciliation reports to compare data between Source system against BI and data targets within BI system and tested thoroughly, corrected all the issues which is crucial for day today activities for client.
• Created many Process chains as per user requirements.
• Worked on Error DTP's and corrected DTP load failures by editing the records at error stack and by running the error DTP's.
• Recovered the failures in Info package loads, DTP loads, DSO activations failures and attribute change run failures which are happened in my project.
• Worked on BIA (BI Accelerators), building BIA index, filling the same. Also resolved some of the BWA alerts which includes performing the BIA re org to correct corrupted indexes.
• Actively participated in every quarter end closure and worked in all shifts in these period and thus helped team in all types of emergency situation.