Created Prototypes Lumira application in production system in Lumira 2.1

· Developed Header composite to accommodate Dashboard titles, Bookmarks, Personalization and Export Options.

· Working in Agile wall methodology by using R-Board (Record, Realise, Refine, Release, Retire) to deliver the Dashboard.

· Implemented conditional formatting in BEx and Lumira application for Dimension Hierarchies.

· Implemented CSS for Cross tab, Tab stripand other components. And created Global script to reuse the BIAL script function throughout the application.

· Conducted training session for Business users in Lumira Discovery. And given training in Lumira designer in the Team member for cross skilling.

Client GlaxoSmithKlineEnvironment SAP Business Objects 4.2 SP5/Lumira 2.1 SP2/Webi 4.2/Analysis for Office/BW/Power BIDuration June2018 – till dateRole SAP BO Lumira ConsultantGlaxoSmithKline plc is a British pharmaceutical company headquartered in Brentford, London. Established in 2000 bya merger of Glaxo Welcome and SmithKline Beecham, GSK was the worlds sixth largest pharmaceutical company asof 2015Responsibilities:Created Prototypes Lumira application in production system in Lumira 2.1Developed Header composite to accommodate Dashboard titles, Bookmarks, Personalization and ExportOptions.Working in Agile wall methodology by using R-Board (Record, Realise, Refine, Release, Retire) to deliver theDashboard.Implemented conditional formatting in BEx and Lumira application for Dimension Hierarchies.Implemented CSS for Cross tab, Tab stripand other components. And created Global script to reuse the BIALscript function throughout the application.Conducted training session for Business users in Lumira Discovery. And given training in Lumira designer in theTeam member for cross skilling.Implemented Bookmark security in CMC though global and personal folder ids to restrict the data for specificusers.Created and Road map document, Data limitation document for Lumira discovery and Designer.Worked on Custom Visualizations like multi slicer and Hierarchy slicer.Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.Created New Calculated Column and Measure using DAX Expression.Worked on the Power Bi reports & dashboards with SAP BW and Excel.Published/shared the reports by creating Content Pack/Sharing the pbix file.

Client AllerganEnvironment SAP Business Objects 4.2 SP2/Webi 4.2/SAP BO Live Office Excel/PPT/Oracle/SQL/PowerBIDuration Jan2018– till dateRole SAP BO ConsultantAllergan, Plc is a multi-national pharmaceutical that produces branded and generic drugs, and performs pharmaceuticalresearch and development. It was formed on February 18, 2015, when the company formerly known as Actavis, Plcchanged its name. This was completed as of June 15, 2015. Actavis, Plc then became Actavis which now forms theAmerican Generics division of the company.Responsibilities:Creating the POCs in Power BI to implement new dashboards and migrating the webi report dashboards.Working on Universe Design and Development in IDT, Creating the publishing and scheduling the Reports.Involved in Report bursting for Personalizing and distributing documents using CMCResolve data mismatch issues that are raised from end users.As the per user requirement develop the queries using SQL Developer tool and SQL Management Studio andadd in the output in Excel like adhoc reportsCreating the Live office Excel/PPT reports from the webi reports on monthly basis by manually andautomaticallyCreating Webi reports with multiple queries, using functions, merging dimensions at report level, drill down,drill up, drill across, filters.Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font,colors, etcCreated Webi Reports/Universe Excel as data source, by writing SQL Queries for Derived tables in the universeas per the Functional Specifications.Used joins concept by taking different tables from different data sources in the Universe.

Working on Design Studio Dashboards and Webi Reports with a different visualization and layouts using different customized cascade style sheets.

· Archius 3.0 - Chart Plus third party SDK components are being used for creating Dashboards for more visualizations and look and feel.

· Working on Universe Design and Development in IDT, Creating the publishing and scheduling the Reports.

· Developing Executive, Responsive, Interactive and Navigation Dashboards using Design studio 1.6 sp5/Lumira 2.0

· Working on improve the performance of the Dashboards like data source property of processing group and Load in script.

· Created Dashboards using HANA views and Universe as Datasources.

· Created more global functions with return and without return to reuse the functionality throughout the dashboard.

Client 3M CompanyEnvironment SAP BO Design Studio 1.6 SP5/Lumira 2.0(Discovery & Designer /Webi 4.2/SAP BO4.1/4.2/SAP HANA 1.0Duration Dec2017 – till dateRole SAP BO ConsultantThe 3M Company, formerly known as the Minnesota Mining and Manufacturing Company, is an American multinationalconglomerate corporation based in Maplewood, Minnesota. produces more than 55,000 products,including: adhesives, abrasives, laminates, passive fire protection, personal protective equipment, dental and interiorand the under chassis rust protection),[3] electronic circuits, healthcare software and optical films.[4] 3M has operationsin more than 65 countries including 29 international companies with manufacturing operations and 35 companies withlaboratories. 3M products are available for purchase through distributors and retailers, and online directly from thecompany.Responsibilities:Working on Design Studio Dashboards and Webi Reports with a different visualization and layouts usingdifferent customized cascade style sheets.Archius 3.0 - Chart Plus third party SDK components are being used for creating Dashboards for morevisualizations and look and feel.Working on Universe Design and Development in IDT, Creating the publishing and scheduling the Reports.Developing Executive, Responsive, Interactive and Navigation Dashboards using Design studio 1.6 sp5/Lumira2.0Working on improve the performance of the Dashboards like data source property of processing group andLoad in script.Created Dashboards using HANA views and Universe as Datasources.Created more global functions with return and without return to reuse the functionality throughout thedashboard.Worked on Bookmarks, Dynamic visibility of the components like Charts/Cross tab. Implemented Dimensionfilter, Filter line component to apply filter on Dashboard for the end users.Creating Webi reports with multiple queries, using functions, merging dimensions at report level, drill down,drill up, drill across, filters.Testing the Dashboards and Webi Reports with backend Data by Developing Test scripts.

Working on redeveloping Webi reports to Design studio with a different User Interface using different customized cascade style sheets.

· Developing promotional Dashboard for both mobile and IPod using Design studio 1.6 sp2.

· Worked on improving the performance of the Dashboards like data source property of processing group and Load in script.

· Analysed time consuming areas for dashboard by using "profiling" option in local mode.

· Created more global functions with return and without return to reuse the functionality throughout the dashboard.

· Creating Webi reports with multiple queries, using functions, merging dimensions at report level, drill down, drill up, drill across, filters.

· Established BICS connectivity between SAP BW to BO 4.1 Environment

Client Estee Lauder Company, US/UKEnvironment SAP BO Design Studio 1.6 SP2/Webi/SAP BW 7.3/SAP HANA/SAP BO 4.1Duration Jan 2017 – Jun 2017Role SAP BO ConsultantThe Estée Lauder Companies Inc.is an American manufacturer and marketer of prestige skincare, makeup, fragrance andhair care products. The company owns a diverse portfolio of labels, distributed internationally in up-market departmentstores, and has its headquarters in Midtown Manhattan, New York City.Responsibilities:Working on redeveloping Webi reports to Design studio with a different User Interface using differentcustomized cascade style sheets.Developing promotional Dashboard for both mobile and IPod using Design studio 1.6 sp2.Worked on improving the performance of the Dashboards like data source property of processing group andLoad in script.Analysed time consuming areas for dashboard by using profiling option in local mode.Created more global functions with return and without return to reuse the functionality throughout thedashboard.Creating Webi reports with multiple queries, using functions, merging dimensions at report level, drill down,drill up, drill across, filters.Established BICS connectivity between SAP BW to BO 4.1 Environment.Generating standard and customized reports using BEx Query Designer and BEx Analyzer to test the Dashboard.Worked on performance improvement of the dashboard, implemented parallel query process by usingprocessing group, background processing and load in data source in script.Tested the memory allocation for data sources in BW session by using SM04 transaction code.Improved the performance of the when use the dimension filter as target source, by using the set filter andsefilterExt property of the data source.

Analysed the exiting environment objects to move to new environment of BO.

· Created the approach document for migrating objects using promotion management and prepared to be moved objects list with universes and connections.

· Migrated all the objects to new environment of BO Dev and create the new connections to connect HANA and assigned those connections to related universes and published.

· Validate all migrated reports like Webi and Xcelsius Dashboards with source environment BO production system and fixed the issues.

· Worked on BODS jobs to move to new environment which were used for data loading to HANA tables.

· Imported required BODS jobs into production as “atl” file and changed the connection details and CSV files path as well.

· Created POCs for dashboard in Design Studio and Lumira.

· Designing the all dashboards layouts and getting sign off from client before start development.

· Closely worked with client at on-shore on design and changes to get more clarification on requirement and finish deliverables in time.

· Design and Developed new lading page with animations using the CSS to represent the organization structure on the Dashboard in Design Studio.

Client Tasnee/Cristal, Saudi ArabiaEnvironment Design Studio 1.6 SP2/Webi/ Dashboards(Xcelsius) - 4.1/ SAP BI 7.3/SAP HANA /LumiraDuration June 2016– Dec2016Role SAP BOBJ ConsultantTasnee/Cristal Saudi private sectors first fully owned joint stock industrial company, with the aim of advancing theeconomic diversification in Saudi Arabia. Driven by best business practices and the goal of achieving profitable andsustainable growth for its stakeholders and society at large, it is today Saudi Arabias second largest industrial companyand one of the worlds largest producers of titanium dioxide. It has a wide range of interests in petrochemicals,chemicals, plastics, and metals manufacturing, industrial services and environmental technologies. Itis a revamp projectfor one environment and another environment and designing and developing new Dashboards for the KPIs in DesignStudio.Responsibilities:Analysed the exiting environment objects to move to new environment of BO.Created the approach document for migrating objects using promotion management and prepared to bemoved objects list with universes and connections.Migrated all the objects to new environment of BO Dev and create the new connections to connect HANA andassigned those connections to related universes and published.Validate all migrated reports like Webi and Xcelsius Dashboards with source environment BO productionsystem and fixed the issues.Worked on BODS jobs to move to new environment which were used for data loading to HANA tables.Imported required BODS jobs into production as atl file and changed the connection details and CSV files pathas well.Created POCs for dashboard in Design Studio and Lumira.Designing the all dashboards layouts and getting sign off from client before start development.Closely worked with client at on-shore on design and changes to get more clarification on requirement andfinish deliverables in time.Design and Developed new lading page with animations using the CSS to represent the organization structureon the Dashboard in Design Studio.Design and Developed new navigation pages for the 7 business units for all related KPI Dashboards.Design and Developed Data visualization KPI Dashboards like Finance, Manufacturing and Procurement.Implemented more CSS script and CSS class for dynamic assignments to have good look and feel andvisualization on dashboard.Worked on performance areas like images loading, data source assignment for components, reusability of thescript using global functions.Implemented the navigation functionality from landing page to navigation page and navigation page toDashboards.Worked on Design studio components and technical global functions.Trained the users to get them familiar to Business Objects in order to help them run the system on their own

Client Centrica, UK/NLEnvironment SAP BO Dashboard 4.1/Webi/SAP BI 7.3/SAP BO Design Studio 1.6Duration Feb 2016– May2016Centricas Energy Marketing & Trading (EM&T) business operates in UK and European energy markets, trading in energyproduced both inside and outside the business. The business is the trading arm of Centrica, trading gas, power andrelated commodities, and provides the route to market for our upstream and power generation operations. This projectis used to show their KPIs performance at high level for the last 12 months from the current month with using variouscomponent on dashboard.Responsibilities:Analysing the Client Requirements and preparing the Dashboard functional specification and design document.Worked on modification and creation Bexqueries for the dashboard requirements.Developed Webi reports to navigate through dashboard for details reports.Involved in data connectivity for adding query through BICS connection.Worked on the Performance tuning of the Dashboard.Worked on Designing the Dashboard according to colour style guide given by clientWorked on Conducted Unit Testing of the DashboardWorked on the Development of Sample Dashboards to incorporate in the product.Developed Report Mock-up samples before User interaction to analyze the business requirements.Used various component in dashboard designing like query prompt selector, scorecard, staked column chart,combo box,list builder, toggle button and URL by applying their properties (dynamic visibility, appearance andbehaviour)Implemented excel formulas in the dashboard embed excelsheet for manipulating the data based on thedashboard component requirement.Created Design, functional and Technical documents in details for the dashboard to understand easily step bystep to client IT Team.

Client The Walt Disney, USEnvironment SAP BO Analysis 2.1 SP2/BEx Analyzer/SAP BI 7.3Duration July2015 to Jan2016Role SAP BO ConsultantThe client is one of the worlds leading producers and providers of entertainment and information. Using the portfolio ofbrands to differentiate content, services and consumer products, it seeks to develop the most creative, innovative andprofitable entertainment experiences and related products in the world.Responsibilities:Based on the assigned BEx workbooks, downloading from the available share point path.Refresh the workbooks in the BEx application by selecting available variants or giving manual inputs for theprompts and saved in the BI server favourite folder.Find out the no of data providers and workbook is protected or not in the BEx application.Maintain the status updating on share point like Work in progress, UAT, User input requiredConvert the BEx workbook into SAP BO analysis by using Convert to BEx workbook option on the Analysis Tab.Change the data provider from BI connection to BICS (OLAP) connection to complete the conversion process.After changing the data provider applying the options and properties on analysis according to original BExworkbooks like key and text, hierarchy, sorting, scaling factor, currency conversion.Before migrating to Analysis change the settings to get conversion log and show technical names.Used VBA code for running macros to implement automationRun the macro to get all the crosstabs properties like dynamic filters static filters and no of data source of theworkbooks on the separate sheet as Metasheet.In the process of conversion by running macro, it applies the rows, columns and background filters to get thecross tab structure including data.Applied SAP functions like SAPGetVariable, SAPGetSourceInfo, SAPGetDimensionStaticFilter to show the filtersand variables of the particular cross tab on top of the sheet.Once the conversion is completed, testing the analysis workbook with the BEx workbook.After completion of testing, upload the workbook on share point and changed the status to UAT for reportowner testingCompleting the weekly individual target assignment whether it is different priority and complexity.

Client Rabo Bank, NetherlandEnvironment SAP BO Dashboard 2008/Design Studio 1.4 SP2/SAP HANA/SAP BI 7.3/SAP BO 4.0Duration Nov 2014– June2015Role SAP BO Dashboard ConsultantRabo bank group is an international financial services provider with cooperative principles. We offer products andservices in the area of banking, capital management, leasing, insurance and real estate. To analysis, businessmanagement and service improvement they are maintaining the management information for you (MI4U) project withthe help of dashboards and reports using with this dashboard applications design studio latest version. In design studioapplications used various technologies like BW on top of HANA as data source, CSS for applying styles, customized SDKcomponents in eclipse with design studio configuration.Responsibilities:Changes made in trigger events in the Xcelsius as per the formula requirement in embed spreadsheet.Added new score card component for debug version of cockpit (dashboard).Added new hyperlink label and formula in embedded excel for navigating theShare point linked documents.Changes made in triggering mechanism as per the master data for the populating the Tabs under thegraphs.Used most of the components like URL button, Toggle button, scorecard, Tabs, Radio buttons, Imageloader and others.Designed SAP BO Design studio reports using with default components like cross tab, panel, list box,combo, buttons and charts on BW top of HANA.Implemented global functions by using Button components on click event.Created global and local variables for implementing script logic easily.Involved in redesign cockpit (dashboard) to SAP Design studio.Migrated some reports from WAD reports to design studio and design studio reports itself migratedfor the applying the new look & feel with CSS as per the client style guide team requirement.Created& maintained separated CSS files in MIME repository for writing CSS class and script andapplied those CSS files into design studio applications.Implemented dynamic functionality for main and sub header text in the design studio.Involved version updating from the 1.2 to 1.3 sp2 and 1.3 sp2 to 1.4 sp2 on sand box testing andbugs fixing.Involved in BW queries creation and modification as per the requirement for the data source andcreated multiple data source with the queries to meet report requirements.Created BW transports on top of HANA and moved up to system testing for UAT.Involved SDK components creation in eclipse using the JQuery, D3, CSS and configure into Designstudio.