SAP BI Consultant
AMICO
Total years of experience :11 years, 2 Months
• Involved in upgrading SAP Business Objects from 4.1 SP6 to 4.2 SP7
• Testing all applications and functionalities of all the client tools post upgrade & Developed Web Intelligence reports using Bex Queries
• Creating and updating the dashboards along with maintaining the existing dashboards based on the business requirements involving underlying WEBI Reports and Queries and displaying the updated data in dashboards
• Conducting user interactions to create new development of reports dashboards and storyboards; developing Web Intelligence Reports and Dashboards using QAAWS and passing parameters through dashboard to call detail WebI report
• Designing & implementing best practices for Tableau report development using data blending, filters, parameters, sets & groups
• Converting existing BO reports and Xcelcius dashboards to Tableau
• Creating & maintaining various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Developed Tableau dashboards using maps, bar chart, bar in bar chart, line chart, butterfly & donut charts
• Creating Prompts, customized Calculations, Conditions and Filter Local, Global, Parameters, Groups and sets for various analytical reports and dashboards
• Gaining experience in usage of Dashboard URL actions to get detail report by passing filters from dashboard; developing dashboard by connecting to SharePoint lists
• Assisting users in creating and modifying worksheets and data visualization dashboards
• Developing & enhancing Advanced DSO, Composite Providers, Open ODS views, Data Store Objects, Info Objects, Multi providers, Data Sources based on CDS views
• Developing Calculation views on Eclipse/Hana Studio to consume by Business Objects, Tableau and other third party tools
• Worked on FI - GL, FI-AR, FI- AP, SD, PM data sources for extraction and loading to BI system
• Working on Analysis Office 2.4 and created reports /Input templets according to business requirements
• Configuring Macros to automate the AO workbook
• Expertise in BW/ BI 7.4 (NW 2004S) components like Info cubes, DSO(ODS), Multi-providers, Info sets Transformations, Data Transfer Process, remodelling of the Info Cubes, Data Sources, Data source enhancement, Transfer Rules, Update Rules, PSA, BW Transports, and BI content
• Implemented and maintained SAP Business Objects Business Intelligence Platform 4.2 SP04 along with Client Tools in Production Environment
• Conducted Impact Analysis and Development of migration plan for SAP BI 4.2 upgrade; updated SAP Business Objects Business Intelligence Platform from version 4.1 SP06 to 4.2 SP04 in Development Environment
• Worked on the upgradation of TOMCAT server on SAP Business Objects Business Intelligence Platform 4.1SP06 from version 7.0.55 to 8.5.13 to eliminate security issues
• Integrated & migrated reports from UDT to IDT; designed & developed WEBI reports using WEBI 4.1 and WEBI 4.2
• Gathered the required information and generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning
• Worked on & utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Involved in SAP Business Objects Business Intelligence Platform End To End Implementation.
• Involved in SAP Net Weaver 7.4 End To End Implementation.
• Created Generic Data Source for the Actual data which is based on the View as per the requirement.
• Involved in creating and maintaining Info Cubes, Data Store Objects, PSA, Info Objects, Info Areas, Multi providers, Info Sources, Data Sources, and Info Packages
• Activation and Enhancement of standard data sources related to FI, HR, SD, MM and Solution Manager.
• Created custom queries using Conditions, Variables, Structures, and Calculated Key Figures.
• Preparing detailed Technical Specification for the Data flow, Data Marts and Reports based on the requirement.
• Daily trouble shooting of Incidents, Implementing changes and requests.
• Created ABAP Queries.
• Created ABAP Function Modules.
• Created data source for data loading from Flat files
• Created Universe based on SAP data source using Information Designer tool (IDT).
• Created complex dashboards on Bex Queries using Query Browser in Dash board designer 4.0
• Created Dashboards Using Live Office
• Created Web Intelligence Reports using Variables, Breaks, Sections, Ranking, Sorting, Drill down, Slice and Dice.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Experience in CMC (Central Management Console) Administration activities like Scheduling, creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server.
• Monitoring of Background Jobs.
Name of University: JNTU University Location: Hyderabad Type of Degree: Bachelors In Technology Field of Study: Electrical and Electronics Graduation Year: 2013 (Attended From/Batch Of: 2008 to 2012)