SAP Consultant

• Oct 2019 - Present

Intern-MSBI

• Sep 2017 - Apr 2018

• Involved in the ETL phase of the project and getting data from different data sources. • Creating a package with the given requirement and tested details • We are following agile life cycle and top down approach. • Used script component, script task, for each loop enumerator, execute package task and data flow task • Document the business process by identifying the requirements • Creating separate database and table • Creating a new project, package and Variables, Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio. • using file system task to move or create processed or error files and folders. • Using different transformations like derived column, OLEDB Destination, Data Conversion, excel source • Execution, Deployment and Scheduling Show less

SAP BI Consultant

• May 2012 - Jan 2015

• Support played a major role in delivering and supporting the incidents in huge complex environment. Has closely worked with client counter parts. • Work Orders played an important role in Enhancing and developing new applications which require data model change/re- design till query level, involved in understanding the business and provided the solutions according to client requirements. • Data Load –Was actively involved in overall functioning of data load team of 5 members. Providing 24/7 support, performance optimization, identifying possible areas to reduce data load time was key objective of data load project. Regular monitoring and sending updates was part of this project. Also, involved in BIA upkeep, troubleshooting and checking ACR conflicts. • Upgrade – Supported in upgrade process from BI 7.0 to BI7.3. Worked along with SAP and different vendors in identifying and resolving issues. • Consolidation – Involved in SLO (System Landscape Optimization) testing. • Worked on creating Aggregates, compressing InfoCubes, creating Indexes, MultiCubes and process chains. • Developed real time Infocubes for IP Planning. • Designed and developed Info Objects, Info Providers, Aggregation Levels, Filters, Planning Functions, and Planning Sequences. • Configured and involved in troubleshooting custom IP applications using the BEx toolset including BEx Query Designer, BEx Analyzer, and BEx Web Application Designer • Involved in 24x7 Production Support. • Daily trouble shooting of Incidents, Implementing changes and requests &Involved in submitting the Ticket Status (open/close) report. • Maintain Work History for all the Tickets until it is closed down. • Created Crystal Reports using SAP BW Queries. • Created OLAP Conn for SAP BW Queries to create Crystal Reports & Explorer Dashboards. • Created ROLAP Universe using SAP BW Info providers. Show less

SAP BI Consultant

• Jul 2009 - May 2012

•Support played a major role in delivering and supporting the incidents in huge complex environment. Has closely worked with client counter parts. •\Work Orders played an important role in Enhancing and developing new applications which require data model change/re- design till query level, involved in understanding the business and provided the solutions according to client requirements. •Data Load –Was actively involved in overall functioning of data load team of 5 members. Providing 24/7 support, performance optimization, identifying possible areas to reduce data load time was key objective of data load project. Regular monitoring and sending updates was part of this project. Also, involved in BIA upkeep, troubleshooting and checking ACR conflicts. •Upgrade – Supported in upgrade process from BI 7.0 to BI7.3. Worked along with SAP and different vendors in identifying and resolving issues. •Consolidation – Involved in SLO (System Landscape Optimization) testing. •Worked on creating Aggregates, compressing InfoCubes, creating Indexes, MultiCubes and process chains. •Developed real time Infocubes for IP Planning. •Designed and developed Info Objects, Info Providers, Aggregation Levels, Filters, Planning Functions, and Planning Sequences. •Configured and involved in troubleshooting custom IP applications using the BEx toolset including BEx Query Designer, BEx Analyzer, and BEx Web Application Designer •Daily trouble shooting of Incidents, Implementing changes and requests &Involved in submitting the Ticket Status (open/close) report. •Created Crystal Reports using SAP BW Queries. •Created OLAP Conn for SAP BW Queries to create Crystal Reports & Explorer Dashboards. •Created ROLAP Universe using SAP BW Info providers. •Involved in escalating high-prioritized tickets regarding extractions, performance issues and also loads failures. •Maintaining Reconciliation's to verify the data in SAP R/3 and SAP BW are same or not after the data loads. Show less