SUMMARY:

• 9 + years of experience in Information Technology industry.
• 8+ years of SAP BW/BI implementation, SAP HANA, SAP Business Objects (BO), which includes 4 full life cycle implementation and Production support.
• Expertise experience with requirement gathering from business groups and Design owners, Business blue prints (Gap Analysis, Identifying reports), Realization (Design & Development of BI Objects) and Post production Support.
• Strong in HANA data modeling and having extensive experience on modeler perspective of HANA Studio. HANA migration and Extraction with data provisioning techniques like SLT (SAP Landscape Transformation), ETL (BODS) for SAP and non - SAP data.
• Expertise in developing reporting solutions using SAP BOBJ Toolset (Design Studio, WebI, Lumira 2.x, Analysis for office, OLAP, Crystal), Tableau.
• Implemented Analytics cloud reporting and Digital Board room.
• Expertise in SAP BW 7.x, ECC 6.x, BOBJ 3.x, 4.x, SAP HANA SPS (7-12).
• Expertise in technical upgrades for different versions of BW/BO/HANA.
• Expertise in SAP ECC functional area reporting moving data to application layer, including FICO, COPA, PM, TM, MM, SD, HR and others.
• Expertise in developing integrated, cross-functional, strategic and operational analytical solutions.
• Expertise and expert knowledge level on integrating Business Objects (BOBJ) - SAP BI /HANA Integration.
• Good knowledge and Trained in HANA dynamic tiering concepts.
• Expertise in vanilla BI/BW to BI/BW/BOBJ migration approaches.
• Extensively worked with SAP on newer versions of SAP Tools for validation as part of ramp up customer’s team.
• Worked with IBM team supply data to IBM SPSS tool from SAP HANA for creating predictive models, which are used, in the predictive analytics.
• Experience in designing and development of Tableau visualizations using Tableau Desktop and Tableau Server in various versions of Tableau 9.x/10.x for the business users.

TECHNICAL SKILL:

ERP: SAP ECC 6.0, R/3 4.6 C/4.6 B

SAP BW: SAP BI/BW 3.5, 7.0, 7.3, 7.4 (HANA), 7.5

SAP HANA: HANA 1.0 SPS6-10, HANA 2.0 SP2

Reporting Tools: Design Studio 1.x, Lumira 2.x, WebI, Analysis for office, AOLAP, Tableau

Languages: ABAP/4, C, C++ and VB

AREAS OF EXPERTISE:

SAP HANA Data Modeling:

• Extensively worked in SLT configuration, replication of ECC Data using SLT, table enhancements from SAP, Non-SAP sources with SLT \HANA Modeling Best practices.
• Extensive experience in Creating Catalog Objects.
• Expertise in Creating HANA Artifacts (Attribute /Analytical / Calculation Views) with complex business use case.
• Experience in using views from Multiple container Systems (MDC)
• Expertise in optimizing Views to reduce latency, memory consumption and enhance performance.
• Participated in the HANA sizing effort.
• Experience in using HANA Smart Data Access (SDA) / SDI data transfers.
• Knowledge on CDS views.
• Expertise in version upgrades and strategy development for Pre/Post activities.
• Experience in designing security model using Analytical Privileges.

SAP Business Objects Reporting:

• Expertise in HANA Reporting layer and Connectivity options to various SAP BO tools (Design Studio, WebI, Lumira 2.x, Analysis for office, Crystal reporting).
• Expertise in developing and implementing Analytics could reporting, Digital boardroom connecting S/4 HANA.
• Extensively expertise in designing the Dashboards and BO reports based on the customers’ business use case.
• Expertise in implementing BO Landscape, sizing, SSO Authentication and user groups
• Expertise developing BO reports and Dashboards connecting SAP sources via OLAP/Http connections and Non-SAP (SQL/HIVE) via universe.
• Expertise in developing complex CSS scripting to format the components in design studio.
• Expertise in defining folder security and Leveraging Data level security in BO environment.
• Expertise in upgrading BO versions, server sizing, User groups and system landscaping / configurations.
• Experience in designing rich graphic visualizations with modular design of reports, worksheets and views in BO Tools/ Tableau with a strong understanding of the appropriate chart types including Bar charts, Line charts, scatter plot, Dual Axes charts, Histograms, Filled map, Bubble chart, Tree map, Whisker Plot, Stacked Bar, geographical maps, bullet charts, Heat Maps to use to highlight patterns etc.

SAP BW on HANA modeling:

• Expertise in building BE objects in Eclipse Modeler
• Expertise in Data extraction and Data flow within SAP BW 7.4
• Expertise in New Data source and info provider concept of BW 7.4
• Extensive experience in BW Modeling- Info Cube & DSO design, 7.0, 7.3 and 7.4 Info Sources, Info Object Maintenance, Hierarchies, Multi providers, Info Packages, Transformations, DTPs, Update and Transfer rules.
• Expertise in developing BW info object based on SAP HANA Models, reporting on BW queries.
• Expertise in developing hybrid model of data flow with composite provider in eclipse modeler
• Worked on BEx Reports providing insight of Business Intelligence as Decision making tool for Business Analyst using Formulas, Selections, Structures, Conditions, Exceptions, Filters, Free Characteristics, Restricted Key Figures and Calculated KFs.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Worked across all the business lines Chemicals/Downstream/Upstream/HR/Procurement for different business use cases, extreme experience in client facing from different geographical regions.
• Experience is budgeting, estimating, and resource allocation, executions of projects with a project plan, post production validation and support.
• Successfully delivered 18 projects which includes modeling/upgrades/ incubation projects
• Good experience in handling multiple projects in parallel, Portfolio Management with Onsite/Offshore project execution.
• Conduct and lead regular meetings with SAP to review the status of critical issues and very high priority OSS message.
• Incubated multiple new versions of BW/BO tools
• Developed and Designed Data flows for HANA Modeling’s and Data provisioning (SLT, BODS).
• Used different data provisioning technics to fulfill requirement based on the frequency of data triggers and volume of data using SLT and BODS.
• Having Strong Knowledge on SAP HANA Data Modeling using Attribute views, Analytic Views and Calculation Views (both Graphical & SQL script based)
• Worked as a member of a large BI assessment team
• Experience in importing data from flat file to HANA data base Tables.
• Participated in pain point, GAP Analysis of the current BW environment
• Recommended best fit HANA scenario, based on fit analysis
• Created Technical specifications and Logical modeling documents for HANA.
• Migrated HANA content (Packages, Information Models) from development, testing environment to production environment using delivery Units.
• Identified several plausible HANA mix and match implementation scenarios, involving HANA Enterprise, BW on HANA, HANA Live, HANA Sidecar
• Successfully designed and developed the whole data model like Attribute views, Analytical views and Calculation views in SAP HANA and Analytics Could reporting for Purchase order data like invoice, goods receipt and purchase order values, quantities and dates for in-depth analysis of purchasing data at purchase order item and scheduling level
• Implemented security model in HANA to restrict Data Level security using Analytical Privilege.
• Debug ABAP Programs, Business Intelligence data models, business warehouse transformations, Data store objects (DSO), Info cubes, Multiproviders, Infosets and convert existing BW logic into Hana Models.
• Extracted Sales Order Header, Sales Order Item, Billing, Delivery, Purchase and Finance data from SAP to SAP Hana by Data provisioning using SLT and created attribute views, analytical views and calculation views and joined the relationship to meet the business requirement and analyzed using Bex analyzer and created report.
• Worked on the HANA revision upgrades.
• Developed a unique solution to BO reporting on SAP BW/HANA systems and non-SAP system, using Data Federator
• As a Member of SAP Implementation team, worked on the Analysis/Design/Development of the system by interacting both at managerial and user level, understanding their requirements and Test Data preparation for the Promo Effectiveness Project.
• Guideline the best practices for all the BO reporting tools, which can be used for all the projects.
• Highly experienced in creating Design Studio dashboards, WebI, Analysis for office reports using BW BEx queries and SAP HANA Views.
• Upgraded BO platform from 3.x to 4.1 Sp5, 4.1SP5 to 4.2SP2, 4.2SP2 to 4.2SP5.
• Designed a global template for Design studio and layered it on the server for everyone across the company to use the global template.
• Created a global template for Analysis for Office for the users to create any ad-hoc reports, Key SME for analysis for office.
• Worked extensively with SAP to enhance Analysis for office with key strategies by business needs in upcoming versions.
• Trained the users and other members to understand the work flow process, self-service tools, system landscape and current design.
• Procedures for promoting BOBJ objects using Life Cycle Manager (LCM) using re-usable job templates.
• Created user profiles for all the business users and mapped them to the right groups and created folders in BI Launchpad along with the right access levels for the developers and business users.
• Played a key role in regression testing for Design Studio 1.6, AO 2.x and Lumira 2.x as part of customer specific ramp up with SAP.
• Excellent expertise in developing complex design studio dashboards using complex java script coding and formatting using Cascading Style Sheets, Used Geo-maps in dashboards
• Configured BI 4.0 environment with SAP and Windows authentications.
• Expertise in Creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tabsets, Canvas Containers.
• Experience in creating Custom SDK Components like Gauges, Geo Maps etc as extensions for Design Studio.
• Developed storyboards from the requirements gathered from the business users using SAP Lumira and SAP design Studio.
• Worked with User interface experts at SAP labs to refine the storyboards created in the requirement gathering sessions and created user friendly and pixel perfect storyboards.
• Wrote and used complex CSS scripting to format the components in design studio. CSS Scripts used on the components in CSS Class and CSS Style sections.
• Designed WebI reports with Complex Calculations to get Alerts for Xcelsius Dashboards
• Used Alerts, Filters, Breaks, Sorting, Ranking and Prompts to customize reports based on user requirements.
• Created Open Doc links in Design Studio Dashboard to open other Design studio dashboards or WebI reports and pass parameters using Global URL Parameters.
• Developed multiple WebI reports using the Universe as a source for SQL database.
• Developed an extended approach for BW Data modeling / Data flow design and Loading data (SAP.Non-SAP):
• Procedure for optimizing back-end BW model, and BEx queries to support optimization of corresponding BOBJ Universe, WebI, Crystal, Xcelsius reports
• Worked on FI, SD, PP, CRM-BW integration projects and involved in the major financial reconciliation project between data posted in GL against the EIP system. Involved in project design, development and unit testing and providing KT sessions to the team after completion.
• Worked extensively on Administrative Workbench (RSA1) and customized different InfoCubes, Transfer rules, Update rules, Routines etc., according to the client requirements.
• Created Cubes, ODS and Multi Providers for the Sales and Distribution, Material Management Reporting.
• Prepared LIS extractor in Sales and Distribution by creating information structures and thus generating data source and configuring for Initial, Delta and Full updates.
• Customized Business Content extractors in LO customizing cockpit and also took necessary steps in converting LIS to LO data extraction.
• Extensively worked on Web Reporting, BEx Analyzer for designing the reports on Sales, Deliveries, Shipment, Purchasing, and Inventory using Conditions, Exceptions, and Variables & Structures.
• Used BEx Analyzer for enhanced the already created queries. I created Calculated Key Figures, Restricted Key Figures and Variables in the existing queries.
• Created a BW report on Sales Analysis Enquiries and a report on Daily Bookings and Shipments using company code.
• Created reports on general quotation information at sales area level, Material availability analytics back orders and Incoming orders per Calendar year and month.
• Created a new workbook to identify discrepancies between the material values as per the purchase order and the materials invoiced based on plant, vendor, and material for various periods.
• Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing reports based on various roles.
• Worked on BEx Query Designer and built queries using Restricted Key Figures (RKF’s), Calculated Key Figures (CKF’s), Free Characteristics, Structures, Variables, Formulas, Navigational Attributes, Filters, Conditions, and Exceptions to meet the business requirements
• Procedures for broadcasting reports, previously handled by information broadcaster
• Improved performance for reporting by partitioning of Info Cube and compressing Data in Info Cube
• Procedures for performance and tuning, including factors such as back-end BW MDX, size of BOBJ micro-cube, scheduling reports, BEx report settings.

Confidential

SAP BW/HANA Strategy Developer

Responsibilities:

• Experience in Full Lifecycle HANA Implementation in Native Hana (HANA Studio) and BW on HANA Implementation.
• Worked on SAP HANA Data Modeling using Attribute views, Analytic Views and Calculation Views
• Native HANA MODELLING - Designing Views (Attribute View, Analytic View, and Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script.
• Worked on HANA with Business Objects reporting tools like Dashboard, WEBI Crystal Reports etc.
• Good Exposure on Schemas, table definitions, attributes, table definitions, Attributes, Measures & Hierarchies in HANA.
• Experience on HANA Integration with IDT and UDT Semantic Layers.
• Having Good Experience in data provisioning method SLT and Maintained real time data replication from ECC to HANA.
• Worked on Different types of Transformation in BODS Like Query, Merge case, Key generation and Pivot Transformations Etc.
• Migrated HANA content (Packages, Information Models) from development, testing environment to production environment using delivery Units.
• Good Knowledge in SAP HANA security including user Management, Roles and Privileges.
• Sound Knowledge on Decision table, Mass Copy, Migrate, Auto Documentation, delivery units, Data Provisioning, Import and Export.
• Interacting with the onsite team/Client to understand the functionality with respect to the developments.
• Worked on extracting data from R/3 using LO and Generic Extractions.
• Involved in installing Business Content Objects as per the Business requirement, end to end design and construction of Info Objects, Data Sources, Info Cubes, DSOs and Multi-Providers to suit the Business requirements.
• Designed and modified Transformations, Info Packages and DTP's.
• Worked on BEx Reports providing insight of Business Intelligence as Decision making tool for Business Analyst using Formulas, Selections, Structures, Conditions, Exceptions, Filters, Free Characteristics, Restricted Key Figures and Calculated KFs.
• Hands on experience using Characteristic, Text and Formula Variables using different Processing types.
• Created various Process Chains to automate the data loads from different source systems.
• Analyzed Query performance to optimizations as per theory and practical observations. Performance Tuning by using Indexing, Partitioning, Aggregates and Compressions.
• Involved in transportation of BI objects across the landscape and analyzing the transport failures.

Confidential

SAP BW Reporting Developer

Responsibilities:

• Interacted with business users and gather the design specs for dashboards.
• Designed a dashboard for Lead / Target analysis where the target data is obtained from Non- SAP sources.
• Created detailed Crystal Reports using Formulas, Parameters and Grouping functionality.
• Gathered the requirements from business users and did the gap analysis.
• Involved in extracting SD, FI-CO and CO-PA data from SAP R/3 to SAP BI.
• Enhanced the data sources for FI-AR, FI-AP and extracted the data into BI.
• Used extractors from Logistics cockpit for Sales Order Header (2LIS 11 VAHDR), Item Level (2LIS 11 VAITM) & Billing (2LIS 13 VTIT)
• Designed and developed the CO-PA data sources and involved in extracting the actuals data from CO-PA into BI.
• Developed DSO, Info cubes for the actuals data from CO-PA.
• Created Multiproviders to include the actual data from COPA and planned data from IP.
• Designed and created complex queries using user-exit variables.
• Created Process Chains for daily delta loads for cleanup operations of PSA.
• Created partitioning, aggregates, and indexes as performance tuning measures.
• Transported the objects from Dev to Quality and Dev to Production using Transport Organizer.

Confidential

SAP BW Analyst

Responsibilities:

• Developed BI/BW SD Reporting application
• Designed and configured SD-Sales and SD-Billing based information model, involving calculation of billings, bookings, current, and scheduled backlog
• Enhanced standard extractors, and developed generic extractors
• Designed BEx queries to be used exclusively in Business Objects.