SUMMARY

• 10 years of meticulous experience as a technical consultant in SAP BOBJ, BW indulging in development, testing, trouble shooting and documentation of applications.
• 4+ years of experience in Native HANA modelling with different types of views like Calculation views, Analytical views and attribute views, SQL Views.
• Designed and developed various aspects of HANA modelling including creating schemas and importing source system metadata, creating attributes, measures and developing Information Models with Attribute Views, Analytical Views and Calculation Views.
• Created SQL Script Calculation Views and Procedures to model complex business logics of SAP Standard Data Sources and Z Data Sources.
• Experience using SDI, SDA in HANA to model the views involving more than 1 data source.
• Experience in using HANA Planviz to analyze the dataflow and performance optimize the models/queries
• Experience in creating XS jobs in HANA to schedule the HANA views to load the data in custom tables for maintaining the data snapshots
• Experience in using BW perspective in HANA Studio to create composite providers and BEx queries on top of it to utilize the hierarchy feature from BW
• Extensive experience in SAP Design Studio for creating fluid dashboards with rich User experience using SAP HANA and BW as datasource.
• Extensive experience in Business Objects 4.x Web Intelligence, Dashboard Designer, Analysis for Excel, Analysis for OLAP, Design Studio, Explorer, Workspaces, BICS, BIWS,QAAWS, Live Office, Infoview, Import Wizard, Promotion Management using CTS+.
• Created Universes on top of HANA calculation views and developed the WebI reports and dashboards using IDT (Information design tool).
• Experience in creating Mobile compatible dashboards using Dashboard Designer/Designstudio/WebI.
• Extensive experience in Creating BO Xcelsius dashboards and KPI’s to large - scale multi layered reports.
• Experience in Tableau creating static and self-service capable dashboards enhancing the user adoption on reports and dashboards
• Experience in creating Tableau dashboards, Lumira Dashboards over SAP HANA models with and without universes
• Experience in the BOBJ upgrade from 3.x to 4.0 and from 4.0 SP02 to 4.0 SP04 Patch 5 to 4.1 SP02.
• Designed and created Info Objects, Info Cubes, ODS/DSO Objects, Info Sets, Multiproviders, Datasource, Infosources, Process Chains, Transfer Rules, Update Rules, transformations, data transfer process, BEx Query Designer, BEx Analyzer, Views and Work Books.
• Expertise in BEx Analyzer, Query Designer, Web Application Designer, Info-Set queries. Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures. Experience on Data Modeling, Data staging & involved in creation of info sets, remote cubes and Multi providers.

TECHNICAL SKILLS

Operating Systems: Windows NT, 2000, Win XP and HP-Unix

Data Ware Housing Tools: SAP BI 7.0 in Nw2004’s, BW 3.5 and 3.1C.

ERP: SAP R/3 4.6C, 4.7 E and ECC 6.0 and ABAP/4.

Databases: SAP HANA, SQl and MS-Access

Reporting Tools: Business Explorer, BEx Browser, Business Objects and Web Application Designer, Dashboard Designer and WebI.

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA Architect/Visualization Lead

Environment: SAP HANA, Hadoop, Lumira

Responsibilities:

• Interfaced with business users to prepare and update Business Process Requirements (BPR). Determined user/business/functional requirements. Created scope, and use case documents; business process models, process flow diagrams and
• Used SAP Power designer to capture all business requirements and design ideal implementation plans using a drag-and-drop interface
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements
• Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
• Developed the following HANA Data Models: Attribute Views for master data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Calculation Views for report consumption with time dimensions.
• Created the star schema modelling architecture in HANA by incorporating the master data views to enable the reusability of the HANA models
• Involved in creation of HANA views to support multi-dimensional reporting by joining Fact table data foundation to modeled dimensions attribute views, selected attributes and measures.
• Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data.
• Defined the architecture for data modelling in HANA. Created base views, logical views and business views to enhance the reusability of HANA views
• Worked extensively on data modelling design in SAP HANA like creating custom tables, Base table views, product views, business views, global views
• Worked on understanding hierarchies in ECC and moving the related tables to HANA and build Custom hierarchies in HANA
• Used SAP BODS to map the data structure between ECC and HANA Database. Created tables in SAP HANA, extracted data from ECC and loaded into HANA
• Created SAP Lumira reports and story boards using HANA business views (both HANA Online and HANA download connections)
• Used SAP Lumira for acquiring data from multiple sources for data blending and for deeper analysis and insight
• Identified the key metrics from the requirements and created a dashboard using SAP Lumira for SAP SD and Logistics business units. This empowers the analysts and business users to produce new insights and quicker decision making capabilities
• Created dashboard templates in SAP Lumira for different business modules like SAP SD, MM and FI. Created the dashboard standards document

Confidential

SAP HANA/Dashboard Architect

Environment: SAP HANA, SAP - BO 4.1

Responsibilities:

• Gathered requirements from the business users for the daily operations dashboard
• Analyse the requirements, created the prototype of the dashboard and conducted the demo using SAP design studio
• Design, Develop and unit test the dashboard as per the requirements with SAP HANA model and BW query as the backend data source
• Designed and developed the HANA model using HANA Calculation view and SDA for data federation of the virtual data
• Created calculated measures and input parameters in HANA model to filter the data and optimize the query performance and in turn the dashboard performance
• Converted the existing analytic views into table functions as per the standards provided by SAP while upgrading the system
• Collected the HANA objects and transported using HTA and export import process
• Worked on schema mapping and error handling while transporting the HANA objects
• Downloaded and installed the 3rd party extensions for SAP Design studio to meet the business requirements
• Edited and customized the 3rd party extensions by overwriting the styling properties using Javascript and Eclipse editor
• Customized and invoked the dynamic properties in the dashboard using JavaScript coding
• Enhanced the individual components of the dashboard and also the dashboard using CSS scripting to match the corporate color code and design
• Worked on the performance enhancement of the dashboard by changing the filters, parallel processing of the queries and splitting the queries
• Experience in gathering the requirements from business users/analysts and developing a prototype for the user sign off before actual development
• Created dashboards using Design studio with HANA, SAP BW as a data source.
• Experience in training the end users getting used to a dashboard or while transitioning from other dashboarding tool
• Experience in customizing the components by overwriting the styling properties and setup as a template across the company for all the business units.
• Created a global dashboard with multiple tabs for multiple KPIs across different business units.
• Experience in creating custom style sheets using CSS for enhanced user experience across multiple displays.
• Worked with the different methods in the design studio like Setfilter, Setitems, Getmemberlist, setSelectedValue etc.
• Worked with variety of components in SAP Design studio like chart types, filters, containers, tabs checkboxes, radiobuttons etc.
• Experience with installing 3rd party custom components using SDK in Design studio like Crosstab, Export to PPT.
• Installed the 3rd party extensions using SDK in Design studio like Dials, Date Functions, angular gauges and modified them as per the requirements
• Worked on creating cascading filters, triggering events, linking the components in Design studio.
• Created fluid and interactive dashboards on HANA models using SAP Design Studio. Also created custom style sheets in CSS and used them in design studio for global templates

Confidential

SAP HANA Consultant

Environment: SAP HANA (S4), SAP - BO 4.1

Responsibilities:

• Interacted with business stake holders in order to understand their structured and ad-hoc reporting requirements, User stories, business rules for finance, sales and marketing domains.
• Understanding end to end scenarios while gathering the requirements and analyzing the report output.
• End to End implementation experience in HANA modelling, transporting, report development and upgrade.
• Architecting the dataflow, designed the technical document and developed the HANA model as per the business requirements.
• Created the star schema modelling architecture by incorporating the master data views to enable the reusability of the HANA models
• Experience in using the new SFIN tables like ACDOCA for most of the HANA Reports in the Finance area offsetting the traditional FI, CO, Leger tables usage.
• Worked with standard HANA content for Ledger reports, DSO Reports and DIR Reports. Experience in utilizing standard Value help views for the LOVs in the HANA based views.
• Created HANA transports collection and import process using HANA Transport for ABAP (HTA) and Solution Manager
• Activated the HANA Live content and enhanced the standard content according to the business requirements
• Utilized the HANA Visualize Plan (Planviz) to optimize the HANA Queries by analyzing the record flow in the data model thus achieving better reporting performance.
• Created cross module reports (HR and FI, ECC and SCM) on HANA Views using SDA (Smart Data Access) feature of HANA
• Worked on collecting the statistics of virtual HANA model built using SDA and optimized the performance of model
• Experience in collecting the runtime statistics using the tables m cs tables, m cs columns and optimize the Hana models built on virtual tables using SDA
• Created complex reports like DSO(Days Sales Outstanding) and DIR (Days Invoice Ratio) using HANA and WebI
• Working with cross client architecture and with cross system landscape (HANA, HFM, SQL Server) to support the multiple phases of the project
• Creating the POC’s before initializing the development cycle and made sure the expectations are reached before signing off on the requirements
• Experience working with Information Design Tool (IDT). Used to create HANA information models on the calculation views, to create multi source universe, to create LOVs.
• Created adhoc reports to users in Tableau by connecting various data sources like HANA and SQL Server for IDM reporting and HANA Audit Reporting on Adhoc basis.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated tableau dashboards with combination charts for clear understanding.
• Development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Created Heat Map showing the DSO by color that were broken into regions allowing business user to better analyze the higher DSO vs Low DSO values
• Extensive experience in creating dashboards using Dashboard Designer aka Xcelsius, Design studio, Explorer and Lumira
• Expert level experience in creating WebI reports on top of SAP BW source, HANA and other relational data sources
• Created many storyboards using SAP Lumira and deployed them on Mobile platform. Also, involved in installing the Lumira Add on to the SAP BI Launch Pad.
• Expert level experience in utilizing the functionalities of Web Intelligence like merging different datasources, Grouping, Ranking, creating drilldown reports, hyperlinks, simple dashboards.
• Expert level experience in creating WebI reports and connecting them to SAP ECC for further transactional detailed reports.
• Experience in creating BI Workspaces from multiple reports and dashboards from different tools of BI Suite. This workspace is launched as the home page for the users.
• Experience in creating dashboards using Tableau on top of SAP HANA views.
• Experience in converting the business requirements into technical specs and assigning the tasks to the developers.
• Experience in creating calculation views and converting the existing ABAP reports to HANA models and building WebI reports on the HANA model (Eg: Ledger Comparison Report, Invoice AR reports)
• Experience in creating the incidents, OSS messages with SAP regarding the issues with the tool/application
• Experience in creating reusable information views using SQL, thus tuning the query performance of the Calculation view.
• Experience creating the Analytical views for the Master data and also analytical views for the LOVs to be used in the calculation views.
• Experience in creating Variables and Input parameters in the Hana calculation views and assigning master/transaction data tables for the LOVs.
• Experience in creating transports using HTA (HANA Transports for ABAP) and Promotion Management.
• Experience in utilizing the Solution Manager to maintain the documentation and for better defect tracking and creating Tasks and Transport of copies.
• Created training material and conducted training sessions to the business users explaining the new functionalities available with the new reporting tools

Confidential

SAP BI Consultant/Dashboard Architect

Environment: SAP-BO 4.1

Responsibilities:

• Understood the business and gathered the requirements from the business and functional users.
• Redesigned the existing complex dashboard (non-functional) into simple and functional dashboards.
• Working directly with business users in understanding their requirements and providing the POC with mock up data to explain the functionality.
• Conducting training sessions for the users about using new tools and explaining the functionality.
• Building ad-hoc reports with Analysis, which helps users in building their own sub analysis reports by adding a focussed analysis and filters.
• Designed the .UNX Universes for the various reports in the BOBJ Explorer.
• Created Audit database Universe for BOBJ on MS SQL server using IDT. This universe is used for all the audit reports on BOBJ.
• Used Query Builder in BOBJ CMC to create queries on the Business Objects Repository for detailed events.
• Created BI Workspaces in the BI Launch pad to create a dashboard from different WebI components.
• Created universes on BW cubes using IDT that is used in different reporting tools like WebI, Explorer and Xcelsius.
• Created user training documents and trained end users in SAP Business Objects
• Used different components in the design studio like Radio buttons, Cross tabs, Charts, List box, Combo boxes, dropdowns and image components etc. and created dashboards for the different business units.
• Experience in scripting the CSS scripts to define the custom properties for the components in the design studio as per the requirements.
• Experience in converting existing Webi/Xcelsius dashboards to design studio and deploy them on SAP BI launch pad.
• Customized the components by overwriting the styling properties and setup as a template across the company for all the business units.
• Worked with the different methods in the design studio like Setfilter, Setitems, Getmemberlist, setSelectedValue etc.
• Created visualizations and storyboards for the different Sales and Billing units by using the new generation charts like 3D charts and Trellis options in the column charts.
• Created POC for Finance team using the Universe Data set exporting it to SAP Lumira Server.
• Created a Multi-source universe in IDT over a SAP BW multiproviders and this universe are exposed to multiple users thus reducing the number of BEx queries.
• Tested and compared different functionalities between Universe and BEx connectivity in Lumira.

Confidential

SAP BOBJ Lead/Dashboard Architect

Environment: SAP-BI, BO 4.0/4.1, HANA

Responsibilities:

• Worked with the business users in gathering the project specifications by conducting user requirements gathering sessions and workshops.
• Analysed the requirements and technical specifications by partnering with Business analysts to develop the reports that conform to the enterprise standards.
• Expert level experience in designing, developing and implementing dashboards using Dashboard Designer/Design Studio.
• Experience in working with different components of Xcelsius like Charts, Labels, scorecards, buttons, selectors, containers, text components.
• Experience in developing simple,complex, static and dynamic dashboards using Xcelsius, with multiple tabs and multiple components.
• Created dashboards for Marketplaces finance and MP HR teams with Xcelsius, and also Design Studio using CSS.
• Used different components in the design studio like Radio buttons, Cross tabs, Charts, comboboxes etc.
• Experience in scripting the CSS scripts to define the custom properties for the components in the design studio as per the requirements.
• Experience in passing parameters between dashboards in the Design studio for drill down purposes.
• Experience in creating cascading filters, triggering events, linking the components in Design studio.
• Upgraded the BOBJ from 4.0 SP04 patch 05 to 4.1 SP2 in order to provide one of the best feature to the users - mobile compatibility for the Dashboards.
• Expert level experience in creating dashboards using Dashboard Designer/Xcelsius.
• Extensive experience using the components in the dashboard like, crosstab, scorecard, charts, combo box, alerts, radiobuttons and so on…
• Created Xcelsius Dashboards using HTML5 for Mobile compatibility, Information spaces in Explorer for Adhoc analysis.
• Created dashboards with drill down feature to the more detailed WebI report.
• Worked with the Query Designer feature in the Dashboard Designer/Xcelsius to connect to BEx queries directly and UNX universe to populate data for dashboards which enhances the dashboards performance
• Created workspaces with multiple dashboards and WebI reports and used HTML code to list the reports as per the requirement.
• Created POC using Tableau for the financial dashboards for the Marketplaces team. Used different components like filters, dropdowns and graphs for the dashboard.
• Created many Dashboards using the new mode of connection - BICS (Business Intelligence Consumer Services), BIWS, QAAWS. Also used multiple connections in a single dashboard for better performance in the dashboards.
• Assisted in the implementation of HANA database (BW on HANA) and its integration with the Business Objects 4.0.
• Established the best modelling and recommended strategies for BOBJ environment on BW over HANA.
• Developed the test scripts and report validation documents for the BOBJ reports/dashboards during the HANA upgrade.
• Involved in conducting strategic evaluation (Proof of Concepts) of the use of Business Objects 4.0 with BW on HANA.
• Created Design Documents and report validation documents based on the validation policy of the organization.
• Assisted in installing and configuring SAP BOBJ 4.0 SP2, SP04 and 4.1 SP02 and generated reports using WebI and Advanced Analysis.
• Worked closely with SAP in creating OSS messages and resolving the issues with the reports/dashboards migration during BOBJ and HANA Upgrade.
• Designed .UNV Universes and connections for various reports like WebI, Analysis and Dashboards.
• Designed the .UNX Universes for the various reports in the BOBJ Explorer.
• Created Mobile dashboards from WebI, Dashboard Designer, Explorer and Design Studio. Compared the performance and the user experience from different tools on Mobile platform.
• Extensive experience in creating complex formulas, Cascading prompts, Merge Dimensions, Query stripping and scheduling reports to Users.
• Created many reports using AAE (Advanced Analysis for Excel) which are further used in WebI for better user experience.
• Created many APD’s to send data from the BW system to the SQL system for further analysis using web Methods.
• Created many BEx queries that are needed for the reporting purposes.
• Created transformations using ABAP to get the text data and hierarchies for the APDs.
• Created user training documents and trained end users in SAP Business Objects, Workspace and building adhoc reports with Analysis which helps users in building their own queries, adding filters, generating reports, drilling down reports, creating charts performing business essential tasks
• Created BEx queries for the Dashboards and created many RKFs and CKFs as per the requirement.

Confidential

SAP BOBJ Lead/Dashboard Architect

Environment: SAP-BO 4.0

Responsibilities:

• Understood the business and gathered the requirements from the business and functional users.
• Redesigned the existing complex dashboard (non-functional) into simple and functional dashboards.
• Developed the High level design for Corporate Dashboard COR using the mockup data.
• Designed 3 different project plans for COR with different timelines and number of resources using MS Project.
• Extensive experience in linking multiple dashboards using Content Linking in the BI Launch Pad.
• Experience in working with Flash Variables in passing the multiple parameters (more than 10) between Dashboards and also between WebI and Dashboard.
• Extensive working experience with different components of Dashboard Designer like Charts, Selectors, Text, Maps and Containers.
• Developed multi layered graphs in order to show more than 4 indicators in a single graph.
• Experience in using different connections like LIVEOFFICE, QAAWS, BI Web Services and Query Browser to access the data depending on the requirement.
• Developed Web Intelligence reports using BW BICS Connections with Hierarchical data, RDBMS Connections with Multiple Query’s.
• (.UNV) as well (.UNX). Defined various OLAP connections in SAP BICS connectivity.
• Directly used SAP BEx queries to build a WebI documents. Worked with Legacy Universes
• Responsible for Creating/Enhancing BOBJ Universes using BW BEx Query’s, retrieving data from Universes and Creating Complex, Multi-dimensional and Ad-Hoc reports according to client's requirements using, Web Intelligence (WEBI).
• Experience in using IDT (Information Design Tool) used to design the Universe on more than one relational database. Also created queries using IDT.
• Extensive experience with WebI in creating queries and reports that further used in the Dashboard Designer.
• Created WebI reports on relational Database that helps in ranking purposes.
• Developed Interactive reports and dashboards using Xcelcius and WebI reports.
• Experience in using Download Doc and Open doc in order to connect the dashboards in the BI Launch pad.
• Created crosstab data in WebI and developed the WEB Services for the WebI report that can be directly used in the Dashboard Designer.
• Sound knowledge over Dashboard Designer components.

Confidential

SAP BI/BO Consultant

Environment: SAP-BI 7.0, ECC 6.0, ABAP/4, SD, MM, FI-CO,BOBJ 3.x

Responsibilities:

• Good experience in creating Universes over the BEx queries using Universe Designer.
• Created many Variables and Prompts in BOBJ according to the end user requirements.
• Worked in developing many Report Level filters during the reconciliation process in BOBJ.
• Extensive experience in working with data synchronization options like Merge Dimensions, Extended Merge Dimensions in BOBJ to fetch data from two universes.
• Extensive experience working with Infoview in creating and maintaining the WEBI reports.
• Created many dashboards using Live Office and QAAWS in the Xcelsius.
• Created Web I reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Extensively Worked in SAP Live Office to create connections between WEB I and Xcelsius Dashboards.
• Sound Knowledge over SAP QAAWS used in mapping data directly from Universe to Xcelsius Dashboards.

Confidential, WI

SAP Senior BI/BO Consultant

Environment: SAP-BI 7.0, ECC 6.0, ABAP/4, SD, MM, FI-CO, APO, BOBJ 3.x

Responsibilities:

• Created Universes over BEx queries and Info cubes of SAP BI using Universe Designer.
• Extensively worked in INFOVIEW to create Web Intelligence, Desk Intelligence Reports over the Universe Created
• Worked on WebI reports to get Alerts for Xcelsius Dashboards, created variables and prompts in webI
• Extensively Worked in SAP Live Office to create connections between WEB I and Xcelsius Dashboards
• SAP QAAWS used in mapping data directly from Universe to Xcelsius Dashboards
• Sound Knowledge over Xcelsius Dashboard Components.

Confidential, Chicago, IL

SAP Senior BI Consultant

Environment: SAP-BI 7.0, ECC 6.0, ABAP/4, SD, MM, FI-CO, HR and CRM, BOBJ

Responsibilities:

• Created MultiProviders and Infoset Queries for Cross-Functional Reporting for FI-AR & Sales, FI-AP and Purchasing.
• Built the custom extractors and enhanced the business content data sources on CRM and built the ODS (0CRM PROI and 0CRM RUOI) objects.
• Using Bex Broadcaster, distributed the customized reports by region and exported to the Enterprise portal.
• Worked on different Cubes like 0CRM PRI, 0CSRV C01 ODS objects like 0CRM PROI, 0CRM RUOI and Datasources 0CRM SRV PROCESS H, 0CRM SRV PROCESS I.
• Designed and developed CRM ERMS statistics detailed custom queries for business reporting on SLA.
• Designed and configured Category summary report to identify number of tickets created for each CRM category combination for business reporting.
• Improved performance by creating Aggregates, Compressions, Partitions and Indexes.
• Maintaining Reconciliation’s to verify the data in SAP R3 with SAP BW. Extensively checked the missing values in the BW reports in the R/3 transaction and table’s level.
• Created various summarized reports on Cost, Revenue, Service Orders, Stock Usage, Ship & Bill for Profitability Analysis based on variances of Actual vs Plan data.
• Created Universes over BEx queries, Info cubes and Multiproviders of SAP BI using Universe Designer.
• Developed a “Summary Executive Metric Dashboard” using different WEBI reports according to the business requirements.
• Extensive experience in using different functionalities of XCELSIUS like Charts, Gauges, Combo boxes, Containers, Maps and developed many dashboards with different combinations of the available properties.
• Extensively Worked in SAP Live Office to create connections between WEB I and Xcelsius Dashboards.

Confidential

SAP BI Developer

Environment: SAP-BI7.0, ECC6.0, SD, MM, FI/CO, QM, Business Objects XIr2 and WebI Reports.

Responsibilities:

• Designed and developed multiple BW infocubes and multi-providers to analyze Service Process, Activities, leads and opportunities.
• Worked on business content Installation of Info objects, Data sources, Info Sources, and Data Targets as per the business requirements.
• Created and Maintained Info Cubes using RSA1(T-Code), Data Store Objects, Info Objects, Multi Providers, Info Sources, Data Sources, Transformations, Data transfer Process and Info Packages.
• Extracted Data specific to the client from General Ledgers - 0FIGL C01 and 0FIGL C02 to SAP BI System.
• Worked on Remote Cubes to support real time data. Extracting required data from the Data Source of PSA to ODS
• Developed SAP BI Reports using Bex Analyzer and query design Position.
• Used Formulas, Selections, Structures, variables, Calculated Key Figure (CKF), and Restricted Key Figure (RKF). Created Aggregates, Compressions, Indexes, Multi Cubes and parallel setups to improve the query performance.